notebooks/usgov-import-export.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Learn about world trade by looking at US Census import / export data\n",
    "\n",
    "## Why this data is interesting\n",
    "\n",
    "The US government keeps very detailed records on all goods being import or exported from the United States.\n",
    "\n",
    "Want to estimate the size of a world market or see if it's growing or shrinking?\n",
    "\n",
    "Want to find the best place in the world to manufacture a particular product?.. or get a sense of how much importers are paying for the goods they wholesale? This dataset can give you a lot of valuable and interesting insights into how the world economy works.\n",
    "\n",
    "It's also super easy to access and it's government data. It's pretty darn clean!\n",
    "\n",
    "## Ideas for questions this data can help you answer\n",
    "\n",
    "* Where is the best place in the world to have a particular type of product manufactured?\n",
    "* What kinds of products are Americans buying?\n",
    "* Where are they importing goods from?\n",
    "* What do they sell and where do they sell to?\n",
    "* How much do products cost before they get marked up?\n",
    "\n",
    "## Where you can go to get this kind of data\n",
    "\n",
    "This data is available through the US census beaureau's website.\n",
    "\n",
    "https://usatrade.census.gov/index.php\n",
    "\n",
    "They also provide access to it via API!!!\n",
    "\n",
    "https://www.census.gov/developers/\n",
    "\n",
    "The data is super easy to work with. Definitely worth checking out.\n",
    "\n",
    "## This is a sample of what data might look like\n",
    "\n",
    "In this case we're looking at US imports of antiques (broken down into sub-categories) grouped by year."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Commodity</th>\n",
       "      <th>\"2009\"</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "      <th>2013</th>\n",
       "      <th>2014</th>\n",
       "      <th>2015</th>\n",
       "      <th>2016</th>\n",
       "      <th>2017</th>\n",
       "      <th>2018</th>\n",
       "      <th>2019 through February</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>97 Works Of Art, Collectors' Pieces And Antiques</td>\n",
       "      <td>5,025,438,041</td>\n",
       "      <td>6,247,591,682</td>\n",
       "      <td>6,894,183,981</td>\n",
       "      <td>7,791,234,894</td>\n",
       "      <td>9,061,466,121</td>\n",
       "      <td>9,184,214,249</td>\n",
       "      <td>11,616,990,312</td>\n",
       "      <td>9,803,916,941</td>\n",
       "      <td>10,346,030,763</td>\n",
       "      <td>11,839,326,026</td>\n",
       "      <td>1,890,545,757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9701 Paintings, Drawings Etc By Hand As Art; C...</td>\n",
       "      <td>3,283,317,686</td>\n",
       "      <td>4,184,844,181</td>\n",
       "      <td>4,720,193,575</td>\n",
       "      <td>5,261,073,241</td>\n",
       "      <td>6,154,317,457</td>\n",
       "      <td>6,096,237,424</td>\n",
       "      <td>8,536,471,687</td>\n",
       "      <td>6,660,796,601</td>\n",
       "      <td>7,259,311,200</td>\n",
       "      <td>8,107,284,471</td>\n",
       "      <td>1,114,199,867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>970110 Paintings, Drawing And Pastels By Hand</td>\n",
       "      <td>3,206,132,078</td>\n",
       "      <td>4,123,489,956</td>\n",
       "      <td>4,606,998,496</td>\n",
       "      <td>5,136,849,556</td>\n",
       "      <td>5,976,462,820</td>\n",
       "      <td>5,919,890,390</td>\n",
       "      <td>8,282,861,253</td>\n",
       "      <td>6,430,559,048</td>\n",
       "      <td>7,025,784,199</td>\n",
       "      <td>7,847,956,788</td>\n",
       "      <td>1,064,502,993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9701100000 Paintings, Drawing And Pastels Exc ...</td>\n",
       "      <td>3,206,132,078</td>\n",
       "      <td>4,123,489,956</td>\n",
       "      <td>4,606,998,496</td>\n",
       "      <td>5,136,849,556</td>\n",
       "      <td>5,976,462,820</td>\n",
       "      <td>5,919,890,390</td>\n",
       "      <td>8,282,861,253</td>\n",
       "      <td>6,430,559,048</td>\n",
       "      <td>7,025,784,199</td>\n",
       "      <td>7,847,956,788</td>\n",
       "      <td>1,064,502,993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>970190 Collages And Similar Decorative Plaques</td>\n",
       "      <td>77,185,608</td>\n",
       "      <td>61,354,225</td>\n",
       "      <td>113,195,079</td>\n",
       "      <td>124,223,685</td>\n",
       "      <td>177,854,637</td>\n",
       "      <td>176,347,034</td>\n",
       "      <td>253,610,434</td>\n",
       "      <td>230,237,553</td>\n",
       "      <td>233,527,001</td>\n",
       "      <td>259,327,683</td>\n",
       "      <td>49,696,874</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           Commodity         \"2009\"  \\\n",
       "0   97 Works Of Art, Collectors' Pieces And Antiques  5,025,438,041   \n",
       "1  9701 Paintings, Drawings Etc By Hand As Art; C...  3,283,317,686   \n",
       "2      970110 Paintings, Drawing And Pastels By Hand  3,206,132,078   \n",
       "3  9701100000 Paintings, Drawing And Pastels Exc ...  3,206,132,078   \n",
       "4     970190 Collages And Similar Decorative Plaques     77,185,608   \n",
       "\n",
       "            2010           2011           2012           2013           2014  \\\n",
       "0  6,247,591,682  6,894,183,981  7,791,234,894  9,061,466,121  9,184,214,249   \n",
       "1  4,184,844,181  4,720,193,575  5,261,073,241  6,154,317,457  6,096,237,424   \n",
       "2  4,123,489,956  4,606,998,496  5,136,849,556  5,976,462,820  5,919,890,390   \n",
       "3  4,123,489,956  4,606,998,496  5,136,849,556  5,976,462,820  5,919,890,390   \n",
       "4     61,354,225    113,195,079    124,223,685    177,854,637    176,347,034   \n",
       "\n",
       "             2015           2016            2017            2018  \\\n",
       "0  11,616,990,312  9,803,916,941  10,346,030,763  11,839,326,026   \n",
       "1   8,536,471,687  6,660,796,601   7,259,311,200   8,107,284,471   \n",
       "2   8,282,861,253  6,430,559,048   7,025,784,199   7,847,956,788   \n",
       "3   8,282,861,253  6,430,559,048   7,025,784,199   7,847,956,788   \n",
       "4     253,610,434    230,237,553     233,527,001     259,327,683   \n",
       "\n",
       "  2019 through February  \n",
       "0         1,890,545,757  \n",
       "1         1,114,199,867  \n",
       "2         1,064,502,993  \n",
       "3         1,064,502,993  \n",
       "4            49,696,874  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df = pd.read_csv('../datasets/us-imports-antiques-world-totals-by-year.csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}