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
Nesta página do site você pode assistir ao vídeo on-line Analyze Google Sheets data with Python using Google Collab | Python in Practice #5 duração 14 minuto 38 segundo em boa qualidade , que foi baixado pelo usuário Programação Dinâmica 19 Setembro 2020, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 127,140 vezes e gostou 10 mil espectadores. Boa visualização!
