tidypolars VS redframes

I recommend trying tidypolars

There’s a tidypolars package that appears to be well-maintained https://github.com/markfairbanks/tidypolars

tidypolars is one I’ve seen. Still very new, but it’s built on top of polars (which is a little more like dplyr to begin with), so it’s much faster than pandas.

If I misunderstood your question - feel free to open a discussion with a small code example and we can talk through how you can do it in tidypolars.

Try out tidypolars. It's really close to tidyverse syntax and it's a lot faster than pandas as well

I'm not GP, but I find the pandas API incredibly inconsistent and difficult to remember how to do simple transformations. For example, it sometimes overloads operators because it doesn't use built in language features like lambdas. There are reasons for the inconsistency, but using the alternatives like R's tidyverse or Julia's DataFramess.jl is like night and day for me.

I found RedFrames [1] recently which wraps Pandas dataframes with a more consistent interface, it's probably what I'd use if I had to write data transformations that had to be compatible with Pandas.

[1] https://github.com/maxhumber/redframes

[2022-10-23 14:11:15]: Question []: should we use Red Frames (https://github.com/maxhumber/redframes) in addition to Pandas? Criteria for decision? @me #projectLion

If you like writing chain-able pandas, you should check out: https://github.com/maxhumber/redframes

I intend to use this pattern in my redframes library to hijack some pd.DataFrame methods.

I'm dog-fooding my new Python data manipulation library, redframes: https://github.com/maxhumber/redframes

To help me prep for my Fantasy Hockey Draft next week!