Concatenating multiple DataFrames together

The versatile concat function enables concatenating two or more DataFrames (or Series) together, both vertically and horizontally. As per usual, when dealing with multiple pandas objects simultaneously, concatenation doesn't happen haphazardly but aligns each object by their index.

Getting ready

In this recipe, we combine DataFrames both horizontally and vertically with the concat function and then change the parameter values to yield different results.

How to do it...

1. Read in the 2016 and 2017 stock datasets, and make their ticker symbol the index:

>>> stocks_2016 = pd.read_csv('data/stocks_2016.csv', 
                              index_col='Symbol')
>>> stocks_2017 = pd.read_csv('data/stocks_2017.csv',
                              index_col='Symbol')

    

2. Place all the stock datasets into a single list, and then call the concat function to concatenate them together:

>>> s_list = [stocks_2016, stocks_2017]
>>> pd.concat...