我有以下数据库:
firm sic identifier name year X Y Z
1078 2834.0 002824100 ABBOTT LABORATORIES 2013 4.347826 5.217391 15.739130
1078 2834.0 002824100 ABBOTT LABORATORIES 2014 4.368421 6.263158 16.684211
112178 2836.0 00339B107 ABGENIX INC 2005 5.222222 3.111111 9.777778
112178 2836.0 00339B107 ABGENIX INC 2006 5.222222 4.111111 10.777778
178855 2836.0 00383Y102 ABRAXIS BIOSCIENCE INC 2007 4.000000 0.000000 13.544322
我的意图是为每个小组向后延长5年。Firm、sic、identifier和name列需要复制到新行。但是,X、Y和Z列将为NAN。你知道吗
预期结果:
firm sic identifier name year X Y Z
1078 2834.0 002824100 ABBOTT LABORATORIES 2008 NAN NAN NAN
1078 2834.0 002824100 ABBOTT LABORATORIES 2009 NAN NAN NAN
1078 2834.0 002824100 ABBOTT LABORATORIES 2010 NAN NAN NAN
1078 2834.0 002824100 ABBOTT LABORATORIES 2011 NAN NAN NAN
1078 2834.0 002824100 ABBOTT LABORATORIES 2012 NAN NAN NAN
1078 2834.0 002824100 ABBOTT LABORATORIES 2013 4.347826 5.217391 15.739130
1078 2834.0 002824100 ABBOTT LABORATORIES 2014 4.368421 6.263158 16.684211
112178 2836.0 00339B107 ABGENIX INC 2000 NAN NAN NAN
112178 2836.0 00339B107 ABGENIX INC 2001 NAN NAN NAN
112178 2836.0 00339B107 ABGENIX INC 2002 NAN NAN NAN
112178 2836.0 00339B107 ABGENIX INC 2003 NAN NAN NAN
112178 2836.0 00339B107 ABGENIX INC 2004 NAN NAN NAN
112178 2836.0 00339B107 ABGENIX INC 2005 4.454545 3.181818 11.000000
112178 2836.0 00339B107 ABGENIX INC 2006 4.222222 4.000000 13.555556
178855 2836.0 00383Y102 ABRAXIS BIOSCIENCE INC 2007 NAN NAN NAN
178855 2836.0 00383Y102 ABRAXIS BIOSCIENCE INC 2007 NAN NAN NAN
178855 2836.0 00383Y102 ABRAXIS BIOSCIENCE INC 2007 NAN NAN NAN
178855 2836.0 00383Y102 ABRAXIS BIOSCIENCE INC 2007 NAN NAN NAN
178855 2836.0 00383Y102 ABRAXIS BIOSCIENCE INC 2007 NAN NAN NAN
178855 2836.0 00383Y102 ABRAXIS BIOSCIENCE INC 2007 4.000000 0.000000 13.544322
如果您对如何在python中实现这一点有一些想法,请与我分享。你知道吗
提前谢谢。你知道吗
IIUC您可以使用
groupby
explode
和merge
如以下代码所示您可以将索引设置为年份值,并按特定日期范围对其重新编制索引。在这个例子中,我回顾了每一组的7年。你知道吗
在:
输出:
您可以使用
index.repeat
和merge
相关问题 更多 >
编程相关推荐