我肯定这是张贴在某处,或这么简单,我没有看到它,但我没有运气找到一个张贴。任何帮助都是大有裨益的。你知道吗
我想做一个分组方式差异如你所见。如果缺少日期,我需要显示负值。你知道吗
df['delta'] = df.groupby(['ID', 'ticker', 'date'])['shares'].diff()
ID ticker date shares delta
A AAA 3/31/2012 904180 675010
A AAA 12/31/2011 229170 NaN
A BBB 3/31/2012 517756 390117
A BBB 12/31/2011 127639 NaN
A CCC 12/31/2011 1757 NaN
A DDD 12/31/2011 500 NaN
B AAA 3/31/2012 920920 554920
B AAA 12/31/2011 366000 NaN
B BBB 3/31/2012 524 393
B BBB 12/31/2011 131 NaN
我想我需要填充才能得到这个:
ID ticker date shares delta
A AAA 3/31/2012 904180 675010
A AAA 12/31/2011 229170 NaN
A BBB 3/31/2012 517756 390117
A BBB 12/31/2011 127639 NaN
A CCC 3/31/2012 0 -1757
A CCC 12/31/2011 1757 NaN
A DDD 3/31/2012 0 -500
A DDD 12/31/2011 500 NaN
B AAA 3/31/2012 920920 554920
B AAA 12/31/2011 366000 NaN
B BBB 3/31/2012 524 393
B BBB 12/31/2011 131 NaN
再次感谢
使用
unstack
+stack
排序后
相关问题 更多 >
编程相关推荐