我正在尝试在python中编写一个函数,该函数读取csv文件并返回格式正确的文件。输入文件只是标准的csv文件。每行代表一个人。输出格式应类似于:
[
("Age", "Gender", "Weight (kg)", "Height (cm)"),
("28", "Female", "58", "168"),
("33", "Male", "", "188")
]
事情就是不知道我该怎么做。我知道我可以遍历列表中的每个元素并打印出来,但是我想像上面一样返回它们。我最终获得的唯一格式如下:
[('Age', 'Gender', 'Weight (kg)', 'Height (cm)'), ('28', 'Female', '58', '168'), ('33', 'Male', '', '188')]
万一有人需要看我的代码(我想它根本没有很好地编码,但我正在学习):
def read_csv(path):
newlist = []
with open("example.csv", "r") as f:
nr_of_lines = 0
for line in f.readlines():
counter = 0
nr_of_lines += 1
while "," in line:
idx = line.find(",")
entry = line[0:idx]
newlist.append(entry)
line = line[idx+1:]
counter += 1
if "," not in line:
idx2 = line.find("\n")
newlist.append(line[:idx2])
nr_elements_per_line = int(len(newlist)/nr_of_lines)
tuple_list = []
for i in range(nr_of_lines):
tuple_list.append(tuple(newlist[nr_elements_per_line*i:nr_elements_per_line+i*nr_elements_per_line]))
return tuple_list
print(read_csv("example.csv"))
您可以使用该pprint
模块进行更好的打印,或者自己打印:
data = [('Age', 'Gender', 'Weight (kg)', 'Height (cm)'),
('28', 'Female', '58', '168'),
('33', 'Male', '', '188')]
print('[')
for inner in data:
print(f"\t{inner}")
print(']')
输出:
[
('Age', 'Gender', 'Weight (kg)', 'Height (cm)')
('28', 'Female', '58', '168')
('33', 'Male', '', '188')
]
与pprint
:
from pprint import pprint
pprint(data)
输出:
[('Age', 'Gender', 'Weight (kg)', 'Height (cm)'),
('28', 'Female', '58', '168'),
('33', 'Male', '', '188')]
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句