Analyze Google Sheets data with Python using Google Collab | Python in Practice #5
Still need to learn to program? Learn Python the Right Way and develop a fundamental base to become capable of thinking and creating solutions to problems by writing code: access https://vai.pgdinamica.com/pjc-dados or watch • Python do Jeito Certo | Primeiros passos c...
How to analyze spreadsheet data with Python?
In this video, Kizzy teaches you how to work with a Google Sheets spreadsheet using the Python programming language. You can open a spreadsheet in your Google Drive, create new spreadsheets, read data from specific cells, write or modify data in cells, create and modify pages (tabs) within the spreadsheet, and even export and import all the spreadsheet data to a Pandas dataframe! 🤯 In short, whatever you want to do with spreadsheet data in Python, including automating the spreadsheet, you can achieve it using the GSpread package and the techniques Kizzy teaches in this video.
The most amazing thing is that you can analyze data from Google Sheets spreadsheets directly in the cloud using Google Colab to access your Google Drive and run your Python code!
0:00 Why use Google Colab to access Google Sheets
1:42 Creating a notebook and preparing the environment with GSpread
2:55 Authentication in Google Drive
4:10 Accessing an existing spreadsheet in Google Drive
5:40 Accessing a specific page
6:20 Editing specific cells
8:00 Integrating the spreadsheet with a Pandas dataframe
13:40 Final considerations and possibilities
📌 Useful links:
GSpread - https://gspread.readthedocs.io/en/lat...
Video code - https://github.com/programacaodinamic...
https://colab.research.google.com/not...
– Related videos:
1. How to use Google Collaborate to Analyze Data? 1. Python Data Analysis Series: • Análise de Dados em Python
2. Pandas Tips Series: • Dicas de Pandas | DataFrames em Python | D...
3. Python in Practice Series: • Python na Prática
#PythonInPractice
Recommended Data Science Books: https://amzn.to/2XZyxUr
Algorithms and Data Structures Books: https://amzn.to/3d5wK4m
Setup - Equipment: https://amzn.to/37Cg3N2
Telegram channel to receive videos: https://t.me/joinchat/AAAAAFaoNgZTMRv...
*Emails:
– Business proposals: comercial@pgdinamica.com
– Other matters: contato@programacaodinamica.com.br
*Check out more content on our blog: https://blog.programacaodinamica.com.br
*Instagram: / pgdinamica
/ kizzy_terra
/ hallpaz
*Twitter: / pgdinamica
/ kizzy_terra
/ hallpaz
*Like Programação Dinâmica on Facebook: https://fb.com/programacaodinamica
*Our repository on Github: https://github.com/programacaodinamica
Check out our Medium: / programacaodinamica
Check out the articles on Python Café: https://pythoncafe.com.br
Auf dieser Seite können Sie das Online-Video Analyze Google Sheets data with Python using Google Collab | Python in Practice #5 mit der Dauer 14 minuten 38 sekunde in guter Qualität ansehen, das der Benutzer Programação Dinâmica 19 September 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 127,140 Mal angesehen und es wurde von 10 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
