How do I get Multiple CSV files (csv file names will be column names) from a folder to a pandas dataframe?
How do you get to the second picture from that code? I wil give you rough set of steps to follow along with the main function names. you can search through the pandas documentation for more details.

initialise some empty lists:  ticker_names=[] dataframes=[]
Loop over the files and read them using df = pd.read_csv(file_name)
Take just the Close column of each single ticker's dataframe: df = df[&quot;Close&quot;]
Keep track of the tickers' names in a list: ticker_names.append(ticker)
Bring them all together into one dataframe: final_df = pd.concat(dataframes, left_index=True, right_index=True). We uses the indices because you have date-time index values, and we want to keep them all.
Then give each column the correct name: final_df.columns = ticker_names

You can play around with each of these steps, and I would suggest looking at the **pd.merge** documentation.