Merging Series / DataFrames

Learning objectives

After working through this topic, you should be able to:

• use pd.merge to combine DataFrames

• use the how argument to determine which rows are kept

• list different types of merging data depending on their structure:

  • one-to-one

  • many-to-one

  • one-to-many

  • many-to-many

Materials

Video with English subtitles:

Download the slides.

Video with German subtitles:

(turn subtitles on in the bottom right corner of the video)