在数据框中查找某一行，并将另一数据框中的值输入到特定列中

Question

我有两个数据帧。我目前有下面的代码，但我现在知道如何在dataframe 2中搜索客户ID，将数量放入相应的product列中

Dataframe 1 (INPUT DF): 
CustomerID Product Quantity
123        Ball    2
123        Leash   2
456        Ball    1

Dataframe 2 (OUTPUT DF):
CustomerID Ball Leash
123        0    0
456        0    0     

我希望他们看起来像这样

Dataframe 1 (INPUT):
CustomerID Product Quantity
123        Ball    2
123        Leash   2
456        Ball    1

Dataframe 2 (OUTPUT):
CustomerID Ball Leash
123        2    2
456        1    0

如果我需要进一步解释，请告诉我

### Adding how many for each customer
for index, row in df2.iterrows():
   ID = row["Customer_ID"]
   Product = row["Product_Name"]
   Quantity = row["Quantity"]
   df.loc[df.index[df[ID]], Product] = Quantity

Answer 1

我想你在找df.pivot。从熊猫文档：

Reshape data (produce a “pivot” table) based on column values. Uses unique values from specified index / columns to form axes of the resulting DataFrame. This function does not support data aggregation, multiple values will result in a MultiIndex in the columns. See the User Guide for more on reshaping.

在案例中使用pivot会在索引中生成CustomerID，在列中生成Product：

In [4]: df.pivot('CustomerID', 'Product', 'Quantity')                                                                                                                                                     
Out[4]: 
Product     Ball  Leash
CustomerID             
123          2.0    2.0
456          1.0    NaN

然后可以使用^{}在剩余的单元格中获取0