我需要在此块下方精确地复制相同的行块 3 次。像下面的例子。
数据帧（df1）：-
S.No Cal Date DFM
1 8 01-03-2013 100.00%
1 7 01-06-2013 100.00%
1 6 01-09-2013 100.00%
1 5 01-12-2013 99.99%
1 4 01-03-2014 99.97%
1 3 01-06-2014 99.95%
1 2 01-09-2014 98.89%
1 1 01-12-2014 39.36%
1 0 01-03-2015 0.00%
1 0 01-06-2015 0.00%
1 0 01-09-2015 0.00%
1 0 01-12-2015 0.00%
2 8 01-03-2013 100.00%
2 7 01-06-2013 100.00%
2 6 01-09-2013 100.00%
2 5 01-12-2013 99.99%
2 4 01-03-2014 99.97%
2 3 01-06-2014 97.95%
2 2 01-09-2014 94.42%
2 1 01-12-2014 43.13%
2 0 01-03-2015 0.00%
2 0 01-06-2015 0.00%
2 0 01-09-2015 0.00%
2 0 01-12-2015 0.00%
3 8 01-03-2013 100.00%
3 7 01-06-2013 100.00%
3 6 01-09-2013 100.00%
3 5 01-12-2013 99.99%
3 4 01-03-2014 99.96%
3 3 01-06-2014 99.94%
3 2 01-09-2014 98.85%
3 1 01-12-2014 54.77%
3 0 01-03-2015 0.00%
3 0 01-06-2015 0.00%
3 0 01-09-2015 0.00%
3 0 01-12-2015 0.00%
结果：-
第一个数据帧：-
S.No Cal Date DFM
1 8 01-03-2013 100.00%
1 7 01-06-2013 100.00%
1 6 01-09-2013 100.00%
1 5 01-12-2013 99.99%
1 4 01-03-2014 99.97%
1 3 01-06-2014 99.95%
1 2 01-09-2014 98.89%
1 1 01-12-2014 39.36%
1 0 01-03-2015 0.00%
1 0 01-06-2015 0.00%
1 0 01-09-2015 0.00%
1 0 01-12-2015 0.00%
1 8 01-03-2013 100.00%
1 7 01-06-2013 100.00%
1 6 01-09-2013 100.00%
1 5 01-12-2013 99.99%
1 4 01-03-2014 99.97%
1 3 01-06-2014 99.95%
1 2 01-09-2014 98.89%
1 1 01-12-2014 39.36%
1 0 01-03-2015 0.00%
1 0 01-06-2015 0.00%
1 0 01-09-2015 0.00%
1 0 01-12-2015 0.00%
1 8 01-03-2013 100.00%
1 7 01-06-2013 100.00%
1 6 01-09-2013 100.00%
1 5 01-12-2013 99.99%
1 4 01-03-2014 99.97%
1 3 01-06-2014 99.95%
1 2 01-09-2014 98.89%
1 1 01-12-2014 39.36%
1 0 01-03-2015 0.00%
1 0 01-06-2015 0.00%
1 0 01-09-2015 0.00%
1 0 01-12-2015 0.00%
2 8 01-03-2013 100.00%
2 7 01-06-2013 100.00%
2 6 01-09-2013 100.00%
2 5 01-12-2013 99.99%
2 4 01-03-2014 99.97%
2 3 01-06-2014 97.95%
2 2 01-09-2014 94.42%
2 1 01-12-2014 43.13%
2 0 01-03-2015 0.00%
2 0 01-06-2015 0.00%
2 0 01-09-2015 0.00%
2 0 01-12-2015 0.00%
2 8 01-03-2013 100.00%
2 7 01-06-2013 100.00%
2 6 01-09-2013 100.00%
2 5 01-12-2013 99.99%
2 4 01-03-2014 99.97%
2 3 01-06-2014 97.95%
2 2 01-09-2014 94.42%
2 1 01-12-2014 43.13%
2 0 01-03-2015 0.00%
2 0 01-06-2015 0.00%
2 0 01-09-2015 0.00%
2 0 01-12-2015 0.00%
2 8 01-03-2013 100.00%
2 7 01-06-2013 100.00%
2 6 01-09-2013 100.00%
2 5 01-12-2013 99.99%
2 4 01-03-2014 99.97%
2 3 01-06-2014 97.95%
2 2 01-09-2014 94.42%
2 1 01-12-2014 43.13%
2 0 01-03-2015 0.00%
2 0 01-06-2015 0.00%
2 0 01-09-2015 0.00%
2 0 01-12-2015 0.00%
3 8 01-03-2013 100.00%
3 7 01-06-2013 100.00%
3 6 01-09-2013 100.00%
3 5 01-12-2013 99.99%
3 4 01-03-2014 99.96%
3 3 01-06-2014 99.94%
3 2 01-09-2014 98.85%
3 1 01-12-2014 54.77%
3 0 01-03-2015 0.00%
3 0 01-06-2015 0.00%
3 0 01-09-2015 0.00%
3 0 01-12-2015 0.00%
3 8 01-03-2013 100.00%
3 7 01-06-2013 100.00%
3 6 01-09-2013 100.00%
3 5 01-12-2013 99.99%
3 4 01-03-2014 99.96%
3 3 01-06-2014 99.94%
3 2 01-09-2014 98.85%
3 1 01-12-2014 54.77%
3 0 01-03-2015 0.00%
3 0 01-06-2015 0.00%
3 0 01-09-2015 0.00%
3 0 01-12-2015 0.00%
3 8 01-03-2013 100.00%
3 7 01-06-2013 100.00%
3 6 01-09-2013 100.00%
3 5 01-12-2013 99.99%
3 4 01-03-2014 99.96%
3 3 01-06-2014 99.94%
3 2 01-09-2014 98.85%
3 1 01-12-2014 54.77%
3 0 01-03-2015 0.00%
3 0 01-06-2015 0.00%
3 0 01-09-2015 0.00%
3 0 01-12-2015 0.00%
一种方法是分组"S.No"，然后返回一个连接的帧并在最后重置索引：
new_df = df.groupby("S.No").apply(lambda d: pd.concat([d]*3)).reset_index(drop=True)
要得到
>>> new_df
S.No Cal Date DFM
0 1 8 01-03-2013 100.00%
1 1 7 01-06-2013 100.00%
2 1 6 01-09-2013 100.00%
3 1 5 01-12-2013 99.99%
4 1 4 01-03-2014 99.97%
.. ... ... ... ...
103 3 1 01-12-2014 54.77%
104 3 0 01-03-2015 0.00%
105 3 0 01-06-2015 0.00%
106 3 0 01-09-2015 0.00%
107 3 0 01-12-2015 0.00%
[108 rows x 4 columns]
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句