Get startedGet started for free

Concatenating rows with duplicated indexes

Pandas is proving quite useful for your data prep! One small problem - your colleague reloaded the data frames without setting GameKey as the index for either frame. Can you still concatenate the games_2016 and games_2017 data frames?

This exercise is part of the course

Pandas Joins for Spreadsheet Users

View Course

Exercise instructions

  • View the indexes of the reloaded data frames.
  • Rejoin the data frames using pd.concat().
  • View the new data frame.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# View indexes
print(games_2016.index.values)
print(____.index.values)

# Rejoin data frames
games = ____([____, ____], 
    ____=____)

# View new data frame
print(____)
Edit and Run Code