• viking@infosec.pub
    link
    fedilink
    arrow-up
    0
    ·
    8 months ago

    Yeah I was a bit surprised by the downvotes considering this is the window 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
      0
      ·
      8 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.