sec.gov-api-v1.0.4.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"sec.gov-api-v1.0.4.ipynb","provenance":[{"file_id":"10ygjDePccexJ0h4BS-apfTYOVb68Kn0f","timestamp":1660211828436},{"file_id":"1YW2ZRAHLdxFo-L5KxUR3PfUEb5gz9YMI","timestamp":1657004996506},{"file_id":"1OeORhuVZjKl2HTxAbN6i7HQc7lzNBQTf","timestamp":1656672069109}],"collapsed_sections":[],"authorship_tag":"ABX9TyMP3RKJoCTgP5S+fXEwl/e2"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"code","source":["import re\n","import json\n","import requests\n","import pandas as pd\n","from time import sleep\n","\n","import warnings\n","warnings.filterwarnings('ignore')"],"metadata":{"id":"9SOR2Gv24WWt","executionInfo":{"status":"ok","timestamp":1660212868331,"user_tz":-120,"elapsed":273,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":1,"outputs":[]},{"cell_type":"code","source":["def get_response(url):\n","    headers = {\n","        'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36'\n","    }\n","\n","    session = requests.Session()\n","    response = session.get(url, headers=headers).json()\n","\n","    return response"],"metadata":{"id":"xXxIJDyhUn8e","executionInfo":{"status":"ok","timestamp":1660212868332,"user_tz":-120,"elapsed":4,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":2,"outputs":[]},{"cell_type":"code","source":["def cik_normalize(cik):\n","    return str(cik).zfill(10)\n","\n","def camelcase_to_title(txt):\n","    return [re.sub(\"([a-z])([A-Z])\", r\"\\g<1> \\g<2>\", i).title() for i in txt]"],"metadata":{"id":"vF2RJN0JQfQt","executionInfo":{"status":"ok","timestamp":1660212868676,"user_tz":-120,"elapsed":15,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":3,"outputs":[]},{"cell_type":"code","source":["url = \"https://www.sec.gov/files/company_tickers.json\"\n","\n","response = get_response(url)\n","tickers_cik = pd.json_normalize(response.values())\n","tickers_cik.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"Pq5nqY59795w","executionInfo":{"status":"ok","timestamp":1660212868677,"user_tz":-120,"elapsed":16,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"045bea23-70b7-4879-a6af-74e15ab3aab5"},"execution_count":4,"outputs":[{"output_type":"execute_result","data":{"text/plain":["   cik_str ticker                   title\n","0   320193   AAPL              Apple Inc.\n","1   789019   MSFT          MICROSOFT CORP\n","2  1652044  GOOGL           Alphabet Inc.\n","3  1318605   TSLA             Tesla, Inc.\n","4  1067983  BRK-B  BERKSHIRE HATHAWAY INC"],"text/html":["\n","  <div id=\"df-f1ce09d9-ca4e-4b83-9e3b-5bda1fd50c3e\">\n","    <div 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>cik_str</th>\n","      <th>ticker</th>\n","      <th>title</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>320193</td>\n","      <td>AAPL</td>\n","      <td>Apple Inc.</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>789019</td>\n","      <td>MSFT</td>\n","      <td>MICROSOFT CORP</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>1652044</td>\n","      <td>GOOGL</td>\n","      <td>Alphabet Inc.</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>1318605</td>\n","      <td>TSLA</td>\n","      <td>Tesla, Inc.</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1067983</td>\n","      <td>BRK-B</td>\n","      <td>BERKSHIRE HATHAWAY INC</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f1ce09d9-ca4e-4b83-9e3b-5bda1fd50c3e')\"\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 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\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","    [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-f1ce09d9-ca4e-4b83-9e3b-5bda1fd50c3e 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-f1ce09d9-ca4e-4b83-9e3b-5bda1fd50c3e');\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","  </div>\n","  "]},"metadata":{},"execution_count":4}]},{"cell_type":"code","source":["companies = tickers_cik.copy()\n","companies['cik_str'] = companies['cik_str'].apply(cik_normalize)\n","companies.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"34VuPZB88-Lq","executionInfo":{"status":"ok","timestamp":1660212868677,"user_tz":-120,"elapsed":15,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"5230d14b-dc2e-47c9-ffff-3a06c6ab8249"},"execution_count":5,"outputs":[{"output_type":"execute_result","data":{"text/plain":["      cik_str ticker                   title\n","0  0000320193   AAPL              Apple Inc.\n","1  0000789019   MSFT          MICROSOFT CORP\n","2  0001652044  GOOGL           Alphabet Inc.\n","3  0001318605   TSLA             Tesla, Inc.\n","4  0001067983  BRK-B  BERKSHIRE HATHAWAY INC"],"text/html":["\n","  <div id=\"df-fa625c89-b2f3-4e2e-adf1-bd05f8853170\">\n","    <div 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>cik_str</th>\n","      <th>ticker</th>\n","      <th>title</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>0000320193</td>\n","      <td>AAPL</td>\n","      <td>Apple Inc.</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>0000789019</td>\n","      <td>MSFT</td>\n","      <td>MICROSOFT CORP</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>0001652044</td>\n","      <td>GOOGL</td>\n","      <td>Alphabet Inc.</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>0001318605</td>\n","      <td>TSLA</td>\n","      <td>Tesla, Inc.</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>0001067983</td>\n","      <td>BRK-B</td>\n","      <td>BERKSHIRE HATHAWAY INC</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-fa625c89-b2f3-4e2e-adf1-bd05f8853170')\"\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 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\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","    [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-fa625c89-b2f3-4e2e-adf1-bd05f8853170 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-fa625c89-b2f3-4e2e-adf1-bd05f8853170');\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","  </div>\n","  "]},"metadata":{},"execution_count":5}]},{"cell_type":"code","source":["url = f\"https://data.sec.gov/api/xbrl/companyfacts/CIK{companies['cik_str'][2]}.json\"\n","\n","response = get_response(url)\n","data = response[\"facts\"][\"us-gaap\"]"],"metadata":{"id":"hALngY3F-LMD","executionInfo":{"status":"ok","timestamp":1660212869532,"user_tz":-120,"elapsed":869,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":6,"outputs":[]},{"cell_type":"code","source":["keys = data.keys()"],"metadata":{"id":"f68f8vWIUfLP","executionInfo":{"status":"ok","timestamp":1660212869533,"user_tz":-120,"elapsed":40,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":7,"outputs":[]},{"cell_type":"code","source":["usd_keys = [key for key in keys if 'USD' in data[key]['units'].keys()]\n","usd_keys"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"zi6nn00GednW","executionInfo":{"status":"ok","timestamp":1660212869533,"user_tz":-120,"elapsed":40,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"4ee1ee1d-1288-40f5-ca0a-9fe1352b93e8"},"execution_count":8,"outputs":[{"output_type":"execute_result","data":{"text/plain":["['AccountsPayableCurrent',\n"," 'AccountsReceivableNetCurrent',\n"," 'AccruedIncomeTaxesCurrent',\n"," 'AccruedIncomeTaxesNoncurrent',\n"," 'AccruedLiabilitiesCurrent',\n"," 'AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment',\n"," 'AccumulatedOtherComprehensiveIncomeLossNetOfTax',\n"," 'AdjustmentsRelatedToTaxWithholdingForShareBasedCompensation',\n"," 'AdjustmentsToAdditionalPaidInCapitalSharebasedCompensationRequisiteServicePeriodRecognitionValue',\n"," 'AdjustmentsToAdditionalPaidInCapitalTaxEffectFromShareBasedCompensation',\n"," 'AllocatedShareBasedCompensationExpense',\n"," 'AllowanceForDoubtfulAccountsReceivable',\n"," 'AllowanceForDoubtfulAccountsReceivableCurrent',\n"," 'Assets',\n"," 'AssetsCurrent',\n"," 'AssetsNoncurrent',\n"," 'AvailableForSaleDebtSecuritiesAccumulatedGrossUnrealizedGainBeforeTax',\n"," 'AvailableForSaleDebtSecuritiesAccumulatedGrossUnrealizedLossBeforeTax',\n"," 'AvailableForSaleDebtSecuritiesAmortizedCostBasis',\n"," 'AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss',\n"," 'AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss',\n"," 'AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue',\n"," 'AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss',\n"," 'AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue',\n"," 'AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue',\n"," 'AvailableForSaleSecuritiesCurrent',\n"," 'AvailableForSaleSecuritiesDebtMaturitiesAfterFiveThroughTenYearsFairValue',\n"," 'AvailableForSaleSecuritiesDebtMaturitiesAfterOneThroughFiveYearsFairValue',\n"," 'AvailableForSaleSecuritiesDebtMaturitiesAfterTenYearsFairValue',\n"," 'AvailableForSaleSecuritiesDebtMaturitiesWithinOneYearFairValue',\n"," 'AvailableForSaleSecuritiesDebtSecurities',\n"," 'AvailableForSaleSecuritiesGrossRealizedGainLossNet',\n"," 'AvailableForSaleSecuritiesGrossRealizedGains',\n"," 'AvailableForSaleSecuritiesGrossRealizedLosses',\n"," 'BusinessCombinationStepAcquisitionEquityInterestInAcquireeRemeasurementGain',\n"," 'CapitalLeasedAssetsGross',\n"," 'CapitalLeaseObligationsCurrent',\n"," 'CapitalLeaseObligationsNoncurrent',\n"," 'CashAndCashEquivalentsAtCarryingValue',\n"," 'CashAndCashEquivalentsAtCarryingValueIncludingDiscontinuedOperations',\n"," 'CashAndCashEquivalentsFairValueDisclosure',\n"," 'CashAndCashEquivalentsPeriodIncreaseDecrease',\n"," 'CashCashEquivalentsAndShortTermInvestments',\n"," 'CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents',\n"," 'CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsPeriodIncreaseDecreaseIncludingExchangeRateEffect',\n"," 'CommercialPaper',\n"," 'CommonStocksIncludingAdditionalPaidInCapital',\n"," 'CommonStockValue',\n"," 'ComprehensiveIncomeNetOfTax',\n"," 'ContractWithCustomerLiability',\n"," 'ContractWithCustomerLiabilityCurrent',\n"," 'ContractWithCustomerLiabilityNoncurrent',\n"," 'ContractWithCustomerLiabilityRevenueRecognized',\n"," 'ConvertiblePreferredStockNonredeemableOrRedeemableIssuerOptionValue',\n"," 'CostMethodInvestments',\n"," 'CostMethodInvestmentsFairValueDisclosure',\n"," 'CostOfRevenue',\n"," 'CostsAndExpenses',\n"," 'CumulativeEffectOfNewAccountingPrincipleInPeriodOfAdoption',\n"," 'CurrentFederalStateAndLocalTaxExpenseBenefit',\n"," 'CurrentFederalTaxExpenseBenefit',\n"," 'CurrentForeignTaxExpenseBenefit',\n"," 'CurrentIncomeTaxExpenseBenefit',\n"," 'CurrentStateAndLocalTaxExpenseBenefit',\n"," 'CustomerAdvancesAndDeposits',\n"," 'DebtAndEquitySecuritiesGainLoss',\n"," 'DebtCurrent',\n"," 'DebtInstrumentFaceAmount',\n"," 'DebtInstrumentUnamortizedDiscount',\n"," 'DebtInstrumentUnamortizedDiscountPremiumAndDebtIssuanceCostsNet',\n"," 'DebtSecuritiesAvailableForSaleAllowanceForCreditLoss',\n"," 'DebtSecuritiesAvailableForSaleAllowanceForCreditLossNotPreviouslyRecorded',\n"," 'DebtSecuritiesAvailableForSaleAllowanceForCreditLossRecovery',\n"," 'DebtSecuritiesAvailableForSaleContinuousUnrealizedLossPosition12MonthsOrLonger',\n"," 'DebtSecuritiesAvailableForSaleContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss',\n"," 'DebtSecuritiesAvailableForSaleContinuousUnrealizedLossPositionLessThan12Months',\n"," 'DebtSecuritiesAvailableForSaleContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss',\n"," 'DebtSecuritiesAvailableForSaleRealizedGain',\n"," 'DebtSecuritiesAvailableForSaleRealizedLoss',\n"," 'DebtSecuritiesAvailableForSaleUnrealizedLossPosition',\n"," 'DebtSecuritiesAvailableForSaleUnrealizedLossPositionAccumulatedLoss',\n"," 'DebtSecuritiesGainLoss',\n"," 'DebtSecuritiesRealizedGainLoss',\n"," 'DecreaseInUnrecognizedTaxBenefitsIsReasonablyPossible',\n"," 'DeferredFederalIncomeTaxExpenseBenefit',\n"," 'DeferredFederalStateAndLocalTaxExpenseBenefit',\n"," 'DeferredForeignIncomeTaxExpenseBenefit',\n"," 'DeferredIncomeTaxAssetsNet',\n"," 'DeferredIncomeTaxExpenseBenefit',\n"," 'DeferredIncomeTaxesAndTaxCredits',\n"," 'DeferredIncomeTaxLiabilities',\n"," 'DeferredIncomeTaxLiabilitiesNet',\n"," 'DeferredRevenueCurrent',\n"," 'DeferredRevenueNoncurrent',\n"," 'DeferredRevenueRevenueRecognized1',\n"," 'DeferredStateAndLocalIncomeTaxExpenseBenefit',\n"," 'DeferredTaxAssetsCapitalLossCarryforwards',\n"," 'DeferredTaxAssetsGross',\n"," 'DeferredTaxAssetsLiabilitiesNet',\n"," 'DeferredTaxAssetsLiabilitiesNetNoncurrent',\n"," 'DeferredTaxAssetsNet',\n"," 'DeferredTaxAssetsNetCurrent',\n"," 'DeferredTaxAssetsOperatingLossCarryforwards',\n"," 'DeferredTaxAssetsOther',\n"," 'DeferredTaxAssetsStateTaxes',\n"," 'DeferredTaxAssetsTaxCreditCarryforwardsOther',\n"," 'DeferredTaxAssetsTaxDeferredExpenseCompensationAndBenefitsEmployeeBenefits',\n"," 'DeferredTaxAssetsTaxDeferredExpenseCompensationAndBenefitsShareBasedCompensationCost',\n"," 'DeferredTaxAssetsTaxDeferredExpenseReservesAndAccrualsLegalSettlements',\n"," 'DeferredTaxAssetsTaxDeferredExpenseReservesAndAccrualsOther',\n"," 'DeferredTaxAssetsValuationAllowance',\n"," 'DeferredTaxLiabilities',\n"," 'DeferredTaxLiabilitiesGoodwillAndIntangibleAssetsIntangibleAssets',\n"," 'DeferredTaxLiabilitiesInvestments',\n"," 'DeferredTaxLiabilitiesNoncurrent',\n"," 'DeferredTaxLiabilitiesOther',\n"," 'DeferredTaxLiabilitiesOtherComprehensiveIncome',\n"," 'DeferredTaxLiabilitiesPropertyPlantAndEquipment',\n"," 'DeferredTaxLiabilitiesUndistributedForeignEarnings',\n"," 'DefinedContributionPlanCostRecognized',\n"," 'DepositsReceivedForSecuritiesLoanedAtCarryingValue',\n"," 'DerivativeAmountOfHedgedItem',\n"," 'DerivativeAssetFairValueGrossLiability',\n"," 'DerivativeAssetFairValueOffsetAgainstCollateralNetOfNotSubjectToMasterNettingArrangementPolicyElection',\n"," 'DerivativeAssetNotOffsetPolicyElectionDeduction',\n"," 'DerivativeAssetSecuritiesPurchasedUnderAgreementsToResellSecuritiesBorrowed',\n"," 'DerivativeAssetSecuritiesPurchasedUnderAgreementsToResellSecuritiesBorrowedAmountOffsetAgainstCollateral',\n"," 'DerivativeAssetSecuritiesPurchasedUnderAgreementsToResellSecuritiesBorrowedCollateralObligationToReturnCash',\n"," 'DerivativeAssetSecuritiesPurchasedUnderAgreementsToResellSecuritiesBorrowedCollateralObligationToReturnSecurities',\n"," 'DerivativeAssetSecuritiesPurchasedUnderAgreementsToResellSecuritiesBorrowedGross',\n"," 'DerivativeAssetSecuritiesPurchasedUnderAgreementsToResellSecuritiesBorrowedLiability',\n"," 'DerivativeAssetSecuritiesPurchasedUnderAgreementsToResellSecuritiesBorrowedNotOffsetPolicyElectionDeduction',\n"," 'DerivativeAssetSecuritiesPurchasedUnderAgreementsToResellSecuritiesBorrowedOffsetAgainstCollateralNetOfNotSubjectToMasterNettingArrangementPolicyElection',\n"," 'DerivativeAssets',\n"," 'DerivativeCollateralObligationToReturnCash',\n"," 'DerivativeCollateralObligationToReturnSecurities',\n"," 'DerivativeCollateralRightToReclaimCash',\n"," 'DerivativeCollateralRightToReclaimSecurities',\n"," 'DerivativeFairValueOfDerivativeAsset',\n"," 'DerivativeFairValueOfDerivativeAssetAmountOffsetAgainstCollateral',\n"," 'DerivativeFairValueOfDerivativeLiability',\n"," 'DerivativeFairValueOfDerivativeLiabilityAmountOffsetAgainstCollateral',\n"," 'DerivativeInstrumentsGainLossReclassifiedFromAccumulatedOCIIntoIncomeEffectivePortionNet',\n"," 'DerivativeInstrumentsGainLossRecognizedInIncomeIneffectivePortionAndAmountExcludedFromEffectivenessTestingNet',\n"," 'DerivativeInstrumentsGainLossRecognizedInOtherComprehensiveIncomeEffectivePortionNet',\n"," 'DerivativeInstrumentsNotDesignatedAsHedgingInstrumentsGainLossNet',\n"," 'DerivativeLiabilities',\n"," 'DerivativeLiabilityFairValueGrossAsset',\n"," 'DerivativeLiabilityFairValueOffsetAgainstCollateralNetOfNotSubjectToMasterNettingArrangementPolicyElection',\n"," 'DerivativeLiabilityNotOffsetPolicyElectionDeduction',\n"," 'DerivativeLiabilitySecuritiesSoldUnderAgreementsToResellSecuritiesLoaned',\n"," 'DerivativeLiabilitySecuritiesSoldUnderAgreementsToResellSecuritiesLoanedAmountOffsetAgainstCollateral',\n"," 'DerivativeLiabilitySecuritiesSoldUnderAgreementsToResellSecuritiesLoanedAsset',\n"," 'DerivativeLiabilitySecuritiesSoldUnderAgreementsToResellSecuritiesLoanedCollateralRightToReclaimCash',\n"," 'DerivativeLiabilitySecuritiesSoldUnderAgreementsToResellSecuritiesLoanedCollateralRightToReclaimSecurities',\n"," 'DerivativeLiabilitySecuritiesSoldUnderAgreementsToResellSecuritiesLoanedGross',\n"," 'DerivativeLiabilitySecuritiesSoldUnderAgreementsToResellSecuritiesLoanedNotOffsetPolicyElectionDeduction',\n"," 'DerivativeLiabilitySecuritiesSoldUnderAgreementsToResellSecuritiesLoanedOffsetAgainstCollateralNetOfNotSubjectToMasterNettingArrangementPolicyElection',\n"," 'DisposalGroupIncludingDiscontinuedOperationCashAndCashEquivalents',\n"," 'EffectOfExchangeRateOnCashAndCashEquivalents',\n"," 'EffectOfExchangeRateOnCashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents',\n"," 'EmployeeRelatedLiabilitiesCurrent',\n"," 'EmployeeServiceShareBasedCompensationTaxBenefitFromCompensationExpense',\n"," 'EquityMethodInvestments',\n"," 'EquitySecuritiesFvNi',\n"," 'EquitySecuritiesFvNiAndWithoutReadilyDeterminableFairValue',\n"," 'EquitySecuritiesFvNiCost',\n"," 'EquitySecuritiesFvNiGainLoss',\n"," 'EquitySecuritiesFvNiRealizedGainLoss',\n"," 'EquitySecuritiesFvNiUnrealizedGainLoss',\n"," 'EquitySecuritiesFvNiUnrealizedLoss',\n"," 'EquitySecuritiesWithoutReadilyDeterminableFairValueAmount',\n"," 'EquitySecuritiesWithoutReadilyDeterminableFairValueDownwardPriceAdjustmentAnnualAmount',\n"," 'EquitySecuritiesWithoutReadilyDeterminableFairValueDownwardPriceAdjustmentCumulativeAmount',\n"," 'EquitySecuritiesWithoutReadilyDeterminableFairValueUpwardPriceAdjustmentAnnualAmount',\n"," 'EquitySecuritiesWithoutReadilyDeterminableFairValueUpwardPriceAdjustmentCumulativeAmount',\n"," 'ExcessTaxBenefitFromShareBasedCompensationFinancingActivities',\n"," 'ExcessTaxBenefitFromShareBasedCompensationOperatingActivities',\n"," 'FinanceLeaseLiability',\n"," 'FinanceLeaseLiabilityCurrent',\n"," 'FinanceLeaseLiabilityNoncurrent',\n"," 'FinanceLeaseLiabilityUndiscountedExcessAmount',\n"," 'FiniteLivedIntangibleAssetsAccumulatedAmortization',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseAfterYearFive',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseNextTwelveMonths',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseRemainderOfFiscalYear',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseYearFive',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseYearFour',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseYearThree',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseYearTwo',\n"," 'FiniteLivedIntangibleAssetsGross',\n"," 'FiniteLivedIntangibleAssetsNet',\n"," 'ForeignCurrencyCashFlowHedgeGainLossToBeReclassifiedDuringNext12Months',\n"," 'ForeignCurrencyTransactionGainLossBeforeTax',\n"," 'ForeignCurrencyTransactionLossBeforeTax',\n"," 'GainLossOnOilAndGasHedgingActivity',\n"," 'GainLossOnSaleOfBusiness',\n"," 'GainsLossesOnRestructuringOfDebt',\n"," 'GeneralAndAdministrativeExpense',\n"," 'Goodwill',\n"," 'GoodwillAcquiredDuringPeriod',\n"," 'GoodwillImpairmentLoss',\n"," 'GoodwillOtherChanges',\n"," 'GoodwillTransfers',\n"," 'GoodwillTranslationAndPurchaseAccountingAdjustments',\n"," 'GoodwillWrittenOffRelatedToSaleOfBusinessUnit',\n"," 'ImpairmentOfInvestments',\n"," 'IncomeLossFromContinuingOperations',\n"," 'IncomeLossFromContinuingOperationsBeforeIncomeTaxesDomestic',\n"," 'IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest',\n"," 'IncomeLossFromContinuingOperationsBeforeIncomeTaxesForeign',\n"," 'IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments',\n"," 'IncomeLossFromDiscontinuedOperationsNetOfTax',\n"," 'IncomeLossFromEquityMethodInvestments',\n"," 'IncomeTaxExpenseBenefit',\n"," 'IncomeTaxesPaid',\n"," 'IncomeTaxesPaidNet',\n"," 'IncomeTaxesReceivable',\n"," 'IncomeTaxReconciliationChangeInDeferredTaxAssetsValuationAllowance',\n"," 'IncomeTaxReconciliationForeignIncomeTaxRateDifferential',\n"," 'IncomeTaxReconciliationIncomeTaxExpenseBenefitAtFederalStatutoryIncomeTaxRate',\n"," 'IncomeTaxReconciliationOtherAdjustments',\n"," 'IncomeTaxReconciliationStateAndLocalIncomeTaxes',\n"," 'IncomeTaxReconciliationTaxCreditsResearch',\n"," 'IncreaseDecreaseInAccountsPayable',\n"," 'IncreaseDecreaseInAccountsReceivable',\n"," 'IncreaseDecreaseInAccruedLiabilities',\n"," 'IncreaseDecreaseInCollateralHeldUnderSecuritiesLending',\n"," 'IncreaseDecreaseInContractWithCustomerLiability',\n"," 'IncreaseDecreaseInDeferredRevenue',\n"," 'IncreaseDecreaseInIncomeTaxes',\n"," 'IncreaseDecreaseInOtherOperatingAssets',\n"," 'IntangibleAssetsNetExcludingGoodwill',\n"," 'InterestCostsCapitalized',\n"," 'InterestExpense',\n"," 'InterestIncomeOther',\n"," 'InterestPaid',\n"," 'InterestPaidNet',\n"," 'InventoryNet',\n"," 'LeaseAndRentalExpense',\n"," 'LeaseCost',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDue',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueAfterYearFive',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueNextTwelveMonths',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueYearFive',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueYearFour',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueYearThree',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueYearTwo',\n"," 'LesseeOperatingLeaseLiabilityPaymentsRemainderOfFiscalYear',\n"," 'LesseeOperatingLeaseLiabilityUndiscountedExcessAmount',\n"," 'LettersOfCreditOutstandingAmount',\n"," 'Liabilities',\n"," 'LiabilitiesAndStockholdersEquity',\n"," 'LiabilitiesCurrent',\n"," 'LiabilityForUncertainTaxPositionsNoncurrent',\n"," 'LineOfCreditFacilityMaximumBorrowingCapacity',\n"," 'LongTermDebt',\n"," 'LongTermDebtAndCapitalLeaseObligations',\n"," 'LongTermDebtAndCapitalLeaseObligationsCurrent',\n"," 'LongTermDebtAndCapitalLeaseObligationsIncludingCurrentMaturities',\n"," 'LongTermDebtCurrent',\n"," 'LongTermDebtFairValue',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalAfterYearFive',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalInNextTwelveMonths',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalInYearFive',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalInYearFour',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalInYearThree',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalInYearTwo',\n"," 'LongTermDebtNoncurrent',\n"," 'LossContingencyAccrualCarryingValueCurrent',\n"," 'LossContingencyLossInPeriod',\n"," 'MarketableSecurities',\n"," 'MarketableSecuritiesCurrent',\n"," 'MarketingAndAdvertisingExpense',\n"," 'NetCashProvidedByUsedInFinancingActivities',\n"," 'NetCashProvidedByUsedInInvestingActivities',\n"," 'NetCashProvidedByUsedInOperatingActivities',\n"," 'NetIncomeLoss',\n"," 'NetIncomeLossAvailableToCommonStockholdersBasic',\n"," 'NoncontrollingInterestIncreaseFromSaleOfParentEquityInterest',\n"," 'NoncontrollingInterestInVariableInterestEntity',\n"," 'NoncurrentAssets',\n"," 'NonoperatingIncomeExpense',\n"," 'OciBeforeReclassificationsNetOfTaxAttributableToParent',\n"," 'OperatingIncomeLoss',\n"," 'OperatingLeaseCost',\n"," 'OperatingLeaseLiability',\n"," 'OperatingLeaseLiabilityCurrent',\n"," 'OperatingLeaseLiabilityNoncurrent',\n"," 'OperatingLeasePayments',\n"," 'OperatingLeaseRightOfUseAsset',\n"," 'OperatingLeasesFutureMinimumPaymentsDue',\n"," 'OperatingLeasesFutureMinimumPaymentsDueCurrent',\n"," 'OperatingLeasesFutureMinimumPaymentsDueInFiveYears',\n"," 'OperatingLeasesFutureMinimumPaymentsDueInFourYears',\n"," 'OperatingLeasesFutureMinimumPaymentsDueInThreeYears',\n"," 'OperatingLeasesFutureMinimumPaymentsDueInTwoYears',\n"," 'OperatingLeasesFutureMinimumPaymentsDueThereafter',\n"," 'OperatingLeasesFutureMinimumPaymentsReceivable',\n"," 'OperatingLeasesFutureMinimumPaymentsReceivableCurrent',\n"," 'OperatingLeasesFutureMinimumPaymentsReceivableInFiveYears',\n"," 'OperatingLeasesFutureMinimumPaymentsReceivableInFourYears',\n"," 'OperatingLeasesFutureMinimumPaymentsReceivableInThreeYears',\n"," 'OperatingLeasesFutureMinimumPaymentsReceivableInTwoYears',\n"," 'OperatingLeasesFutureMinimumPaymentsReceivableThereafter',\n"," 'OtherAccruedLiabilitiesCurrent',\n"," 'OtherAssetsCurrent',\n"," 'OtherAssetsNoncurrent',\n"," 'OtherComprehensiveIncomeLossAvailableForSaleSecuritiesAdjustmentNetOfTax',\n"," 'OtherComprehensiveIncomeLossAvailableForSaleSecuritiesTax',\n"," 'OtherComprehensiveIncomeLossBeforeReclassificationsNetOfTax',\n"," 'OtherComprehensiveIncomeLossCashFlowHedgeGainLossAfterReclassificationAndTax',\n"," 'OtherComprehensiveIncomeLossCashFlowHedgeGainLossAfterReclassificationTax',\n"," 'OtherComprehensiveIncomeLossCashFlowHedgeGainLossBeforeReclassificationAfterTax',\n"," 'OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax',\n"," 'OtherComprehensiveIncomeLossDerivativesQualifyingAsHedgesNetOfTax',\n"," 'OtherComprehensiveIncomeLossDerivativesQualifyingAsHedgesTax',\n"," 'OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax',\n"," 'OtherComprehensiveIncomeLossNetOfTax',\n"," 'OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent',\n"," 'OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIForSaleOfSecuritiesNetOfTax',\n"," 'OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIOnDerivativesNetOfTax',\n"," 'OtherComprehensiveIncomeUnrealizedGainLossOnDerivativesArisingDuringPeriodNetOfTax',\n"," 'OtherComprehensiveIncomeUnrealizedHoldingGainLossOnSecuritiesArisingDuringPeriodNetOfTax',\n"," 'OtherLiabilitiesNoncurrent',\n"," 'OtherLongTermInvestments',\n"," 'OtherNoncashIncomeExpense',\n"," 'OtherNonoperatingIncomeExpense',\n"," 'OtherThanTemporaryImpairmentLossesInvestmentsAvailableforsaleSecurities',\n"," 'PaymentsForProceedsFromOtherInvestingActivities',\n"," 'PaymentsForRepurchaseOfCommonStock',\n"," 'PaymentsOfDividends',\n"," 'PaymentsToAcquireBuildings',\n"," 'PaymentsToAcquireInterestInSubsidiariesAndAffiliates',\n"," 'PaymentsToAcquireMarketableSecurities',\n"," 'PaymentsToAcquireOtherInvestments',\n"," 'PaymentsToAcquirePropertyPlantAndEquipment',\n"," 'PreferredStockDividendsAndOtherAdjustments',\n"," 'ProceedsFromCollectionOfNotesReceivable',\n"," 'ProceedsFromDebtNetOfIssuanceCosts',\n"," 'ProceedsFromDivestitureOfBusinesses',\n"," 'ProceedsFromMinorityShareholders',\n"," 'ProceedsFromPaymentsForSecuritiesPurchasedUnderAgreementsToResell',\n"," 'ProceedsFromSaleAndMaturityOfMarketableSecurities',\n"," 'ProceedsFromSaleAndMaturityOfOtherInvestments',\n"," 'ProceedsFromSaleOfPropertyPlantAndEquipment',\n"," 'ProceedsFromStockOptionsExercised',\n"," 'PropertyPlantAndEquipmentAndFinanceLeaseRightOfUseAssetAccumulatedDepreciationAndAmortization',\n"," 'PropertyPlantAndEquipmentAndFinanceLeaseRightOfUseAssetAfterAccumulatedDepreciationAndAmortization',\n"," 'PropertyPlantAndEquipmentAndFinanceLeaseRightOfUseAssetBeforeAccumulatedDepreciationAndAmortization',\n"," 'PropertyPlantAndEquipmentGross',\n"," 'PropertyPlantAndEquipmentNet',\n"," 'PurchaseObligation',\n"," 'ReclassificationFromAccumulatedOtherComprehensiveIncomeCurrentPeriodNetOfTax',\n"," 'ReclassificationFromAociCurrentPeriodNetOfTaxAttributableToParent',\n"," 'RepaymentsOfDebt',\n"," 'RepaymentsOfDebtAndCapitalLeaseObligations',\n"," 'ResearchAndDevelopmentExpense',\n"," 'RetainedEarningsAccumulatedDeficit',\n"," 'RevenueFromContractWithCustomerExcludingAssessedTax',\n"," 'RevenueRemainingPerformanceObligation',\n"," 'Revenues',\n"," 'RightOfUseAssetObtainedInExchangeForOperatingLeaseLiability',\n"," 'SecuredBorrowingsGrossDifferenceAmount',\n"," 'SecuritiesLoaned',\n"," 'SecuritiesLoanedAmountOffsetAgainstCollateral',\n"," 'SecuritiesLoanedAsset',\n"," 'SecuritiesLoanedCollateralRightToReclaimCash',\n"," 'SecuritiesLoanedCollateralRightToReclaimSecurities',\n"," 'SecuritiesLoanedGross',\n"," 'SecuritiesLoanedIncludingNotSubjectToMasterNettingArrangementAndAssetsOtherThanSecuritiesTransferred',\n"," 'SecuritiesLoanedNotOffsetPolicyElectionDeduction',\n"," 'SecuritiesLoanedOffsetAgainstCollateralNetOfNotSubjectToMasterNettingArrangementPolicyElection',\n"," 'SecuritiesOwnedNotReadilyMarketable',\n"," 'SecuritiesPurchasedUnderAgreementsToResell',\n"," 'SecuritiesPurchasedUnderAgreementsToResellAmountOffsetAgainstCollateral',\n"," 'SecuritiesPurchasedUnderAgreementsToResellCollateralObligationToReturnCash',\n"," 'SecuritiesPurchasedUnderAgreementsToResellCollateralObligationToReturnSecurities',\n"," 'SecuritiesPurchasedUnderAgreementsToResellGross',\n"," 'SecuritiesPurchasedUnderAgreementsToResellLiability',\n"," 'SecuritiesPurchasedUnderAgreementsToResellNotOffsetPolicyElectionDeduction',\n"," 'SecuritiesPurchasedUnderAgreementsToResellOffsetAgainstCollateralNetOfNotSubjectToMasterNettingArrangementPolicyElection',\n"," 'SellingAndMarketingExpense',\n"," 'ShareBasedCompensation',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardEquityInstrumentsOtherThanOptionsShareBasedLiabilitiesPaid',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardEquityInstrumentsOtherThanOptionsVestedInPeriodTotalFairValue',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsExercisesInPeriodTotalIntrinsicValue',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsOutstandingIntrinsicValue',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsVestedAndExpectedToVestExercisableAggregateIntrinsicValue',\n"," 'SharebasedCompensationArrangementBySharebasedPaymentAwardOptionsExercisableIntrinsicValue1',\n"," 'SharebasedCompensationArrangementBySharebasedPaymentAwardOptionsVestedInPeriodFairValue1',\n"," 'StockholdersEquity',\n"," 'StockIssued1',\n"," 'StockIssuedDuringPeriodValueNewIssues',\n"," 'StockRepurchasedAndRetiredDuringPeriodValue',\n"," 'TaxCreditCarryforwardAmount',\n"," 'TaxCutsAndJobsActOf2017IncompleteAccountingChangeInTaxRateDeferredTaxAssetProvisionalIncomeTaxExpense',\n"," 'TaxCutsAndJobsActOf2017IncompleteAccountingProvisionalIncomeTaxExpenseBenefit',\n"," 'UndistributedEarningsOfForeignSubsidiaries',\n"," 'UnrecognizedTaxBenefits',\n"," 'UnrecognizedTaxBenefitsDecreasesResultingFromPriorPeriodTaxPositions',\n"," 'UnrecognizedTaxBenefitsDecreasesResultingFromSettlementsWithTaxingAuthorities',\n"," 'UnrecognizedTaxBenefitsIncomeTaxPenaltiesAndInterestAccrued',\n"," 'UnrecognizedTaxBenefitsIncreasesResultingFromCurrentPeriodTaxPositions',\n"," 'UnrecognizedTaxBenefitsIncreasesResultingFromPriorPeriodTaxPositions',\n"," 'UnrecognizedTaxBenefitsThatWouldImpactEffectiveTaxRate',\n"," 'UnrecordedUnconditionalPurchaseObligationBalanceSheetAmount',\n"," 'VariableInterestEntityConsolidatedAssetsPledged',\n"," 'VariableInterestEntityConsolidatedLiabilitiesNoRecourse',\n"," 'VariableLeaseCost',\n"," 'IndefiniteLivedIntangibleAssetsExcludingGoodwill',\n"," 'IntangibleAssetsGrossExcludingGoodwill',\n"," 'VariableInterestEntityEntityMaximumLossExposureAmount']"]},"metadata":{},"execution_count":8}]},{"cell_type":"code","source":["shares_keys = [key for key in keys if 'shares' in data[key]['units'].keys()]\n","shares_keys"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"A10eLZM4kOgj","executionInfo":{"status":"ok","timestamp":1660212869534,"user_tz":-120,"elapsed":39,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"20dcafc8-baa2-439e-a2c7-4c40cf138b2c"},"execution_count":9,"outputs":[{"output_type":"execute_result","data":{"text/plain":["['CommonStockCapitalSharesReservedForFutureIssuance',\n"," 'CommonStockSharesAuthorized',\n"," 'CommonStockSharesIssued',\n"," 'CommonStockSharesOutstanding',\n"," 'PreferredStockSharesAuthorized',\n"," 'PreferredStockSharesIssued',\n"," 'PreferredStockSharesOutstanding',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsExercisableNumber',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsForfeituresAndExpirationsInPeriod',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsGrantsInPeriod',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsOutstandingNumber',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsVestedAndExpectedToVestExercisableNumber',\n"," 'StockIssuedDuringPeriodSharesStockOptionsExercised']"]},"metadata":{},"execution_count":9}]},{"cell_type":"code","source":["usd_shares_keys = [key for key in keys if 'USD/shares' in data[key]['units'].keys()]\n","usd_shares_keys"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"BvY4j5B3kZix","executionInfo":{"status":"ok","timestamp":1660212869534,"user_tz":-120,"elapsed":24,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"7d62f694-b175-4d80-d0fe-0ae2a1b37485"},"execution_count":10,"outputs":[{"output_type":"execute_result","data":{"text/plain":["['CommonStockParOrStatedValuePerShare',\n"," 'EarningsPerShareBasic',\n"," 'EarningsPerShareDiluted',\n"," 'IncomeLossFromContinuingOperationsPerBasicShare',\n"," 'IncomeLossFromContinuingOperationsPerDilutedShare',\n"," 'PreferredStockParOrStatedValuePerShare',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsExercisableWeightedAverageExercisePrice',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsOutstandingWeightedAverageExercisePrice',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsVestedAndExpectedToVestExercisableWeightedAverageExercisePrice',\n"," 'ShareBasedCompensationArrangementsByShareBasedPaymentAwardOptionsExercisesInPeriodWeightedAverageExercisePrice',\n"," 'ShareBasedCompensationArrangementsByShareBasedPaymentAwardOptionsForfeituresInPeriodWeightedAverageExercisePrice']"]},"metadata":{},"execution_count":10}]},{"cell_type":"code","source":["pure_keys = [key for key in keys if 'pure' in data[key]['units'].keys()]\n","pure_keys"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"cp0lkvFdla6z","executionInfo":{"status":"ok","timestamp":1660212869534,"user_tz":-120,"elapsed":21,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"4b1d095d-bab0-4efa-f7c8-6a7f1d7b2e0c"},"execution_count":11,"outputs":[{"output_type":"execute_result","data":{"text/plain":["['EffectiveIncomeTaxRateContinuingOperations',\n"," 'EffectiveIncomeTaxRateReconciliationAtFederalStatutoryIncomeTaxRate',\n"," 'EffectiveIncomeTaxRateReconciliationChangeInDeferredTaxAssetsValuationAllowance',\n"," 'EffectiveIncomeTaxRateReconciliationChangeInEnactedTaxRate',\n"," 'EffectiveIncomeTaxRateReconciliationForeignIncomeTaxRateDifferential',\n"," 'EffectiveIncomeTaxRateReconciliationNondeductibleExpenseShareBasedCompensationCost',\n"," 'EffectiveIncomeTaxRateReconciliationOtherAdjustments',\n"," 'EffectiveIncomeTaxRateReconciliationOtherReconcilingItemsPercent',\n"," 'EffectiveIncomeTaxRateReconciliationStateAndLocalIncomeTaxes',\n"," 'EffectiveIncomeTaxRateReconciliationTaxCredits',\n"," 'EffectiveIncomeTaxRateReconciliationTaxCreditsResearch',\n"," 'EffectiveIncomeTaxRateReconciliationTaxCutsAndJobsActOf2017Percent',\n"," 'EffectiveIncomeTaxRateReconciliationTaxCutsAndJobsActOf2017TransitionTaxOnAccumulatedForeignEarningsPercent',\n"," 'OperatingLeaseWeightedAverageDiscountRatePercent',\n"," 'ShortTermDebtWeightedAverageInterestRate',\n"," 'StockholdersEquityNoteStockSplitConversionRatio1']"]},"metadata":{},"execution_count":11}]},{"cell_type":"code","source":["year_keys = [key for key in keys if 'Year' in data[key]['units'].keys()]\n","year_keys"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"wFsk49jilsWB","executionInfo":{"status":"ok","timestamp":1660212869534,"user_tz":-120,"elapsed":18,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"2209799d-e398-4a76-ea70-fbfe36a6e855"},"execution_count":12,"outputs":[{"output_type":"execute_result","data":{"text/plain":["[]"]},"metadata":{},"execution_count":12}]},{"cell_type":"code","source":["keys_list = [\n","             usd_keys,\n","             shares_keys,\n","             usd_shares_keys,\n","             pure_keys,\n","             year_keys\n","]\n","\n","keys_groups = [\n","               'USD',\n","               'shares',\n","               'USD/shares',\n","               'pure',\n","               'Year'\n","]\n","\n","full_df = pd.DataFrame()\n","\n","for group, keys in zip(keys_groups, keys_list):\n","    for key in keys:\n","        key_data = data[key]['units'][group]\n","        tmp_full_df = pd.json_normalize(key_data)\n","\n","        tmp_df = tmp_full_df[tmp_full_df['form'] == '10-K'].drop_duplicates('end', keep='last')\n","        tmp_df = tmp_df[['end', 'val']].set_index('end')\n","        full_df[key] = tmp_df\n","\n","full_df.index.name = ''\n","full_df = full_df.T.dropna(how='all')\n","full_df"],"metadata":{"id":"70uuV1u2YNma","colab":{"base_uri":"https://localhost:8080/","height":424},"executionInfo":{"status":"ok","timestamp":1660212872832,"user_tz":-120,"elapsed":3312,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"f8bbaeba-c3a2-4502-b8e2-48be4856454b"},"execution_count":13,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                                                      2014-12-31  \\\n","AccountsPayableCurrent                              1.715000e+09   \n","AccountsReceivableNetCurrent                        9.383000e+09   \n","AccruedIncomeTaxesCurrent                           9.600000e+07   \n","AccruedIncomeTaxesNoncurrent                                 NaN   \n","AccruedLiabilitiesCurrent                           4.408000e+09   \n","...                                                          ...   \n","EffectiveIncomeTaxRateReconciliationTaxCreditsR...  1.800000e-02   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ...           NaN   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ...           NaN   \n","OperatingLeaseWeightedAverageDiscountRatePercent             NaN   \n","ShortTermDebtWeightedAverageInterestRate                     NaN   \n","\n","                                                      2015-12-31  \\\n","AccountsPayableCurrent                              1.931000e+09   \n","AccountsReceivableNetCurrent                        1.155600e+10   \n","AccruedIncomeTaxesCurrent                           3.020000e+08   \n","AccruedIncomeTaxesNoncurrent                                 NaN   \n","AccruedLiabilitiesCurrent                           4.768000e+09   \n","...                                                          ...   \n","EffectiveIncomeTaxRateReconciliationTaxCreditsR...  2.100000e-02   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ...           NaN   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ...           NaN   \n","OperatingLeaseWeightedAverageDiscountRatePercent             NaN   \n","ShortTermDebtWeightedAverageInterestRate            2.000000e-03   \n","\n","                                                      2016-12-31  \\\n","AccountsPayableCurrent                              2.041000e+09   \n","AccountsReceivableNetCurrent                        1.413700e+10   \n","AccruedIncomeTaxesCurrent                           5.540000e+08   \n","AccruedIncomeTaxesNoncurrent                                 NaN   \n","AccruedLiabilitiesCurrent                           6.144000e+09   \n","...                                                          ...   \n","EffectiveIncomeTaxRateReconciliationTaxCreditsR...  2.000000e-02   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ...           NaN   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ...           NaN   \n","OperatingLeaseWeightedAverageDiscountRatePercent             NaN   \n","ShortTermDebtWeightedAverageInterestRate                     NaN   \n","\n","                                                      2017-12-31  \\\n","AccountsPayableCurrent                              3.137000e+09   \n","AccountsReceivableNetCurrent                        1.833600e+10   \n","AccruedIncomeTaxesCurrent                           8.810000e+08   \n","AccruedIncomeTaxesNoncurrent                        1.281200e+10   \n","AccruedLiabilitiesCurrent                           1.017700e+10   \n","...                                                          ...   \n","EffectiveIncomeTaxRateReconciliationTaxCreditsR...  1.800000e-02   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ...           NaN   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ...  3.760000e-01   \n","OperatingLeaseWeightedAverageDiscountRatePercent             NaN   \n","ShortTermDebtWeightedAverageInterestRate                     NaN   \n","\n","                                                      2018-12-31  \\\n","AccountsPayableCurrent                              4.378000e+09   \n","AccountsReceivableNetCurrent                        2.083800e+10   \n","AccruedIncomeTaxesCurrent                           6.900000e+07   \n","AccruedIncomeTaxesNoncurrent                        1.132700e+10   \n","AccruedLiabilitiesCurrent                           1.695800e+10   \n","...                                                          ...   \n","EffectiveIncomeTaxRateReconciliationTaxCreditsR...  2.400000e-02   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ... -1.300000e-02   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ... -1.000000e-03   \n","OperatingLeaseWeightedAverageDiscountRatePercent             NaN   \n","ShortTermDebtWeightedAverageInterestRate                     NaN   \n","\n","                                                      2019-12-31  \\\n","AccountsPayableCurrent                              5.561000e+09   \n","AccountsReceivableNetCurrent                        2.532600e+10   \n","AccruedIncomeTaxesCurrent                           2.740000e+08   \n","AccruedIncomeTaxesNoncurrent                        9.885000e+09   \n","AccruedLiabilitiesCurrent                           2.306700e+10   \n","...                                                          ...   \n","EffectiveIncomeTaxRateReconciliationTaxCreditsR...  2.500000e-02   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ... -6.000000e-03   \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ... -6.000000e-03   \n","OperatingLeaseWeightedAverageDiscountRatePercent    2.800000e-02   \n","ShortTermDebtWeightedAverageInterestRate                     NaN   \n","\n","                                                      2020-12-31    2021-12-31  \n","AccountsPayableCurrent                              5.589000e+09  6.037000e+09  \n","AccountsReceivableNetCurrent                        3.093000e+10  3.930400e+10  \n","AccruedIncomeTaxesCurrent                           1.485000e+09  8.080000e+08  \n","AccruedIncomeTaxesNoncurrent                        8.849000e+09  9.176000e+09  \n","AccruedLiabilitiesCurrent                           2.863100e+10  3.123600e+10  \n","...                                                          ...           ...  \n","EffectiveIncomeTaxRateReconciliationTaxCreditsR...  2.300000e-02  1.600000e-02  \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ...  0.000000e+00           NaN  \n","EffectiveIncomeTaxRateReconciliationTaxCutsAndJ...           NaN           NaN  \n","OperatingLeaseWeightedAverageDiscountRatePercent    2.600000e-02  2.300000e-02  \n","ShortTermDebtWeightedAverageInterestRate                     NaN           NaN  \n","\n","[419 rows x 8 columns]"],"text/html":["\n","  <div id=\"df-44940c1a-60ff-4e93-8d4b-c8d420c7848b\">\n","    <div 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>2014-12-31</th>\n","      <th>2015-12-31</th>\n","      <th>2016-12-31</th>\n","      <th>2017-12-31</th>\n","      <th>2018-12-31</th>\n","      <th>2019-12-31</th>\n","      <th>2020-12-31</th>\n","      <th>2021-12-31</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>AccountsPayableCurrent</th>\n","      <td>1.715000e+09</td>\n","      <td>1.931000e+09</td>\n","      <td>2.041000e+09</td>\n","      <td>3.137000e+09</td>\n","      <td>4.378000e+09</td>\n","      <td>5.561000e+09</td>\n","      <td>5.589000e+09</td>\n","      <td>6.037000e+09</td>\n","    </tr>\n","    <tr>\n","      <th>AccountsReceivableNetCurrent</th>\n","      <td>9.383000e+09</td>\n","      <td>1.155600e+10</td>\n","      <td>1.413700e+10</td>\n","      <td>1.833600e+10</td>\n","      <td>2.083800e+10</td>\n","      <td>2.532600e+10</td>\n","      <td>3.093000e+10</td>\n","      <td>3.930400e+10</td>\n","    </tr>\n","    <tr>\n","      <th>AccruedIncomeTaxesCurrent</th>\n","      <td>9.600000e+07</td>\n","      <td>3.020000e+08</td>\n","      <td>5.540000e+08</td>\n","      <td>8.810000e+08</td>\n","      <td>6.900000e+07</td>\n","      <td>2.740000e+08</td>\n","      <td>1.485000e+09</td>\n","      <td>8.080000e+08</td>\n","    </tr>\n","    <tr>\n","      <th>AccruedIncomeTaxesNoncurrent</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>1.281200e+10</td>\n","      <td>1.132700e+10</td>\n","      <td>9.885000e+09</td>\n","      <td>8.849000e+09</td>\n","      <td>9.176000e+09</td>\n","    </tr>\n","    <tr>\n","      <th>AccruedLiabilitiesCurrent</th>\n","      <td>4.408000e+09</td>\n","      <td>4.768000e+09</td>\n","      <td>6.144000e+09</td>\n","      <td>1.017700e+10</td>\n","      <td>1.695800e+10</td>\n","      <td>2.306700e+10</td>\n","      <td>2.863100e+10</td>\n","      <td>3.123600e+10</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","    </tr>\n","    <tr>\n","      <th>EffectiveIncomeTaxRateReconciliationTaxCreditsResearch</th>\n","      <td>1.800000e-02</td>\n","      <td>2.100000e-02</td>\n","      <td>2.000000e-02</td>\n","      <td>1.800000e-02</td>\n","      <td>2.400000e-02</td>\n","      <td>2.500000e-02</td>\n","      <td>2.300000e-02</td>\n","      <td>1.600000e-02</td>\n","    </tr>\n","    <tr>\n","      <th>EffectiveIncomeTaxRateReconciliationTaxCutsAndJobsActOf2017Percent</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>-1.300000e-02</td>\n","      <td>-6.000000e-03</td>\n","      <td>0.000000e+00</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>EffectiveIncomeTaxRateReconciliationTaxCutsAndJobsActOf2017TransitionTaxOnAccumulatedForeignEarningsPercent</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>3.760000e-01</td>\n","      <td>-1.000000e-03</td>\n","      <td>-6.000000e-03</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>OperatingLeaseWeightedAverageDiscountRatePercent</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>2.800000e-02</td>\n","      <td>2.600000e-02</td>\n","      <td>2.300000e-02</td>\n","    </tr>\n","    <tr>\n","      <th>ShortTermDebtWeightedAverageInterestRate</th>\n","      <td>NaN</td>\n","      <td>2.000000e-03</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","    </tr>\n","  </tbody>\n","</table>\n","<p>419 rows × 8 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-44940c1a-60ff-4e93-8d4b-c8d420c7848b')\"\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 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\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","    [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-44940c1a-60ff-4e93-8d4b-c8d420c7848b 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-44940c1a-60ff-4e93-8d4b-c8d420c7848b');\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","  </div>\n","  "]},"metadata":{},"execution_count":13}]},{"cell_type":"code","source":["last_year_data = full_df.iloc[:, -1].dropna()\n","last_year_data.index.to_list()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"UWcdalSguiQ5","executionInfo":{"status":"ok","timestamp":1660212872834,"user_tz":-120,"elapsed":32,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"f5f07547-2c62-4821-be2e-8e7004721644"},"execution_count":14,"outputs":[{"output_type":"execute_result","data":{"text/plain":["['AccountsPayableCurrent',\n"," 'AccountsReceivableNetCurrent',\n"," 'AccruedIncomeTaxesCurrent',\n"," 'AccruedIncomeTaxesNoncurrent',\n"," 'AccruedLiabilitiesCurrent',\n"," 'AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment',\n"," 'AccumulatedOtherComprehensiveIncomeLossNetOfTax',\n"," 'AdjustmentsToAdditionalPaidInCapitalSharebasedCompensationRequisiteServicePeriodRecognitionValue',\n"," 'AllocatedShareBasedCompensationExpense',\n"," 'AllowanceForDoubtfulAccountsReceivable',\n"," 'Assets',\n"," 'AssetsCurrent',\n"," 'AvailableForSaleSecuritiesDebtMaturitiesAfterFiveThroughTenYearsFairValue',\n"," 'AvailableForSaleSecuritiesDebtMaturitiesAfterOneThroughFiveYearsFairValue',\n"," 'AvailableForSaleSecuritiesDebtMaturitiesAfterTenYearsFairValue',\n"," 'AvailableForSaleSecuritiesDebtMaturitiesWithinOneYearFairValue',\n"," 'AvailableForSaleSecuritiesDebtSecurities',\n"," 'CashAndCashEquivalentsAtCarryingValue',\n"," 'CashAndCashEquivalentsFairValueDisclosure',\n"," 'CashCashEquivalentsAndShortTermInvestments',\n"," 'CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents',\n"," 'CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsPeriodIncreaseDecreaseIncludingExchangeRateEffect',\n"," 'CommercialPaper',\n"," 'CommonStocksIncludingAdditionalPaidInCapital',\n"," 'ComprehensiveIncomeNetOfTax',\n"," 'ContractWithCustomerLiabilityCurrent',\n"," 'ContractWithCustomerLiabilityNoncurrent',\n"," 'ContractWithCustomerLiabilityRevenueRecognized',\n"," 'ConvertiblePreferredStockNonredeemableOrRedeemableIssuerOptionValue',\n"," 'CostOfRevenue',\n"," 'CostsAndExpenses',\n"," 'CurrentFederalStateAndLocalTaxExpenseBenefit',\n"," 'CurrentForeignTaxExpenseBenefit',\n"," 'CurrentIncomeTaxExpenseBenefit',\n"," 'DebtAndEquitySecuritiesGainLoss',\n"," 'DebtInstrumentUnamortizedDiscountPremiumAndDebtIssuanceCostsNet',\n"," 'DebtSecuritiesAvailableForSaleContinuousUnrealizedLossPosition12MonthsOrLonger',\n"," 'DebtSecuritiesAvailableForSaleContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss',\n"," 'DebtSecuritiesAvailableForSaleContinuousUnrealizedLossPositionLessThan12Months',\n"," 'DebtSecuritiesAvailableForSaleContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss',\n"," 'DebtSecuritiesAvailableForSaleRealizedGain',\n"," 'DebtSecuritiesAvailableForSaleRealizedLoss',\n"," 'DebtSecuritiesAvailableForSaleUnrealizedLossPosition',\n"," 'DebtSecuritiesAvailableForSaleUnrealizedLossPositionAccumulatedLoss',\n"," 'DebtSecuritiesRealizedGainLoss',\n"," 'DecreaseInUnrecognizedTaxBenefitsIsReasonablyPossible',\n"," 'DeferredFederalStateAndLocalTaxExpenseBenefit',\n"," 'DeferredForeignIncomeTaxExpenseBenefit',\n"," 'DeferredIncomeTaxAssetsNet',\n"," 'DeferredIncomeTaxExpenseBenefit',\n"," 'DeferredIncomeTaxesAndTaxCredits',\n"," 'DeferredIncomeTaxLiabilities',\n"," 'DeferredIncomeTaxLiabilitiesNet',\n"," 'DeferredTaxAssetsGross',\n"," 'DeferredTaxAssetsNet',\n"," 'DeferredTaxAssetsOperatingLossCarryforwards',\n"," 'DeferredTaxAssetsOther',\n"," 'DeferredTaxAssetsTaxCreditCarryforwardsOther',\n"," 'DeferredTaxAssetsTaxDeferredExpenseCompensationAndBenefitsEmployeeBenefits',\n"," 'DeferredTaxAssetsTaxDeferredExpenseReservesAndAccrualsOther',\n"," 'DeferredTaxAssetsValuationAllowance',\n"," 'DeferredTaxLiabilities',\n"," 'DeferredTaxLiabilitiesInvestments',\n"," 'DeferredTaxLiabilitiesOther',\n"," 'DeferredTaxLiabilitiesPropertyPlantAndEquipment',\n"," 'DefinedContributionPlanCostRecognized',\n"," 'DerivativeAssetFairValueGrossLiability',\n"," 'DerivativeAssetFairValueOffsetAgainstCollateralNetOfNotSubjectToMasterNettingArrangementPolicyElection',\n"," 'DerivativeAssetNotOffsetPolicyElectionDeduction',\n"," 'DerivativeAssets',\n"," 'DerivativeCollateralObligationToReturnCash',\n"," 'DerivativeCollateralObligationToReturnSecurities',\n"," 'DerivativeCollateralRightToReclaimCash',\n"," 'DerivativeCollateralRightToReclaimSecurities',\n"," 'DerivativeFairValueOfDerivativeAsset',\n"," 'DerivativeFairValueOfDerivativeLiability',\n"," 'DerivativeInstrumentsNotDesignatedAsHedgingInstrumentsGainLossNet',\n"," 'DerivativeLiabilities',\n"," 'DerivativeLiabilityFairValueGrossAsset',\n"," 'DerivativeLiabilityFairValueOffsetAgainstCollateralNetOfNotSubjectToMasterNettingArrangementPolicyElection',\n"," 'DerivativeLiabilityNotOffsetPolicyElectionDeduction',\n"," 'EffectOfExchangeRateOnCashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents',\n"," 'EmployeeRelatedLiabilitiesCurrent',\n"," 'EmployeeServiceShareBasedCompensationTaxBenefitFromCompensationExpense',\n"," 'EquityMethodInvestments',\n"," 'EquitySecuritiesFvNi',\n"," 'EquitySecuritiesFvNiAndWithoutReadilyDeterminableFairValue',\n"," 'EquitySecuritiesFvNiCost',\n"," 'EquitySecuritiesFvNiGainLoss',\n"," 'EquitySecuritiesFvNiRealizedGainLoss',\n"," 'EquitySecuritiesFvNiUnrealizedGainLoss',\n"," 'EquitySecuritiesWithoutReadilyDeterminableFairValueAmount',\n"," 'EquitySecuritiesWithoutReadilyDeterminableFairValueDownwardPriceAdjustmentAnnualAmount',\n"," 'EquitySecuritiesWithoutReadilyDeterminableFairValueUpwardPriceAdjustmentAnnualAmount',\n"," 'FinanceLeaseLiability',\n"," 'FinanceLeaseLiabilityCurrent',\n"," 'FiniteLivedIntangibleAssetsAccumulatedAmortization',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseAfterYearFive',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseNextTwelveMonths',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseYearFive',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseYearFour',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseYearThree',\n"," 'FiniteLivedIntangibleAssetsAmortizationExpenseYearTwo',\n"," 'FiniteLivedIntangibleAssetsGross',\n"," 'FiniteLivedIntangibleAssetsNet',\n"," 'ForeignCurrencyCashFlowHedgeGainLossToBeReclassifiedDuringNext12Months',\n"," 'ForeignCurrencyTransactionGainLossBeforeTax',\n"," 'GainLossOnOilAndGasHedgingActivity',\n"," 'GeneralAndAdministrativeExpense',\n"," 'Goodwill',\n"," 'GoodwillAcquiredDuringPeriod',\n"," 'GoodwillImpairmentLoss',\n"," 'GoodwillTranslationAndPurchaseAccountingAdjustments',\n"," 'IncomeLossFromContinuingOperationsBeforeIncomeTaxesDomestic',\n"," 'IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest',\n"," 'IncomeLossFromContinuingOperationsBeforeIncomeTaxesForeign',\n"," 'IncomeTaxExpenseBenefit',\n"," 'IncomeTaxesPaidNet',\n"," 'IncomeTaxesReceivable',\n"," 'IncreaseDecreaseInAccountsPayable',\n"," 'IncreaseDecreaseInAccountsReceivable',\n"," 'IncreaseDecreaseInAccruedLiabilities',\n"," 'IncreaseDecreaseInContractWithCustomerLiability',\n"," 'IncreaseDecreaseInIncomeTaxes',\n"," 'IncreaseDecreaseInOtherOperatingAssets',\n"," 'IntangibleAssetsNetExcludingGoodwill',\n"," 'InterestCostsCapitalized',\n"," 'InterestExpense',\n"," 'InterestIncomeOther',\n"," 'InventoryNet',\n"," 'LeaseCost',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDue',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueAfterYearFive',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueNextTwelveMonths',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueYearFive',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueYearFour',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueYearThree',\n"," 'LesseeOperatingLeaseLiabilityPaymentsDueYearTwo',\n"," 'LesseeOperatingLeaseLiabilityUndiscountedExcessAmount',\n"," 'Liabilities',\n"," 'LiabilitiesAndStockholdersEquity',\n"," 'LiabilitiesCurrent',\n"," 'LongTermDebt',\n"," 'LongTermDebtAndCapitalLeaseObligations',\n"," 'LongTermDebtAndCapitalLeaseObligationsIncludingCurrentMaturities',\n"," 'LongTermDebtCurrent',\n"," 'LongTermDebtFairValue',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalAfterYearFive',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalInNextTwelveMonths',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalInYearFive',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalInYearFour',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalInYearThree',\n"," 'LongTermDebtMaturitiesRepaymentsOfPrincipalInYearTwo',\n"," 'LossContingencyAccrualCarryingValueCurrent',\n"," 'LossContingencyLossInPeriod',\n"," 'MarketableSecurities',\n"," 'MarketableSecuritiesCurrent',\n"," 'MarketingAndAdvertisingExpense',\n"," 'NetCashProvidedByUsedInFinancingActivities',\n"," 'NetCashProvidedByUsedInInvestingActivities',\n"," 'NetCashProvidedByUsedInOperatingActivities',\n"," 'NetIncomeLoss',\n"," 'NoncontrollingInterestIncreaseFromSaleOfParentEquityInterest',\n"," 'NoncontrollingInterestInVariableInterestEntity',\n"," 'NoncurrentAssets',\n"," 'NonoperatingIncomeExpense',\n"," 'OciBeforeReclassificationsNetOfTaxAttributableToParent',\n"," 'OperatingIncomeLoss',\n"," 'OperatingLeaseCost',\n"," 'OperatingLeaseLiability',\n"," 'OperatingLeaseLiabilityCurrent',\n"," 'OperatingLeaseLiabilityNoncurrent',\n"," 'OperatingLeasePayments',\n"," 'OperatingLeaseRightOfUseAsset',\n"," 'OtherAccruedLiabilitiesCurrent',\n"," 'OtherAssetsCurrent',\n"," 'OtherAssetsNoncurrent',\n"," 'OtherComprehensiveIncomeLossAvailableForSaleSecuritiesAdjustmentNetOfTax',\n"," 'OtherComprehensiveIncomeLossAvailableForSaleSecuritiesTax',\n"," 'OtherComprehensiveIncomeLossCashFlowHedgeGainLossAfterReclassificationAndTax',\n"," 'OtherComprehensiveIncomeLossCashFlowHedgeGainLossAfterReclassificationTax',\n"," 'OtherComprehensiveIncomeLossCashFlowHedgeGainLossBeforeReclassificationAfterTax',\n"," 'OtherComprehensiveIncomeLossCashFlowHedgeGainLossReclassificationAfterTax',\n"," 'OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax',\n"," 'OtherComprehensiveIncomeLossNetOfTax',\n"," 'OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent',\n"," 'OtherComprehensiveIncomeLossReclassificationAdjustmentFromAOCIForSaleOfSecuritiesNetOfTax',\n"," 'OtherComprehensiveIncomeUnrealizedHoldingGainLossOnSecuritiesArisingDuringPeriodNetOfTax',\n"," 'OtherLiabilitiesNoncurrent',\n"," 'OtherLongTermInvestments',\n"," 'OtherNoncashIncomeExpense',\n"," 'OtherNonoperatingIncomeExpense',\n"," 'PaymentsForProceedsFromOtherInvestingActivities',\n"," 'PaymentsForRepurchaseOfCommonStock',\n"," 'PaymentsToAcquireMarketableSecurities',\n"," 'PaymentsToAcquireOtherInvestments',\n"," 'PaymentsToAcquirePropertyPlantAndEquipment',\n"," 'ProceedsFromDebtNetOfIssuanceCosts',\n"," 'ProceedsFromMinorityShareholders',\n"," 'ProceedsFromSaleAndMaturityOfMarketableSecurities',\n"," 'ProceedsFromSaleAndMaturityOfOtherInvestments',\n"," 'PropertyPlantAndEquipmentGross',\n"," 'PropertyPlantAndEquipmentNet',\n"," 'ReclassificationFromAociCurrentPeriodNetOfTaxAttributableToParent',\n"," 'RepaymentsOfDebtAndCapitalLeaseObligations',\n"," 'ResearchAndDevelopmentExpense',\n"," 'RetainedEarningsAccumulatedDeficit',\n"," 'RevenueRemainingPerformanceObligation',\n"," 'Revenues',\n"," 'RightOfUseAssetObtainedInExchangeForOperatingLeaseLiability',\n"," 'SellingAndMarketingExpense',\n"," 'ShareBasedCompensation',\n"," 'ShareBasedCompensationArrangementByShareBasedPaymentAwardEquityInstrumentsOtherThanOptionsVestedInPeriodTotalFairValue',\n"," 'StockholdersEquity',\n"," 'StockIssuedDuringPeriodValueNewIssues',\n"," 'StockRepurchasedAndRetiredDuringPeriodValue',\n"," 'TaxCreditCarryforwardAmount',\n"," 'UnrecognizedTaxBenefits',\n"," 'UnrecognizedTaxBenefitsDecreasesResultingFromPriorPeriodTaxPositions',\n"," 'UnrecognizedTaxBenefitsDecreasesResultingFromSettlementsWithTaxingAuthorities',\n"," 'UnrecognizedTaxBenefitsIncomeTaxPenaltiesAndInterestAccrued',\n"," 'UnrecognizedTaxBenefitsIncreasesResultingFromCurrentPeriodTaxPositions',\n"," 'UnrecognizedTaxBenefitsIncreasesResultingFromPriorPeriodTaxPositions',\n"," 'UnrecognizedTaxBenefitsThatWouldImpactEffectiveTaxRate',\n"," 'VariableLeaseCost',\n"," 'IndefiniteLivedIntangibleAssetsExcludingGoodwill',\n"," 'IntangibleAssetsGrossExcludingGoodwill',\n"," 'VariableInterestEntityEntityMaximumLossExposureAmount',\n"," 'CommonStockSharesAuthorized',\n"," 'CommonStockSharesIssued',\n"," 'CommonStockSharesOutstanding',\n"," 'PreferredStockSharesAuthorized',\n"," 'PreferredStockSharesIssued',\n"," 'PreferredStockSharesOutstanding',\n"," 'CommonStockParOrStatedValuePerShare',\n"," 'EarningsPerShareBasic',\n"," 'EarningsPerShareDiluted',\n"," 'PreferredStockParOrStatedValuePerShare',\n"," 'EffectiveIncomeTaxRateContinuingOperations',\n"," 'EffectiveIncomeTaxRateReconciliationAtFederalStatutoryIncomeTaxRate',\n"," 'EffectiveIncomeTaxRateReconciliationChangeInDeferredTaxAssetsValuationAllowance',\n"," 'EffectiveIncomeTaxRateReconciliationForeignIncomeTaxRateDifferential',\n"," 'EffectiveIncomeTaxRateReconciliationNondeductibleExpenseShareBasedCompensationCost',\n"," 'EffectiveIncomeTaxRateReconciliationStateAndLocalIncomeTaxes',\n"," 'EffectiveIncomeTaxRateReconciliationTaxCreditsResearch',\n"," 'OperatingLeaseWeightedAverageDiscountRatePercent']"]},"metadata":{},"execution_count":14}]},{"cell_type":"code","source":["df_5y = full_df.copy()\n","df_5y = df_5y.iloc[:, -5:].dropna(how='all')\n","df_5y.index = camelcase_to_title(df_5y.index)\n","df_5y"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":424},"id":"X6IsKICUBGC3","executionInfo":{"status":"ok","timestamp":1660212872835,"user_tz":-120,"elapsed":23,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"98d5f4a7-0d9c-4d0f-8e12-e7f9fc86b390"},"execution_count":15,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                                                      2017-12-31  \\\n","Accounts Payable Current                            3.137000e+09   \n","Accounts Receivable Net Current                     1.833600e+10   \n","Accrued Income Taxes Current                        8.810000e+08   \n","Accrued Income Taxes Noncurrent                     1.281200e+10   \n","Accrued Liabilities Current                         1.017700e+10   \n","...                                                          ...   \n","Effective Income Tax Rate Reconciliation State ...  1.000000e-03   \n","Effective Income Tax Rate Reconciliation Tax Cr...  1.800000e-02   \n","Effective Income Tax Rate Reconciliation Tax Cu...           NaN   \n","Effective Income Tax Rate Reconciliation Tax Cu...  3.760000e-01   \n","Operating Lease Weighted Average Discount Rate ...           NaN   \n","\n","                                                      2018-12-31  \\\n","Accounts Payable Current                            4.378000e+09   \n","Accounts Receivable Net Current                     2.083800e+10   \n","Accrued Income Taxes Current                        6.900000e+07   \n","Accrued Income Taxes Noncurrent                     1.132700e+10   \n","Accrued Liabilities Current                         1.695800e+10   \n","...                                                          ...   \n","Effective Income Tax Rate Reconciliation State ... -4.000000e-03   \n","Effective Income Tax Rate Reconciliation Tax Cr...  2.400000e-02   \n","Effective Income Tax Rate Reconciliation Tax Cu... -1.300000e-02   \n","Effective Income Tax Rate Reconciliation Tax Cu... -1.000000e-03   \n","Operating Lease Weighted Average Discount Rate ...           NaN   \n","\n","                                                      2019-12-31  \\\n","Accounts Payable Current                            5.561000e+09   \n","Accounts Receivable Net Current                     2.532600e+10   \n","Accrued Income Taxes Current                        2.740000e+08   \n","Accrued Income Taxes Noncurrent                     9.885000e+09   \n","Accrued Liabilities Current                         2.306700e+10   \n","...                                                          ...   \n","Effective Income Tax Rate Reconciliation State ...  1.100000e-02   \n","Effective Income Tax Rate Reconciliation Tax Cr...  2.500000e-02   \n","Effective Income Tax Rate Reconciliation Tax Cu... -6.000000e-03   \n","Effective Income Tax Rate Reconciliation Tax Cu... -6.000000e-03   \n","Operating Lease Weighted Average Discount Rate ...  2.800000e-02   \n","\n","                                                      2020-12-31    2021-12-31  \n","Accounts Payable Current                            5.589000e+09  6.037000e+09  \n","Accounts Receivable Net Current                     3.093000e+10  3.930400e+10  \n","Accrued Income Taxes Current                        1.485000e+09  8.080000e+08  \n","Accrued Income Taxes Noncurrent                     8.849000e+09  9.176000e+09  \n","Accrued Liabilities Current                         2.863100e+10  3.123600e+10  \n","...                                                          ...           ...  \n","Effective Income Tax Rate Reconciliation State ...  1.100000e-02  1.000000e-02  \n","Effective Income Tax Rate Reconciliation Tax Cr...  2.300000e-02  1.600000e-02  \n","Effective Income Tax Rate Reconciliation Tax Cu...  0.000000e+00           NaN  \n","Effective Income Tax Rate Reconciliation Tax Cu...           NaN           NaN  \n","Operating Lease Weighted Average Discount Rate ...  2.600000e-02  2.300000e-02  \n","\n","[330 rows x 5 columns]"],"text/html":["\n","  <div id=\"df-1fcce4f1-df15-4eb7-af63-ae062a74d0d1\">\n","    <div 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>2017-12-31</th>\n","      <th>2018-12-31</th>\n","      <th>2019-12-31</th>\n","      <th>2020-12-31</th>\n","      <th>2021-12-31</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>Accounts Payable Current</th>\n","      <td>3.137000e+09</td>\n","      <td>4.378000e+09</td>\n","      <td>5.561000e+09</td>\n","      <td>5.589000e+09</td>\n","      <td>6.037000e+09</td>\n","    </tr>\n","    <tr>\n","      <th>Accounts Receivable Net Current</th>\n","      <td>1.833600e+10</td>\n","      <td>2.083800e+10</td>\n","      <td>2.532600e+10</td>\n","      <td>3.093000e+10</td>\n","      <td>3.930400e+10</td>\n","    </tr>\n","    <tr>\n","      <th>Accrued Income Taxes Current</th>\n","      <td>8.810000e+08</td>\n","      <td>6.900000e+07</td>\n","      <td>2.740000e+08</td>\n","      <td>1.485000e+09</td>\n","      <td>8.080000e+08</td>\n","    </tr>\n","    <tr>\n","      <th>Accrued Income Taxes Noncurrent</th>\n","      <td>1.281200e+10</td>\n","      <td>1.132700e+10</td>\n","      <td>9.885000e+09</td>\n","      <td>8.849000e+09</td>\n","      <td>9.176000e+09</td>\n","    </tr>\n","    <tr>\n","      <th>Accrued Liabilities Current</th>\n","      <td>1.017700e+10</td>\n","      <td>1.695800e+10</td>\n","      <td>2.306700e+10</td>\n","      <td>2.863100e+10</td>\n","      <td>3.123600e+10</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>Effective Income Tax Rate Reconciliation State And Local Income Taxes</th>\n","      <td>1.000000e-03</td>\n","      <td>-4.000000e-03</td>\n","      <td>1.100000e-02</td>\n","      <td>1.100000e-02</td>\n","      <td>1.000000e-02</td>\n","    </tr>\n","    <tr>\n","      <th>Effective Income Tax Rate Reconciliation Tax Credits Research</th>\n","      <td>1.800000e-02</td>\n","      <td>2.400000e-02</td>\n","      <td>2.500000e-02</td>\n","      <td>2.300000e-02</td>\n","      <td>1.600000e-02</td>\n","    </tr>\n","    <tr>\n","      <th>Effective Income Tax Rate Reconciliation Tax Cuts And Jobs Act Of2017Percent</th>\n","      <td>NaN</td>\n","      <td>-1.300000e-02</td>\n","      <td>-6.000000e-03</td>\n","      <td>0.000000e+00</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>Effective Income Tax Rate Reconciliation Tax Cuts And Jobs Act Of2017Transition Tax On Accumulated Foreign Earnings Percent</th>\n","      <td>3.760000e-01</td>\n","      <td>-1.000000e-03</td>\n","      <td>-6.000000e-03</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>Operating Lease Weighted Average Discount Rate Percent</th>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>2.800000e-02</td>\n","      <td>2.600000e-02</td>\n","      <td>2.300000e-02</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>330 rows × 5 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1fcce4f1-df15-4eb7-af63-ae062a74d0d1')\"\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 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\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","    [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-1fcce4f1-df15-4eb7-af63-ae062a74d0d1 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-1fcce4f1-df15-4eb7-af63-ae062a74d0d1');\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","  </div>\n","  "]},"metadata":{},"execution_count":15}]},{"cell_type":"code","source":["df_5y[df_5y.index.str.contains('Cash')].iloc[:, -1].dropna()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"sBkx6nvXkeKc","executionInfo":{"status":"ok","timestamp":1660212873169,"user_tz":-120,"elapsed":355,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}},"outputId":"f7c07db6-a5ff-4bd1-94a3-89388ab0716f"},"execution_count":16,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Cash And Cash Equivalents At Carrying Value                                                                                      2.094500e+10\n","Cash And Cash Equivalents Fair Value Disclosure                                                                                  7.499000e+09\n","Cash Cash Equivalents And Short Term Investments                                                                                 1.396490e+11\n","Cash Cash Equivalents Restricted Cash And Restricted Cash Equivalents                                                            2.094500e+10\n","Cash Cash Equivalents Restricted Cash And Restricted Cash Equivalents Period Increase Decrease Including Exchange Rate Effect   -5.520000e+09\n","Derivative Collateral Obligation To Return Cash                                                                                  3.940000e+08\n","Derivative Collateral Right To Reclaim Cash                                                                                      4.000000e+06\n","Effect Of Exchange Rate On Cash Cash Equivalents Restricted Cash And Restricted Cash Equivalents                                -2.870000e+08\n","Foreign Currency Cash Flow Hedge Gain Loss To Be Reclassified During Next12Months                                                5.180000e+08\n","Net Cash Provided By Used In Financing Activities                                                                               -6.136200e+10\n","Net Cash Provided By Used In Investing Activities                                                                               -3.552300e+10\n","Net Cash Provided By Used In Operating Activities                                                                                9.165200e+10\n","Other Comprehensive Income Loss Cash Flow Hedge Gain Loss After Reclassification And Tax                                         5.620000e+08\n","Other Comprehensive Income Loss Cash Flow Hedge Gain Loss After Reclassification Tax                                             1.220000e+08\n","Other Comprehensive Income Loss Cash Flow Hedge Gain Loss Before Reclassification After Tax                                      7.160000e+08\n","Other Comprehensive Income Loss Cash Flow Hedge Gain Loss Reclassification After Tax                                             1.540000e+08\n","Name: 2021-12-31, dtype: float64"]},"metadata":{},"execution_count":16}]},{"cell_type":"code","source":["# https://data.sec.gov/api/xbrl/frames/us-gaap/[tag]/USD/[frame].json\n","\n","# https://data.sec.gov/api/xbrl/frames/us-gaap/AccountsPayableCurrent/USD/CY2022Q1I.json"],"metadata":{"id":"nREQFTcfyczF","executionInfo":{"status":"ok","timestamp":1660212873169,"user_tz":-120,"elapsed":6,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":17,"outputs":[]}]}