Jun-07-2020, 10:57 PM
I can't get rid of the old index, still shows the old index and the index title is on top of the old one. what might be the reason for it? Thanks :) the data source is: https://github.com/KeithGalli/Pandas-Dat...esAnalysis
i downloaded the data and i was watching from tutorial but in the video this problem didn't occur
i downloaded the data and i was watching from tutorial but in the video this problem didn't occur
import pandas as pd import os df = pd.read_csv('./Sales_Data/Sales_April_2019.csv') files = [file for file in os.listdir('./Sales_Data')] all_months_data = pd.DataFrame() for file in files: df = pd.read_csv('./Sales_Data/'+ file) all_months_data = pd.concat([all_months_data,df]) all_months_data.head() all_months_data.to_csv('all_data.csv', index=False) nan_df = all_data[all_data.isna().any(axis=1)] nan_df.head() all_data = all_data.dropna(how='all') all_data.head() all_data['Month']= all_data['Order Date'].str[0:2] all_data.Month=[int(x.strip('/')) if type(x)==str else x for x in all_data.Month] #In mine it showed the months as 4/ so thats why i had to do it all_data['Month'] = all_data['Month'].astype('int32') all_data.head() all_data = all_data[all_data['Order Date'].str[0:2] !='Or'] all_data = all_data.reset_index(drop=True) #for some reason the index jumps 0 to 2 even though the info is ordered just like the downloaded the data all_data.head()