我有一个。txt文件,里面有这个- 2.9,Gardena CA
我要做的是使用python脚本将该文本转换为。csv(表):
import csv
import itertools
with open('log.txt', 'r') as in_file:
stripped = (line.strip() for line in in_file)
lines = (line for line in stripped if line)
grouped = itertools.izip(*[lines] * 3)
with open('log.csv', 'w') as out_file:
writer = csv.writer(out_file)
writer.writerow(('title', 'intro'))
writer.writerows(grouped)
在log.csv文件中得到的输出是- title,intro,tagline
我希望log.csv文件显示的是:
title,intro
2.9,Gardena CA
你需要先把这一行分开。
import csv
with open('log.txt', 'r') as in_file:
stripped = (line.strip() for line in in_file)
lines = (line.split(",") for line in stripped if line)
with open('log.csv', 'w') as out_file:
writer = csv.writer(out_file)
writer.writerow(('title', 'intro'))
writer.writerows(lines)
import pandas as pd
df = pd.read_fwf('log.txt')
df.to_csv('log.csv')
我是这样做的:
with open(txtfile, 'r') as infile, open(csvfile, 'w') as outfile:
stripped = (line.strip() for line in infile)
lines = (line.split(",") for line in stripped if line)
writer = csv.writer(outfile)
writer.writerows(lines)
希望有帮助!
我想这就是您需要的输出:
标题、简介、标语
2.9,嘉丁拿,CA
可以这样修改你的代码:
import csv
import itertools
with open('log.txt', 'r') as in_file:
lines = in_file.read().splitlines()
stripped = [line.replace(","," ").split() for line in lines]
grouped = itertools.izip(*[stripped]*1)
with open('log.csv', 'w') as out_file:
writer = csv.writer(out_file)
writer.writerow(('title', 'intro', 'tagline'))
for group in grouped:
writer.writerows(group)
在python版本3。X, intertools。
Python 3的函数代码是:import csv
import zlib
with open('output.txt', 'r') as in_file:
lines = in_file.read().splitlines()
stripped = [line.replace(","," ").split() for line in lines]
grouped = zip(*[stripped]*1)
with open('teste.csv', 'w') as out_file:
writer = csv.writer(out_file)
writer.writerow(('A', 'B', 'C', 'D'))
for group in grouped:
writer.writerows(group)