Python Pandas 合并 Excel 文件：示例代码和步骤

import\u0020pandas\u0020as\u0020pd\n\ndata1\u0020=\u0020pd.read_excel(r"C:\Users\asus\Desktop\附件1.xlsx")\nprint(data1)\n\ndata2\u0020=\u0020pd.read_excel(r'C:\Users\asus\Desktop\附件2.xlsx')\nprint(data2)\n\nall_data\u0020=\u0020pd.merge(data1,\u0020data2,\u0020on='单品编码',\u0020how='left')\nprint(all_data)\n\nall_data.to_excel(r"D:\spyder文件\数学建模.xlsx")