Features
Query Local Files: Run SQL queries directly on CSV and Parquet files stored locally. Ease of Use: Simple streamlit webapp to run and manage your queries on. Blazing Fast Analytics: Powered by DuckDB, optimised for analytical queries on large datasets. Lightweight: No database setup or configuration required—just point to your files and start querying. Extensibility: Designed for pricing and actuarial workflows but flexible enough for general-purpose analytics.Who Should Use Cast?
This tool is perfect for: Actuaries: Quickly explore insurance data, summarise portfolios, and validate assumptions. Data Scientists: Perform ad-hoc analysis on datasets without loading them into a database. Pricing Professionals: Join, clean and analyze datasets that can be used in your pricing models.Setting up
The first step to world-class data processing and analysis is setting up your python environment and then to install the cast app.
Installing Python
Follow the step by step process to install and setup python locally.
Installing Cast
Install cast using your terminal.
How to use Cast
View the detailed docs for each of the main functions within the Cast app.Query Editor
Write queries to your heart’s desire.
One-way views
Generate simple one-way views of the queried data.
Data viewer
Build complex visualisations of the queried data.
Settings
Configure your Cast setup.