国赛C题代码结果.py

#!/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