Pandas: Merge or join DataFrames

19 August 2020

Code

# Import library
import pandas as pd

# Create DataFrames
df1 = pd.DataFrame({
    'sport': ['tennis', 'cricket', 'football'],
    'spectators': [100000, 200000, 175000]
})

df2 = pd.DataFrame({
    'sport': ['tennis', 'cricket', 'football'],
    'number_of_players': [2, 11, 11]
})

# Merge DataFrame
df = df1.merge(df2, on='sport', how='inner')

# Output
print(df)

Output:

      sport  spectators  number_of_players
0    tennis      100000                  2
1   cricket      200000                 11
2  football      175000                 11






Any errors in code above?
Please send a message.