• raspberriesareyummy@lemmy.world
    link
    fedilink
    arrow-up
    12
    arrow-down
    2
    ·
    2 months ago

    But, if you’re a power user doing a lot of complex data analytics, Excel is still the king.

    Only if you refuse to learn SQL and do everything in a fraction of the time with way more functionality.

      • GissaMittJobb@lemmy.ml
        link
        fedilink
        arrow-up
        6
        ·
        2 months ago

        Not saying there’s any reason to switch, but I believe you can load CSV’s into sqlite.

        Datasette would be something that I would try for CSV’s as well, that seems like an interesting piece of technology I haven’t had reason to use yet.

        Finally there’s always Jupiter Notebook and any respectable DataFrame-solution.

        Not to knock spreadsheet-solutions too much - I certainly see their value and use them frequently - but if I had to do something that warranted writing VBA, I’d probably reach for a tool I could combine with some form of VCS like Git at least.