merge

来源:互联网 发布:mac怎么清理safari 编辑:程序博客网 时间:2024/05/21 13:58
import pandas as pddfl = pd.read_excel("window_regulator原始数据.xlsx",sheetname= "fb_title_sale_price")dfr = pd.read_excel("window_regulator原始数据.xlsx",sheetname="category总")print(len(dfl))print(len(dfr))df = pd.merge(dfl , dfr , how="left",on="ebayno")df.to_csv("title_category.csv" , index = False)

原创粉丝点击