我在将我的预测值合并到现有的数据帧时遇到了问题。我目前有2个数据帧,其中一个包含文件名和其他带有预测值的数据帧,并且两者的长度相同。然而,当我尝试合并或连接时,我得不到想要的输出。
数据帧1
filename
0 1gBZ9vG1.txt
1 4XztkgDw.txt
2 GfCk8XGZ.txt
3 gfHCMnJM.txt
4 GfLCd17y.txt
5 gFqruhps.txt
6 gfsZpRDu.txt
7 gfT1yDbz.txt
8 GfT9mkJL.txt
9 GFTbJDLn.txt
10 gFwh0Ekb.txt
11 GGB7680Q.txt
12 R7NkR2q2.txt
13 tK2Xmi4C.txt
数据帧2
predictedLabels
0 2
1 2
2 2
3 1
4 2
5 2
6 2
7 2
8 1
9 1
10 1
11 0
12 2
13 2
Output
filename predictedLabels
0 1gBZ9vG1.txt NaN
1 4XztkgDw.txt NaN
2 GfCk8XGZ.txt NaN
3 gfHCMnJM.txt NaN
4 GfLCd17y.txt NaN
5 gFqruhps.txt NaN
6 gfsZpRDu.txt NaN
7 gfT1yDbz.txt NaN
8 GfT9mkJL.txt NaN
9 GFTbJDLn.txt NaN
10 gFwh0Ekb.txt NaN
11 GGB7680Q.txt NaN
12 R7NkR2q2.txt NaN
13 tK2Xmi4C.txt NaN
0 NaN 2.0
1 NaN 2.0
2 NaN 2.0
3 NaN 1.0
4 NaN 2.0
5 NaN 2.0
6 NaN 2.0
7 NaN 2.0
8 NaN 1.0
9 NaN 1.0
10 NaN 1.0
11 NaN 0.0
12 NaN 2.0
13 NaN 2.0
我不确定为什么标签会出现在下面的NaN值下面,尽管它们具有相同的长度。我尝试合并和连接,也尝试重置我的索引,但它不起作用。
发布于 2020-06-22 19:04:44
试试看:
Dataframe1["predictedLabels"] = Dataframe2["predictedLabels"]
https://stackoverflow.com/questions/62512931
复制相似问题