#!/usr/bin/env python
# coding: utf-8
# In[1]:
import pandas as pd
# Load the provided files
attachment_1 = pd.read_excel(r"C:\Users\86136\Desktop\C题(1)\附件1.xlsx")
attachment_2 = pd.read_excel(r"C:\Users\86136\Desktop\C题(1)\附件2.xlsx")
# Display the first few rows of each dataset for a preliminary inspection
attachment_1.head(), attachment_2.head()
# In[2]:
# Merge the datasets on "单品编码"
merged_data = pd.merge(attachment_2, attachment_1, on="单品编码", how="left")
# Display the first few rows
