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
Sur cette page du site, vous pouvez voir la vidéo en ligne Analyze Google Sheets data with Python using Google Collab | Python in Practice #5 durée 14 minute 38 seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Programação Dinâmica 19 septembre 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 127,140 fois et il a aimé 10 mille téléspectateurs. Bon visionnage!
