There are a lot of different solutions knocking around for running queries on one or more CSV files. This is a web-based notebook that prioritizes loading large files quickly so you can get running queries on them as soon as possible. It supports most text files, Excel files, JSON. It can also display your results as graphs.
This is really wonderful! The discussion about lay people's knowledge of sql reminded me that the Pandas API is often useful for non-sql folk. Likewise there are some projects similar to dirtylittlesql to bring Python data manipulation to the browser.<p><a href="https://github.com/jtpio/jupyterlite" rel="nofollow">https://github.com/jtpio/jupyterlite</a><p><a href="https://github.com/gzuidhof/starboard-notebook" rel="nofollow">https://github.com/gzuidhof/starboard-notebook</a>
Also worth a look, built as a static web spa<p><a href="https://github.com/lana-k/sqliteviz" rel="nofollow">https://github.com/lana-k/sqliteviz</a>
What would be cool is integrating this with OpenAI Codex - the natural language to SQL transformations were impressive when I played around with them.<p>This could then be pitched to non-techie folk who want to simply ask questions from their data on flat file.
Love it!
Could you also provide some options for decimal point data?
Comma instead of period.<p>It would be great if I could use it as a kernel in JupyterLite!