• viking
    link
    fedilink
    arrow-up
    5
    ·
    edit-2
    7 months ago

    Yeah I was a bit surprised by the downvotes considering this is the windows community, but then again the Linux fanboys on Lemmy are a resilient bunch.

    Funny thing is that I’m using Linux (Xubuntu) as my daily driver, but switch to Windows for those two applications pretty much exclusively.

    I’ve yet to use Pandas / Polars, are they working well with macros/vbs and pivot tables, especially importing existing ones from excel? That was by biggest pain point with Calc.

    • fartsparkles@sh.itjust.works
      link
      fedilink
      arrow-up
      3
      ·
      7 months ago

      Pandas and Polars are libraries for the Python and Rust programming languages (respectively).

      The way I moved on from Excel was to write code instead since my end goal was always data visualization and there are so many good visualization libraries that offer far more than Excel could out of the box.

      It’s not for the faint of heart and you’ll have to reimplement the logic of all your macros but once you’re liberated, it’s exceptionally freeing - especially being able to handle vastly bigger datasets than Excel could handle.

      • viking
        link
        fedilink
        arrow-up
        1
        ·
        7 months ago

        Ah ok, understood. Unfortunately I’m not much of a programmer, I understand just enough of the syntax from macros to use them and make slight adjustments, not to rebuild them from scratch. So I somewhat rely on the tools that some with excel or have been developed in my company.