def process_statement(self, fname: str) -> None:
df = None
if Helper.extractFileExtension(fname) == '.xlsx':
df = pd.read_excel(fname,parse_dates=[0,1])
elif Helper.extractFileExtension(fname) == '.csv':
df = pd.read_csv(fname, parse_dates=[0,1])
else:
raise ValueError("filename must contain the file extension .xlsx or .csv")
# Add Year, Month and Upper Case Description Columns
df["Year"] = df.apply(lambda row: Helper.getYear(row), axis = 1)
df["Month"] = df.apply(lambda row: Helper.getMonth(row), axis = 1)
df["Searchable Description"] = df.apply(lambda row: Helper.allCapsify(row), axis=1)
return df
