5. Merging data

Merging data

• Merging data
  • Similar to joining tables in SQL
  • Combine disparate datasets based on common columns
• Types of merges
  1. One-to-one
  2. Many-to-one
  3. One-to-many

1-to-1 data merge

o2o = pd.merge(left=site, right=visited, left_on='name', right_on='site') # Merge the site and visited DataFrames on the 'name' column and 'site' column

print(o2o)

Many-to-1 data merge

m2o = pd.merge(left=site, right=visited, left_on='name', right_on='site') # Merge the DataFrames

print(m2o)

Many-to-many data merge

m2m = pd.merge(left=site, right=visited, left_on='name', right_on='site') # Merge site and visited

m2m = pd.merge(left=m2m, right=survey, left_on='ident', right_on='taken') # Merge m2m and survey

print(m2m.head(20)) # Print the first 20 lines