/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

8 votes334 views2 answers
Python float print 2 digits
Python
3 votes364 views2 answers
Django timezone india
Python Django
1 vote337 views1 answer
Python in line conditional statement
Python
-3 votes345 views3 answers
Pandas.duplicated
Python
35 votes346 views2 answers
Convert into date python
Python
0 vote343 views1 answer
Get data from s3 bucket python
Python
1 vote325 views1 answer
Numpy slice array into chunks
Python
0 vote460 views1 answer
How to see the functions of a library in python
Python
0 vote320 views2 answers
Numpy method to make polynomial model
Python
1 vote348 views2 answers
From sklearn.metrics import classification_report
Python