import csv
with open('your_csv.csv') as f:
f.readline() # these are headings should remove them
csv_reader = csv.reader(f, delimiter='\t')
for line_list in csv_reader:
# line_list is a list of each row of your csv
# line_list[0] Contains 'Name' data 'Napolean'
# line_list[1] Cotinas Address 'Preston, Idaho'
# line_list[2] Contains skills 'Bowhunting, Computer Hacking, Drawing Unicorns'
skills_list = [x.strip() for x in line_list[2].split(',')]
for skill in skills_list:
#line_list[0] line_list[1], skill
Napoleon Preston, Idaho Bowhunting
Napoleon Preston, Idaho Computer Hacking
Napoleon Preston, Idaho Drawing Unicorns
现在有了一个平面文件,我相信操作数据的第一步是将其加载到python中,以便开始使用它。在
你在正确的轨道上。csv模块就是为此而设计的
假设您的数据是制表符分隔的
相关问题 更多 >
编程相关推荐