python - 使用另一个数据框中的查找值填充一个熊猫数据框中的 3 列

Question

我有两个数据框，df_source 和 df_dest，如下所示：

>>> df_source = pd.read_csv('Product_Lookup.csv')
>>> df_source
   ProdCode    ProdName        ProdUPC  ProdQty
0       131       Apple  1100034030045        1
1       320   Bookshelf  2222200209090        1
2       420  Comic Book  4449435895489        5
3       511   Drillbits  5558493958393       10
4        55        Eggs  6660001110005       20
5        12   Fish food  9099910002776       50

>>> df_dest = pd.read_csv('Product_Dest.csv')
>>> df_dest
  CustName  ProdCode  ProdName  ProdUPC  ProdQty
0     Fred        12       nan      nan      nan
1   Sanjay       131       nan      nan      nan
2     Rita       55        nan      nan      nan
3    Steph       511       nan      nan      nan
4   Hannah        55       nan      nan      nan
5    Roger       131       nan      nan      nan

对于在查找函数中处理多列人口的熊猫，我还没有在这里看到一个问题。

我正在尝试df_dest.loc[:,['ProdName','ProdUPC','ProdQty']]通过匹配来df_dest['ProdCode']填充df_source['ProdCode'].

我可以做到这一点iterrows()，但希望更快，更优雅。任何帮助都非常感谢！

标签： pythonpandasnumpydataframe