Merging Data from Different Sources in Python

Focused View

Rudi Bruchez

46:09

72 View

1. Course Overview

1. Course Overview.mp4

01:35

2. Introduction to Data Merging and Concatenation

1. Introduction to Data Merging and Concatenation.mp4

02:53

2. Understanding Difference between Concatenation and Merge.mp4

04:58

3. Discovering the Example Dataset and Uur Programming Environment.mp4

04:20

4. Using the concat Function in Pandas for Concatenation.mp4

04:17

5. Module Summary.mp4

01:15

3. Implementing Joins with pd.merge()

1. Understanding the Pandas Merge Function and Join Cardinality.mp4

03:06

2. Performing One-to-one and One-to-many Merges.mp4

05:00

3. Performing Inner and Outer Joins.mp4

06:22

4. Managing Merge Keys with the on Parameter.mp4

04:21

5. Projecting Columns.mp4

04:35

6. Merging on DataFrames Indices.mp4

03:27

Description

Unlock the power of pandas and master data merging in Python! Discover join types, merge key specs, and advanced techniques to solve real-world problems.

What You'll Learn?

Combining data from various sources is crucial for data professionals to extract valuable insights.

In this course, Merging Data from Different Sources in Python, you'll learn the techniques to merge and concatenate diverse data sets seamlessly using pandas.

First, you'll delve into concatenation with pandas' concat() and append() functions.

Next, you'll explore different types of joins, such as one-to-one, many-to-one, and many-to-many, using the pd.merge() function.

Finally, you'll learn how to handle non-matching column names, merge with indices, and resolve overlapping column names using advanced merging strategies.

When you finish this course, you'll have the skills and knowledge needed to effectively combine data from diverse sources in Python, facilitating more comprehensive data analysis.

Software required: Python 3.x and pandas library.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Rudi Bruchez

Instructor's Courses

Rudi Bruchez is a freelance consultant and trainer based in Paris, France. He has more than 15 years of experience with SQL Server and started to venture into NoSQL territories. He worked first as a developer and started as a DBA in 2001, in Switzerland at MSC (Mediterranean Shipping Company). He moved to France in 2005 and is working freelance since 2006. He provides consulting, administration, audits and training. As SQL Server evolves into a more complex solution, he tries to make sure that developers and administrators keep mastering the fundamentals: the relational model and the SQL language, as well as the principles of the SGBDR physical architecture. He wrote in 2008 the only French book about SQL Server optimization, published a book about SQL Security at Packt Pub in 2012 and released recently a french book about the NoSQL movement. And yes, he manages to have some free time sometimes.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.