Data Science Stack Exchange is a question and answer site for Data science professionals, Machine Learning specialists, and those interested in learning more about the field. It only takes a minute to sign up.
I think the title is enough for what is my problem here. I have 100 tickers in a folder. I got all csv files to one list. but I wanna see the tickers name which these are csv file names.
what should I do for getting all tickers like that. I'm doing it manually but I need a simple way to do that.
import pandas as pd
#BİST100-2010.01.01-2020.07.01/ is my folder.
log_total = 
for file in os.listdir('BİST100-2010.01.01-2020.07.01/'):
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["Close"]
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.