datetime.datetime.strptime("2013-1-25", '%Y-%m-%d').strftime('%m/%d/%y')
now = datetime.now()
time_string = now.strftime("%Y-%m-%d %H:%M:%S")
print(time_string)
>>> datetime.today().strftime('%Y-%m-%d-%H:%M:%S')
'2021-01-26-16:50:03'
>>> from datetime import datetime
>>> datetime.today().strftime('%Y-%m-%d')
'2021-01-26'
# Change the format of the order date column to datetime format
data = data[data['Order Date'].str[0:2] != 'Or'] # this line of code ensures that there is no text in any row or cell
data['Order Date'] = pd.to_datetime(data['Order Date'])