From the course: Fundamentals of Data Transformation for Data Engineering
Unlock the full course today
Join today to access over 25,200 courses taught by industry experts.
DataFrame basics - SQL Tutorial
From the course: Fundamentals of Data Transformation for Data Engineering
DataFrame basics
- [Instructor] So welcome back. You've completed our first lesson on SQL, and now we're jumping into data transformation with Python and pandas, specifically the pandas library. And in this video, we'll talk a little bit about how our lessons are structured, which should be familiar with you, how to interact with the notebooks, slightly different for Python, but if you've used pandas before, this should be pretty straightforward, how to tinker with the data, and then give a first lesson introduction. And this lesson is going to follow largely from the last lesson. So the structure will be very similar in that we're going to cover different methods of data transformation with Python and pandas that we just covered with SQL. And the goal is to give you really a direct comparison for how to perform the same operations in pandas that you would with SQL. And hopefully from that, my goal is for you to take away when it…
Contents
-
-
-
-
-
(Locked)
DataFrame basics6m 14s
-
(Locked)
Wrangling unstructured data13m 41s
-
(Locked)
Select and filter10m 49s
-
(Locked)
Order and aggregate9m 47s
-
(Locked)
Advanced filters3m 53s
-
(Locked)
Data generation6m 37s
-
(Locked)
Windows5m 26s
-
(Locked)
Apply6m 14s
-
(Locked)
pandas challenge2m
-
(Locked)
pandas solution12m 45s
-
(Locked)
-