1-business-questions.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "3e6ec0f8",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f9d2222a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('fortune_2000_in_2021.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ea54d35e",
   "metadata": {},
   "source": [
    "- **Here is the dataframe we will be cleaning, transforming and creating new columns and visualizations from.**\n",
    "- **The dataframe is based on the Fortune 2000 list for 2021**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "84817f41",
   "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>Rank</th>\n",
       "      <th>Name</th>\n",
       "      <th>Country</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Assets</th>\n",
       "      <th>Market Value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>ICBC</td>\n",
       "      <td>China</td>\n",
       "      <td>$190.5 B</td>\n",
       "      <td>$45.8 B</td>\n",
       "      <td>$4,914.7 B</td>\n",
       "      <td>$249.5 B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>JPMorgan Chase</td>\n",
       "      <td>United States</td>\n",
       "      <td>$136.2 B</td>\n",
       "      <td>$40.4 B</td>\n",
       "      <td>$3,689.3 B</td>\n",
       "      <td>$464.8 B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Berkshire Hathaway</td>\n",
       "      <td>United States</td>\n",
       "      <td>$245.5 B</td>\n",
       "      <td>$42.5 B</td>\n",
       "      <td>$873.7 B</td>\n",
       "      <td>$624.4 B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>China Construction Bank</td>\n",
       "      <td>China</td>\n",
       "      <td>$173.5 B</td>\n",
       "      <td>$39.3 B</td>\n",
       "      <td>$4,301.7 B</td>\n",
       "      <td>$210.4 B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Saudi Arabian Oil Company (Saudi Aramco)</td>\n",
       "      <td>Saudi Arabia</td>\n",
       "      <td>$229.7 B</td>\n",
       "      <td>$49.3 B</td>\n",
       "      <td>$510.3 B</td>\n",
       "      <td>$1,897.2 B</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>1995</th>\n",
       "      <td>1996</td>\n",
       "      <td>JTEKT</td>\n",
       "      <td>Japan</td>\n",
       "      <td>$13.1 B</td>\n",
       "      <td>$-34.9 M</td>\n",
       "      <td>$12 B</td>\n",
       "      <td>$3.5 B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>1997</td>\n",
       "      <td>Insurance Australia Group</td>\n",
       "      <td>Australia</td>\n",
       "      <td>$5.4 B</td>\n",
       "      <td>$-212 M</td>\n",
       "      <td>$25 B</td>\n",
       "      <td>$9.3 B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>1997</td>\n",
       "      <td>Sumec Corporation</td>\n",
       "      <td>China</td>\n",
       "      <td>$13 B</td>\n",
       "      <td>$79.2 M</td>\n",
       "      <td>$7.1 B</td>\n",
       "      <td>$1.3 B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>1999</td>\n",
       "      <td>Gold Fields</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>$3.9 B</td>\n",
       "      <td>$718.1 M</td>\n",
       "      <td>$7.5 B</td>\n",
       "      <td>$8.9 B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>1999</td>\n",
       "      <td>Paycom</td>\n",
       "      <td>United States</td>\n",
       "      <td>$841 M</td>\n",
       "      <td>$143.4 M</td>\n",
       "      <td>$2.6 B</td>\n",
       "      <td>$24 B</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2000 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Rank                                      Name        Country     Sales  \\\n",
       "0        1                                      ICBC          China  $190.5 B   \n",
       "1        2                            JPMorgan Chase  United States  $136.2 B   \n",
       "2        3                        Berkshire Hathaway  United States  $245.5 B   \n",
       "3        4                   China Construction Bank          China  $173.5 B   \n",
       "4        5  Saudi Arabian Oil Company (Saudi Aramco)   Saudi Arabia  $229.7 B   \n",
       "...    ...                                       ...            ...       ...   \n",
       "1995  1996                                     JTEKT          Japan   $13.1 B   \n",
       "1996  1997                 Insurance Australia Group      Australia    $5.4 B   \n",
       "1997  1997                         Sumec Corporation          China     $13 B   \n",
       "1998  1999                               Gold Fields   South Africa    $3.9 B   \n",
       "1999  1999                                    Paycom  United States    $841 M   \n",
       "\n",
       "        Profit      Assets Market Value  \n",
       "0      $45.8 B  $4,914.7 B     $249.5 B  \n",
       "1      $40.4 B  $3,689.3 B     $464.8 B  \n",
       "2      $42.5 B    $873.7 B     $624.4 B  \n",
       "3      $39.3 B  $4,301.7 B     $210.4 B  \n",
       "4      $49.3 B    $510.3 B   $1,897.2 B  \n",
       "...        ...         ...          ...  \n",
       "1995  $-34.9 M       $12 B       $3.5 B  \n",
       "1996   $-212 M       $25 B       $9.3 B  \n",
       "1997   $79.2 M      $7.1 B       $1.3 B  \n",
       "1998  $718.1 M      $7.5 B       $8.9 B  \n",
       "1999  $143.4 M      $2.6 B        $24 B  \n",
       "\n",
       "[2000 rows x 7 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f3c01fea",
   "metadata": {},
   "source": [
    "# Business Questions"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe001436",
   "metadata": {},
   "source": [
    "**The questions below focus on 3 areas of interest**\n",
    "- Countries - which countries appear most in the list for various metrics.\n",
    "- Overall profit, average company profit per country and profit to sales comparison.\n",
    "- Assets - which companies have the most assets.\n",
    "\n",
    "**BY COUNTRY**\n",
    "\n",
    "1. Which countries have the highest number of companies in the list?\n",
    "2. What share of companies on the list do the big two (USA and China) have in comparison to the rest of the world?\n",
    "3. Which countries have the highest number of companies in the list that turned a profit in 2021?\n",
    "4. Which countries have the fewest number of companies in the list that turned a profit in 2021?\n",
    "5. What are the top 20 countries based on average profit per company in the list?\n",
    "\n",
    "**BY PROFIT TO SALES**\n",
    "\n",
    "6. Of the 10 most profitable companies, which have the best profit to sales ratio?\n",
    "\n",
    "**BY ASSETS**\n",
    "\n",
    "7. What are the top 20 companies in terms of assets?"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}