Concatenating columns
Now it's time to continue exploring stadiums and turf types as potential factors associated with concussions. It might be interesting to see turf types by season type.
You determined earlier that the games
data frame and the stadiums
data frame are complementary. It seems reasonable to concatenate them by column. The two data frames are already loaded.
This exercise is part of the course
Pandas Joins for Spreadsheet Users
Exercise instructions
- Use the default number of rows for
.head()
to view the first 5 rows of each data frame. - Join the data frames using
pd.concat()
. - Cross-tabulate
Turf
andSeasonType
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# View data frames
print(____.head())
print(____.____())
# Join data frames
games_places = pd.concat([____, ____],
axis=____)
# Cross-tabulate Season and Season Type
print(pd.crosstab(games_places.Turf, games_places.SeasonType))