如何使用python从公共Google表格中获取数据? [英] How to obtain data from a public google sheets using python?

问题描述

我正在尝试获取以下Google工作表的不同工作表中显示的COVID-19数据.G工作表开放供公众使用，URL仅返回第一个工作表.我要抓取所有工作表.有谁可以帮忙.这是Google工作表链接:

I am trying to obtain the COVID-19 data present in different worksheets of the following google sheet. The g-sheet being open for public usage, the URL only returns the first worksheet only.I want to scrape all the worksheets.Can any one help. Here's the google sheet link:

https://docs.google.com/spreadsheets/d/e/2PACX-1vSc_2y5N0I67wDU38DjDh35IZSIS30rQf7_NYZhtYYGU1jJYT6_kDx4YpF-qw0LSlGsBYP8pqM_a1Pd/pubhtml

推荐答案

您可以使用请求来完成.所有表都在一个HTML文档的源代码中.只需遍历表并写入CSV.

You can do it using requests. All the tables are in the source of one HTML document. Simply iterate through the tables and write to a CSV.

from bs4 import BeautifulSoup
import csv
import requests

html = requests.get('https://docs.google.com/spreadsheets/d/e/2PACX-1vSc_2y5N0I67wDU38DjDh35IZSIS30rQf7_NYZhtYYGU1jJYT6_kDx4YpF-qw0LSlGsBYP8pqM_a1Pd/pubhtml').text
soup = BeautifulSoup(html, "lxml")
tables = soup.find_all("table")
index = 0
for table in tables:
    with open(str(index) + ".csv", "w") as f:
        wr = csv.writer(f, quoting=csv.QUOTE_NONNUMERIC)
        wr.writerows([[td.text for td in row.find_all("td")] for row in table.find_all("tr")])
    index = index + 1

这篇关于如何使用python从公共Google表格中获取数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！