Pandas for Productivity Vlog Ep2: Think like a data engineer!
Why this topic? When we join two flat files, or a flat file to a SQL query output in Python,
Mid-Career Tech
Join
Mid-Career Tech
Combine data sets by merging or concatenating
Have you ever tied up your computer for hours with a vlookup? Or laboriously copy pasted rows of .csv data
Mid-Career Tech
Subqueries and CTEs: Multi-step problems
As you progress, you’ll find situations where you need to combine more than one data pull to answer your question.
Mid-Career Tech
Your first SQL joins: reading the “FROM” clause
You’ve got a first query from your company, and you’re ready to start making sense of it. First of all,