/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

0 vote197 views1 answer
Ler arquivo xls no pandas
Python
33 votes202 views3 answers
Add dataframe column to set
Python
9 votes183 views1 answer
Comment out a block in python
Python
0 vote187 views1 answer
Pandas plot heatmap
Python
23 votes174 views4 answers
Flatten a list of list python
Python
1 vote180 views2 answers
Update python 3.9
Python
0 vote213 views1 answer
WSGIPassAuthorization on
Python
1 vote202 views2 answers
Pyqt message box set detailed text
Python
2 votes200 views1 answer
Flask session timeout
Python
0 vote185 views1 answer
Reg.fit(x_train, y_train) TypeError: fit() missing 1 required positional argument: 'y'
Python