I have this DataFrame :
df = pd.DataFrame({'1-sensor':['608', '608', '2158', '2158'],
'2-day':['2017-12-11', '2017-12-12', '2017-12-11', '2017-12-12'],
'3-voltage':[30, 31, 28, 29]})
df :
1-sensor 2-day 3-voltage
0 608 2017-12-11 30
1 608 2017-12-12 31
2 2158 2017-12-11 28
3 2158 2017-12-12 29
我希望您能将其改造为这样:
pd.DataFrame({'1-sensor':['608', '2158'],
'2017-12-11':[30, 28],
'2017-12-12':[31, 29]})
df :
1-sensor 2017-12-11 2017-12-12
0 608 30 31
1 2158 28 29
我尝试了不同的解决方案,结合
.groupby('sensor')
和 .unstack()
但是没有成功。有什么好的建议吗?谢谢!