/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

8 votes228 views1 answer
How to do collision detection in pygame
Python
1 vote254 views1 answer
Plot image without axes python
Python
1 vote228 views1 answer
Def dft(self, array): stack = Stack() visited = set() stack.append(self) while len(stack) > 0 and while len(visited) >= 0: current = stack.pop() array.append(current) visited.add(current) return array
Python
0 vote258 views1 answer
Access Google Photo API with Python using google-api-python-client
Python
5 votes267 views4 answers
Python generator function
Python
4 votes257 views1 answer
Pandas read_csv ignore first column
Python
0 vote252 views1 answer
Django optional path parameter
Python
0 vote247 views1 answer
Make blinking text python
Python
2 votes246 views2 answers
Merge two df
Python
12 votes236 views3 answers
Python for in for in
Python