/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

3 votes153 views1 answer
Maping value to data in pandas dataframe
Python
0 vote169 views1 answer
Python remove \xa0
Python
0 vote159 views4 answers
How to open a dataset in netcdf4
Python
1 vote140 views3 answers
List of prime numbers in python
Python
5 votes144 views1 answer
Check is lowercase
Python
0 vote154 views1 answer
Unpacking using List in Python
Python
4 votes198 views2 answers
Arrayfield django example
Python Django
1 vote106 views1 answer
Typeerror: list indices must be integers or slices, not str
Python
1 vote180 views1 answer
Django don't redirect on submission
Python Django
0 vote144 views1 answer
Open url from ipywidgets
Python