<p>创建带有月份编号的tempoary数据框:</p>
<pre><code>df2 = pd.DataFrame(range(1, 13), columns=["MONTH"])
</code></pre>
<p>并填写以下列:</p>
<pre><code>cols = ["SKU_ID" , "SUPPLIER", "YEAR" , "UOM"]
for col in cols:
df2[col] = df[col][0]
</code></pre>
<p>并在<code>MONTH</code>上将旧数据帧合并到它</p>
<pre><code>df2.merge(df, how="left", on="MONTH")
</code></pre>
<p>输出:</p>
<pre><code> MONTH SKU_ID_x SUPPLIER_x YEAR_x UOM_x SKU_ID_y | SUPPLIER_y |.1 YEAR_y |.2 |.3 UOM_y |.4 VOLUME |.5 COST
0 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
1 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
2 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
3 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
4 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
5 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
6 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
7 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
8 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
9 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
10 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
11 2 SKU_123a Supplier_8 2020 Case SKU_123a | Supplier_8 | 2020 | | Case | 12 | $101.36
</code></pre>