Eclipse_Totality_Duration_csvtojson.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "efc84b73",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from pathlib import Path"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c0177ed3",
   "metadata": {},
   "outputs": [],
   "source": [
    "cvs_file = Path(\"Resources/Eclipse_Cities_Totality_duration.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0ae10684",
   "metadata": {},
   "outputs": [],
   "source": [
    " # Read our data file with the Pandas library\n",
    "# Not every CSV requires an encoding, but be aware this can come up\n",
    "csv_file_df = pd.read_csv(cvs_file, encoding=\"ISO-8859-1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "3d599569",
   "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>ï»¿X</th>\n",
       "      <th>Y</th>\n",
       "      <th>STATE</th>\n",
       "      <th>NAME</th>\n",
       "      <th>LAT</th>\n",
       "      <th>LON</th>\n",
       "      <th>Start_Partial</th>\n",
       "      <th>Start_Date</th>\n",
       "      <th>Start_Time</th>\n",
       "      <th>End_Time</th>\n",
       "      <th>Total_Duration</th>\n",
       "      <th>End_Partial</th>\n",
       "      <th>Midpoint_Totality</th>\n",
       "      <th>ObjectId</th>\n",
       "      <th>TestTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-94.200112</td>\n",
       "      <td>34.638786</td>\n",
       "      <td>AR</td>\n",
       "      <td>Acorn</td>\n",
       "      <td>34.638786</td>\n",
       "      <td>-94.200112</td>\n",
       "      <td>2024/02/18 17:30:40+00</td>\n",
       "      <td>2/18/24</td>\n",
       "      <td>18:47:35</td>\n",
       "      <td>18:51:37</td>\n",
       "      <td>04:02</td>\n",
       "      <td>2024/02/18 20:08:30+00</td>\n",
       "      <td>2024/02/18 18:49:36+00</td>\n",
       "      <td>1</td>\n",
       "      <td>12:30:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-91.826194</td>\n",
       "      <td>35.113627</td>\n",
       "      <td>AR</td>\n",
       "      <td>McRae</td>\n",
       "      <td>35.113627</td>\n",
       "      <td>-91.826194</td>\n",
       "      <td>2024/02/18 17:35:10+00</td>\n",
       "      <td>2/18/24</td>\n",
       "      <td>18:52:42</td>\n",
       "      <td>18:55:26</td>\n",
       "      <td>02:44</td>\n",
       "      <td>2024/02/18 20:12:30+00</td>\n",
       "      <td>2024/02/18 18:54:04+00</td>\n",
       "      <td>2</td>\n",
       "      <td>12:35:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-92.899132</td>\n",
       "      <td>35.039930</td>\n",
       "      <td>AR</td>\n",
       "      <td>Adona</td>\n",
       "      <td>35.039930</td>\n",
       "      <td>-92.899132</td>\n",
       "      <td>2024/02/18 17:33:20+00</td>\n",
       "      <td>2/18/24</td>\n",
       "      <td>18:50:08</td>\n",
       "      <td>18:54:22</td>\n",
       "      <td>04:14</td>\n",
       "      <td>2024/02/18 20:10:50+00</td>\n",
       "      <td>2024/02/18 18:52:15+00</td>\n",
       "      <td>3</td>\n",
       "      <td>12:33:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-92.451217</td>\n",
       "      <td>34.618588</td>\n",
       "      <td>AR</td>\n",
       "      <td>Alexander</td>\n",
       "      <td>34.618588</td>\n",
       "      <td>-92.451217</td>\n",
       "      <td>2024/02/18 17:33:20+00</td>\n",
       "      <td>2/18/24</td>\n",
       "      <td>18:51:09</td>\n",
       "      <td>18:53:38</td>\n",
       "      <td>02:29</td>\n",
       "      <td>2024/02/18 20:11:10+00</td>\n",
       "      <td>2024/02/18 18:52:24+00</td>\n",
       "      <td>4</td>\n",
       "      <td>12:33:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-91.083450</td>\n",
       "      <td>35.892907</td>\n",
       "      <td>AR</td>\n",
       "      <td>Alicia</td>\n",
       "      <td>35.892907</td>\n",
       "      <td>-91.083450</td>\n",
       "      <td>2024/02/18 17:37:30+00</td>\n",
       "      <td>2/18/24</td>\n",
       "      <td>18:54:29</td>\n",
       "      <td>18:58:05</td>\n",
       "      <td>03:36</td>\n",
       "      <td>2024/02/18 20:14:10+00</td>\n",
       "      <td>2024/02/18 18:56:17+00</td>\n",
       "      <td>5</td>\n",
       "      <td>12:37:30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        ï»¿X          Y STATE       NAME        LAT        LON  \\\n",
       "0 -94.200112  34.638786    AR      Acorn  34.638786 -94.200112   \n",
       "1 -91.826194  35.113627    AR      McRae  35.113627 -91.826194   \n",
       "2 -92.899132  35.039930    AR      Adona  35.039930 -92.899132   \n",
       "3 -92.451217  34.618588    AR  Alexander  34.618588 -92.451217   \n",
       "4 -91.083450  35.892907    AR     Alicia  35.892907 -91.083450   \n",
       "\n",
       "            Start_Partial Start_Date Start_Time  End_Time Total_Duration  \\\n",
       "0  2024/02/18 17:30:40+00    2/18/24   18:47:35  18:51:37          04:02   \n",
       "1  2024/02/18 17:35:10+00    2/18/24   18:52:42  18:55:26          02:44   \n",
       "2  2024/02/18 17:33:20+00    2/18/24   18:50:08  18:54:22          04:14   \n",
       "3  2024/02/18 17:33:20+00    2/18/24   18:51:09  18:53:38          02:29   \n",
       "4  2024/02/18 17:37:30+00    2/18/24   18:54:29  18:58:05          03:36   \n",
       "\n",
       "              End_Partial       Midpoint_Totality  ObjectId  TestTime  \n",
       "0  2024/02/18 20:08:30+00  2024/02/18 18:49:36+00         1  12:30:40  \n",
       "1  2024/02/18 20:12:30+00  2024/02/18 18:54:04+00         2  12:35:10  \n",
       "2  2024/02/18 20:10:50+00  2024/02/18 18:52:15+00         3  12:33:20  \n",
       "3  2024/02/18 20:11:10+00  2024/02/18 18:52:24+00         4  12:33:20  \n",
       "4  2024/02/18 20:14:10+00  2024/02/18 18:56:17+00         5  12:37:30  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    " # Show the first five rows.\n",
    "csv_file_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "f1105cd5",
   "metadata": {},
   "outputs": [],
   "source": [
    "csv_file_df.to_json(\"Resources/Eclipse_Cities_Totality_duration.json\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "abb29fa3",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c3d06fe3",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f3d397d5",
   "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.10.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}