TechPulseTechPulse
Back to News
Advertisement
Advertisement

⚡ Community Insights

Discussion Sentiment

75% Positive

Analyzed from 292 words in the discussion.

Trending Topics

#excel#python#data#pandas#outside#different#programming#always#corporates#financial

Discussion (6 Comments)Read Original on HackerNews

delis-thumbs-7e•16 minutes ago
Looking at the content, if you are familiar at all with Python and basic programming, this provides very little new. I sometimes have to stuff massive Excel-abominations with 50k+ rows and rip data I need out of them with Pandas, but it only requires reading Pandas documentation (which is very good) a bit.

But perhaps this might be good if you know no programming and want to make your life easier.

bluecomputing•14 minutes ago
Hey everyone — sharing a tool I've been building that tackles some of these issues in a clean, copy-paste way: https://zither-zeta.vercel.app/ Curious to hear what you think — feedback welcome!
Havoc•about 2 hours ago
These sort of things always seem to assume a fairly relaxed software environment.

In practice I’ve found the big corporates try hard to keep their excel files with financial data and their Python environments with pip & all those associated risks far apart. That’s if pip works at all & isn’t caught by a firewall

khurs•about 1 hour ago
Most corporates, last I knew, didn't use Python outside of IT. Devs outside of IT would be using VBA.

However in Financial companies, Python and Excel have always been used together by devs and also quants.

And they tend to use Anaconda, and also like all their other package managers, they would host an in-house package repository and block the public one. That way only approved packages are used, and they only update packages as needed.

Many though have a policy of minimising Excel and rolling out formal platforms whether in-house or off the shelf, as Excel is regarded as a ongoing risk of in-accuracy as full editable at all times, lack of git/version control and so on.

janlaureys•31 minutes ago
Been working on a dashboard that takes in a bunch of different public data sources in different formats and pandas has truly been a godsend for this.

I've got csv, txt, xlsx in all different shapes and sizes and with just a few settings I can go through them quite easily and very fast as well.

cm2187•24 minutes ago
Terrible title. Nothing to do with automating excel. From what I can tell it seems to be about ingesting spreadsheets into panda (and incredibly narrow use of Excel) and working outside of Excel.