我有以下格式的数据集
source adset date impression click spend
fb abc 1/1/19 100 140 20
fb abc 1/2/19 200 130 40
cl xyz 1/1/19 300 200 50
cl xyz 1/2/19 500 200 50如何使用pandas获取如下格式?
source adset kpi 1/1/19 1/2/19
fb abc impression 100 200
fb abc click 140 130
fb abc spend 20 40
cl abc impression 300 500
cl abc click 200 200
cl abc spend 50 50发布于 2019-12-06 15:28:35
你可以通过DataFrame.set_index,DataFrame.stack和Series.unstack来重塑
df1 = (df.set_index(['source','adset','date'])
.rename_axis('kpi', axis=1)
.stack()
.unstack(level=2)
.reset_index())
print (df1)
date source adset kpi 1/1/19 1/2/19
0 cl xyz impression 300 500
1 cl xyz click 200 200
2 cl xyz spend 50 50
3 fb abc impression 100 200
4 fb abc click 140 130
5 fb abc spend 20 40另一种使用DataFrame.melt和DataFrame.pivot_table的解决方案
df1 = (df.melt(['source','adset','date'], var_name='kpi')
.pivot_table(index=['source','adset', 'kpi'], columns='date', values='value')
.reset_index())
print (df1)
date source adset kpi 1/1/19 1/2/19
0 cl xyz click 200 200
1 cl xyz impression 300 500
2 cl xyz spend 50 50
3 fb abc click 140 130
4 fb abc impression 100 200
5 fb abc spend 20 40https://stackoverflow.com/questions/59208693
复制相似问题