/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

10 votes246 views4 answers
Pandas find column with max value for each row
Python
0 vote268 views1 answer
Freqtrade - Informative Pairs
Python
0 vote268 views1 answer
How to change bit in integer in python
Python
0 vote271 views1 answer
"'S3' object has no attribute 'Bucket'", python boto3 aws
Python
16 votes304 views5 answers
Logistic regression python
Python
1 vote263 views1 answer
Time date in pandas to csv file
Python
78 votes252 views4 answers
Read json
Python
2 votes281 views3 answers
Get binary string python
Python
2 votes256 views6 answers
How to setup Turtle python
Python
0 vote241 views1 answer
Pandas make new dataframe
Python