code: def _parse_excel(
      self,
      excel_url: str,
      add_date: pd.Timestamp,
      remove_date: pd.Timestamp,
  ) -> pd.DataFrame:
      content = retry_request(excel_url, exclude_status=[404]).content
      _io = BytesIO(content)
      df_map = pd.read_excel(_io, sheet_name=None)
      with self.cache_dir.joinpath(
          f"{self.index_name.lower()}_changes_{add_date.strftime('%Y%m%d')}.{excel_url.split('.')[-1]}"
      ).open("wb") as fp:
          fp.write(content)
      tmp = []
      for _s_name, _type, _date in [
          ("调入", self.ADD, add_date),
          ("调出", self.REMOVE, remove_date),
      ]:
          _df = df_map[_s_name]
          _df = _df.loc[_df["指数代码"] == self.index_code, ["证券代码"]]
          _df = _df.applymap(self.normalize_symbol)
          _df.columns = [self.SYMBOL_FIELD_NAME]
          _df["type"] = _type
          _df[self.DATE_FIELD_NAME] = _date
          tmp.append(_df)
      df = pd.concat(tmp)
      return df
  
imports: import re
  import abc
  import sys
  from io import BytesIO
  from typing import List, Iterable
  from pathlib import Path
  import fire
  import requests
  import pandas
  import baostock
  from tqdm import tqdm
  from loguru import logger
  from data_collector.index import IndexBase
  from data_collector.utils import get_calendar_list, get_trading_date_by_shift, deco_retry
  from data_collector.utils import get_instruments
label_desc: Use image node_id 10 for calling the CSIIndex obj's underlying member method code with example usage: obj._parse_excel(excel_url, add_date, remove_date) and returns: df