Selecting, filtering, and sorting data
Introduction
The Python Pandas library and SQL are both popular tools for manipulating data and have a lot of overlap in their functionality. So, what better way to improve your skill at both than to put Pandas and SQL head-to-head by working through the same coding problems for each?
This is the first of a series of articles I will write to help you directly compare Pandas and SQL. My goal is to help you:
- Learn and compare functionality
- If you already know one, then to learn the other
- Understand the strengths and weaknesses of each
- Have multiple tools for manipulating data
For the examples here I will use the infamous Titanic dataset that can be found on Kaggle. I encourage you to look at it while going through this article so you can follow along. At the end, I will present some practice problems for you to work through on your own based on the specific functionality discussed in this article.
#programming #sql #pandas #data-science
