From Kafka to a Spreadsheet - A Step by Step Python Tutorial

Sooner or later, someone will ask you to get data into a spreadsheet. It's a
universal truth of the software business. So let's create a project that does
exactly that!

In this Python coding walkthrough, we'll show you how to build a real-time
data-streaming pipeline that takes data from Apache Kafka and streams it into a
live Google Spreadsheet. You see every step of the code - minus our API keys -
as we build up the solution step-by-step. From empty directory to working,
live-updating sheet.

📥 This project's source code: https://github.com/quixio/simple-kafk...
👨‍💻 Quix Streams Source on Github: https://github.com/quixio/quix-streams
📓 Quix Streams API Docs: https://quix.io/docs/quix-streams/api...
📺 Watch all the videos in this series:    • Quix Streams Tutorials  
⚙️ Google Developer Console: https://console.cloud.google.com/

--
00:00 Intro
00:27 Weather data
01:00 Data preprocessing
06:47 Hourly data grouping
08:10 Summarize hourly data
15:10 Connect the data to google sheets
22:44 Summary
23:10 Outro