this post was submitted on 16 Sep 2024
42 points (90.4% liked)

Python

6420 readers
31 users here now

Welcome to the Python community on the programming.dev Lemmy instance!

πŸ“… Events

PastNovember 2023

October 2023

July 2023

August 2023

September 2023

🐍 Python project:
πŸ’“ Python Community:
✨ Python Ecosystem:
🌌 Fediverse
Communities
Projects
Feeds

founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] GetOffMyLan 4 points 2 months ago (2 children)

Likely aimed at financial departments which often (in my experience) love to do everything in Excel.

[–] [email protected] 4 points 2 months ago (1 children)

Sometimes when IT only lets you hold a hammer, then by necessity everything looks like a nail.

[–] starshipwinepineapple 1 points 2 months ago

Right. VBA or this may not be the best tools for the job but when IT restricts what can be used then VBA or excel python could be great examples of Shadow IT.

[–] [email protected] 1 points 2 months ago

That's true, but how often have you heard a finance team member wanting a CSV file so they can more easily process the data using Pandas or visualize it with MatPlotLib? How many accountants or finance people (especially those that ask for everything in Excel) do you know that is comfortable writing even a single line of Python code? How many of the finance team's Excel-based tools will Python integrate well with? What feature(s) does Python within Excel provide that Excel (formulas, pivot tables, VBA, Power Query, Power Pivot, etc.) does not provide that someone on the finance team would need? What advanced charting/dashboarding functionality does Python in Excel provide that isn't better accomplished in PowerBI (if not handled by standard Excel charts/graphs)?

Don't get me wrong - Microsoft's implementation of Python in Excel has its merits and will solve some problems that otherwise would not be possible in Excel and will make some people happy. However, this is not the solution most people were expecting, asking for, or find useful.