excel中有三张表,具体情况如下。
现在想把订单号 摊位ID SKU放入一个表中,如何放?
下面给出python代码
# -*- coding: utf-8 -*-
"""
Created on Thu Dec 3 11:19:52 2020
@author: Administrator
"""
#导入库
import pandas as pd
#导入三张表
A=pd.read_excel("D:\\测试样本3.xlsx",skiprows=1,usecols=[0,1],nrows=4)
B=pd.read_excel("D:\\测试样本3.xlsx",skiprows=1,usecols=[3,4],nrows=4)
C=pd.read_excel("D:\\测试样本3.xlsx",skiprows=1,usecols=[6,7],nrows=7)
A.columns=["订单号","摊位ID"]
B.columns=["订单号","SKU"]
C.columns=["摊位ID","SKU"]
#首先根据表C生成一个字典对象&#