python将csv转化为excel_使用Python 3将大型CSV文件转换为Excel

this is my code covert CSV file to .xlsx file, for small size CSV file this code is working fine, but when I tried for larger size CSV files, Its shows an error.

import os

import glob

import csv

from xlsxwriter.workbook import Workbook

for csvfile in glob.glob(os.path.join('.', 'file.csv')):

workbook = Workbook(csvfile[:-4] + '.xlsx')

worksheet = workbook.add_worksheet()

with open(csvfile, 'r', encoding='utf8') as f:

reader = csv.reader(f)

for r, row in enumerate(reader):

for c, col in enumerate(row):

worksheet.write(r, c, col)

workbook.close()

the error is

File "CsvToExcel.py", line 12, in

for r, row in enumerate(reader):

_csv.Error: field larger than field limit (131072)

Exception ignored in:

>

Traceback (most recent call last):

File "/usr/local/lib/python3.5/dist-packages/xlsxwriter/workbook.py", line

153, in __del__

Exception: Exception caught in workbook destructor. Explicit close() may be

required for workbook.

解决方案

I found Out New Code with panda package, this code is working fine now

import pandas

data = pandas.read_csv('Documents_2/AdvMedcsv.csv')

data = data.groupby(lambda x: data['research_id'][x]).first()

writer = pandas.ExcelWriter('Documents_2/AdvMed.xlsx',engine='xlsxwriter')data.to_excel(writer)

writer.save()