假设我有这样一个数据帧:
import pandas as pd
df = pd.DataFrame({"a":["","DATE","01-01-2012"],
"b":["","ID",18],
"c":["CLASS A","GOLF",3],
"d":["","HOCKEY",4],
"e":["","BASEBALL",2],
"f":["CLASS B","GOLF",15],
"g":["","HOCKEY",2],
"h":["","BASEBALL",3]
})
Out[33]:
a b c d e f g h
0 CLASS A CLASS B
1 DATE ID GOLF HOCKEY BASEBALL GOLF HOCKEY BASEBALL
2 01-01-2012 18 3 4 2 15 2 3
我想将第一行的字符串添加到下面一行的运动名称中,但只能在下一节课开始之前添加.有人知道我怎么能做到这一点吗?
所以结果应该是这样的:
a b c ... f g h
0 CLASS A ... CLASS B
1 DATE ID CLASS A GOLF ... CLASS B GOLF CLASS B HOCKEY CLASS B BASEBALL
2 01-01-2012 18 3 ... 15 2 3
稍后我会将第1行作为我的标题名,但这部分我知道怎么做.我已经try 使用df.iterrow,但我对工作流程感到困惑.