5 ms·
Why Pandas feels clunky when coming from R (2024)
- great_wubwub 1y agoI have no R experience but have been using Polars instead of Pandas for this sort of stuff and it feels less clunky. How does Polars compare to R?
- j_bum 1y agoI strongly prefer `dplyr` and the R stack for table processing and visualization. But, recently I’ve been working with much larger scale data than R can handle (thanks to R’s base int32 limitation) and have been needing to use Python instead. Polars feels much more intuitive and similar to `dplyr` to me for table processing than Pandas does. I often ask my LLM of choice to “translate this dplyr call to Polars” as I’ve been learning the Polars syntax.
- aydyn 1y agoIt blows my mind that in 2025 R is still limited to 2^31-1 rows. R needs a Python 3.0 moment, but that is unfortunately not going to happen for certain unfortunate but unnecessary reasons.
- j_bum 1y agoYep. I have a deep love/hate relationship with R. This is one of those decisions that I just do not understand. In your mind, why do you imagine a set of improvements won’t be made? Otherwise, for now, working with Python and R using the reticulate package in Quarto is perfect for my needs. If the Positron IDE could get in-line plot visualization in Quarto documents like the RStudio IDE has, I’d be the happiest camper.
- BDPW 1y agoI've had a similar experience from the opposite side. I've had quite a few years of experience in Python and had to work in R for an internship during my masters. My impression was that it's pretty easy to do straightforward things like the examples described in the article. But when you have to do complicated or unusual things with your data I found it very frustrating to work with. Access to the underlying data was often opague and it was difficult to me at times to figure out what was happening under the hood. Does anyone here know any research areas still using R?
- Tomte 1y agoEveryone in statistics, and lots of people applying statistics in other disciplines (anthropology etc.).
- j_bum 1y agoIn addition to stats, R is widely used in computational biology and bioinformatics domains. It’s also widely used in the biopharma industry for a variety of other purposes.
- mauritsd 1y agoIME (bioinformatics PhD in the netherlands a number of years ago) it's mostly still preferred in a (pre-)clinical context, not so much in academia itself
- kgwgk 1y ago> My impression was that it's pretty easy to do straightforward things like the examples described in the article. But when you have to do complicated or unusual things with your data I found it very frustrating to work with. That's where I realised that the "modern" approach was taken in the article - which obviously I had not looked at.
- pteetor 1y agoR is used extensively in quant finance. The quant traders, portfolio managers, and risk managers with whom I work all use R.
- dkdcio 1y agopandas* per the style guide (nobody follows it) also I recommend trying Ibis. created by the creator of pandas originally and solves so many of the issues https://ibis-project.org https://ibis-project.org
- jna_sh 1y agoAny thoughts on ibis vs polars?
- gnulinux 1y agoDisclaimer: Never used Ibis before but I daily use polars and DuckDB. It seems like Ibis uses DuckDB on its backend (by default) and has Polars support as well. Given this, maybe see if Ibis works better for you than polars. If you very specifically need polars, using that will for sure be better. DuckDB is faster than polars and it has great polars support, so depending on how Ibis is implemented it might be "better" than polars as data frame lib.
- orlp 1y ago> DuckDB is faster than polars Whether or not DuckDB is faster than Polars depends on the query and data size. I've spent a large portion of the last 2 years building a new execution engine for and optimizing Polars, and it shows: https://pola.rs/posts/benchmarks/ https://pola.rs/posts/benchmarks/.
- dkdcio 1y agothe Polars benchmarking is always so unserious and biased
- Vaslo 1y agoThere is also Nahwhals. https://pypi.org/project/narwhals/#description https://pypi.org/project/narwhals/#description I tried really hard to use Ibis but I ran into issues where it was way easier to do some stuff in pandas/polars and had to keep coming out of Ibis to make it work so I gave up on it for the time being.
- dleather 1y agoI couldn't agree more. I'm fluent in languages like Julia, and MATLAB. I'm 90% fluent in R and prefer data.table over dplyr but working in both is easy enough. The past few months I've been fully transitioning to Python. And while base Python I find to be extremely elegant, typical data science and scientific computing workflows are a headache. There aren't just 1-2 packages to choose from for each use, every package has it's own syntax, keeping track of Pandas Series vs DataFrames is confusion. Want fast differentiable code? Then rewrite everything in numpy in JAX which requires its own tricks. What Python desperately needs is a coordinated effort for a core data science /scientific computing stack with a unified framework. In my opinion, if it weren't for Python's extensive use in Industry and package ecosystem, Julia would be the language of choice for nearly all data science and scientific computing uses.
- hatmatrix 1y ago> And while base Python I find to be extremely elegant, typical data science and scientific computing workflows are a headache. That's my impression as well. Going back to the topic of the original post, pandas only partially implements the idioms of the tidyverse so you have to mix in a lot of different forms of syntax (with lambdas to boot) go get things done. Julia is much nicer, but I find myself using PythonCall more often than I'd like. Scipy was originally supposed to provide the scientific computing stack, but then many offshoots in the direction of pandas / ibis / JAX, etc. happened. I guess that's what you get with a community-based language. MATLAB has its warts but MathWorks does manage to present a coherent stack on that end.
- rich_sasha 1y ago> What Python desperately needs is a coordinated effort for a core data science /scientific computing stack with a unified framework. In fairness, if you're not touching Pandas, it's pretty good I'd say. Everything is based around numpy and scipy. Sklearn API is a bit idiosyncratic but works really nicely in practice and is extensible. JAX has an API which is 1:1 equivalent to numpy, probably with some catches but still. All the trouble starts with pandas. Pandas is pretty terrible IMO for all the reasons listed by OP and TFA - and more.
- wodenokoto 1y agoA really, really big part of this is thanks to RStudio, which, when you run a line and write a line will peek into memory to see what the columns in your dataframe is and understand the dplyr DSL to help you auto complete what essentially is non-existing variables.
- smabie 1y agoThe original sin of Pandas is row indices
- emehex 1y agoI haven't seriously used R in nearly a decade but I still miss (and think about) dpylr and the hadleyverse... A few years ago I made a package called "redframes" that tried to "solve" all of my frustrations with pandas, make data wrangling feel more like R, while retaining all the best bits of Python... Alas, it never really took off. For those curious: https://github.com/maxhumber/redframes https://github.com/maxhumber/redframes
- hatmatrix 1y agoHey this looks pretty tidy. There is so much hype and luck to widespread adoption, you never know with these things.
- doctaj 1y agoAgreed! I started out doing data analysis in R… switched to Python because it was more multi-purpose at the time (ie: data engineering, analysis, and model deployment)… and I think about it and miss it so often.
- __mharrison__ 1y agoLots of readers of my book, Effective Pandas, say it helps them feel more like they are used to with R... (I've never used R myself, but certainly have some very strong opinions about Pandas after having written 3 books about it.)
- ivansavz 1y agoHi Matt! Big fan. The first that I thought when I read this article was "How would Matt use his .assign-chain-kung-fu on this one" and I tried import pandas as pd purchases = pd.read_csv("https://www.sumsar.net/blog/pandas-feels-clunky-when-coming-from-r/purchases.csv") (purchases .assign(country_median=lambda df: df.groupby("country")["amount"].transform("median") ) .query("amount <= country_median * 10") .groupby("country") .assign(total=lambda df: (df["amount"] - df["discount"]).sum()) ) but it seems 'DataFrameGroupBy' object has no attribute 'assign' so its not that simple, though with a slight re-ordering of the chain operations, it works cf. https://news.ycombinator.com/item?id=44236487 https://news.ycombinator.com/item?id=44236487
- btown 1y agoIf you're looking for the analytics-world version of this "I wish I had real pipelines rather than dot notation" sentiment, I highly recommend checking out Malloy: https://www.malloydata.dev/ https://www.malloydata.dev/ It's a domain-specific language that makes pipelining a first-class citizen and compiles into various flavors of SQL... but it's also a fully-fleshed out VS Code environment that dynamically checks typing based on live DB schemas, and lets you represent your entire semantic layer in incredibly terse code with type hints and error bars. It's being actively developed and was founded by the former founder of Looker. While it's still experimental, it's very usable, particularly if you export the compiled SQL into other BI tools, and visualization tools are being developed incredibly rapidly.
- ryan-duve 1y agoI wonder if the author would have thought Pandas feels less clunky if they knew about `.eval`? import pandas as pd purchases = pd.read_csv("purchases.csv") ( purchases.loc[ lambda x: x["amount"] < 10 * x.groupby("country")["amount"].transform("median") ] .eval("total=amount-discount") .groupby("country")["total"] .sum() )
- ivansavz 1y agoOr with and .assign: ( purchases.loc[ lambda x: x["amount"] < 10 * x.groupby("country")["amount"].transform("median") ] .assign(total=lambda df: df["amount"] - df["discount"]) .groupby("country")["total"] .sum() .reset_index() # to produce a DataFrame result )
- interiormut 1y ago``` library(data.table) purchases[amount <= median(amount)*10][, .(total = sum(amount - discount)), by = .(country)][order(country)] ``` - no quotes needed - no loc needed - only 1 groupby needed
- bbstats 1y agoJust say you're bad at pandas
- JohnKemeny 1y agoDiscussed previously Feb 22, 2024, 71 points, 25 comments: https://news.ycombinator.com/item?id=39468737 https://news.ycombinator.com/item?id=39468737 Feb 20, 2024, 20 points, 6 comments: https://news.ycombinator.com/item?id=39438491 https://news.ycombinator.com/item?id=39438491
- interiormut 1y agoAs a long-time R user, I truly miss the elegance of `data.table` and base R in general. Today, I mostly write in Rust and Python. But R just feels elegant and purposeful. I force myself to avoid R these days though because that's the aesthetic of other people (who only see beauty when they look at python) and paying R roles are scarce. I will say that Python has the `datatable` package by H2o that is close to R's `data.table` in elegance. I wish it had the widespread adoption that Pandas enjoys. https://datatable.readthedocs.io/en https://datatable.readthedocs.io/en