How to read and save data from Google Sheets in Python

Показать описание

Tutorial on How to read and save data from Google Sheets in Python. How to load Google Sheets in Python / Google Colab and save data into Google Sheet spreadsheets using Python in Colab environment. Providing a downloadable template solution and step by step tutorial for beginners regardless of previous knowledge on programming.
In this video, I provide a step-by-step tutorial and a ready-to-execute & download code script template to load or open and save your input and output csv data files from and into google sheets spreadsheets.

Related links for this video:

Please like this video and subscribe to the channel for more tutorial videos, particularly with a focus on:
• to provide ready-to-execute solutions to achieve data goals of professionals regardless of your previous knowledge on technical background of programming and data.
• a series of data and business insight from the perspective of an economist and applied data scientist in industry for those interested in the "under the hood" of the data related topics.

00:00 Introduction
00:17 Step1: initial settings for google sheet connection
00:51 Step2: authenticate connection of google colab to your google account
01:15 Step3: reading the spreadsheet data
01:37 example of google sheets used in tutorial
02:14 Step4: data as dataframe
03:03 Saving output data in google sheet

About me: I am Dimo, an economist with a data science focus in industry. I am sharing my productivity, tech-solution, data visualization and analysis experiences, statistical - econometrics - machine learning interpretations in format of how-to tutorials in this channel.

My Social Media Links & Profiles:

Music: Days Like This by Justhea is licensed under a Creative Commons License.