def get_sanitized_dataframe(self, date_column='Date'):
# ExcelFile does not handle file_paths very well, use native Python open
opened_file = open(self.file_path, 'rb')
excel_file = pd.ExcelFile(opened_file)
dataframe = excel_file.parse(self.sheet)
# Sanitize so the inputs are correct and remove fluke days
dataframe = self._sanitize_sheet(dataframe)
dataframe = self._set_dataframe_index(dataframe, date_column)
return dataframe
评论列表
文章目录