pythonsql语句

最新推荐文章于 2024-07-12 20:31:59 发布

zn505119020

最新推荐文章于 2024-07-12 20:31:59 发布

阅读量744

点赞数

分类专栏：工作相关

本文链接：https://blog.csdn.net/zn505119020/article/details/74586771

版权

工作相关专栏收录该内容

136 篇文章 0 订阅

订阅专栏

import pandas

def load(ic_path, ic_sales_path):
    ic_df = pandas.DataFrame(
        pandas.read_csv(ic_path, encoding="gbk", keep_default_na=True))
    del ic_df["goods_name"]
    del ic_df["item_specific"]
    ic_sales_df = pandas.DataFrame(
        pandas.read_csv(ic_sales_path, encoding="gbk", keep_default_na=True))
    del ic_sales_df["product_name"]
    sale_df = pandas.merge(ic_df, ic_sales_df , on="product_sku")
    sale_df = sale_df.drop_duplicates(['product_sku'])
    return sale_df

def left_load(ic_path, ic_sales_path):
    ic_df = pandas.DataFrame(
        pandas.read_csv(ic_path, encoding="gbk", keep_default_na=True))
    del ic_df["goods_name"]
    del ic_df["item_specific"]
    ic_sales_df = pandas.DataFrame(
        pandas.read_csv(ic_sales_path, encoding="gbk", keep_default_na=True))
    del ic_sales_df["product_name"]
    sale_df = pandas.merge(ic_df, ic_sales_df,  on="product_sku", how='left')
    sale_df = sale_df.drop_duplicates(['product_sku'])
    return sale_df

if __name__ == '__main__':
    # sale_df = load("ic.csv", "ic_sales.csv")
    # sale_df.to_csv('sum.csv')
    sale_df = left_load("ic.csv", "ic_sales.csv")
    sale_df.to_csv('left_sum.csv')