📅 Today’s Picks

Query Nested JSON with DuckDB SQL Dot Notation

Problem

Working with nested JSON structures requires complex normalization steps in pandas before analysis.

Solution

DuckDB automatically flattens nested JSON files and allows direct querying of nested fields with dot notation.

Other key benefits:

• High-performance columnar engine for analytical workloads
• Zero external dependencies – embedded database design
• Native support for Parquet, CSV, JSON without data movement
• Direct integration with pandas, NumPy, and Arrow format

Gradio: Turn Python Functions into Interactive AI Demos

Problem

You built an AI model that works well for your use case in your notebook. But how do you demo it to stakeholders?

Your stakeholders expect clickable demos, not code snippets, but building web interfaces requires frontend expertise you don’t have.

Solution

With Gradio, you can create professional chat interfaces with just 10 lines of code.

Key benefits:

• Instant UI generation from Python functions
• Zero frontend coding required
• Share live demos with URL links without any deployment

☕️ Weekly Finds

presidio [Data Processing] – Context aware, pluggable and customizable PII de-identification service for text and images

testcontainers-python [Python Utils] – Python library providing a friendly API to run Docker containers for functional and integration testing

shapash [ML] – Python library dedicated to the interpretability of Data Science models with explicit visualization labels

Looking for a specific tool? Explore 70+ Python tools →