diff options
| -rw-r--r-- | ui_security_inventory_23_parsing.ipynb | 623 |
1 files changed, 19 insertions, 604 deletions
diff --git a/ui_security_inventory_23_parsing.ipynb b/ui_security_inventory_23_parsing.ipynb index 84be050..0091ac6 100644 --- a/ui_security_inventory_23_parsing.ipynb +++ b/ui_security_inventory_23_parsing.ipynb @@ -2,7 +2,7 @@ "cells": [ { "cell_type": "code", - "execution_count": 1, + "execution_count": null, "id": "8ce6b023", "metadata": {}, "outputs": [], @@ -15,18 +15,10 @@ }, { "cell_type": "code", - "execution_count": 2, + "execution_count": null, "id": "8304939a", "metadata": {}, - "outputs": [ - { - "name": "stdout", - "output_type": "stream", - "text": [ - "Sheet1\n" - ] - } - ], + "outputs": [], "source": [ "file_path_23 = \"./data/23-138.Records.xlsx\"\n", " # skip header rows so column names align, drop all NaN rows\n", @@ -43,147 +35,10 @@ }, { "cell_type": "code", - "execution_count": 3, + "execution_count": null, "id": "96dee5bc", "metadata": {}, - "outputs": [ - { - "data": { - "text/html": [ - "<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>Account or Security</th>\n", - " <th>Coupon</th>\n", - " <th>Date</th>\n", - " <th>Quantity</th>\n", - " <th>Cost Value</th>\n", - " <th>Market Value</th>\n", - " <th>Bank</th>\n", - " <th>Asset Type</th>\n", - " <th>Company</th>\n", - " <th>Industry</th>\n", - " <th>Private Placement</th>\n", - " </tr>\n", - " </thead>\n", - " <tbody>\n", - " <tr>\n", - " <th>36</th>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>37</th>\n", - " <td>Asset-Backed Securities</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>38</th>\n", - " <td>CHASE FDG MTG LN 2004-1 MTG LN</td>\n", - " <td>2.08</td>\n", - " <td>1933-12-25 00:00:00</td>\n", - " <td>6462.53</td>\n", - " <td>6462.53</td>\n", - " <td>6068.88</td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>39</th>\n", - " <td>MVW 2021-2 LLC TIMESHARE LN BK</td>\n", - " <td>1.43</td>\n", - " <td>1939-05-20 00:00:00</td>\n", - " <td>737880.25</td>\n", - " <td>737679.54</td>\n", - " <td>672033.22</td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>40</th>\n", - " <td>PFS FING CORP .77% 08-15-2026</td>\n", - " <td>0.77</td>\n", - " <td>2026-08-15 00:00:00</td>\n", - " <td>1090000.00</td>\n", - " <td>1089872.25</td>\n", - " <td>1010524.50</td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " </tbody>\n", - "</table>\n", - "</div>" - ], - "text/plain": [ - " Account or Security Coupon Date Quantity \\\n", - "36 9-200100-Neuberger Intermediate NaN NaN NaN \n", - "37 Asset-Backed Securities NaN NaN NaN \n", - "38 CHASE FDG MTG LN 2004-1 MTG LN 2.08 1933-12-25 00:00:00 6462.53 \n", - "39 MVW 2021-2 LLC TIMESHARE LN BK 1.43 1939-05-20 00:00:00 737880.25 \n", - "40 PFS FING CORP .77% 08-15-2026 0.77 2026-08-15 00:00:00 1090000.00 \n", - "\n", - " Cost Value Market Value Bank Asset Type Company Industry \\\n", - "36 NaN NaN <NA> <NA> <NA> <NA> \n", - "37 NaN NaN <NA> <NA> <NA> <NA> \n", - "38 6462.53 6068.88 <NA> <NA> <NA> <NA> \n", - "39 737679.54 672033.22 <NA> <NA> <NA> <NA> \n", - "40 1089872.25 1010524.50 <NA> <NA> <NA> <NA> \n", - "\n", - " Private Placement \n", - "36 False \n", - "37 False \n", - "38 False \n", - "39 False \n", - "40 False " - ] - }, - "execution_count": 3, - "metadata": {}, - "output_type": "execute_result" - } - ], + "outputs": [], "source": [ "bank_i = df[df['Account or Security'].str.contains(\"9-200100\", na=False)].index\n", "op_i = df[df['Account or Security'].str.contains(\"Operating Funds Pool\", na=False)].index\n", @@ -207,147 +62,10 @@ }, { "cell_type": "code", - "execution_count": 4, + "execution_count": null, "id": "29c95d09", "metadata": {}, - "outputs": [ - { - "data": { - "text/html": [ - "<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>Account or Security</th>\n", - " <th>Coupon</th>\n", - " <th>Date</th>\n", - " <th>Quantity</th>\n", - " <th>Cost Value</th>\n", - " <th>Market Value</th>\n", - " <th>Bank</th>\n", - " <th>Asset Type</th>\n", - " <th>Company</th>\n", - " <th>Industry</th>\n", - " <th>Private Placement</th>\n", - " </tr>\n", - " </thead>\n", - " <tbody>\n", - " <tr>\n", - " <th>36</th>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>37</th>\n", - " <td>Asset-Backed Securities</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td>Asset-Backed Securities</td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>38</th>\n", - " <td>CHASE FDG MTG LN 2004-1 MTG LN</td>\n", - " <td>2.08</td>\n", - " <td>1933-12-25 00:00:00</td>\n", - " <td>6462.53</td>\n", - " <td>6462.53</td>\n", - " <td>6068.88</td>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td>Asset-Backed Securities</td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>39</th>\n", - " <td>MVW 2021-2 LLC TIMESHARE LN BK</td>\n", - " <td>1.43</td>\n", - " <td>1939-05-20 00:00:00</td>\n", - " <td>737880.25</td>\n", - " <td>737679.54</td>\n", - " <td>672033.22</td>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td>Asset-Backed Securities</td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>40</th>\n", - " <td>PFS FING CORP .77% 08-15-2026</td>\n", - " <td>0.77</td>\n", - " <td>2026-08-15 00:00:00</td>\n", - " <td>1090000.00</td>\n", - " <td>1089872.25</td>\n", - " <td>1010524.50</td>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td>Asset-Backed Securities</td>\n", - " <td><NA></td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " </tbody>\n", - "</table>\n", - "</div>" - ], - "text/plain": [ - " Account or Security Coupon Date Quantity \\\n", - "36 9-200100-Neuberger Intermediate NaN NaN NaN \n", - "37 Asset-Backed Securities NaN NaN NaN \n", - "38 CHASE FDG MTG LN 2004-1 MTG LN 2.08 1933-12-25 00:00:00 6462.53 \n", - "39 MVW 2021-2 LLC TIMESHARE LN BK 1.43 1939-05-20 00:00:00 737880.25 \n", - "40 PFS FING CORP .77% 08-15-2026 0.77 2026-08-15 00:00:00 1090000.00 \n", - "\n", - " Cost Value Market Value Bank \\\n", - "36 NaN NaN 9-200100-Neuberger Intermediate \n", - "37 NaN NaN 9-200100-Neuberger Intermediate \n", - "38 6462.53 6068.88 9-200100-Neuberger Intermediate \n", - "39 737679.54 672033.22 9-200100-Neuberger Intermediate \n", - "40 1089872.25 1010524.50 9-200100-Neuberger Intermediate \n", - "\n", - " Asset Type Company Industry Private Placement \n", - "36 <NA> <NA> <NA> False \n", - "37 Asset-Backed Securities <NA> <NA> False \n", - "38 Asset-Backed Securities <NA> <NA> False \n", - "39 Asset-Backed Securities <NA> <NA> False \n", - "40 Asset-Backed Securities <NA> <NA> False " - ] - }, - "execution_count": 4, - "metadata": {}, - "output_type": "execute_result" - } - ], + "outputs": [], "source": [ "bank_name = pd.NA\n", "asset_type = pd.NA\n", @@ -364,41 +82,10 @@ }, { "cell_type": "code", - "execution_count": 5, + "execution_count": null, "id": "3ea40a3e", "metadata": {}, - "outputs": [ - { - "data": { - "text/plain": [ - "{<NA>,\n", - " 'Account Totals',\n", - " 'Account Totals - Allspring Conservative Income Fund',\n", - " 'Account Totals - Allspring Short Duration',\n", - " 'Account Totals - Galliard Capital',\n", - " 'Account Totals - Income Research Intermediate',\n", - " 'Account Totals - Income Research Short Duration',\n", - " 'Account Totals - JP Morgan Managed Reserves ',\n", - " 'Account Totals - Neuberger Berman Enhanced Cash',\n", - " 'Account Totals - Neuberger Intermediate',\n", - " 'Account Totals - Northern Trust UI Short Duration',\n", - " 'Asset Backed Securities',\n", - " 'Asset-Backed Securities',\n", - " 'Cash & Cash Equivalents',\n", - " 'Commercial Mortgage Backed Securities',\n", - " 'Commercial Paper',\n", - " 'Corporate Bonds',\n", - " 'International Government Bonds',\n", - " 'Municipal Bonds',\n", - " 'U.S. Agency Bonds',\n", - " 'U.S. Treasury Securities'}" - ] - }, - "execution_count": 5, - "metadata": {}, - "output_type": "execute_result" - } - ], + "outputs": [], "source": [ "all_asset_types = set([op_df.loc[i]['Asset Type'] for i in op_df.index]);all_asset_types" ] @@ -413,20 +100,10 @@ }, { "cell_type": "code", - "execution_count": 6, + "execution_count": null, "id": "fe124c92", "metadata": {}, - "outputs": [ - { - "name": "stdout", - "output_type": "stream", - "text": [ - "Corperate Bond Totals\n", - "Cost Value\t $1,020,500,769.44\n", - "Market Value\t $985,000,673.71\n" - ] - } - ], + "outputs": [], "source": [ "cb_df = op_df[op_df['Asset Type'].str.contains(\"Corporate Bonds\", na=False)]\n", "print(\"Corperate Bond Totals\")\n", @@ -457,7 +134,7 @@ }, { "cell_type": "code", - "execution_count": 7, + "execution_count": null, "id": "d78a9733", "metadata": {}, "outputs": [], @@ -556,7 +233,7 @@ }, { "cell_type": "code", - "execution_count": 8, + "execution_count": null, "id": "659c0ba7", "metadata": {}, "outputs": [], @@ -588,21 +265,10 @@ }, { "cell_type": "code", - "execution_count": 9, + "execution_count": null, "id": "0ba92284", "metadata": {}, - "outputs": [ - { - "data": { - "text/plain": [ - "408" - ] - }, - "execution_count": 9, - "metadata": {}, - "output_type": "execute_result" - } - ], + "outputs": [], "source": [ "len(company_names)" ] @@ -617,252 +283,10 @@ }, { "cell_type": "code", - "execution_count": 10, + "execution_count": null, "id": "e7e06dfe", "metadata": {}, - "outputs": [ - { - "data": { - "text/html": [ - "<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>Account or Security</th>\n", - " <th>Coupon</th>\n", - " <th>Date</th>\n", - " <th>Quantity</th>\n", - " <th>Cost Value</th>\n", - " <th>Market Value</th>\n", - " <th>Bank</th>\n", - " <th>Asset Type</th>\n", - " <th>Company</th>\n", - " <th>Industry</th>\n", - " <th>Private Placement</th>\n", - " </tr>\n", - " </thead>\n", - " <tbody>\n", - " <tr>\n", - " <th>103</th>\n", - " <td>Corporate Bonds</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>NaN</td>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td>Corporate Bonds</td>\n", - " <td>Corporate Bonds</td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>104</th>\n", - " <td>ABBVIE INC 2.6% DUE 11-21-2024</td>\n", - " <td>2.6</td>\n", - " <td>2024-11-21 00:00:00</td>\n", - " <td>1065000.0</td>\n", - " <td>1135158.13</td>\n", - " <td>1030877.86</td>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td>Corporate Bonds</td>\n", - " <td>ABBVIE INC</td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>105</th>\n", - " <td>ABBVIE INC 2.95% DUE</td>\n", - " <td>2.95</td>\n", - " <td>2026-11-21 00:00:00</td>\n", - " <td>495000.0</td>\n", - " <td>545836.80</td>\n", - " <td>469035.55</td>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td>Corporate Bonds</td>\n", - " <td>ABBVIE INC</td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>106</th>\n", - " <td>AERCAP IRELAND CAP / GLOBA 3.0</td>\n", - " <td>3</td>\n", - " <td>2028-10-29 00:00:00</td>\n", - " <td>440000.0</td>\n", - " <td>439199.20</td>\n", - " <td>370620.29</td>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td>Corporate Bonds</td>\n", - " <td>AERCAP IRELAND CAP</td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>107</th>\n", - " <td>AERCAP IRELAND CAP / GLOBA</td>\n", - " <td>3.56</td>\n", - " <td>1932-01-30 00:00:00</td>\n", - " <td>430000.0</td>\n", - " <td>428383.20</td>\n", - " <td>344211.28</td>\n", - " <td>9-200100-Neuberger Intermediate</td>\n", - " <td>Corporate Bonds</td>\n", - " <td>AERCAP IRELAND CAP</td>\n", - " <td><NA></td>\n", - " <td>False</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", - " </tr>\n", - " <tr>\n", - " <th>2706</th>\n", - " <td>UBS AG LONDON BRH NT FLTG RATE</td>\n", - " <td>1.39</td>\n", - " <td>2024-08-09 00:00:00</td>\n", - " <td>1766000.0</td>\n", - " <td>1766000.00</td>\n", - " <td>1754003.40</td>\n", - " <td>9-200100-JP Morgan Managed Reserves</td>\n", - " <td>Corporate Bonds</td>\n", - " <td>UBS AG LONDON</td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>2707</th>\n", - " <td>UBS GROUP FDG SWITZ AG NT FLTG</td>\n", - " <td>2.36</td>\n", - " <td>2023-08-15 00:00:00</td>\n", - " <td>2000000.0</td>\n", - " <td>1999460.00</td>\n", - " <td>1999374.24</td>\n", - " <td>9-200100-JP Morgan Managed Reserves</td>\n", - " <td>Corporate Bonds</td>\n", - " <td>UBS AG LONDON</td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>2708</th>\n", - " <td>UNITED PARCEL SVC INC 2.45% DU</td>\n", - " <td>2.45</td>\n", - " <td>2022-10-01 00:00:00</td>\n", - " <td>145000.0</td>\n", - " <td>148575.70</td>\n", - " <td>144922.71</td>\n", - " <td>9-200100-JP Morgan Managed Reserves</td>\n", - " <td>Corporate Bonds</td>\n", - " <td>UNITED PARCEL SVC INC</td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>2709</th>\n", - " <td>WESTPAC BKG CORP 2.0% DUE 01-1</td>\n", - " <td>2</td>\n", - " <td>2023-01-13 00:00:00</td>\n", - " <td>72000.0</td>\n", - " <td>73785.60</td>\n", - " <td>71637.73</td>\n", - " <td>9-200100-JP Morgan Managed Reserves</td>\n", - " <td>Corporate Bonds</td>\n", - " <td>WESTPAC BANKING</td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " <tr>\n", - " <th>2710</th>\n", - " <td>WESTPAC BKG CORP 2.75% DUE 01-</td>\n", - " <td>2.75</td>\n", - " <td>2023-01-11 00:00:00</td>\n", - " <td>2497000.0</td>\n", - " <td>2589713.61</td>\n", - " <td>2492680.54</td>\n", - " <td>9-200100-JP Morgan Managed Reserves</td>\n", - " <td>Corporate Bonds</td>\n", - " <td>WESTPAC BANKING</td>\n", - " <td><NA></td>\n", - " <td>False</td>\n", - " </tr>\n", - " </tbody>\n", - "</table>\n", - "<p>1222 rows × 11 columns</p>\n", - "</div>" - ], - "text/plain": [ - " Account or Security Coupon Date Quantity \\\n", - "103 Corporate Bonds NaN NaN NaN \n", - "104 ABBVIE INC 2.6% DUE 11-21-2024 2.6 2024-11-21 00:00:00 1065000.0 \n", - "105 ABBVIE INC 2.95% DUE 2.95 2026-11-21 00:00:00 495000.0 \n", - "106 AERCAP IRELAND CAP / GLOBA 3.0 3 2028-10-29 00:00:00 440000.0 \n", - "107 AERCAP IRELAND CAP / GLOBA 3.56 1932-01-30 00:00:00 430000.0 \n", - "... ... ... ... ... \n", - "2706 UBS AG LONDON BRH NT FLTG RATE 1.39 2024-08-09 00:00:00 1766000.0 \n", - "2707 UBS GROUP FDG SWITZ AG NT FLTG 2.36 2023-08-15 00:00:00 2000000.0 \n", - "2708 UNITED PARCEL SVC INC 2.45% DU 2.45 2022-10-01 00:00:00 145000.0 \n", - "2709 WESTPAC BKG CORP 2.0% DUE 01-1 2 2023-01-13 00:00:00 72000.0 \n", - "2710 WESTPAC BKG CORP 2.75% DUE 01- 2.75 2023-01-11 00:00:00 2497000.0 \n", - "\n", - " Cost Value Market Value Bank \\\n", - "103 NaN NaN 9-200100-Neuberger Intermediate \n", - "104 1135158.13 1030877.86 9-200100-Neuberger Intermediate \n", - "105 545836.80 469035.55 9-200100-Neuberger Intermediate \n", - "106 439199.20 370620.29 9-200100-Neuberger Intermediate \n", - "107 428383.20 344211.28 9-200100-Neuberger Intermediate \n", - "... ... ... ... \n", - "2706 1766000.00 1754003.40 9-200100-JP Morgan Managed Reserves \n", - "2707 1999460.00 1999374.24 9-200100-JP Morgan Managed Reserves \n", - "2708 148575.70 144922.71 9-200100-JP Morgan Managed Reserves \n", - "2709 73785.60 71637.73 9-200100-JP Morgan Managed Reserves \n", - "2710 2589713.61 2492680.54 9-200100-JP Morgan Managed Reserves \n", - "\n", - " Asset Type Company Industry Private Placement \n", - "103 Corporate Bonds Corporate Bonds <NA> False \n", - "104 Corporate Bonds ABBVIE INC <NA> False \n", - "105 Corporate Bonds ABBVIE INC <NA> False \n", - "106 Corporate Bonds AERCAP IRELAND CAP <NA> False \n", - "107 Corporate Bonds AERCAP IRELAND CAP <NA> False \n", - "... ... ... ... ... \n", - "2706 Corporate Bonds UBS AG LONDON <NA> False \n", - "2707 Corporate Bonds UBS AG LONDON <NA> False \n", - "2708 Corporate Bonds UNITED PARCEL SVC INC <NA> False \n", - "2709 Corporate Bonds WESTPAC BANKING <NA> False \n", - "2710 Corporate Bonds WESTPAC BANKING <NA> False \n", - "\n", - "[1222 rows x 11 columns]" - ] - }, - "execution_count": 10, - "metadata": {}, - "output_type": "execute_result" - } - ], + "outputs": [], "source": [ "cb_df" ] @@ -877,19 +301,10 @@ }, { "cell_type": "code", - "execution_count": 11, + "execution_count": null, "id": "6fe3d0df", "metadata": {}, - "outputs": [ - { - "name": "stdout", - "output_type": "stream", - "text": [ - "WARNING: No decryption keys could be extracted from JS file. Falling back to backup decrypt methods.\n", - "Drug Manufacturers—General\n" - ] - } - ], + "outputs": [], "source": [ "# Replace \"company_name\" with the name of the company you're searching for\n", "company_name = \"ABBV\"\n", |