python .txt文件转.csv
数据处理尝尝需要把数据集从.txt转到.csv格式,可以通过以下代码完成:import numpy as npimport pandas as pdimport csvout = open('/LF1big.csv','w',newline='')#要转成的.csv文件,先创建一个LF1big.csv文件csv_writer = csv.writer(out,dialect='excel')f =
·
数据处理尝尝需要把数据集从.txt转到.csv格式,可以通过以下代码完成:
import numpy as np
import pandas as pd
import csv
out = open('/LF1big.csv','w',newline='') #要转成的.csv文件,先创建一个LF1big.csv文件
csv_writer = csv.writer(out,dialect='excel')
f = open("/LF1.txt","r")
for line in f.readlines():
line=line.replace(',','\t') #将每行的逗号替换成空格
list = line.split() #将字符串转为列表,从而可以按单元格写入csv
csv_writer.writerow(list)
更多推荐
所有评论(0)