import pandas as pd
import numpy as np
import datetime as dt
df = pd.read_csv('supermarket_sales - Sheet1.csv')
df.head()
df.shape
df.isnull().sum()
df.describe()
df.info()
df['Date'] = pd.to_datetime(df['Date'])
df.info()
df['Order Date']= pd.date_range(start='1/1/2018', end = '9/26/2020')
df.head()
df.replace(to_replace='Yangon', value='Lagos')
df.replace(to_replace='Naypyitaw', value='Abuja')
df.replace(to_replace='Yangon', value='Lagos')
df.replace(to_replace='Mandalay', value='Port Harcourt')
df.to_excel('Supermart_Cleaned.xlsx')