Compile Site List.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "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>Unnamed: 0</th>\n",
       "      <th>tower</th>\n",
       "      <th>orbit</th>\n",
       "      <th>scene</th>\n",
       "      <th>tile</th>\n",
       "      <th>time_UTC</th>\n",
       "      <th>product</th>\n",
       "      <th>variable</th>\n",
       "      <th>med3x3</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>US-Mpj</td>\n",
       "      <td>3190</td>\n",
       "      <td>4</td>\n",
       "      <td>13SCU</td>\n",
       "      <td>2019-01-27 23:32:30</td>\n",
       "      <td>L1CT_RAD</td>\n",
       "      <td>radiance_1</td>\n",
       "      <td>5.028204</td>\n",
       "      <td>34.4385</td>\n",
       "      <td>-106.2377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>US-Mpj</td>\n",
       "      <td>3190</td>\n",
       "      <td>4</td>\n",
       "      <td>13SCU</td>\n",
       "      <td>2019-01-27 23:32:30</td>\n",
       "      <td>L1CT_RAD</td>\n",
       "      <td>radiance_2</td>\n",
       "      <td>5.390165</td>\n",
       "      <td>34.4385</td>\n",
       "      <td>-106.2377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>US-Mpj</td>\n",
       "      <td>3190</td>\n",
       "      <td>4</td>\n",
       "      <td>13SCU</td>\n",
       "      <td>2019-01-27 23:32:30</td>\n",
       "      <td>L1CT_RAD</td>\n",
       "      <td>radiance_3</td>\n",
       "      <td>5.390238</td>\n",
       "      <td>34.4385</td>\n",
       "      <td>-106.2377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>US-Mpj</td>\n",
       "      <td>3190</td>\n",
       "      <td>4</td>\n",
       "      <td>13SCU</td>\n",
       "      <td>2019-01-27 23:32:30</td>\n",
       "      <td>L1CT_RAD</td>\n",
       "      <td>radiance_4</td>\n",
       "      <td>6.068446</td>\n",
       "      <td>34.4385</td>\n",
       "      <td>-106.2377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>US-Mpj</td>\n",
       "      <td>3190</td>\n",
       "      <td>4</td>\n",
       "      <td>13SCU</td>\n",
       "      <td>2019-01-27 23:32:30</td>\n",
       "      <td>L1CT_RAD</td>\n",
       "      <td>radiance_5</td>\n",
       "      <td>5.829097</td>\n",
       "      <td>34.4385</td>\n",
       "      <td>-106.2377</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68894</th>\n",
       "      <td>68894</td>\n",
       "      <td>US-Ha2</td>\n",
       "      <td>19605</td>\n",
       "      <td>12</td>\n",
       "      <td>18TYN</td>\n",
       "      <td>2021-12-20 17:05:33</td>\n",
       "      <td>L4T_WUE</td>\n",
       "      <td>GPP</td>\n",
       "      <td>2.777341</td>\n",
       "      <td>42.5393</td>\n",
       "      <td>-72.1779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68895</th>\n",
       "      <td>68895</td>\n",
       "      <td>US-Ha2</td>\n",
       "      <td>19605</td>\n",
       "      <td>12</td>\n",
       "      <td>18TYN</td>\n",
       "      <td>2021-12-20 17:05:33</td>\n",
       "      <td>L4T_WUE</td>\n",
       "      <td>WUE</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>42.5393</td>\n",
       "      <td>-72.1779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68896</th>\n",
       "      <td>68896</td>\n",
       "      <td>US-Ha2</td>\n",
       "      <td>19620</td>\n",
       "      <td>13</td>\n",
       "      <td>18TYN</td>\n",
       "      <td>2021-12-21 16:18:05</td>\n",
       "      <td>L3T_MET</td>\n",
       "      <td>RH</td>\n",
       "      <td>0.957962</td>\n",
       "      <td>42.5393</td>\n",
       "      <td>-72.1779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68897</th>\n",
       "      <td>68897</td>\n",
       "      <td>US-Ha2</td>\n",
       "      <td>19620</td>\n",
       "      <td>13</td>\n",
       "      <td>18TYN</td>\n",
       "      <td>2021-12-21 16:18:05</td>\n",
       "      <td>L3T_MET</td>\n",
       "      <td>Ta</td>\n",
       "      <td>-0.425873</td>\n",
       "      <td>42.5393</td>\n",
       "      <td>-72.1779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68898</th>\n",
       "      <td>68898</td>\n",
       "      <td>US-Ha2</td>\n",
       "      <td>19620</td>\n",
       "      <td>13</td>\n",
       "      <td>18TYN</td>\n",
       "      <td>2021-12-21 16:18:05</td>\n",
       "      <td>L3T_SM</td>\n",
       "      <td>SM</td>\n",
       "      <td>0.273294</td>\n",
       "      <td>42.5393</td>\n",
       "      <td>-72.1779</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>68899 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0   tower  orbit  scene   tile             time_UTC   product  \\\n",
       "0               0  US-Mpj   3190      4  13SCU  2019-01-27 23:32:30  L1CT_RAD   \n",
       "1               1  US-Mpj   3190      4  13SCU  2019-01-27 23:32:30  L1CT_RAD   \n",
       "2               2  US-Mpj   3190      4  13SCU  2019-01-27 23:32:30  L1CT_RAD   \n",
       "3               3  US-Mpj   3190      4  13SCU  2019-01-27 23:32:30  L1CT_RAD   \n",
       "4               4  US-Mpj   3190      4  13SCU  2019-01-27 23:32:30  L1CT_RAD   \n",
       "...           ...     ...    ...    ...    ...                  ...       ...   \n",
       "68894       68894  US-Ha2  19605     12  18TYN  2021-12-20 17:05:33   L4T_WUE   \n",
       "68895       68895  US-Ha2  19605     12  18TYN  2021-12-20 17:05:33   L4T_WUE   \n",
       "68896       68896  US-Ha2  19620     13  18TYN  2021-12-21 16:18:05   L3T_MET   \n",
       "68897       68897  US-Ha2  19620     13  18TYN  2021-12-21 16:18:05   L3T_MET   \n",
       "68898       68898  US-Ha2  19620     13  18TYN  2021-12-21 16:18:05    L3T_SM   \n",
       "\n",
       "         variable    med3x3      lat       lon  \n",
       "0      radiance_1  5.028204  34.4385 -106.2377  \n",
       "1      radiance_2  5.390165  34.4385 -106.2377  \n",
       "2      radiance_3  5.390238  34.4385 -106.2377  \n",
       "3      radiance_4  6.068446  34.4385 -106.2377  \n",
       "4      radiance_5  5.829097  34.4385 -106.2377  \n",
       "...           ...       ...      ...       ...  \n",
       "68894         GPP  2.777341  42.5393  -72.1779  \n",
       "68895         WUE  0.000000  42.5393  -72.1779  \n",
       "68896          RH  0.957962  42.5393  -72.1779  \n",
       "68897          Ta -0.425873  42.5393  -72.1779  \n",
       "68898          SM  0.273294  42.5393  -72.1779  \n",
       "\n",
       "[68899 rows x 11 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "samples = pd.read_csv(\"calval_final_50.csv\")\n",
    "samples"
   ]
  },
  {
   "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>tower</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CA-Cbo</td>\n",
       "      <td>44.3167</td>\n",
       "      <td>-79.9333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CA-DB2</td>\n",
       "      <td>49.1190</td>\n",
       "      <td>-122.9951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PR-xGU</td>\n",
       "      <td>17.9696</td>\n",
       "      <td>-66.8687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PR-xLA</td>\n",
       "      <td>18.0212</td>\n",
       "      <td>-67.0769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>US-ALQ</td>\n",
       "      <td>46.0308</td>\n",
       "      <td>-89.6067</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>US-CF1</td>\n",
       "      <td>46.7815</td>\n",
       "      <td>-117.0821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>US-CF2</td>\n",
       "      <td>46.7840</td>\n",
       "      <td>-117.0908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>US-CF3</td>\n",
       "      <td>46.7551</td>\n",
       "      <td>-117.1261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>US-CF4</td>\n",
       "      <td>46.7518</td>\n",
       "      <td>-117.1285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>US-CS2</td>\n",
       "      <td>44.1467</td>\n",
       "      <td>-89.5002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>US-DFC</td>\n",
       "      <td>43.3448</td>\n",
       "      <td>-89.7117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>US-GLE</td>\n",
       "      <td>41.3665</td>\n",
       "      <td>-106.2399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>US-Ha2</td>\n",
       "      <td>42.5393</td>\n",
       "      <td>-72.1779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>US-KM4</td>\n",
       "      <td>42.4423</td>\n",
       "      <td>-85.3301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>US-Los</td>\n",
       "      <td>46.0827</td>\n",
       "      <td>-89.9792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>US-Me6</td>\n",
       "      <td>44.3233</td>\n",
       "      <td>-121.6078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>US-Mpj</td>\n",
       "      <td>34.4385</td>\n",
       "      <td>-106.2377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>US-NC2</td>\n",
       "      <td>35.8030</td>\n",
       "      <td>-76.6685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>US-NC3</td>\n",
       "      <td>35.7990</td>\n",
       "      <td>-76.6560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>US-NC4</td>\n",
       "      <td>35.7879</td>\n",
       "      <td>-75.9038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>US-NR1</td>\n",
       "      <td>40.0329</td>\n",
       "      <td>-105.5464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>US-NR3</td>\n",
       "      <td>40.0520</td>\n",
       "      <td>-105.5864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>US-ONA</td>\n",
       "      <td>27.3836</td>\n",
       "      <td>-81.9509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>US-PFd</td>\n",
       "      <td>45.9689</td>\n",
       "      <td>-90.3010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>US-PFi</td>\n",
       "      <td>45.9749</td>\n",
       "      <td>-90.2327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>US-PFq</td>\n",
       "      <td>45.9271</td>\n",
       "      <td>-90.2475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>US-PHM</td>\n",
       "      <td>42.7423</td>\n",
       "      <td>-70.8301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>US-Ro4</td>\n",
       "      <td>44.6781</td>\n",
       "      <td>-93.0723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>US-Syv</td>\n",
       "      <td>46.2420</td>\n",
       "      <td>-89.3477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>US-Tw1</td>\n",
       "      <td>38.1074</td>\n",
       "      <td>-121.6469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>US-Tw4</td>\n",
       "      <td>38.1027</td>\n",
       "      <td>-121.6413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>US-UC1</td>\n",
       "      <td>40.7536</td>\n",
       "      <td>-78.0056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>US-UC2</td>\n",
       "      <td>40.7559</td>\n",
       "      <td>-77.9998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>US-UMB</td>\n",
       "      <td>45.5598</td>\n",
       "      <td>-84.7138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>US-UMd</td>\n",
       "      <td>45.5625</td>\n",
       "      <td>-84.6975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>US-Var</td>\n",
       "      <td>38.4133</td>\n",
       "      <td>-120.9508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>US-Vcp</td>\n",
       "      <td>35.8642</td>\n",
       "      <td>-106.5967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>US-WCr</td>\n",
       "      <td>45.8059</td>\n",
       "      <td>-90.0799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>US-xAB</td>\n",
       "      <td>45.7624</td>\n",
       "      <td>-122.3303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>US-xBL</td>\n",
       "      <td>39.0603</td>\n",
       "      <td>-78.0716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>US-xDL</td>\n",
       "      <td>32.5417</td>\n",
       "      <td>-87.8039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>US-xJE</td>\n",
       "      <td>31.1948</td>\n",
       "      <td>-84.4686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>US-xML</td>\n",
       "      <td>37.3783</td>\n",
       "      <td>-80.5248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>US-xNW</td>\n",
       "      <td>40.0543</td>\n",
       "      <td>-105.5824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>US-xRM</td>\n",
       "      <td>40.2759</td>\n",
       "      <td>-105.5459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>US-xST</td>\n",
       "      <td>45.5089</td>\n",
       "      <td>-89.5864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>US-xTR</td>\n",
       "      <td>45.4937</td>\n",
       "      <td>-89.5857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>US-xUK</td>\n",
       "      <td>39.0404</td>\n",
       "      <td>-95.1921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>US-xUN</td>\n",
       "      <td>46.2339</td>\n",
       "      <td>-89.5373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>US-xYE</td>\n",
       "      <td>44.9535</td>\n",
       "      <td>-110.5391</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     tower      lat       lon\n",
       "0   CA-Cbo  44.3167  -79.9333\n",
       "1   CA-DB2  49.1190 -122.9951\n",
       "2   PR-xGU  17.9696  -66.8687\n",
       "3   PR-xLA  18.0212  -67.0769\n",
       "4   US-ALQ  46.0308  -89.6067\n",
       "5   US-CF1  46.7815 -117.0821\n",
       "6   US-CF2  46.7840 -117.0908\n",
       "7   US-CF3  46.7551 -117.1261\n",
       "8   US-CF4  46.7518 -117.1285\n",
       "9   US-CS2  44.1467  -89.5002\n",
       "10  US-DFC  43.3448  -89.7117\n",
       "11  US-GLE  41.3665 -106.2399\n",
       "12  US-Ha2  42.5393  -72.1779\n",
       "13  US-KM4  42.4423  -85.3301\n",
       "14  US-Los  46.0827  -89.9792\n",
       "15  US-Me6  44.3233 -121.6078\n",
       "16  US-Mpj  34.4385 -106.2377\n",
       "17  US-NC2  35.8030  -76.6685\n",
       "18  US-NC3  35.7990  -76.6560\n",
       "19  US-NC4  35.7879  -75.9038\n",
       "20  US-NR1  40.0329 -105.5464\n",
       "21  US-NR3  40.0520 -105.5864\n",
       "22  US-ONA  27.3836  -81.9509\n",
       "23  US-PFd  45.9689  -90.3010\n",
       "24  US-PFi  45.9749  -90.2327\n",
       "25  US-PFq  45.9271  -90.2475\n",
       "26  US-PHM  42.7423  -70.8301\n",
       "27  US-Ro4  44.6781  -93.0723\n",
       "28  US-Syv  46.2420  -89.3477\n",
       "29  US-Tw1  38.1074 -121.6469\n",
       "30  US-Tw4  38.1027 -121.6413\n",
       "31  US-UC1  40.7536  -78.0056\n",
       "32  US-UC2  40.7559  -77.9998\n",
       "33  US-UMB  45.5598  -84.7138\n",
       "34  US-UMd  45.5625  -84.6975\n",
       "35  US-Var  38.4133 -120.9508\n",
       "36  US-Vcp  35.8642 -106.5967\n",
       "37  US-WCr  45.8059  -90.0799\n",
       "38  US-xAB  45.7624 -122.3303\n",
       "39  US-xBL  39.0603  -78.0716\n",
       "40  US-xDL  32.5417  -87.8039\n",
       "41  US-xJE  31.1948  -84.4686\n",
       "42  US-xML  37.3783  -80.5248\n",
       "43  US-xNW  40.0543 -105.5824\n",
       "44  US-xRM  40.2759 -105.5459\n",
       "45  US-xST  45.5089  -89.5864\n",
       "46  US-xTR  45.4937  -89.5857\n",
       "47  US-xUK  39.0404  -95.1921\n",
       "48  US-xUN  46.2339  -89.5373\n",
       "49  US-xYE  44.9535 -110.5391"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sites_df = samples.groupby(\"tower\")[[\"lat\", \"lon\"]].first().reset_index()\n",
    "sites_df.to_csv(\"sites.csv\", index=False)\n",
    "sites_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "sensitivity",
   "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.16"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}