将txt转换为csv python脚本 [英] Convert txt to csv python script
本文介绍了将txt转换为csv python脚本的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在其中有一个.txt文件-2.9,Gardena CA
I have a .txt file with this inside - 2.9,Gardena CA
我要执行的操作是使用python脚本将该文本转换为.csv(表):
What I'm trying to do is convert that text into a .csv (table) using a python script:
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
The output I get in the log.csv file is - title,intro,tagline
我希望显示的log.csv文件是:
What I would want the log.csv file to show is:
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)
这篇关于将txt转换为csv python脚本的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文