Working with Pandas .ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Age</th>\n",
       "      <th>Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Vaishnavi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Age       Name\n",
       "0   NaN  Vaishnavi\n",
       "1  19.0        NaN"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas\n",
    "df1=pandas.DataFrame([{\"Name\":\"Saharsh\",\"Name\":\"Vaishnavi\"},{\"Age\":12,\"Age\":19}])\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "ename": "HTTPError",
     "evalue": "HTTP Error 401: Unauthorized",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mHTTPError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-7-350f7eca8aa1>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[1;32mimport\u001b[0m \u001b[0murllib\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mrequest\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mjson\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0mresponse\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0murllib\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mrequest\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0murlopen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"http://api.openweathermap.org/data/2.5/weather?lat=29.88930833333333&lon=77.95958833333334&appid=b6907d289e10d714a6e88b30761fae22\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      3\u001b[0m \u001b[0mjson\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mloads\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mresponse\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      4\u001b[0m \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mjson\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\users\\shurru\\appdata\\local\\programs\\python\\python36-32\\lib\\urllib\\request.py\u001b[0m in \u001b[0;36murlopen\u001b[1;34m(url, data, timeout, cafile, capath, cadefault, context)\u001b[0m\n\u001b[0;32m    221\u001b[0m     \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    222\u001b[0m         \u001b[0mopener\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0m_opener\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 223\u001b[1;33m     \u001b[1;32mreturn\u001b[0m \u001b[0mopener\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mopen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0murl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mdata\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    224\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    225\u001b[0m \u001b[1;32mdef\u001b[0m \u001b[0minstall_opener\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mopener\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\users\\shurru\\appdata\\local\\programs\\python\\python36-32\\lib\\urllib\\request.py\u001b[0m in \u001b[0;36mopen\u001b[1;34m(self, fullurl, data, timeout)\u001b[0m\n\u001b[0;32m    530\u001b[0m         \u001b[1;32mfor\u001b[0m \u001b[0mprocessor\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mprocess_response\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mprotocol\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m[\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    531\u001b[0m             \u001b[0mmeth\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mgetattr\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mprocessor\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmeth_name\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 532\u001b[1;33m             \u001b[0mresponse\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mmeth\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mreq\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mresponse\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    533\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    534\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mresponse\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\users\\shurru\\appdata\\local\\programs\\python\\python36-32\\lib\\urllib\\request.py\u001b[0m in \u001b[0;36mhttp_response\u001b[1;34m(self, request, response)\u001b[0m\n\u001b[0;32m    640\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;33m(\u001b[0m\u001b[1;36m200\u001b[0m \u001b[1;33m<=\u001b[0m \u001b[0mcode\u001b[0m \u001b[1;33m<\u001b[0m \u001b[1;36m300\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    641\u001b[0m             response = self.parent.error(\n\u001b[1;32m--> 642\u001b[1;33m                 'http', request, response, code, msg, hdrs)\n\u001b[0m\u001b[0;32m    643\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    644\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mresponse\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\users\\shurru\\appdata\\local\\programs\\python\\python36-32\\lib\\urllib\\request.py\u001b[0m in \u001b[0;36merror\u001b[1;34m(self, proto, *args)\u001b[0m\n\u001b[0;32m    568\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mhttp_err\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    569\u001b[0m             \u001b[0margs\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mdict\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'default'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'http_error_default'\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;33m+\u001b[0m \u001b[0morig_args\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 570\u001b[1;33m             \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_call_chain\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    571\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    572\u001b[0m \u001b[1;31m# XXX probably also want an abstract factory that knows when it makes\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\users\\shurru\\appdata\\local\\programs\\python\\python36-32\\lib\\urllib\\request.py\u001b[0m in \u001b[0;36m_call_chain\u001b[1;34m(self, chain, kind, meth_name, *args)\u001b[0m\n\u001b[0;32m    502\u001b[0m         \u001b[1;32mfor\u001b[0m \u001b[0mhandler\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mhandlers\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    503\u001b[0m             \u001b[0mfunc\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mgetattr\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mhandler\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmeth_name\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 504\u001b[1;33m             \u001b[0mresult\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mfunc\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    505\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mresult\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    506\u001b[0m                 \u001b[1;32mreturn\u001b[0m \u001b[0mresult\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mc:\\users\\shurru\\appdata\\local\\programs\\python\\python36-32\\lib\\urllib\\request.py\u001b[0m in \u001b[0;36mhttp_error_default\u001b[1;34m(self, req, fp, code, msg, hdrs)\u001b[0m\n\u001b[0;32m    648\u001b[0m \u001b[1;32mclass\u001b[0m \u001b[0mHTTPDefaultErrorHandler\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mBaseHandler\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    649\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mhttp_error_default\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mreq\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mfp\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcode\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmsg\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mhdrs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 650\u001b[1;33m         \u001b[1;32mraise\u001b[0m \u001b[0mHTTPError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mreq\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfull_url\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcode\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmsg\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mhdrs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mfp\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    651\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    652\u001b[0m \u001b[1;32mclass\u001b[0m \u001b[0mHTTPRedirectHandler\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mBaseHandler\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mHTTPError\u001b[0m: HTTP Error 401: Unauthorized"
     ]
    }
   ],
   "source": [
    "import urllib.request,json\n",
    "response=urllib.request.urlopen(\"http://api.openweathermap.org/data/2.5/weather?lat=29.88930833333333&lon=77.95958833333334&appid=b6907d289e10d714a6e88b30761fae22\")\n",
    "json.loads(response.read())\n",
    "print(json)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'cod': '200', 'message': 0.0086, 'cnt': 40, 'list': [{'dt': 1524085200, 'main': {'temp': 16.58, 'temp_min': 16.58, 'temp_max': 20.18, 'pressure': 971.17, 'sea_level': 1019.1, 'grnd_level': 971.17, 'humidity': 44, 'temp_kf': -3.6}, 'weather': [{'id': 802, 'main': 'Clouds', 'description': 'scattered clouds', 'icon': '03n'}], 'clouds': {'all': 44}, 'wind': {'speed': 2.57, 'deg': 326.501}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-18 21:00:00'}, {'dt': 1524096000, 'main': {'temp': 16.29, 'temp_min': 16.29, 'temp_max': 18.99, 'pressure': 970.63, 'sea_level': 1018.78, 'grnd_level': 970.63, 'humidity': 50, 'temp_kf': -2.7}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.75, 'deg': 342.502}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-19 00:00:00'}, {'dt': 1524106800, 'main': {'temp': 23.97, 'temp_min': 23.97, 'temp_max': 25.77, 'pressure': 972.1, 'sea_level': 1019.88, 'grnd_level': 972.1, 'humidity': 43, 'temp_kf': -1.8}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.86, 'deg': 36.0031}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-19 03:00:00'}, {'dt': 1524117600, 'main': {'temp': 31.38, 'temp_min': 31.38, 'temp_max': 32.28, 'pressure': 971.59, 'sea_level': 1018.85, 'grnd_level': 971.59, 'humidity': 39, 'temp_kf': -0.9}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.87, 'deg': 250.501}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-19 06:00:00'}, {'dt': 1524128400, 'main': {'temp': 34.25, 'temp_min': 34.25, 'temp_max': 34.25, 'pressure': 969.55, 'sea_level': 1016.73, 'grnd_level': 969.55, 'humidity': 31, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '02d'}], 'clouds': {'all': 8}, 'wind': {'speed': 4.77, 'deg': 274.007}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-19 09:00:00'}, {'dt': 1524139200, 'main': {'temp': 31.97, 'temp_min': 31.97, 'temp_max': 31.97, 'pressure': 968.75, 'sea_level': 1016.36, 'grnd_level': 968.75, 'humidity': 26, 'temp_kf': 0}, 'weather': [{'id': 803, 'main': 'Clouds', 'description': 'broken clouds', 'icon': '04d'}], 'clouds': {'all': 64}, 'wind': {'speed': 4.21, 'deg': 298.501}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-19 12:00:00'}, {'dt': 1524150000, 'main': {'temp': 24.34, 'temp_min': 24.34, 'temp_max': 24.34, 'pressure': 971.04, 'sea_level': 1018.96, 'grnd_level': 971.04, 'humidity': 40, 'temp_kf': 0}, 'weather': [{'id': 802, 'main': 'Clouds', 'description': 'scattered clouds', 'icon': '03n'}], 'clouds': {'all': 36}, 'wind': {'speed': 2.11, 'deg': 354}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-19 15:00:00'}, {'dt': 1524160800, 'main': {'temp': 19.57, 'temp_min': 19.57, 'temp_max': 19.57, 'pressure': 971.85, 'sea_level': 1019.94, 'grnd_level': 971.85, 'humidity': 63, 'temp_kf': 0}, 'weather': [{'id': 801, 'main': 'Clouds', 'description': 'few clouds', 'icon': '02n'}], 'clouds': {'all': 24}, 'wind': {'speed': 1.81, 'deg': 28.5022}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-19 18:00:00'}, {'dt': 1524171600, 'main': {'temp': 17.68, 'temp_min': 17.68, 'temp_max': 17.68, 'pressure': 970.74, 'sea_level': 1019.1, 'grnd_level': 970.74, 'humidity': 81, 'temp_kf': 0}, 'weather': [{'id': 500, 'main': 'Rain', 'description': 'light rain', 'icon': '10n'}], 'clouds': {'all': 48}, 'wind': {'speed': 2.31, 'deg': 41.0005}, 'rain': {'3h': 0.164825}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-19 21:00:00'}, {'dt': 1524182400, 'main': {'temp': 17.96, 'temp_min': 17.96, 'temp_max': 17.96, 'pressure': 971.94, 'sea_level': 1020.4, 'grnd_level': 971.94, 'humidity': 84, 'temp_kf': 0}, 'weather': [{'id': 500, 'main': 'Rain', 'description': 'light rain', 'icon': '10n'}], 'clouds': {'all': 100}, 'wind': {'speed': 1.72, 'deg': 48.5008}, 'rain': {'3h': 0.2366}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-20 00:00:00'}, {'dt': 1524193200, 'main': {'temp': 22.03, 'temp_min': 22.03, 'temp_max': 22.03, 'pressure': 972.31, 'sea_level': 1020.43, 'grnd_level': 972.31, 'humidity': 64, 'temp_kf': 0}, 'weather': [{'id': 802, 'main': 'Clouds', 'description': 'scattered clouds', 'icon': '03d'}], 'clouds': {'all': 32}, 'wind': {'speed': 5.72, 'deg': 52.5002}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-20 03:00:00'}, {'dt': 1524204000, 'main': {'temp': 27, 'temp_min': 27, 'temp_max': 27, 'pressure': 972.19, 'sea_level': 1020.14, 'grnd_level': 972.19, 'humidity': 47, 'temp_kf': 0}, 'weather': [{'id': 803, 'main': 'Clouds', 'description': 'broken clouds', 'icon': '04d'}], 'clouds': {'all': 56}, 'wind': {'speed': 6.01, 'deg': 61.5008}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-20 06:00:00'}, {'dt': 1524214800, 'main': {'temp': 28.2, 'temp_min': 28.2, 'temp_max': 28.2, 'pressure': 971.05, 'sea_level': 1018.86, 'grnd_level': 971.05, 'humidity': 46, 'temp_kf': 0}, 'weather': [{'id': 500, 'main': 'Rain', 'description': 'light rain', 'icon': '10d'}], 'clouds': {'all': 64}, 'wind': {'speed': 6.06, 'deg': 70.5005}, 'rain': {'3h': 0.007725}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-20 09:00:00'}, {'dt': 1524225600, 'main': {'temp': 23.81, 'temp_min': 23.81, 'temp_max': 23.81, 'pressure': 970.38, 'sea_level': 1018.42, 'grnd_level': 970.38, 'humidity': 52, 'temp_kf': 0}, 'weather': [{'id': 500, 'main': 'Rain', 'description': 'light rain', 'icon': '10d'}], 'clouds': {'all': 92}, 'wind': {'speed': 4.71, 'deg': 66.5019}, 'rain': {'3h': 0.110025}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-20 12:00:00'}, {'dt': 1524236400, 'main': {'temp': 19.42, 'temp_min': 19.42, 'temp_max': 19.42, 'pressure': 971.81, 'sea_level': 1020.33, 'grnd_level': 971.81, 'humidity': 76, 'temp_kf': 0}, 'weather': [{'id': 500, 'main': 'Rain', 'description': 'light rain', 'icon': '10n'}], 'clouds': {'all': 56}, 'wind': {'speed': 3.07, 'deg': 54.5009}, 'rain': {'3h': 0.34915}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-20 15:00:00'}, {'dt': 1524247200, 'main': {'temp': 16.67, 'temp_min': 16.67, 'temp_max': 16.67, 'pressure': 972.92, 'sea_level': 1021.73, 'grnd_level': 972.92, 'humidity': 86, 'temp_kf': 0}, 'weather': [{'id': 500, 'main': 'Rain', 'description': 'light rain', 'icon': '10n'}], 'clouds': {'all': 0}, 'wind': {'speed': 2.56, 'deg': 48.5087}, 'rain': {'3h': 0.048925}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-20 18:00:00'}, {'dt': 1524258000, 'main': {'temp': 15.04, 'temp_min': 15.04, 'temp_max': 15.04, 'pressure': 973.47, 'sea_level': 1022.41, 'grnd_level': 973.47, 'humidity': 88, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.69, 'deg': 13.5038}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-20 21:00:00'}, {'dt': 1524268800, 'main': {'temp': 13.62, 'temp_min': 13.62, 'temp_max': 13.62, 'pressure': 973.8, 'sea_level': 1022.75, 'grnd_level': 973.8, 'humidity': 88, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.43, 'deg': 24.5017}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-21 00:00:00'}, {'dt': 1524279600, 'main': {'temp': 22.08, 'temp_min': 22.08, 'temp_max': 22.08, 'pressure': 974.98, 'sea_level': 1023.31, 'grnd_level': 974.98, 'humidity': 60, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.86, 'deg': 20.0023}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-21 03:00:00'}, {'dt': 1524290400, 'main': {'temp': 28.67, 'temp_min': 28.67, 'temp_max': 28.67, 'pressure': 975.12, 'sea_level': 1022.94, 'grnd_level': 975.12, 'humidity': 53, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.87, 'deg': 260.508}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-21 06:00:00'}, {'dt': 1524301200, 'main': {'temp': 31.25, 'temp_min': 31.25, 'temp_max': 31.25, 'pressure': 973.34, 'sea_level': 1020.91, 'grnd_level': 973.34, 'humidity': 41, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 2.11, 'deg': 249.502}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-21 09:00:00'}, {'dt': 1524312000, 'main': {'temp': 30.15, 'temp_min': 30.15, 'temp_max': 30.15, 'pressure': 972.05, 'sea_level': 1019.76, 'grnd_level': 972.05, 'humidity': 32, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.62, 'deg': 253.001}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-21 12:00:00'}, {'dt': 1524322800, 'main': {'temp': 21.68, 'temp_min': 21.68, 'temp_max': 21.68, 'pressure': 973.12, 'sea_level': 1021.25, 'grnd_level': 973.12, 'humidity': 49, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.67, 'deg': 301.501}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-21 15:00:00'}, {'dt': 1524333600, 'main': {'temp': 17.17, 'temp_min': 17.17, 'temp_max': 17.17, 'pressure': 974.16, 'sea_level': 1022.53, 'grnd_level': 974.16, 'humidity': 64, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.42, 'deg': 352.51}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-21 18:00:00'}, {'dt': 1524344400, 'main': {'temp': 14.74, 'temp_min': 14.74, 'temp_max': 14.74, 'pressure': 973.83, 'sea_level': 1022.42, 'grnd_level': 973.83, 'humidity': 68, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.17, 'deg': 1.00092}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-21 21:00:00'}, {'dt': 1524355200, 'main': {'temp': 12.95, 'temp_min': 12.95, 'temp_max': 12.95, 'pressure': 974.18, 'sea_level': 1022.94, 'grnd_level': 974.18, 'humidity': 70, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.31, 'deg': 0.500854}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-22 00:00:00'}, {'dt': 1524366000, 'main': {'temp': 22.93, 'temp_min': 22.93, 'temp_max': 22.93, 'pressure': 975.27, 'sea_level': 1023.64, 'grnd_level': 975.27, 'humidity': 45, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.75, 'deg': 352.001}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-22 03:00:00'}, {'dt': 1524376800, 'main': {'temp': 28.85, 'temp_min': 28.85, 'temp_max': 28.85, 'pressure': 975.79, 'sea_level': 1023.48, 'grnd_level': 975.79, 'humidity': 43, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 2.67, 'deg': 266.5}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-22 06:00:00'}, {'dt': 1524387600, 'main': {'temp': 31.53, 'temp_min': 31.53, 'temp_max': 31.53, 'pressure': 973.75, 'sea_level': 1021.26, 'grnd_level': 973.75, 'humidity': 34, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 3.9, 'deg': 260.5}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-22 09:00:00'}, {'dt': 1524398400, 'main': {'temp': 30.85, 'temp_min': 30.85, 'temp_max': 30.85, 'pressure': 972.72, 'sea_level': 1020.43, 'grnd_level': 972.72, 'humidity': 27, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.91, 'deg': 260.002}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-22 12:00:00'}, {'dt': 1524409200, 'main': {'temp': 21.82, 'temp_min': 21.82, 'temp_max': 21.82, 'pressure': 973.8, 'sea_level': 1021.9, 'grnd_level': 973.8, 'humidity': 43, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.81, 'deg': 277.002}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-22 15:00:00'}, {'dt': 1524420000, 'main': {'temp': 17.52, 'temp_min': 17.52, 'temp_max': 17.52, 'pressure': 974.19, 'sea_level': 1022.93, 'grnd_level': 974.19, 'humidity': 56, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 0.96, 'deg': 9.50235}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-22 18:00:00'}, {'dt': 1524430800, 'main': {'temp': 14.73, 'temp_min': 14.73, 'temp_max': 14.73, 'pressure': 973.69, 'sea_level': 1022.52, 'grnd_level': 973.69, 'humidity': 63, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.31, 'deg': 20.502}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-22 21:00:00'}, {'dt': 1524441600, 'main': {'temp': 12.97, 'temp_min': 12.97, 'temp_max': 12.97, 'pressure': 973.85, 'sea_level': 1022.89, 'grnd_level': 973.85, 'humidity': 57, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.51, 'deg': 20.5029}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-23 00:00:00'}, {'dt': 1524452400, 'main': {'temp': 22.69, 'temp_min': 22.69, 'temp_max': 22.69, 'pressure': 975.1, 'sea_level': 1023.42, 'grnd_level': 975.1, 'humidity': 39, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.96, 'deg': 37.0015}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-23 03:00:00'}, {'dt': 1524463200, 'main': {'temp': 30.65, 'temp_min': 30.65, 'temp_max': 30.65, 'pressure': 975.06, 'sea_level': 1022.78, 'grnd_level': 975.06, 'humidity': 36, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.81, 'deg': 256.002}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-23 06:00:00'}, {'dt': 1524474000, 'main': {'temp': 32.91, 'temp_min': 32.91, 'temp_max': 32.91, 'pressure': 973.25, 'sea_level': 1020.56, 'grnd_level': 973.25, 'humidity': 30, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01d'}], 'clouds': {'all': 0}, 'wind': {'speed': 3.26, 'deg': 272}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-23 09:00:00'}, {'dt': 1524484800, 'main': {'temp': 32.23, 'temp_min': 32.23, 'temp_max': 32.23, 'pressure': 971.98, 'sea_level': 1019.44, 'grnd_level': 971.98, 'humidity': 26, 'temp_kf': 0}, 'weather': [{'id': 801, 'main': 'Clouds', 'description': 'few clouds', 'icon': '02d'}], 'clouds': {'all': 12}, 'wind': {'speed': 2.66, 'deg': 289.503}, 'rain': {}, 'sys': {'pod': 'd'}, 'dt_txt': '2018-04-23 12:00:00'}, {'dt': 1524495600, 'main': {'temp': 23.51, 'temp_min': 23.51, 'temp_max': 23.51, 'pressure': 972.56, 'sea_level': 1020.63, 'grnd_level': 972.56, 'humidity': 35, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 2.52, 'deg': 277.5}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-23 15:00:00'}, {'dt': 1524506400, 'main': {'temp': 18.62, 'temp_min': 18.62, 'temp_max': 18.62, 'pressure': 973.2, 'sea_level': 1021.7, 'grnd_level': 973.2, 'humidity': 50, 'temp_kf': 0}, 'weather': [{'id': 800, 'main': 'Clear', 'description': 'clear sky', 'icon': '01n'}], 'clouds': {'all': 0}, 'wind': {'speed': 1.41, 'deg': 333}, 'rain': {}, 'sys': {'pod': 'n'}, 'dt_txt': '2018-04-23 18:00:00'}], 'city': {'id': 1258044, 'name': 'Roorkee', 'coord': {'lat': 29.8667, 'lon': 77.8833}, 'country': 'IN', 'population': 103894}}\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "r = requests.get('http://api.openweathermap.org/data/2.5/forecast?lat=29.88930833333333&lon=77.95958833333334&appid=2e4cece87a1d0ae4bec92a7be776258a&units=metric')\n",
    "print (r.json())\n",
    " "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[[187, 187, 187],\n",
       "        [158, 158, 158],\n",
       "        [104, 104, 104],\n",
       "        [121, 121, 121],\n",
       "        [143, 143, 143]],\n",
       "\n",
       "       [[198, 198, 198],\n",
       "        [125, 125, 125],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [147, 147, 147]],\n",
       "\n",
       "       [[209, 209, 209],\n",
       "        [134, 134, 134],\n",
       "        [255, 255, 255],\n",
       "        [ 97,  97,  97],\n",
       "        [182, 182, 182]]], dtype=uint8)"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import cv2\n",
    "cv2.imread(\"smallgray.png\",1)\n",
    "#print(cv2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Help on built-in function array in module numpy.core.multiarray:\n",
      "\n",
      "array(...)\n",
      "    array(object, dtype=None, copy=True, order='K', subok=False, ndmin=0)\n",
      "    \n",
      "    Create an array.\n",
      "    \n",
      "    Parameters\n",
      "    ----------\n",
      "    object : array_like\n",
      "        An array, any object exposing the array interface, an object whose\n",
      "        __array__ method returns an array, or any (nested) sequence.\n",
      "    dtype : data-type, optional\n",
      "        The desired data-type for the array.  If not given, then the type will\n",
      "        be determined as the minimum type required to hold the objects in the\n",
      "        sequence.  This argument can only be used to 'upcast' the array.  For\n",
      "        downcasting, use the .astype(t) method.\n",
      "    copy : bool, optional\n",
      "        If true (default), then the object is copied.  Otherwise, a copy will\n",
      "        only be made if __array__ returns a copy, if obj is a nested sequence,\n",
      "        or if a copy is needed to satisfy any of the other requirements\n",
      "        (`dtype`, `order`, etc.).\n",
      "    order : {'K', 'A', 'C', 'F'}, optional\n",
      "        Specify the memory layout of the array. If object is not an array, the\n",
      "        newly created array will be in C order (row major) unless 'F' is\n",
      "        specified, in which case it will be in Fortran order (column major).\n",
      "        If object is an array the following holds.\n",
      "    \n",
      "        ===== ========= ===================================================\n",
      "        order  no copy                     copy=True\n",
      "        ===== ========= ===================================================\n",
      "        'K'   unchanged F & C order preserved, otherwise most similar order\n",
      "        'A'   unchanged F order if input is F and not C, otherwise C order\n",
      "        'C'   C order   C order\n",
      "        'F'   F order   F order\n",
      "        ===== ========= ===================================================\n",
      "    \n",
      "        When ``copy=False`` and a copy is made for other reasons, the result is\n",
      "        the same as if ``copy=True``, with some exceptions for `A`, see the\n",
      "        Notes section. The default order is 'K'.\n",
      "    subok : bool, optional\n",
      "        If True, then sub-classes will be passed-through, otherwise\n",
      "        the returned array will be forced to be a base-class array (default).\n",
      "    ndmin : int, optional\n",
      "        Specifies the minimum number of dimensions that the resulting\n",
      "        array should have.  Ones will be pre-pended to the shape as\n",
      "        needed to meet this requirement.\n",
      "    \n",
      "    Returns\n",
      "    -------\n",
      "    out : ndarray\n",
      "        An array object satisfying the specified requirements.\n",
      "    \n",
      "    See Also\n",
      "    --------\n",
      "    empty, empty_like, zeros, zeros_like, ones, ones_like, full, full_like\n",
      "    \n",
      "    Notes\n",
      "    -----\n",
      "    When order is 'A' and `object` is an array in neither 'C' nor 'F' order,\n",
      "    and a copy is forced by a change in dtype, then the order of the result is\n",
      "    not necessarily 'C' as expected. This is likely a bug.\n",
      "    \n",
      "    Examples\n",
      "    --------\n",
      "    >>> np.array([1, 2, 3])\n",
      "    array([1, 2, 3])\n",
      "    \n",
      "    Upcasting:\n",
      "    \n",
      "    >>> np.array([1, 2, 3.0])\n",
      "    array([ 1.,  2.,  3.])\n",
      "    \n",
      "    More than one dimension:\n",
      "    \n",
      "    >>> np.array([[1, 2], [3, 4]])\n",
      "    array([[1, 2],\n",
      "           [3, 4]])\n",
      "    \n",
      "    Minimum dimensions 2:\n",
      "    \n",
      "    >>> np.array([1, 2, 3], ndmin=2)\n",
      "    array([[1, 2, 3]])\n",
      "    \n",
      "    Type provided:\n",
      "    \n",
      "    >>> np.array([1, 2, 3], dtype=complex)\n",
      "    array([ 1.+0.j,  2.+0.j,  3.+0.j])\n",
      "    \n",
      "    Data-type consisting of more than one element:\n",
      "    \n",
      "    >>> x = np.array([(1,2),(3,4)],dtype=[('a','<i4'),('b','<i4')])\n",
      "    >>> x['a']\n",
      "    array([1, 3])\n",
      "    \n",
      "    Creating an array from sub-classes:\n",
      "    \n",
      "    >>> np.array(np.mat('1 2; 3 4'))\n",
      "    array([[1, 2],\n",
      "           [3, 4]])\n",
      "    \n",
      "    >>> np.array(np.mat('1 2; 3 4'), subok=True)\n",
      "    matrix([[1, 2],\n",
      "            [3, 4]])\n",
      "\n"
     ]
    }
   ],
   "source": [
    "import numpy\n",
    "\n",
    "help(numpy.array)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['.ipynb_checkpoints',\n",
       " 'supermarkets-commas.txt',\n",
       " 'supermarkets-semi-colons.txt',\n",
       " 'supermarkets.csv',\n",
       " 'supermarkets.json',\n",
       " 'supermarkets.xlsx',\n",
       " 'Testing.ipynb']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "os.listdir()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Country</th>\n",
       "      <th>Name</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>3666 21st St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA 94114</td>\n",
       "      <td>USA</td>\n",
       "      <td>Madeira</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>735 Dolores St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA 94119</td>\n",
       "      <td>USA</td>\n",
       "      <td>Bready Shop</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>332 Hill St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>California 94114</td>\n",
       "      <td>USA</td>\n",
       "      <td>Super River</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>3995 23rd St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA 94114</td>\n",
       "      <td>USA</td>\n",
       "      <td>Ben's Shop</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>1056 Sanchez St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>California</td>\n",
       "      <td>USA</td>\n",
       "      <td>Sanchez</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>551 Alvarado St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA 94114</td>\n",
       "      <td>USA</td>\n",
       "      <td>Richvalley</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ID          Address           City             State Country         Name  \\\n",
       "0   1     3666 21st St  San Francisco          CA 94114     USA      Madeira   \n",
       "1   2   735 Dolores St  San Francisco          CA 94119     USA  Bready Shop   \n",
       "2   3      332 Hill St  San Francisco  California 94114     USA  Super River   \n",
       "3   4     3995 23rd St  San Francisco          CA 94114     USA   Ben's Shop   \n",
       "4   5  1056 Sanchez St  San Francisco        California     USA      Sanchez   \n",
       "5   6  551 Alvarado St  San Francisco          CA 94114     USA   Richvalley   \n",
       "\n",
       "   Employees  \n",
       "0          8  \n",
       "1         15  \n",
       "2         25  \n",
       "3         10  \n",
       "4         12  \n",
       "5         20  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas\n",
    "df1=pandas.read_csv(\"supermarkets.csv\")\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Country</th>\n",
       "      <th>Name</th>\n",
       "      <th>Employees</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>3666 21st St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA 94114</td>\n",
       "      <td>USA</td>\n",
       "      <td>Madeira</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>735 Dolores St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA 94119</td>\n",
       "      <td>USA</td>\n",
       "      <td>Bready Shop</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>332 Hill St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>California 94114</td>\n",
       "      <td>USA</td>\n",
       "      <td>Super River</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>3995 23rd St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA 94114</td>\n",
       "      <td>USA</td>\n",
       "      <td>Ben's Shop</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>1056 Sanchez St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>California</td>\n",
       "      <td>USA</td>\n",
       "      <td>Sanchez</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>551 Alvarado St</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA 94114</td>\n",
       "      <td>USA</td>\n",
       "      <td>Richvalley</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ID          Address           City             State Country          Name  \\\n",
       "0   1     3666 21st St  San Francisco          CA 94114     USA       Madeira   \n",
       "1   2   735 Dolores St  San Francisco          CA 94119     USA   Bready Shop   \n",
       "2   3      332 Hill St  San Francisco  California 94114     USA   Super River   \n",
       "3   4     3995 23rd St  San Francisco          CA 94114     USA    Ben's Shop   \n",
       "4   5  1056 Sanchez St  San Francisco        California     USA       Sanchez   \n",
       "5   6  551 Alvarado St  San Francisco          CA 94114     USA    Richvalley   \n",
       "\n",
       "   Employees  \n",
       "0          8  \n",
       "1         15  \n",
       "2         25  \n",
       "3         10  \n",
       "4         12  \n",
       "5         20  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas\n",
    "df1=pandas.read_csv(\"supermarkets-semi-colons.txt\",sep=\";\")\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ApparentTemperature</th>\n",
       "      <th>Ceiling</th>\n",
       "      <th>CloudCover</th>\n",
       "      <th>DewPoint</th>\n",
       "      <th>EpochTime</th>\n",
       "      <th>IsDayTime</th>\n",
       "      <th>Link</th>\n",
       "      <th>LocalObservationDateTime</th>\n",
       "      <th>MobileLink</th>\n",
       "      <th>ObstructionsToVisibility</th>\n",
       "      <th>...</th>\n",
       "      <th>TemperatureSummary</th>\n",
       "      <th>UVIndex</th>\n",
       "      <th>UVIndexText</th>\n",
       "      <th>Visibility</th>\n",
       "      <th>WeatherIcon</th>\n",
       "      <th>WeatherText</th>\n",
       "      <th>WetBulbTemperature</th>\n",
       "      <th>Wind</th>\n",
       "      <th>WindChillTemperature</th>\n",
       "      <th>WindGust</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{'Metric': {'Value': 20.6, 'Unit': 'C', 'UnitT...</td>\n",
       "      <td>{'Metric': {'Value': 9144.0, 'Unit': 'm', 'Uni...</td>\n",
       "      <td>31</td>\n",
       "      <td>{'Metric': {'Value': 5.6, 'Unit': 'C', 'UnitTy...</td>\n",
       "      <td>1524000900</td>\n",
       "      <td>False</td>\n",
       "      <td>http://www.accuweather.com/en/in/belada/300848...</td>\n",
       "      <td>2018-04-18T03:05:00+05:30</td>\n",
       "      <td>http://m.accuweather.com/en/in/belada/3008489/...</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>{'Past6HourRange': {'Minimum': {'Metric': {'Va...</td>\n",
       "      <td>0</td>\n",
       "      <td>Low</td>\n",
       "      <td>{'Metric': {'Value': 8.0, 'Unit': 'km', 'UnitT...</td>\n",
       "      <td>37</td>\n",
       "      <td>Hazy clouds</td>\n",
       "      <td>{'Metric': {'Value': 13.4, 'Unit': 'C', 'UnitT...</td>\n",
       "      <td>{'Direction': {'Degrees': 23, 'Localized': 'NN...</td>\n",
       "      <td>{'Metric': {'Value': 23.3, 'Unit': 'C', 'UnitT...</td>\n",
       "      <td>{'Speed': {'Metric': {'Value': 14.5, 'Unit': '...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 ApparentTemperature  \\\n",
       "0  {'Metric': {'Value': 20.6, 'Unit': 'C', 'UnitT...   \n",
       "\n",
       "                                             Ceiling  CloudCover  \\\n",
       "0  {'Metric': {'Value': 9144.0, 'Unit': 'm', 'Uni...          31   \n",
       "\n",
       "                                            DewPoint   EpochTime  IsDayTime  \\\n",
       "0  {'Metric': {'Value': 5.6, 'Unit': 'C', 'UnitTy...  1524000900      False   \n",
       "\n",
       "                                                Link  \\\n",
       "0  http://www.accuweather.com/en/in/belada/300848...   \n",
       "\n",
       "    LocalObservationDateTime  \\\n",
       "0  2018-04-18T03:05:00+05:30   \n",
       "\n",
       "                                          MobileLink ObstructionsToVisibility  \\\n",
       "0  http://m.accuweather.com/en/in/belada/3008489/...                            \n",
       "\n",
       "                         ...                          \\\n",
       "0                        ...                           \n",
       "\n",
       "                                  TemperatureSummary UVIndex UVIndexText  \\\n",
       "0  {'Past6HourRange': {'Minimum': {'Metric': {'Va...       0         Low   \n",
       "\n",
       "                                          Visibility WeatherIcon  WeatherText  \\\n",
       "0  {'Metric': {'Value': 8.0, 'Unit': 'km', 'UnitT...          37  Hazy clouds   \n",
       "\n",
       "                                  WetBulbTemperature  \\\n",
       "0  {'Metric': {'Value': 13.4, 'Unit': 'C', 'UnitT...   \n",
       "\n",
       "                                                Wind  \\\n",
       "0  {'Direction': {'Degrees': 23, 'Localized': 'NN...   \n",
       "\n",
       "                                WindChillTemperature  \\\n",
       "0  {'Metric': {'Value': 23.3, 'Unit': 'C', 'UnitT...   \n",
       "\n",
       "                                            WindGust  \n",
       "0  {'Speed': {'Metric': {'Value': 14.5, 'Unit': '...  \n",
       "\n",
       "[1 rows x 29 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas\n",
    "df1=pandas.read_json(\"http://dataservice.accuweather.com/currentconditions/v1/3008489?apikey=ukARpEXeA9PI9rz6XIlHIUwzmPY0lPEx&details=true\")\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "geopy.location.Location"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from geopy import Nominatim\n",
    "nom=Nominatim()\n",
    "nomi=nom.geocode(\"Roorkee,Uttarakhand,India\")\n",
    "nomi.latitude\n",
    "nomi.longitude\n",
    "\n"
   ]
  }
 ],
 "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}