3 ms·
The point is that if you only need to join and aggregate data it's easier and more efficient to do it directly in SQL. Also in production or when your database
by tarsinge 5y ago
The point is that if you only need to join and aggregate data it's easier and more efficient to do it directly in SQL. Also in production or when your database doesn't fit in memory the idea is to first use SQL to generate an optimized view of your data from the database before further analysis and transformation.
- jstrong 5y ago> The point is that if you only need to join and aggregate data it's easier and more efficient to do it directly in SQL citation needed? I've seen plenty of cases where it would have taken the db ages to do something that pandas does fast, and I don't consider pandas to be particularly fast.
- tarsinge 5y agoTFA