machow/siuba

Health v2 · maintenance only

Adoption not part of the score

1183 stars · 54 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

siuba is a Python library that ports R's dplyr syntax to pandas DataFrames and SQL databases, using pipe (>>) chaining and lazy expressions. The same analysis code runs on local DataFrames or generates SQL queries against backends like postgres, sqlite, duckdb, and snowflake.

Use cases

• analyze pandas dataframes with dplyr-style verbs
• write data analysis code that runs on both pandas and SQL
• generate SQL queries from Python expressions
• group and summarize tabular data with a concise pipe syntax
• port R dplyr workflows to Python
• avoid verbose pandas lambda syntax
• run the same analysis on a local dataframe and a remote database

When to choose

• you know dplyr and want similar ergonomics in Python
• you want one analysis codebase for pandas and SQL backends
• you find pandas method chaining with lambdas too verbose
• you need lazy SQL query generation from dataframe-style code

When to avoid

• you prefer idiomatic pandas or polars APIs
• you need a mature, widely-adopted tool with large ecosystem support
• your SQL backend is not among the supported dialects
• you need advanced pandas features outside siuba's verb set

Facets

library · maturity active

data-science etl database-driver data-science databases python cross-platform dplyr pandas sql dataframe tidyverse data-analysis sql-query-generation data-engineering

Member repositories

For agents

markdown · JSON · MCP: product_card(name="machow/siuba")