Recap and case study
1. Recap and case study
Well done! We covered a lot of ground in this course! Let’s briefly review what you’ve learned and prepare for one final challenge.2. Chapter 1 - Introduction to joining data
In chapter 1, you learned about the importance of joining data in the real world. As someone who has likely worked with data in a spreadsheet environment, this served as a good review of common situations that arise. You used pandas to join data from the National Football League using pandas concat. And you learned that pandas’ scalability, efficiency, and integration with the Python environment make it a powerful tool.3. Chapter 2 - VLOOKUP-style joins
In chapter 2, you learned how to combine two or more datasets with a one-to-one relationship. You used the pandas merge function to create a VLOOKUP-style join. Again, your knowledge of spreadsheets was probably useful here as the VLOOKUP formula provides a solid understanding of what happens during a pandas merge operation.4. Chapter 3- One-to-many joins
In Chapter 3, you expanded your skills by practicing the one-to-many join. You joined data frames on key columns with pandas data frame merge, and on index with pandas data frame join.5. Chapter 4 - Advanced joins
Finally, in Chapter 4 you tackled advanced joining techniques that occur in real life. You learned how to use the advanced parameters for merge statements when mixing data frames with different structures or when needing to track data origin. You also learned how to join ordered data such as time series with pandas merge ordered and pandas merge asof.6. Thank you!
I hope you find these methods to be valuable in the days ahead. Now, it’s time for one last challenge as you complete the course. Thank you, and best wishes!Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.