python合并多个csv文件并去重

时间:2017-06-22 11:52:03   收藏:0   阅读:2044
#coding=utf-8
import os
import pandas as pd
import glob

def hebing():
    csv_list = glob.glob(*.csv)
    print(u共发现%s个CSV文件% len(csv_list))
    print(u正在处理............)
    for i in csv_list:
        fr = open(i,r).read()
        with open(haha.csv,a) as f:
            f.write(fr)
    print(u合并完毕!)

def quchong(file):
    df = pd.read_csv(file,header=0)
    datalist = df.drop_duplicates()
    datalist.to_csv(file)

if __name__ == __main__:
    hebing()
    quchong("haha.csv")

 

原文:http://www.cnblogs.com/zhangtianyuan/p/7064054.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!