· 5 years ago · Dec 18, 2020, 12:10 PM
1# Способ подгрузки excel таблицы через API
2
3import pandas as pd
4import gspread
5from df2gspread import df2gspread as d2g
6from oauth2client.service_account import ServiceAccountCredentials
7
8# 1. Авторизация после получения токена
9scope = ['https://spreadsheets.google.com/feeds',
10 'https://www.googleapis.com/auth/drive']
11
12
13my_mail = 'maximmandrik@avian-muse-298921.iam.gserviceaccount.com'
14path_to_credentials = 'avian-muse-298921-6ccf6e37deb9.json'
15
16
17credentials = ServiceAccountCredentials.from_json_keyfile_name(path_to_credentials, scope)
18gs = gspread.authorize(credentials)
19
20# 2. Конвертирование файла в dataframe
21
22# Name of the table in google sheets,
23# can be url for open_by_url
24# or id (key) part for open_by_key
25table_name = 'masterclass2_2020-11-16' # Your table
26
27# Get this table
28work_sheet = gs.open(table_name)
29
30# Select 1st sheet
31sheet1 = work_sheet.sheet1
32
33# Get data in python lists format
34data = sheet1.get_all_values()
35
36headers = data.pop(0)
37
38# Create df
39df = pd.DataFrame(data, columns=headers)
40df.head()
41
42
43