Untitled2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "27.59\n",
      "41.1\n",
      "59.97\n",
      "46.11\n",
      "22.38\n",
      "21.59\n",
      "25.92\n",
      "29.84\n",
      "29.32\n",
      "12.03\n",
      "32.57\n",
      "58.69\n",
      "79.76\n",
      "54.67\n",
      "591.07\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[27.59,\n",
       " 41.1,\n",
       " 59.97,\n",
       " 46.11,\n",
       " 22.38,\n",
       " 21.59,\n",
       " 25.92,\n",
       " 29.84,\n",
       " 29.32,\n",
       " 12.03,\n",
       " 32.57,\n",
       " 58.69,\n",
       " 79.76,\n",
       " 54.67,\n",
       " 591.07]"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import json\n",
    "\n",
    "all_data = json.load(open('Yahoo_Financials.json'))\n",
    "\n",
    "for company in all_data:\n",
    "    print(\"{}\".format(all_data[company]['Valuation Measures']['Trailing P/E']))\n",
    "\n",
    "\n",
    "[all_data[company]['Valuation Measures']['Trailing P/E'] for company in all_data]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Market Cap (intraday)': 2049999999999.9998,\n",
       "  'Enterprise Value': 2109999999999.9998,\n",
       "  'Trailing P/E': 27.59,\n",
       "  'Forward P/E': 22.99,\n",
       "  'PEG Ratio (5 yr expected)': 1.45,\n",
       "  'Price/Sales': 6.3,\n",
       "  'Price/Book': 29.61,\n",
       "  'Enterprise Value/Revenue': 6.49,\n",
       "  'Enterprise Value/EBITDA': 21.17},\n",
       " {'Market Cap (intraday)': 225660000000.0,\n",
       "  'Enterprise Value': 231660000000.0,\n",
       "  'Trailing P/E': 41.1,\n",
       "  'Forward P/E': 34.51,\n",
       "  'PEG Ratio (5 yr expected)': 2.48,\n",
       "  'Price/Sales': 16.49,\n",
       "  'Price/Book': 16.69,\n",
       "  'Enterprise Value/Revenue': 16.93,\n",
       "  'Enterprise Value/EBITDA': 43.44},\n",
       " {'Market Cap (intraday)': 1590000000000.0,\n",
       "  'Enterprise Value': 1650000000000.0,\n",
       "  'Trailing P/E': 59.97,\n",
       "  'Forward P/E': 43.73,\n",
       "  'PEG Ratio (5 yr expected)': 1.5899999999999999,\n",
       "  'Price/Sales': 3.79,\n",
       "  'Price/Book': 15.38,\n",
       "  'Enterprise Value/Revenue': 3.95,\n",
       "  'Enterprise Value/EBITDA': 28.93},\n",
       " {'Market Cap (intraday)': 254780000000.0,\n",
       "  'Enterprise Value': 249940000000.0,\n",
       "  'Trailing P/E': 46.11,\n",
       "  'Forward P/E': 35.24,\n",
       "  'PEG Ratio (5 yr expected)': 1.54,\n",
       "  'Price/Sales': 16.02,\n",
       "  'Price/Book': 18.34,\n",
       "  'Enterprise Value/Revenue': 15.72,\n",
       "  'Enterprise Value/EBITDA': 44.76},\n",
       " {'Market Cap (intraday)': 260130000000.0,\n",
       "  'Enterprise Value': 360160000000.0,\n",
       "  'Trailing P/E': 22.38,\n",
       "  'Forward P/E': 15.43,\n",
       "  'PEG Ratio (5 yr expected)': 1.04,\n",
       "  'Price/Sales': 2.5,\n",
       "  'Price/Book': 2.81,\n",
       "  'Enterprise Value/Revenue': 3.46,\n",
       "  'Enterprise Value/EBITDA': 11.66},\n",
       " {'Market Cap (intraday)': 217840000000.0,\n",
       "  'Enterprise Value': 208070000000.0,\n",
       "  'Trailing P/E': 21.59,\n",
       "  'Forward P/E': 15.09,\n",
       "  'PEG Ratio (5 yr expected)': 2.8200000000000003,\n",
       "  'Price/Sales': 4.54,\n",
       "  'Price/Book': 5.57,\n",
       "  'Enterprise Value/Revenue': 4.33,\n",
       "  'Enterprise Value/EBITDA': 13.66},\n",
       " {'Market Cap (intraday)': 857870000000.0,\n",
       "  'Enterprise Value': 805790000000.0,\n",
       "  'Trailing P/E': 25.92,\n",
       "  'Forward P/E': 19.92,\n",
       "  'PEG Ratio (5 yr expected)': 0.97,\n",
       "  'Price/Sales': 9.09,\n",
       "  'Price/Book': 6.43,\n",
       "  'Enterprise Value/Revenue': 8.54,\n",
       "  'Enterprise Value/EBITDA': 17.75},\n",
       " {'Market Cap (intraday)': 1490000000000.0,\n",
       "  'Enterprise Value': 1390000000000.0,\n",
       "  'Trailing P/E': 29.84,\n",
       "  'Forward P/E': 23.64,\n",
       "  'PEG Ratio (5 yr expected)': 1.27,\n",
       "  'Price/Sales': 7.5600000000000005,\n",
       "  'Price/Book': 6.53,\n",
       "  'Enterprise Value/Revenue': 7.09,\n",
       "  'Enterprise Value/EBITDA': 22.12},\n",
       " {'Market Cap (intraday)': 1490000000000.0,\n",
       "  'Enterprise Value': 1370000000000.0,\n",
       "  'Trailing P/E': 29.32,\n",
       "  'Forward P/E': 23.21,\n",
       "  'PEG Ratio (5 yr expected)': 1.25,\n",
       "  'Price/Sales': 7.5600000000000005,\n",
       "  'Price/Book': 6.42,\n",
       "  'Enterprise Value/Revenue': 6.95,\n",
       "  'Enterprise Value/EBITDA': 21.71},\n",
       " {'Market Cap (intraday)': 216520000000.0,\n",
       "  'Enterprise Value': 235740000000.0,\n",
       "  'Trailing P/E': 12.03,\n",
       "  'Forward P/E': 11.68,\n",
       "  'PEG Ratio (5 yr expected)': 2.34,\n",
       "  'Price/Sales': 2.79,\n",
       "  'Price/Book': 2.71,\n",
       "  'Enterprise Value/Revenue': 3.03,\n",
       "  'Enterprise Value/EBITDA': 6.8},\n",
       " {'Market Cap (intraday)': 1800000000000.0,\n",
       "  'Enterprise Value': 1760000000000.0,\n",
       "  'Trailing P/E': 32.57,\n",
       "  'Forward P/E': 28.62,\n",
       "  'PEG Ratio (5 yr expected)': 2.01,\n",
       "  'Price/Sales': 11.25,\n",
       "  'Price/Book': 13.39,\n",
       "  'Enterprise Value/Revenue': 10.98,\n",
       "  'Enterprise Value/EBITDA': 23.24},\n",
       " {'Market Cap (intraday)': 215040000000.0,\n",
       "  'Enterprise Value': 224370000000.0,\n",
       "  'Trailing P/E': 58.69,\n",
       "  'Forward P/E': 37.39,\n",
       "  'PEG Ratio (5 yr expected)': 1.09,\n",
       "  'Price/Sales': 8.15,\n",
       "  'Price/Book': 16.69,\n",
       "  'Enterprise Value/Revenue': 8.5,\n",
       "  'Enterprise Value/EBITDA': 39.29},\n",
       " {'Market Cap (intraday)': 342520000000.0,\n",
       "  'Enterprise Value': 337370000000.0,\n",
       "  'Trailing P/E': 79.76,\n",
       "  'Forward P/E': 35.81,\n",
       "  'PEG Ratio (5 yr expected)': 2.05,\n",
       "  'Price/Sales': 20.54,\n",
       "  'Price/Book': 20.2,\n",
       "  'Enterprise Value/Revenue': 20.23,\n",
       "  'Enterprise Value/EBITDA': 57.98},\n",
       " {'Market Cap (intraday)': 281830000000.0,\n",
       "  'Enterprise Value': 278460000000.0,\n",
       "  'Trailing P/E': 54.67,\n",
       "  'Forward P/E': 41.01,\n",
       "  'PEG Ratio (5 yr expected)': 2.46,\n",
       "  'Price/Sales': 12.32,\n",
       "  'Price/Book': 14.49,\n",
       "  'Enterprise Value/Revenue': 12.18,\n",
       "  'Enterprise Value/EBITDA': 56.26},\n",
       " {'Market Cap (intraday)': 568260000000.0,\n",
       "  'Enterprise Value': 565080000000.0,\n",
       "  'Trailing P/E': 591.07,\n",
       "  'Forward P/E': 94.38,\n",
       "  'PEG Ratio (5 yr expected)': 3.66,\n",
       "  'Price/Sales': 15.81,\n",
       "  'Price/Book': 24.68,\n",
       "  'Enterprise Value/Revenue': 15.72,\n",
       "  'Enterprise Value/EBITDA': 124.17}]"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_json('Yahoo_Financials.json')\n",
    "\n",
    "#for idx, company in enumerate(df):\n",
    "    #print(\"{}\".format(df[company]['Valuation Measures']['Trailing P/E']))\n",
    "\n",
    "[df[company]['Valuation Measures'] for company in df]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}