/hippotable

👩🏻‍🔬📊 Lightweight data analysis in your browser

Primary LanguageTypeScriptGNU General Public License v3.0GPL-3.0

Hippotable is a simple tool to work with data in the browser. Your data is never sent to a third-party server, protecting your privacy and saving bandwidth. All processing happens in-memory to ensure great performance and real-time feedback. Try it now at thoughtspile.github.io/hippotable

Features:

  • 📦 Open CSV files — tested with datasets up to 100 Mb.
  • 🚀 Clean and efficient UI lets you scroll though thousands of rows.
  • 🔎 Filter and sort your data without delay.
  • 👩‍🔬 Aggregate / groupby data to gain deeper insights.
  • 🏗️ Build powerful data pipelines with multiple filter / aggrefate steps.
  • 💾 Share results with CSV export.
  • 💯 Free and open-source.

Running locally

Clone this repository, then:

npm ci
npm run dev

Contributing

See CONTRIBUTING.md

Acknowledgements

Arquero provides the solid dataframe foundation — thanks to Jeffrey Heer and all the contributors!

SolidJS gives us the good developer experience with the performance of vanilla DOM — great work by Ryan Carniato and the team.

Last but not least, TanStack virtual by Tanner Linsley gives us powerful table virtualization — and is one of the few projects that support SolidJS.

Finos perspective, especially its datagrid component was a big influence on hippotable. Perspective has a more integrated design, while hippotable goes with a more modular setup, leveraging other open-source projects under the hood. Hippotable is also designed with multi-layer analysis (aggregate-filter-aggregate) in mind, and should eventually support operations spanning multiple tables.

License

GPLv3 License

Built in 2023 by Vladimir Klepov