Hacker News new | ask | show | jobs
by F_J_H 1923 days ago
For me it's SQL and then simply visualizing.
1 comments
aarondia 1923 days ago
As a bit of background on Mito, it works by passing the parameters from the frontend spreadsheet to the Python kernel backend, which transpiles the spreadsheet formula into Python/Pandas code [0]. So what we're hoping to do down the line is let the user pick which language to translate to, SQL and R being the obvious next steps. But that's a ways away :)

[0] https://trymito.io/blog/transpiler

link
fifilura 1923 days ago
The problem with SQL is that it is not great with pivoting. But maybe that is not a big problem when you auto-generate the SQL.

I agree, SQL is what I like more for mangling. Except for the pivot/melt part that is

link