How to upload Cloud files into Python

Question

I use to upload excel files into pandas dataframe pd.ExcelFile if the files are in my local drive How can I do the same if I have an Excel file in Google Drive or Microsoft One Drive and I want to connect remotely?

min2bro · Accepted Answer · 2017-07-01 08:55:28Z

1

You can use read_csv() on a StringIO object:

from StringIO import StringIO  # moved to io in python3.

import requests
r = requests.get('Your google drive link')
data = r.content

df = pd.read_csv(StringIO(data))

answered Jul 1, 2017 at 8:55

min2bro

4,6385 gold badges33 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Mariano Over a year ago

I tried your idea but it did not work I am getting the following error "TypeError: initial_value must be str or None, not bytes" I also tried with BytesIO in case that the problem was there

min2bro Over a year ago

Can i get access to the sample file and then i can try from my end?

Mariano Over a year ago

sure, here is the link='thi-my.sharepoint.com/personal/mariano_scandizzo_spartners_me/…'

min2bro Over a year ago

Access to this link has been removed, Sorry

Mariano Over a year ago

sorry for that , the following one should work thi-my.sharepoint.com/personal/mariano_scandizzo_spartners_me/… thank you for all your help

|

Collectives™ on Stack Overflow

How to upload Cloud files into Python

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related