ead53c9bd3205abfe3fdec30f8e6c8b39ea04329,src/pudl/extract/excel.py,GenericExtractor,load_excel_file,#GenericExtractor#Any#Any#,230

Before Change

        zf = zipfile.ZipFile(p)
        xlsx_filename = self.excel_filename(year, page)
        excel_file = pd.ExcelFile(zf.read(xlsx_filename))
        self._file_cache[str(p)] = excel_file
        return excel_file

    def excel_filename(self, year, page):

After Change

        p = Path(item["path"])
        xlsx_filename = self.excel_filename(part, page)

        if xlsx_filename in self._file_cache.keys():
            logger.debug("Grabing cached file.")
            excel_file = self._file_cache[xlsx_filename]
        else:
            logger.debug("Grabing new file.")

        if p.name != xlsx_filename:
            zf = zipfile.ZipFile(p)
            excel_file = pd.ExcelFile(zf.read(xlsx_filename))
        else:
            excel_file = pd.ExcelFile(p)
        self._file_cache[xlsx_filename] = excel_file
        return excel_file

    def excel_filename(self, year, page):

Instances