{"repo":"manzt/quak","free":true,"listed":false,"github":"https://github.com/manzt/quak","clone":"git clone https://github.com/manzt/quak.git","description":"a scalable data profiler","language":"TypeScript","stars":409,"topics":["database","dataframe","jupyter","python","visualization"],"license":"MIT","category":"databases-storage","readme_excerpt":"quak /kwæk/ an anywidget for data that talks like a duck quak is a scalable data profiler for quickly scanning large tables, capturing interactions as executable SQL queries. - interactive 🖱️ mouse over column summaries, cross-filter, sort, and slice rows. - fast ⚡ built with Mosaic; views are expressed as SQL queries lazily executed by DuckDB. - flexible 🔄 supports many data types and formats via Apache Arrow, the dataframe interchange protocol, and the Arrow PyCapsule Interface. - reproducible 📓 a UI for building complex SQL queries; materialize views in the kernel for further analysis. install usage The easiest way to get started with quak is using the IPython cell magic. quak hooks into Jupyter's display mechanism to automatically render any dataframe-like object (implementing the Python dataframe interchange protocol or Arrow PyCapsule Interface) using quak.Widget instead of the default display. Alternatively, you can use quak.Widget directly: interacting with the data quak captures all user interactions as queries . At any point, table state can be accessed as SQL, which for convenience can be executed in the kernel to materialize the view for further analysis: By representing UI state as SQL, quak makes it easy to generate complex queries via interactions that would be challenging to write manually, while keeping them reproducible. using quak in marimo quak can also be used in marimo notebooks, which provide out-of-the-box support for anywidget: contributing Contrib","default_branch":null,"files":null,"tree":[],"storefront":"/r/manzt","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/manzt/quak/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}