summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorIgor Radovanovic <74266147+IgorWounds@users.noreply.github.com>2023-11-27 23:39:42 +0100
committerIgor Radovanovic <74266147+IgorWounds@users.noreply.github.com>2023-11-27 23:39:42 +0100
commitfc5ea9d9cc9c7ab262ed14b988393f258fdbddd8 (patch)
treef759024cf2025721cf08c7a031ea3778f29aba35
parent7d8c544f173005a469d60831bc6c6b6ea9781a99 (diff)
-rw-r--r--examples/financialStatements.ipynb750
-rw-r--r--examples/findSymbols.ipynb1180
-rw-r--r--examples/loadHistoricalPriceData.ipynb1713
3 files changed, 71 insertions, 3572 deletions
diff --git a/examples/financialStatements.ipynb b/examples/financialStatements.ipynb
index 12db7e4874c..15859f43159 100644
--- a/examples/financialStatements.ipynb
+++ b/examples/financialStatements.ipynb
@@ -38,82 +38,9 @@
},
{
"cell_type": "code",
- "execution_count": 1,
+ "execution_count": null,
"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>yfinance</th>\n",
- " <th>fmp</th>\n",
- " <th>intrinio</th>\n",
- " <th>polygon</th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>0</th>\n",
- " <td>42779000000</td>\n",
- " <td>42779000000</td>\n",
- " <td>42779000000</td>\n",
- " <td>42779000000</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>1</th>\n",
- " <td>51248000000</td>\n",
- " <td>51248000000</td>\n",
- " <td>51248000000</td>\n",
- " <td>51248000000</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>2</th>\n",
- " <td>53811000000</td>\n",
- " <td>53811000000</td>\n",
- " <td>53811000000</td>\n",
- " <td>53811000000</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>3</th>\n",
- " <td>53335000000</td>\n",
- " <td>53335000000</td>\n",
- " <td>53335000000</td>\n",
- " <td>53335000000</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "</div>"
- ],
- "text/plain": [
- " yfinance fmp intrinio polygon\n",
- "0 42779000000 42779000000 42779000000 42779000000\n",
- "1 51248000000 51248000000 51248000000 51248000000\n",
- "2 53811000000 53811000000 53811000000 53811000000\n",
- "3 53335000000 53335000000 53335000000 53335000000"
- ]
- },
- "execution_count": 1,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"from openbb import obb\n",
"import pandas as pd\n",
@@ -158,32 +85,9 @@
},
{
"cell_type": "code",
- "execution_count": 2,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "date\n",
- "1986-07-31 1168.816\n",
- "Name: weighted_average_shares_outstanding, dtype: float64"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- },
- {
- "data": {
- "text/plain": [
- "date\n",
- "2023-10-31 461.6\n",
- "Name: weighted_average_shares_outstanding, dtype: float64"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- }
- ],
+ "outputs": [],
"source": [
"data = (\n",
" obb.equity.fundamental.income(\"TGT\", provider=\"fmp\", limit=150, period=\"quarter\")\n",
@@ -206,28 +110,9 @@
},
{
"cell_type": "code",
- "execution_count": 3,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "-0.12226659060657907"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- },
- {
- "data": {
- "text/plain": [
- "-1.3000000000000114"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- }
- ],
+ "outputs": [],
"source": [
"display(shares.pct_change(20).iloc[-1])\n",
"\n",
@@ -243,20 +128,9 @@
},
{
"cell_type": "code",
- "execution_count": 4,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "187.55"
- ]
- },
- "execution_count": 4,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"price = (\n",
" obb.equity.price.historical(\"TGT\", start_date=\"2022-10-01\", provider=\"fmp\")\n",
@@ -277,25 +151,9 @@
},
{
"cell_type": "code",
- "execution_count": 5,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "date\n",
- "2023-01-28 -1.079731\n",
- "2023-04-29 -1.078325\n",
- "2023-07-29 -1.081023\n",
- "2023-10-31 -1.098354\n",
- "Name: div_per_share, dtype: float64"
- ]
- },
- "execution_count": 5,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"dividends = (\n",
" obb.equity.fundamental.cash(\"TGT\", provider=\"fmp\", limit=150, period=\"quarter\")\n",
@@ -317,25 +175,9 @@
},
{
"cell_type": "code",
- "execution_count": 6,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "date\n",
- "2022-11-15 1.08\n",
- "2023-02-14 1.08\n",
- "2023-05-16 1.08\n",
- "2023-08-15 1.10\n",
- "Name: dividend, dtype: float64"
- ]
- },
- "execution_count": 6,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"(\n",
" obb.equity.fundamental.dividends(\"TGT\", provider=\"fmp\")\n",
@@ -361,264 +203,9 @@
},
{
"cell_type": "code",
- "execution_count": 7,
+ "execution_count": null,
"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>id</th>\n",
- " <th>name</th>\n",
- " <th>tag</th>\n",
- " <th>statement_code</th>\n",
- " <th>statement_type</th>\n",
- " <th>parent_name</th>\n",
- " <th>sequence</th>\n",
- " <th>factor</th>\n",
- " <th>transaction</th>\n",
- " <th>type</th>\n",
- " <th>unit</th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>0</th>\n",
- " <td>tag_BgkbWy</td>\n",
- " <td>Market Capitalization</td>\n",
- " <td>marketcap</td>\n",
- " <td>calculations</td>\n",
- " <td>industrial</td>\n",
- " <td>None</td>\n",
- " <td>NaN</td>\n",
- " <td>None</td>\n",
- " <td>None</td>\n",
- " <td>valuation</td>\n",
- " <td>usd</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>1</th>\n",
- " <td>tag_kylOqz</td>\n",
- " <td>Market Capitalization</td>\n",
- " <td>marketcap</td>\n",
- " <td>calculations</td>\n",
- " <td>financial</td>\n",
- " <td>None</td>\n",
- " <td>NaN</td>\n",
- " <td>None</td>\n",
- " <td>None</td>\n",
- " <td>valuation</td>\n",
- " <td>usd</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>2</th>\n",
- " <td>tag_XLRlqy</td>\n",
- " <td>Market Sector</td>\n",
- " <td>market_sector</td>\n",
- " <td>current</td>\n",
- " <td>None</td>\n",
- " <td>None</td>\n",
- " <td>NaN</td>\n",
- " <td>None</td>\n",
- " <td>None</td>\n",
- " <td>security</td>\n",
- " <td>string</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>3</th>\n",
- " <td>tag_2gBA8y</td>\n",
- " <td>Market Category</td>\n",
- " <td>market_category</td>\n",
- " <td>current</td>\n",
- " <td>None</td>\n",
- " <td>None</td>\n",
- " <td>NaN</td>\n",
- " <td>None</td>\n",
- " <td>None</td>\n",
- " <td>security</td>\n",
- " <td>string</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>4</th>\n",
- " <td>tag_DzonXe</td>\n",
- " <td>Marketing Expense</td>\n",
- " <td>marketingexpense</td>\n",
- " <td>income_statement</td>\n",
- " <td>industrial</td>\n",
- " <td>totaloperatingexpenses</td>\n",
- " <td>9.0</td>\n",
- " <td>+</td>\n",
- " <td>debit</td>\n",
- " <td>income_statement_metric</td>\n",
- " <td>usd</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>95</th>\n",
- " <td>tag_nzJAmX</td>\n",
- " <td>Total Long-Term Debt</td>\n",
- " <td>ltdebtandcapleases</td>\n",
- " <td>calculations</td>\n",
- " <td>financial</td>\n",
- " <td>None</td>\n",
- " <td>NaN</td>\n",
- " <td>None</td>\n",
- " <td>None</td>\n",
- " <td>metric</td>\n",
- " <td>usd</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>96</th>\n",
- " <td>tag_9XaL5g</td>\n",
- " <td>Other Net Changes in Cash</td>\n",
- " <td>othernetchangesincash</td>\n",
- " <td>cash_flow_statement</td>\n",
- " <td>industrial</td>\n",
- " <td>netchangeincash</td>\n",
- " <td>33.0</td>\n",
- " <td>+</td>\n",
- " <td>debit</td>\n",
- " <td>cash_flow_statement_metric</td>\n",
- " <td>usd</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>97</th>\n",
- " <td>tag_5X7p6z</td>\n",
- " <td>Other Net Changes in Cash</td>\n",
- " <td>othernetchangesincash</td>\n",
- " <td>cash_flow_statement</td>\n",
- " <td>financial</td>\n",
- " <td>netchangeincash</td>\n",
- " <td>37.0</td>\n",
- " <td>+</td>\n",
- " <td>debit</td>\n",
- " <td>cash_flow_statement_metric</td>\n",
- " <td>usd</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>98</th>\n",
- " <td>tag_qzEwng</td>\n",
- " <td>Changes in Operating Assets and Liabilities, net</td>\n",
- " <td>increasedecreaseinoperatingcapital</td>\n",
- " <td>cash_flow_statement</td>\n",
- " <td>financial</td>\n",
- " <td>netcashfromcontinuingoperatingactivities</td>\n",
- " <td>8.0</td>\n",
- " <td>+</td>\n",
- " <td>debit</td>\n",
- " <td>cash_flow_statement_metric</td>\n",
- " <td>usd</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>99</th>\n",
- " <td>tag_pgVB2g</td>\n",
- " <td>Changes in Operating Assets and Liabilities, net</td>\n",
- " <td>increasedecreaseinoperatingcapital</td>\n",
- " <td>cash_flow_statement</td>\n",
- " <td>industrial</td>\n",
- " <td>netcashfromcontinuingoperatingactivities</td>\n",
- " <td>7.0</td>\n",
- " <td>+</td>\n",
- " <td>debit</td>\n",
- " <td>cash_flow_statement_metric</td>\n",
- " <td>usd</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "<p>100 rows × 11 columns</p>\n",
- "</div>"
- ],
- "text/plain": [
- " id name \\\n",
- "0 tag_BgkbWy Market Capitalization \n",
- "1 tag_kylOqz Market Capitalization \n",
- "2 tag_XLRlqy Market Sector \n",
- "3 tag_2gBA8y Market Category \n",
- "4 tag_DzonXe Marketing Expense \n",
- ".. ... ... \n",
- "95 tag_nzJAmX Total Long-Term Debt \n",
- "96 tag_9XaL5g Other Net Changes in Cash \n",
- "97 tag_5X7p6z Other Net Changes in Cash \n",
- "98 tag_qzEwng Changes in Operating Assets and Liabilities, net \n",
- "99 tag_pgVB2g Changes in Operating Assets and Liabilities, net \n",
- "\n",
- " tag statement_code statement_type \\\n",
- "0 marketcap calculations industrial \n",
- "1 marketcap calculations financial \n",
- "2 market_sector current None \n",
- "3 market_category current None \n",
- "4 marketingexpense income_statement industrial \n",
- ".. ... ... ... \n",
- "95 ltdebtandcapleases calculations financial \n",
- "96 othernetchangesincash cash_flow_statement industrial \n",
- "97 othernetchangesincash cash_flow_statement financial \n",
- "98 increasedecreaseinoperatingcapital cash_flow_statement financial \n",
- "99 increasedecreaseinoperatingcapital cash_flow_statement industrial \n",
- "\n",
- " parent_name sequence factor transaction \\\n",
- "0 None NaN None None \n",
- "1 None NaN None None \n",
- "2 None NaN None None \n",
- "3 None NaN None None \n",
- "4 totaloperatingexpenses 9.0 + debit \n",
- ".. ... ... ... ... \n",
- "95 None NaN None None \n",
- "96 netchangeincash 33.0 + debit \n",
- "97 netchangeincash 37.0 + debit \n",
- "98 netcashfromcontinuingoperatingactivities 8.0 + debit \n",
- "99 netcashfromcontinuingoperatingactivities 7.0 + debit \n",
- "\n",
- " type unit \n",
- "0 valuation usd \n",
- "1 valuation usd \n",
- "2 security string \n",
- "3 security string \n",
- "4 income_statement_metric usd \n",
- ".. ... ... \n",
- "95 metric usd \n",
- "96 cash_flow_statement_metric usd \n",
- "97 cash_flow_statement_metric usd \n",
- "98 cash_flow_statement_metric usd \n",
- "99 cash_flow_statement_metric usd \n",
- "\n",
- "[100 rows x 11 columns]"
- ]
- },
- "execution_count": 7,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"(\n",
" obb.equity.fundamental.search_financial_attributes(\"marketcap\")\n",
@@ -635,77 +222,9 @@
},
{
"cell_type": "code",
- "execution_count": 8,
+ "execution_count": null,
"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>value</th>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>date</th>\n",
- " <th></th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>2022-12-31</th>\n",
- " <td>6.692963e+10</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>2023-03-31</th>\n",
- " <td>7.502370e+10</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>2023-06-30</th>\n",
- " <td>5.991695e+10</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>2023-09-30</th>\n",
- " <td>5.061437e+10</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>2023-11-22</th>\n",
- " <td>6.049500e+10</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "</div>"
- ],
- "text/plain": [
- " value\n",
- "date \n",
- "2022-12-31 6.692963e+10\n",
- "2023-03-31 7.502370e+10\n",
- "2023-06-30 5.991695e+10\n",
- "2023-09-30 5.061437e+10\n",
- "2023-11-22 6.049500e+10"
- ]
- },
- "execution_count": 8,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"marketcap = (\n",
" obb.equity.fundamental.financial_attributes(symbol=\"TGT\", tag = \"marketcap\", period=\"quarter\")\n",
@@ -724,20 +243,9 @@
},
{
"cell_type": "code",
- "execution_count": 9,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "-0.24376733082703084"
- ]
- },
- "execution_count": 9,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"(\n",
" (marketcap.loc[\"2023-09-30\"] - marketcap.loc[\"2022-12-31\"])/marketcap.loc[\"2022-12-31\"]\n",
@@ -761,28 +269,9 @@
},
{
"cell_type": "code",
- "execution_count": 28,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "'Current Quick Ratio: 0.2701'"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- },
- {
- "data": {
- "text/plain": [
- "'Median Quick Ratio: 0.5844'"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- }
- ],
+ "outputs": [],
"source": [
"ratios = (\n",
" obb.equity.fundamental.ratios(\"TGT\", limit=50, provider=\"fmp\")\n",
@@ -806,204 +295,9 @@
},
{
"cell_type": "code",
- "execution_count": 26,
+ "execution_count": null,
"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>calendar_year</th>\n",
- " <th>2023</th>\n",
- " <th>2022</th>\n",
- " <th>2021</th>\n",
- " <th>2020</th>\n",
- " <th>2019</th>\n",
- " <th>2018</th>\n",
- " <th>2017</th>\n",
- " <th>2016</th>\n",
- " <th>2015</th>\n",
- " <th>2014</th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>Costco Wholesale Corporation</th>\n",
- " <td>0.027922</td>\n",
- " <td>0.014860</td>\n",
- " <td>0.026582</td>\n",
- " <td>0.039351</td>\n",
- " <td>0.025906</td>\n",
- " <td>0.027438</td>\n",
- " <td>0.060884</td>\n",
- " <td>0.008941</td>\n",
- " <td>0.030741</td>\n",
- " <td>0.037483</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>BJ's Wholesale Club Holdings, Inc.</th>\n",
- " <td>NaN</td>\n",
- " <td>0.044709</td>\n",
- " <td>0.067213</td>\n",
- " <td>0.113551</td>\n",
- " <td>0.056630</td>\n",
- " <td>0.091107</td>\n",
- " <td>0.026186</td>\n",
- " <td>0.065871</td>\n",
- " <td>0.016947</td>\n",
- " <td>NaN</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Dollar Tree, Inc.</th>\n",
- " <td>NaN</td>\n",
- " <td>0.010756</td>\n",
- " <td>0.013957</td>\n",
- " <td>0.075627</td>\n",
- " <td>0.040338</td>\n",
- " <td>0.041252</td>\n",
- " <td>0.034069</td>\n",
- " <td>0.063465</td>\n",
- " <td>0.016602</td>\n",
- " <td>0.041047</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Dollar General Corporation</th>\n",
- " <td>NaN</td>\n",
- " <td>0.008256</td>\n",
- " <td>0.037507</td>\n",
- " <td>0.058973</td>\n",
- " <td>0.036922</td>\n",
- " <td>0.046197</td>\n",
- " <td>0.042609</td>\n",
- " <td>0.050776</td>\n",
- " <td>0.039524</td>\n",
- " <td>0.046052</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Walmart Inc.</th>\n",
- " <td>0.031243</td>\n",
- " <td>0.028372</td>\n",
- " <td>0.065462</td>\n",
- " <td>0.044591</td>\n",
- " <td>0.062023</td>\n",
- " <td>0.057275</td>\n",
- " <td>0.101038</td>\n",
- " <td>0.073506</td>\n",
- " <td>0.059712</td>\n",
- " <td>0.041544</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Big Lots, Inc.</th>\n",
- " <td>NaN</td>\n",
- " <td>-0.550469</td>\n",
- " <td>0.025262</td>\n",
- " <td>0.115757</td>\n",
- " <td>0.069464</td>\n",
- " <td>-0.111853</td>\n",
- " <td>0.037219</td>\n",
- " <td>0.100721</td>\n",
- " <td>0.110443</td>\n",
- " <td>0.089253</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Macy's, Inc.</th>\n",
- " <td>NaN</td>\n",
- " <td>0.050473</td>\n",
- " <td>0.270980</td>\n",
- " <td>0.039111</td>\n",
- " <td>0.091301</td>\n",
- " <td>0.101426</td>\n",
- " <td>0.155761</td>\n",
- " <td>0.098993</td>\n",
- " <td>0.065634</td>\n",
- " <td>0.072322</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>Kohl's Corporation</th>\n",
- " <td>NaN</td>\n",
- " <td>-0.143961</td>\n",
- " <td>0.189677</td>\n",
- " <td>0.147968</td>\n",
- " <td>0.119492</td>\n",
- " <td>0.139799</td>\n",
- " <td>0.096137</td>\n",
- " <td>0.198790</td>\n",
- " <td>0.081652</td>\n",
- " <td>0.110697</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>The TJX Companies, Inc.</th>\n",
- " <td>0.027159</td>\n",
- " <td>0.023497</td>\n",
- " <td>0.051769</td>\n",
- " <td>0.040167</td>\n",
- " <td>0.048827</td>\n",
- " <td>0.039935</td>\n",
- " <td>0.053697</td>\n",
- " <td>0.043328</td>\n",
- " <td>0.046442</td>\n",
- " <td>0.040643</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "</div>"
- ],
- "text/plain": [
- "calendar_year 2023 2022 2021 2020 \\\n",
- "Costco Wholesale Corporation 0.027922 0.014860 0.026582 0.039351 \n",
- "BJ's Wholesale Club Holdings, Inc. NaN 0.044709 0.067213 0.113551 \n",
- "Dollar Tree, Inc. NaN 0.010756 0.013957 0.075627 \n",
- "Dollar General Corporation NaN 0.008256 0.037507 0.058973 \n",
- "Walmart Inc. 0.031243 0.028372 0.065462 0.044591 \n",
- "Big Lots, Inc. NaN -0.550469 0.025262 0.115757 \n",
- "Macy's, Inc. NaN 0.050473 0.270980 0.039111 \n",
- "Kohl's Corporation NaN -0.143961 0.189677 0.147968 \n",
- "The TJX Companies, Inc. 0.027159 0.023497 0.051769 0.040167 \n",
- "\n",
- "calendar_year 2019 2018 2017 2016 \\\n",
- "Costco Wholesale Corporation 0.025906 0.027438 0.060884 0.008941 \n",
- "BJ's Wholesale Club Holdings, Inc. 0.056630 0.091107 0.026186 0.065871 \n",
- "Dollar Tree, Inc. 0