---

📅 Today’s Picks

Delta Lake: Insert + Update in One Operation

Problem

In pandas, implementing upserts means running 3 separate operations: filter existing records, update matches, and append new ones.

Each step requires a full data scan, increasing both code complexity and execution time.

Solution

Delta Lake’s MERGE replaces this 3-step process with a single transaction that updates existing records and inserts new ones.

How it works:

• Compares source data with existing table records
• Updates matching records with new values
• Inserts records that don’t exist yet
• Executes all changes together with automatic rollback if any step fails

---

☕️ Weekly Finds

Boruta-Shap [ML] – A tree-based feature selection tool combining the Boruta algorithm with SHAP values to identify the most important features for machine learning models.

a2a-python [LLM] – Official Python SDK for building agentic applications as A2A Servers following the Agent2Agent Protocol, with async support and optional integrations.

respx [Python Utils] – A Python library for mocking HTTPX and HTTP Core with request pattern matching and customizable response side effects for testing purposes.

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

---