/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 vote110 views1 answer
Saleor docker development
Python
0 vote105 views1 answer
Python last non-zero value in a list
Python
5 votes108 views1 answer
Tkinter minsize
Python
107 votes112 views6 answers
Python do while loop
Python
0 vote115 views1 answer
How to find out the max and min date on the basis of property id in pandas
Python
0 vote119 views1 answer
Python convert xml to dictionary
Python
3 votes119 views1 answer
Python get item from queue
Python
49 votes118 views2 answers
Add new element to python dictionary
Python
1 vote104 views1 answer
Convert pandas dataframe to numpy dataframe
Python
2 votes68 views1 answer
EnvironmentError command line
Python