weather_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "c782ba0b",
   "metadata": {},
   "source": [
    "## Weather Analysis: Sunshine, Rain & Temperature in Denmark VS the United States ☀️🌧️🌡️\n",
    "\n",
    "#### Denmark scores as one of the happiest countries in the world, but when it comes to nice weather, the U.S. has it beat. The idea of perfect weather is highly subjective. But a lot of people like sunshine, warmth and lush greenery. Based on an analysis of U.N. climate data, here’s how Denmark and the United States differ and why Danes may want to consider a trip stateside.\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "aa27551a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd \n",
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import re\n",
    "import time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "22110df6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "32da66a9",
   "metadata": {},
   "source": [
    "### Export Data from UN Climate site. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "485df311",
   "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>country_or_territory</th>\n",
       "      <th>station_name</th>\n",
       "      <th>wmo_station_number</th>\n",
       "      <th>national_station_id_number</th>\n",
       "      <th>period</th>\n",
       "      <th>element-statistic_qualifier_code</th>\n",
       "      <th>statistic_description</th>\n",
       "      <th>unit</th>\n",
       "      <th>jan</th>\n",
       "      <th>jan_footnotes</th>\n",
       "      <th>...</th>\n",
       "      <th>oct</th>\n",
       "      <th>oct_footnotes</th>\n",
       "      <th>nov</th>\n",
       "      <th>nov_footnotes</th>\n",
       "      <th>dec</th>\n",
       "      <th>dec_footnotes</th>\n",
       "      <th>annual</th>\n",
       "      <th>annual_footnotes</th>\n",
       "      <th>annual_ncdc_computed_value</th>\n",
       "      <th>annual_ncdc_computed_value_footnotes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AFGHANISTAN, ISLAMIC STATE OF</td>\n",
       "      <td>Faiz abad</td>\n",
       "      <td>40904.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1964-1983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mean Number of Hours</td>\n",
       "      <td>*</td>\n",
       "      <td>117.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>224.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>176.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>127.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>205.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2576.6</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AFGHANISTAN, ISLAMIC STATE OF</td>\n",
       "      <td>Sheberghan</td>\n",
       "      <td>40908.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1964-1983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mean Number of Hours</td>\n",
       "      <td>*</td>\n",
       "      <td>115.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>242.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>175.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>125.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>236.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2823.1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AFGHANISTAN, ISLAMIC STATE OF</td>\n",
       "      <td>Mazar-i-Sharif</td>\n",
       "      <td>40911.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1959-1983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mean Number of Hours</td>\n",
       "      <td>*</td>\n",
       "      <td>122.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>223.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>173.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>125.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>229.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2762.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AFGHANISTAN, ISLAMIC STATE OF</td>\n",
       "      <td>Kunduz</td>\n",
       "      <td>40913.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1958-1983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mean Number of Hours</td>\n",
       "      <td>*</td>\n",
       "      <td>114.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>221.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>118.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>229.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2652.3</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AFGHANISTAN, ISLAMIC STATE OF</td>\n",
       "      <td>Maimana</td>\n",
       "      <td>40922.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1959-1983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mean Number of Hours</td>\n",
       "      <td>*</td>\n",
       "      <td>136.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>237.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>159.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>137.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>239.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2866.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>AFGHANISTAN, ISLAMIC STATE OF</td>\n",
       "      <td>North Salang</td>\n",
       "      <td>40930.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1960-1983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mean Number of Hours</td>\n",
       "      <td>*</td>\n",
       "      <td>112.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>184.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>149.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>118.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>188.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2229.4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AFGHANISTAN, ISLAMIC STATE OF</td>\n",
       "      <td>Jabulsaraj</td>\n",
       "      <td>40932.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1961-1983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mean Number of Hours</td>\n",
       "      <td>*</td>\n",
       "      <td>167.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>275.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>224.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>260.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3059.2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AFGHANISTAN, ISLAMIC STATE OF</td>\n",
       "      <td>Qalai naw</td>\n",
       "      <td>40937.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-1983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mean Number of Hours</td>\n",
       "      <td>*</td>\n",
       "      <td>127.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>197.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>175.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2685.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>AFGHANISTAN, ISLAMIC STATE OF</td>\n",
       "      <td>Herat</td>\n",
       "      <td>40938.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1958-1983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mean Number of Hours</td>\n",
       "      <td>*</td>\n",
       "      <td>149.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>274.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>235.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>143.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>253.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3131.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AFGHANISTAN, ISLAMIC STATE OF</td>\n",
       "      <td>Chakhcharan</td>\n",
       "      <td>40942.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1968-1983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mean Number of Hours</td>\n",
       "      <td>*</td>\n",
       "      <td>146.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>267.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>217.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>154.7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>250.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3156.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            country_or_territory    station_name  wmo_station_number  \\\n",
       "0  AFGHANISTAN, ISLAMIC STATE OF       Faiz abad             40904.0   \n",
       "1  AFGHANISTAN, ISLAMIC STATE OF      Sheberghan             40908.0   \n",
       "2  AFGHANISTAN, ISLAMIC STATE OF  Mazar-i-Sharif             40911.0   \n",
       "3  AFGHANISTAN, ISLAMIC STATE OF          Kunduz             40913.0   \n",
       "4  AFGHANISTAN, ISLAMIC STATE OF         Maimana             40922.0   \n",
       "5  AFGHANISTAN, ISLAMIC STATE OF    North Salang             40930.0   \n",
       "6  AFGHANISTAN, ISLAMIC STATE OF      Jabulsaraj             40932.0   \n",
       "7  AFGHANISTAN, ISLAMIC STATE OF       Qalai naw             40937.0   \n",
       "8  AFGHANISTAN, ISLAMIC STATE OF           Herat             40938.0   \n",
       "9  AFGHANISTAN, ISLAMIC STATE OF     Chakhcharan             40942.0   \n",
       "\n",
       "  national_station_id_number     period element-statistic_qualifier_code  \\\n",
       "0                        NaN  1964-1983                              NaN   \n",
       "1                        NaN  1964-1983                              NaN   \n",
       "2                        NaN  1959-1983                              NaN   \n",
       "3                        NaN  1958-1983                              NaN   \n",
       "4                        NaN  1959-1983                              NaN   \n",
       "5                        NaN  1960-1983                              NaN   \n",
       "6                        NaN  1961-1983                              NaN   \n",
       "7                        NaN  1970-1983                              NaN   \n",
       "8                        NaN  1958-1983                              NaN   \n",
       "9                        NaN  1968-1983                              NaN   \n",
       "\n",
       "  statistic_description unit    jan  jan_footnotes  ...    oct  oct_footnotes  \\\n",
       "0  Mean Number of Hours    *  117.3            NaN  ...  224.2            NaN   \n",
       "1  Mean Number of Hours    *  115.3            NaN  ...  242.9            NaN   \n",
       "2  Mean Number of Hours    *  122.2            NaN  ...  223.2            NaN   \n",
       "3  Mean Number of Hours    *  114.4            NaN  ...  221.8            NaN   \n",
       "4  Mean Number of Hours    *  136.6            NaN  ...  237.2            NaN   \n",
       "5  Mean Number of Hours    *  112.8            NaN  ...  184.3            NaN   \n",
       "6  Mean Number of Hours    *  167.3            NaN  ...  275.9            NaN   \n",
       "7  Mean Number of Hours    *  127.4            NaN  ...  197.0            NaN   \n",
       "8  Mean Number of Hours    *  149.3            NaN  ...  274.0            NaN   \n",
       "9  Mean Number of Hours    *  146.4            NaN  ...  267.7            NaN   \n",
       "\n",
       "     nov  nov_footnotes    dec  dec_footnotes  annual  annual_footnotes  \\\n",
       "0  176.4            NaN  127.3            NaN   205.3               NaN   \n",
       "1  175.8            NaN  125.7            NaN   236.9               NaN   \n",
       "2  173.6            NaN  125.5            NaN   229.9               NaN   \n",
       "3  169.3            NaN  118.3            NaN   229.5               NaN   \n",
       "4  159.1            NaN  137.9            NaN   239.6               NaN   \n",
       "5  149.4            NaN  118.5            NaN   188.2               NaN   \n",
       "6  224.4            NaN  167.3            NaN   260.3               NaN   \n",
       "7  175.4            NaN  110.2            NaN   201.4               NaN   \n",
       "8  235.0            NaN  143.1            NaN   253.8               NaN   \n",
       "9  217.9            NaN  154.7            NaN   250.1               NaN   \n",
       "\n",
       "   annual_ncdc_computed_value  annual_ncdc_computed_value_footnotes  \n",
       "0                      2576.6                                   NaN  \n",
       "1                      2823.1                                   NaN  \n",
       "2                      2762.9                                   NaN  \n",
       "3                      2652.3                                   NaN  \n",
       "4                      2866.9                                   NaN  \n",
       "5                      2229.4                                   NaN  \n",
       "6                      3059.2                                   NaN  \n",
       "7                      2685.0                                   NaN  \n",
       "8                      3131.9                                   NaN  \n",
       "9                      3156.0                                   NaN  \n",
       "\n",
       "[10 rows x 36 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sunlight = pd.read_csv(\"sunlight.csv\")\n",
    "#temperature = pd.read_csv(\"temp.csv\")\n",
    "#sunlight = pd.read_csv(\"rain.csv\")\n",
    "#df = pd.read_csv(\"UNdata_Export_20220125_184823524.csv\")\n",
    "#pd.set_option('display.max_rows', None)\n",
    "\n",
    "#clean column names \n",
    "df.columns = df.columns.str.lower()\n",
    "df.columns = df.columns.str.replace(' ','_')\n",
    "df.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "07ccfb5f",
   "metadata": {},
   "source": [
    "### Filter for cells with missing values (these cells will typically have a footnote)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "b10a947d",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = df[df['annual_ncdc_computed_value_footnotes'] != 1]\n",
    "df2 = df2[df2['jan_footnotes'] != 1]\n",
    "df2 = df2[df2['feb_footnotes'] != 1]\n",
    "df2 = df2[df2['mar_footnotes'] != 1]\n",
    "df2 = df2[df2['apr_footnotes'] != 1]\n",
    "df2 = df2[df2['may_footnotes'] != 1]\n",
    "df2 = df2[df2['jun_footnotes'] != 1]\n",
    "df2 = df2[df2['jul_footnotes'] != 1]\n",
    "df2 = df2[df2['aug_footnotes'] != 1]\n",
    "df2 = df2[df2['sep_footnotes'] != 1]\n",
    "df2 = df2[df2['oct_footnotes'] != 1]\n",
    "df2 = df2[df2['nov_footnotes'] != 1]\n",
    "df2 = df2[df2['dec_footnotes'] != 1]\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5a73e42d",
   "metadata": {},
   "source": [
    "### Group by country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "5be615e0",
   "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>wmo_station_number</th>\n",
       "      <th>jan</th>\n",
       "      <th>jan_footnotes</th>\n",
       "      <th>feb</th>\n",
       "      <th>feb_footnotes</th>\n",
       "      <th>mar</th>\n",
       "      <th>mar_footnotes</th>\n",
       "      <th>apr</th>\n",
       "      <th>apr_footnotes</th>\n",
       "      <th>may</th>\n",
       "      <th>...</th>\n",
       "      <th>oct</th>\n",
       "      <th>oct_footnotes</th>\n",
       "      <th>nov</th>\n",
       "      <th>nov_footnotes</th>\n",
       "      <th>dec</th>\n",
       "      <th>dec_footnotes</th>\n",
       "      <th>annual</th>\n",
       "      <th>annual_footnotes</th>\n",
       "      <th>annual_ncdc_computed_value</th>\n",
       "      <th>annual_ncdc_computed_value_footnotes</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>country_or_territory</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AFGHANISTAN, ISLAMIC STATE OF</th>\n",
       "      <td>40946.100000</td>\n",
       "      <td>160.870000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>154.670000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>195.245000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>221.655</td>\n",
       "      <td>NaN</td>\n",
       "      <td>289.655000</td>\n",
       "      <td>...</td>\n",
       "      <td>260.205000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>218.690000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>164.885000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>249.330</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2995.630000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARGENTINA</th>\n",
       "      <td>87488.280000</td>\n",
       "      <td>283.836000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>245.728000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>227.664000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>198.360</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171.616000</td>\n",
       "      <td>...</td>\n",
       "      <td>238.204000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>263.400000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>274.164000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2585.912</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2585.912000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARMENIA</th>\n",
       "      <td>37737.500000</td>\n",
       "      <td>94.500000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>106.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>160.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>174.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237.500000</td>\n",
       "      <td>...</td>\n",
       "      <td>210.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>137.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>92.500000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-9999.900</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2457.500000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AUSTRALIA</th>\n",
       "      <td>94659.200000</td>\n",
       "      <td>258.230000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223.626667</td>\n",
       "      <td>NaN</td>\n",
       "      <td>229.710000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>214.300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>194.886667</td>\n",
       "      <td>...</td>\n",
       "      <td>254.303333</td>\n",
       "      <td>NaN</td>\n",
       "      <td>252.200000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>262.260000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2746.770</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2746.770000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AUSTRALIA (ANTARCTIC STATIONS)</th>\n",
       "      <td>89567.500000</td>\n",
       "      <td>265.050000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>191.800000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>128.650000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.650000</td>\n",
       "      <td>...</td>\n",
       "      <td>198.400000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>241.500000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>274.350000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-9999.900</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1644.150000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AUSTRIA</th>\n",
       "      <td>11233.000000</td>\n",
       "      <td>73.285714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>98.714286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>138.714286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>161.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>199.142857</td>\n",
       "      <td>...</td>\n",
       "      <td>144.714286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.428571</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65.857143</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-9999.900</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1778.857143</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AZERBAIJAN</th>\n",
       "      <td>37819.555556</td>\n",
       "      <td>98.622222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.444444</td>\n",
       "      <td>NaN</td>\n",
       "      <td>127.422222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>181.300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>229.777778</td>\n",
       "      <td>...</td>\n",
       "      <td>152.588889</td>\n",
       "      <td>NaN</td>\n",
       "      <td>109.666667</td>\n",
       "      <td>NaN</td>\n",
       "      <td>107.844444</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-9999.900</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2151.877778</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BAHAMAS</th>\n",
       "      <td>78073.000000</td>\n",
       "      <td>220.100000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>212.800000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>257.300000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>276.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>269.700000</td>\n",
       "      <td>...</td>\n",
       "      <td>223.200000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>213.900000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2878.400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2878.400000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BAHRAIN</th>\n",
       "      <td>41150.000000</td>\n",
       "      <td>226.300000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>221.200000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>238.700000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>255.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>306.900000</td>\n",
       "      <td>...</td>\n",
       "      <td>303.800000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>261.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>226.300000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3353.600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3353.600000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                wmo_station_number         jan  jan_footnotes  \\\n",
       "country_or_territory                                                            \n",
       "1                                              NaN         NaN            NaN   \n",
       "AFGHANISTAN, ISLAMIC STATE OF         40946.100000  160.870000            NaN   \n",
       "ARGENTINA                             87488.280000  283.836000            NaN   \n",
       "ARMENIA                               37737.500000   94.500000            NaN   \n",
       "AUSTRALIA                             94659.200000  258.230000            NaN   \n",
       "AUSTRALIA (ANTARCTIC STATIONS)        89567.500000  265.050000            NaN   \n",
       "AUSTRIA                               11233.000000   73.285714            NaN   \n",
       "AZERBAIJAN                            37819.555556   98.622222            NaN   \n",
       "BAHAMAS                               78073.000000  220.100000            NaN   \n",
       "BAHRAIN                               41150.000000  226.300000            NaN   \n",
       "\n",
       "                                       feb  feb_footnotes         mar  \\\n",
       "country_or_territory                                                    \n",
       "1                                      NaN            NaN         NaN   \n",
       "AFGHANISTAN, ISLAMIC STATE OF   154.670000            NaN  195.245000   \n",
       "ARGENTINA                       245.728000            NaN  227.664000   \n",
       "ARMENIA                         106.000000            NaN  160.000000   \n",
       "AUSTRALIA                       223.626667            NaN  229.710000   \n",
       "AUSTRALIA (ANTARCTIC STATIONS)  191.800000            NaN  128.650000   \n",
       "AUSTRIA                          98.714286            NaN  138.714286   \n",
       "AZERBAIJAN                       95.444444            NaN  127.422222   \n",
       "BAHAMAS                         212.800000            NaN  257.300000   \n",
       "BAHRAIN                         221.200000            NaN  238.700000   \n",
       "\n",
       "                                mar_footnotes      apr  apr_footnotes  \\\n",
       "country_or_territory                                                    \n",
       "1                                         NaN      NaN            NaN   \n",
       "AFGHANISTAN, ISLAMIC STATE OF             NaN  221.655            NaN   \n",
       "ARGENTINA                                 NaN  198.360            NaN   \n",
       "ARMENIA                                   NaN  174.000            NaN   \n",
       "AUSTRALIA                                 NaN  214.300            NaN   \n",
       "AUSTRALIA (ANTARCTIC STATIONS)            NaN   88.500            NaN   \n",
       "AUSTRIA                                   NaN  161.000            NaN   \n",
       "AZERBAIJAN                                NaN  181.300            NaN   \n",
       "BAHAMAS                                   NaN  276.000            NaN   \n",
       "BAHRAIN                                   NaN  255.000            NaN   \n",
       "\n",
       "                                       may  ...         oct  oct_footnotes  \\\n",
       "country_or_territory                        ...                              \n",
       "1                                      NaN  ...         NaN            NaN   \n",
       "AFGHANISTAN, ISLAMIC STATE OF   289.655000  ...  260.205000            NaN   \n",
       "ARGENTINA                       171.616000  ...  238.204000            NaN   \n",
       "ARMENIA                         237.500000  ...  210.000000            NaN   \n",
       "AUSTRALIA                       194.886667  ...  254.303333            NaN   \n",
       "AUSTRALIA (ANTARCTIC STATIONS)   35.650000  ...  198.400000            NaN   \n",
       "AUSTRIA                         199.142857  ...  144.714286            NaN   \n",
       "AZERBAIJAN                      229.777778  ...  152.588889            NaN   \n",
       "BAHAMAS                         269.700000  ...  223.200000            NaN   \n",
       "BAHRAIN                         306.900000  ...  303.800000            NaN   \n",
       "\n",
       "                                       nov  nov_footnotes         dec  \\\n",
       "country_or_territory                                                    \n",
       "1                                      NaN            NaN         NaN   \n",
       "AFGHANISTAN, ISLAMIC STATE OF   218.690000            NaN  164.885000   \n",
       "ARGENTINA                       263.400000            NaN  274.164000   \n",
       "ARMENIA                         137.000000            NaN   92.500000   \n",
       "AUSTRALIA                       252.200000            NaN  262.260000   \n",
       "AUSTRALIA (ANTARCTIC STATIONS)  241.500000            NaN  274.350000   \n",
       "AUSTRIA                          80.428571            NaN   65.857143   \n",
       "AZERBAIJAN                      109.666667            NaN  107.844444   \n",
       "BAHAMAS                         222.000000            NaN  213.900000   \n",
       "BAHRAIN                         261.000000            NaN  226.300000   \n",
       "\n",
       "                                dec_footnotes    annual  annual_footnotes  \\\n",
       "country_or_territory                                                        \n",
       "1                                         NaN       NaN               NaN   \n",
       "AFGHANISTAN, ISLAMIC STATE OF             NaN   249.330               NaN   \n",
       "ARGENTINA                                 NaN  2585.912               NaN   \n",
       "ARMENIA                                   NaN -9999.900               1.0   \n",
       "AUSTRALIA                                 NaN  2746.770               NaN   \n",
       "AUSTRALIA (ANTARCTIC STATIONS)            NaN -9999.900               1.0   \n",
       "AUSTRIA                                   NaN -9999.900               1.0   \n",
       "AZERBAIJAN                                NaN -9999.900               1.0   \n",
       "BAHAMAS                                   NaN  2878.400               NaN   \n",
       "BAHRAIN                                   NaN  3353.600               NaN   \n",
       "\n",
       "                                annual_ncdc_computed_value  \\\n",
       "country_or_territory                                         \n",
       "1                                                      NaN   \n",
       "AFGHANISTAN, ISLAMIC STATE OF                  2995.630000   \n",
       "ARGENTINA                                      2585.912000   \n",
       "ARMENIA                                        2457.500000   \n",
       "AUSTRALIA                                      2746.770000   \n",
       "AUSTRALIA (ANTARCTIC STATIONS)                 1644.150000   \n",
       "AUSTRIA                                        1778.857143   \n",
       "AZERBAIJAN                                     2151.877778   \n",
       "BAHAMAS                                        2878.400000   \n",
       "BAHRAIN                                        3353.600000   \n",
       "\n",
       "                                annual_ncdc_computed_value_footnotes  \n",
       "country_or_territory                                                  \n",
       "1                                                                NaN  \n",
       "AFGHANISTAN, ISLAMIC STATE OF                                    NaN  \n",
       "ARGENTINA                                                        NaN  \n",
       "ARMENIA                                                          NaN  \n",
       "AUSTRALIA                                                        NaN  \n",
       "AUSTRALIA (ANTARCTIC STATIONS)                                   NaN  \n",
       "AUSTRIA                                                          NaN  \n",
       "AZERBAIJAN                                                       NaN  \n",
       "BAHAMAS                                                          NaN  \n",
       "BAHRAIN                                                          NaN  \n",
       "\n",
       "[10 rows x 29 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "grouped = df2.groupby('country_or_territory').mean()\n",
    "grouped.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "d0e0d9d2",
   "metadata": {},
   "outputs": [],
   "source": [
    "#save file \n",
    "striped.to_csv ('sunlight2.csv', header=True) \n"
   ]
  }
 ],
 "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}