Merging datasets

Learning Objectives

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

• Use pd.concat to combine DataFrames vertically or horizontally

• Use pd.merge to combine DataFrames

• Use the how argument to determine which rows are kept

• List different types of joining data

Materials

Here is the Screencast (audio is very low in the beginning, but gets better) and these are the slides.

Additional Materials

• Pandas tutorial on merge, join and concatenate

Quiz