将txt转换为csv python scrip

Question

我有一个.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

Answer 1

我就是这样做的：

 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)

希望有帮助！

Answer 2

你得先把线分开。

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)

Answer 3

import pandas as pd
df = pd.read_fwf('log.txt')
df.to_csv('log.csv')