I need to fill the data in one xlsx file to another xlsm file using Python xlwings, Pandas, numpy ... I am new to Python
Solution 1:
Is this what you wanted?
df_final = pd.merge(df1, df2[["Item no", "Amount"]], on="Item no", how="left")
df_final["Jan"] = df_final["Amount"]
df_final.drop("Amount", axis=1, inplace=True)
Output:
Item no Item Name Jan
0 10 aaa 1000
1 20 bbb 2000
2 30 ccc 3000