433
submitted 11 months ago by throws_lemy@lemmy.nz to c/technology@lemmy.world
you are viewing a single comment's thread
view the rest of the comments
[-] driving_crooner@lemmy.eco.br 24 points 11 months ago

I'm migrating some VBAs to python/pandas and reducing some process times from half an hour to 3 minutes.

[-] AlmightySnoo@lemmy.world 19 points 11 months ago

Yup that's normal because VBA is single-threaded, doesn't take advantage of vector instructions and even its interpreter is slow. So when someone writes numerical code in VBA working in single precision, and assuming they have an 8 core CPU with AVX2, they're using only 1/64-th of their CPU's processing power. On the other hand with Python, while it's still interpreted, the interpreter is much faster on its own, and you have modules like numpy that use precompiled routines that take advantage of vector instructions (and possibly multiple cores).

[-] Melkath@kbin.social 5 points 11 months ago

Yes. Python is a LOT more powerful. Requires a LOT technical knowledge to operate.

Are you making north of 150k to make your strife worth it?

Or are you raising the technical bar while also lowering the compensation bar?

Myself, I make 60k and my VBA gets the job done. Zero incentive to get into the minutia you just explained. My shit works. And I'm not set on fucking up the bell curve for everyone.

[-] AlmightySnoo@lemmy.world 3 points 11 months ago

I don't know what your seniority is, but it's cool if it works for you. However, to remain employable in case you someday get laid off (of course not wishing you that), it would be beneficial to have experience in a more modern language. To remain fixated on one single language/tech just because it works for you for now is going to cause you lots of pain in case you need to hit the job market again someday and it would be too late to learn new languages because, depending on your seniority again, recruiters won't want someone who just began learning the language.

[-] driving_crooner@lemmy.eco.br 3 points 11 months ago

Python is way easy lo learn that VBA imo, and is way more useful.

[-] MonkderZweite@feddit.ch 2 points 11 months ago

Btw, Libreoffice supports python scripts. Other offices too?

[-] lud@lemm.ee 2 points 11 months ago

Excel will kinda support it soon, unfortunately it will only be available to run in the cloud and not locally.

[-] driving_crooner@lemmy.eco.br 1 points 11 months ago

I work in corporate, so it's Microsoft all the way up.

this post was submitted on 11 Oct 2023
433 points (100.0% liked)

Technology

58221 readers
3265 users here now

This is a most excellent place for technology news and articles.


Our Rules


  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots


founded 1 year ago
MODERATORS