From the course: Vibe Coding for Data Analysts
Join today to access over 25,200 courses taught by industry experts.
Merging data
From the course: Vibe Coding for Data Analysts
Merging data
- Vibes can come from so many places. Some of the most interesting tasks that you can work on, will involve data from multiple sources. Joining multiple data frames together, is one of the most fundamental aspects of Dataprep. It just so happens that we have a few data frame structures living in our environment. As we think about vibe coding through this joining process, we need to choose the keys and the type of join to use. As you look at the columns in these objects, you will see that we have one named "song_id". We'll probably want to use that to join the data frames together. Read in the "songs_personnel" feather and use pandas to left join the pldf, "first_table", "songs_df", and "song_personnel" objects together on the song_id variable and call the objects "song". This looks like it's worked. Let's keep it and try it out. "Song_personnel" reads in just fine. Our pollers data frame is converted to a pandas data frame. And now we can try the merge. And you'll notice we get a key…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.