code: def format_index(data):
      
      tz_raw = data.columns[1]
      timezone = TZ_MAP.get(tz_raw, tz_raw)
      datetime = data['DATE (MM/DD/YYYY)'] + data[tz_raw]
      datetime = pd.to_datetime(datetime, format='%m/%d/%Y%H:%M')
      data = data.set_index(datetime)
      data = data.tz_localize(timezone)
      return data
docs: Create DatetimeIndex for the Dataframe localized to the timezone provided
      as the label of the second (time) column.
  
      Parameters
      ----------
      data: Dataframe
          Must contain 'DATE (MM/DD/YYYY)' column, second column must be labeled
          with the timezone and contain times in 'HH:MM' format.
  
      Returns
      -------
      data: Dataframe
          Dataframe with DatetimeIndex localized to the provided timezone.