如何用feedparser解析csv文件中的多个feed？

Question

我正在尝试解析CSV文件中列表中的多个feed（500），并将结果保存到另一个CSV文件中。问题是解析器只检查列表中的一个提要。你知道吗

writer = csv.writer(open('items.csv', 'w'))
reader = csv.reader(open('feeds.csv', 'r'))
next(reader) # skip column headings

for row in reader:
    url = row[0]
    print (url)
df = pd.DataFrame(row)
df = pd.DataFrame(columns=['author', 'title', 'link','summary', 'published'])
for i, post in enumerate(feed.entries):
    df.loc[i] = post.author, post.title, post.link, post.summary, post.published

df

CSV文件如下所示

Answer 1

我终于解决了我的问题这里是最后的代码，如果有人会有类似的问题在未来

import feedparser
import csv
import pandas as pd

reader = csv.reader(open('feeds.csv', 'r'))
next(reader) # column headings
df = pd.DataFrame(columns=['author', 'title', 'link','summary', 'published'])
for row in reader:
    url = row[0]
    print (url)

    feed = feedparser.parse(url)

    for i, post in enumerate(feed.entries):
        df.loc[len(df)] = post.author, post.title, post.link, post.summary, post.published

df.to_csv('myfilename.csv', index=False)