/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 vote304 views1 answer
Matplotlib convert color string to int
Python
2 votes341 views2 answers
Python list to string without brackets
Python
0 vote310 views1 answer
Django form is onvalid
Python Django
0 vote298 views1 answer
Visual code notebook importerror: keras requires tensorflow 2.2 or higher. install tensorflow via `pip install tensorflow`
Python
0 vote341 views1 answer
No package python37 available.
Python
0 vote361 views1 answer
Pandas: How to Drop Rows that Contain a Specific String
Python
0 vote317 views1 answer
Matlab index last element
Python
0 vote327 views1 answer
Reducing noise on Data
Python
0 vote314 views1 answer
Whitespace delimiter python
Python
71 votes325 views6 answers
Shuffle array python
Python