text_html_output_1.png
import os

import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

import numpy as np
import pandas as pd
import os

df = pd.read_csv('../input/sales-dataset/Sales_April_2019.csv')

files = [file for file in os.listdir('../input/sales-dataset')]
df = pd.DataFrame()
for file in files:
    df1 = pd.read_csv('../input/sales-dataset/' + file)
    df = pd.concat([df, df1])
df.to_csv('all_data.csv', index=False)

df1 = pd.read_csv('all_data.csv')

df1.shape

nan_df = df1[df1.isna().any(axis=1)]
df1 = df1.dropna(how='all')

df1 = df1[df1['Order Date'].str[0:2] != 'Or']

df1['sales'] = 0
df1.head()