csc_hackathon.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/abfhdays/Employee-Management-System-ICS4UO-/blob/main/csc_hackathon.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "from google.colab import drive"
      ],
      "metadata": {
        "id": "mBpZWQjfPvcd"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "There's missing data!\n"
      ],
      "metadata": {
        "id": "KvAtCI-TaKys"
      }
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "SQ-7qqJBhzJJ"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "drive.mount('/content/drive')\n",
        "df = pd.read_csv(\"/content/drive/MyDrive/test1.csv\")\n",
        "pd.set_option('display.max_columns', None)\n",
        "print(display(df))\n",
        "df.shape\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 707
        },
        "id": "oNqLIpxNfQzs",
        "outputId": "c2dc7dbf-7036-46aa-e641-ed75c628cb99"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ]
        },
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-23-9931c7154610>:2: DtypeWarning: Columns (62,64,87) have mixed types. Specify dtype option on import or set low_memory=False.\n",
            "  df = pd.read_csv(\"/content/drive/MyDrive/test1.csv\")\n"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "             id   type_code is_registered country_code currency_code  \\\n",
              "0       1155742        CASH             f          NaN           CAD   \n",
              "1       1269359        TFSA             t          NaN           CAD   \n",
              "2        573181        CASH             f          NaN           CAD   \n",
              "3        967968        TFSA             t          NaN           CAD   \n",
              "4        595581        CASH             f          NaN           CAD   \n",
              "...         ...         ...           ...          ...           ...   \n",
              "168330  1047726        CASH             f          NaN           CAD   \n",
              "168331   888353  CASH SWEEP             f          NaN           CAD   \n",
              "168332  1090674        CASH             f          NaN           CAD   \n",
              "168333  1034923    REG RRSP             t          NaN           CAD   \n",
              "168334  1182775  CASH SWEEP             f          NaN           CAD   \n",
              "\n",
              "       is_active  class_id debit_code last_trade_date  contract_type  \\\n",
              "0              t       3.0          T             NaN           17.0   \n",
              "1              t       5.0          C      2020-11-05           18.0   \n",
              "2              t       3.0          T             NaN           17.0   \n",
              "3              t       5.0          A      2020-03-03           17.0   \n",
              "4              t       3.0          T      2011-04-01           17.0   \n",
              "...          ...       ...        ...             ...            ...   \n",
              "168330         t       3.0          A             NaN           17.0   \n",
              "168331         t       3.0          0             NaN            NaN   \n",
              "168332         t       3.0          T             NaN           12.0   \n",
              "168333         f       5.0          A      2017-09-27           17.0   \n",
              "168334         t       3.0          0             NaN            NaN   \n",
              "\n",
              "       inception_date net_of_fees  cashflows_custody_fee fee_paid_separately  \\\n",
              "0          2017-07-21           f                    NaN                   f   \n",
              "1          2020-03-09           f                    NaN                   f   \n",
              "2          2023-01-10           f                    NaN                   f   \n",
              "3          2017-07-21           f                    NaN                   f   \n",
              "4          2009-02-18           f                    NaN                   f   \n",
              "...               ...         ...                    ...                 ...   \n",
              "168330     2017-07-21           f                    NaN                   f   \n",
              "168331     2017-08-18           f                    NaN                   f   \n",
              "168332     2021-09-21           f                    NaN                   f   \n",
              "168333     2017-07-21           f                    NaN                   f   \n",
              "168334     2017-08-18           f                    NaN                   f   \n",
              "\n",
              "       custody_fee_withdrawal is_fee_exempt branch  \\\n",
              "0                           f             f  HOLIS   \n",
              "1                           f             f   IAVM   \n",
              "2                           f             f    IAS   \n",
              "3                           f             f    IAS   \n",
              "4                           f             f   IAVM   \n",
              "...                       ...           ...    ...   \n",
              "168330                      f             f   IAVM   \n",
              "168331                      f             f   IAVM   \n",
              "168332                      f             f   IAVM   \n",
              "168333                      f             f   IAVM   \n",
              "168334                      f             f   IAVM   \n",
              "\n",
              "       include_client_consolidation use_client_address  credit_limit_type  \\\n",
              "0                                 t                  t                0.0   \n",
              "1                                 t                  t                0.0   \n",
              "2                                 t                  t                0.0   \n",
              "3                                 t                  f                0.0   \n",
              "4                                 t                  t                0.0   \n",
              "...                             ...                ...                ...   \n",
              "168330                            t                  t                0.0   \n",
              "168331                            t                  f                0.0   \n",
              "168332                            t                  t                0.0   \n",
              "168333                            t                  f                0.0   \n",
              "168334                            t                  t                0.0   \n",
              "\n",
              "       retail_plan is_spousal is_arp_locked arp_pension_origin language_code  \\\n",
              "0              NaN        NaN           NaN                NaN             E   \n",
              "1               TF          f             f                NaN             E   \n",
              "2              NaN        NaN           NaN                NaN             E   \n",
              "3               TF          f             f                NaN             E   \n",
              "4              NaN        NaN           NaN                NaN             E   \n",
              "...            ...        ...           ...                ...           ...   \n",
              "168330         NaN        NaN           NaN                NaN             E   \n",
              "168331         NaN        NaN           NaN                NaN             E   \n",
              "168332         NaN        NaN           NaN                NaN             E   \n",
              "168333          RS          f             f                NaN             E   \n",
              "168334         NaN        NaN           NaN                NaN             E   \n",
              "\n",
              "        dividend_confirm_code sss_location  options_trading_type sss_type  \\\n",
              "0                         0.0          NaN                   0.0      NaN   \n",
              "1                         0.0          NaN                   0.0      NaN   \n",
              "2                         0.0          NaN                   0.0      NaN   \n",
              "3                         0.0          NaN                   0.0      NaN   \n",
              "4                         0.0          NaN                   0.0      NaN   \n",
              "...                       ...          ...                   ...      ...   \n",
              "168330                    0.0          NaN                   0.0      NaN   \n",
              "168331                    0.0          NaN                   0.0      NaN   \n",
              "168332                    0.0          NaN                   0.0      NaN   \n",
              "168333                    0.0          NaN                   0.0      NaN   \n",
              "168334                    0.0          NaN                   0.0      NaN   \n",
              "\n",
              "       sss_agent is_midwest_clearing_account  rep_commission_rate  \\\n",
              "0            NaN                       False                  0.0   \n",
              "1            NaN                       False                  0.0   \n",
              "2            NaN                       False                  0.0   \n",
              "3            NaN                       False                  0.0   \n",
              "4            NaN                       False                  0.0   \n",
              "...          ...                         ...                  ...   \n",
              "168330       NaN                       False                  0.0   \n",
              "168331       NaN                       False                  0.0   \n",
              "168332       NaN                       False                  0.0   \n",
              "168333       NaN                       False                  0.0   \n",
              "168334       NaN                       False                  0.0   \n",
              "\n",
              "        rep_commission_override  interest_dividend_conversion_type  \\\n",
              "0                           0.0                                0.0   \n",
              "1                           0.0                                0.0   \n",
              "2                           0.0                                0.0   \n",
              "3                           0.0                                0.0   \n",
              "4                           0.0                                0.0   \n",
              "...                         ...                                ...   \n",
              "168330                      0.0                                0.0   \n",
              "168331                      0.0                                0.0   \n",
              "168332                      0.0                                0.0   \n",
              "168333                      0.0                                0.0   \n",
              "168334                      0.0                                0.0   \n",
              "\n",
              "        guarantee_gtor_type use_hand_delivery use_mail  \\\n",
              "0                       0.0                 f        f   \n",
              "1                       2.0                 f        f   \n",
              "2                       0.0                 f        f   \n",
              "3                       2.0                 f        f   \n",
              "4                       0.0                 f        f   \n",
              "...                     ...               ...      ...   \n",
              "168330                  0.0                 f        f   \n",
              "168331                  0.0                 f        f   \n",
              "168332                  0.0                 f        f   \n",
              "168333                  2.0                 f        f   \n",
              "168334                  0.0                 f        f   \n",
              "\n",
              "       share_name_address_to_issuer shareholder_instructions_received  \\\n",
              "0                                 t                                 f   \n",
              "1                                 t                                 f   \n",
              "2                                 t                                 f   \n",
              "3                                 t                                 f   \n",
              "4                                 t                                 f   \n",
              "...                             ...                               ...   \n",
              "168330                            t                                 f   \n",
              "168331                            t                                 f   \n",
              "168332                            t                                 f   \n",
              "168333                            t                                 f   \n",
              "168334                            t                                 f   \n",
              "\n",
              "       rrsp_limit_reached is_portfolio_account has_no_min_commission  \\\n",
              "0                       f                    f                     f   \n",
              "1                       f                    f                     f   \n",
              "2                       f                    f                     f   \n",
              "3                       f                    f                     f   \n",
              "4                       f                    f                     f   \n",
              "...                   ...                  ...                   ...   \n",
              "168330                  f                    f                     f   \n",
              "168331                  f                    f                     f   \n",
              "168332                  f                    f                     f   \n",
              "168333                  f                    f                     f   \n",
              "168334                  f                    f                     f   \n",
              "\n",
              "       is_tms_eligible is_agent_bbs_participant is_parameters_account  \\\n",
              "0                    f                        f                     f   \n",
              "1                    f                        f                     f   \n",
              "2                    f                        f                     f   \n",
              "3                    f                        f                     f   \n",
              "4                    f                        f                     f   \n",
              "...                ...                      ...                   ...   \n",
              "168330               f                        f                     f   \n",
              "168331               f                        f                     f   \n",
              "168332               f                        f                     f   \n",
              "168333               f                        f                     f   \n",
              "168334               f                        f                     f   \n",
              "\n",
              "       is_spousal_transfer spousal_age_flag terminal_code has_multiple_name  \\\n",
              "0                        f                f           NaN                 f   \n",
              "1                        f                f          1026                 f   \n",
              "2                        f                f          1137                 t   \n",
              "3                        f                f           NaN                 f   \n",
              "4                        f                f         BATCH                 f   \n",
              "...                    ...              ...           ...               ...   \n",
              "168330                   f                f          113F                 f   \n",
              "168331                   f                f         BATCH                 f   \n",
              "168332                   f                f          11A0                 t   \n",
              "168333                   f                f         BATCH                 f   \n",
              "168334                   f                f         BATCH                 f   \n",
              "\n",
              "        deceased_fair_market_value  target_grantor_grantee_flag  \\\n",
              "0                              0.0                          NaN   \n",
              "1                              0.0                          NaN   \n",
              "2                              0.0                          NaN   \n",
              "3                              0.0                          0.0   \n",
              "4                              0.0                          NaN   \n",
              "...                            ...                          ...   \n",
              "168330                         0.0                          NaN   \n",
              "168331                         0.0                          NaN   \n",
              "168332                         0.0                          NaN   \n",
              "168333                         0.0                          0.0   \n",
              "168334                         0.0                          NaN   \n",
              "\n",
              "       discretionary_trading_authorized iso_funds_code  esir_number  \\\n",
              "0                                     f            CAD          NaN   \n",
              "1                                     f            CAD          NaN   \n",
              "2                                     f            CAD          NaN   \n",
              "3                                     f            CAD          NaN   \n",
              "4                                   NaN            CAD          NaN   \n",
              "...                                 ...            ...          ...   \n",
              "168330                                f            CAD          NaN   \n",
              "168331                              NaN            CAD          NaN   \n",
              "168332                              NaN            CAD          NaN   \n",
              "168333                                f            CAD          NaN   \n",
              "168334                                f            CAD          NaN   \n",
              "\n",
              "       shareholder_language dup_trip_quad_code special_tag conjunction title  \\\n",
              "0                       NaN                  A         NaN         NaN    MR   \n",
              "1                       NaN                  A         NaN         NaN  MRS.   \n",
              "2                       NaN                  A      JTWROS         NaN    MR   \n",
              "3                       NaN                  A         NaN         NaN    MR   \n",
              "4                       NaN                  A         NaN         NaN    MR   \n",
              "...                     ...                ...         ...         ...   ...   \n",
              "168330                  NaN                  A         NaN         NaN    MR   \n",
              "168331                  NaN                  A         NaN         NaN   NaN   \n",
              "168332                  NaN                  A      JTWROS         NaN   MRS   \n",
              "168333                  NaN                  A         NaN         NaN   MRS   \n",
              "168334                  NaN                  A         NaN         NaN   NaN   \n",
              "\n",
              "       function_code tms_settlement_location  portfolio_cost_method  \\\n",
              "0                NaN                     NaN                    0.0   \n",
              "1                NaN                     NaN                    0.0   \n",
              "2                NaN                     NaN                    0.0   \n",
              "3                NaN                     NaN                    0.0   \n",
              "4                NaN                     NaN                    0.0   \n",
              "...              ...                     ...                    ...   \n",
              "168330           NaN                     NaN                    0.0   \n",
              "168331           NaN                     NaN                    0.0   \n",
              "168332           NaN                     NaN                    0.0   \n",
              "168333           NaN                     NaN                    0.0   \n",
              "168334           NaN                     NaN                    0.0   \n",
              "\n",
              "       portfolio_name_address_option  portfolio_report_option  \\\n",
              "0                                0.0                      0.0   \n",
              "1                                0.0                      0.0   \n",
              "2                                0.0                      0.0   \n",
              "3                                0.0                      0.0   \n",
              "4                                0.0                      0.0   \n",
              "...                              ...                      ...   \n",
              "168330                             0                      0.0   \n",
              "168331                             0                      0.0   \n",
              "168332                             0                      0.0   \n",
              "168333                             0                      0.0   \n",
              "168334                             0                      0.0   \n",
              "\n",
              "       portfolio_summary_option receive_general_mailings loan_limit_override  \\\n",
              "0                           0.0                        t                 NaN   \n",
              "1                           0.0                        t                 NaN   \n",
              "2                           0.0                        t                 NaN   \n",
              "3                           0.0                        t                 NaN   \n",
              "4                           0.0                        t                 NaN   \n",
              "...                         ...                      ...                 ...   \n",
              "168330                        0                        t                 NaN   \n",
              "168331                        0                        t                 NaN   \n",
              "168332                        0                        t                 NaN   \n",
              "168333                        0                        t                 NaN   \n",
              "168334                        0                        t                 NaN   \n",
              "\n",
              "        interactive_portfolio_code non_plan_book_value_flag has_discrete_auth  \\\n",
              "0                              0.0                        V                 f   \n",
              "1                              0.0                      NaN                 f   \n",
              "2                              0.0                        V                 f   \n",
              "3                              0.0                      NaN                 f   \n",
              "4                              0.0                        V                 f   \n",
              "...                            ...                      ...               ...   \n",
              "168330                         0.0                        V                 f   \n",
              "168331                         0.0                        V               NaN   \n",
              "168332                         0.0                        V               NaN   \n",
              "168333                         0.0                      NaN                 f   \n",
              "168334                         0.0                        V                 f   \n",
              "\n",
              "       last_update_date is_non_objecting_beneficial_owner  \\\n",
              "0            2017-07-24                                 f   \n",
              "1            2020-03-09                                 t   \n",
              "2            2023-01-10                                 f   \n",
              "3            2018-10-29                                 f   \n",
              "4            2023-02-07                                 f   \n",
              "...                 ...                               ...   \n",
              "168330       2017-07-24                                 f   \n",
              "168331              NaN                                 f   \n",
              "168332       2021-09-21                                 t   \n",
              "168333       2017-07-24                                 f   \n",
              "168334              NaN                                 f   \n",
              "\n",
              "       is_objecting_to_disclose_info  mailing_consent consent_to_pay_for_mail  \\\n",
              "0                                  t              0.0                       f   \n",
              "1                                  f              0.0                       f   \n",
              "2                                  t              0.0                       f   \n",
              "3                                  t              0.0                       f   \n",
              "4                                  t              0.0                       f   \n",
              "...                              ...              ...                     ...   \n",
              "168330                             t              0.0                       f   \n",
              "168331                             f              0.0                       f   \n",
              "168332                             f              0.0                       f   \n",
              "168333                             t              0.0                       f   \n",
              "168334                             f              0.0                       f   \n",
              "\n",
              "       consent_to_email_delivery has_received_instruction risk_tolerance  \\\n",
              "0                              f                        t         H25M75   \n",
              "1                              f                        t            L99   \n",
              "2                              f                        t            M99   \n",
              "3                              f                        t            M99   \n",
              "4                              f                        t         H10M90   \n",
              "...                          ...                      ...            ...   \n",
              "168330                         f                        t            H99   \n",
              "168331                         f                        f            NaN   \n",
              "168332                         f                        t            M99   \n",
              "168333                         f                        t            NaN   \n",
              "168334                         f                        f            NaN   \n",
              "\n",
              "       investment_objective is_broker_account is_inventory_account  \\\n",
              "0                    G75S25                 f                    f   \n",
              "1                       M99                 f                    f   \n",
              "2                       G99                 f                    f   \n",
              "3                       G99                 f                    f   \n",
              "4                    B35G65                 f                    f   \n",
              "...                     ...               ...                  ...   \n",
              "168330                  S99                 f                    f   \n",
              "168331                  NaN                 f                    f   \n",
              "168332               B50G50                 f                    f   \n",
              "168333                  NaN                 f                    f   \n",
              "168334                  NaN                 f                    f   \n",
              "\n",
              "       is_gl_account is_control_account is_extract_eligible  \\\n",
              "0                  f                  f                   t   \n",
              "1                  f                  f                   t   \n",
              "2                  f                  f                   t   \n",
              "3                  f                  f                   t   \n",
              "4                  f                  f                   t   \n",
              "...              ...                ...                 ...   \n",
              "168330             f                  f                   t   \n",
              "168331             f                  f                   t   \n",
              "168332             f                  f                   t   \n",
              "168333             f                  f                   t   \n",
              "168334             f                  f                   t   \n",
              "\n",
              "       last_maintenance_time last_maintenance_user is_pledged  \\\n",
              "0        2022-07-14 00:00:00                   T80        NaN   \n",
              "1        2022-10-20 00:00:00               ROMANAA          f   \n",
              "2        2023-01-11 00:00:00               MEGHZFG        NaN   \n",
              "3        2021-08-06 00:00:00                   T80          f   \n",
              "4        2023-05-08 00:00:00                 BATCH        NaN   \n",
              "...                      ...                   ...        ...   \n",
              "168330   2018-10-31 00:00:00                 WONGU        NaN   \n",
              "168331   2023-06-12 00:00:00                   H01        NaN   \n",
              "168332   2023-04-27 00:00:00               CHHATWA        NaN   \n",
              "168333   2020-01-03 00:00:00                ISLUSR          f   \n",
              "168334   2017-08-18 00:00:00                 BATCH        NaN   \n",
              "\n",
              "       special_fee_code non_calendar_year_end plan_effective_date  \\\n",
              "0                   NaN                   NaN                 NaN   \n",
              "1                   NaN                  0000          2020-03-09   \n",
              "2                   NaN                   NaN                 NaN   \n",
              "3                   NaN                  0000          2017-07-21   \n",
              "4                   NaN                   NaN                 NaN   \n",
              "...                 ...                   ...                 ...   \n",
              "168330              NaN                   NaN                 NaN   \n",
              "168331              NaN                   NaN                 NaN   \n",
              "168332              NaN                   NaN                 NaN   \n",
              "168333              NaN                  00/0          2017-07-21   \n",
              "168334              NaN                   NaN                 NaN   \n",
              "\n",
              "       plan_end_date is_resp  number_of_beneficiaries rrif_original_date  \\\n",
              "0                NaN     NaN                      NaN                NaN   \n",
              "1                NaN       f                      0.0         2020-03-09   \n",
              "2                NaN     NaN                      NaN                NaN   \n",
              "3         2020-03-16       f                      0.0         2017-07-21   \n",
              "4                NaN     NaN                      NaN                NaN   \n",
              "...              ...     ...                      ...                ...   \n",
              "168330           NaN     NaN                      NaN                NaN   \n",
              "168331           NaN     NaN                      NaN                NaN   \n",
              "168332           NaN     NaN                      NaN                NaN   \n",
              "168333    2017-10-02       f                      0.0         2017-07-21   \n",
              "168334           NaN     NaN                      NaN                NaN   \n",
              "\n",
              "       use_original_date_for_payment_calc is_family_resp is_hrdc_resp  \\\n",
              "0                                     NaN            NaN          NaN   \n",
              "1                                       f              f            f   \n",
              "2                                     NaN            NaN          NaN   \n",
              "3                                       f              f            f   \n",
              "4                                     NaN            NaN          NaN   \n",
              "...                                   ...            ...          ...   \n",
              "168330                                NaN            NaN          NaN   \n",
              "168331                                NaN            NaN          NaN   \n",
              "168332                                NaN            NaN          NaN   \n",
              "168333                                  f              f            f   \n",
              "168334                                NaN            NaN          NaN   \n",
              "\n",
              "       is_plan_grandfathered  resp_specimen_plan  \\\n",
              "0                        NaN                 NaN   \n",
              "1                          f                 NaN   \n",
              "2                        NaN                 NaN   \n",
              "3                          f                 NaN   \n",
              "4                        NaN                 NaN   \n",
              "...                      ...                 ...   \n",
              "168330                   NaN                 NaN   \n",
              "168331                   NaN                 NaN   \n",
              "168332                   NaN                 NaN   \n",
              "168333                     f                 NaN   \n",
              "168334                   NaN                 NaN   \n",
              "\n",
              "                          inserted_at                     updated_at is_olob  \\\n",
              "0       2023-05-30 14:20:18.531115+00  2023-08-08 18:53:01.439561+00       f   \n",
              "1       2023-05-30 14:20:18.531115+00  2023-08-10 21:47:25.370403+00       f   \n",
              "2       2023-05-30 14:20:18.531115+00  2023-08-08 18:53:01.439561+00       f   \n",
              "3       2023-05-30 14:20:18.531115+00  2023-08-10 21:47:25.370403+00       f   \n",
              "4       2023-05-30 14:20:18.531115+00  2023-08-08 20:37:22.511698+00       f   \n",
              "...                               ...                            ...     ...   \n",
              "168330  2023-05-30 14:20:18.531115+00  2023-08-08 18:53:01.439561+00       f   \n",
              "168331  2023-05-30 14:20:18.531115+00  2023-08-08 20:48:02.170633+00       f   \n",
              "168332  2023-05-30 14:20:18.531115+00  2023-08-08 20:33:44.941805+00       f   \n",
              "168333  2023-05-30 14:20:18.531115+00  2023-08-10 21:47:25.370403+00       f   \n",
              "168334  2023-05-30 14:20:18.531115+00  2023-08-08 18:53:01.439561+00       f   \n",
              "\n",
              "       retail_last_maintenance_time retail_last_maintenance_user  \\\n",
              "0                               NaN                          NaN   \n",
              "1               2022-10-20 00:00:00                      ROMANAA   \n",
              "2                               NaN                          NaN   \n",
              "3               2021-08-06 00:00:00                          T80   \n",
              "4                               NaN                          NaN   \n",
              "...                             ...                          ...   \n",
              "168330                          NaN                          NaN   \n",
              "168331                          NaN                          NaN   \n",
              "168332                          NaN                          NaN   \n",
              "168333          2018-06-15 00:00:00                        BATCH   \n",
              "168334                          NaN                          NaN   \n",
              "\n",
              "       visible_in_reports  \n",
              "0                       t  \n",
              "1                       t  \n",
              "2                       t  \n",
              "3                       f  \n",
              "4                       t  \n",
              "...                   ...  \n",
              "168330                  f  \n",
              "168331                  f  \n",
              "168332                  t  \n",
              "168333                  f  \n",
              "168334                  t  \n",
              "\n",
              "[168335 rows x 105 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-77496caa-533f-4d07-97fe-a31db937a3ca\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>type_code</th>\n",
              "      <th>is_registered</th>\n",
              "      <th>country_code</th>\n",
              "      <th>currency_code</th>\n",
              "      <th>is_active</th>\n",
              "      <th>class_id</th>\n",
              "      <th>debit_code</th>\n",
              "      <th>last_trade_date</th>\n",
              "      <th>contract_type</th>\n",
              "      <th>inception_date</th>\n",
              "      <th>net_of_fees</th>\n",
              "      <th>cashflows_custody_fee</th>\n",
              "      <th>fee_paid_separately</th>\n",
              "      <th>custody_fee_withdrawal</th>\n",
              "      <th>is_fee_exempt</th>\n",
              "      <th>branch</th>\n",
              "      <th>include_client_consolidation</th>\n",
              "      <th>use_client_address</th>\n",
              "      <th>credit_limit_type</th>\n",
              "      <th>retail_plan</th>\n",
              "      <th>is_spousal</th>\n",
              "      <th>is_arp_locked</th>\n",
              "      <th>arp_pension_origin</th>\n",
              "      <th>language_code</th>\n",
              "      <th>dividend_confirm_code</th>\n",
              "      <th>sss_location</th>\n",
              "      <th>options_trading_type</th>\n",
              "      <th>sss_type</th>\n",
              "      <th>sss_agent</th>\n",
              "      <th>is_midwest_clearing_account</th>\n",
              "      <th>rep_commission_rate</th>\n",
              "      <th>rep_commission_override</th>\n",
              "      <th>interest_dividend_conversion_type</th>\n",
              "      <th>guarantee_gtor_type</th>\n",
              "      <th>use_hand_delivery</th>\n",
              "      <th>use_mail</th>\n",
              "      <th>share_name_address_to_issuer</th>\n",
              "      <th>shareholder_instructions_received</th>\n",
              "      <th>rrsp_limit_reached</th>\n",
              "      <th>is_portfolio_account</th>\n",
              "      <th>has_no_min_commission</th>\n",
              "      <th>is_tms_eligible</th>\n",
              "      <th>is_agent_bbs_participant</th>\n",
              "      <th>is_parameters_account</th>\n",
              "      <th>is_spousal_transfer</th>\n",
              "      <th>spousal_age_flag</th>\n",
              "      <th>terminal_code</th>\n",
              "      <th>has_multiple_name</th>\n",
              "      <th>deceased_fair_market_value</th>\n",
              "      <th>target_grantor_grantee_flag</th>\n",
              "      <th>discretionary_trading_authorized</th>\n",
              "      <th>iso_funds_code</th>\n",
              "      <th>esir_number</th>\n",
              "      <th>shareholder_language</th>\n",
              "      <th>dup_trip_quad_code</th>\n",
              "      <th>special_tag</th>\n",
              "      <th>conjunction</th>\n",
              "      <th>title</th>\n",
              "      <th>function_code</th>\n",
              "      <th>tms_settlement_location</th>\n",
              "      <th>portfolio_cost_method</th>\n",
              "      <th>portfolio_name_address_option</th>\n",
              "      <th>portfolio_report_option</th>\n",
              "      <th>portfolio_summary_option</th>\n",
              "      <th>receive_general_mailings</th>\n",
              "      <th>loan_limit_override</th>\n",
              "      <th>interactive_portfolio_code</th>\n",
              "      <th>non_plan_book_value_flag</th>\n",
              "      <th>has_discrete_auth</th>\n",
              "      <th>last_update_date</th>\n",
              "      <th>is_non_objecting_beneficial_owner</th>\n",
              "      <th>is_objecting_to_disclose_info</th>\n",
              "      <th>mailing_consent</th>\n",
              "      <th>consent_to_pay_for_mail</th>\n",
              "      <th>consent_to_email_delivery</th>\n",
              "      <th>has_received_instruction</th>\n",
              "      <th>risk_tolerance</th>\n",
              "      <th>investment_objective</th>\n",
              "      <th>is_broker_account</th>\n",
              "      <th>is_inventory_account</th>\n",
              "      <th>is_gl_account</th>\n",
              "      <th>is_control_account</th>\n",
              "      <th>is_extract_eligible</th>\n",
              "      <th>last_maintenance_time</th>\n",
              "      <th>last_maintenance_user</th>\n",
              "      <th>is_pledged</th>\n",
              "      <th>special_fee_code</th>\n",
              "      <th>non_calendar_year_end</th>\n",
              "      <th>plan_effective_date</th>\n",
              "      <th>plan_end_date</th>\n",
              "      <th>is_resp</th>\n",
              "      <th>number_of_beneficiaries</th>\n",
              "      <th>rrif_original_date</th>\n",
              "      <th>use_original_date_for_payment_calc</th>\n",
              "      <th>is_family_resp</th>\n",
              "      <th>is_hrdc_resp</th>\n",
              "      <th>is_plan_grandfathered</th>\n",
              "      <th>resp_specimen_plan</th>\n",
              "      <th>inserted_at</th>\n",
              "      <th>updated_at</th>\n",
              "      <th>is_olob</th>\n",
              "      <th>retail_last_maintenance_time</th>\n",
              "      <th>retail_last_maintenance_user</th>\n",
              "      <th>visible_in_reports</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1155742</td>\n",
              "      <td>CASH</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>t</td>\n",
              "      <td>3.0</td>\n",
              "      <td>T</td>\n",
              "      <td>NaN</td>\n",
              "      <td>17.0</td>\n",
              "      <td>2017-07-21</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>HOLIS</td>\n",
              "      <td>t</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>CAD</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>A</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>MR</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>V</td>\n",
              "      <td>f</td>\n",
              "      <td>2017-07-24</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>H25M75</td>\n",
              "      <td>G75S25</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>2022-07-14 00:00:00</td>\n",
              "      <td>T80</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-05-30 14:20:18.531115+00</td>\n",
              "      <td>2023-08-08 18:53:01.439561+00</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>t</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1269359</td>\n",
              "      <td>TFSA</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>t</td>\n",
              "      <td>5.0</td>\n",
              "      <td>C</td>\n",
              "      <td>2020-11-05</td>\n",
              "      <td>18.0</td>\n",
              "      <td>2020-03-09</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>IAVM</td>\n",
              "      <td>t</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>TF</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>1026</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>CAD</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>A</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>MRS.</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>2020-03-09</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>L99</td>\n",
              "      <td>M99</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>2022-10-20 00:00:00</td>\n",
              "      <td>ROMANAA</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0000</td>\n",
              "      <td>2020-03-09</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2020-03-09</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-05-30 14:20:18.531115+00</td>\n",
              "      <td>2023-08-10 21:47:25.370403+00</td>\n",
              "      <td>f</td>\n",
              "      <td>2022-10-20 00:00:00</td>\n",
              "      <td>ROMANAA</td>\n",
              "      <td>t</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>573181</td>\n",
              "      <td>CASH</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>t</td>\n",
              "      <td>3.0</td>\n",
              "      <td>T</td>\n",
              "      <td>NaN</td>\n",
              "      <td>17.0</td>\n",
              "      <td>2023-01-10</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>IAS</td>\n",
              "      <td>t</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>1137</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>CAD</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>A</td>\n",
              "      <td>JTWROS</td>\n",
              "      <td>NaN</td>\n",
              "      <td>MR</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>V</td>\n",
              "      <td>f</td>\n",
              "      <td>2023-01-10</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>M99</td>\n",
              "      <td>G99</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>2023-01-11 00:00:00</td>\n",
              "      <td>MEGHZFG</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-05-30 14:20:18.531115+00</td>\n",
              "      <td>2023-08-08 18:53:01.439561+00</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>t</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>967968</td>\n",
              "      <td>TFSA</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>t</td>\n",
              "      <td>5.0</td>\n",
              "      <td>A</td>\n",
              "      <td>2020-03-03</td>\n",
              "      <td>17.0</td>\n",
              "      <td>2017-07-21</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>IAS</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>TF</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>CAD</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>A</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>MR</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>2018-10-29</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>M99</td>\n",
              "      <td>G99</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>2021-08-06 00:00:00</td>\n",
              "      <td>T80</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0000</td>\n",
              "      <td>2017-07-21</td>\n",
              "      <td>2020-03-16</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2017-07-21</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-05-30 14:20:18.531115+00</td>\n",
              "      <td>2023-08-10 21:47:25.370403+00</td>\n",
              "      <td>f</td>\n",
              "      <td>2021-08-06 00:00:00</td>\n",
              "      <td>T80</td>\n",
              "      <td>f</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>595581</td>\n",
              "      <td>CASH</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>t</td>\n",
              "      <td>3.0</td>\n",
              "      <td>T</td>\n",
              "      <td>2011-04-01</td>\n",
              "      <td>17.0</td>\n",
              "      <td>2009-02-18</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>IAVM</td>\n",
              "      <td>t</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>BATCH</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>A</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>MR</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>V</td>\n",
              "      <td>f</td>\n",
              "      <td>2023-02-07</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>H10M90</td>\n",
              "      <td>B35G65</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>2023-05-08 00:00:00</td>\n",
              "      <td>BATCH</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-05-30 14:20:18.531115+00</td>\n",
              "      <td>2023-08-08 20:37:22.511698+00</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>t</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>168330</th>\n",
              "      <td>1047726</td>\n",
              "      <td>CASH</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>t</td>\n",
              "      <td>3.0</td>\n",
              "      <td>A</td>\n",
              "      <td>NaN</td>\n",
              "      <td>17.0</td>\n",
              "      <td>2017-07-21</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>IAVM</td>\n",
              "      <td>t</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>113F</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>CAD</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>A</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>MR</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>V</td>\n",
              "      <td>f</td>\n",
              "      <td>2017-07-24</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>H99</td>\n",
              "      <td>S99</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>2018-10-31 00:00:00</td>\n",
              "      <td>WONGU</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-05-30 14:20:18.531115+00</td>\n",
              "      <td>2023-08-08 18:53:01.439561+00</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>168331</th>\n",
              "      <td>888353</td>\n",
              "      <td>CASH SWEEP</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>t</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2017-08-18</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>IAVM</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>BATCH</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>A</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>V</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>2023-06-12 00:00:00</td>\n",
              "      <td>H01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-05-30 14:20:18.531115+00</td>\n",
              "      <td>2023-08-08 20:48:02.170633+00</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>168332</th>\n",
              "      <td>1090674</td>\n",
              "      <td>CASH</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>t</td>\n",
              "      <td>3.0</td>\n",
              "      <td>T</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12.0</td>\n",
              "      <td>2021-09-21</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>IAVM</td>\n",
              "      <td>t</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>11A0</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>A</td>\n",
              "      <td>JTWROS</td>\n",
              "      <td>NaN</td>\n",
              "      <td>MRS</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>V</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021-09-21</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>M99</td>\n",
              "      <td>B50G50</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>2023-04-27 00:00:00</td>\n",
              "      <td>CHHATWA</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-05-30 14:20:18.531115+00</td>\n",
              "      <td>2023-08-08 20:33:44.941805+00</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>t</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>168333</th>\n",
              "      <td>1034923</td>\n",
              "      <td>REG RRSP</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>f</td>\n",
              "      <td>5.0</td>\n",
              "      <td>A</td>\n",
              "      <td>2017-09-27</td>\n",
              "      <td>17.0</td>\n",
              "      <td>2017-07-21</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>IAVM</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>RS</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>BATCH</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>CAD</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>A</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>MRS</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>2017-07-24</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>2020-01-03 00:00:00</td>\n",
              "      <td>ISLUSR</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>00/0</td>\n",
              "      <td>2017-07-21</td>\n",
              "      <td>2017-10-02</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2017-07-21</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-05-30 14:20:18.531115+00</td>\n",
              "      <td>2023-08-10 21:47:25.370403+00</td>\n",
              "      <td>f</td>\n",
              "      <td>2018-06-15 00:00:00</td>\n",
              "      <td>BATCH</td>\n",
              "      <td>f</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>168334</th>\n",
              "      <td>1182775</td>\n",
              "      <td>CASH SWEEP</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>CAD</td>\n",
              "      <td>t</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2017-08-18</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>IAVM</td>\n",
              "      <td>t</td>\n",
              "      <td>t</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>BATCH</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>CAD</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>A</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>t</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>V</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>0.0</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>f</td>\n",
              "      <td>t</td>\n",
              "      <td>2017-08-18 00:00:00</td>\n",
              "      <td>BATCH</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-05-30 14:20:18.531115+00</td>\n",
              "      <td>2023-08-08 18:53:01.439561+00</td>\n",
              "      <td>f</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>t</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>168335 rows × 105 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-77496caa-533f-4d07-97fe-a31db937a3ca')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-77496caa-533f-4d07-97fe-a31db937a3ca button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-77496caa-533f-4d07-97fe-a31db937a3ca');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-f20a05a1-22d2-42e8-9723-697319858f72\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-f20a05a1-22d2-42e8-9723-697319858f72')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-f20a05a1-22d2-42e8-9723-697319858f72 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_a3a10090-6c57-403c-8006-b10585ffcb2d\">\n",
              "    <style>\n",
              "      .colab-df-generate {\n",
              "        background-color: #E8F0FE;\n",
              "        border: none;\n",
              "        border-radius: 50%;\n",
              "        cursor: pointer;\n",
              "        display: none;\n",
              "        fill: #1967D2;\n",
              "        height: 32px;\n",
              "        padding: 0 0 0 0;\n",
              "        width: 32px;\n",
              "      }\n",
              "\n",
              "      .colab-df-generate:hover {\n",
              "        background-color: #E2EBFA;\n",
              "        box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "        fill: #174EA6;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate:hover {\n",
              "        background-color: #434B5C;\n",
              "        box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "        filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "        fill: #FFFFFF;\n",
              "      }\n",
              "    </style>\n",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('df')\"\n",
              "            title=\"Generate code using this dataframe.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_a3a10090-6c57-403c-8006-b10585ffcb2d button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('df');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {}
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "None\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(168335, 105)"
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.iloc[62]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 524
        },
        "id": "AWrJMcB_fRG9",
        "outputId": "d9acad6f-1b0f-4692-bf5a-48ef9cd7f18c"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "error",
          "ename": "KeyError",
          "evalue": "62",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   3801\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3802\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcasted_key\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3803\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;31mKeyError\u001b[0m: 62",
            "\nThe above exception was the direct cause of the following exception:\n",
            "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-22-e24d9f0e9f67>\u001b[0m in \u001b[0;36m<cell line: 1>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m62\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   3805\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mnlevels\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3806\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_multilevel\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3807\u001b[0;31m             \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3808\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mis_integer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mindexer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3809\u001b[0m                 \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0mindexer\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   3802\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcasted_key\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3803\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3804\u001b[0;31m                 \u001b[0;32mraise\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mfrom\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3805\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mTypeError\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3806\u001b[0m                 \u001b[0;31m# If we have a listlike key, _check_indexing_error will raise\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mKeyError\u001b[0m: 62"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "YVqnBc9Ffxy3"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}