unexpected output

[asyrafcc99]

def compile_data():
with open("dict.pickle","rb") as f:
tickers = pickle.load(f)

main_df = pd.DataFrame()

for count,ticker in enumerate(tickers):
df = pd.read_csv(r'C:\Users\User\Desktop\StockProject\5 stocks/{}.csv'.format(ticker))
df.set_index('date', inplace=True)

df.rename(columns={'close':ticker}, inplace=True)
df.drop(['no','ticker','name','per','open','high','low','volume','o/i'],1, inplace=True)
if main_df.empty:
main_df = df
else:
main_df = main_df.join(df, how='outer')

print(main_df.head())
main_df.to_csv('lastcombine.csv')

compile_data()
.
.
.
can someone help me with this problem? im trying to combine all 5 stock of historical prices into one but the output was not what am expected it to be. the date and close price went crazy.

metulburr write Oct-24-2020, 03:55 PM:
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.