/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

5 votes185 views1 answer
Google translate python
Python
0 vote237 views1 answer
Pylint no name in module opencv
Python
53 votes225 views6 answers
Python 2 decimal places format
Python
0 vote234 views1 answer
List generation for python
Python
0 vote223 views1 answer
Pandas extracting tables from pdf
Python
0 vote222 views1 answer
Display all resources in table pandas
Python
9 votes253 views4 answers
Pandas not in list
Python
11 votes235 views6 answers
Write list to csv python
Python
0 vote244 views1 answer
List Delete a Element
Python
47 votes266 views6 answers
Add rows to dataframe pandas
Python