import pandas as pd
#create a dataframe raw_data = {'name': ['Willard Morris', 'Al Jennings'], 'age': [20, 19], 'favorite_color': ['blue', 'red'], 'grade': [88, 92]} df = pd.DataFrame(raw_data, index = ['Willard Morris', 'Al Jennings']) df
#create another dataframe raw_data_2 = {'name': [ 'Omar Mullins', 'Spencer McDaniel'], 'age': [22, 21], 'favorite_color': ['yellow', "green"], 'grade': [95, 70]} df_2 = pd.DataFrame(raw_data, index = ['Omar Mullins', 'Spencer McDaniel']) df_2
#create list of dataframes we want to concatenate dataframes = [df, df_2]
#concatenate the dataframes. analagous to union function in sql dataframes_concat = pd.concat(dataframes) dataframes_concat