首页 > 解决方案 > 从 python readlines() 创建一个 csv 文件

问题描述

我想从文本文件创建 CSV 文件

text_file.txt

Friday,09071235462,08:42:48

Princely,08123456,08:46:45

我的代码转换文件

#Convert to csv
import csv
for_csv_list = []
with open(f'./text_file.txt', "r") as file:
    lines = file.readlines()
    for line in lines:
        if line != "\n":
            for_csv_list.append(line.strip().split())


with open("the_csv_file.csv","w") as convert_to_csv:
    writer = csv.writer(convert_to_csv)
    writer.writerows(for_csv_list)

然后我尝试打开转换后的 CSV 文件

f = open("the_csv_file.csv")
csv_f = csv.reader(f)
for row in csv_f:
    print("this is row = ",row)
f.close()

返回的代码

this is row =  ['Friday,09071235462,08:42:48']
this is row =  []
this is row =  ['Princely,08123456,08:46:45']
this is row =  []

请问我将如何删除空列表,因为我的预期结果应该是:

this is row =  ['Friday,09071235462,08:42:48']
this is row =  ['Princely,08123456,08:46:45']

标签: python-3.xcsvreadlines

解决方案


推荐阅读