加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 编程开发 > Python > 正文

Python将大的csv文件拆分多个小的csv文件

发布时间:2020-12-20 10:46:40 所属栏目:Python 来源:网络整理
导读:#ecoding=utf- 8 import osimport time# 2019 / 9 / 8 将大的csv文件拆分多个小的csv文件def mkSubFile(lines,head,srcName,sub): [des_filename,extname] = os.path.splitext(srcName) filename = des_filename + ‘ _ ‘ + str(sub) + extname print( ‘ m
#ecoding=utf-8
import os
import time
# 2019/9/8 将大的csv文件拆分多个小的csv文件

def mkSubFile(lines,head,srcName,sub):
    [des_filename,extname] = os.path.splitext(srcName)
    filename = des_filename + _ + str(sub) + extname
    print(make file: %s % filename)
    fout = open(filename,w)
    try:
        fout.writelines([head])
        fout.writelines(lines)
        return sub + 1
    finally:
        fout.close()


def splitByLineCount(filename,count):
    fin = open(filename,encoding="utf-8")
    try:
        head = fin.readline()
        buf = []
        sub = 1
        for line in fin:
            buf.append(line)
            if len(buf) == count:
                sub = mkSubFile(buf,filename,sub)
                buf = []
        if len(buf) != 0:
            sub = mkSubFile(buf,sub)
    finally:
        fin.close()


if __name__ == __main__:
    begin = time.time()
    splitByLineCount(training-inspur.csv,1000)#每个小的csv文件存放1000条
    end = time.time()
    print(time is %d seconds  % (end - begin))

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读