In all courses, the focus is mainly on building models from an already clean dataset that is in a csv file.
If I have a database, Postgres, with a table that has ~10 million rows, what is the best way to export it to do exploratory data analysis (EDA)?
I can export it to a csv (only 1 million rows), but is that the optimal way? How are databases usually used when doing EDA and building models, when dealing with millions of records?
Any resources to read on this topic or suggestions are appreciated.