如何使用python中的pandas read_html获取超过100行的信息？

Question

我一直在尝试导入一个在google sheets中有超过100行数据的表，但read_html函数只读取前100行数据，如何扩展或设置行数限制

A = pd.read_html('https://docs.google.com/spreadsheets/d/1SqqSwGUvYAA33eV_B93nPtOQshZ2TIf8XGgkc90lnpQ/view#gid=0')
C = np.array((np.array(A[0]))[2:,7:12])
C[0,0:3] = ("Día", "Vacunas a 0:00", "Vacunas Día")
F = np.zeros((99,5)) 
for i in range(1,98):     
  for j in range(1,5):
    F[i,j] = float(C[i,j])       
F = np.nan_to_num(F)

Answer 1

您可以通过以下方式更改显示设置：

import pandas as pd
pd.set_option('max_rows',1000)
data = pd.read_html(url)

Answer 2

尝试使用以下表单：

from google.colab import auth
auth.authenticate_user()

import gspread
from oauth2client.client import GoogleCredentials

gc = gspread.authorize(GoogleCredentials.get_application_default())

worksheet = gc.open('Your spreadsheet name').sheet1

# get_all_values gives a list of rows.
rows = worksheet.get_all_values()
print(rows)

# Convert to a DataFrame and render.
import pandas as pd
pd.DataFrame.from_records(rows)

发件人： https://colab.research.google.com/notebooks/snippets/sheets.ipynb#scrollTo=JiJVCmu3dhFa