使用以下 Pandas DataFrame:>>> df = pd.DataFrame({"id":[1,2,1,2],"name":['a','b','a','c'],"val_1":[1,2,3,4],"val_2":[5,6,7,8]})>>> df id name val_1 val_20 1 a 1 51 2 b 2 62 1 a 3 73 2 c 4 8我按 id 和 name 對數(shù)據(jù)框進(jìn)行分組,因此我可以一次遍歷每個組數(shù)據(jù):>>> grp = df.groupby(['id','name'])<pandas.core.groupby.groupby.DataFrameGroupBy object at 0x103334c88>現(xiàn)在我正在遍歷每個組的行并將其打印出來:>>> for name,group in grp:... for row,data in group.iterrows():... print(data)... id 1name aval_1 1val_2 5Name: 0, dtype: objectid 1name aval_1 2val_2 6Name: 1, dtype: objectid 2name bval_1 3val_2 7Name: 2, dtype: objectid 2name cval_1 4val_2 8Name: 3, dtype: object我想得到的行是: id name val_1 val_20 1 a 1 5 id name val_1 val_21 1 a 2 6 id name val_1 val_22 2 b 3 7 id name val_1 val_23 2 c 4 8我怎樣才能做到這一點?
添加回答
舉報
0/150
提交
取消