I feel the same. The closest to tidyverse in Python I've seen is siuba, a neat wrapper around pandas. Tidypolars is great too.

Lately, I've used DuckDB to write SQL that manipulates pandas data frames.