So much data, so little memory | pandas vs SQL Part 1
Sign up for DUTC Weekly: https://mailchi.mp/dutc/ytweekly
LinkedIn: / do-n-t-use-this-code
Website: https://www.dontusethiscode.com/index...
Upcoming events: learning.dutc.io
Looking for training? Contact [email protected]
This is part of the Confident Queries & Stronger SQL - pandas vs SQL series.
Do you…
only write simple SQL queries to perform analysis in pandas?
use pandas.read_sql to reduce your SQL query complexity?
wonder what analyses you can do in both SQL and pandas?
want to know when to stop writing SQL and start writing pandas code?
→ If so, join us for this session!
In this series, we discuss the pros and cons of using SQL over pandas (and vice versa) in order to best leverage their strengths. Moreover, we discuss features that make SQL unique and why it is one of the most popular choices for data persistence. We’ll present some data-driven problems and compare and contrast how they would be solved in pandas vs SQL. Finally, we discuss when you would want your analyses to rely on SQL or pandas.
Disclaimer: This session will include PostgreSQL-specific features & functionality that may not be present in other database products like MariaDB, MySQL, or SQLite.