Python Pandas : Append不返回所需的值

Question

我有两个数据帧，当我使用追加概念时，同样没有返回所需的结果。

firstDF = pd.DataFrame({'mac':[1,3],'location':[['kitchen', 'kitchen', 'kitchen', 'kitchen', 'kitchen'],['conference']]})
predictedDF = pd.DataFrame({'mac':[2],'location':[['lab']]})

if predictedDF['mac'].isin(firstDF['mac']).any():
    pass
else:

    firstDF.append(predictedDF,ignore_index=True)

相同的返回结果为，

      mac                                       location
 0    1    [kitchen, kitchen, kitchen, kitchen, kitchen]
 1    3                                     [conference]

而我应该得到的结果是，

 mac                                       location
 0    1    [kitchen, kitchen, kitchen, kitchen, kitchen]
 1    3                                     [conference]
 2    2                                            [lab]

Answer 1

您需要返回赋值，因为使用DataFrame.append，而不是python append

if predictedDF['mac'].isin(firstDF['mac']).any():
    pass
else:

    firstDF = firstDF.append(predictedDF,ignore_index=True)

print (firstDF)
   mac                                       location
0    1  [kitchen, kitchen, kitchen, kitchen, kitchen]
1    3                                   [conference]
2    2                                          [lab]