Loads Excel file in AS import template format, uses Pandas to crudely split dates from titles

dates.py

import pandas as pd

#load csv file - NB first remove extra rows at top, need to replace these before import
#df = pd.read_csv('clean_input.csv', encoding = 'ISO-8859-1', low_memory=False)

#load Excel directly, - NB first remove extra rows at top, need to replace these before import
df = pd.read_excel(open('clean_input.xlsx','rb'))


#print column headings
#print(list(df))

#define x as the number of rows
for x in range(0, 10893):
	title = df.at[x, "title"]
	date = df.at[x, "expression"]
	#Check to see if date expression already exists
	if isinstance(date, str):
		print("nothing")
	else:
		newdate = title.rsplit(', ', 1)
		if len(newdate) < 2:
			print("no len date")
		else:
			df.at[x, "title"] = newdate[0]
			df.at[x, "expression"] = newdate[1]
			print(newdate)
#output csv
#df.to_csv('out.csv')

#output xslx
df.to_excel('out.xlsx')