ICERM_Data-Imports.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "48d31e75",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "97134a94",
   "metadata": {},
   "source": [
    "# 1 - Nenana Ice Classic Data \n",
    "## Need to login and download the data - manage the csv file\n",
    "\n",
    "Had to create a profile at \n",
    "https://urs.earthdata.nasa.gov/profile\n",
    "\n",
    "https://daacdata.apps.nsidc.org/pub/DATASETS/nsidc0064_nenana_ice_classic_v2/NenanaIceClassic_1917-2021.csv\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "9e2a5e68",
   "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>Year</th>\n",
       "      <th>Decimal Day of Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>Day</th>\n",
       "      <th>Time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1917</td>\n",
       "      <td>120.4792</td>\n",
       "      <td>April</td>\n",
       "      <td>30</td>\n",
       "      <td>11:30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1918</td>\n",
       "      <td>131.3979</td>\n",
       "      <td>May</td>\n",
       "      <td>11</td>\n",
       "      <td>09:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1919</td>\n",
       "      <td>123.6063</td>\n",
       "      <td>May</td>\n",
       "      <td>3</td>\n",
       "      <td>14:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1920</td>\n",
       "      <td>132.4486</td>\n",
       "      <td>May</td>\n",
       "      <td>11</td>\n",
       "      <td>10:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1921</td>\n",
       "      <td>131.2792</td>\n",
       "      <td>May</td>\n",
       "      <td>11</td>\n",
       "      <td>06:42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>2017</td>\n",
       "      <td>121.5000</td>\n",
       "      <td>May</td>\n",
       "      <td>1</td>\n",
       "      <td>12:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>2018</td>\n",
       "      <td>121.5542</td>\n",
       "      <td>May</td>\n",
       "      <td>1</td>\n",
       "      <td>13:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>2019</td>\n",
       "      <td>104.0146</td>\n",
       "      <td>April</td>\n",
       "      <td>14</td>\n",
       "      <td>00:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>2020</td>\n",
       "      <td>118.5389</td>\n",
       "      <td>April</td>\n",
       "      <td>27</td>\n",
       "      <td>12:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>2021</td>\n",
       "      <td>120.5347</td>\n",
       "      <td>April</td>\n",
       "      <td>30</td>\n",
       "      <td>12:50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>105 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Year  Decimal Day of Year  Month  Day   Time\n",
       "0    1917             120.4792  April   30  11:30\n",
       "1    1918             131.3979    May   11  09:33\n",
       "2    1919             123.6063    May    3  14:33\n",
       "3    1920             132.4486    May   11  10:46\n",
       "4    1921             131.2792    May   11  06:42\n",
       "..    ...                  ...    ...  ...    ...\n",
       "100  2017             121.5000    May    1  12:00\n",
       "101  2018             121.5542    May    1  13:18\n",
       "102  2019             104.0146  April   14  00:21\n",
       "103  2020             118.5389  April   27  12:56\n",
       "104  2021             120.5347  April   30  12:50\n",
       "\n",
       "[105 rows x 5 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#upload to Jupyterhub\n",
    "ice_df = pd.read_csv(\"NenanaIceClassic_1917-2021.csv\")\n",
    "ice_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "aac254b8",
   "metadata": {},
   "source": [
    "\n",
    "\n",
    "# 2- Getting Datasets from DSSJ datasets repository \n",
    "https://sites.google.com/view/dssj/projects\n",
    "\n",
    "For Example \n",
    "## CSV for Florida Covid dataset\n",
    "https://figshare.com/articles/dataset/COVID-19/14552367?file=28042047"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "5531dd23",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "--2023-07-18 10:43:32--  https://figshare.com/ndownloader/files/28042047\n",
      "Resolving figshare.com (figshare.com)... 34.242.105.80, 34.250.148.102, 2a05:d018:1f4:d000:2df1:b4d4:f8bf:d1c, ...\n",
      "Connecting to figshare.com (figshare.com)|34.242.105.80|:443... connected.\n",
      "HTTP request sent, awaiting response... 302 Found\n",
      "Location: https://s3-eu-west-1.amazonaws.com/pfigshare-u-files/28042047/CoViDCasesFL.csv?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIYCQYOYV5JSSROOA/20230718/eu-west-1/s3/aws4_request&X-Amz-Date=20230718T174333Z&X-Amz-Expires=10&X-Amz-SignedHeaders=host&X-Amz-Signature=742946b2ca01ba9739661e8a7a3987dc2a12db2d19e8a2217f20cda29923214b [following]\n",
      "--2023-07-18 10:43:33--  https://s3-eu-west-1.amazonaws.com/pfigshare-u-files/28042047/CoViDCasesFL.csv?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIYCQYOYV5JSSROOA/20230718/eu-west-1/s3/aws4_request&X-Amz-Date=20230718T174333Z&X-Amz-Expires=10&X-Amz-SignedHeaders=host&X-Amz-Signature=742946b2ca01ba9739661e8a7a3987dc2a12db2d19e8a2217f20cda29923214b\n",
      "Resolving s3-eu-west-1.amazonaws.com (s3-eu-west-1.amazonaws.com)... 52.218.112.171, 52.218.49.68, 52.218.97.210, ...\n",
      "Connecting to s3-eu-west-1.amazonaws.com (s3-eu-west-1.amazonaws.com)|52.218.112.171|:443... connected.\n",
      "HTTP request sent, awaiting response... 200 OK\n",
      "Length: 13654 (13K) [text/csv]\n",
      "Saving to: ‘28042047’\n",
      "\n",
      "28042047            100%[===================>]  13.33K  --.-KB/s    in 0s      \n",
      "\n",
      "2023-07-18 10:43:33 (117 MB/s) - ‘28042047’ saved [13654/13654]\n",
      "\n"
     ]
    }
   ],
   "source": [
    "!wget https://figshare.com/ndownloader/files/28042047\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "9da69b35",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "28042047      ES-21AC-SP21-key\t\t      NenanaIceClassic_1917-2021.csv.1\r\n",
      "covid_fl.csv  ICERM_DataImports.ipynb\r\n",
      "EEP-147-SP23  NenanaIceClassic_1917-2021.csv\r\n"
     ]
    }
   ],
   "source": [
    "!ls\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "961e44cc",
   "metadata": {},
   "outputs": [],
   "source": [
    "!mv 28042047 covid_fl.csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "b3259993",
   "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>FIPS</th>\n",
       "      <th>County</th>\n",
       "      <th>Province_State</th>\n",
       "      <th>Country_Region</th>\n",
       "      <th>Last_Update</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Confirmed</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Recovered</th>\n",
       "      <th>Active</th>\n",
       "      <th>Combined_Key</th>\n",
       "      <th>Incident_Rate</th>\n",
       "      <th>Case_Fatality_Ratio</th>\n",
       "      <th>adults_poverty_percent</th>\n",
       "      <th>children_under_18_poverty_percent</th>\n",
       "      <th>RUC</th>\n",
       "      <th>college_completion_rate</th>\n",
       "      <th>percent_of_state_median_income</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12001</td>\n",
       "      <td>Alachua</td>\n",
       "      <td>Florida</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-05-17 04:20:34</td>\n",
       "      <td>29.678665</td>\n",
       "      <td>-82.359282</td>\n",
       "      <td>25106</td>\n",
       "      <td>279</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alachua, Florida, US</td>\n",
       "      <td>9331.593834</td>\n",
       "      <td>1.111288</td>\n",
       "      <td>19.8</td>\n",
       "      <td>21.1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>42.523907</td>\n",
       "      <td>92.049862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12003</td>\n",
       "      <td>Baker</td>\n",
       "      <td>Florida</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-05-17 04:20:34</td>\n",
       "      <td>30.330601</td>\n",
       "      <td>-82.284675</td>\n",
       "      <td>3518</td>\n",
       "      <td>60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Baker, Florida, US</td>\n",
       "      <td>12043.820609</td>\n",
       "      <td>1.705514</td>\n",
       "      <td>15.4</td>\n",
       "      <td>21.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.355485</td>\n",
       "      <td>95.257338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12005</td>\n",
       "      <td>Bay</td>\n",
       "      <td>Florida</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-05-17 04:20:34</td>\n",
       "      <td>30.265487</td>\n",
       "      <td>-85.621226</td>\n",
       "      <td>20386</td>\n",
       "      <td>392</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bay, Florida, US</td>\n",
       "      <td>11668.813142</td>\n",
       "      <td>1.922888</td>\n",
       "      <td>13.4</td>\n",
       "      <td>20.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>22.821664</td>\n",
       "      <td>93.404651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12007</td>\n",
       "      <td>Bradford</td>\n",
       "      <td>Florida</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-05-17 04:20:34</td>\n",
       "      <td>29.950797</td>\n",
       "      <td>-82.166116</td>\n",
       "      <td>3028</td>\n",
       "      <td>56</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bradford, Florida, US</td>\n",
       "      <td>10737.207900</td>\n",
       "      <td>1.849406</td>\n",
       "      <td>19.5</td>\n",
       "      <td>26.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.550082</td>\n",
       "      <td>81.314380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12009</td>\n",
       "      <td>Brevard</td>\n",
       "      <td>Florida</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-05-17 04:20:34</td>\n",
       "      <td>28.294095</td>\n",
       "      <td>-80.730910</td>\n",
       "      <td>42237</td>\n",
       "      <td>880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Brevard, Florida, US</td>\n",
       "      <td>7016.788993</td>\n",
       "      <td>2.083481</td>\n",
       "      <td>11.0</td>\n",
       "      <td>16.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>29.309989</td>\n",
       "      <td>103.930872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>12125</td>\n",
       "      <td>Union</td>\n",
       "      <td>Florida</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-05-17 04:20:34</td>\n",
       "      <td>30.044130</td>\n",
       "      <td>-82.374974</td>\n",
       "      <td>1836</td>\n",
       "      <td>74</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Union, Florida, US</td>\n",
       "      <td>12049.616066</td>\n",
       "      <td>4.030501</td>\n",
       "      <td>20.6</td>\n",
       "      <td>21.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.322184</td>\n",
       "      <td>82.813487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>12127</td>\n",
       "      <td>Volusia</td>\n",
       "      <td>Florida</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-05-17 04:20:34</td>\n",
       "      <td>29.058589</td>\n",
       "      <td>-81.182633</td>\n",
       "      <td>44006</td>\n",
       "      <td>814</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Volusia, Florida, US</td>\n",
       "      <td>7953.600682</td>\n",
       "      <td>1.849748</td>\n",
       "      <td>13.2</td>\n",
       "      <td>17.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>23.561302</td>\n",
       "      <td>90.713113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>12129</td>\n",
       "      <td>Wakulla</td>\n",
       "      <td>Florida</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-05-17 04:20:34</td>\n",
       "      <td>30.165489</td>\n",
       "      <td>-84.398952</td>\n",
       "      <td>3484</td>\n",
       "      <td>56</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wakulla, Florida, US</td>\n",
       "      <td>10326.328581</td>\n",
       "      <td>1.607348</td>\n",
       "      <td>11.9</td>\n",
       "      <td>16.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>18.383153</td>\n",
       "      <td>104.997023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>12131</td>\n",
       "      <td>Walton</td>\n",
       "      <td>Florida</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-05-17 04:20:34</td>\n",
       "      <td>30.642040</td>\n",
       "      <td>-86.169357</td>\n",
       "      <td>7849</td>\n",
       "      <td>87</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Walton, Florida, US</td>\n",
       "      <td>10596.589758</td>\n",
       "      <td>1.108421</td>\n",
       "      <td>11.4</td>\n",
       "      <td>18.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>28.388890</td>\n",
       "      <td>109.994047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>12133</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Florida</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-05-17 04:20:34</td>\n",
       "      <td>30.613593</td>\n",
       "      <td>-85.660025</td>\n",
       "      <td>2740</td>\n",
       "      <td>52</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Washington, Florida, US</td>\n",
       "      <td>10756.487261</td>\n",
       "      <td>1.897810</td>\n",
       "      <td>22.8</td>\n",
       "      <td>32.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11.737009</td>\n",
       "      <td>70.761099</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>68 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     FIPS      County Province_State Country_Region          Last_Update  \\\n",
       "0   12001     Alachua        Florida             US  2021-05-17 04:20:34   \n",
       "1   12003       Baker        Florida             US  2021-05-17 04:20:34   \n",
       "2   12005         Bay        Florida             US  2021-05-17 04:20:34   \n",
       "3   12007    Bradford        Florida             US  2021-05-17 04:20:34   \n",
       "4   12009     Brevard        Florida             US  2021-05-17 04:20:34   \n",
       "..    ...         ...            ...            ...                  ...   \n",
       "63  12125       Union        Florida             US  2021-05-17 04:20:34   \n",
       "64  12127     Volusia        Florida             US  2021-05-17 04:20:34   \n",
       "65  12129     Wakulla        Florida             US  2021-05-17 04:20:34   \n",
       "66  12131      Walton        Florida             US  2021-05-17 04:20:34   \n",
       "67  12133  Washington        Florida             US  2021-05-17 04:20:34   \n",
       "\n",
       "     Latitude  Longitude  Confirmed  Deaths  Recovered  Active  \\\n",
       "0   29.678665 -82.359282      25106     279        NaN     NaN   \n",
       "1   30.330601 -82.284675       3518      60        NaN     NaN   \n",
       "2   30.265487 -85.621226      20386     392        NaN     NaN   \n",
       "3   29.950797 -82.166116       3028      56        NaN     NaN   \n",
       "4   28.294095 -80.730910      42237     880        NaN     NaN   \n",
       "..        ...        ...        ...     ...        ...     ...   \n",
       "63  30.044130 -82.374974       1836      74        NaN     NaN   \n",
       "64  29.058589 -81.182633      44006     814        NaN     NaN   \n",
       "65  30.165489 -84.398952       3484      56        NaN     NaN   \n",
       "66  30.642040 -86.169357       7849      87        NaN     NaN   \n",
       "67  30.613593 -85.660025       2740      52        NaN     NaN   \n",
       "\n",
       "               Combined_Key  Incident_Rate  Case_Fatality_Ratio  \\\n",
       "0      Alachua, Florida, US    9331.593834             1.111288   \n",
       "1        Baker, Florida, US   12043.820609             1.705514   \n",
       "2          Bay, Florida, US   11668.813142             1.922888   \n",
       "3     Bradford, Florida, US   10737.207900             1.849406   \n",
       "4      Brevard, Florida, US    7016.788993             2.083481   \n",
       "..                      ...            ...                  ...   \n",
       "63       Union, Florida, US   12049.616066             4.030501   \n",
       "64     Volusia, Florida, US    7953.600682             1.849748   \n",
       "65     Wakulla, Florida, US   10326.328581             1.607348   \n",
       "66      Walton, Florida, US   10596.589758             1.108421   \n",
       "67  Washington, Florida, US   10756.487261             1.897810   \n",
       "\n",
       "    adults_poverty_percent  children_under_18_poverty_percent  RUC  \\\n",
       "0                     19.8                               21.1  2.0   \n",
       "1                     15.4                               21.7  1.0   \n",
       "2                     13.4                               20.5  3.0   \n",
       "3                     19.5                               26.0  6.0   \n",
       "4                     11.0                               16.5  2.0   \n",
       "..                     ...                                ...  ...   \n",
       "63                    20.6                               21.0  6.0   \n",
       "64                    13.2                               17.5  2.0   \n",
       "65                    11.9                               16.2  2.0   \n",
       "66                    11.4                               18.6  3.0   \n",
       "67                    22.8                               32.0  6.0   \n",
       "\n",
       "    college_completion_rate  percent_of_state_median_income  \n",
       "0                 42.523907                       92.049862  \n",
       "1                 13.355485                       95.257338  \n",
       "2                 22.821664                       93.404651  \n",
       "3                 10.550082                       81.314380  \n",
       "4                 29.309989                      103.930872  \n",
       "..                      ...                             ...  \n",
       "63                 8.322184                       82.813487  \n",
       "64                23.561302                       90.713113  \n",
       "65                18.383153                      104.997023  \n",
       "66                28.388890                      109.994047  \n",
       "67                11.737009                       70.761099  \n",
       "\n",
       "[68 rows x 19 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "covid_fl_df = pd.read_csv(\"covid_fl.csv\")\n",
    "covid_fl_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d4d4607f",
   "metadata": {},
   "source": [
    "## 3 - Book Chapter - Quantititative Research 4 Social Justice\n",
    "\n",
    "https://github.com/Zibiana/QR4SJ/blob/main/remixed-sections/Data_Files/State-payday-loan-rates-03-21-only-predatory.xlsx\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "542f001f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "covid_fl.csv\t  ICERM_DataImports.ipynb\r\n",
      "crdc.zip\t  NenanaIceClassic_1917-2021.csv\r\n",
      "EEP-147-SP23\t  Poverty-School-ussd21.xls\r\n",
      "ES-21AC-SP21-key  State-payday-loan-rates-03-21-only-predatory.xlsx\r\n"
     ]
    }
   ],
   "source": [
    "#upload to Jupyterhub\n",
    "!ls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "319e29ed",
   "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>State</th>\n",
       "      <th>Typical Payday Loan APR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ohio</td>\n",
       "      <td>1.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Oregon</td>\n",
       "      <td>1.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Virginia</td>\n",
       "      <td>1.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>New Mexico</td>\n",
       "      <td>1.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>2.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Maine</td>\n",
       "      <td>2.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>2.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Wyoming</td>\n",
       "      <td>2.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Florida</td>\n",
       "      <td>3.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>3.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>3.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Indiana</td>\n",
       "      <td>3.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Delaware</td>\n",
       "      <td>3.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Kansas</td>\n",
       "      <td>3.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Washington</td>\n",
       "      <td>3.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>South Carolina</td>\n",
       "      <td>3.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Alaska</td>\n",
       "      <td>4.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Alabama</td>\n",
       "      <td>4.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>California</td>\n",
       "      <td>4.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Hawaii</td>\n",
       "      <td>4.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Tennessee</td>\n",
       "      <td>4.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Kentucky</td>\n",
       "      <td>4.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Louisiana</td>\n",
       "      <td>4.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>5.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Mississippi</td>\n",
       "      <td>5.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>North Dakota</td>\n",
       "      <td>5.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Missouri</td>\n",
       "      <td>5.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Idaho</td>\n",
       "      <td>6.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Nevada</td>\n",
       "      <td>6.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Utah</td>\n",
       "      <td>6.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Texas</td>\n",
       "      <td>6.64</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             State  Typical Payday Loan APR\n",
       "0             Ohio                     1.38\n",
       "1           Oregon                     1.54\n",
       "2         Virginia                     1.73\n",
       "3       New Mexico                     1.75\n",
       "4        Minnesota                     2.00\n",
       "5         Oklahoma                     2.03\n",
       "6            Maine                     2.17\n",
       "7     Rhode Island                     2.61\n",
       "8          Wyoming                     2.61\n",
       "9          Florida                     3.04\n",
       "10            Iowa                     3.36\n",
       "11        Michigan                     3.70\n",
       "12         Indiana                     3.82\n",
       "13        Delaware                     3.91\n",
       "14          Kansas                     3.91\n",
       "15      Washington                     3.91\n",
       "16  South Carolina                     3.95\n",
       "17          Alaska                     4.35\n",
       "18         Alabama                     4.56\n",
       "19      California                     4.60\n",
       "20          Hawaii                     4.60\n",
       "21       Tennessee                     4.60\n",
       "22        Kentucky                     4.69\n",
       "23       Louisiana                     4.78\n",
       "24       Wisconsin                     5.16\n",
       "25     Mississippi                     5.21\n",
       "26    North Dakota                     5.26\n",
       "27        Missouri                     5.27\n",
       "28           Idaho                     6.52\n",
       "29          Nevada                     6.52\n",
       "30            Utah                     6.52\n",
       "31           Texas                     6.64"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "payday_df = pd.read_excel(\"State-payday-loan-rates-03-21-only-predatory.xlsx\")\n",
    "payday_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "26d51fdc",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.15"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}