{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "id": "xngb6vK81ve0" }, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "id": "ChATGJf4_vk6" }, "outputs": [], "source": [ "o3_and_no2 = pd.read_csv(r\"..\\data\\processed\\v2_sorted_griftpark,-utrecht-air-quality.csv\")" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 206 }, "id": "qF0ziyih_1YC", "outputId": "b464754d-f85b-489e-af6e-03c1a8d77244" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
datepm25pm10o3no2so2
011/09/2024246165
110/09/20242616273
209/09/20241514253
308/09/20241712319
407/09/20242513343
\n", "
" ], "text/plain": [ " date pm25 pm10 o3 no2 so2\n", "0 11/09/2024 24 6 16 5 \n", "1 10/09/2024 26 16 27 3 \n", "2 09/09/2024 15 14 25 3 \n", "3 08/09/2024 17 12 31 9 \n", "4 07/09/2024 25 13 34 3 " ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "o3_and_no2.head()" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 423 }, "id": "JsNZ-ezWGaWA", "outputId": "10ec2795-781c-4516-a62f-d1b6e6b047a7" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
datepm25pm10o3no2so2
011/09/2024246165
110/09/20242616273
209/09/20241514253
308/09/20241712319
407/09/20242513343
.....................
366502/02/20141711171
366601/02/201422188
366731/01/201448226
366830/01/20143817211
366929/01/20144171
\n", "

3670 rows × 6 columns

\n", "
" ], "text/plain": [ " date pm25 pm10 o3 no2 so2\n", "0 11/09/2024 24 6 16 5 \n", "1 10/09/2024 26 16 27 3 \n", "2 09/09/2024 15 14 25 3 \n", "3 08/09/2024 17 12 31 9 \n", "4 07/09/2024 25 13 34 3 \n", "... ... ... ... .. ... ...\n", "3665 02/02/2014 17 11 17 1\n", "3666 01/02/2014 22 18 8 \n", "3667 31/01/2014 48 22 6 \n", "3668 30/01/2014 38 17 21 1\n", "3669 29/01/2014 4 17 1\n", "\n", "[3670 rows x 6 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "o3_and_no2" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "id": "91wMW5HX_1py" }, "outputs": [], "source": [ "utrecht_additional_data = pd.read_csv(r\"..\\data\\raw\\v1_utrecht 2014-01-29 to 2024-09-11.csv\")" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 446 }, "id": "kh9AbRMiEvZE", "outputId": "00e5905a-7ea9-4910-e576-b7e15c4efe67" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
namedatetimetempmaxtempmintempfeelslikemaxfeelslikeminfeelslikedewhumidity...solarenergyuvindexsevererisksunrisesunsetmoonphaseconditionsdescriptioniconstations
0utrecht2014-01-293.2-1.80.6-1.0-7.5-4.7-1.983.9...6.53NaN2014-01-29T08:24:352014-01-29T17:21:210.95Partially cloudyPartly cloudy throughout the day.partly-cloudy-day06260099999
1utrecht2014-01-304.4-2.30.62.6-7.2-2.9-1.983.6...6.33NaN2014-01-30T08:23:062014-01-30T17:23:120.00Partially cloudyPartly cloudy throughout the day.partly-cloudy-day06260099999,remote
2utrecht2014-01-317.1-2.62.64.7-5.5-0.20.084.0...6.43NaN2014-01-31T08:21:342014-01-31T17:25:020.02Partially cloudyBecoming cloudy in the afternoon.partly-cloudy-day06260099999
3utrecht2014-02-018.45.46.65.31.32.83.882.6...1.41NaN2014-02-01T08:20:012014-02-01T17:26:540.05Rain, Partially cloudyPartly cloudy throughout the day with a chance...rain06260099999
4utrecht2014-02-027.73.25.35.1-0.71.82.079.7...6.13NaN2014-02-02T08:18:252014-02-02T17:28:450.08Partially cloudyBecoming cloudy in the afternoon.partly-cloudy-day06260099999
\n", "

5 rows × 33 columns

\n", "
" ], "text/plain": [ " name datetime tempmax tempmin temp feelslikemax feelslikemin \\\n", "0 utrecht 2014-01-29 3.2 -1.8 0.6 -1.0 -7.5 \n", "1 utrecht 2014-01-30 4.4 -2.3 0.6 2.6 -7.2 \n", "2 utrecht 2014-01-31 7.1 -2.6 2.6 4.7 -5.5 \n", "3 utrecht 2014-02-01 8.4 5.4 6.6 5.3 1.3 \n", "4 utrecht 2014-02-02 7.7 3.2 5.3 5.1 -0.7 \n", "\n", " feelslike dew humidity ... solarenergy uvindex severerisk \\\n", "0 -4.7 -1.9 83.9 ... 6.5 3 NaN \n", "1 -2.9 -1.9 83.6 ... 6.3 3 NaN \n", "2 -0.2 0.0 84.0 ... 6.4 3 NaN \n", "3 2.8 3.8 82.6 ... 1.4 1 NaN \n", "4 1.8 2.0 79.7 ... 6.1 3 NaN \n", "\n", " sunrise sunset moonphase \\\n", "0 2014-01-29T08:24:35 2014-01-29T17:21:21 0.95 \n", "1 2014-01-30T08:23:06 2014-01-30T17:23:12 0.00 \n", "2 2014-01-31T08:21:34 2014-01-31T17:25:02 0.02 \n", "3 2014-02-01T08:20:01 2014-02-01T17:26:54 0.05 \n", "4 2014-02-02T08:18:25 2014-02-02T17:28:45 0.08 \n", "\n", " conditions description \\\n", "0 Partially cloudy Partly cloudy throughout the day. \n", "1 Partially cloudy Partly cloudy throughout the day. \n", "2 Partially cloudy Becoming cloudy in the afternoon. \n", "3 Rain, Partially cloudy Partly cloudy throughout the day with a chance... \n", "4 Partially cloudy Becoming cloudy in the afternoon. \n", "\n", " icon stations \n", "0 partly-cloudy-day 06260099999 \n", "1 partly-cloudy-day 06260099999,remote \n", "2 partly-cloudy-day 06260099999 \n", "3 rain 06260099999 \n", "4 partly-cloudy-day 06260099999 \n", "\n", "[5 rows x 33 columns]" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "utrecht_additional_data.head()" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "id": "wWNdBHwKE0wm" }, "outputs": [], "source": [ "utrecht_additional_data['datetime'] = pd.to_datetime(utrecht_additional_data['datetime'], format='%Y-%m-%d')\n", "\n", "#day/month/year\n", "utrecht_additional_data['datetime'] = utrecht_additional_data['datetime'].dt.strftime('%d/%m/%Y')" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 446 }, "id": "zNT2SlcYFh9v", "outputId": "8ab8062b-06af-411a-a06a-70314d15c54b" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
namedatetimetempmaxtempmintempfeelslikemaxfeelslikeminfeelslikedewhumidity...solarenergyuvindexsevererisksunrisesunsetmoonphaseconditionsdescriptioniconstations
0utrecht29/01/20143.2-1.80.6-1.0-7.5-4.7-1.983.9...6.53NaN2014-01-29T08:24:352014-01-29T17:21:210.95Partially cloudyPartly cloudy throughout the day.partly-cloudy-day06260099999
1utrecht30/01/20144.4-2.30.62.6-7.2-2.9-1.983.6...6.33NaN2014-01-30T08:23:062014-01-30T17:23:120.00Partially cloudyPartly cloudy throughout the day.partly-cloudy-day06260099999,remote
2utrecht31/01/20147.1-2.62.64.7-5.5-0.20.084.0...6.43NaN2014-01-31T08:21:342014-01-31T17:25:020.02Partially cloudyBecoming cloudy in the afternoon.partly-cloudy-day06260099999
3utrecht01/02/20148.45.46.65.31.32.83.882.6...1.41NaN2014-02-01T08:20:012014-02-01T17:26:540.05Rain, Partially cloudyPartly cloudy throughout the day with a chance...rain06260099999
4utrecht02/02/20147.73.25.35.1-0.71.82.079.7...6.13NaN2014-02-02T08:18:252014-02-02T17:28:450.08Partially cloudyBecoming cloudy in the afternoon.partly-cloudy-day06260099999
\n", "

5 rows × 33 columns

\n", "
" ], "text/plain": [ " name datetime tempmax tempmin temp feelslikemax feelslikemin \\\n", "0 utrecht 29/01/2014 3.2 -1.8 0.6 -1.0 -7.5 \n", "1 utrecht 30/01/2014 4.4 -2.3 0.6 2.6 -7.2 \n", "2 utrecht 31/01/2014 7.1 -2.6 2.6 4.7 -5.5 \n", "3 utrecht 01/02/2014 8.4 5.4 6.6 5.3 1.3 \n", "4 utrecht 02/02/2014 7.7 3.2 5.3 5.1 -0.7 \n", "\n", " feelslike dew humidity ... solarenergy uvindex severerisk \\\n", "0 -4.7 -1.9 83.9 ... 6.5 3 NaN \n", "1 -2.9 -1.9 83.6 ... 6.3 3 NaN \n", "2 -0.2 0.0 84.0 ... 6.4 3 NaN \n", "3 2.8 3.8 82.6 ... 1.4 1 NaN \n", "4 1.8 2.0 79.7 ... 6.1 3 NaN \n", "\n", " sunrise sunset moonphase \\\n", "0 2014-01-29T08:24:35 2014-01-29T17:21:21 0.95 \n", "1 2014-01-30T08:23:06 2014-01-30T17:23:12 0.00 \n", "2 2014-01-31T08:21:34 2014-01-31T17:25:02 0.02 \n", "3 2014-02-01T08:20:01 2014-02-01T17:26:54 0.05 \n", "4 2014-02-02T08:18:25 2014-02-02T17:28:45 0.08 \n", "\n", " conditions description \\\n", "0 Partially cloudy Partly cloudy throughout the day. \n", "1 Partially cloudy Partly cloudy throughout the day. \n", "2 Partially cloudy Becoming cloudy in the afternoon. \n", "3 Rain, Partially cloudy Partly cloudy throughout the day with a chance... \n", "4 Partially cloudy Becoming cloudy in the afternoon. \n", "\n", " icon stations \n", "0 partly-cloudy-day 06260099999 \n", "1 partly-cloudy-day 06260099999,remote \n", "2 partly-cloudy-day 06260099999 \n", "3 rain 06260099999 \n", "4 partly-cloudy-day 06260099999 \n", "\n", "[5 rows x 33 columns]" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "utrecht_additional_data.head()" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "id": "Q_4dp9v5Fi1-" }, "outputs": [], "source": [ "merged_df = pd.merge(o3_and_no2, utrecht_additional_data, left_on='date', right_on='datetime')" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 877 }, "id": "6-3nXPubGWjW", "outputId": "f667bbce-1a60-4d6a-c6c9-65f43ab4b877" }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
datepm25pm10o3no2so2namedatetimetempmaxtempmin...solarenergyuvindexsevererisksunrisesunsetmoonphaseconditionsdescriptioniconstations
011/09/2024246165utrecht11/09/202414.59.2...17.3710.02024-09-11T07:08:062024-09-11T20:02:590.25Rain, Partially cloudyPartly cloudy throughout the day with a chance...rainremote
110/09/20242616273utrecht10/09/202416.612.4...6.8510.02024-09-10T07:06:282024-09-10T20:05:190.24Rain, OvercastCloudy skies throughout the day with rain.rainremote
209/09/20241514253utrecht09/09/202420.214.0...16.0610.02024-09-09T07:04:502024-09-09T20:07:390.21Rain, Partially cloudyPartly cloudy throughout the day with rain.rainremote
308/09/20241712319utrecht08/09/202421.914.9...17.7710.02024-09-08T07:03:122024-09-08T20:09:580.18Rain, Partially cloudyPartly cloudy throughout the day with early mo...rain06260099999,remote
407/09/20242513343utrecht07/09/202426.417.6...16.5610.02024-09-07T07:01:342024-09-07T20:12:180.14OvercastCloudy skies throughout the day.cloudy06260099999
..................................................................
366502/02/20141711171utrecht02/02/20147.73.2...6.13NaN2014-02-02T08:18:252014-02-02T17:28:450.08Partially cloudyBecoming cloudy in the afternoon.partly-cloudy-day06260099999
366601/02/201422188utrecht01/02/20148.45.4...1.41NaN2014-02-01T08:20:012014-02-01T17:26:540.05Rain, Partially cloudyPartly cloudy throughout the day with a chance...rain06260099999
366731/01/201448226utrecht31/01/20147.1-2.6...6.43NaN2014-01-31T08:21:342014-01-31T17:25:020.02Partially cloudyBecoming cloudy in the afternoon.partly-cloudy-day06260099999
366830/01/20143817211utrecht30/01/20144.4-2.3...6.33NaN2014-01-30T08:23:062014-01-30T17:23:120.00Partially cloudyPartly cloudy throughout the day.partly-cloudy-day06260099999,remote
366929/01/20144171utrecht29/01/20143.2-1.8...6.53NaN2014-01-29T08:24:352014-01-29T17:21:210.95Partially cloudyPartly cloudy throughout the day.partly-cloudy-day06260099999
\n", "

3670 rows × 39 columns

\n", "
" ], "text/plain": [ " date pm25 pm10 o3 no2 so2 name datetime tempmax \\\n", "0 11/09/2024 24 6 16 5 utrecht 11/09/2024 14.5 \n", "1 10/09/2024 26 16 27 3 utrecht 10/09/2024 16.6 \n", "2 09/09/2024 15 14 25 3 utrecht 09/09/2024 20.2 \n", "3 08/09/2024 17 12 31 9 utrecht 08/09/2024 21.9 \n", "4 07/09/2024 25 13 34 3 utrecht 07/09/2024 26.4 \n", "... ... ... ... .. ... ... ... ... ... \n", "3665 02/02/2014 17 11 17 1 utrecht 02/02/2014 7.7 \n", "3666 01/02/2014 22 18 8 utrecht 01/02/2014 8.4 \n", "3667 31/01/2014 48 22 6 utrecht 31/01/2014 7.1 \n", "3668 30/01/2014 38 17 21 1 utrecht 30/01/2014 4.4 \n", "3669 29/01/2014 4 17 1 utrecht 29/01/2014 3.2 \n", "\n", " tempmin ... solarenergy uvindex severerisk sunrise \\\n", "0 9.2 ... 17.3 7 10.0 2024-09-11T07:08:06 \n", "1 12.4 ... 6.8 5 10.0 2024-09-10T07:06:28 \n", "2 14.0 ... 16.0 6 10.0 2024-09-09T07:04:50 \n", "3 14.9 ... 17.7 7 10.0 2024-09-08T07:03:12 \n", "4 17.6 ... 16.5 6 10.0 2024-09-07T07:01:34 \n", "... ... ... ... ... ... ... \n", "3665 3.2 ... 6.1 3 NaN 2014-02-02T08:18:25 \n", "3666 5.4 ... 1.4 1 NaN 2014-02-01T08:20:01 \n", "3667 -2.6 ... 6.4 3 NaN 2014-01-31T08:21:34 \n", "3668 -2.3 ... 6.3 3 NaN 2014-01-30T08:23:06 \n", "3669 -1.8 ... 6.5 3 NaN 2014-01-29T08:24:35 \n", "\n", " sunset moonphase conditions \\\n", "0 2024-09-11T20:02:59 0.25 Rain, Partially cloudy \n", "1 2024-09-10T20:05:19 0.24 Rain, Overcast \n", "2 2024-09-09T20:07:39 0.21 Rain, Partially cloudy \n", "3 2024-09-08T20:09:58 0.18 Rain, Partially cloudy \n", "4 2024-09-07T20:12:18 0.14 Overcast \n", "... ... ... ... \n", "3665 2014-02-02T17:28:45 0.08 Partially cloudy \n", "3666 2014-02-01T17:26:54 0.05 Rain, Partially cloudy \n", "3667 2014-01-31T17:25:02 0.02 Partially cloudy \n", "3668 2014-01-30T17:23:12 0.00 Partially cloudy \n", "3669 2014-01-29T17:21:21 0.95 Partially cloudy \n", "\n", " description icon \\\n", "0 Partly cloudy throughout the day with a chance... rain \n", "1 Cloudy skies throughout the day with rain. rain \n", "2 Partly cloudy throughout the day with rain. rain \n", "3 Partly cloudy throughout the day with early mo... rain \n", "4 Cloudy skies throughout the day. cloudy \n", "... ... ... \n", "3665 Becoming cloudy in the afternoon. partly-cloudy-day \n", "3666 Partly cloudy throughout the day with a chance... rain \n", "3667 Becoming cloudy in the afternoon. partly-cloudy-day \n", "3668 Partly cloudy throughout the day. partly-cloudy-day \n", "3669 Partly cloudy throughout the day. partly-cloudy-day \n", "\n", " stations \n", "0 remote \n", "1 remote \n", "2 remote \n", "3 06260099999,remote \n", "4 06260099999 \n", "... ... \n", "3665 06260099999 \n", "3666 06260099999 \n", "3667 06260099999 \n", "3668 06260099999,remote \n", "3669 06260099999 \n", "\n", "[3670 rows x 39 columns]" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "merged_df" ] }, { "cell_type": "code", "execution_count": 15, "metadata": { "id": "gH6X91ctGXR6" }, "outputs": [], "source": [ "merged_df.to_csv('../data/processed/v1_merged_weather_data.csv')" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "id": "x_8saTUjGj-e" }, "outputs": [], "source": [] } ], "metadata": { "colab": { "provenance": [] }, "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.11.0" } }, "nbformat": 4, "nbformat_minor": 1 }