import csv
csv_file = '/路径/'
with open('csv_file','r') as csvfile:
reader = csv.reader(csvfile)
data = [row for row in reader]
data[1:]//get rid of the first row-data[0]
我的csv文件内容如下(此处只列出3行):想要获取该csv文件的第一列关于视频id的名称,并按行存入txt文件。
id subject scene actions length
46GP8 HR43 kitchen window a person cooks food on a stove before looking out of a window.
N11GT 0KZ7 Stairs floor person at the bottom of the staircase shakes a blanket out.
......
代码如下:
import csv
csv_file = '/文件路径/'
fi = open('id_lst.txt','w')
with open(csv_file,'r') as f:
reader = csv.DictReader(f)
for row in reader:
actions = row['id'].split(';')
fi.writelines(actions)
fi.write('\n')
fi.close()