How to update a existing csv in google drive without using google sheets using python

user_13997535 0
Viewed 980

I have a csv file (data.csv) in my Google drive.

I want to append new data (df) to that csv file(stack new below old as both csv's have same column headers) and save it to existing data.csv without using google sheets.

How can I do this?

pandas python
1 Answers

Open google colab and mount your google drive in colab using :

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

Provide your authorization and the file will be available in your current session inside your drive directory. You can then edit the file by importing pandas or csv then :

with open('data.csv','a') as fd:
     fd.write(myCsvRow)

Opening a file with the 'a' parameter allows you to append to the end of the file instead of simply overwriting the existing content. Any changes you do will be saved to your original file.

user_111350030
Related