Live data from Hacker News

Pandas Exercises for Data Analysis (Interactive)

machinelearningplus.com

11–20 of 35 posts

Re: Pandas Exercises for Data Analysis (Interactive)

#11
post #4

Dope. I've just started using Pandas in some personal projects, and am quickly hitting my knowledge ceiling. I think this will be useful. I'll check it out properly after work.

You should check out the Modern Pandas series by Tom Augspurger, it’s well worth reading to get clean modern style code. https://tomaugspurger.net/posts/modern-1-intro/

Thanks. There's a special place in my heart for any blog that opens with 'Prior Work' :)

Re: Pandas Exercises for Data Analysis (Interactive)

#12
post #8
post #4

Dope. I've just started using Pandas in some personal projects, and am quickly hitting my knowledge ceiling. I think this will be useful. I'll check it out properly after work.

If I were investing effort into acquiring knowledge in this domain, I'd skip straight to Polars. Before I made the switch, I had been using Pandas on and off for more than a decade. I'm not sure how representative this is, but most of the people I know who were Pandas users have also made this switch. I initially did it for the performance improvements but the API (according to my subjective opinion) is much more log…

Thanks, I'll look into this in the future. I don't need the most performant script, but this could change.

Re: Pandas Exercises for Data Analysis (Interactive)

#13
post #12
post #8

Earlier quoted context omitted.

If I were investing effort into acquiring knowledge in this domain, I'd skip straight to Polars. Before I made the switch, I had been using Pandas on and off for more than a decade. I'm not sure how representative this is, but most of the people I know who were Pandas users have also made this switch. I initially did it for the performance improvements but the API (according to my subjective opinion) is much more log…

Thanks, I'll look into this in the future. I don't need the most performant script, but this could change.

It's less about performance and more about ecosystem lockin. It's a bit like imperial vs metric units. Why would you ever chose to learn imperial if you had the option to only ever use metric to begin with?

Re: Pandas Exercises for Data Analysis (Interactive)

#14
post #13
post #12

Earlier quoted context omitted.

Thanks, I'll look into this in the future. I don't need the most performant script, but this could change.

It's less about performance and more about ecosystem lockin. It's a bit like imperial vs metric units. Why would you ever chose to learn imperial if you had the option to only ever use metric to begin with?

Because these are silly personal scripts. I'm not going to make sensible architectural decisions on something I run every now and then on my laptop. That's optimising too early.

Re: Pandas Exercises for Data Analysis (Interactive)

#15
post #8
post #4

Dope. I've just started using Pandas in some personal projects, and am quickly hitting my knowledge ceiling. I think this will be useful. I'll check it out properly after work.

If I were investing effort into acquiring knowledge in this domain, I'd skip straight to Polars. Before I made the switch, I had been using Pandas on and off for more than a decade. I'm not sure how representative this is, but most of the people I know who were Pandas users have also made this switch. I initially did it for the performance improvements but the API (according to my subjective opinion) is much more log…

I'd second this, especially if its just for personal use!

The data world owes a lot to pandas, but it has plenty of sharp edges and using it can sometimes involve pretty close knowledge of how things like indexing/slicing/etc work under the hood.

If I get stuck in polars, its almost always just a "what's the name of the function to use?" type problem rather than needing lots of knowledge about how things are working under the hood.

Re: Pandas Exercises for Data Analysis (Interactive)

#16
post #13
post #12

Earlier quoted context omitted.

Thanks, I'll look into this in the future. I don't need the most performant script, but this could change.

It's less about performance and more about ecosystem lockin. It's a bit like imperial vs metric units. Why would you ever chose to learn imperial if you had the option to only ever use metric to begin with?

For short scripts and interactive research work, pandas is still much better than polars. Polars works well when you know what you want.

When you are still figuring out things step by step, pandas does a lot of heavy lifting for you so you don't have to think about it.

E.g. I don't have to think about timeseries alignment, pandas handles that for me implicitly because dataframes can be indexed by timestamps. Polars has timeseries support, but I need to write a paragraph of extra code to deal with it.

Re: Pandas Exercises for Data Analysis (Interactive)

#17
post #13
post #12

Earlier quoted context omitted.

Thanks, I'll look into this in the future. I don't need the most performant script, but this could change.

It's less about performance and more about ecosystem lockin. It's a bit like imperial vs metric units. Why would you ever chose to learn imperial if you had the option to only ever use metric to begin with?

That's exactly why I am reluctant to do anything with Polars. They are actively running a company and trying to sell a product. At any point they could be acquired and change the license for new releases. Sure you could fork it, or stay on an older version, but if what they offer isn't compelling enough for you then why take the risk?

Pandas on the other hand has been open source for almost two decades, and is supported by many companies. They have a governance board, and an active community. The risk of it going off the rails into corporate nonsense is much lower.

Re: Pandas Exercises for Data Analysis (Interactive)

#18
post #8

Earlier quoted context omitted.

If I were investing effort into acquiring knowledge in this domain, I'd skip straight to Polars. Before I made the switch, I had been using Pandas on and off for more than a decade. I'm not sure how representative this is, but most of the people I know who were Pandas users have also made this switch. I initially did it for the performance improvements but the API (according to my subjective opinion) is much more log…

I'd second this, especially if its just for personal use! The data world owes a lot to pandas, but it has plenty of sharp edges and using it can sometimes involve pretty close knowledge of how things like indexing/slicing/etc work under the hood. If I get stuck in polars, its almost always just a "what's the name of the function to use?" type problem rather than needing lots of knowledge about how things are working…

Ehhh, there are still plenty of pandas idioms for which there is only a clunky polars equivalent. Sure, I like the strictness of polars, but it is missing some day-to-day functionality. Which might never change - the polars team is trying to be disciplined about having a consistent and performant API, which does mean some functionality may be left behind.

Re: Pandas Exercises for Data Analysis (Interactive)

#19
post #8
post #4

Dope. I've just started using Pandas in some personal projects, and am quickly hitting my knowledge ceiling. I think this will be useful. I'll check it out properly after work.

If I were investing effort into acquiring knowledge in this domain, I'd skip straight to Polars. Before I made the switch, I had been using Pandas on and off for more than a decade. I'm not sure how representative this is, but most of the people I know who were Pandas users have also made this switch. I initially did it for the performance improvements but the API (according to my subjective opinion) is much more log…

DuckDB and SQL FTW.

Re: Pandas Exercises for Data Analysis (Interactive)

#20
Pandas is terrific, yet even its original author has noted inherent shortcomings [1], and there exist alternatives.

Polars seems to be the most prominent competitor in the Python DataFrame space, and DuckDB appears to pursue an approach similar to SQLite, but columnar.

I am personally working on a solution to a broader problem, which can also be viewed as an alternative to Pandas [2].

[1] https://wesmckinney.com/blog/apache-arrow-pandas-internals/

[2] https://github.com/ronfriedhaber/autark

Post reply on HN