Python を使用して Pandas データ フレームを Google スプレッドシートにエクスポートする

{
  "type": "service_account",
  "project_id": "some-project-id",
  "private_key_id": "eb...25",
  "private_key": "-----BEGIN PRIVATE KEY-----\nNrDyLw...jINQh/9\n-----END PRIVATE KEY-----\n",
  "client_email": "123...999-yourclientemail@projectid.iam.gserviceaccount.com",
  "client_id": "473...hd.apps.googleusercontent.com",
  ...
}

PS C:\> pip install gspread

PS C:\> pip install oauth2client

import gspread
from oauth2client.service_account import ServiceAccountCredentials


def create_connection(service_file):
    client = None
    scope = [
        "https://www.googleapis.com/auth/drive",
        "https://www.googleapis.com/auth/drive.file",
    ]
    try:
        credentials = ServiceAccountCredentials.from_json_keyfile_name(
            service_file, scope
        )
        client = gspread.authorize(credentials)
        print("Connection established successfully...")
    except Exception as e:
        print(e)
    return client


service = "service_account.json"  # downloaded Credential file in JSON format
client = create_connection(service)

def create_google_sheet(client, sheet_name):
    google_sheet = None
    try:
        google_sheet = client.create(sheet_name)
        google_sheet.share(
            "@gmail.com",  # enter the email you want to create a google sheet on
            perm_type="user",
            role="writer",
        )
        print("Google Sheet created successfully...")
    except Exception as e:
        print(e)
    return google_sheet


service = "service_account.json"  # downloaded Credential file in JSON format
client = create_connection(service)

sheet_name = "50_Startups"  # google sheet name of your choice
google_sheet = create_google_sheet(client, sheet_name)

PS C:\> pip install pandas

import pandas as pd


def export_dataframe_to_google_sheet(worksheet, dataframe):
    try:
        worksheet.update(
            [dataframe.columns.values.tolist()] + dataframe.values.tolist()
        )
        print("DataFrame exported successfully...")
    except Exception as e:
        print(e)


df_file = "50_Startups.csv"
dataframe = pd.read_csv(df_file)
worksheet = google_sheet.get_worksheet(0)
export_dataframe_to_google_sheet(worksheet, dataframe)