A Comprehensive SQL to Pandas dictionary
Introduction
What makes SQL so amazing is that it’s so easy to learn — the reason why it’s so easy to learn is that the code syntax is so intuitive.
Pandas on the other hand isn’t so intuitive, especially if you started out with SQL first like I did.
Personally, what I found really helpful was thinking about how I would manipulate my data in SQL, and then replicate it in Pandas. And so, if you’re trying to be more proficient in Pandas, I highly recommend that you take this approach as well.
Thus, this article serves as a cheatsheet, dictionary, a guide, whatever you want to call it so that you can refer to this when using Pandas.
And with that said, let’s dive into it!
Table of Content
- Selecting Rows
- Combining tables
- Filtering tables
- Sorting values
- Aggregate functions
#machine-learning #data-science #programming #pandas #sql
