this post was submitted on 12 Apr 2024
81 points (96.6% liked)

Windows

403 readers
13 users here now

For all things Windows.

founded 3 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] viking@infosec.pub 5 points 7 months ago* (last edited 7 months ago) (1 children)

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 3 points 7 months ago (1 children)

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@infosec.pub 1 points 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.