将数据框作为CSV文件从Google Colab导出到Google Drive [英] Export dataframe as csv file from google colab to google drive

问题描述

我想将数据框以csv的形式从colab上传到Google驱动器.我可以上传一个简单的文本文件，但不能上传一个csv.

I want to upload a dataframe as csv from colab to google drive.I tried a lot but no luck. I can upload a simple text file but failed to upload a csv.

我尝试了以下代码:

import pandas as pd
df=pd.DataFrame({1:[1,2,3]})
df.to_csv('abc',sep='\t')
auth.authenticate_user()
gauth = GoogleAuth()
gauth.credentials = GoogleCredentials.get_application_default()
drive = GoogleDrive(gauth)
uploaded = drive.CreateFile({'title': 'sample.csv', 'mimeType':'csv'})
uploaded.SetContentFile('abc')
uploaded.Upload()

推荐答案

使用挂载代替pydrive可能会更容易.

It may be easier to use mounting instead of pydrive.

from google.colab import drive
drive.mount('drive')

身份验证后，您可以复制csv文件.

After authentication, you can copy your csv file.

df.to_csv('data.csv')
!cp data.csv "drive/My Drive/"

这篇关于将数据框作为CSV文件从Google Colab导出到Google Drive的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！