GroupBy.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Intro to the GroupBy Module"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Walmart</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>General Merchandisers</td>\n",
       "      <td>Bentonville, AR</td>\n",
       "      <td>482130</td>\n",
       "      <td>14694</td>\n",
       "      <td>2300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Exxon Mobil</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Irving, TX</td>\n",
       "      <td>246204</td>\n",
       "      <td>16150</td>\n",
       "      <td>75600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computers, Office Equipment</td>\n",
       "      <td>Cupertino, CA</td>\n",
       "      <td>233715</td>\n",
       "      <td>53394</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Company      Sector                     Industry         Location  \\\n",
       "Rank                                                                          \n",
       "1         Walmart   Retailing        General Merchandisers  Bentonville, AR   \n",
       "2     Exxon Mobil      Energy           Petroleum Refining       Irving, TX   \n",
       "3           Apple  Technology  Computers, Office Equipment    Cupertino, CA   \n",
       "\n",
       "      Revenue  Profits  Employees  \n",
       "Rank                               \n",
       "1      482130    14694    2300000  \n",
       "2      246204    16150      75600  \n",
       "3      233715    53394     110000  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fortune = pd.read_csv('Fortune1000.csv', index_col = 'Rank')\n",
    "sectors = fortune.groupby('Sector')\n",
    "fortune.head(3)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "First operations with groupby Object"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "21"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(sectors)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "21"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fortune['Sector'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Sector\n",
       "Aerospace & Defense              20\n",
       "Apparel                          15\n",
       "Business Services                51\n",
       "Chemicals                        30\n",
       "Energy                          122\n",
       "Engineering & Construction       26\n",
       "Financials                      139\n",
       "Food and Drug Stores             15\n",
       "Food, Beverages & Tobacco        43\n",
       "Health Care                      75\n",
       "Hotels, Resturants & Leisure     25\n",
       "Household Products               28\n",
       "Industrials                      46\n",
       "Materials                        43\n",
       "Media                            25\n",
       "Motor Vehicles & Parts           24\n",
       "Retailing                        80\n",
       "Technology                      102\n",
       "Telecommunications               15\n",
       "Transportation                   36\n",
       "Wholesalers                      40\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors.size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sector</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aerospace &amp; Defense</th>\n",
       "      <td>Boeing</td>\n",
       "      <td>Aerospace and Defense</td>\n",
       "      <td>Chicago, IL</td>\n",
       "      <td>96114</td>\n",
       "      <td>5176</td>\n",
       "      <td>161400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Apparel</th>\n",
       "      <td>Nike</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Beaverton, OR</td>\n",
       "      <td>30601</td>\n",
       "      <td>3273</td>\n",
       "      <td>62600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business Services</th>\n",
       "      <td>ManpowerGroup</td>\n",
       "      <td>Temporary Help</td>\n",
       "      <td>Milwaukee, WI</td>\n",
       "      <td>19330</td>\n",
       "      <td>419</td>\n",
       "      <td>27000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chemicals</th>\n",
       "      <td>Dow Chemical</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Midland, MI</td>\n",
       "      <td>48778</td>\n",
       "      <td>7685</td>\n",
       "      <td>49495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Energy</th>\n",
       "      <td>Exxon Mobil</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Irving, TX</td>\n",
       "      <td>246204</td>\n",
       "      <td>16150</td>\n",
       "      <td>75600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Engineering &amp; Construction</th>\n",
       "      <td>Fluor</td>\n",
       "      <td>Engineering, Construction</td>\n",
       "      <td>Irving, TX</td>\n",
       "      <td>18114</td>\n",
       "      <td>413</td>\n",
       "      <td>38758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Financials</th>\n",
       "      <td>Berkshire Hathaway</td>\n",
       "      <td>Insurance: Property and Casualty (Stock)</td>\n",
       "      <td>Omaha, NE</td>\n",
       "      <td>210821</td>\n",
       "      <td>24083</td>\n",
       "      <td>331000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food and Drug Stores</th>\n",
       "      <td>CVS Health</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Woonsocket, RI</td>\n",
       "      <td>153290</td>\n",
       "      <td>5237</td>\n",
       "      <td>199000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food, Beverages &amp; Tobacco</th>\n",
       "      <td>Archer Daniels Midland</td>\n",
       "      <td>Food Production</td>\n",
       "      <td>Chicago, IL</td>\n",
       "      <td>67702</td>\n",
       "      <td>1849</td>\n",
       "      <td>32300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Care</th>\n",
       "      <td>McKesson</td>\n",
       "      <td>Wholesalers: Health Care</td>\n",
       "      <td>San Francisco, CA</td>\n",
       "      <td>181241</td>\n",
       "      <td>1476</td>\n",
       "      <td>70400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hotels, Resturants &amp; Leisure</th>\n",
       "      <td>McDonald’s</td>\n",
       "      <td>Food Services</td>\n",
       "      <td>Oak Brook, IL</td>\n",
       "      <td>25413</td>\n",
       "      <td>4529</td>\n",
       "      <td>420000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Household Products</th>\n",
       "      <td>Procter &amp; Gamble</td>\n",
       "      <td>Household and Personal Products</td>\n",
       "      <td>Cincinnati, OH</td>\n",
       "      <td>78756</td>\n",
       "      <td>7036</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Industrials</th>\n",
       "      <td>General Electric</td>\n",
       "      <td>Industrial Machinery</td>\n",
       "      <td>Fairfield, CT</td>\n",
       "      <td>140389</td>\n",
       "      <td>-6126</td>\n",
       "      <td>333000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Materials</th>\n",
       "      <td>Alcoa</td>\n",
       "      <td>Metals</td>\n",
       "      <td>New York, NY</td>\n",
       "      <td>22534</td>\n",
       "      <td>-322</td>\n",
       "      <td>60000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Media</th>\n",
       "      <td>Disney</td>\n",
       "      <td>Entertainment</td>\n",
       "      <td>Burbank, CA</td>\n",
       "      <td>52465</td>\n",
       "      <td>8382</td>\n",
       "      <td>185000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Motor Vehicles &amp; Parts</th>\n",
       "      <td>General Motors</td>\n",
       "      <td>Motor Vehicles and Parts</td>\n",
       "      <td>Detroit, MI</td>\n",
       "      <td>152356</td>\n",
       "      <td>9687</td>\n",
       "      <td>215000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Retailing</th>\n",
       "      <td>Walmart</td>\n",
       "      <td>General Merchandisers</td>\n",
       "      <td>Bentonville, AR</td>\n",
       "      <td>482130</td>\n",
       "      <td>14694</td>\n",
       "      <td>2300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technology</th>\n",
       "      <td>Apple</td>\n",
       "      <td>Computers, Office Equipment</td>\n",
       "      <td>Cupertino, CA</td>\n",
       "      <td>233715</td>\n",
       "      <td>53394</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Telecommunications</th>\n",
       "      <td>AT&amp;T</td>\n",
       "      <td>Telecommunications</td>\n",
       "      <td>Dallas, TX</td>\n",
       "      <td>146801</td>\n",
       "      <td>13345</td>\n",
       "      <td>281450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Transportation</th>\n",
       "      <td>UPS</td>\n",
       "      <td>Mail, Package, and Freight Delivery</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>58363</td>\n",
       "      <td>4844</td>\n",
       "      <td>341240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wholesalers</th>\n",
       "      <td>Sysco</td>\n",
       "      <td>Wholesalers: Food and Grocery</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>48681</td>\n",
       "      <td>687</td>\n",
       "      <td>51700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Company  \\\n",
       "Sector                                                 \n",
       "Aerospace & Defense                           Boeing   \n",
       "Apparel                                         Nike   \n",
       "Business Services                      ManpowerGroup   \n",
       "Chemicals                               Dow Chemical   \n",
       "Energy                                   Exxon Mobil   \n",
       "Engineering & Construction                     Fluor   \n",
       "Financials                        Berkshire Hathaway   \n",
       "Food and Drug Stores                      CVS Health   \n",
       "Food, Beverages & Tobacco     Archer Daniels Midland   \n",
       "Health Care                                 McKesson   \n",
       "Hotels, Resturants & Leisure              McDonald’s   \n",
       "Household Products                  Procter & Gamble   \n",
       "Industrials                         General Electric   \n",
       "Materials                                      Alcoa   \n",
       "Media                                         Disney   \n",
       "Motor Vehicles & Parts                General Motors   \n",
       "Retailing                                    Walmart   \n",
       "Technology                                     Apple   \n",
       "Telecommunications                              AT&T   \n",
       "Transportation                                   UPS   \n",
       "Wholesalers                                    Sysco   \n",
       "\n",
       "                                                              Industry  \\\n",
       "Sector                                                                   \n",
       "Aerospace & Defense                              Aerospace and Defense   \n",
       "Apparel                                                        Apparel   \n",
       "Business Services                                       Temporary Help   \n",
       "Chemicals                                                    Chemicals   \n",
       "Energy                                              Petroleum Refining   \n",
       "Engineering & Construction                   Engineering, Construction   \n",
       "Financials                    Insurance: Property and Casualty (Stock)   \n",
       "Food and Drug Stores                              Food and Drug Stores   \n",
       "Food, Beverages & Tobacco                              Food Production   \n",
       "Health Care                                   Wholesalers: Health Care   \n",
       "Hotels, Resturants & Leisure                             Food Services   \n",
       "Household Products                     Household and Personal Products   \n",
       "Industrials                                       Industrial Machinery   \n",
       "Materials                                                       Metals   \n",
       "Media                                                    Entertainment   \n",
       "Motor Vehicles & Parts                        Motor Vehicles and Parts   \n",
       "Retailing                                        General Merchandisers   \n",
       "Technology                                 Computers, Office Equipment   \n",
       "Telecommunications                                  Telecommunications   \n",
       "Transportation                     Mail, Package, and Freight Delivery   \n",
       "Wholesalers                              Wholesalers: Food and Grocery   \n",
       "\n",
       "                                       Location  Revenue  Profits  Employees  \n",
       "Sector                                                                        \n",
       "Aerospace & Defense                 Chicago, IL    96114     5176     161400  \n",
       "Apparel                           Beaverton, OR    30601     3273      62600  \n",
       "Business Services                 Milwaukee, WI    19330      419      27000  \n",
       "Chemicals                           Midland, MI    48778     7685      49495  \n",
       "Energy                               Irving, TX   246204    16150      75600  \n",
       "Engineering & Construction           Irving, TX    18114      413      38758  \n",
       "Financials                            Omaha, NE   210821    24083     331000  \n",
       "Food and Drug Stores             Woonsocket, RI   153290     5237     199000  \n",
       "Food, Beverages & Tobacco           Chicago, IL    67702     1849      32300  \n",
       "Health Care                   San Francisco, CA   181241     1476      70400  \n",
       "Hotels, Resturants & Leisure      Oak Brook, IL    25413     4529     420000  \n",
       "Household Products               Cincinnati, OH    78756     7036     110000  \n",
       "Industrials                       Fairfield, CT   140389    -6126     333000  \n",
       "Materials                          New York, NY    22534     -322      60000  \n",
       "Media                               Burbank, CA    52465     8382     185000  \n",
       "Motor Vehicles & Parts              Detroit, MI   152356     9687     215000  \n",
       "Retailing                       Bentonville, AR   482130    14694    2300000  \n",
       "Technology                        Cupertino, CA   233715    53394     110000  \n",
       "Telecommunications                   Dallas, TX   146801    13345     281450  \n",
       "Transportation                      Atlanta, GA    58363     4844     341240  \n",
       "Wholesalers                         Houston, TX    48681      687      51700  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors.first()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sector</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aerospace &amp; Defense</th>\n",
       "      <td>Delta Tucker Holdings</td>\n",
       "      <td>Aerospace and Defense</td>\n",
       "      <td>McLean, VA</td>\n",
       "      <td>1923</td>\n",
       "      <td>-133</td>\n",
       "      <td>12000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Apparel</th>\n",
       "      <td>Guess</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Los Angeles, CA</td>\n",
       "      <td>2204</td>\n",
       "      <td>82</td>\n",
       "      <td>13500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business Services</th>\n",
       "      <td>DeVry Education Group</td>\n",
       "      <td>Education</td>\n",
       "      <td>Downers Grove, IL</td>\n",
       "      <td>1910</td>\n",
       "      <td>140</td>\n",
       "      <td>11770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chemicals</th>\n",
       "      <td>H.B. Fuller</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>St. Paul, MN</td>\n",
       "      <td>2084</td>\n",
       "      <td>87</td>\n",
       "      <td>4425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Energy</th>\n",
       "      <td>Portland General Electric</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Portland, OR</td>\n",
       "      <td>1898</td>\n",
       "      <td>172</td>\n",
       "      <td>2646</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Engineering &amp; Construction</th>\n",
       "      <td>MDC Holdings</td>\n",
       "      <td>Homebuilders</td>\n",
       "      <td>Denver, CO</td>\n",
       "      <td>1909</td>\n",
       "      <td>66</td>\n",
       "      <td>1225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Financials</th>\n",
       "      <td>New York Community Bancorp</td>\n",
       "      <td>Commercial Banks</td>\n",
       "      <td>Westbury, NY</td>\n",
       "      <td>1902</td>\n",
       "      <td>-47</td>\n",
       "      <td>3448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food and Drug Stores</th>\n",
       "      <td>Fred’s</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Memphis, TN</td>\n",
       "      <td>2151</td>\n",
       "      <td>-7</td>\n",
       "      <td>7103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food, Beverages &amp; Tobacco</th>\n",
       "      <td>Alliance One International</td>\n",
       "      <td>Tobacco</td>\n",
       "      <td>Morrisville, NC</td>\n",
       "      <td>2066</td>\n",
       "      <td>-15</td>\n",
       "      <td>6835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Care</th>\n",
       "      <td>Providence Service</td>\n",
       "      <td>Health Care: Pharmacy and Other Services</td>\n",
       "      <td>Tucson, AZ</td>\n",
       "      <td>1987</td>\n",
       "      <td>84</td>\n",
       "      <td>9072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hotels, Resturants &amp; Leisure</th>\n",
       "      <td>Wendy’s</td>\n",
       "      <td>Food Services</td>\n",
       "      <td>Dublin, OH</td>\n",
       "      <td>1896</td>\n",
       "      <td>161</td>\n",
       "      <td>21200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Household Products</th>\n",
       "      <td>Revlon</td>\n",
       "      <td>Household and Personal Products</td>\n",
       "      <td>New York, NY</td>\n",
       "      <td>1914</td>\n",
       "      <td>56</td>\n",
       "      <td>5700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Industrials</th>\n",
       "      <td>Briggs &amp; Stratton</td>\n",
       "      <td>Industrial Machinery</td>\n",
       "      <td>Wauwatosa, WI</td>\n",
       "      <td>1895</td>\n",
       "      <td>46</td>\n",
       "      <td>5480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Materials</th>\n",
       "      <td>Schnitzer Steel Industries</td>\n",
       "      <td>Metals</td>\n",
       "      <td>Portland, OR</td>\n",
       "      <td>1924</td>\n",
       "      <td>-197</td>\n",
       "      <td>2955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Media</th>\n",
       "      <td>Cenveo</td>\n",
       "      <td>Publishing, Printing</td>\n",
       "      <td>Stamford, CT</td>\n",
       "      <td>1921</td>\n",
       "      <td>-31</td>\n",
       "      <td>7300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Motor Vehicles &amp; Parts</th>\n",
       "      <td>Allison Transmission Holdings</td>\n",
       "      <td>Motor Vehicles and Parts</td>\n",
       "      <td>Indianaoplis, IN</td>\n",
       "      <td>1986</td>\n",
       "      <td>182</td>\n",
       "      <td>2700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Retailing</th>\n",
       "      <td>99 Cents Only Stores</td>\n",
       "      <td>Specialty Retailers: Other</td>\n",
       "      <td>Commerce, CA</td>\n",
       "      <td>1999</td>\n",
       "      <td>-232</td>\n",
       "      <td>18200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technology</th>\n",
       "      <td>F5 Networks</td>\n",
       "      <td>Network and Other Communications Equipment</td>\n",
       "      <td>Seattle, WA</td>\n",
       "      <td>1920</td>\n",
       "      <td>365</td>\n",
       "      <td>4178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Telecommunications</th>\n",
       "      <td>Equinix</td>\n",
       "      <td>Telecommunications</td>\n",
       "      <td>Redwood City, CA</td>\n",
       "      <td>2726</td>\n",
       "      <td>188</td>\n",
       "      <td>5042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Transportation</th>\n",
       "      <td>Roadrunner Transportation Systems</td>\n",
       "      <td>Transportation and Logistics</td>\n",
       "      <td>Cudahy, WI</td>\n",
       "      <td>1995</td>\n",
       "      <td>48</td>\n",
       "      <td>4502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wholesalers</th>\n",
       "      <td>BlueLinx Holdings</td>\n",
       "      <td>Wholesalers: Diversified</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>1917</td>\n",
       "      <td>-12</td>\n",
       "      <td>1600</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                        Company  \\\n",
       "Sector                                                            \n",
       "Aerospace & Defense                       Delta Tucker Holdings   \n",
       "Apparel                                                   Guess   \n",
       "Business Services                         DeVry Education Group   \n",
       "Chemicals                                           H.B. Fuller   \n",
       "Energy                                Portland General Electric   \n",
       "Engineering & Construction                         MDC Holdings   \n",
       "Financials                           New York Community Bancorp   \n",
       "Food and Drug Stores                                     Fred’s   \n",
       "Food, Beverages & Tobacco            Alliance One International   \n",
       "Health Care                                  Providence Service   \n",
       "Hotels, Resturants & Leisure                            Wendy’s   \n",
       "Household Products                                       Revlon   \n",
       "Industrials                                   Briggs & Stratton   \n",
       "Materials                            Schnitzer Steel Industries   \n",
       "Media                                                    Cenveo   \n",
       "Motor Vehicles & Parts            Allison Transmission Holdings   \n",
       "Retailing                                  99 Cents Only Stores   \n",
       "Technology                                          F5 Networks   \n",
       "Telecommunications                                      Equinix   \n",
       "Transportation                Roadrunner Transportation Systems   \n",
       "Wholesalers                                   BlueLinx Holdings   \n",
       "\n",
       "                                                                Industry  \\\n",
       "Sector                                                                     \n",
       "Aerospace & Defense                                Aerospace and Defense   \n",
       "Apparel                                                          Apparel   \n",
       "Business Services                                              Education   \n",
       "Chemicals                                                      Chemicals   \n",
       "Energy                                       Utilities: Gas and Electric   \n",
       "Engineering & Construction                                  Homebuilders   \n",
       "Financials                                              Commercial Banks   \n",
       "Food and Drug Stores                                Food and Drug Stores   \n",
       "Food, Beverages & Tobacco                                        Tobacco   \n",
       "Health Care                     Health Care: Pharmacy and Other Services   \n",
       "Hotels, Resturants & Leisure                               Food Services   \n",
       "Household Products                       Household and Personal Products   \n",
       "Industrials                                         Industrial Machinery   \n",
       "Materials                                                         Metals   \n",
       "Media                                               Publishing, Printing   \n",
       "Motor Vehicles & Parts                          Motor Vehicles and Parts   \n",
       "Retailing                                     Specialty Retailers: Other   \n",
       "Technology                    Network and Other Communications Equipment   \n",
       "Telecommunications                                    Telecommunications   \n",
       "Transportation                              Transportation and Logistics   \n",
       "Wholesalers                                     Wholesalers: Diversified   \n",
       "\n",
       "                                       Location  Revenue  Profits  Employees  \n",
       "Sector                                                                        \n",
       "Aerospace & Defense                  McLean, VA     1923     -133      12000  \n",
       "Apparel                         Los Angeles, CA     2204       82      13500  \n",
       "Business Services             Downers Grove, IL     1910      140      11770  \n",
       "Chemicals                          St. Paul, MN     2084       87       4425  \n",
       "Energy                             Portland, OR     1898      172       2646  \n",
       "Engineering & Construction           Denver, CO     1909       66       1225  \n",
       "Financials                         Westbury, NY     1902      -47       3448  \n",
       "Food and Drug Stores                Memphis, TN     2151       -7       7103  \n",
       "Food, Beverages & Tobacco       Morrisville, NC     2066      -15       6835  \n",
       "Health Care                          Tucson, AZ     1987       84       9072  \n",
       "Hotels, Resturants & Leisure         Dublin, OH     1896      161      21200  \n",
       "Household Products                 New York, NY     1914       56       5700  \n",
       "Industrials                       Wauwatosa, WI     1895       46       5480  \n",
       "Materials                          Portland, OR     1924     -197       2955  \n",
       "Media                              Stamford, CT     1921      -31       7300  \n",
       "Motor Vehicles & Parts         Indianaoplis, IN     1986      182       2700  \n",
       "Retailing                          Commerce, CA     1999     -232      18200  \n",
       "Technology                          Seattle, WA     1920      365       4178  \n",
       "Telecommunications             Redwood City, CA     2726      188       5042  \n",
       "Transportation                       Cudahy, WI     1995       48       4502  \n",
       "Wholesalers                         Atlanta, GA     1917      -12       1600  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors.last()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Aerospace & Defense': Int64Index([ 24,  45,  60,  88, 118, 120, 209, 245, 282, 378, 389, 490, 560,\n",
       "             605, 785, 788, 836, 903, 958, 987],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Apparel': Int64Index([91, 231, 340, 354, 448, 547, 575, 597, 683, 695, 726, 794, 877,\n",
       "             882, 917],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Business Services': Int64Index([144, 186, 199, 204, 221, 248, 249, 294, 307, 312, 355, 392, 404,\n",
       "             440, 467, 468, 481, 485, 492, 503, 545, 626, 635, 652, 677, 694,\n",
       "             714, 729, 734, 735, 737, 744, 767, 776, 777, 783, 791, 792, 796,\n",
       "             801, 803, 816, 819, 820, 869, 870, 886, 939, 951, 952, 993],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Chemicals': Int64Index([ 56, 101, 182, 189, 206, 253, 262, 277, 288, 296, 316, 538, 549,\n",
       "             555, 566, 580, 613, 624, 654, 668, 717, 720, 724, 758, 761, 829,\n",
       "             865, 898, 934, 949],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Energy': Int64Index([  2,  14,  30,  32,  42,  65,  90,  95,  98, 104,\n",
       "             ...\n",
       "             953, 955, 962, 966, 980, 981, 983, 995, 997, 997],\n",
       "            dtype='int64', name='Rank', length=122),\n",
       " 'Engineering & Construction': Int64Index([155, 156, 235, 260, 301, 314, 352, 381, 433, 478, 498, 501, 516,\n",
       "             572, 576, 640, 719, 738, 822, 863, 874, 892, 929, 963, 985, 994],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Financials': Int64Index([  4,  16,  23,  26,  27,  29,  35,  40,  43,  49,\n",
       "             ...\n",
       "             920, 923, 925, 926, 936, 938, 959, 976, 988, 996],\n",
       "            dtype='int64', name='Rank', length=139),\n",
       " 'Food and Drug Stores': Int64Index([7, 17, 19, 87, 107, 160, 181, 595, 614, 631, 669, 756, 809, 849,\n",
       "             928],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Food, Beverages & Tobacco': Int64Index([ 41,  44,  62,  66,  84,  94, 106, 149, 153, 161, 176, 207, 215,\n",
       "             242, 266, 304, 336, 337, 362, 397, 413, 429, 452, 456, 460, 535,\n",
       "             542, 567, 574, 587, 608, 615, 636, 664, 686, 702, 770, 787, 795,\n",
       "             804, 889, 902, 954],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Health Care': Int64Index([  5,   6,  12,  21,  22,  33,  39,  46,  52,  55,  63,  72,  79,\n",
       "              86, 123, 124, 125, 130, 138, 140, 141, 168, 172, 200, 201, 202,\n",
       "             263, 268, 278, 286, 287, 290, 291, 305, 325, 358, 359, 372, 420,\n",
       "             430, 431, 447, 457, 465, 469, 515, 527, 537, 553, 559, 583, 618,\n",
       "             629, 661, 684, 693, 697, 708, 746, 749, 766, 775, 790, 799, 815,\n",
       "             818, 845, 868, 881, 883, 935, 960, 965, 977, 978],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Hotels, Resturants & Leisure': Int64Index([109, 146, 195, 218, 241, 254, 309, 371, 444, 466, 534, 546, 557,\n",
       "             562, 585, 731, 763, 764, 779, 797, 895, 915, 918, 941, 999],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Household Products': Int64Index([ 34, 151, 174, 256, 261, 328, 338, 345, 370, 434, 441, 450, 455,\n",
       "             533, 550, 554, 601, 665, 699, 716, 856, 890, 900, 907, 932, 950,\n",
       "             967, 992],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Industrials': Int64Index([  11,   59,   75,   93,   97,  128,  134,  148,  211,  224,  360,\n",
       "              377,  396,  412,  419,  539,  544,  596,  622,  623,  630,  645,\n",
       "              655,  658,  666,  674,  690,  757,  782,  789,  806,  813,  823,\n",
       "              831,  832,  835,  841,  847,  866,  867,  873,  887,  942,  947,\n",
       "              964, 1000],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Materials': Int64Index([126, 127, 170, 244, 251, 303, 321, 341, 356, 373, 375, 383, 417,\n",
       "             418, 426, 435, 446, 480, 489, 514, 518, 577, 586, 616, 617, 620,\n",
       "             625, 628, 637, 639, 641, 660, 667, 687, 691, 751, 774, 793, 857,\n",
       "             885, 911, 982, 986],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Media': Int64Index([ 53,  96,  99, 203, 213, 255, 327, 366, 406, 414, 525, 530, 681,\n",
       "             705, 707, 722, 741, 752, 759, 762, 821, 913, 968, 969, 989],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Motor Vehicles & Parts': Int64Index([  8,   9,  70, 147, 154, 169, 281, 310, 334, 339, 424, 428, 470,\n",
       "             588, 591, 604, 647, 670, 718, 739, 811, 957, 961, 979],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Retailing': Int64Index([  1,  15,  28,  38,  47,  71,  89, 103, 111, 132, 136, 139, 143,\n",
       "             145, 177, 180, 191, 196, 197, 228, 234, 237, 238, 240, 258, 267,\n",
       "             269, 280, 293, 297, 299, 302, 330, 342, 346, 361, 365, 374, 379,\n",
       "             380, 393, 415, 427, 439, 495, 500, 502, 511, 512, 517, 523, 582,\n",
       "             592, 602, 607, 610, 621, 643, 644, 648, 657, 675, 689, 721, 748,\n",
       "             771, 773, 807, 812, 824, 825, 827, 840, 876, 894, 899, 922, 937,\n",
       "             940, 973],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Technology': Int64Index([  3,  18,  20,  25,  31,  36,  51,  54,  77, 110,\n",
       "             ...\n",
       "             931, 943, 944, 946, 956, 970, 971, 975, 984, 990],\n",
       "            dtype='int64', name='Rank', length=102),\n",
       " 'Telecommunications': Int64Index([10, 13, 37, 116, 159, 187, 292, 333, 399, 443, 461, 496, 526, 619,\n",
       "             786],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Transportation': Int64Index([ 48,  58,  67,  68,  80, 129, 142, 208, 239, 270, 353, 390, 395,\n",
       "             405, 407, 416, 432, 459, 521, 528, 570, 578, 642, 672, 709, 713,\n",
       "             740, 800, 814, 858, 884, 930, 933, 945, 972, 974],\n",
       "            dtype='int64', name='Rank'),\n",
       " 'Wholesalers': Int64Index([ 57,  64,  92, 102, 108, 119, 122, 167, 183, 185, 212, 276, 285,\n",
       "             315, 317, 320, 323, 335, 351, 357, 369, 391, 423, 463, 474, 477,\n",
       "             484, 564, 581, 599, 627, 653, 685, 727, 747, 780, 808, 837, 875,\n",
       "             991],\n",
       "            dtype='int64', name='Rank')}"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors.groups"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Retreive a Group with the .get_group() Method"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Walmart</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>General Merchandisers</td>\n",
       "      <td>Bentonville, AR</td>\n",
       "      <td>482130</td>\n",
       "      <td>14694</td>\n",
       "      <td>2300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Exxon Mobil</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Irving, TX</td>\n",
       "      <td>246204</td>\n",
       "      <td>16150</td>\n",
       "      <td>75600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computers, Office Equipment</td>\n",
       "      <td>Cupertino, CA</td>\n",
       "      <td>233715</td>\n",
       "      <td>53394</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Company      Sector                     Industry         Location  \\\n",
       "Rank                                                                          \n",
       "1         Walmart   Retailing        General Merchandisers  Bentonville, AR   \n",
       "2     Exxon Mobil      Energy           Petroleum Refining       Irving, TX   \n",
       "3           Apple  Technology  Computers, Office Equipment    Cupertino, CA   \n",
       "\n",
       "      Revenue  Profits  Employees  \n",
       "Rank                               \n",
       "1      482130    14694    2300000  \n",
       "2      246204    16150      75600  \n",
       "3      233715    53394     110000  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fortune = pd.read_csv('Fortune1000.csv', index_col = 'Rank')\n",
    "sectors = fortune.groupby('Sector')\n",
    "fortune.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Exxon Mobil</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Irving, TX</td>\n",
       "      <td>246204</td>\n",
       "      <td>16150</td>\n",
       "      <td>75600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Chevron</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>San Ramon, CA</td>\n",
       "      <td>131118</td>\n",
       "      <td>4587</td>\n",
       "      <td>61500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Phillips 66</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>87169</td>\n",
       "      <td>4227</td>\n",
       "      <td>14000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Valero Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>San Antonio, TX</td>\n",
       "      <td>81824</td>\n",
       "      <td>3990</td>\n",
       "      <td>10103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Marathon Petroleum</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Findlay, OH</td>\n",
       "      <td>64566</td>\n",
       "      <td>2852</td>\n",
       "      <td>45440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Energy Transfer Equity</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Pipelines</td>\n",
       "      <td>Dallas, TX</td>\n",
       "      <td>42126</td>\n",
       "      <td>1189</td>\n",
       "      <td>30078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>ConocoPhillips</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>30935</td>\n",
       "      <td>-4428</td>\n",
       "      <td>15900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Exelon</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Chicago, IL</td>\n",
       "      <td>29447</td>\n",
       "      <td>2269</td>\n",
       "      <td>29762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Tesoro</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>San Antonio, TX</td>\n",
       "      <td>28150</td>\n",
       "      <td>1540</td>\n",
       "      <td>6016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Enterprise Products Partners</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Pipelines</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>27028</td>\n",
       "      <td>2521</td>\n",
       "      <td>6800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>Duke Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Charlotte, NC</td>\n",
       "      <td>24002</td>\n",
       "      <td>2816</td>\n",
       "      <td>29188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>Halliburton</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Oil and Gas Equipment, Services</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>23633</td>\n",
       "      <td>-671</td>\n",
       "      <td>65000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Plains GP Holdings</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Pipelines</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>23152</td>\n",
       "      <td>118</td>\n",
       "      <td>5400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>Southern</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>17489</td>\n",
       "      <td>2367</td>\n",
       "      <td>26703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>NextEra Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Juno Beach, FL</td>\n",
       "      <td>17486</td>\n",
       "      <td>2752</td>\n",
       "      <td>14300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>American Electric Power</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Columbus, OH</td>\n",
       "      <td>16900</td>\n",
       "      <td>2047</td>\n",
       "      <td>17405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>PG&amp;E Corp.</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>San Francisco, CA</td>\n",
       "      <td>16833</td>\n",
       "      <td>874</td>\n",
       "      <td>23323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>Freeport-McMoRan</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Phoenix, AZ</td>\n",
       "      <td>15877</td>\n",
       "      <td>-12236</td>\n",
       "      <td>34500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>Baker Hughes</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Oil and Gas Equipment, Services</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>15742</td>\n",
       "      <td>-1967</td>\n",
       "      <td>43000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>FirstEnergy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Akron, OH</td>\n",
       "      <td>15026</td>\n",
       "      <td>578</td>\n",
       "      <td>15781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>AES</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>14963</td>\n",
       "      <td>306</td>\n",
       "      <td>21000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>National Oilwell Varco</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Oil and Gas Equipment, Services</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>14757</td>\n",
       "      <td>-769</td>\n",
       "      <td>47262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>NRG Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Princeton, NJ</td>\n",
       "      <td>14674</td>\n",
       "      <td>-6382</td>\n",
       "      <td>10468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>Kinder Morgan</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Pipelines</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>14403</td>\n",
       "      <td>253</td>\n",
       "      <td>11290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>HollyFrontier</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Dallas, TX</td>\n",
       "      <td>13238</td>\n",
       "      <td>740</td>\n",
       "      <td>2704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>Devon Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Oklahoma City, OK</td>\n",
       "      <td>13145</td>\n",
       "      <td>-14454</td>\n",
       "      <td>5167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>PBF Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Parsippany, NJ</td>\n",
       "      <td>13124</td>\n",
       "      <td>146</td>\n",
       "      <td>2270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>Chesapeake Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Oklahoma City, OK</td>\n",
       "      <td>12764</td>\n",
       "      <td>-14685</td>\n",
       "      <td>4400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>Occidental Petroleum</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>12699</td>\n",
       "      <td>-7829</td>\n",
       "      <td>11100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>Consolidated Edison</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>New York, NY</td>\n",
       "      <td>12554</td>\n",
       "      <td>1193</td>\n",
       "      <td>14806</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>784</th>\n",
       "      <td>New Jersey Resources</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Wall, NJ</td>\n",
       "      <td>2734</td>\n",
       "      <td>181</td>\n",
       "      <td>991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>798</th>\n",
       "      <td>Continental Resources</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Oklahoma City, OK</td>\n",
       "      <td>2680</td>\n",
       "      <td>-354</td>\n",
       "      <td>1143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>802</th>\n",
       "      <td>WGL Holdings</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Washington, DC</td>\n",
       "      <td>2660</td>\n",
       "      <td>131</td>\n",
       "      <td>1529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>Crestwood Equity Partners</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>2633</td>\n",
       "      <td>-1667</td>\n",
       "      <td>1300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>817</th>\n",
       "      <td>Hawaiian Electric Industries</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Honolulu, HI</td>\n",
       "      <td>2603</td>\n",
       "      <td>160</td>\n",
       "      <td>3918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>826</th>\n",
       "      <td>Arch Coal</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>St. Louis, MO</td>\n",
       "      <td>2573</td>\n",
       "      <td>-2913</td>\n",
       "      <td>4655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>843</th>\n",
       "      <td>Great Plains Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Kansas City, MO</td>\n",
       "      <td>2502</td>\n",
       "      <td>213</td>\n",
       "      <td>2899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>United Refining</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Warren, PA</td>\n",
       "      <td>2470</td>\n",
       "      <td>82</td>\n",
       "      <td>2997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>851</th>\n",
       "      <td>Southwest Gas</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Las Vegas, NV</td>\n",
       "      <td>2464</td>\n",
       "      <td>138</td>\n",
       "      <td>5876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>853</th>\n",
       "      <td>Westar Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Topeka, KS</td>\n",
       "      <td>2459</td>\n",
       "      <td>292</td>\n",
       "      <td>2330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>855</th>\n",
       "      <td>Vectren</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Evansville, IN</td>\n",
       "      <td>2435</td>\n",
       "      <td>197</td>\n",
       "      <td>5600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>859</th>\n",
       "      <td>Enable Midstream Partners</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Pipelines</td>\n",
       "      <td>Oklahoma City, OK</td>\n",
       "      <td>2418</td>\n",
       "      <td>-752</td>\n",
       "      <td>1640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>860</th>\n",
       "      <td>Cliffs Natural Resources</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Cleveland, OH</td>\n",
       "      <td>2418</td>\n",
       "      <td>-749</td>\n",
       "      <td>2638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>862</th>\n",
       "      <td>California Resources</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Los Angeles, CA</td>\n",
       "      <td>2403</td>\n",
       "      <td>-3554</td>\n",
       "      <td>1700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>879</th>\n",
       "      <td>EQT</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Pittsburgh, PA</td>\n",
       "      <td>2340</td>\n",
       "      <td>85</td>\n",
       "      <td>1914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>901</th>\n",
       "      <td>Alliance Holdings</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Tulsa, OK</td>\n",
       "      <td>2273</td>\n",
       "      <td>211</td>\n",
       "      <td>4243</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>Genesis Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Pipelines</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>2247</td>\n",
       "      <td>423</td>\n",
       "      <td>1400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>921</th>\n",
       "      <td>OGE Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Oklahoma City, OK</td>\n",
       "      <td>2197</td>\n",
       "      <td>271</td>\n",
       "      <td>2586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>Magellan Midstream Partners</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Pipelines</td>\n",
       "      <td>Tulsa, OK</td>\n",
       "      <td>2189</td>\n",
       "      <td>819</td>\n",
       "      <td>1640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>948</th>\n",
       "      <td>NuStar Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Pipelines</td>\n",
       "      <td>San Antonio, TX</td>\n",
       "      <td>2084</td>\n",
       "      <td>307</td>\n",
       "      <td>1644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>953</th>\n",
       "      <td>Par Pacific Holdings</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>2066</td>\n",
       "      <td>-40</td>\n",
       "      <td>744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>955</th>\n",
       "      <td>Whiting Petroleum</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Denver, CO</td>\n",
       "      <td>2051</td>\n",
       "      <td>-2219</td>\n",
       "      <td>1200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>962</th>\n",
       "      <td>Ferrellgas Partners</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Overland Park, KS</td>\n",
       "      <td>2024</td>\n",
       "      <td>30</td>\n",
       "      <td>4028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>966</th>\n",
       "      <td>QEP Resources</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Denver, CO</td>\n",
       "      <td>2019</td>\n",
       "      <td>-149</td>\n",
       "      <td>693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>Spire</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>St. Louis, MO</td>\n",
       "      <td>1976</td>\n",
       "      <td>137</td>\n",
       "      <td>3078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>WPX Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Tulsa, OK</td>\n",
       "      <td>1958</td>\n",
       "      <td>-1727</td>\n",
       "      <td>1040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>Adams Resources &amp; Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>1944</td>\n",
       "      <td>-1</td>\n",
       "      <td>809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>EP Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Mining, Crude-Oil Production</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>1908</td>\n",
       "      <td>-3748</td>\n",
       "      <td>665</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Portland General Electric</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Portland, OR</td>\n",
       "      <td>1898</td>\n",
       "      <td>172</td>\n",
       "      <td>2646</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Portland General Electric</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Portland, OR</td>\n",
       "      <td>1898</td>\n",
       "      <td>172</td>\n",
       "      <td>2646</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>122 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Company  Sector                         Industry  \\\n",
       "Rank                                                                          \n",
       "2                      Exxon Mobil  Energy               Petroleum Refining   \n",
       "14                         Chevron  Energy               Petroleum Refining   \n",
       "30                     Phillips 66  Energy               Petroleum Refining   \n",
       "32                   Valero Energy  Energy               Petroleum Refining   \n",
       "42              Marathon Petroleum  Energy               Petroleum Refining   \n",
       "65          Energy Transfer Equity  Energy                        Pipelines   \n",
       "90                  ConocoPhillips  Energy     Mining, Crude-Oil Production   \n",
       "95                          Exelon  Energy      Utilities: Gas and Electric   \n",
       "98                          Tesoro  Energy               Petroleum Refining   \n",
       "104   Enterprise Products Partners  Energy                        Pipelines   \n",
       "115                    Duke Energy  Energy      Utilities: Gas and Electric   \n",
       "117                    Halliburton  Energy  Oil and Gas Equipment, Services   \n",
       "121             Plains GP Holdings  Energy                        Pipelines   \n",
       "162                       Southern  Energy      Utilities: Gas and Electric   \n",
       "163                 NextEra Energy  Energy      Utilities: Gas and Electric   \n",
       "165        American Electric Power  Energy      Utilities: Gas and Electric   \n",
       "166                     PG&E Corp.  Energy      Utilities: Gas and Electric   \n",
       "175               Freeport-McMoRan  Energy     Mining, Crude-Oil Production   \n",
       "178                   Baker Hughes  Energy  Oil and Gas Equipment, Services   \n",
       "188                    FirstEnergy  Energy      Utilities: Gas and Electric   \n",
       "190                            AES  Energy      Utilities: Gas and Electric   \n",
       "192         National Oilwell Varco  Energy  Oil and Gas Equipment, Services   \n",
       "193                     NRG Energy  Energy                           Energy   \n",
       "198                  Kinder Morgan  Energy                        Pipelines   \n",
       "214                  HollyFrontier  Energy               Petroleum Refining   \n",
       "216                   Devon Energy  Energy     Mining, Crude-Oil Production   \n",
       "217                     PBF Energy  Energy               Petroleum Refining   \n",
       "223              Chesapeake Energy  Energy     Mining, Crude-Oil Production   \n",
       "225           Occidental Petroleum  Energy     Mining, Crude-Oil Production   \n",
       "229            Consolidated Edison  Energy      Utilities: Gas and Electric   \n",
       "...                            ...     ...                              ...   \n",
       "784           New Jersey Resources  Energy                           Energy   \n",
       "798          Continental Resources  Energy     Mining, Crude-Oil Production   \n",
       "802                   WGL Holdings  Energy                           Energy   \n",
       "810      Crestwood Equity Partners  Energy                           Energy   \n",
       "817   Hawaiian Electric Industries  Energy      Utilities: Gas and Electric   \n",
       "826                      Arch Coal  Energy     Mining, Crude-Oil Production   \n",
       "843            Great Plains Energy  Energy      Utilities: Gas and Electric   \n",
       "850                United Refining  Energy               Petroleum Refining   \n",
       "851                  Southwest Gas  Energy      Utilities: Gas and Electric   \n",
       "853                  Westar Energy  Energy      Utilities: Gas and Electric   \n",
       "855                        Vectren  Energy      Utilities: Gas and Electric   \n",
       "859      Enable Midstream Partners  Energy                        Pipelines   \n",
       "860       Cliffs Natural Resources  Energy     Mining, Crude-Oil Production   \n",
       "862           California Resources  Energy     Mining, Crude-Oil Production   \n",
       "879                            EQT  Energy                           Energy   \n",
       "901              Alliance Holdings  Energy     Mining, Crude-Oil Production   \n",
       "908                 Genesis Energy  Energy                        Pipelines   \n",
       "921                     OGE Energy  Energy      Utilities: Gas and Electric   \n",
       "924    Magellan Midstream Partners  Energy                        Pipelines   \n",
       "948                  NuStar Energy  Energy                        Pipelines   \n",
       "953           Par Pacific Holdings  Energy               Petroleum Refining   \n",
       "955              Whiting Petroleum  Energy     Mining, Crude-Oil Production   \n",
       "962            Ferrellgas Partners  Energy                           Energy   \n",
       "966                  QEP Resources  Energy     Mining, Crude-Oil Production   \n",
       "980                          Spire  Energy      Utilities: Gas and Electric   \n",
       "981                     WPX Energy  Energy     Mining, Crude-Oil Production   \n",
       "983       Adams Resources & Energy  Energy               Petroleum Refining   \n",
       "995                      EP Energy  Energy     Mining, Crude-Oil Production   \n",
       "997      Portland General Electric  Energy      Utilities: Gas and Electric   \n",
       "997      Portland General Electric  Energy      Utilities: Gas and Electric   \n",
       "\n",
       "               Location  Revenue  Profits  Employees  \n",
       "Rank                                                  \n",
       "2            Irving, TX   246204    16150      75600  \n",
       "14        San Ramon, CA   131118     4587      61500  \n",
       "30          Houston, TX    87169     4227      14000  \n",
       "32      San Antonio, TX    81824     3990      10103  \n",
       "42          Findlay, OH    64566     2852      45440  \n",
       "65           Dallas, TX    42126     1189      30078  \n",
       "90          Houston, TX    30935    -4428      15900  \n",
       "95          Chicago, IL    29447     2269      29762  \n",
       "98      San Antonio, TX    28150     1540       6016  \n",
       "104         Houston, TX    27028     2521       6800  \n",
       "115       Charlotte, NC    24002     2816      29188  \n",
       "117         Houston, TX    23633     -671      65000  \n",
       "121         Houston, TX    23152      118       5400  \n",
       "162         Atlanta, GA    17489     2367      26703  \n",
       "163      Juno Beach, FL    17486     2752      14300  \n",
       "165        Columbus, OH    16900     2047      17405  \n",
       "166   San Francisco, CA    16833      874      23323  \n",
       "175         Phoenix, AZ    15877   -12236      34500  \n",
       "178         Houston, TX    15742    -1967      43000  \n",
       "188           Akron, OH    15026      578      15781  \n",
       "190       Arlington, VA    14963      306      21000  \n",
       "192         Houston, TX    14757     -769      47262  \n",
       "193       Princeton, NJ    14674    -6382      10468  \n",
       "198         Houston, TX    14403      253      11290  \n",
       "214          Dallas, TX    13238      740       2704  \n",
       "216   Oklahoma City, OK    13145   -14454       5167  \n",
       "217      Parsippany, NJ    13124      146       2270  \n",
       "223   Oklahoma City, OK    12764   -14685       4400  \n",
       "225         Houston, TX    12699    -7829      11100  \n",
       "229        New York, NY    12554     1193      14806  \n",
       "...                 ...      ...      ...        ...  \n",
       "784            Wall, NJ     2734      181        991  \n",
       "798   Oklahoma City, OK     2680     -354       1143  \n",
       "802      Washington, DC     2660      131       1529  \n",
       "810         Houston, TX     2633    -1667       1300  \n",
       "817        Honolulu, HI     2603      160       3918  \n",
       "826       St. Louis, MO     2573    -2913       4655  \n",
       "843     Kansas City, MO     2502      213       2899  \n",
       "850          Warren, PA     2470       82       2997  \n",
       "851       Las Vegas, NV     2464      138       5876  \n",
       "853          Topeka, KS     2459      292       2330  \n",
       "855      Evansville, IN     2435      197       5600  \n",
       "859   Oklahoma City, OK     2418     -752       1640  \n",
       "860       Cleveland, OH     2418     -749       2638  \n",
       "862     Los Angeles, CA     2403    -3554       1700  \n",
       "879      Pittsburgh, PA     2340       85       1914  \n",
       "901           Tulsa, OK     2273      211       4243  \n",
       "908         Houston, TX     2247      423       1400  \n",
       "921   Oklahoma City, OK     2197      271       2586  \n",
       "924           Tulsa, OK     2189      819       1640  \n",
       "948     San Antonio, TX     2084      307       1644  \n",
       "953         Houston, TX     2066      -40        744  \n",
       "955          Denver, CO     2051    -2219       1200  \n",
       "962   Overland Park, KS     2024       30       4028  \n",
       "966          Denver, CO     2019     -149        693  \n",
       "980       St. Louis, MO     1976      137       3078  \n",
       "981           Tulsa, OK     1958    -1727       1040  \n",
       "983         Houston, TX     1944       -1        809  \n",
       "995         Houston, TX     1908    -3748        665  \n",
       "997        Portland, OR     1898      172       2646  \n",
       "997        Portland, OR     1898      172       2646  \n",
       "\n",
       "[122 rows x 7 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors.get_group('Energy')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Nike</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Beaverton, OR</td>\n",
       "      <td>30601</td>\n",
       "      <td>3273</td>\n",
       "      <td>62600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>VF</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Greensboro, NC</td>\n",
       "      <td>12377</td>\n",
       "      <td>1232</td>\n",
       "      <td>64000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340</th>\n",
       "      <td>PVH</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>New York, NY</td>\n",
       "      <td>8020</td>\n",
       "      <td>572</td>\n",
       "      <td>26200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>Ralph Lauren</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>New York, NY</td>\n",
       "      <td>7620</td>\n",
       "      <td>702</td>\n",
       "      <td>20000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>Hanesbrands</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Winston-Salem, NC</td>\n",
       "      <td>5732</td>\n",
       "      <td>429</td>\n",
       "      <td>65300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>547</th>\n",
       "      <td>Levi Strauss</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>San Francisco, CA</td>\n",
       "      <td>4495</td>\n",
       "      <td>209</td>\n",
       "      <td>12500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>575</th>\n",
       "      <td>Coach</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>New York, NY</td>\n",
       "      <td>4192</td>\n",
       "      <td>402</td>\n",
       "      <td>12950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597</th>\n",
       "      <td>Under Armour</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Baltimore, MD</td>\n",
       "      <td>3963</td>\n",
       "      <td>233</td>\n",
       "      <td>9600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>683</th>\n",
       "      <td>Fossil Group</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Richardson, TX</td>\n",
       "      <td>3229</td>\n",
       "      <td>221</td>\n",
       "      <td>15100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>695</th>\n",
       "      <td>Skechers U.S.A.</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Manhattan Beach, CA</td>\n",
       "      <td>3159</td>\n",
       "      <td>232</td>\n",
       "      <td>6400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>Carter’s</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>3014</td>\n",
       "      <td>238</td>\n",
       "      <td>16800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Wolverine World Wide</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Rockford, MI</td>\n",
       "      <td>2692</td>\n",
       "      <td>123</td>\n",
       "      <td>6550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>877</th>\n",
       "      <td>G-III Apparel Group</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>New York, NY</td>\n",
       "      <td>2344</td>\n",
       "      <td>114</td>\n",
       "      <td>8919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>882</th>\n",
       "      <td>Columbia Sportswear</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Portland, OR</td>\n",
       "      <td>2326</td>\n",
       "      <td>174</td>\n",
       "      <td>5978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>917</th>\n",
       "      <td>Guess</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Los Angeles, CA</td>\n",
       "      <td>2204</td>\n",
       "      <td>82</td>\n",
       "      <td>13500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Company   Sector Industry             Location  Revenue  \\\n",
       "Rank                                                                         \n",
       "91                    Nike  Apparel  Apparel        Beaverton, OR    30601   \n",
       "231                     VF  Apparel  Apparel       Greensboro, NC    12377   \n",
       "340                    PVH  Apparel  Apparel         New York, NY     8020   \n",
       "354           Ralph Lauren  Apparel  Apparel         New York, NY     7620   \n",
       "448            Hanesbrands  Apparel  Apparel    Winston-Salem, NC     5732   \n",
       "547           Levi Strauss  Apparel  Apparel    San Francisco, CA     4495   \n",
       "575                  Coach  Apparel  Apparel         New York, NY     4192   \n",
       "597           Under Armour  Apparel  Apparel        Baltimore, MD     3963   \n",
       "683           Fossil Group  Apparel  Apparel       Richardson, TX     3229   \n",
       "695        Skechers U.S.A.  Apparel  Apparel  Manhattan Beach, CA     3159   \n",
       "726               Carter’s  Apparel  Apparel          Atlanta, GA     3014   \n",
       "794   Wolverine World Wide  Apparel  Apparel         Rockford, MI     2692   \n",
       "877    G-III Apparel Group  Apparel  Apparel         New York, NY     2344   \n",
       "882    Columbia Sportswear  Apparel  Apparel         Portland, OR     2326   \n",
       "917                  Guess  Apparel  Apparel      Los Angeles, CA     2204   \n",
       "\n",
       "      Profits  Employees  \n",
       "Rank                      \n",
       "91       3273      62600  \n",
       "231      1232      64000  \n",
       "340       572      26200  \n",
       "354       702      20000  \n",
       "448       429      65300  \n",
       "547       209      12500  \n",
       "575       402      12950  \n",
       "597       233       9600  \n",
       "683       221      15100  \n",
       "695       232       6400  \n",
       "726       238      16800  \n",
       "794       123       6550  \n",
       "877       114       8919  \n",
       "882       174       5978  \n",
       "917        82      13500  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors.get_group('Apparel')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Methods on the Groupby Object and DataFrame Columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Walmart</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>General Merchandisers</td>\n",
       "      <td>Bentonville, AR</td>\n",
       "      <td>482130</td>\n",
       "      <td>14694</td>\n",
       "      <td>2300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Exxon Mobil</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Irving, TX</td>\n",
       "      <td>246204</td>\n",
       "      <td>16150</td>\n",
       "      <td>75600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computers, Office Equipment</td>\n",
       "      <td>Cupertino, CA</td>\n",
       "      <td>233715</td>\n",
       "      <td>53394</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Company      Sector                     Industry         Location  \\\n",
       "Rank                                                                          \n",
       "1         Walmart   Retailing        General Merchandisers  Bentonville, AR   \n",
       "2     Exxon Mobil      Energy           Petroleum Refining       Irving, TX   \n",
       "3           Apple  Technology  Computers, Office Equipment    Cupertino, CA   \n",
       "\n",
       "      Revenue  Profits  Employees  \n",
       "Rank                               \n",
       "1      482130    14694    2300000  \n",
       "2      246204    16150      75600  \n",
       "3      233715    53394     110000  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fortune = pd.read_csv('Fortune1000.csv', index_col = 'Rank')\n",
    "sectors = fortune.groupby('Sector')\n",
    "fortune.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sector</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aerospace &amp; Defense</th>\n",
       "      <td>Woodward</td>\n",
       "      <td>Aerospace and Defense</td>\n",
       "      <td>Wichita, KS</td>\n",
       "      <td>96114</td>\n",
       "      <td>7608</td>\n",
       "      <td>197200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Apparel</th>\n",
       "      <td>Wolverine World Wide</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Winston-Salem, NC</td>\n",
       "      <td>30601</td>\n",
       "      <td>3273</td>\n",
       "      <td>65300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business Services</th>\n",
       "      <td>Western Union</td>\n",
       "      <td>Waste Management</td>\n",
       "      <td>Troy, MI</td>\n",
       "      <td>19330</td>\n",
       "      <td>6328</td>\n",
       "      <td>216500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chemicals</th>\n",
       "      <td>Westlake Chemical</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Wilmington, DE</td>\n",
       "      <td>48778</td>\n",
       "      <td>7685</td>\n",
       "      <td>52000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Energy</th>\n",
       "      <td>Xcel Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Washington, DC</td>\n",
       "      <td>246204</td>\n",
       "      <td>16150</td>\n",
       "      <td>75600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Engineering &amp; Construction</th>\n",
       "      <td>Tutor Perini</td>\n",
       "      <td>Homebuilders</td>\n",
       "      <td>Watsonville, CA</td>\n",
       "      <td>18114</td>\n",
       "      <td>803</td>\n",
       "      <td>92000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Financials</th>\n",
       "      <td>Zions Bancorp.</td>\n",
       "      <td>Securities</td>\n",
       "      <td>Worcester, MA</td>\n",
       "      <td>210821</td>\n",
       "      <td>24442</td>\n",
       "      <td>331000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food and Drug Stores</th>\n",
       "      <td>Whole Foods Market</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Woonsocket, RI</td>\n",
       "      <td>153290</td>\n",
       "      <td>5237</td>\n",
       "      <td>431000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food, Beverages &amp; Tobacco</th>\n",
       "      <td>WhiteWave Foods</td>\n",
       "      <td>Tobacco</td>\n",
       "      <td>Winston-Salem, NC</td>\n",
       "      <td>67702</td>\n",
       "      <td>7351</td>\n",
       "      <td>263000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Care</th>\n",
       "      <td>inVentiv Health</td>\n",
       "      <td>Wholesalers: Health Care</td>\n",
       "      <td>York, PA</td>\n",
       "      <td>181241</td>\n",
       "      <td>18108</td>\n",
       "      <td>203500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hotels, Resturants &amp; Leisure</th>\n",
       "      <td>Yum Brands</td>\n",
       "      <td>Hotels, Casinos, Resorts</td>\n",
       "      <td>Wyomissing, PA</td>\n",
       "      <td>25413</td>\n",
       "      <td>5920</td>\n",
       "      <td>505000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Household Products</th>\n",
       "      <td>Vista Outdoor</td>\n",
       "      <td>Miscellaneous</td>\n",
       "      <td>Zeeland, MI</td>\n",
       "      <td>78756</td>\n",
       "      <td>7036</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Industrials</th>\n",
       "      <td>Zebra Technologies</td>\n",
       "      <td>Miscellaneous</td>\n",
       "      <td>Wilmerding, PA</td>\n",
       "      <td>140389</td>\n",
       "      <td>4833</td>\n",
       "      <td>333000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Materials</th>\n",
       "      <td>Worthington Industries</td>\n",
       "      <td>Packaging, Containers</td>\n",
       "      <td>Wyomissing, PA</td>\n",
       "      <td>22534</td>\n",
       "      <td>991</td>\n",
       "      <td>60000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Media</th>\n",
       "      <td>iHeartMedia</td>\n",
       "      <td>Publishing, Printing</td>\n",
       "      <td>Sussex, WI</td>\n",
       "      <td>52465</td>\n",
       "      <td>8382</td>\n",
       "      <td>185000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Motor Vehicles &amp; Parts</th>\n",
       "      <td>Wabash National</td>\n",
       "      <td>Motor Vehicles and Parts</td>\n",
       "      <td>Van Buren Township, MI</td>\n",
       "      <td>152356</td>\n",
       "      <td>9687</td>\n",
       "      <td>215000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Retailing</th>\n",
       "      <td>hhgregg</td>\n",
       "      <td>Specialty Retailers: Other</td>\n",
       "      <td>York, PA</td>\n",
       "      <td>482130</td>\n",
       "      <td>14694</td>\n",
       "      <td>2300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technology</th>\n",
       "      <td>salesforce.com</td>\n",
       "      <td>Semiconductors and Other Electronic Components</td>\n",
       "      <td>Woburn, MA</td>\n",
       "      <td>233715</td>\n",
       "      <td>53394</td>\n",
       "      <td>411798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Telecommunications</th>\n",
       "      <td>Windstream Holdings</td>\n",
       "      <td>Telecommunications</td>\n",
       "      <td>Stamford, CT</td>\n",
       "      <td>146801</td>\n",
       "      <td>17879</td>\n",
       "      <td>281450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Transportation</th>\n",
       "      <td>YRC Worldwide</td>\n",
       "      <td>Trucking, Truck Leasing</td>\n",
       "      <td>Thomasville, NC</td>\n",
       "      <td>58363</td>\n",
       "      <td>7610</td>\n",
       "      <td>341240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wholesalers</th>\n",
       "      <td>World Fuel Services</td>\n",
       "      <td>Wholesalers: Food and Grocery</td>\n",
       "      <td>Waltham, MA</td>\n",
       "      <td>48681</td>\n",
       "      <td>1472</td>\n",
       "      <td>78500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Company  \\\n",
       "Sector                                                 \n",
       "Aerospace & Defense                         Woodward   \n",
       "Apparel                         Wolverine World Wide   \n",
       "Business Services                      Western Union   \n",
       "Chemicals                          Westlake Chemical   \n",
       "Energy                                   Xcel Energy   \n",
       "Engineering & Construction              Tutor Perini   \n",
       "Financials                            Zions Bancorp.   \n",
       "Food and Drug Stores              Whole Foods Market   \n",
       "Food, Beverages & Tobacco            WhiteWave Foods   \n",
       "Health Care                          inVentiv Health   \n",
       "Hotels, Resturants & Leisure              Yum Brands   \n",
       "Household Products                     Vista Outdoor   \n",
       "Industrials                       Zebra Technologies   \n",
       "Materials                     Worthington Industries   \n",
       "Media                                    iHeartMedia   \n",
       "Motor Vehicles & Parts               Wabash National   \n",
       "Retailing                                    hhgregg   \n",
       "Technology                            salesforce.com   \n",
       "Telecommunications               Windstream Holdings   \n",
       "Transportation                         YRC Worldwide   \n",
       "Wholesalers                      World Fuel Services   \n",
       "\n",
       "                                                                    Industry  \\\n",
       "Sector                                                                         \n",
       "Aerospace & Defense                                    Aerospace and Defense   \n",
       "Apparel                                                              Apparel   \n",
       "Business Services                                           Waste Management   \n",
       "Chemicals                                                          Chemicals   \n",
       "Energy                                           Utilities: Gas and Electric   \n",
       "Engineering & Construction                                      Homebuilders   \n",
       "Financials                                                        Securities   \n",
       "Food and Drug Stores                                    Food and Drug Stores   \n",
       "Food, Beverages & Tobacco                                            Tobacco   \n",
       "Health Care                                         Wholesalers: Health Care   \n",
       "Hotels, Resturants & Leisure                        Hotels, Casinos, Resorts   \n",
       "Household Products                                             Miscellaneous   \n",
       "Industrials                                                    Miscellaneous   \n",
       "Materials                                              Packaging, Containers   \n",
       "Media                                                   Publishing, Printing   \n",
       "Motor Vehicles & Parts                              Motor Vehicles and Parts   \n",
       "Retailing                                         Specialty Retailers: Other   \n",
       "Technology                    Semiconductors and Other Electronic Components   \n",
       "Telecommunications                                        Telecommunications   \n",
       "Transportation                                       Trucking, Truck Leasing   \n",
       "Wholesalers                                    Wholesalers: Food and Grocery   \n",
       "\n",
       "                                            Location  Revenue  Profits  \\\n",
       "Sector                                                                   \n",
       "Aerospace & Defense                      Wichita, KS    96114     7608   \n",
       "Apparel                            Winston-Salem, NC    30601     3273   \n",
       "Business Services                           Troy, MI    19330     6328   \n",
       "Chemicals                             Wilmington, DE    48778     7685   \n",
       "Energy                                Washington, DC   246204    16150   \n",
       "Engineering & Construction           Watsonville, CA    18114      803   \n",
       "Financials                             Worcester, MA   210821    24442   \n",
       "Food and Drug Stores                  Woonsocket, RI   153290     5237   \n",
       "Food, Beverages & Tobacco          Winston-Salem, NC    67702     7351   \n",
       "Health Care                                 York, PA   181241    18108   \n",
       "Hotels, Resturants & Leisure          Wyomissing, PA    25413     5920   \n",
       "Household Products                       Zeeland, MI    78756     7036   \n",
       "Industrials                           Wilmerding, PA   140389     4833   \n",
       "Materials                             Wyomissing, PA    22534      991   \n",
       "Media                                     Sussex, WI    52465     8382   \n",
       "Motor Vehicles & Parts        Van Buren Township, MI   152356     9687   \n",
       "Retailing                                   York, PA   482130    14694   \n",
       "Technology                                Woburn, MA   233715    53394   \n",
       "Telecommunications                      Stamford, CT   146801    17879   \n",
       "Transportation                       Thomasville, NC    58363     7610   \n",
       "Wholesalers                              Waltham, MA    48681     1472   \n",
       "\n",
       "                              Employees  \n",
       "Sector                                   \n",
       "Aerospace & Defense              197200  \n",
       "Apparel                           65300  \n",
       "Business Services                216500  \n",
       "Chemicals                         52000  \n",
       "Energy                            75600  \n",
       "Engineering & Construction        92000  \n",
       "Financials                       331000  \n",
       "Food and Drug Stores             431000  \n",
       "Food, Beverages & Tobacco        263000  \n",
       "Health Care                      203500  \n",
       "Hotels, Resturants & Leisure     505000  \n",
       "Household Products               110000  \n",
       "Industrials                      333000  \n",
       "Materials                         60000  \n",
       "Media                            185000  \n",
       "Motor Vehicles & Parts           215000  \n",
       "Retailing                       2300000  \n",
       "Technology                       411798  \n",
       "Telecommunications               281450  \n",
       "Transportation                   341240  \n",
       "Wholesalers                       78500  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors.max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sector</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aerospace &amp; Defense</th>\n",
       "      <td>B/E Aerospace</td>\n",
       "      <td>Aerospace and Defense</td>\n",
       "      <td>Berwyn, PA</td>\n",
       "      <td>1923</td>\n",
       "      <td>-240</td>\n",
       "      <td>6955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Apparel</th>\n",
       "      <td>Carter’s</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>2204</td>\n",
       "      <td>82</td>\n",
       "      <td>5978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business Services</th>\n",
       "      <td>ABM Industries</td>\n",
       "      <td>Advertising, marketing</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>1910</td>\n",
       "      <td>-1481</td>\n",
       "      <td>2400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chemicals</th>\n",
       "      <td>A. Schulman</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Allentown, PA</td>\n",
       "      <td>2084</td>\n",
       "      <td>-816</td>\n",
       "      <td>1979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Energy</th>\n",
       "      <td>AES</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Akron, OH</td>\n",
       "      <td>1898</td>\n",
       "      <td>-23119</td>\n",
       "      <td>480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Engineering &amp; Construction</th>\n",
       "      <td>AECOM</td>\n",
       "      <td>Engineering, Construction</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>1909</td>\n",
       "      <td>-155</td>\n",
       "      <td>1036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Financials</th>\n",
       "      <td>AIG</td>\n",
       "      <td>Commercial Banks</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>1902</td>\n",
       "      <td>-1194</td>\n",
       "      <td>187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food and Drug Stores</th>\n",
       "      <td>CVS Health</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Austin, TX</td>\n",
       "      <td>2151</td>\n",
       "      <td>-62</td>\n",
       "      <td>1616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food, Beverages &amp; Tobacco</th>\n",
       "      <td>Alliance One International</td>\n",
       "      <td>Beverages</td>\n",
       "      <td>Arden Hills, MN</td>\n",
       "      <td>2066</td>\n",
       "      <td>-253</td>\n",
       "      <td>1857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Care</th>\n",
       "      <td>AbbVie</td>\n",
       "      <td>Health Care: Insurance and Managed Care</td>\n",
       "      <td>Abbott Park, IL</td>\n",
       "      <td>1987</td>\n",
       "      <td>-458</td>\n",
       "      <td>2924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hotels, Resturants &amp; Leisure</th>\n",
       "      <td>Bloomin’ Brands</td>\n",
       "      <td>Food Services</td>\n",
       "      <td>Ann Arbor, MI</td>\n",
       "      <td>1896</td>\n",
       "      <td>-1394</td>\n",
       "      <td>8500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Household Products</th>\n",
       "      <td>Avon Products</td>\n",
       "      <td>Home Equipment, Furnishings</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>1914</td>\n",
       "      <td>-1149</td>\n",
       "      <td>4406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Industrials</th>\n",
       "      <td>3M</td>\n",
       "      <td>Construction and Farm Machinery</td>\n",
       "      <td>Annapolis Junction, MD</td>\n",
       "      <td>1895</td>\n",
       "      <td>-6126</td>\n",
       "      <td>4104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Materials</th>\n",
       "      <td>A-Mark Precious Metals</td>\n",
       "      <td>Building Materials, Glass</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>1924</td>\n",
       "      <td>-1642</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Media</th>\n",
       "      <td>AMC Networks</td>\n",
       "      <td>Entertainment</td>\n",
       "      <td>Beverly Hills, CA</td>\n",
       "      <td>1921</td>\n",
       "      <td>-881</td>\n",
       "      <td>2341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Motor Vehicles &amp; Parts</th>\n",
       "      <td>Allison Transmission Holdings</td>\n",
       "      <td>Motor Vehicles and Parts</td>\n",
       "      <td>Akron, OH</td>\n",
       "      <td>1986</td>\n",
       "      <td>-889</td>\n",
       "      <td>2700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Retailing</th>\n",
       "      <td>99 Cents Only Stores</td>\n",
       "      <td>Automotive Retailing, Services</td>\n",
       "      <td>Ankeny, IA</td>\n",
       "      <td>1999</td>\n",
       "      <td>-1243</td>\n",
       "      <td>2155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technology</th>\n",
       "      <td>Activision Blizzard</td>\n",
       "      <td>Computer Peripherals</td>\n",
       "      <td>Angleton, TX</td>\n",
       "      <td>1920</td>\n",
       "      <td>-4359</td>\n",
       "      <td>2285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Telecommunications</th>\n",
       "      <td>AT&amp;T</td>\n",
       "      <td>Telecommunications</td>\n",
       "      <td>Bethpage, NY</td>\n",
       "      <td>2726</td>\n",
       "      <td>-271</td>\n",
       "      <td>2700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Transportation</th>\n",
       "      <td>Alaska Air Group</td>\n",
       "      <td>Airlines</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>1995</td>\n",
       "      <td>-191</td>\n",
       "      <td>1223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wholesalers</th>\n",
       "      <td>Airgas</td>\n",
       "      <td>Miscellaneous</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>1917</td>\n",
       "      <td>-502</td>\n",
       "      <td>500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    Company  \\\n",
       "Sector                                                        \n",
       "Aerospace & Defense                           B/E Aerospace   \n",
       "Apparel                                            Carter’s   \n",
       "Business Services                            ABM Industries   \n",
       "Chemicals                                       A. Schulman   \n",
       "Energy                                                  AES   \n",
       "Engineering & Construction                            AECOM   \n",
       "Financials                                              AIG   \n",
       "Food and Drug Stores                             CVS Health   \n",
       "Food, Beverages & Tobacco        Alliance One International   \n",
       "Health Care                                          AbbVie   \n",
       "Hotels, Resturants & Leisure                Bloomin’ Brands   \n",
       "Household Products                            Avon Products   \n",
       "Industrials                                              3M   \n",
       "Materials                            A-Mark Precious Metals   \n",
       "Media                                          AMC Networks   \n",
       "Motor Vehicles & Parts        Allison Transmission Holdings   \n",
       "Retailing                              99 Cents Only Stores   \n",
       "Technology                              Activision Blizzard   \n",
       "Telecommunications                                     AT&T   \n",
       "Transportation                             Alaska Air Group   \n",
       "Wholesalers                                          Airgas   \n",
       "\n",
       "                                                             Industry  \\\n",
       "Sector                                                                  \n",
       "Aerospace & Defense                             Aerospace and Defense   \n",
       "Apparel                                                       Apparel   \n",
       "Business Services                              Advertising, marketing   \n",
       "Chemicals                                                   Chemicals   \n",
       "Energy                                                         Energy   \n",
       "Engineering & Construction                  Engineering, Construction   \n",
       "Financials                                           Commercial Banks   \n",
       "Food and Drug Stores                             Food and Drug Stores   \n",
       "Food, Beverages & Tobacco                                   Beverages   \n",
       "Health Care                   Health Care: Insurance and Managed Care   \n",
       "Hotels, Resturants & Leisure                            Food Services   \n",
       "Household Products                        Home Equipment, Furnishings   \n",
       "Industrials                           Construction and Farm Machinery   \n",
       "Materials                                   Building Materials, Glass   \n",
       "Media                                                   Entertainment   \n",
       "Motor Vehicles & Parts                       Motor Vehicles and Parts   \n",
       "Retailing                              Automotive Retailing, Services   \n",
       "Technology                                       Computer Peripherals   \n",
       "Telecommunications                                 Telecommunications   \n",
       "Transportation                                               Airlines   \n",
       "Wholesalers                                             Miscellaneous   \n",
       "\n",
       "                                            Location  Revenue  Profits  \\\n",
       "Sector                                                                   \n",
       "Aerospace & Defense                       Berwyn, PA     1923     -240   \n",
       "Apparel                                  Atlanta, GA     2204       82   \n",
       "Business Services                      Arlington, VA     1910    -1481   \n",
       "Chemicals                              Allentown, PA     2084     -816   \n",
       "Energy                                     Akron, OH     1898   -23119   \n",
       "Engineering & Construction               Atlanta, GA     1909     -155   \n",
       "Financials                               Atlanta, GA     1902    -1194   \n",
       "Food and Drug Stores                      Austin, TX     2151      -62   \n",
       "Food, Beverages & Tobacco            Arden Hills, MN     2066     -253   \n",
       "Health Care                          Abbott Park, IL     1987     -458   \n",
       "Hotels, Resturants & Leisure           Ann Arbor, MI     1896    -1394   \n",
       "Household Products                       Atlanta, GA     1914    -1149   \n",
       "Industrials                   Annapolis Junction, MD     1895    -6126   \n",
       "Materials                                Atlanta, GA     1924    -1642   \n",
       "Media                              Beverly Hills, CA     1921     -881   \n",
       "Motor Vehicles & Parts                     Akron, OH     1986     -889   \n",
       "Retailing                                 Ankeny, IA     1999    -1243   \n",
       "Technology                              Angleton, TX     1920    -4359   \n",
       "Telecommunications                      Bethpage, NY     2726     -271   \n",
       "Transportation                           Atlanta, GA     1995     -191   \n",
       "Wholesalers                              Atlanta, GA     1917     -502   \n",
       "\n",
       "                              Employees  \n",
       "Sector                                   \n",
       "Aerospace & Defense                6955  \n",
       "Apparel                            5978  \n",
       "Business Services                  2400  \n",
       "Chemicals                          1979  \n",
       "Energy                              480  \n",
       "Engineering & Construction         1036  \n",
       "Financials                          187  \n",
       "Food and Drug Stores               1616  \n",
       "Food, Beverages & Tobacco          1857  \n",
       "Health Care                        2924  \n",
       "Hotels, Resturants & Leisure       8500  \n",
       "Household Products                 4406  \n",
       "Industrials                        4104  \n",
       "Materials                            52  \n",
       "Media                              2341  \n",
       "Motor Vehicles & Parts             2700  \n",
       "Retailing                          2155  \n",
       "Technology                         2285  \n",
       "Telecommunications                 2700  \n",
       "Transportation                     1223  \n",
       "Wholesalers                         500  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors.min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Sector\n",
       "Aerospace & Defense              968057\n",
       "Apparel                          346397\n",
       "Business Services               1361050\n",
       "Chemicals                        463651\n",
       "Energy                          1188927\n",
       "Engineering & Construction       406708\n",
       "Financials                      3359948\n",
       "Food and Drug Stores            1395398\n",
       "Food, Beverages & Tobacco       1211632\n",
       "Health Care                     2678289\n",
       "Hotels, Resturants & Leisure    2484245\n",
       "Household Products               646038\n",
       "Industrials                     1545229\n",
       "Materials                        638123\n",
       "Media                            550314\n",
       "Motor Vehicles & Parts          1082560\n",
       "Retailing                       6227629\n",
       "Technology                      3578949\n",
       "Telecommunications               832468\n",
       "Transportation                  1536793\n",
       "Wholesalers                      525597\n",
       "Name: Employees, dtype: int64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors['Employees'].sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Grouping by Multiple Columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Walmart</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>General Merchandisers</td>\n",
       "      <td>Bentonville, AR</td>\n",
       "      <td>482130</td>\n",
       "      <td>14694</td>\n",
       "      <td>2300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Exxon Mobil</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Irving, TX</td>\n",
       "      <td>246204</td>\n",
       "      <td>16150</td>\n",
       "      <td>75600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computers, Office Equipment</td>\n",
       "      <td>Cupertino, CA</td>\n",
       "      <td>233715</td>\n",
       "      <td>53394</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Company      Sector                     Industry         Location  \\\n",
       "Rank                                                                          \n",
       "1         Walmart   Retailing        General Merchandisers  Bentonville, AR   \n",
       "2     Exxon Mobil      Energy           Petroleum Refining       Irving, TX   \n",
       "3           Apple  Technology  Computers, Office Equipment    Cupertino, CA   \n",
       "\n",
       "      Revenue  Profits  Employees  \n",
       "Rank                               \n",
       "1      482130    14694    2300000  \n",
       "2      246204    16150      75600  \n",
       "3      233715    53394     110000  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fortune = pd.read_csv('Fortune1000.csv', index_col = 'Rank')\n",
    "sectors = fortune.groupby(['Sector', 'Industry'])\n",
    "fortune.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Sector                      Industry                                      \n",
       "Aerospace & Defense         Aerospace and Defense                              48402.850000\n",
       "Apparel                     Apparel                                            23093.133333\n",
       "Business Services           Advertising, marketing                             62050.000000\n",
       "                            Diversified Outsourcing Services                   50595.000000\n",
       "                            Education                                          15585.000000\n",
       "                            Financial Data Services                            13943.473684\n",
       "                            Miscellaneous                                      12573.333333\n",
       "                            Temporary Help                                     12004.000000\n",
       "                            Waste Management                                   23839.800000\n",
       "Chemicals                   Chemicals                                          15455.033333\n",
       "Energy                      Energy                                              5005.142857\n",
       "                            Mining, Crude-Oil Production                        5325.357143\n",
       "                            Miscellaneous                                       6700.000000\n",
       "                            Oil and Gas Equipment, Services                    25088.333333\n",
       "                            Petroleum Refining                                 14404.705882\n",
       "                            Pipelines                                           6011.750000\n",
       "                            Utilities: Gas and Electric                        10249.487805\n",
       "Engineering & Construction  Engineering, Construction                          26293.142857\n",
       "                            Homebuilders                                        3217.000000\n",
       "Financials                  Commercial Banks                                   54965.142857\n",
       "                            Diversified Financials                             21940.933333\n",
       "                            Insurance: Life, Health (Mutual)                    5880.100000\n",
       "                            Insurance: Life, Health (stock)                    11235.166667\n",
       "                            Insurance: Property and Casualty (Mutual)          19021.142857\n",
       "                            Insurance: Property and Casualty (Stock)           28361.535714\n",
       "                            Real estate                                        10705.266667\n",
       "                            Securities                                          7940.333333\n",
       "Food and Drug Stores        Food and Drug Stores                               93026.533333\n",
       "Food, Beverages & Tobacco   Beverages                                          22123.000000\n",
       "                            Food Consumer Products                             33271.950000\n",
       "                                                                                  ...      \n",
       "Materials                   Metals                                             13825.642857\n",
       "                            Miscellaneous                                         52.000000\n",
       "                            Packaging, Containers                              20840.375000\n",
       "Media                       Entertainment                                      21309.111111\n",
       "                            Publishing, Printing                               23821.428571\n",
       "Motor Vehicles & Parts      Motor Vehicles and Parts                           45106.666667\n",
       "Retailing                   Automotive Retailing, Services                     17497.400000\n",
       "                            General Merchandisers                             340810.000000\n",
       "                            Specialty Retailers: Apparel                       42807.944444\n",
       "                            Specialty Retailers: Other                         44619.333333\n",
       "Technology                  Computer Peripherals                               43814.750000\n",
       "                            Computer Software                                  27771.142857\n",
       "                            Computers, Office Equipment                        66869.285714\n",
       "                            Information Technology Services                    75818.384615\n",
       "                            Internet Services and Retailing                    28723.666667\n",
       "                            Network and Other Communications Equipment         21379.285714\n",
       "                            Scientific,Photographic and Control Equipment      19291.750000\n",
       "                            Semiconductors and Other Electronic Components     26065.391304\n",
       "Telecommunications          Telecommunications                                 55497.866667\n",
       "Transportation              Airlines                                           43511.222222\n",
       "                            Mail, Package, and Freight Delivery               332137.500000\n",
       "                            Miscellaneous                                       4200.000000\n",
       "                            Railroads                                          24368.800000\n",
       "                            Transportation Equipment                           11945.200000\n",
       "                            Transportation and Logistics                       24938.200000\n",
       "                            Trucking, Truck Leasing                            18939.555556\n",
       "Wholesalers                 Miscellaneous                                       9200.000000\n",
       "                            Wholesalers: Diversified                            9353.240000\n",
       "                            Wholesalers: Electronics and Office Equipment      20832.625000\n",
       "                            Wholesalers: Food and Grocery                      19317.500000\n",
       "Name: Employees, Length: 79, dtype: float64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors.size()\n",
    "sectors.sum()\n",
    "sectors['Revenue'].sum()\n",
    "sectors['Employees'].mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The .agg() Method"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Walmart</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>General Merchandisers</td>\n",
       "      <td>Bentonville, AR</td>\n",
       "      <td>482130</td>\n",
       "      <td>14694</td>\n",
       "      <td>2300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Exxon Mobil</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Irving, TX</td>\n",
       "      <td>246204</td>\n",
       "      <td>16150</td>\n",
       "      <td>75600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computers, Office Equipment</td>\n",
       "      <td>Cupertino, CA</td>\n",
       "      <td>233715</td>\n",
       "      <td>53394</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Company      Sector                     Industry         Location  \\\n",
       "Rank                                                                          \n",
       "1         Walmart   Retailing        General Merchandisers  Bentonville, AR   \n",
       "2     Exxon Mobil      Energy           Petroleum Refining       Irving, TX   \n",
       "3           Apple  Technology  Computers, Office Equipment    Cupertino, CA   \n",
       "\n",
       "      Revenue  Profits  Employees  \n",
       "Rank                               \n",
       "1      482130    14694    2300000  \n",
       "2      246204    16150      75600  \n",
       "3      233715    53394     110000  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fortune = pd.read_csv('Fortune1000.csv', index_col = 'Rank')\n",
    "sectors = fortune.groupby('Sector')\n",
    "fortune.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"2\" halign=\"left\">Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>sum</th>\n",
       "      <th>mean</th>\n",
       "      <th>sum</th>\n",
       "      <th>mean</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sector</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aerospace &amp; Defense</th>\n",
       "      <td>357940</td>\n",
       "      <td>17897.000000</td>\n",
       "      <td>28742</td>\n",
       "      <td>48402.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Apparel</th>\n",
       "      <td>95968</td>\n",
       "      <td>6397.866667</td>\n",
       "      <td>8236</td>\n",
       "      <td>23093.133333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business Services</th>\n",
       "      <td>272195</td>\n",
       "      <td>5337.156863</td>\n",
       "      <td>28227</td>\n",
       "      <td>26687.254902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chemicals</th>\n",
       "      <td>243897</td>\n",
       "      <td>8129.900000</td>\n",
       "      <td>22628</td>\n",
       "      <td>15455.033333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Energy</th>\n",
       "      <td>1517809</td>\n",
       "      <td>12441.057377</td>\n",
       "      <td>-73447</td>\n",
       "      <td>9745.303279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Engineering &amp; Construction</th>\n",
       "      <td>153983</td>\n",
       "      <td>5922.423077</td>\n",
       "      <td>5304</td>\n",
       "      <td>15642.615385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Financials</th>\n",
       "      <td>2217159</td>\n",
       "      <td>15950.784173</td>\n",
       "      <td>260209</td>\n",
       "      <td>24172.287770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food and Drug Stores</th>\n",
       "      <td>483769</td>\n",
       "      <td>32251.266667</td>\n",
       "      <td>16759</td>\n",
       "      <td>93026.533333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food, Beverages &amp; Tobacco</th>\n",
       "      <td>555967</td>\n",
       "      <td>12929.465116</td>\n",
       "      <td>51417</td>\n",
       "      <td>28177.488372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Care</th>\n",
       "      <td>1614707</td>\n",
       "      <td>21529.426667</td>\n",
       "      <td>106114</td>\n",
       "      <td>35710.520000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hotels, Resturants &amp; Leisure</th>\n",
       "      <td>169546</td>\n",
       "      <td>6781.840000</td>\n",
       "      <td>20697</td>\n",
       "      <td>99369.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Household Products</th>\n",
       "      <td>234737</td>\n",
       "      <td>8383.464286</td>\n",
       "      <td>14428</td>\n",
       "      <td>23072.785714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Industrials</th>\n",
       "      <td>497581</td>\n",
       "      <td>10816.978261</td>\n",
       "      <td>20764</td>\n",
       "      <td>33591.934783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Materials</th>\n",
       "      <td>259145</td>\n",
       "      <td>6026.627907</td>\n",
       "      <td>4428</td>\n",
       "      <td>14840.069767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Media</th>\n",
       "      <td>220764</td>\n",
       "      <td>8830.560000</td>\n",
       "      <td>24347</td>\n",
       "      <td>22012.560000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Motor Vehicles &amp; Parts</th>\n",
       "      <td>482540</td>\n",
       "      <td>20105.833333</td>\n",
       "      <td>25898</td>\n",
       "      <td>45106.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Retailing</th>\n",
       "      <td>1465076</td>\n",
       "      <td>18313.450000</td>\n",
       "      <td>47830</td>\n",
       "      <td>77845.362500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technology</th>\n",
       "      <td>1377600</td>\n",
       "      <td>13505.882353</td>\n",
       "      <td>180473</td>\n",
       "      <td>35087.735294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Telecommunications</th>\n",
       "      <td>461834</td>\n",
       "      <td>30788.933333</td>\n",
       "      <td>48637</td>\n",
       "      <td>55497.866667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Transportation</th>\n",
       "      <td>408508</td>\n",
       "      <td>11347.444444</td>\n",
       "      <td>44169</td>\n",
       "      <td>42688.694444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wholesalers</th>\n",
       "      <td>444800</td>\n",
       "      <td>11120.000000</td>\n",
       "      <td>8233</td>\n",
       "      <td>13139.925000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Revenue               Profits     Employees\n",
       "                                  sum          mean     sum          mean\n",
       "Sector                                                                   \n",
       "Aerospace & Defense            357940  17897.000000   28742  48402.850000\n",
       "Apparel                         95968   6397.866667    8236  23093.133333\n",
       "Business Services              272195   5337.156863   28227  26687.254902\n",
       "Chemicals                      243897   8129.900000   22628  15455.033333\n",
       "Energy                        1517809  12441.057377  -73447   9745.303279\n",
       "Engineering & Construction     153983   5922.423077    5304  15642.615385\n",
       "Financials                    2217159  15950.784173  260209  24172.287770\n",
       "Food and Drug Stores           483769  32251.266667   16759  93026.533333\n",
       "Food, Beverages & Tobacco      555967  12929.465116   51417  28177.488372\n",
       "Health Care                   1614707  21529.426667  106114  35710.520000\n",
       "Hotels, Resturants & Leisure   169546   6781.840000   20697  99369.800000\n",
       "Household Products             234737   8383.464286   14428  23072.785714\n",
       "Industrials                    497581  10816.978261   20764  33591.934783\n",
       "Materials                      259145   6026.627907    4428  14840.069767\n",
       "Media                          220764   8830.560000   24347  22012.560000\n",
       "Motor Vehicles & Parts         482540  20105.833333   25898  45106.666667\n",
       "Retailing                     1465076  18313.450000   47830  77845.362500\n",
       "Technology                    1377600  13505.882353  180473  35087.735294\n",
       "Telecommunications             461834  30788.933333   48637  55497.866667\n",
       "Transportation                 408508  11347.444444   44169  42688.694444\n",
       "Wholesalers                    444800  11120.000000    8233  13139.925000"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors.agg({'Revenue' : ['sum','mean'],\n",
    "             'Profits' : 'sum', \n",
    "             'Employees': 'mean'\n",
    "    \n",
    "})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"3\" halign=\"left\">Revenue</th>\n",
       "      <th colspan=\"3\" halign=\"left\">Profits</th>\n",
       "      <th colspan=\"3\" halign=\"left\">Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>size</th>\n",
       "      <th>sum</th>\n",
       "      <th>mean</th>\n",
       "      <th>size</th>\n",
       "      <th>sum</th>\n",
       "      <th>mean</th>\n",
       "      <th>size</th>\n",
       "      <th>sum</th>\n",
       "      <th>mean</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sector</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aerospace &amp; Defense</th>\n",
       "      <td>20</td>\n",
       "      <td>357940</td>\n",
       "      <td>17897.000000</td>\n",
       "      <td>20</td>\n",
       "      <td>28742</td>\n",
       "      <td>1437.100000</td>\n",
       "      <td>20</td>\n",
       "      <td>968057</td>\n",
       "      <td>48402.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Apparel</th>\n",
       "      <td>15</td>\n",
       "      <td>95968</td>\n",
       "      <td>6397.866667</td>\n",
       "      <td>15</td>\n",
       "      <td>8236</td>\n",
       "      <td>549.066667</td>\n",
       "      <td>15</td>\n",
       "      <td>346397</td>\n",
       "      <td>23093.133333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business Services</th>\n",
       "      <td>51</td>\n",
       "      <td>272195</td>\n",
       "      <td>5337.156863</td>\n",
       "      <td>51</td>\n",
       "      <td>28227</td>\n",
       "      <td>553.470588</td>\n",
       "      <td>51</td>\n",
       "      <td>1361050</td>\n",
       "      <td>26687.254902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chemicals</th>\n",
       "      <td>30</td>\n",
       "      <td>243897</td>\n",
       "      <td>8129.900000</td>\n",
       "      <td>30</td>\n",
       "      <td>22628</td>\n",
       "      <td>754.266667</td>\n",
       "      <td>30</td>\n",
       "      <td>463651</td>\n",
       "      <td>15455.033333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Energy</th>\n",
       "      <td>122</td>\n",
       "      <td>1517809</td>\n",
       "      <td>12441.057377</td>\n",
       "      <td>122</td>\n",
       "      <td>-73447</td>\n",
       "      <td>-602.024590</td>\n",
       "      <td>122</td>\n",
       "      <td>1188927</td>\n",
       "      <td>9745.303279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Engineering &amp; Construction</th>\n",
       "      <td>26</td>\n",
       "      <td>153983</td>\n",
       "      <td>5922.423077</td>\n",
       "      <td>26</td>\n",
       "      <td>5304</td>\n",
       "      <td>204.000000</td>\n",
       "      <td>26</td>\n",
       "      <td>406708</td>\n",
       "      <td>15642.615385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Financials</th>\n",
       "      <td>139</td>\n",
       "      <td>2217159</td>\n",
       "      <td>15950.784173</td>\n",
       "      <td>139</td>\n",
       "      <td>260209</td>\n",
       "      <td>1872.007194</td>\n",
       "      <td>139</td>\n",
       "      <td>3359948</td>\n",
       "      <td>24172.287770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food and Drug Stores</th>\n",
       "      <td>15</td>\n",
       "      <td>483769</td>\n",
       "      <td>32251.266667</td>\n",
       "      <td>15</td>\n",
       "      <td>16759</td>\n",
       "      <td>1117.266667</td>\n",
       "      <td>15</td>\n",
       "      <td>1395398</td>\n",
       "      <td>93026.533333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Food, Beverages &amp; Tobacco</th>\n",
       "      <td>43</td>\n",
       "      <td>555967</td>\n",
       "      <td>12929.465116</td>\n",
       "      <td>43</td>\n",
       "      <td>51417</td>\n",
       "      <td>1195.744186</td>\n",
       "      <td>43</td>\n",
       "      <td>1211632</td>\n",
       "      <td>28177.488372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Care</th>\n",
       "      <td>75</td>\n",
       "      <td>1614707</td>\n",
       "      <td>21529.426667</td>\n",
       "      <td>75</td>\n",
       "      <td>106114</td>\n",
       "      <td>1414.853333</td>\n",
       "      <td>75</td>\n",
       "      <td>2678289</td>\n",
       "      <td>35710.520000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hotels, Resturants &amp; Leisure</th>\n",
       "      <td>25</td>\n",
       "      <td>169546</td>\n",
       "      <td>6781.840000</td>\n",
       "      <td>25</td>\n",
       "      <td>20697</td>\n",
       "      <td>827.880000</td>\n",
       "      <td>25</td>\n",
       "      <td>2484245</td>\n",
       "      <td>99369.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Household Products</th>\n",
       "      <td>28</td>\n",
       "      <td>234737</td>\n",
       "      <td>8383.464286</td>\n",
       "      <td>28</td>\n",
       "      <td>14428</td>\n",
       "      <td>515.285714</td>\n",
       "      <td>28</td>\n",
       "      <td>646038</td>\n",
       "      <td>23072.785714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Industrials</th>\n",
       "      <td>46</td>\n",
       "      <td>497581</td>\n",
       "      <td>10816.978261</td>\n",
       "      <td>46</td>\n",
       "      <td>20764</td>\n",
       "      <td>451.391304</td>\n",
       "      <td>46</td>\n",
       "      <td>1545229</td>\n",
       "      <td>33591.934783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Materials</th>\n",
       "      <td>43</td>\n",
       "      <td>259145</td>\n",
       "      <td>6026.627907</td>\n",
       "      <td>43</td>\n",
       "      <td>4428</td>\n",
       "      <td>102.976744</td>\n",
       "      <td>43</td>\n",
       "      <td>638123</td>\n",
       "      <td>14840.069767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Media</th>\n",
       "      <td>25</td>\n",
       "      <td>220764</td>\n",
       "      <td>8830.560000</td>\n",
       "      <td>25</td>\n",
       "      <td>24347</td>\n",
       "      <td>973.880000</td>\n",
       "      <td>25</td>\n",
       "      <td>550314</td>\n",
       "      <td>22012.560000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Motor Vehicles &amp; Parts</th>\n",
       "      <td>24</td>\n",
       "      <td>482540</td>\n",
       "      <td>20105.833333</td>\n",
       "      <td>24</td>\n",
       "      <td>25898</td>\n",
       "      <td>1079.083333</td>\n",
       "      <td>24</td>\n",
       "      <td>1082560</td>\n",
       "      <td>45106.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Retailing</th>\n",
       "      <td>80</td>\n",
       "      <td>1465076</td>\n",
       "      <td>18313.450000</td>\n",
       "      <td>80</td>\n",
       "      <td>47830</td>\n",
       "      <td>597.875000</td>\n",
       "      <td>80</td>\n",
       "      <td>6227629</td>\n",
       "      <td>77845.362500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technology</th>\n",
       "      <td>102</td>\n",
       "      <td>1377600</td>\n",
       "      <td>13505.882353</td>\n",
       "      <td>102</td>\n",
       "      <td>180473</td>\n",
       "      <td>1769.343137</td>\n",
       "      <td>102</td>\n",
       "      <td>3578949</td>\n",
       "      <td>35087.735294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Telecommunications</th>\n",
       "      <td>15</td>\n",
       "      <td>461834</td>\n",
       "      <td>30788.933333</td>\n",
       "      <td>15</td>\n",
       "      <td>48637</td>\n",
       "      <td>3242.466667</td>\n",
       "      <td>15</td>\n",
       "      <td>832468</td>\n",
       "      <td>55497.866667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Transportation</th>\n",
       "      <td>36</td>\n",
       "      <td>408508</td>\n",
       "      <td>11347.444444</td>\n",
       "      <td>36</td>\n",
       "      <td>44169</td>\n",
       "      <td>1226.916667</td>\n",
       "      <td>36</td>\n",
       "      <td>1536793</td>\n",
       "      <td>42688.694444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wholesalers</th>\n",
       "      <td>40</td>\n",
       "      <td>444800</td>\n",
       "      <td>11120.000000</td>\n",
       "      <td>40</td>\n",
       "      <td>8233</td>\n",
       "      <td>205.825000</td>\n",
       "      <td>40</td>\n",
       "      <td>525597</td>\n",
       "      <td>13139.925000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Revenue                        Profits          \\\n",
       "                                size      sum          mean    size     sum   \n",
       "Sector                                                                        \n",
       "Aerospace & Defense               20   357940  17897.000000      20   28742   \n",
       "Apparel                           15    95968   6397.866667      15    8236   \n",
       "Business Services                 51   272195   5337.156863      51   28227   \n",
       "Chemicals                         30   243897   8129.900000      30   22628   \n",
       "Energy                           122  1517809  12441.057377     122  -73447   \n",
       "Engineering & Construction        26   153983   5922.423077      26    5304   \n",
       "Financials                       139  2217159  15950.784173     139  260209   \n",
       "Food and Drug Stores              15   483769  32251.266667      15   16759   \n",
       "Food, Beverages & Tobacco         43   555967  12929.465116      43   51417   \n",
       "Health Care                       75  1614707  21529.426667      75  106114   \n",
       "Hotels, Resturants & Leisure      25   169546   6781.840000      25   20697   \n",
       "Household Products                28   234737   8383.464286      28   14428   \n",
       "Industrials                       46   497581  10816.978261      46   20764   \n",
       "Materials                         43   259145   6026.627907      43    4428   \n",
       "Media                             25   220764   8830.560000      25   24347   \n",
       "Motor Vehicles & Parts            24   482540  20105.833333      24   25898   \n",
       "Retailing                         80  1465076  18313.450000      80   47830   \n",
       "Technology                       102  1377600  13505.882353     102  180473   \n",
       "Telecommunications                15   461834  30788.933333      15   48637   \n",
       "Transportation                    36   408508  11347.444444      36   44169   \n",
       "Wholesalers                       40   444800  11120.000000      40    8233   \n",
       "\n",
       "                                          Employees                         \n",
       "                                     mean      size      sum          mean  \n",
       "Sector                                                                      \n",
       "Aerospace & Defense           1437.100000        20   968057  48402.850000  \n",
       "Apparel                        549.066667        15   346397  23093.133333  \n",
       "Business Services              553.470588        51  1361050  26687.254902  \n",
       "Chemicals                      754.266667        30   463651  15455.033333  \n",
       "Energy                        -602.024590       122  1188927   9745.303279  \n",
       "Engineering & Construction     204.000000        26   406708  15642.615385  \n",
       "Financials                    1872.007194       139  3359948  24172.287770  \n",
       "Food and Drug Stores          1117.266667        15  1395398  93026.533333  \n",
       "Food, Beverages & Tobacco     1195.744186        43  1211632  28177.488372  \n",
       "Health Care                   1414.853333        75  2678289  35710.520000  \n",
       "Hotels, Resturants & Leisure   827.880000        25  2484245  99369.800000  \n",
       "Household Products             515.285714        28   646038  23072.785714  \n",
       "Industrials                    451.391304        46  1545229  33591.934783  \n",
       "Materials                      102.976744        43   638123  14840.069767  \n",
       "Media                          973.880000        25   550314  22012.560000  \n",
       "Motor Vehicles & Parts        1079.083333        24  1082560  45106.666667  \n",
       "Retailing                      597.875000        80  6227629  77845.362500  \n",
       "Technology                    1769.343137       102  3578949  35087.735294  \n",
       "Telecommunications            3242.466667        15   832468  55497.866667  \n",
       "Transportation                1226.916667        36  1536793  42688.694444  \n",
       "Wholesalers                    205.825000        40   525597  13139.925000  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sectors.agg(['size', 'sum', 'mean'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Iterating through Groups"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Walmart</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>General Merchandisers</td>\n",
       "      <td>Bentonville, AR</td>\n",
       "      <td>482130</td>\n",
       "      <td>14694</td>\n",
       "      <td>2300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Exxon Mobil</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Irving, TX</td>\n",
       "      <td>246204</td>\n",
       "      <td>16150</td>\n",
       "      <td>75600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computers, Office Equipment</td>\n",
       "      <td>Cupertino, CA</td>\n",
       "      <td>233715</td>\n",
       "      <td>53394</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Company      Sector                     Industry         Location  \\\n",
       "Rank                                                                          \n",
       "1         Walmart   Retailing        General Merchandisers  Bentonville, AR   \n",
       "2     Exxon Mobil      Energy           Petroleum Refining       Irving, TX   \n",
       "3           Apple  Technology  Computers, Office Equipment    Cupertino, CA   \n",
       "\n",
       "      Revenue  Profits  Employees  \n",
       "Rank                               \n",
       "1      482130    14694    2300000  \n",
       "2      246204    16150      75600  \n",
       "3      233715    53394     110000  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fortune = pd.read_csv('Fortune1000.csv', index_col = 'Rank')\n",
    "sectors = fortune.groupby('Sector')\n",
    "fortune.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Company, Sector, Industry, Location, Revenue, Profits, Employees]\n",
       "Index: []"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(columns = fortune.columns)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "for sector, data in sectors:\n",
    "    highest_revenue_company_in_group = data.nlargest(1, 'Revenue')\n",
    "    df = df.append(highest_revenue_company_in_group)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Boeing</td>\n",
       "      <td>Aerospace &amp; Defense</td>\n",
       "      <td>Aerospace and Defense</td>\n",
       "      <td>Chicago, IL</td>\n",
       "      <td>96114</td>\n",
       "      <td>5176</td>\n",
       "      <td>161400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Nike</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Beaverton, OR</td>\n",
       "      <td>30601</td>\n",
       "      <td>3273</td>\n",
       "      <td>62600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>ManpowerGroup</td>\n",
       "      <td>Business Services</td>\n",
       "      <td>Temporary Help</td>\n",
       "      <td>Milwaukee, WI</td>\n",
       "      <td>19330</td>\n",
       "      <td>419</td>\n",
       "      <td>27000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Dow Chemical</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Midland, MI</td>\n",
       "      <td>48778</td>\n",
       "      <td>7685</td>\n",
       "      <td>49495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Exxon Mobil</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Irving, TX</td>\n",
       "      <td>246204</td>\n",
       "      <td>16150</td>\n",
       "      <td>75600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>Fluor</td>\n",
       "      <td>Engineering &amp; Construction</td>\n",
       "      <td>Engineering, Construction</td>\n",
       "      <td>Irving, TX</td>\n",
       "      <td>18114</td>\n",
       "      <td>413</td>\n",
       "      <td>38758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Berkshire Hathaway</td>\n",
       "      <td>Financials</td>\n",
       "      <td>Insurance: Property and Casualty (Stock)</td>\n",
       "      <td>Omaha, NE</td>\n",
       "      <td>210821</td>\n",
       "      <td>24083</td>\n",
       "      <td>331000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CVS Health</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Woonsocket, RI</td>\n",
       "      <td>153290</td>\n",
       "      <td>5237</td>\n",
       "      <td>199000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Archer Daniels Midland</td>\n",
       "      <td>Food, Beverages &amp; Tobacco</td>\n",
       "      <td>Food Production</td>\n",
       "      <td>Chicago, IL</td>\n",
       "      <td>67702</td>\n",
       "      <td>1849</td>\n",
       "      <td>32300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>McKesson</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Wholesalers: Health Care</td>\n",
       "      <td>San Francisco, CA</td>\n",
       "      <td>181241</td>\n",
       "      <td>1476</td>\n",
       "      <td>70400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>McDonald’s</td>\n",
       "      <td>Hotels, Resturants &amp; Leisure</td>\n",
       "      <td>Food Services</td>\n",
       "      <td>Oak Brook, IL</td>\n",
       "      <td>25413</td>\n",
       "      <td>4529</td>\n",
       "      <td>420000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Procter &amp; Gamble</td>\n",
       "      <td>Household Products</td>\n",
       "      <td>Household and Personal Products</td>\n",
       "      <td>Cincinnati, OH</td>\n",
       "      <td>78756</td>\n",
       "      <td>7036</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>General Electric</td>\n",
       "      <td>Industrials</td>\n",
       "      <td>Industrial Machinery</td>\n",
       "      <td>Fairfield, CT</td>\n",
       "      <td>140389</td>\n",
       "      <td>-6126</td>\n",
       "      <td>333000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>Alcoa</td>\n",
       "      <td>Materials</td>\n",
       "      <td>Metals</td>\n",
       "      <td>New York, NY</td>\n",
       "      <td>22534</td>\n",
       "      <td>-322</td>\n",
       "      <td>60000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Disney</td>\n",
       "      <td>Media</td>\n",
       "      <td>Entertainment</td>\n",
       "      <td>Burbank, CA</td>\n",
       "      <td>52465</td>\n",
       "      <td>8382</td>\n",
       "      <td>185000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>General Motors</td>\n",
       "      <td>Motor Vehicles &amp; Parts</td>\n",
       "      <td>Motor Vehicles and Parts</td>\n",
       "      <td>Detroit, MI</td>\n",
       "      <td>152356</td>\n",
       "      <td>9687</td>\n",
       "      <td>215000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Walmart</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>General Merchandisers</td>\n",
       "      <td>Bentonville, AR</td>\n",
       "      <td>482130</td>\n",
       "      <td>14694</td>\n",
       "      <td>2300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computers, Office Equipment</td>\n",
       "      <td>Cupertino, CA</td>\n",
       "      <td>233715</td>\n",
       "      <td>53394</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AT&amp;T</td>\n",
       "      <td>Telecommunications</td>\n",
       "      <td>Telecommunications</td>\n",
       "      <td>Dallas, TX</td>\n",
       "      <td>146801</td>\n",
       "      <td>13345</td>\n",
       "      <td>281450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>UPS</td>\n",
       "      <td>Transportation</td>\n",
       "      <td>Mail, Package, and Freight Delivery</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>58363</td>\n",
       "      <td>4844</td>\n",
       "      <td>341240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Sysco</td>\n",
       "      <td>Wholesalers</td>\n",
       "      <td>Wholesalers: Food and Grocery</td>\n",
       "      <td>Houston, TX</td>\n",
       "      <td>48681</td>\n",
       "      <td>687</td>\n",
       "      <td>51700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Company                        Sector  \\\n",
       "24                   Boeing           Aerospace & Defense   \n",
       "91                     Nike                       Apparel   \n",
       "144           ManpowerGroup             Business Services   \n",
       "56             Dow Chemical                     Chemicals   \n",
       "2               Exxon Mobil                        Energy   \n",
       "155                   Fluor    Engineering & Construction   \n",
       "4        Berkshire Hathaway                    Financials   \n",
       "7                CVS Health          Food and Drug Stores   \n",
       "41   Archer Daniels Midland     Food, Beverages & Tobacco   \n",
       "5                  McKesson                   Health Care   \n",
       "109              McDonald’s  Hotels, Resturants & Leisure   \n",
       "34         Procter & Gamble            Household Products   \n",
       "11         General Electric                   Industrials   \n",
       "126                   Alcoa                     Materials   \n",
       "53                   Disney                         Media   \n",
       "8            General Motors        Motor Vehicles & Parts   \n",
       "1                   Walmart                     Retailing   \n",
       "3                     Apple                    Technology   \n",
       "10                     AT&T            Telecommunications   \n",
       "48                      UPS                Transportation   \n",
       "57                    Sysco                   Wholesalers   \n",
       "\n",
       "                                     Industry           Location Revenue  \\\n",
       "24                      Aerospace and Defense        Chicago, IL   96114   \n",
       "91                                    Apparel      Beaverton, OR   30601   \n",
       "144                            Temporary Help      Milwaukee, WI   19330   \n",
       "56                                  Chemicals        Midland, MI   48778   \n",
       "2                          Petroleum Refining         Irving, TX  246204   \n",
       "155                 Engineering, Construction         Irving, TX   18114   \n",
       "4    Insurance: Property and Casualty (Stock)          Omaha, NE  210821   \n",
       "7                        Food and Drug Stores     Woonsocket, RI  153290   \n",
       "41                            Food Production        Chicago, IL   67702   \n",
       "5                    Wholesalers: Health Care  San Francisco, CA  181241   \n",
       "109                             Food Services      Oak Brook, IL   25413   \n",
       "34            Household and Personal Products     Cincinnati, OH   78756   \n",
       "11                       Industrial Machinery      Fairfield, CT  140389   \n",
       "126                                    Metals       New York, NY   22534   \n",
       "53                              Entertainment        Burbank, CA   52465   \n",
       "8                    Motor Vehicles and Parts        Detroit, MI  152356   \n",
       "1                       General Merchandisers    Bentonville, AR  482130   \n",
       "3                 Computers, Office Equipment      Cupertino, CA  233715   \n",
       "10                         Telecommunications         Dallas, TX  146801   \n",
       "48        Mail, Package, and Freight Delivery        Atlanta, GA   58363   \n",
       "57              Wholesalers: Food and Grocery        Houston, TX   48681   \n",
       "\n",
       "    Profits Employees  \n",
       "24     5176    161400  \n",
       "91     3273     62600  \n",
       "144     419     27000  \n",
       "56     7685     49495  \n",
       "2     16150     75600  \n",
       "155     413     38758  \n",
       "4     24083    331000  \n",
       "7      5237    199000  \n",
       "41     1849     32300  \n",
       "5      1476     70400  \n",
       "109    4529    420000  \n",
       "34     7036    110000  \n",
       "11    -6126    333000  \n",
       "126    -322     60000  \n",
       "53     8382    185000  \n",
       "8      9687    215000  \n",
       "1     14694   2300000  \n",
       "3     53394    110000  \n",
       "10    13345    281450  \n",
       "48     4844    341240  \n",
       "57      687     51700  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Company, Sector, Industry, Location, Revenue, Profits, Employees]\n",
       "Index: []"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cities = fortune.groupby('Location')\n",
    "df = pd.DataFrame(columns = fortune.columns)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "for city, data in cities:\n",
    "    highest_revenue_in_city = data.nlargest(1, 'Revenue')\n",
    "    df = df.append(highest_revenue_in_city)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Location</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Profits</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>Abbott Laboratories</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Medical Products and Equipment</td>\n",
       "      <td>Abbott Park, IL</td>\n",
       "      <td>20661</td>\n",
       "      <td>4423</td>\n",
       "      <td>74000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>Goodyear Tire &amp; Rubber</td>\n",
       "      <td>Motor Vehicles &amp; Parts</td>\n",
       "      <td>Motor Vehicles and Parts</td>\n",
       "      <td>Akron, OH</td>\n",
       "      <td>16443</td>\n",
       "      <td>307</td>\n",
       "      <td>66000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>Air Products &amp; Chemicals</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Allentown, PA</td>\n",
       "      <td>9895</td>\n",
       "      <td>1278</td>\n",
       "      <td>19550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>830</th>\n",
       "      <td>Benchmark Electronics</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Semiconductors and Other Electronic Components</td>\n",
       "      <td>Angleton, TX</td>\n",
       "      <td>2541</td>\n",
       "      <td>95</td>\n",
       "      <td>10500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>Casey’s General Stores</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>Specialty Retailers: Other</td>\n",
       "      <td>Ankeny, IA</td>\n",
       "      <td>7052</td>\n",
       "      <td>181</td>\n",
       "      <td>22408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>Domino’s Pizza</td>\n",
       "      <td>Hotels, Resturants &amp; Leisure</td>\n",
       "      <td>Food Services</td>\n",
       "      <td>Ann Arbor, MI</td>\n",
       "      <td>2217</td>\n",
       "      <td>193</td>\n",
       "      <td>11900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>596</th>\n",
       "      <td>Colfax</td>\n",
       "      <td>Industrials</td>\n",
       "      <td>Industrial Machinery</td>\n",
       "      <td>Annapolis Junction, MD</td>\n",
       "      <td>3967</td>\n",
       "      <td>168</td>\n",
       "      <td>17087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>Land O’Lakes</td>\n",
       "      <td>Food, Beverages &amp; Tobacco</td>\n",
       "      <td>Food Consumer Products</td>\n",
       "      <td>Arden Hills, MN</td>\n",
       "      <td>13161</td>\n",
       "      <td>308</td>\n",
       "      <td>10000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>AES</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Utilities: Gas and Electric</td>\n",
       "      <td>Arlington, VA</td>\n",
       "      <td>14963</td>\n",
       "      <td>306</td>\n",
       "      <td>21000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>IBM</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Information Technology Services</td>\n",
       "      <td>Armonk, NY</td>\n",
       "      <td>82461</td>\n",
       "      <td>13190</td>\n",
       "      <td>411798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Home Depot</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>Specialty Retailers: Other</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>88519</td>\n",
       "      <td>7009</td>\n",
       "      <td>385000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>Autoliv</td>\n",
       "      <td>Motor Vehicles &amp; Parts</td>\n",
       "      <td>Motor Vehicles and Parts</td>\n",
       "      <td>Auburn Hills, MI</td>\n",
       "      <td>9170</td>\n",
       "      <td>457</td>\n",
       "      <td>59350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>Hormel Foods</td>\n",
       "      <td>Food, Beverages &amp; Tobacco</td>\n",
       "      <td>Food Consumer Products</td>\n",
       "      <td>Austin, MN</td>\n",
       "      <td>9264</td>\n",
       "      <td>686</td>\n",
       "      <td>20700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Whole Foods Market</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Austin, TX</td>\n",
       "      <td>15389</td>\n",
       "      <td>536</td>\n",
       "      <td>76300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>PolyOne</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Avon Lake, OH</td>\n",
       "      <td>3378</td>\n",
       "      <td>145</td>\n",
       "      <td>6900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>573</th>\n",
       "      <td>T. Rowe Price</td>\n",
       "      <td>Financials</td>\n",
       "      <td>Securities</td>\n",
       "      <td>Baltimore, MD</td>\n",
       "      <td>4201</td>\n",
       "      <td>1223</td>\n",
       "      <td>5999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>Baxalta</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Pharmaceuticals</td>\n",
       "      <td>Bannockburn, IL</td>\n",
       "      <td>6149</td>\n",
       "      <td>956</td>\n",
       "      <td>17000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>Albemarle</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Baton Rouge, LA</td>\n",
       "      <td>3651</td>\n",
       "      <td>335</td>\n",
       "      <td>6963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>Kellogg</td>\n",
       "      <td>Food, Beverages &amp; Tobacco</td>\n",
       "      <td>Food Consumer Products</td>\n",
       "      <td>Battle Creek, MI</td>\n",
       "      <td>13525</td>\n",
       "      <td>614</td>\n",
       "      <td>33577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Nike</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Apparel</td>\n",
       "      <td>Beaverton, OR</td>\n",
       "      <td>30601</td>\n",
       "      <td>3273</td>\n",
       "      <td>62600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>Paccar</td>\n",
       "      <td>Motor Vehicles &amp; Parts</td>\n",
       "      <td>Motor Vehicles and Parts</td>\n",
       "      <td>Bellevue, WA</td>\n",
       "      <td>19115</td>\n",
       "      <td>1604</td>\n",
       "      <td>23000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>645</th>\n",
       "      <td>Regal Beloit</td>\n",
       "      <td>Industrials</td>\n",
       "      <td>Electronics, Electrical Equip.</td>\n",
       "      <td>Beloit, WI</td>\n",
       "      <td>3510</td>\n",
       "      <td>143</td>\n",
       "      <td>26200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>Whirlpool</td>\n",
       "      <td>Industrials</td>\n",
       "      <td>Electronics, Electrical Equip.</td>\n",
       "      <td>Benton Harbor, MI</td>\n",
       "      <td>20891</td>\n",
       "      <td>783</td>\n",
       "      <td>97000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Walmart</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>General Merchandisers</td>\n",
       "      <td>Bentonville, AR</td>\n",
       "      <td>482130</td>\n",
       "      <td>14694</td>\n",
       "      <td>2300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>Ametek</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Scientific,Photographic and Control Equipment</td>\n",
       "      <td>Berwyn, PA</td>\n",
       "      <td>3974</td>\n",
       "      <td>591</td>\n",
       "      <td>15400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Lockheed Martin</td>\n",
       "      <td>Aerospace &amp; Defense</td>\n",
       "      <td>Aerospace and Defense</td>\n",
       "      <td>Bethesda, MD</td>\n",
       "      <td>46132</td>\n",
       "      <td>3605</td>\n",
       "      <td>126000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>Cablevision Systems</td>\n",
       "      <td>Telecommunications</td>\n",
       "      <td>Telecommunications</td>\n",
       "      <td>Bethpage, NY</td>\n",
       "      <td>6510</td>\n",
       "      <td>175</td>\n",
       "      <td>13549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>Live Nation Entertainment</td>\n",
       "      <td>Media</td>\n",
       "      <td>Entertainment</td>\n",
       "      <td>Beverly Hills, CA</td>\n",
       "      <td>7246</td>\n",
       "      <td>-33</td>\n",
       "      <td>12200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>Regions Financial</td>\n",
       "      <td>Financials</td>\n",
       "      <td>Commercial Banks</td>\n",
       "      <td>Birmingham, AL</td>\n",
       "      <td>5674</td>\n",
       "      <td>1062</td>\n",
       "      <td>23916</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>558</th>\n",
       "      <td>MDU Resources Group</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Bismarck, ND</td>\n",
       "      <td>4376</td>\n",
       "      <td>-622</td>\n",
       "      <td>8689</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>Raytheon</td>\n",
       "      <td>Aerospace &amp; Defense</td>\n",
       "      <td>Aerospace and Defense</td>\n",
       "      <td>Waltham, MA</td>\n",
       "      <td>23247</td>\n",
       "      <td>2074</td>\n",
       "      <td>61000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>United Refining</td>\n",
       "      <td>Energy</td>\n",
       "      <td>Petroleum Refining</td>\n",
       "      <td>Warren, PA</td>\n",
       "      <td>2470</td>\n",
       "      <td>82</td>\n",
       "      <td>2997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>Zimmer Biomet Holdings</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Medical Products and Equipment</td>\n",
       "      <td>Warsaw, IN</td>\n",
       "      <td>5998</td>\n",
       "      <td>147</td>\n",
       "      <td>17500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Fannie Mae</td>\n",
       "      <td>Financials</td>\n",
       "      <td>Diversified Financials</td>\n",
       "      <td>Washington, DC</td>\n",
       "      <td>110359</td>\n",
       "      <td>10954</td>\n",
       "      <td>7300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>542</th>\n",
       "      <td>Keurig Green Mountain</td>\n",
       "      <td>Food, Beverages &amp; Tobacco</td>\n",
       "      <td>Beverages</td>\n",
       "      <td>Waterbury, VT</td>\n",
       "      <td>4520</td>\n",
       "      <td>498</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>898</th>\n",
       "      <td>MPM Holdings</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Waterford, NY</td>\n",
       "      <td>2289</td>\n",
       "      <td>-83</td>\n",
       "      <td>5000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>874</th>\n",
       "      <td>Granite Construction</td>\n",
       "      <td>Engineering &amp; Construction</td>\n",
       "      <td>Engineering, Construction</td>\n",
       "      <td>Watsonville, CA</td>\n",
       "      <td>2371</td>\n",
       "      <td>61</td>\n",
       "      <td>3200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1000</th>\n",
       "      <td>Briggs &amp; Stratton</td>\n",
       "      <td>Industrials</td>\n",
       "      <td>Industrial Machinery</td>\n",
       "      <td>Wauwatosa, WI</td>\n",
       "      <td>1895</td>\n",
       "      <td>46</td>\n",
       "      <td>5480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>Toys “R” Us</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>Specialty Retailers: Other</td>\n",
       "      <td>Wayne, NJ</td>\n",
       "      <td>11802</td>\n",
       "      <td>-130</td>\n",
       "      <td>62000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>785</th>\n",
       "      <td>B/E Aerospace</td>\n",
       "      <td>Aerospace &amp; Defense</td>\n",
       "      <td>Aerospace and Defense</td>\n",
       "      <td>Wellington, FL</td>\n",
       "      <td>2730</td>\n",
       "      <td>286</td>\n",
       "      <td>10057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>AK Steel Holding</td>\n",
       "      <td>Materials</td>\n",
       "      <td>Metals</td>\n",
       "      <td>West Chester, OH</td>\n",
       "      <td>6693</td>\n",
       "      <td>-509</td>\n",
       "      <td>8500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>Platform Specialty Products</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>West Palm Beach, FL</td>\n",
       "      <td>2542</td>\n",
       "      <td>-309</td>\n",
       "      <td>8200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>New York Community Bancorp</td>\n",
       "      <td>Financials</td>\n",
       "      <td>Commercial Banks</td>\n",
       "      <td>Westbury, NY</td>\n",
       "      <td>1902</td>\n",
       "      <td>-47</td>\n",
       "      <td>3448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>Ingredion</td>\n",
       "      <td>Food, Beverages &amp; Tobacco</td>\n",
       "      <td>Food Production</td>\n",
       "      <td>Westchester, IL</td>\n",
       "      <td>5621</td>\n",
       "      <td>402</td>\n",
       "      <td>11500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>TravelCenters of America</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>Specialty Retailers: Other</td>\n",
       "      <td>Westlake, OH</td>\n",
       "      <td>5851</td>\n",
       "      <td>28</td>\n",
       "      <td>18450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>Terex</td>\n",
       "      <td>Industrials</td>\n",
       "      <td>Construction and Farm Machinery</td>\n",
       "      <td>Westport, CT</td>\n",
       "      <td>6543</td>\n",
       "      <td>146</td>\n",
       "      <td>20400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>847</th>\n",
       "      <td>ITT</td>\n",
       "      <td>Industrials</td>\n",
       "      <td>Industrial Machinery</td>\n",
       "      <td>White Plains, NY</td>\n",
       "      <td>2486</td>\n",
       "      <td>352</td>\n",
       "      <td>9700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>Spirit AeroSystems Holdings</td>\n",
       "      <td>Aerospace &amp; Defense</td>\n",
       "      <td>Aerospace and Defense</td>\n",
       "      <td>Wichita, KS</td>\n",
       "      <td>6644</td>\n",
       "      <td>789</td>\n",
       "      <td>15200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>849</th>\n",
       "      <td>Tops Holding</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Williamsville, NY</td>\n",
       "      <td>2472</td>\n",
       "      <td>-62</td>\n",
       "      <td>14800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>674</th>\n",
       "      <td>Westinghouse Air Brake Technologies</td>\n",
       "      <td>Industrials</td>\n",
       "      <td>Industrial Machinery</td>\n",
       "      <td>Wilmerding, PA</td>\n",
       "      <td>3308</td>\n",
       "      <td>399</td>\n",
       "      <td>13000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>DuPont</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Chemicals</td>\n",
       "      <td>Wilmington, DE</td>\n",
       "      <td>27940</td>\n",
       "      <td>1953</td>\n",
       "      <td>52000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>607</th>\n",
       "      <td>Fastenal</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>Specialty Retailers: Other</td>\n",
       "      <td>Winona, MN</td>\n",
       "      <td>3869</td>\n",
       "      <td>516</td>\n",
       "      <td>20746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>Reynolds American</td>\n",
       "      <td>Food, Beverages &amp; Tobacco</td>\n",
       "      <td>Tobacco</td>\n",
       "      <td>Winston-Salem, NC</td>\n",
       "      <td>10675</td>\n",
       "      <td>3253</td>\n",
       "      <td>5650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>678</th>\n",
       "      <td>Skyworks Solutions</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Semiconductors and Other Electronic Components</td>\n",
       "      <td>Woburn, MA</td>\n",
       "      <td>3258</td>\n",
       "      <td>798</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>Health Net</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care: Insurance and Managed Care</td>\n",
       "      <td>Woodland Hills, CA</td>\n",
       "      <td>16244</td>\n",
       "      <td>186</td>\n",
       "      <td>8584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CVS Health</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Food and Drug Stores</td>\n",
       "      <td>Woonsocket, RI</td>\n",
       "      <td>153290</td>\n",
       "      <td>5237</td>\n",
       "      <td>199000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>Hanover Insurance Group</td>\n",
       "      <td>Financials</td>\n",
       "      <td>Insurance: Property and Casualty (Stock)</td>\n",
       "      <td>Worcester, MA</td>\n",
       "      <td>5034</td>\n",
       "      <td>332</td>\n",
       "      <td>4800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>764</th>\n",
       "      <td>Penn National Gaming</td>\n",
       "      <td>Hotels, Resturants &amp; Leisure</td>\n",
       "      <td>Hotels, Casinos, Resorts</td>\n",
       "      <td>Wyomissing, PA</td>\n",
       "      <td>2838</td>\n",
       "      <td>1</td>\n",
       "      <td>18204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>773</th>\n",
       "      <td>Bon-Ton Stores</td>\n",
       "      <td>Retailing</td>\n",
       "      <td>General Merchandisers</td>\n",
       "      <td>York, PA</td>\n",
       "      <td>2790</td>\n",
       "      <td>-57</td>\n",
       "      <td>24100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932</th>\n",
       "      <td>Herman Miller</td>\n",
       "      <td>Household Products</td>\n",
       "      <td>Home Equipment, Furnishings</td>\n",
       "      <td>Zeeland, MI</td>\n",
       "      <td>2142</td>\n",
       "      <td>98</td>\n",
       "      <td>7510</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>416 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Company                        Sector  \\\n",
       "138                   Abbott Laboratories                   Health Care   \n",
       "169                Goodyear Tire & Rubber        Motor Vehicles & Parts   \n",
       "288              Air Products & Chemicals                     Chemicals   \n",
       "830                 Benchmark Electronics                    Technology   \n",
       "374                Casey’s General Stores                     Retailing   \n",
       "915                        Domino’s Pizza  Hotels, Resturants & Leisure   \n",
       "596                                Colfax                   Industrials   \n",
       "215                          Land O’Lakes     Food, Beverages & Tobacco   \n",
       "190                                   AES                        Energy   \n",
       "31                                    IBM                    Technology   \n",
       "28                             Home Depot                     Retailing   \n",
       "310                               Autoliv        Motor Vehicles & Parts   \n",
       "304                          Hormel Foods     Food, Beverages & Tobacco   \n",
       "181                    Whole Foods Market          Food and Drug Stores   \n",
       "668                               PolyOne                     Chemicals   \n",
       "573                         T. Rowe Price                    Financials   \n",
       "420                               Baxalta                   Health Care   \n",
       "624                             Albemarle                     Chemicals   \n",
       "207                               Kellogg     Food, Beverages & Tobacco   \n",
       "91                                   Nike                       Apparel   \n",
       "147                                Paccar        Motor Vehicles & Parts   \n",
       "645                          Regal Beloit                   Industrials   \n",
       "134                             Whirlpool                   Industrials   \n",
       "1                                 Walmart                     Retailing   \n",
       "594                                Ametek                    Technology   \n",
       "60                        Lockheed Martin           Aerospace & Defense   \n",
       "399                   Cablevision Systems            Telecommunications   \n",
       "366             Live Nation Entertainment                         Media   \n",
       "453                     Regions Financial                    Financials   \n",
       "558                   MDU Resources Group                        Energy   \n",
       "...                                   ...                           ...   \n",
       "120                              Raytheon           Aerospace & Defense   \n",
       "850                       United Refining                        Energy   \n",
       "431                Zimmer Biomet Holdings                   Health Care   \n",
       "16                             Fannie Mae                    Financials   \n",
       "542                 Keurig Green Mountain     Food, Beverages & Tobacco   \n",
       "898                          MPM Holdings                     Chemicals   \n",
       "874                  Granite Construction    Engineering & Construction   \n",
       "1000                    Briggs & Stratton                   Industrials   \n",
       "240                           Toys “R” Us                     Retailing   \n",
       "785                         B/E Aerospace           Aerospace & Defense   \n",
       "383                      AK Steel Holding                     Materials   \n",
       "829           Platform Specialty Products                     Chemicals   \n",
       "996            New York Community Bancorp                    Financials   \n",
       "456                             Ingredion     Food, Beverages & Tobacco   \n",
       "439              TravelCenters of America                     Retailing   \n",
       "396                                 Terex                   Industrials   \n",
       "847                                   ITT                   Industrials   \n",
       "389           Spirit AeroSystems Holdings           Aerospace & Defense   \n",
       "849                          Tops Holding          Food and Drug Stores   \n",
       "674   Westinghouse Air Brake Technologies                   Industrials   \n",
       "101                                DuPont                     Chemicals   \n",
       "607                              Fastenal                     Retailing   \n",
       "266                     Reynolds American     Food, Beverages & Tobacco   \n",
       "678                    Skyworks Solutions                    Technology   \n",
       "172                            Health Net                   Health Care   \n",
       "7                              CVS Health          Food and Drug Stores   \n",
       "506               Hanover Insurance Group                    Financials   \n",
       "764                  Penn National Gaming  Hotels, Resturants & Leisure   \n",
       "773                        Bon-Ton Stores                     Retailing   \n",
       "932                         Herman Miller            Household Products   \n",
       "\n",
       "                                            Industry                Location  \\\n",
       "138                   Medical Products and Equipment         Abbott Park, IL   \n",
       "169                         Motor Vehicles and Parts               Akron, OH   \n",
       "288                                        Chemicals           Allentown, PA   \n",
       "830   Semiconductors and Other Electronic Components            Angleton, TX   \n",
       "374                       Specialty Retailers: Other              Ankeny, IA   \n",
       "915                                    Food Services           Ann Arbor, MI   \n",
       "596                             Industrial Machinery  Annapolis Junction, MD   \n",
       "215                           Food Consumer Products         Arden Hills, MN   \n",
       "190                      Utilities: Gas and Electric           Arlington, VA   \n",
       "31                   Information Technology Services              Armonk, NY   \n",
       "28                        Specialty Retailers: Other             Atlanta, GA   \n",
       "310                         Motor Vehicles and Parts        Auburn Hills, MI   \n",
       "304                           Food Consumer Products              Austin, MN   \n",
       "181                             Food and Drug Stores              Austin, TX   \n",
       "668                                        Chemicals           Avon Lake, OH   \n",
       "573                                       Securities           Baltimore, MD   \n",
       "420                                  Pharmaceuticals         Bannockburn, IL   \n",
       "624                                        Chemicals         Baton Rouge, LA   \n",
       "207                           Food Consumer Products        Battle Creek, MI   \n",
       "91                                           Apparel           Beaverton, OR   \n",
       "147                         Motor Vehicles and Parts            Bellevue, WA   \n",
       "645                   Electronics, Electrical Equip.              Beloit, WI   \n",
       "134                   Electronics, Electrical Equip.       Benton Harbor, MI   \n",
       "1                              General Merchandisers         Bentonville, AR   \n",
       "594    Scientific,Photographic and Control Equipment              Berwyn, PA   \n",
       "60                             Aerospace and Defense            Bethesda, MD   \n",
       "399                               Telecommunications            Bethpage, NY   \n",
       "366                                    Entertainment       Beverly Hills, CA   \n",
       "453                                 Commercial Banks          Birmingham, AL   \n",
       "558                                           Energy            Bismarck, ND   \n",
       "...                                              ...                     ...   \n",
       "120                            Aerospace and Defense             Waltham, MA   \n",
       "850                               Petroleum Refining              Warren, PA   \n",
       "431                   Medical Products and Equipment              Warsaw, IN   \n",
       "16                            Diversified Financials          Washington, DC   \n",
       "542                                        Beverages           Waterbury, VT   \n",
       "898                                        Chemicals           Waterford, NY   \n",
       "874                        Engineering, Construction         Watsonville, CA   \n",
       "1000                            Industrial Machinery           Wauwatosa, WI   \n",
       "240                       Specialty Retailers: Other               Wayne, NJ   \n",
       "785                            Aerospace and Defense          Wellington, FL   \n",
       "383                                           Metals        West Chester, OH   \n",
       "829                                        Chemicals     West Palm Beach, FL   \n",
       "996                                 Commercial Banks            Westbury, NY   \n",
       "456                                  Food Production         Westchester, IL   \n",
       "439                       Specialty Retailers: Other            Westlake, OH   \n",
       "396                  Construction and Farm Machinery            Westport, CT   \n",
       "847                             Industrial Machinery        White Plains, NY   \n",
       "389                            Aerospace and Defense             Wichita, KS   \n",
       "849                             Food and Drug Stores       Williamsville, NY   \n",
       "674                             Industrial Machinery          Wilmerding, PA   \n",
       "101                                        Chemicals          Wilmington, DE   \n",
       "607                       Specialty Retailers: Other              Winona, MN   \n",
       "266                                          Tobacco       Winston-Salem, NC   \n",
       "678   Semiconductors and Other Electronic Components              Woburn, MA   \n",
       "172          Health Care: Insurance and Managed Care      Woodland Hills, CA   \n",
       "7                               Food and Drug Stores          Woonsocket, RI   \n",
       "506         Insurance: Property and Casualty (Stock)           Worcester, MA   \n",
       "764                         Hotels, Casinos, Resorts          Wyomissing, PA   \n",
       "773                            General Merchandisers                York, PA   \n",
       "932                      Home Equipment, Furnishings             Zeeland, MI   \n",
       "\n",
       "     Revenue Profits Employees  \n",
       "138    20661    4423     74000  \n",
       "169    16443     307     66000  \n",
       "288     9895    1278     19550  \n",
       "830     2541      95     10500  \n",
       "374     7052     181     22408  \n",
       "915     2217     193     11900  \n",
       "596     3967     168     17087  \n",
       "215    13161     308     10000  \n",
       "190    14963     306     21000  \n",
       "31     82461   13190    411798  \n",
       "28     88519    7009    385000  \n",
       "310     9170     457     59350  \n",
       "304     9264     686     20700  \n",
       "181    15389     536     76300  \n",
       "668     3378     145      6900  \n",
       "573     4201    1223      5999  \n",
       "420     6149     956     17000  \n",
       "624     3651     335      6963  \n",
       "207    13525     614     33577  \n",
       "91     30601    3273     62600  \n",
       "147    19115    1604     23000  \n",
       "645     3510     143     26200  \n",
       "134    20891     783     97000  \n",
       "1     482130   14694   2300000  \n",
       "594     3974     591     15400  \n",
       "60     46132    3605    126000  \n",
       "399     6510     175     13549  \n",
       "366     7246     -33     12200  \n",
       "453     5674    1062     23916  \n",
       "558     4376    -622      8689  \n",
       "...      ...     ...       ...  \n",
       "120    23247    2074     61000  \n",
       "850     2470      82      2997  \n",
       "431     5998     147     17500  \n",
       "16    110359   10954      7300  \n",
       "542     4520     498      6000  \n",
       "898     2289     -83      5000  \n",
       "874     2371      61      3200  \n",
       "1000    1895      46      5480  \n",
       "240    11802    -130     62000  \n",
       "785     2730     286     10057  \n",
       "383     6693    -509      8500  \n",
       "829     2542    -309      8200  \n",
       "996     1902     -47      3448  \n",
       "456     5621     402     11500  \n",
       "439     5851      28     18450  \n",
       "396     6543     146     20400  \n",
       "847     2486     352      9700  \n",
       "389     6644     789     15200  \n",
       "849     2472     -62     14800  \n",
       "674     3308     399     13000  \n",
       "101    27940    1953     52000  \n",
       "607     3869     516     20746  \n",
       "266    10675    3253      5650  \n",
       "678     3258     798      6700  \n",
       "172    16244     186      8584  \n",
       "7     153290    5237    199000  \n",
       "506     5034     332      4800  \n",
       "764     2838       1     18204  \n",
       "773     2790     -57     24100  \n",
       "932     2142      98      7510  \n",
       "\n",
       "[416 rows x 7 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}