I have been stuck on how to download a pandas DataFrame into my local disk (or onto Google Drive) after creating it in Google Colab. I have tried converting it to bytes, a string (using pd.to_string), a dict (pd.to_dict), but nothing seems to work.
Additionally, I've looked at using the drive.CreateFile method as explained in the intro Colab Code and as specified here: How to download file created in Colaboratory workspace?, but I'm not sure how to apply this to pandas.
Any help is appreciated - thanks!
Maybe something like this.
from google.colab import files
df.to_csv('df.csv')
files.download('df.csv')
For google colab, i recommend use Pydrive. Your answer can be found in here How to download file created in Colaboratory workspace?
edit: just change filename.csv to filename.zip or filename.blabla in lines
uploaded = drive.CreateFile({'title': 'filename.csv'})
uploaded.SetContentFile('filename.csv')
why? because this line
uploaded.SetContentFile('filename.csv')
auto set format for you content file, so you don't need to converter it to String or Byte.