在一列的右边

Question

我试图把这个值放到列的右边

df1型

       EW  WE   DA  dd     AA
0  cheese   0  300   T      T
1  dwadaw   3  400  21  31232

测向2

       AD   FA      BA  DA    daw ddwad
0  dddddd    1     300   T      T     T
1  cheese    1     400  21  31232   NaN
2  chees   dwa  waddcv   3    NaN   NaN

期望值：

       AD   FA     
0  cheese    1     

我试着：

    df3 = df2[['AD', 'FA']].copy()
    df3.FA=np.where(df2.AD.isin(df1.EW),df3.FA,np.nan)
    print (df3)

我得到与df2中的AD和FA相同的输出

df3 = df2[df2.AD.isin(df1.EW)]给出：df3 = df2[df2.AD.isin(df1.EW)] cheese 1.0 300 T T

Answer 1

我想你需要：

df3 = df2[df2.AD.isin(df1.EW)]
df3 = df3[['AD','FA']]
print (df3)
       AD FA
1  cheese  1