MLProjectWeatherDataModule.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib as mpl\n",
    "import matplotlib.pyplot as plt\n",
    "import pickle as pkl\n",
    "import math\n",
    "import requests\n",
    "import csv\n",
    "import sklearn\n",
    "import json\n",
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "def airport_column(airportname,nooftimes) :\n",
    "    \n",
    "    airport = []\n",
    "\n",
    "    for i in range(0,nooftimes):\n",
    "    \n",
    "        airport.append(airportname)\n",
    "        \n",
    "    return airport"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "def dates_column(filename):\n",
    "    \n",
    "    f = open(filename,'r')\n",
    "\n",
    "    unwanted_columns = ['mintempC', 'maxtempF', 'sunHour', 'mintempF', 'maxtempC','totalSnow_cm','astronomy', 'uvIndex']\n",
    "\n",
    "    data = json.loads(f.read())\n",
    "\n",
    "    dataframe = pd.DataFrame(data['data']['weather'])\n",
    "\n",
    "    dataframes = dataframe.drop(unwanted_columns,axis = 1)\n",
    "\n",
    "    dataframe = pd.DataFrame(dataframes['hourly'])\n",
    "\n",
    "    dataframes = dataframes.drop(['hourly'],axis = 1)\n",
    "\n",
    "    dataframes = dataframes.loc[dataframes.index.repeat(24)].reset_index(drop=True)\n",
    "\n",
    "    dates = dataframes['date']\n",
    "    \n",
    "    return dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def final_dataframe(filename,noofdays,airport):\n",
    "    \n",
    "        f = open(filename,'r')\n",
    "\n",
    "        unwanted_columns = ['mintempC', 'maxtempF', 'sunHour', 'mintempF', 'maxtempC','totalSnow_cm','astronomy', 'uvIndex']\n",
    "\n",
    "        unwanted_columns1 = ['FeelsLikeF','winddir16Point','FeelsLikeC','DewPointC','windspeedMiles','HeatIndexF','HeatIndexC','weatherIconUrl','WindGustMiles','weatherDesc','tempC','WindChillC']\n",
    "\n",
    "        data = json.loads(f.read())\n",
    "\n",
    "        dataframe = pd.DataFrame(data['data']['weather'])\n",
    "\n",
    "        dataframes = dataframe.drop(unwanted_columns,axis = 1)\n",
    "\n",
    "        dataframe = pd.DataFrame(dataframes['hourly'])\n",
    "\n",
    "        dictionary1 = dataframe.iloc[0]['hourly'][0]\n",
    "\n",
    "        dataframe1 = pd.DataFrame.from_dict(dictionary1)\n",
    "\n",
    "        dataframess = pd.DataFrame(columns = dataframe1.columns)\n",
    "\n",
    "        for j in range(0,noofdays):\n",
    "\n",
    "            dictionary1 = dataframe.iloc[j]['hourly'][0]\n",
    "\n",
    "            dataframe1 = pd.DataFrame.from_dict(dictionary1)\n",
    "\n",
    "            dictionary2 = dataframe.iloc[j]['hourly'][1]\n",
    "\n",
    "            dataframe2 = pd.DataFrame.from_dict(dictionary2)\n",
    "\n",
    "            dataframe1 = dataframe1.append(dataframe2,ignore_index = True)\n",
    "\n",
    "            for i in range(2,24) :\n",
    "\n",
    "                dictionary2 = dataframe.iloc[j]['hourly'][i]\n",
    "\n",
    "                dataframe2 = pd.DataFrame.from_dict(dictionary2)\n",
    "\n",
    "                dataframe1 = dataframe1.append(dataframe2,ignore_index = True)\n",
    "\n",
    "            dataframess = dataframess.append(dataframe1,ignore_index = True)\n",
    "\n",
    "        dataframess = dataframess.drop(unwanted_columns1,axis = 1).drop_duplicates()\n",
    "        \n",
    "        nooftimes = noofdays * 24\n",
    "\n",
    "        dataframess['Airport'] = airport_column(airport,nooftimes)\n",
    "\n",
    "        dataframess['Date'] = dates_column(filename)\n",
    "\n",
    "        return dataframess"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "def json_to_csv(filename,filename1,noofdays,airport) :\n",
    "    \n",
    "    f = open(filename,'r')\n",
    "    \n",
    "    data = json.loads(f.read())\n",
    "    \n",
    "    dataframe = final_dataframe(filename,noofdays,airport)\n",
    "    \n",
    "    dataframe.to_csv(filename1)\n",
    "    \n",
    "    return dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "ATL_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-1.csv',31,'ATL')\n",
    "\n",
    "ATL_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-2.csv',29,'ATL')\n",
    "\n",
    "ATL_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-3.csv',31,'ATL')\n",
    "\n",
    "ATL_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-4.csv',30,'ATL')\n",
    "\n",
    "ATL_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-5.csv',31,'ATL')\n",
    "\n",
    "ATL_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-6.csv',30,'ATL')\n",
    "\n",
    "ATL_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-7.csv',31,'ATL')\n",
    "\n",
    "ATL_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-8.csv',31,'ATL')\n",
    "\n",
    "ATL_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-9.csv',30,'ATL')\n",
    "\n",
    "ATL_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-10.csv',31,'ATL')\n",
    "\n",
    "ATL_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-11.csv',30,'ATL')\n",
    "\n",
    "ATL_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2016-12.csv',31,'ATL')\n",
    "\n",
    "\n",
    "\n",
    "ATL_2016_A = ATL_2016_1.append(ATL_2016_2,ignore_index = True).append(ATL_2016_3,ignore_index = True).append(ATL_2016_4,ignore_index = True)\n",
    "\n",
    "ATL_2016_B = ATL_2016_5.append(ATL_2016_6,ignore_index = True).append(ATL_2016_7,ignore_index = True).append(ATL_2016_8,ignore_index = True)\n",
    "\n",
    "ATL_2016_C = ATL_2016_9.append(ATL_2016_10,ignore_index = True).append(ATL_2016_11,ignore_index = True).append(ATL_2016_12,ignore_index = True)\n",
    "\n",
    "ATL_2016 = ATL_2016_A.append(ATL_2016_B,ignore_index = True).append(ATL_2016_C,ignore_index = True)\n",
    "\n",
    "ATL_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\ATL_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "ATL_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-1.csv',31,'ATL')\n",
    "\n",
    "ATL_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-2.csv',28,'ATL')\n",
    "\n",
    "ATL_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-3.csv',31,'ATL')\n",
    "\n",
    "ATL_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-4.csv',30,'ATL')\n",
    "\n",
    "ATL_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-5.csv',31,'ATL')\n",
    "\n",
    "ATL_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-6.csv',30,'ATL')\n",
    "\n",
    "ATL_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-7.csv',31,'ATL')\n",
    "\n",
    "ATL_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-8.csv',31,'ATL')\n",
    "\n",
    "ATL_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-9.csv',30,'ATL')\n",
    "\n",
    "ATL_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-10.csv',31,'ATL')\n",
    "\n",
    "ATL_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-11.csv',30,'ATL')\n",
    "\n",
    "ATL_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\2017-12.csv',31,'ATL')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "ATL_2017_A = ATL_2017_1.append(ATL_2017_2,ignore_index = True).append(ATL_2017_3,ignore_index = True).append(ATL_2017_4,ignore_index = True)\n",
    "\n",
    "ATL_2017_B = ATL_2017_5.append(ATL_2017_6,ignore_index = True).append(ATL_2017_7,ignore_index = True).append(ATL_2017_8,ignore_index = True)\n",
    "\n",
    "ATL_2017_C = ATL_2017_9.append(ATL_2017_10,ignore_index = True).append(ATL_2017_11,ignore_index = True).append(ATL_2017_12,ignore_index = True)\n",
    "\n",
    "ATL_2017 = ATL_2017_A.append(ATL_2017_B,ignore_index = True).append(ATL_2017_C,ignore_index = True)\n",
    "\n",
    "ATL_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\ATL_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "ATL = ATL_2016.append(ATL_2017,ignore_index = True)\n",
    "\n",
    "ATL.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ATL\\ATL_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "CLT_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-1.csv',31,'CLT')\n",
    "\n",
    "CLT_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-2.csv',29,'CLT')\n",
    "\n",
    "CLT_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-3.csv',31,'CLT')\n",
    "\n",
    "CLT_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-4.csv',30,'CLT')\n",
    "\n",
    "CLT_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-5.csv',31,'CLT')\n",
    "\n",
    "CLT_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-6.csv',30,'CLT')\n",
    "\n",
    "CLT_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-7.csv',31,'CLT')\n",
    "\n",
    "CLT_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-8.csv',31,'CLT')\n",
    "\n",
    "CLT_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-9.csv',30,'CLT')\n",
    "\n",
    "CLT_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-10.csv',31,'CLT')\n",
    "\n",
    "CLT_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-11.csv',30,'CLT')\n",
    "\n",
    "CLT_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2016-12.csv',31,'CLT')\n",
    "\n",
    "\n",
    "\n",
    "CLT_2016_A = CLT_2016_1.append(CLT_2016_2,ignore_index = True).append(CLT_2016_3,ignore_index = True).append(CLT_2016_4,ignore_index = True)\n",
    "\n",
    "CLT_2016_B = CLT_2016_5.append(CLT_2016_6,ignore_index = True).append(CLT_2016_7,ignore_index = True).append(CLT_2016_8,ignore_index = True)\n",
    "\n",
    "CLT_2016_C = CLT_2016_9.append(CLT_2016_10,ignore_index = True).append(CLT_2016_11,ignore_index = True).append(CLT_2016_12,ignore_index = True)\n",
    "\n",
    "CLT_2016 = CLT_2016_A.append(CLT_2016_B,ignore_index = True).append(CLT_2016_C,ignore_index = True)\n",
    "\n",
    "CLT_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\CLT_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "CLT_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-1.csv',31,'CLT')\n",
    "\n",
    "CLT_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-2.csv',28,'CLT')\n",
    "\n",
    "CLT_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-3.csv',31,'CLT')\n",
    "\n",
    "CLT_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-4.csv',30,'CLT')\n",
    "\n",
    "CLT_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-5.csv',31,'CLT')\n",
    "\n",
    "CLT_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-6.csv',30,'CLT')\n",
    "\n",
    "CLT_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-7.csv',31,'CLT')\n",
    "\n",
    "CLT_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-8.csv',31,'CLT')\n",
    "\n",
    "CLT_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-9.csv',30,'CLT')\n",
    "\n",
    "CLT_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-10.csv',31,'CLT')\n",
    "\n",
    "CLT_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-11.csv',30,'CLT')\n",
    "\n",
    "CLT_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\2017-12.csv',31,'CLT')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "CLT_2017_A = CLT_2017_1.append(CLT_2017_2,ignore_index = True).append(CLT_2017_3,ignore_index = True).append(CLT_2017_4,ignore_index = True)\n",
    "\n",
    "CLT_2017_B = CLT_2017_5.append(CLT_2017_6,ignore_index = True).append(CLT_2017_7,ignore_index = True).append(CLT_2017_8,ignore_index = True)\n",
    "\n",
    "CLT_2017_C = CLT_2017_9.append(CLT_2017_10,ignore_index = True).append(CLT_2017_11,ignore_index = True).append(CLT_2017_12,ignore_index = True)\n",
    "\n",
    "CLT_2017 = CLT_2017_A.append(CLT_2017_B,ignore_index = True).append(CLT_2017_C,ignore_index = True)\n",
    "\n",
    "CLT_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\CLT_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "CLT = CLT_2016.append(CLT_2017,ignore_index = True)\n",
    "\n",
    "CLT.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\CLT\\CLT_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "DEN_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-1.csv',31,'DEN')\n",
    "\n",
    "DEN_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-2.csv',29,'DEN')\n",
    "\n",
    "DEN_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-3.csv',31,'DEN')\n",
    "\n",
    "DEN_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-4.csv',30,'DEN')\n",
    "\n",
    "DEN_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-5.csv',31,'DEN')\n",
    "\n",
    "DEN_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-6.csv',30,'DEN')\n",
    "\n",
    "DEN_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-7.csv',31,'DEN')\n",
    "\n",
    "DEN_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-8.csv',31,'DEN')\n",
    "\n",
    "DEN_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-9.csv',30,'DEN')\n",
    "\n",
    "DEN_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-10.csv',31,'DEN')\n",
    "\n",
    "DEN_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-11.csv',30,'DEN')\n",
    "\n",
    "DEN_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2016-12.csv',31,'DEN')\n",
    "\n",
    "\n",
    "\n",
    "DEN_2016_A = DEN_2016_1.append(DEN_2016_2,ignore_index = True).append(DEN_2016_3,ignore_index = True).append(DEN_2016_4,ignore_index = True)\n",
    "\n",
    "DEN_2016_B = DEN_2016_5.append(DEN_2016_6,ignore_index = True).append(DEN_2016_7,ignore_index = True).append(DEN_2016_8,ignore_index = True)\n",
    "\n",
    "DEN_2016_C = DEN_2016_9.append(DEN_2016_10,ignore_index = True).append(DEN_2016_11,ignore_index = True).append(DEN_2016_12,ignore_index = True)\n",
    "\n",
    "DEN_2016 = DEN_2016_A.append(DEN_2016_B,ignore_index = True).append(DEN_2016_C,ignore_index = True)\n",
    "\n",
    "DEN_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\DEN_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "DEN_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-1.csv',31,'DEN')\n",
    "\n",
    "DEN_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-2.csv',28,'DEN')\n",
    "\n",
    "DEN_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-3.csv',31,'DEN')\n",
    "\n",
    "DEN_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-4.csv',30,'DEN')\n",
    "\n",
    "DEN_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-5.csv',31,'DEN')\n",
    "\n",
    "DEN_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-6.csv',30,'DEN')\n",
    "\n",
    "DEN_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-7.csv',31,'DEN')\n",
    "\n",
    "DEN_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-8.csv',31,'DEN')\n",
    "\n",
    "DEN_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-9.csv',30,'DEN')\n",
    "\n",
    "DEN_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-10.csv',31,'DEN')\n",
    "\n",
    "DEN_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-11.csv',30,'DEN')\n",
    "\n",
    "DEN_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\2017-12.csv',31,'DEN')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "DEN_2017_A = DEN_2017_1.append(DEN_2017_2,ignore_index = True).append(DEN_2017_3,ignore_index = True).append(DEN_2017_4,ignore_index = True)\n",
    "\n",
    "DEN_2017_B = DEN_2017_5.append(DEN_2017_6,ignore_index = True).append(DEN_2017_7,ignore_index = True).append(DEN_2017_8,ignore_index = True)\n",
    "\n",
    "DEN_2017_C = DEN_2017_9.append(DEN_2017_10,ignore_index = True).append(DEN_2017_11,ignore_index = True).append(DEN_2017_12,ignore_index = True)\n",
    "\n",
    "DEN_2017 = DEN_2017_A.append(DEN_2017_B,ignore_index = True).append(DEN_2017_C,ignore_index = True)\n",
    "\n",
    "DEN_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\DEN_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "DEN = DEN_2016.append(DEN_2017,ignore_index = True)\n",
    "\n",
    "DEN.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DEN\\DEN_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "DFW_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-1.csv',31,'DFW')\n",
    "\n",
    "DFW_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-2.csv',29,'DFW')\n",
    "\n",
    "DFW_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-3.csv',31,'DFW')\n",
    "\n",
    "DFW_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-4.csv',30,'DFW')\n",
    "\n",
    "DFW_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-5.csv',31,'DFW')\n",
    "\n",
    "DFW_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-6.csv',30,'DFW')\n",
    "\n",
    "DFW_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-7.csv',31,'DFW')\n",
    "\n",
    "DFW_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-8.csv',31,'DFW')\n",
    "\n",
    "DFW_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-9.csv',30,'DFW')\n",
    "\n",
    "DFW_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-10.csv',31,'DFW')\n",
    "\n",
    "DFW_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-11.csv',30,'DFW')\n",
    "\n",
    "DFW_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2016-12.csv',31,'DFW')\n",
    "\n",
    "\n",
    "\n",
    "DFW_2016_A = DFW_2016_1.append(DFW_2016_2,ignore_index = True).append(DFW_2016_3,ignore_index = True).append(DFW_2016_4,ignore_index = True)\n",
    "\n",
    "DFW_2016_B = DFW_2016_5.append(DFW_2016_6,ignore_index = True).append(DFW_2016_7,ignore_index = True).append(DFW_2016_8,ignore_index = True)\n",
    "\n",
    "DFW_2016_C = DFW_2016_9.append(DFW_2016_10,ignore_index = True).append(DFW_2016_11,ignore_index = True).append(DFW_2016_12,ignore_index = True)\n",
    "\n",
    "DFW_2016 = DFW_2016_A.append(DFW_2016_B,ignore_index = True).append(DFW_2016_C,ignore_index = True)\n",
    "\n",
    "DFW_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\DFW_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "DFW_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-1.csv',31,'DFW')\n",
    "\n",
    "DFW_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-2.csv',28,'DFW')\n",
    "\n",
    "DFW_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-3.csv',31,'DFW')\n",
    "\n",
    "DFW_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-4.csv',30,'DFW')\n",
    "\n",
    "DFW_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-5.csv',31,'DFW')\n",
    "\n",
    "DFW_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-6.csv',30,'DFW')\n",
    "\n",
    "DFW_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-7.csv',31,'DFW')\n",
    "\n",
    "DFW_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-8.csv',31,'DFW')\n",
    "\n",
    "DFW_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-9.csv',30,'DFW')\n",
    "\n",
    "DFW_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-10.csv',31,'DFW')\n",
    "\n",
    "DFW_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-11.csv',30,'DFW')\n",
    "\n",
    "DFW_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\2017-12.csv',31,'DFW')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "DFW_2017_A = DFW_2017_1.append(DFW_2017_2,ignore_index = True).append(DFW_2017_3,ignore_index = True).append(DFW_2017_4,ignore_index = True)\n",
    "\n",
    "DFW_2017_B = DFW_2017_5.append(DFW_2017_6,ignore_index = True).append(DFW_2017_7,ignore_index = True).append(DFW_2017_8,ignore_index = True)\n",
    "\n",
    "DFW_2017_C = DFW_2017_9.append(DFW_2017_10,ignore_index = True).append(DFW_2017_11,ignore_index = True).append(DFW_2017_12,ignore_index = True)\n",
    "\n",
    "DFW_2017 = DFW_2017_A.append(DFW_2017_B,ignore_index = True).append(DFW_2017_C,ignore_index = True)\n",
    "\n",
    "DFW_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\DFW_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "DFW = DFW_2016.append(DFW_2017,ignore_index = True)\n",
    "\n",
    "DFW.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\DFW\\DFW_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "EWR_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-1.csv',31,'EWR')\n",
    "\n",
    "EWR_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-2.csv',29,'EWR')\n",
    "\n",
    "EWR_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-3.csv',31,'EWR')\n",
    "\n",
    "EWR_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-4.csv',30,'EWR')\n",
    "\n",
    "EWR_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-5.csv',31,'EWR')\n",
    "\n",
    "EWR_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-6.csv',30,'EWR')\n",
    "\n",
    "EWR_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-7.csv',31,'EWR')\n",
    "\n",
    "EWR_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-8.csv',31,'EWR')\n",
    "\n",
    "EWR_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-9.csv',30,'EWR')\n",
    "\n",
    "EWR_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-10.csv',31,'EWR')\n",
    "\n",
    "EWR_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-11.csv',30,'EWR')\n",
    "\n",
    "EWR_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2016-12.csv',31,'EWR')\n",
    "\n",
    "\n",
    "\n",
    "EWR_2016_A = EWR_2016_1.append(EWR_2016_2,ignore_index = True).append(EWR_2016_3,ignore_index = True).append(EWR_2016_4,ignore_index = True)\n",
    "\n",
    "EWR_2016_B = EWR_2016_5.append(EWR_2016_6,ignore_index = True).append(EWR_2016_7,ignore_index = True).append(EWR_2016_8,ignore_index = True)\n",
    "\n",
    "EWR_2016_C = EWR_2016_9.append(EWR_2016_10,ignore_index = True).append(EWR_2016_11,ignore_index = True).append(EWR_2016_12,ignore_index = True)\n",
    "\n",
    "EWR_2016 = EWR_2016_A.append(EWR_2016_B,ignore_index = True).append(EWR_2016_C,ignore_index = True)\n",
    "\n",
    "EWR_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\EWR_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "EWR_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-1.csv',31,'EWR')\n",
    "\n",
    "EWR_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-2.csv',28,'EWR')\n",
    "\n",
    "EWR_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-3.csv',31,'EWR')\n",
    "\n",
    "EWR_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-4.csv',30,'EWR')\n",
    "\n",
    "EWR_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-5.csv',31,'EWR')\n",
    "\n",
    "EWR_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-6.csv',30,'EWR')\n",
    "\n",
    "EWR_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-7.csv',31,'EWR')\n",
    "\n",
    "EWR_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-8.csv',31,'EWR')\n",
    "\n",
    "EWR_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-9.csv',30,'EWR')\n",
    "\n",
    "EWR_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-10.csv',31,'EWR')\n",
    "\n",
    "EWR_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-11.csv',30,'EWR')\n",
    "\n",
    "EWR_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\2017-12.csv',31,'EWR')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "EWR_2017_A = EWR_2017_1.append(EWR_2017_2,ignore_index = True).append(EWR_2017_3,ignore_index = True).append(EWR_2017_4,ignore_index = True)\n",
    "\n",
    "EWR_2017_B = EWR_2017_5.append(EWR_2017_6,ignore_index = True).append(EWR_2017_7,ignore_index = True).append(EWR_2017_8,ignore_index = True)\n",
    "\n",
    "EWR_2017_C = EWR_2017_9.append(EWR_2017_10,ignore_index = True).append(EWR_2017_11,ignore_index = True).append(EWR_2017_12,ignore_index = True)\n",
    "\n",
    "EWR_2017 = EWR_2017_A.append(EWR_2017_B,ignore_index = True).append(EWR_2017_C,ignore_index = True)\n",
    "\n",
    "EWR_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\EWR_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "EWR = EWR_2016.append(EWR_2017,ignore_index = True)\n",
    "\n",
    "EWR.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\EWR\\EWR_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "IAH_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-1.csv',31,'IAH')\n",
    "\n",
    "IAH_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-2.csv',29,'IAH')\n",
    "\n",
    "IAH_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-3.csv',31,'IAH')\n",
    "\n",
    "IAH_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-4.csv',30,'IAH')\n",
    "\n",
    "IAH_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-5.csv',31,'IAH')\n",
    "\n",
    "IAH_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-6.csv',30,'IAH')\n",
    "\n",
    "IAH_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-7.csv',31,'IAH')\n",
    "\n",
    "IAH_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-8.csv',31,'IAH')\n",
    "\n",
    "IAH_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-9.csv',30,'IAH')\n",
    "\n",
    "IAH_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-10.csv',31,'IAH')\n",
    "\n",
    "IAH_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-11.csv',30,'IAH')\n",
    "\n",
    "IAH_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2016-12.csv',31,'IAH')\n",
    "\n",
    "\n",
    "\n",
    "IAH_2016_A = IAH_2016_1.append(IAH_2016_2,ignore_index = True).append(IAH_2016_3,ignore_index = True).append(IAH_2016_4,ignore_index = True)\n",
    "\n",
    "IAH_2016_B = IAH_2016_5.append(IAH_2016_6,ignore_index = True).append(IAH_2016_7,ignore_index = True).append(IAH_2016_8,ignore_index = True)\n",
    "\n",
    "IAH_2016_C = IAH_2016_9.append(IAH_2016_10,ignore_index = True).append(IAH_2016_11,ignore_index = True).append(IAH_2016_12,ignore_index = True)\n",
    "\n",
    "IAH_2016 = IAH_2016_A.append(IAH_2016_B,ignore_index = True).append(IAH_2016_C,ignore_index = True)\n",
    "\n",
    "IAH_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\IAH_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "IAH_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-1.csv',31,'IAH')\n",
    "\n",
    "IAH_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-2.csv',28,'IAH')\n",
    "\n",
    "IAH_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-3.csv',31,'IAH')\n",
    "\n",
    "IAH_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-4.csv',30,'IAH')\n",
    "\n",
    "IAH_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-5.csv',31,'IAH')\n",
    "\n",
    "IAH_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-6.csv',30,'IAH')\n",
    "\n",
    "IAH_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-7.csv',31,'IAH')\n",
    "\n",
    "IAH_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-8.csv',31,'IAH')\n",
    "\n",
    "IAH_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-9.csv',30,'IAH')\n",
    "\n",
    "IAH_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-10.csv',31,'IAH')\n",
    "\n",
    "IAH_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-11.csv',30,'IAH')\n",
    "\n",
    "IAH_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\2017-12.csv',31,'IAH')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "IAH_2017_A = IAH_2017_1.append(IAH_2017_2,ignore_index = True).append(IAH_2017_3,ignore_index = True).append(IAH_2017_4,ignore_index = True)\n",
    "\n",
    "IAH_2017_B = IAH_2017_5.append(IAH_2017_6,ignore_index = True).append(IAH_2017_7,ignore_index = True).append(IAH_2017_8,ignore_index = True)\n",
    "\n",
    "IAH_2017_C = IAH_2017_9.append(IAH_2017_10,ignore_index = True).append(IAH_2017_11,ignore_index = True).append(IAH_2017_12,ignore_index = True)\n",
    "\n",
    "IAH_2017 = IAH_2017_A.append(IAH_2017_B,ignore_index = True).append(IAH_2017_C,ignore_index = True)\n",
    "\n",
    "IAH_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\IAH_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "IAH = IAH_2016.append(IAH_2017,ignore_index = True)\n",
    "\n",
    "IAH.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\IAH\\IAH_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "JFK_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-1.csv',31,'JFK')\n",
    "\n",
    "JFK_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-2.csv',29,'JFK')\n",
    "\n",
    "JFK_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-3.csv',31,'JFK')\n",
    "\n",
    "JFK_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-4.csv',30,'JFK')\n",
    "\n",
    "JFK_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-5.csv',31,'JFK')\n",
    "\n",
    "JFK_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-6.csv',30,'JFK')\n",
    "\n",
    "JFK_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-7.csv',31,'JFK')\n",
    "\n",
    "JFK_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-8.csv',31,'JFK')\n",
    "\n",
    "JFK_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-9.csv',30,'JFK')\n",
    "\n",
    "JFK_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-10.csv',31,'JFK')\n",
    "\n",
    "JFK_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-11.csv',30,'JFK')\n",
    "\n",
    "JFK_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2016-12.csv',31,'JFK')\n",
    "\n",
    "\n",
    "\n",
    "JFK_2016_A = JFK_2016_1.append(JFK_2016_2,ignore_index = True).append(JFK_2016_3,ignore_index = True).append(JFK_2016_4,ignore_index = True)\n",
    "\n",
    "JFK_2016_B = JFK_2016_5.append(JFK_2016_6,ignore_index = True).append(JFK_2016_7,ignore_index = True).append(JFK_2016_8,ignore_index = True)\n",
    "\n",
    "JFK_2016_C = JFK_2016_9.append(JFK_2016_10,ignore_index = True).append(JFK_2016_11,ignore_index = True).append(JFK_2016_12,ignore_index = True)\n",
    "\n",
    "JFK_2016 = JFK_2016_A.append(JFK_2016_B,ignore_index = True).append(JFK_2016_C,ignore_index = True)\n",
    "\n",
    "JFK_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\JFK_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "JFK_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-1.csv',31,'JFK')\n",
    "\n",
    "JFK_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-2.csv',28,'JFK')\n",
    "\n",
    "JFK_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-3.csv',31,'JFK')\n",
    "\n",
    "JFK_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-4.csv',30,'JFK')\n",
    "\n",
    "JFK_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-5.csv',31,'JFK')\n",
    "\n",
    "JFK_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-6.csv',30,'JFK')\n",
    "\n",
    "JFK_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-7.csv',31,'JFK')\n",
    "\n",
    "JFK_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-8.csv',31,'JFK')\n",
    "\n",
    "JFK_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-9.csv',30,'JFK')\n",
    "\n",
    "JFK_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-10.csv',31,'JFK')\n",
    "\n",
    "JFK_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-11.csv',30,'JFK')\n",
    "\n",
    "JFK_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\2017-12.csv',31,'JFK')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "JFK_2017_A = JFK_2017_1.append(JFK_2017_2,ignore_index = True).append(JFK_2017_3,ignore_index = True).append(JFK_2017_4,ignore_index = True)\n",
    "\n",
    "JFK_2017_B = JFK_2017_5.append(JFK_2017_6,ignore_index = True).append(JFK_2017_7,ignore_index = True).append(JFK_2017_8,ignore_index = True)\n",
    "\n",
    "JFK_2017_C = JFK_2017_9.append(JFK_2017_10,ignore_index = True).append(JFK_2017_11,ignore_index = True).append(JFK_2017_12,ignore_index = True)\n",
    "\n",
    "JFK_2017 = JFK_2017_A.append(JFK_2017_B,ignore_index = True).append(JFK_2017_C,ignore_index = True)\n",
    "\n",
    "JFK_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\JFK_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "JFK = JFK_2016.append(JFK_2017,ignore_index = True)\n",
    "\n",
    "JFK.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\JFK\\JFK_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "LAS_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-1.csv',31,'LAS')\n",
    "\n",
    "LAS_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-2.csv',29,'LAS')\n",
    "\n",
    "LAS_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-3.csv',31,'LAS')\n",
    "\n",
    "LAS_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-4.csv',30,'LAS')\n",
    "\n",
    "LAS_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-5.csv',31,'LAS')\n",
    "\n",
    "LAS_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-6.csv',30,'LAS')\n",
    "\n",
    "LAS_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-7.csv',31,'LAS')\n",
    "\n",
    "LAS_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-8.csv',31,'LAS')\n",
    "\n",
    "LAS_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-9.csv',30,'LAS')\n",
    "\n",
    "LAS_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-10.csv',31,'LAS')\n",
    "\n",
    "LAS_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-11.csv',30,'LAS')\n",
    "\n",
    "LAS_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2016-12.csv',31,'LAS')\n",
    "\n",
    "\n",
    "\n",
    "LAS_2016_A = LAS_2016_1.append(LAS_2016_2,ignore_index = True).append(LAS_2016_3,ignore_index = True).append(LAS_2016_4,ignore_index = True)\n",
    "\n",
    "LAS_2016_B = LAS_2016_5.append(LAS_2016_6,ignore_index = True).append(LAS_2016_7,ignore_index = True).append(LAS_2016_8,ignore_index = True)\n",
    "\n",
    "LAS_2016_C = LAS_2016_9.append(LAS_2016_10,ignore_index = True).append(LAS_2016_11,ignore_index = True).append(LAS_2016_12,ignore_index = True)\n",
    "\n",
    "LAS_2016 = LAS_2016_A.append(LAS_2016_B,ignore_index = True).append(LAS_2016_C,ignore_index = True)\n",
    "\n",
    "LAS_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\LAS_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "LAS_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-1.csv',31,'LAS')\n",
    "\n",
    "LAS_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-2.csv',28,'LAS')\n",
    "\n",
    "LAS_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-3.csv',31,'LAS')\n",
    "\n",
    "LAS_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-4.csv',30,'LAS')\n",
    "\n",
    "LAS_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-5.csv',31,'LAS')\n",
    "\n",
    "LAS_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-6.csv',30,'LAS')\n",
    "\n",
    "LAS_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-7.csv',31,'LAS')\n",
    "\n",
    "LAS_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-8.csv',31,'LAS')\n",
    "\n",
    "LAS_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-9.csv',30,'LAS')\n",
    "\n",
    "LAS_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-10.csv',31,'LAS')\n",
    "\n",
    "LAS_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-11.csv',30,'LAS')\n",
    "\n",
    "LAS_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\2017-12.csv',31,'LAS')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "LAS_2017_A = LAS_2017_1.append(LAS_2017_2,ignore_index = True).append(LAS_2017_3,ignore_index = True).append(LAS_2017_4,ignore_index = True)\n",
    "\n",
    "LAS_2017_B = LAS_2017_5.append(LAS_2017_6,ignore_index = True).append(LAS_2017_7,ignore_index = True).append(LAS_2017_8,ignore_index = True)\n",
    "\n",
    "LAS_2017_C = LAS_2017_9.append(LAS_2017_10,ignore_index = True).append(LAS_2017_11,ignore_index = True).append(LAS_2017_12,ignore_index = True)\n",
    "\n",
    "LAS_2017 = LAS_2017_A.append(LAS_2017_B,ignore_index = True).append(LAS_2017_C,ignore_index = True)\n",
    "\n",
    "LAS_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\LAS_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "LAS = LAS_2016.append(LAS_2017,ignore_index = True)\n",
    "\n",
    "LAS.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAS\\LAS_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "LAX_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-1.csv',31,'LAX')\n",
    "\n",
    "LAX_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-2.csv',29,'LAX')\n",
    "\n",
    "LAX_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-3.csv',31,'LAX')\n",
    "\n",
    "LAX_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-4.csv',30,'LAX')\n",
    "\n",
    "LAX_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-5.csv',31,'LAX')\n",
    "\n",
    "LAX_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-6.csv',30,'LAX')\n",
    "\n",
    "LAX_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-7.csv',31,'LAX')\n",
    "\n",
    "LAX_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-8.csv',31,'LAX')\n",
    "\n",
    "LAX_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-9.csv',30,'LAX')\n",
    "\n",
    "LAX_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-10.csv',31,'LAX')\n",
    "\n",
    "LAX_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-11.csv',30,'LAX')\n",
    "\n",
    "LAX_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2016-12.csv',31,'LAX')\n",
    "\n",
    "\n",
    "\n",
    "LAX_2016_A = LAX_2016_1.append(LAX_2016_2,ignore_index = True).append(LAX_2016_3,ignore_index = True).append(LAX_2016_4,ignore_index = True)\n",
    "\n",
    "LAX_2016_B = LAX_2016_5.append(LAX_2016_6,ignore_index = True).append(LAX_2016_7,ignore_index = True).append(LAX_2016_8,ignore_index = True)\n",
    "\n",
    "LAX_2016_C = LAX_2016_9.append(LAX_2016_10,ignore_index = True).append(LAX_2016_11,ignore_index = True).append(LAX_2016_12,ignore_index = True)\n",
    "\n",
    "LAX_2016 = LAX_2016_A.append(LAX_2016_B,ignore_index = True).append(LAX_2016_C,ignore_index = True)\n",
    "\n",
    "LAX_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\LAX_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "LAX_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-1.csv',31,'LAX')\n",
    "\n",
    "LAX_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-2.csv',28,'LAX')\n",
    "\n",
    "LAX_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-3.csv',31,'LAX')\n",
    "\n",
    "LAX_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-4.csv',30,'LAX')\n",
    "\n",
    "LAX_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-5.csv',31,'LAX')\n",
    "\n",
    "LAX_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-6.csv',30,'LAX')\n",
    "\n",
    "LAX_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-7.csv',31,'LAX')\n",
    "\n",
    "LAX_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-8.csv',31,'LAX')\n",
    "\n",
    "LAX_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-9.csv',30,'LAX')\n",
    "\n",
    "LAX_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-10.csv',31,'LAX')\n",
    "\n",
    "LAX_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-11.csv',30,'LAX')\n",
    "\n",
    "LAX_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\2017-12.csv',31,'LAX')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "LAX_2017_A = LAX_2017_1.append(LAX_2017_2,ignore_index = True).append(LAX_2017_3,ignore_index = True).append(LAX_2017_4,ignore_index = True)\n",
    "\n",
    "LAX_2017_B = LAX_2017_5.append(LAX_2017_6,ignore_index = True).append(LAX_2017_7,ignore_index = True).append(LAX_2017_8,ignore_index = True)\n",
    "\n",
    "LAX_2017_C = LAX_2017_9.append(LAX_2017_10,ignore_index = True).append(LAX_2017_11,ignore_index = True).append(LAX_2017_12,ignore_index = True)\n",
    "\n",
    "LAX_2017 = LAX_2017_A.append(LAX_2017_B,ignore_index = True).append(LAX_2017_C,ignore_index = True)\n",
    "\n",
    "LAX_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\LAX_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "LAX = LAX_2016.append(LAX_2017,ignore_index = True)\n",
    "\n",
    "LAX.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\LAX\\LAX_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "MCO_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-1.csv',31,'MCO')\n",
    "\n",
    "MCO_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-2.csv',29,'MCO')\n",
    "\n",
    "MCO_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-3.csv',31,'MCO')\n",
    "\n",
    "MCO_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-4.csv',30,'MCO')\n",
    "\n",
    "MCO_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-5.csv',31,'MCO')\n",
    "\n",
    "MCO_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-6.csv',30,'MCO')\n",
    "\n",
    "MCO_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-7.csv',31,'MCO')\n",
    "\n",
    "MCO_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-8.csv',31,'MCO')\n",
    "\n",
    "MCO_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-9.csv',30,'MCO')\n",
    "\n",
    "MCO_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-10.csv',31,'MCO')\n",
    "\n",
    "MCO_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-11.csv',30,'MCO')\n",
    "\n",
    "MCO_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2016-12.csv',31,'MCO')\n",
    "\n",
    "\n",
    "\n",
    "MCO_2016_A = MCO_2016_1.append(MCO_2016_2,ignore_index = True).append(MCO_2016_3,ignore_index = True).append(MCO_2016_4,ignore_index = True)\n",
    "\n",
    "MCO_2016_B = MCO_2016_5.append(MCO_2016_6,ignore_index = True).append(MCO_2016_7,ignore_index = True).append(MCO_2016_8,ignore_index = True)\n",
    "\n",
    "MCO_2016_C = MCO_2016_9.append(MCO_2016_10,ignore_index = True).append(MCO_2016_11,ignore_index = True).append(MCO_2016_12,ignore_index = True)\n",
    "\n",
    "MCO_2016 = MCO_2016_A.append(MCO_2016_B,ignore_index = True).append(MCO_2016_C,ignore_index = True)\n",
    "\n",
    "MCO_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\MCO_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "MCO_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-1.csv',31,'MCO')\n",
    "\n",
    "MCO_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-2.csv',28,'MCO')\n",
    "\n",
    "MCO_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-3.csv',31,'MCO')\n",
    "\n",
    "MCO_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-4.csv',30,'MCO')\n",
    "\n",
    "MCO_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-5.csv',31,'MCO')\n",
    "\n",
    "MCO_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-6.csv',30,'MCO')\n",
    "\n",
    "MCO_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-7.csv',31,'MCO')\n",
    "\n",
    "MCO_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-8.csv',31,'MCO')\n",
    "\n",
    "MCO_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-9.csv',30,'MCO')\n",
    "\n",
    "MCO_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-10.csv',31,'MCO')\n",
    "\n",
    "MCO_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-11.csv',30,'MCO')\n",
    "\n",
    "MCO_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\2017-12.csv',31,'MCO')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "MCO_2017_A = MCO_2017_1.append(MCO_2017_2,ignore_index = True).append(MCO_2017_3,ignore_index = True).append(MCO_2017_4,ignore_index = True)\n",
    "\n",
    "MCO_2017_B = MCO_2017_5.append(MCO_2017_6,ignore_index = True).append(MCO_2017_7,ignore_index = True).append(MCO_2017_8,ignore_index = True)\n",
    "\n",
    "MCO_2017_C = MCO_2017_9.append(MCO_2017_10,ignore_index = True).append(MCO_2017_11,ignore_index = True).append(MCO_2017_12,ignore_index = True)\n",
    "\n",
    "MCO_2017 = MCO_2017_A.append(MCO_2017_B,ignore_index = True).append(MCO_2017_C,ignore_index = True)\n",
    "\n",
    "MCO_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\MCO_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "MCO = MCO_2016.append(MCO_2017,ignore_index = True)\n",
    "\n",
    "MCO.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MCO\\MCO_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "MIA_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-1.csv',31,'MIA')\n",
    "\n",
    "MIA_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-2.csv',29,'MIA')\n",
    "\n",
    "MIA_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-3.csv',31,'MIA')\n",
    "\n",
    "MIA_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-4.csv',30,'MIA')\n",
    "\n",
    "MIA_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-5.csv',31,'MIA')\n",
    "\n",
    "MIA_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-6.csv',30,'MIA')\n",
    "\n",
    "MIA_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-7.csv',31,'MIA')\n",
    "\n",
    "MIA_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-8.csv',31,'MIA')\n",
    "\n",
    "MIA_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-9.csv',30,'MIA')\n",
    "\n",
    "MIA_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-10.csv',31,'MIA')\n",
    "\n",
    "MIA_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-11.csv',30,'MIA')\n",
    "\n",
    "MIA_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2016-12.csv',31,'MIA')\n",
    "\n",
    "\n",
    "\n",
    "MIA_2016_A = MIA_2016_1.append(MIA_2016_2,ignore_index = True).append(MIA_2016_3,ignore_index = True).append(MIA_2016_4,ignore_index = True)\n",
    "\n",
    "MIA_2016_B = MIA_2016_5.append(MIA_2016_6,ignore_index = True).append(MIA_2016_7,ignore_index = True).append(MIA_2016_8,ignore_index = True)\n",
    "\n",
    "MIA_2016_C = MIA_2016_9.append(MIA_2016_10,ignore_index = True).append(MIA_2016_11,ignore_index = True).append(MIA_2016_12,ignore_index = True)\n",
    "\n",
    "MIA_2016 = MIA_2016_A.append(MIA_2016_B,ignore_index = True).append(MIA_2016_C,ignore_index = True)\n",
    "\n",
    "MIA_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\MIA_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "MIA_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-1.csv',31,'MIA')\n",
    "\n",
    "MIA_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-2.csv',28,'MIA')\n",
    "\n",
    "MIA_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-3.csv',31,'MIA')\n",
    "\n",
    "MIA_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-4.csv',30,'MIA')\n",
    "\n",
    "MIA_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-5.csv',31,'MIA')\n",
    "\n",
    "MIA_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-6.csv',30,'MIA')\n",
    "\n",
    "MIA_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-7.csv',31,'MIA')\n",
    "\n",
    "MIA_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-8.csv',31,'MIA')\n",
    "\n",
    "MIA_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-9.csv',30,'MIA')\n",
    "\n",
    "MIA_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-10.csv',31,'MIA')\n",
    "\n",
    "MIA_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-11.csv',30,'MIA')\n",
    "\n",
    "MIA_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\2017-12.csv',31,'MIA')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "MIA_2017_A = MIA_2017_1.append(MIA_2017_2,ignore_index = True).append(MIA_2017_3,ignore_index = True).append(MIA_2017_4,ignore_index = True)\n",
    "\n",
    "MIA_2017_B = MIA_2017_5.append(MIA_2017_6,ignore_index = True).append(MIA_2017_7,ignore_index = True).append(MIA_2017_8,ignore_index = True)\n",
    "\n",
    "MIA_2017_C = MIA_2017_9.append(MIA_2017_10,ignore_index = True).append(MIA_2017_11,ignore_index = True).append(MIA_2017_12,ignore_index = True)\n",
    "\n",
    "MIA_2017 = MIA_2017_A.append(MIA_2017_B,ignore_index = True).append(MIA_2017_C,ignore_index = True)\n",
    "\n",
    "MIA_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\MIA_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "MIA = MIA_2016.append(MIA_2017,ignore_index = True)\n",
    "\n",
    "MIA.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\MIA\\MIA_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "ORD_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-1.csv',31,'ORD')\n",
    "\n",
    "ORD_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-2.csv',29,'ORD')\n",
    "\n",
    "ORD_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-3.csv',31,'ORD')\n",
    "\n",
    "ORD_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-4.csv',30,'ORD')\n",
    "\n",
    "ORD_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-5.csv',31,'ORD')\n",
    "\n",
    "ORD_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-6.csv',30,'ORD')\n",
    "\n",
    "ORD_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-7.csv',31,'ORD')\n",
    "\n",
    "ORD_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-8.csv',31,'ORD')\n",
    "\n",
    "ORD_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-9.csv',30,'ORD')\n",
    "\n",
    "ORD_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-10.csv',31,'ORD')\n",
    "\n",
    "ORD_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-11.csv',30,'ORD')\n",
    "\n",
    "ORD_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2016-12.csv',31,'ORD')\n",
    "\n",
    "\n",
    "\n",
    "ORD_2016_A = ORD_2016_1.append(ORD_2016_2,ignore_index = True).append(ORD_2016_3,ignore_index = True).append(ORD_2016_4,ignore_index = True)\n",
    "\n",
    "ORD_2016_B = ORD_2016_5.append(ORD_2016_6,ignore_index = True).append(ORD_2016_7,ignore_index = True).append(ORD_2016_8,ignore_index = True)\n",
    "\n",
    "ORD_2016_C = ORD_2016_9.append(ORD_2016_10,ignore_index = True).append(ORD_2016_11,ignore_index = True).append(ORD_2016_12,ignore_index = True)\n",
    "\n",
    "ORD_2016 = ORD_2016_A.append(ORD_2016_B,ignore_index = True).append(ORD_2016_C,ignore_index = True)\n",
    "\n",
    "ORD_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\ORD_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "ORD_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-1.csv',31,'ORD')\n",
    "\n",
    "ORD_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-2.csv',28,'ORD')\n",
    "\n",
    "ORD_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-3.csv',31,'ORD')\n",
    "\n",
    "ORD_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-4.csv',30,'ORD')\n",
    "\n",
    "ORD_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-5.csv',31,'ORD')\n",
    "\n",
    "ORD_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-6.csv',30,'ORD')\n",
    "\n",
    "ORD_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-7.csv',31,'ORD')\n",
    "\n",
    "ORD_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-8.csv',31,'ORD')\n",
    "\n",
    "ORD_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-9.csv',30,'ORD')\n",
    "\n",
    "ORD_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-10.csv',31,'ORD')\n",
    "\n",
    "ORD_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-11.csv',30,'ORD')\n",
    "\n",
    "ORD_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\2017-12.csv',31,'ORD')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "ORD_2017_A = ORD_2017_1.append(ORD_2017_2,ignore_index = True).append(ORD_2017_3,ignore_index = True).append(ORD_2017_4,ignore_index = True)\n",
    "\n",
    "ORD_2017_B = ORD_2017_5.append(ORD_2017_6,ignore_index = True).append(ORD_2017_7,ignore_index = True).append(ORD_2017_8,ignore_index = True)\n",
    "\n",
    "ORD_2017_C = ORD_2017_9.append(ORD_2017_10,ignore_index = True).append(ORD_2017_11,ignore_index = True).append(ORD_2017_12,ignore_index = True)\n",
    "\n",
    "ORD_2017 = ORD_2017_A.append(ORD_2017_B,ignore_index = True).append(ORD_2017_C,ignore_index = True)\n",
    "\n",
    "ORD_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\ORD_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "ORD = ORD_2016.append(ORD_2017,ignore_index = True)\n",
    "\n",
    "ORD.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\ORD\\ORD_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "PHX_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-1.csv',31,'PHX')\n",
    "\n",
    "PHX_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-2.csv',29,'PHX')\n",
    "\n",
    "PHX_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-3.csv',31,'PHX')\n",
    "\n",
    "PHX_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-4.csv',30,'PHX')\n",
    "\n",
    "PHX_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-5.csv',31,'PHX')\n",
    "\n",
    "PHX_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-6.csv',30,'PHX')\n",
    "\n",
    "PHX_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-7.csv',31,'PHX')\n",
    "\n",
    "PHX_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-8.csv',31,'PHX')\n",
    "\n",
    "PHX_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-9.csv',30,'PHX')\n",
    "\n",
    "PHX_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-10.csv',31,'PHX')\n",
    "\n",
    "PHX_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-11.csv',30,'PHX')\n",
    "\n",
    "PHX_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2016-12.csv',31,'PHX')\n",
    "\n",
    "\n",
    "\n",
    "PHX_2016_A = PHX_2016_1.append(PHX_2016_2,ignore_index = True).append(PHX_2016_3,ignore_index = True).append(PHX_2016_4,ignore_index = True)\n",
    "\n",
    "PHX_2016_B = PHX_2016_5.append(PHX_2016_6,ignore_index = True).append(PHX_2016_7,ignore_index = True).append(PHX_2016_8,ignore_index = True)\n",
    "\n",
    "PHX_2016_C = PHX_2016_9.append(PHX_2016_10,ignore_index = True).append(PHX_2016_11,ignore_index = True).append(PHX_2016_12,ignore_index = True)\n",
    "\n",
    "PHX_2016 = PHX_2016_A.append(PHX_2016_B,ignore_index = True).append(PHX_2016_C,ignore_index = True)\n",
    "\n",
    "PHX_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\PHX_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "PHX_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-1.csv',31,'PHX')\n",
    "\n",
    "PHX_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-2.csv',28,'PHX')\n",
    "\n",
    "PHX_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-3.csv',31,'PHX')\n",
    "\n",
    "PHX_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-4.csv',30,'PHX')\n",
    "\n",
    "PHX_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-5.csv',31,'PHX')\n",
    "\n",
    "PHX_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-6.csv',30,'PHX')\n",
    "\n",
    "PHX_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-7.csv',31,'PHX')\n",
    "\n",
    "PHX_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-8.csv',31,'PHX')\n",
    "\n",
    "PHX_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-9.csv',30,'PHX')\n",
    "\n",
    "PHX_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-10.csv',31,'PHX')\n",
    "\n",
    "PHX_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-11.csv',30,'PHX')\n",
    "\n",
    "PHX_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\2017-12.csv',31,'PHX')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "PHX_2017_A = PHX_2017_1.append(PHX_2017_2,ignore_index = True).append(PHX_2017_3,ignore_index = True).append(PHX_2017_4,ignore_index = True)\n",
    "\n",
    "PHX_2017_B = PHX_2017_5.append(PHX_2017_6,ignore_index = True).append(PHX_2017_7,ignore_index = True).append(PHX_2017_8,ignore_index = True)\n",
    "\n",
    "PHX_2017_C = PHX_2017_9.append(PHX_2017_10,ignore_index = True).append(PHX_2017_11,ignore_index = True).append(PHX_2017_12,ignore_index = True)\n",
    "\n",
    "PHX_2017 = PHX_2017_A.append(PHX_2017_B,ignore_index = True).append(PHX_2017_C,ignore_index = True)\n",
    "\n",
    "PHX_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\PHX_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "PHX = PHX_2016.append(PHX_2017,ignore_index = True)\n",
    "\n",
    "PHX.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\PHX\\PHX_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "SEA_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-1.csv',31,'SEA')\n",
    "\n",
    "SEA_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-2.csv',29,'SEA')\n",
    "\n",
    "SEA_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-3.csv',31,'SEA')\n",
    "\n",
    "SEA_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-4.csv',30,'SEA')\n",
    "\n",
    "SEA_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-5.csv',31,'SEA')\n",
    "\n",
    "SEA_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-6.csv',30,'SEA')\n",
    "\n",
    "SEA_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-7.csv',31,'SEA')\n",
    "\n",
    "SEA_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-8.csv',31,'SEA')\n",
    "\n",
    "SEA_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-9.csv',30,'SEA')\n",
    "\n",
    "SEA_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-10.csv',31,'SEA')\n",
    "\n",
    "SEA_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-11.csv',30,'SEA')\n",
    "\n",
    "SEA_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2016-12.csv',31,'SEA')\n",
    "\n",
    "\n",
    "\n",
    "SEA_2016_A = SEA_2016_1.append(SEA_2016_2,ignore_index = True).append(SEA_2016_3,ignore_index = True).append(SEA_2016_4,ignore_index = True)\n",
    "\n",
    "SEA_2016_B = SEA_2016_5.append(SEA_2016_6,ignore_index = True).append(SEA_2016_7,ignore_index = True).append(SEA_2016_8,ignore_index = True)\n",
    "\n",
    "SEA_2016_C = SEA_2016_9.append(SEA_2016_10,ignore_index = True).append(SEA_2016_11,ignore_index = True).append(SEA_2016_12,ignore_index = True)\n",
    "\n",
    "SEA_2016 = SEA_2016_A.append(SEA_2016_B,ignore_index = True).append(SEA_2016_C,ignore_index = True)\n",
    "\n",
    "SEA_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\SEA_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "SEA_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-1.csv',31,'SEA')\n",
    "\n",
    "SEA_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-2.csv',28,'SEA')\n",
    "\n",
    "SEA_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-3.csv',31,'SEA')\n",
    "\n",
    "SEA_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-4.csv',30,'SEA')\n",
    "\n",
    "SEA_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-5.csv',31,'SEA')\n",
    "\n",
    "SEA_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-6.csv',30,'SEA')\n",
    "\n",
    "SEA_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-7.csv',31,'SEA')\n",
    "\n",
    "SEA_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-8.csv',31,'SEA')\n",
    "\n",
    "SEA_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-9.csv',30,'SEA')\n",
    "\n",
    "SEA_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-10.csv',31,'SEA')\n",
    "\n",
    "SEA_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-11.csv',30,'SEA')\n",
    "\n",
    "SEA_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\2017-12.csv',31,'SEA')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "SEA_2017_A = SEA_2017_1.append(SEA_2017_2,ignore_index = True).append(SEA_2017_3,ignore_index = True).append(SEA_2017_4,ignore_index = True)\n",
    "\n",
    "SEA_2017_B = SEA_2017_5.append(SEA_2017_6,ignore_index = True).append(SEA_2017_7,ignore_index = True).append(SEA_2017_8,ignore_index = True)\n",
    "\n",
    "SEA_2017_C = SEA_2017_9.append(SEA_2017_10,ignore_index = True).append(SEA_2017_11,ignore_index = True).append(SEA_2017_12,ignore_index = True)\n",
    "\n",
    "SEA_2017 = SEA_2017_A.append(SEA_2017_B,ignore_index = True).append(SEA_2017_C,ignore_index = True)\n",
    "\n",
    "SEA_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\SEA_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "SEA = SEA_2016.append(SEA_2017,ignore_index = True)\n",
    "\n",
    "SEA.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SEA\\SEA_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "SFO_2016_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-1.csv',31,'SFO')\n",
    "\n",
    "SFO_2016_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-2.csv',29,'SFO')\n",
    "\n",
    "SFO_2016_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-3.csv',31,'SFO')\n",
    "\n",
    "SFO_2016_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-4.csv',30,'SFO')\n",
    "\n",
    "SFO_2016_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-5.csv',31,'SFO')\n",
    "\n",
    "SFO_2016_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-6.csv',30,'SFO')\n",
    "\n",
    "SFO_2016_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-7.csv',31,'SFO')\n",
    "\n",
    "SFO_2016_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-8.csv',31,'SFO')\n",
    "\n",
    "SFO_2016_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-9.csv',30,'SFO')\n",
    "\n",
    "SFO_2016_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-10.csv',31,'SFO')\n",
    "\n",
    "SFO_2016_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-11.csv',30,'SFO')\n",
    "\n",
    "SFO_2016_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2016-12.csv',31,'SFO')\n",
    "\n",
    "\n",
    "\n",
    "SFO_2016_A = SFO_2016_1.append(SFO_2016_2,ignore_index = True).append(SFO_2016_3,ignore_index = True).append(SFO_2016_4,ignore_index = True)\n",
    "\n",
    "SFO_2016_B = SFO_2016_5.append(SFO_2016_6,ignore_index = True).append(SFO_2016_7,ignore_index = True).append(SFO_2016_8,ignore_index = True)\n",
    "\n",
    "SFO_2016_C = SFO_2016_9.append(SFO_2016_10,ignore_index = True).append(SFO_2016_11,ignore_index = True).append(SFO_2016_12,ignore_index = True)\n",
    "\n",
    "SFO_2016 = SFO_2016_A.append(SFO_2016_B,ignore_index = True).append(SFO_2016_C,ignore_index = True)\n",
    "\n",
    "SFO_2016.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\SFO_2016.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "SFO_2017_1 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-1.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-1.csv',31,'SFO')\n",
    "\n",
    "SFO_2017_2 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-2.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-2.csv',28,'SFO')\n",
    "\n",
    "SFO_2017_3 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-3.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-3.csv',31,'SFO')\n",
    "\n",
    "SFO_2017_4 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-4.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-4.csv',30,'SFO')\n",
    "\n",
    "SFO_2017_5 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-5.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-5.csv',31,'SFO')\n",
    "\n",
    "SFO_2017_6 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-6.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-6.csv',30,'SFO')\n",
    "\n",
    "SFO_2017_7 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-7.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-7.csv',31,'SFO')\n",
    "\n",
    "SFO_2017_8 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-8.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-8.csv',31,'SFO')\n",
    "\n",
    "SFO_2017_9 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-9.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-9.csv',30,'SFO')\n",
    "\n",
    "SFO_2017_10 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-10.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-10.csv',31,'SFO')\n",
    "\n",
    "SFO_2017_11 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-11.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-11.csv',30,'SFO')\n",
    "\n",
    "SFO_2017_12 = json_to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-12.json',r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\2017-12.csv',31,'SFO')\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "SFO_2017_A = SFO_2017_1.append(SFO_2017_2,ignore_index = True).append(SFO_2017_3,ignore_index = True).append(SFO_2017_4,ignore_index = True)\n",
    "\n",
    "SFO_2017_B = SFO_2017_5.append(SFO_2017_6,ignore_index = True).append(SFO_2017_7,ignore_index = True).append(SFO_2017_8,ignore_index = True)\n",
    "\n",
    "SFO_2017_C = SFO_2017_9.append(SFO_2017_10,ignore_index = True).append(SFO_2017_11,ignore_index = True).append(SFO_2017_12,ignore_index = True)\n",
    "\n",
    "SFO_2017 = SFO_2017_A.append(SFO_2017_B,ignore_index = True).append(SFO_2017_C,ignore_index = True)\n",
    "\n",
    "SFO_2017.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\SFO_2017.csv',index = False)\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "SFO = SFO_2016.append(SFO_2017,ignore_index = True)\n",
    "\n",
    "SFO.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\SFO\\SFO_2016_2017.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "Airport_1 = ATL.append(CLT,ignore_index = True).append(DEN,ignore_index = True).append(DFW,ignore_index = True).append(EWR,ignore_index = True)\n",
    "\n",
    "Airport_2 = IAH.append(JFK,ignore_index = True).append(LAS,ignore_index = True).append(LAX,ignore_index = True).append(MCO,ignore_index = True)\n",
    "\n",
    "Airport_3 = MIA.append(ORD,ignore_index = True).append(PHX,ignore_index = True).append(SEA,ignore_index = True).append(SFO,ignore_index = True)\n",
    "\n",
    "weather_data = Airport_1.append(Airport_2,ignore_index = True).append(Airport_3,ignore_index = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "weather_data.to_csv(r'C:\\Users\\badri\\Desktop\\ML-Project\\weather\\Weather_Data.csv',index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}