Python Tutorial: Combine data from multiple worksheets

Want to learn more? Take the full course at https://learn.datacamp.com/courses/importing-and-managing-financial-data-in-python at your own pace. More than a video, you'll learn hands-on coding & quickly apply skills to your daily work. --- Now that you can load data from multiple worksheets into pandas dataframes, let us look at how you can combine these worksheets into a single dataframe to analyze all this data together. In this video, you will learn how to concatenate or ‘stack’ multiple DataFrames. For this purpuse, pandas has a function called ‘pd.concat’: if you pass a list of two or more DataFrames to this function, it combines these DataFrames vertically. It does so by looking for matching column names in the DataFrames, and aligning the columns accordingly as it appends the DataFrames in the order that they appear in the list. As you can see in the example, pd.concat combines the three DataFrames containing the listings from the three exchanges into a new DataFrame that contains the original information in stacked form. Let’s take a look at how this works in practice: As before, you can read two worksheets from the ‘listings.xlsx’ file using pd.read_excel(), while passing the respective exchange names to the sheet_name parameter. As a result, the listing data is now contained in two pandas DataFrames, assigned to variables with the same name. You can now combine these data frames by passing as list with the variables to the pd.concat function. When you inspect the result using the method .info() , you’ll notice that the result contains over 3500 rows, around 400 from the AMEX exchange and 3,100 from the NASDAQ. If you combine the information from several DataFrames, you want to keep a reference about the data source with each listing. To this end, you can add a column to each dataframe with the information about which exchange the companies are listed on before combining the dataframes. This example shows you how to do that. Creating a new column is sim