Simplest Way of Reading Google Sheets into a Pandas Dataframe (Python)

Подписаться 2,9 тыс.

Просмотров 14 тыс.

50% 1

In this Video, I'll show you simplest way of reading a Google Sheets into a Pandas DataFrame.
Link to the Notebook : github.com/bha...
If you do have any questions with what we covered in this video then feel free to ask in the comment section below & I'll do my best to answer those.
If you enjoy these tutorials & would like to support them then the easiest way is to simply like the video & give it a thumbs up & also it's a huge help to share these videos with anyone who you think would find them useful.
Please consider clicking the SUBSCRIBE button to be notified for future videos & thank you all for watching.
You can find me on:
Blog - bhattbhavesh91....
Twitter - / _bhaveshbhatt
GitHub - github.com/bha...
Medium - / bhattbhavesh91
#Pandas #GoogleSheets

Опубликовано:

10 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 30

@namankansal4415 4 года назад

Thanks for sharing the awesome content always. One question - is it possible to use Google sheet + python to automate basic reporting. Specific points where I need help - 1. How to manage the sharing permissions via python (on Google sheet) 2. Scheduling the python script Use case - lots of business teams need to create semi automated ecosystem (not as sophisticated as that of an analytics ecosystem, but good enough to support features like - security, permission management, scheduling) Exploring sheet+python/collab to see if it could help

@LashCrypto-ir2hh Год назад

Incredible. You are my god. My df is imported without any error!

@walkerbutin5171 Год назад

Awesome vid, super clear step-by-step

@whatacomedy177 11 месяцев назад

Superb... Perfect...

@sergemmol5357 Год назад

Just what I need, thanks for the content

@schwenk602 6 месяцев назад

awesome....i was messing aroung with the shitty api creds....j

@aryangautam7506 Год назад

It worked Thankyou very much

@butterflies_and_trees Год назад

This is genius!

@saumyabhattacharya2067 3 года назад

Url is downloading csv with double quoted values. For example: "A","B" "1","2" And hence pd.read_csv(gsheet_url) is not working. Please help

@franciscomena5672 2 года назад

A lot of thanks, you help full with this tip

@ahmadyusuf3768 9 месяцев назад

awesome

@atultanna 2 года назад

My google sheet has nse data How can the same to connected to python Will this method work

@tytoalba3333 3 года назад

Did not work with me. It brings an HTML code instead of sheet data.

@tytoalba3333 3 года назад

@Diego Sebastian Iglesias Decastelli try drive.mount. if u face doubts let me know.

@mardibenton7366 3 года назад

You are a boss! thank you sirrrrr!

@francescobaldissera634 2 года назад

What if I have multiple tabs I want to import as a single spreadsheet?

@jigyasakohli5032 Год назад

Thanks for the video. I am facing this error : ParserError: Error tokenizing data. C error: Expected 96 fields in line 3, saw 229. Any solution for this?

@ayushsinha8570 Год назад

yes me too

@jigyasakohli5032 Год назад

@@ayushsinha8570 It resolved for me after changing permissions for the sheet. make it public or visible to everyone

@ayushsinha8570 Год назад

@@jigyasakohli5032 sheets based on organisations are private and cant be made public, i did it through colab and its working

@heera_ai 4 года назад

Excellent work!

@shailesh1981able 3 года назад

Sincere thanks! It is working! But pls tell me, what's the difference between opening Google Sheet through activating API. I tried a lot activating Google Sheet API but that process is cumbersome. You have shown the simplest Way.