要遍历Pandas分组并创建数据框,可以按照以下步骤进行操作:
import pandas as pd
data = {
'Group': ['A', 'A', 'B', 'B', 'C', 'C'],
'Value': [1, 2, 3, 4, 5, 6]
}
df = pd.DataFrame(data)
groupby
方法将数据框分组:groups = df.groupby('Group')
result = pd.DataFrame(columns=['Group', 'Sum'])
for name, group in groups:
group_sum = group['Value'].sum()
result = result.append({'Group': name, 'Sum': group_sum}, ignore_index=True)
print(result)
完整的代码示例如下:
import pandas as pd
data = {
'Group': ['A', 'A', 'B', 'B', 'C', 'C'],
'Value': [1, 2, 3, 4, 5, 6]
}
df = pd.DataFrame(data)
groups = df.groupby('Group')
result = pd.DataFrame(columns=['Group', 'Sum'])
for name, group in groups:
group_sum = group['Value'].sum()
result = result.append({'Group': name, 'Sum': group_sum}, ignore_index=True)
print(result)
运行以上代码,将得到按分组计算总和的结果数据框。