What is your day job?
And if it’s bigger you probably ought to be using a different toolset than Python altogether.
In my experience it is exceedingly rare to find a situation where you have > 1M rows of data and need to do tabular data manipulation, and it’s not coming from a managed database sort of setup where the manipulation could be better done in the database.