> ## Documentation Index
> Fetch the complete documentation index at: https://cast.exakt.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Introduction

>  Cast is a lightweight, powerful utility. Designed to enable actuaries, data scientists, and pricing professionals to easily run analytical queries on local CSV and Parquet files.  Built on top of DuckDB, this tool allows users to leverage SQL-like queries for rapid exploration and analysis of their data without requiring a complex database setup. 

<img className="block dark:hidden" src="https://mintcdn.com/exakt/_6za0JqAICVAxhhk/images/cast.webp?fit=max&auto=format&n=_6za0JqAICVAxhhk&q=85&s=6643772212be373abd4ff784e68dc178" alt="Hero Light" width="1792" height="1024" data-path="images/cast.webp" />

<img className="hidden dark:block" src="https://mintcdn.com/exakt/_6za0JqAICVAxhhk/images/cast.webp?fit=max&auto=format&n=_6za0JqAICVAxhhk&q=85&s=6643772212be373abd4ff784e68dc178" alt="Hero Dark" width="1792" height="1024" data-path="images/cast.webp" />

### 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

<iframe width="560" height="400" src="https://www.youtube.com/embed/LZ2S2fCeslI" title="YouTube video player" frameBorder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen style={{ width: '100%', borderRadius: '0.5rem' }} />

The first step to world-class data processing and analysis is setting up your python environment and then to install the cast app.

<CardGroup cols={2}>
  <Card title="Installing Python" icon="python" href="installation/python">
    Follow the step by step process to install and setup python locally.
  </Card>

  <Card title="Installing Cast" icon="server" href="installation/cast">
    Install cast using your terminal.
  </Card>
</CardGroup>

## How to use Cast

View the detailed docs for each of the main functions within the Cast app.

<CardGroup cols={2}>
  <Card title="Query Editor" icon="code" href="essentials/query-editor">
    Write queries to your heart's desire.
  </Card>

  <Card title="One-way views" icon="chart-line" href="essentials/one-way-views">
    Generate simple one-way views of the queried data.
  </Card>

  <Card title="Data viewer" icon="magnifying-glass-chart" href="essentials/data-viewer">
    Build complex visualisations of the queried data.
  </Card>

  <Card title="Settings" icon="gear" href="essentials/settings">
    Configure your Cast setup.
  </Card>
</CardGroup>
