首页 > 解决方案 > 将字典中的数据附加到列表

问题描述

我一直在用 python 抓取数据并将它们存储在字典中。我想将它们放在一个列表中并将它们导出到 CSV。我有代码但附加不起作用。我想要标题、年份和 Cast(每部电影有几个)

for index in range(0, len(movies)):
# Seperate movie into: 'place', 'title', 'year'
movie_string = movies[index].get_text()
movie = (' '.join(movie_string.split()).replace('.', ''))
movie_title = movie[len(str(index))+1:-7]
year = re.search('\((.*?)\)', movie_string).group(1)
place = movie[:len(str(index))-(len(movie))]
data = {"movie_title": movie_title,
        "year": year,
        "place": place,
        "star_cast": crew[index],
        "rating": ratings[index],
        "vote": votes[index],
        "link": links[index]}
imdb.append(data)

with open("w.csv",'w') as file:
writer=csv.writer(file)
writer.writerow(['ID','TITLE','YEAR','CAST'])           
writer.writerow('movie_title','year''star_cast')

标签: python

解决方案


在写入 CSV 的函数中,您应该迭代字典元素以成为列

with open("w.csv",'w') as file:
writer=csv.writer(file)
writer.writerow(['ID','TITLE','YEAR','CAST'])
for item in imdb:        
    writer.writerow([item['place'],item['movie_title'],item['year'],item['star_cast']])

推荐阅读