Google Research group has introduced the launch of Gemini-SQL2 on X. They described this method as a breakthrough text-to-SQL functionality powered by Gemini 3.1 Pro. Gemini-SQL2 posted 80.04% execution accuracy on the BIRD Text-to-SQL Leaderboard (Single Model). Google’s chart locations it above its personal Gemini-SQL, the prior high entry. The metric measures whether or not…
In this tutorial, we build an end-to-end cognitive complexity analysis workflow using complexipy. We start by measuring complexity directly from raw code strings, then scale the same analysis to individual files and an entire project directory. Along the way, we generate machine-readable reports, normalize them into structured DataFrames, and visualize complexity distributions to understand how…
Schemas, and Composable DataFrame ContractsIn this tutorial, we demonstrate how to build robust, production-grade data validation pipelines using Pandera with typed DataFrame models. We start by simulating realistic, imperfect transactional data and progressively enforce strict schema constraints, column-level rules, and cross-column business logic using declarative checks. We show how lazy validation helps us surface multiple…
Vizro is an open-source Python toolkit by McKinsey that makes it easy to build beautiful, production-ready data visualization apps. With just a few lines of configuration (via JSON, YAML, or Python dictionaries), you can create multi-page dashboards that would normally take thousands of lines of code. Built on top of Plotly, Dash, and Pydantic, Vizro…