我有一些数据
>>> df1
Col1 Col2
0 Hi Hello
1 How Fine
2 Why Because
3 You Me
4 We They
>>> df2
Col1 Col2
0 Mr Mrs
1 Welcome Bye
2 Wow Ohh
3 Sit Stand
我只想连接这两个数据帧的第一列Col1
,并更新df1
,保持Col2
不变,但我无法这样做
我试过很多方法,但都失败了
我想要的输出
>>> df2
Col1 Col2
0 Hi Hello
1 How Fine
2 Why Because
3 You Me
4 We They
5 Mr
6 Welcome
7 Wow
8 Sit
索引是否不同或是否有空单元格而不是NaN都无关紧要
我试过的东西
1
>>> r=pd.concat([df1["Col1"],df2["Col1"]])
>>> df1["Col1"] = r.reset_index(drop=True)
>>> df1
Col1 Col2
0 Hi Hello
1 How Fine
2 Why Because
3 You Me
4 We They
2
>>> pd.concat([df1["Col1"],df2])
0 Col1 Col2
0 Hi NaN NaN
1 How NaN NaN
2 Why NaN NaN
3 You NaN NaN
4 We NaN NaN
0 NaN Mr Mrs
1 NaN Welcome Bye
2 NaN Wow Ohh
3 NaN Sit Stand
3
I Tried append(), merge() and some more techniques but failed
append
concat
无论哪种情况,都可以传递
ignore_index=True
选项来忽略索引相关问题 更多 >
编程相关推荐