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.

--
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

[jake]

My mind is blown by how well you are thinking and translating it by typing it beautifully into python code. Thank you.

[septic]

The day quikstreams supports joins without internal Kafka topics I’m sold !! 😊

[tharunbhaskar]

Always tried to learn Kafka but was worried about the libraries. But quixstreams is something else, its super easy to get started with

[souravbarua]

Thank you for this 🙏. This is a wonderful thing. I'm really enjoying this series.

[arisweedler]

Truly incredibly explained. I would love to know where you learned how to think/explain/communicate like that.

[madishaiken]

Waiting for some more series on kafka, great explanation

[ovidiu_nl]

Cool! A candlestick chart would have been nice. 🙂

[gadhiyaparas]

I like your videos, Please upload more videos.

[gustavosolano]

thank you for the content, keep it up !!

[emtiyazaly]

Interested in
an episode on "From Kafka to Kibana"

[ChuckleChampion]

Awesome videos!! how could I store my data to a local csv tho!??

[yifeitong]

Hello, thanks for the video. What if we would like to consume the data in the topic from certain existing offset number ? I was looking at .seek() class but not get a effective solution yet. Many thanks