直接上测试数据,其他的代码,大家还是要自己敲,才能真正对打击提升理解力有帮助
import pandas as pd
test_dict = {'id':['A','A','A','A','B','B'],
'name':['a','b','b','a','c','c'],
'math':[90,89,99,78,97,93],
'english':[89,94,80,94,94,90]}
#[1].直接写入参数test_dict
test_dict_df = pd.DataFrame(test_dict)
#[2].字典型赋值
test_dict_df = pd.DataFrame(data=test_dict)
形式1:
df.groupby(‘key1’)[‘data1’] = df.groupby(‘key1’).data1
df.groupby(‘key1’)[[‘data1’]
形式2:
df[‘data1’].groupby(df[‘key1’])
df[[‘data1’]].groupby(df[‘key1’])