我正在使用下面的腳本來獲取一個品牌的谷歌新聞結果。但是，我希望能夠將結果匯出為CSV或Excel檔案。誰能幫我解決這個問題呢？
pip install pygooglenews -upgrade
from pygooglenews import GoogleNews
gn = GoogleNews(country = 'IE'/span>)
def get_titles（search）。
故事 = []
搜索 = gn.search(搜索)
newsitem = search[' entries']
for item in newsitem:
story = {
'title' : item.title。
'link' : item.link
}
stories.append(story)
return stories
print(get_titles('aldi')
uj5u.com熱心網友回復：
一種簡單（但很重）的方法是使用pandas，它可以輕松地將字典串列轉換為資料框架
import pandas as pd
pd.DataFrame(stories).to_csv("result_list.csv")
內置的方式在這里有答案。如何將這個字典串列轉換為csv檔案？
import csv
with open("results_list.csv"/span>, "w"/span>, encoding="utf-8"/span>) as f:
writer = csv.DictWriter(f, fieldnames=stories[0].keys()
writer.writeheader()
writer.writerows(stories)
uj5u.com熱心網友回復：
你可以使用CSV模塊，在你從搜索中拉出的時候寫下這些行。
from pygooglenews import GoogleNews
import csv
gn = GoogleNews(country = 'IE')
def write_csv（filename, search）。
搜索 = gn.search(search)
with open(filename, "w"/span>, newline="") as fileobj:
csv.writer(fileobj).writerows((item.title, item.link)
for item in search[' entries'] )
write_csv('output.csv', 'aldi')
uj5u.com熱心網友回復：
你可以試試下面的方法。
以dict串列的形式獲取資料，在串列中回圈，并將每個條目寫到檔案中。
from pygooglenews import GoogleNews
gn = GoogleNews(country = 'IE'/span>)
def get_titles（search）。
故事 = []
搜索 = gn.search(搜索)
newsitem = search[' entries']
for item in newsitem:
story = {
'title' : item.title。
'link' : item.link
}
stories.append(story)
return stories
stories = get_titles('aldi')
with open('stories.csv','w',encoding='utf-8') as f:
f.write('title,link
')
for s in stories:
f.write(f'{s["title"]},{s["link"]}'
')
stories.csv
title,link
阿爾迪將試行首家無結賬超市 - BreakingNews.ie,https://www.breakingnews.ie/business/aldi-to-trial-first-checkout-free-supermarket-1186611.html
為新的Aldi商店在恩尼斯的計劃開了綠燈 - Clare Champion,https://clarechampion.ie/green-light-given-to-plans-為新的aldi-store-在-ennis/的計劃。
基爾代爾婦女在Aldi的全國棕色面包烘焙比賽中獲得了最高獎項2021 - Leinster Leader,https://www.leinsterleader.ie/news/local-news/666996/kildare-woman-scoops-up-top-prize-at-aldi-s-national-brown-bread-baking-competition-2021.html
Aldi將在Co Mayo和Co Galway開設新店 - RTE.ie,https://www.rte.ie/news/business/2021/0909/1245582-two-new-aldi-stores-for-connacht/
愛爾蘭Aldi、Lidl和Tesco的顧客透露了他們最喜歡的"隱藏的寶石"與一些未知的便宜貨 - Irish Mirror,https://www.irishmirror.ie/lifestyle/aldi-lidl-tesco-ireland-customers-25021723
"這對我們來說是一個巨大的推動。" 與Aldi獲獎者一起成長 - Newstalk,https://www.newstalk.com/podcasts/highlights-from-the-pat-kenny-show/its-a-massive-boost-for-us-grow-with-aldi-winners
美食香腸、漢堡醬、餅干。與阿爾迪一起成長活動的獲獎者名單公布 - Agriland,https://www.agriland.ie/farming-news/gourmet-sausage-burger-sauce-cookies-winners-of-grow-with-aldi-announced/
克萊爾老夫婦因拒絕在阿爾迪超市戴口罩而被罰款 - Clare Champion,https://clarechampion.ie/elderly-clare-couple-fined-for-refusing-to-wear-masks-in-aldi/
Tesco、Aldi、M&S和Morrisons超市被房地產投資巨頭以1.131億英鎊的價格收購 - Business Live,https://www.business-live.co.uk/commercial-property/tesco-aldi-ms-morrisons-supermarkets-21616148
Aldi和IRFU推出新的食譜以支持巴納德斯 - 愛爾蘭橄欖球,https://www.irishrugby.ie/2021/09/12/aldi-and-irfu-launch-new-cookbook-in-aid-of-barnardos/
阿爾迪公布了在泰晤士迪頓建店的計劃，創造了50個就業機會 - Surrey Live,https://www.getsurrey.co.uk/news/surrey-news/aldi-unveils-plan-build-store-21625481
阿爾迪沙拉醬因污染而被召回 - Delish.com,https://www.delish.com/food-news/a37665205/aldi-salad-dressing-recall-september-2021/
...
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/323573.html
標籤：