Exporting Data from google colab to local machine

Question

How to export data frames which are created in google colab to your local machine?

I have cleaned a data set on google colab. Now I want to export the data frame to my local machine. df.to_csv is saving file to the virtual machine and not my local machine.

Answer 1

Try this

from google.colab import files files.download("data.csv") 

Update(Sep 2018): now it's even easier

• open the left pane
• select 'Files' tab
• click 'Refresh'
• right click the file, then download

Update (Jan 2020): the UI changes

• click on the folder icon on the left pane (3rd icon)
• click 'Refresh'
• right click the file, then download

Answer 2

Try this:

First you can save the file using pandas to_csv functionality later on you can download that file using google colab files functionality.

from google.colab import files df.to_csv('filename.csv')  files.download('filename.csv')