| 📅 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
Full Article:
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
Full Article:
| ☕️ 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
