Constantin Lungu

Constantin Lungu

51 followers

Data Engineer with a passion for transforming complex data landscapes into insightful stories. Here on my blog, I share insights, challenges, and the ever-evolving dance of technology and business.

Using RANGE_BUCKET in BigQuery

Sep 23, 20241 min read

I've recently had to perform a validation of differences between 2 data sources, so I've figured it would be interesting to see the distribution of...

Using RANGE_BUCKET in BigQuery

Calculating the Median in BigQuery

Aug 9, 20241 min read

One of these days, I had to handle missing value imputation and stumbled upon the need to calculate a median in BigQuery SQL. Since there is no...

Calculating the Median in BigQuery

Dynamically extracting JSON data in BigQuery

Aug 9, 20241 min read

I was asked today about dynamically extracting key-value pairs from heterogeneous JSON-like strings in BigQuery SQL and I've remembered this...

Dynamically extracting JSON data in BigQuery

Using tempfile module in Python

Aug 8, 20241 min read

In this world, everything is ephemeral. If you need to create temporary files or directories in Python, check out the tempfile module. Whether you...

Using tempfile module in Python

A quick look at the json module in Python

Aug 7, 20241 min read

If you ever need to work with JSON files in Python, you're going to encounter the module with the same name. It help encode to and decode from JSON....

A quick look at the json module in Python

Why how the data is collected matters

Aug 6, 20242 min read

I find that working with data daily significantly influences how you perceive the world around you. You begin to notice patterns and details you might...