用python将csv文件中的数据解析为Google电子表格

pip install pandas
pip install --upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib

import pandas as pd
import gspread
from oauth2client.service_account import ServiceAccountCredentials

# 定义CSV文件路径
csv_file_path = 'path/to/your/csv/file.csv'

# 定义Google电子表格名称
google_sheet_name = 'Your Google Sheet Name'

# 读取CSV文件数据
data = pd.read_csv(csv_file_path)

# 将数据写入Google电子表格
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
credentials = ServiceAccountCredentials.from_json_keyfile_name('path/to/your/service_account_credentials.json', scope)
client = gspread.authorize(credentials)
sheet = client.create(google_sheet_name)
worksheet = sheet.get_worksheet(0)
worksheet.update([data.columns.values.tolist()] + data.values.tolist())

# 打印Google电子表格链接
print('Google电子表格链接:', sheet.url)