/Python/Python get column from grouped dataframe

Python get column from grouped dataframe

# You can also reset_index() on your groupby result to get back a dataframe with the name column now accessible.

import pandas as pd
df = pd.DataFrame({"a":[1,1,3], "b":[4,5.5,6], "c":[7,8,9], "name":["hello","hello","foo"]})

df_grouped = df.groupby(["a", "name"]).median().reset_index() # Resetting the index makes the column accessible

df_grouped.name

 #Output:
 0    hello
 1      foo

Source: stackoverflow.com

Similar codes

222 votes483 views6 answers
Python random numbers
Python
1 vote280 views1 answer
Adding new column to existing DataFrame in Pandas by assigning a list
Python
1 vote266 views1 answer
Python previous answer
Python
0 vote301 views1 answer
How to get cube root python
Python
1 vote272 views1 answer
Backup django db from one database to another
Python
13 votes266 views4 answers
Pandas groupby count as new column
Python
9 votes290 views2 answers
How to run linux command in python
Python
12 votes255 views2 answers
Python sort array of dictionary by value
Python
33 votes270 views6 answers
Pip install matplotlib.pyplot
Python
0 vote252 views1 answer
Discord attachments
Python