News for hackers. Stuff that matters.
Re:Excel Never Dies by aarondia on Monday March 08, 2021 @02:10PM (#26390108)
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

Re:Excel Never Dies by fifilura on Monday March 08, 2021 @02:40PM (#26390507)
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