3、多csv宽表联合整理成csv大宽表

目录

1、导入包

2、导入文件路径

知识点：

---

1、导入包

import numpy as np
import pandas as pd
import os

2、导入文件路径

lujing="C:/Users/S/Desktop/不同数据集U_RATIO(BP)/3CleanData--csv整理宽表"
lujing1="C:/Users/S/Desktop/不同数据集U_RATIO(BP)/3CleanData--csv整理宽表/2.csv"

df1=pd.read_csv(lujing1,encoding='utf8')
df1

3、用merge()函数整合

for root,dirs,files in os.walk(lujing):
    for file in files:
        #print(file)
        if file != '2.csv':
            path = os.path.join(root,file)
            df=pd.read_csv(path,encoding='utf8')
            df1=df1.merge(df,on=['LOT','WAFER','U_RATIO'],how='inner')
            #print(df2)
df1.to_csv("C:/Users/S/Desktop/不同数据集U_RATIO(BP)/大宽表.csv",index=False,encoding = 'utf_8_sig')

知识点：

df2=df1.merge(df,on=['LOT','WAFER','U_RATIO'],how='inner')

把df1和df按照['LOT','WAFER','U_RATIO']进行合并