Bitly_Data_Transformation_Pandas.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "source": [
        "#**Bitly User Activity Data Transformation**\n",
        "Transforming Bitly User activity dataset who shorten `.gov` links into readable tabular data from `json` file to a `DataFrame` to eventually a `CSV`.\n",
        "\n",
        "###**Objective:**\n",
        "-  Data Transformation\n",
        "-  Data Cleansing\n",
        "\n",
        "\n",
        "###**Tech Stack:**\n",
        "- Python\n",
        "- Pandas ***Library***\n",
        "- json ***Library***\n",
        "- datetime ***Library***\n",
        "- seaborn ***Library***\n",
        "- matplotlib.pyplot ***Library***\n",
        "\n",
        "###**Dataset:**\n",
        "- `usa.gov_click_data_1.json`\n",
        "\n",
        "***To download the dataset make sure to check the `dataset` folder in the `repository`***\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n"
      ],
      "metadata": {
        "id": "jNZVFmK5StWA"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 30,
      "metadata": {
        "id": "Dm0A0xvakQ6b"
      },
      "outputs": [],
      "source": [
        "import json\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "from datetime import datetime\n",
        "import matplotlib.pyplot as plt\n",
        "import seaborn as sns"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data = [json.loads(line) for line in open('usa.gov_click_data.json')]\n",
        "data[0] # Print the first occurance"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_ndD3sQxkcLL",
        "outputId": "886e0c09-46b9-4f01-a20b-05963ce7377c"
      },
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'a': 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.78 Safari/535.11',\n",
              " 'c': 'US',\n",
              " 'nk': 1,\n",
              " 'tz': 'America/New_York',\n",
              " 'gr': 'MA',\n",
              " 'g': 'A6qOVH',\n",
              " 'h': 'wfLQtf',\n",
              " 'l': 'orofrog',\n",
              " 'al': 'en-US,en;q=0.8',\n",
              " 'hh': '1.usa.gov',\n",
              " 'r': 'http://www.facebook.com/l/7AQEFzjSi/1.usa.gov/wfLQtf',\n",
              " 'u': 'http://www.ncbi.nlm.nih.gov/pubmed/22415991',\n",
              " 't': 1333307030,\n",
              " 'hc': 1333307037,\n",
              " 'cy': 'Danvers',\n",
              " 'll': [42.576698, -70.954903]}"
            ]
          },
          "metadata": {},
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "bitly = pd.DataFrame(data) #Converting json to a DataFrame\n",
        "bitly"
      ],
      "metadata": {
        "id": "n3_ICrAwk_g0",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 785
        },
        "outputId": "57bf8db9-a25d-4e61-d17f-ccfc58865bf6"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                                    a     c  nk  \\\n",
              "0   Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKi...    US   1   \n",
              "1                              GoogleMaps/RochesterNY    US   0   \n",
              "2   Mozilla/4.0 (Windows NT 6.1; MSIE 8.0; Windows...    US   1   \n",
              "3   Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_8)...    BR   0   \n",
              "4   Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKi...    US   0   \n",
              "5   Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKi...    US   0   \n",
              "6   Mozilla/5.0 (Windows NT 5.1) AppleWebKit/535.1...    PL   0   \n",
              "7   Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/2...  None   0   \n",
              "8   Opera/9.80 (Ubuntu 14.04.6; Linux zbov; U; en)...  None   0   \n",
              "9   Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKi...  None   0   \n",
              "10  Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2)...    US   1   \n",
              "11  Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4...    US   0   \n",
              "\n",
              "                     tz   gr       g       h             l  \\\n",
              "0      America/New_York   MA  A6qOVH  wfLQtf       orofrog   \n",
              "1        America/Denver   UT  mwszkS  mwszkS         bitly   \n",
              "2      America/New_York   DC  xxr3Qb  xxr3Qb         bitly   \n",
              "3     America/Sao_Paulo   27  zCaLwp  zUtuOu      alelex88   \n",
              "4      America/New_York   MA  9b6kNl  9b6kNl         bitly   \n",
              "5      America/New_York   MA  axNK8c  axNK8c         bitly   \n",
              "6         Europe/Warsaw   77  wcndER  zkpJBR      bnjacobs   \n",
              "7                        NaN  wcndER  zkpJBR      bnjacobs   \n",
              "8                        NaN  wcndER  zkpJBR      bnjacobs   \n",
              "9                        NaN  zCaLwp  zUtuOu      alelex88   \n",
              "10  America/Los_Angeles   WA  vNJS4H  u0uD9q  o_4us71ccioa   \n",
              "11     America/New_York   DC  wG7OIH  A0nRz4   darrellissa   \n",
              "\n",
              "                                     al         hh  \\\n",
              "0                        en-US,en;q=0.8  1.usa.gov   \n",
              "1                                   NaN       j.mp   \n",
              "2                                 en-US  1.usa.gov   \n",
              "3                                 pt-br  1.usa.gov   \n",
              "4                        en-US,en;q=0.8     bit.ly   \n",
              "5                        en-US,en;q=0.8     bit.ly   \n",
              "6   pl-PL,pl;q=0.8,en-US;q=0.6,en;q=0.4  1.usa.gov   \n",
              "7               bg,en-us;q=0.7,en;q=0.3  1.usa.gov   \n",
              "8                             en-US, en  1.usa.gov   \n",
              "9   pt-BR,pt;q=0.8,en-US;q=0.6,en;q=0.4  1.usa.gov   \n",
              "10                       en-us,en;q=0.5  1.usa.gov   \n",
              "11                       en-us,en;q=0.5  1.usa.gov   \n",
              "\n",
              "                                                    r  \\\n",
              "0   http://www.facebook.com/l/7AQEFzjSi/1.usa.gov/...   \n",
              "1                            http://www.AwareMap.com/   \n",
              "2                                http://t.co/03elZC4Q   \n",
              "3                                              direct   \n",
              "4                 http://www.shrewsbury-ma.gov/selco/   \n",
              "5                 http://www.shrewsbury-ma.gov/selco/   \n",
              "6   http://plus.url.google.com/url?sa=z&n=13319232...   \n",
              "7                            http://www.facebook.com/   \n",
              "8   http://www.facebook.com/l.php?u=http%3A%2F%2F1...   \n",
              "9                                http://t.co/o1Pd0WeV   \n",
              "10                                             direct   \n",
              "11                               http://t.co/ND7SoPyo   \n",
              "\n",
              "                                                    u           t  \\\n",
              "0         http://www.ncbi.nlm.nih.gov/pubmed/22415991  1333307030   \n",
              "1         http://www.monroecounty.gov/etc/911/rss.php  1331923249   \n",
              "2   http://boxer.senate.gov/en/press/releases/0316...  1333407030   \n",
              "3             http://apod.nasa.gov/apod/ap120312.html  1333507030   \n",
              "4   http://www.shrewsbury-ma.gov/egov/gallery/1341...  1333607030   \n",
              "5   http://www.shrewsbury-ma.gov/egov/gallery/1341...  1333707030   \n",
              "6   http://www.nasa.gov/mission_pages/nustar/main/...  1333807030   \n",
              "7   http://www.nasa.gov/mission_pages/nustar/main/...  1334007036   \n",
              "8   http://www.nasa.gov/mission_pages/nustar/main/...  1333907030   \n",
              "9             http://apod.nasa.gov/apod/ap120312.html  1334007030   \n",
              "10  https://www.nysdot.gov/rexdesign/design/commun...  1334107030   \n",
              "11  http://oversight.house.gov/wp-content/uploads/...  1334207040   \n",
              "\n",
              "             hc          cy                        ll  \n",
              "0    1333307037     Danvers   [42.576698, -70.954903]  \n",
              "1    1308262393       Provo  [40.218102, -111.613297]  \n",
              "2    1333407035  Washington     [38.9007, -77.043098]  \n",
              "3    1333507044        Braz  [-23.549999, -46.616699]  \n",
              "4    1333607039  Shrewsbury   [42.286499, -71.714699]  \n",
              "5    1333707048  Shrewsbury   [42.286499, -71.714699]  \n",
              "6    1333807040       Luban      [51.116699, 15.2833]  \n",
              "7   13340070364         NaN                       NaN  \n",
              "8    1333907042         NaN                       NaN  \n",
              "9    1334007040         NaN                       NaN  \n",
              "10   1334107040     Seattle    [47.5951, -122.332603]  \n",
              "11   1334207043  Washington   [38.937599, -77.092796]  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bd14ddff-2672-4cee-911e-79db19ce2326\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>a</th>\n",
              "      <th>c</th>\n",
              "      <th>nk</th>\n",
              "      <th>tz</th>\n",
              "      <th>gr</th>\n",
              "      <th>g</th>\n",
              "      <th>h</th>\n",
              "      <th>l</th>\n",
              "      <th>al</th>\n",
              "      <th>hh</th>\n",
              "      <th>r</th>\n",
              "      <th>u</th>\n",
              "      <th>t</th>\n",
              "      <th>hc</th>\n",
              "      <th>cy</th>\n",
              "      <th>ll</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKi...</td>\n",
              "      <td>US</td>\n",
              "      <td>1</td>\n",
              "      <td>America/New_York</td>\n",
              "      <td>MA</td>\n",
              "      <td>A6qOVH</td>\n",
              "      <td>wfLQtf</td>\n",
              "      <td>orofrog</td>\n",
              "      <td>en-US,en;q=0.8</td>\n",
              "      <td>1.usa.gov</td>\n",
              "      <td>http://www.facebook.com/l/7AQEFzjSi/1.usa.gov/...</td>\n",
              "      <td>http://www.ncbi.nlm.nih.gov/pubmed/22415991</td>\n",
              "      <td>1333307030</td>\n",
              "      <td>1333307037</td>\n",
              "      <td>Danvers</td>\n",
              "      <td>[42.576698, -70.954903]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>GoogleMaps/RochesterNY</td>\n",
              "      <td>US</td>\n",
              "      <td>0</td>\n",
              "      <td>America/Denver</td>\n",
              "      <td>UT</td>\n",
              "      <td>mwszkS</td>\n",
              "      <td>mwszkS</td>\n",
              "      <td>bitly</td>\n",
              "      <td>NaN</td>\n",
              "      <td>j.mp</td>\n",
              "      <td>http://www.AwareMap.com/</td>\n",
              "      <td>http://www.monroecounty.gov/etc/911/rss.php</td>\n",
              "      <td>1331923249</td>\n",
              "      <td>1308262393</td>\n",
              "      <td>Provo</td>\n",
              "      <td>[40.218102, -111.613297]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Mozilla/4.0 (Windows NT 6.1; MSIE 8.0; Windows...</td>\n",
              "      <td>US</td>\n",
              "      <td>1</td>\n",
              "      <td>America/New_York</td>\n",
              "      <td>DC</td>\n",
              "      <td>xxr3Qb</td>\n",
              "      <td>xxr3Qb</td>\n",
              "      <td>bitly</td>\n",
              "      <td>en-US</td>\n",
              "      <td>1.usa.gov</td>\n",
              "      <td>http://t.co/03elZC4Q</td>\n",
              "      <td>http://boxer.senate.gov/en/press/releases/0316...</td>\n",
              "      <td>1333407030</td>\n",
              "      <td>1333407035</td>\n",
              "      <td>Washington</td>\n",
              "      <td>[38.9007, -77.043098]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_8)...</td>\n",
              "      <td>BR</td>\n",
              "      <td>0</td>\n",
              "      <td>America/Sao_Paulo</td>\n",
              "      <td>27</td>\n",
              "      <td>zCaLwp</td>\n",
              "      <td>zUtuOu</td>\n",
              "      <td>alelex88</td>\n",
              "      <td>pt-br</td>\n",
              "      <td>1.usa.gov</td>\n",
              "      <td>direct</td>\n",
              "      <td>http://apod.nasa.gov/apod/ap120312.html</td>\n",
              "      <td>1333507030</td>\n",
              "      <td>1333507044</td>\n",
              "      <td>Braz</td>\n",
              "      <td>[-23.549999, -46.616699]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKi...</td>\n",
              "      <td>US</td>\n",
              "      <td>0</td>\n",
              "      <td>America/New_York</td>\n",
              "      <td>MA</td>\n",
              "      <td>9b6kNl</td>\n",
              "      <td>9b6kNl</td>\n",
              "      <td>bitly</td>\n",
              "      <td>en-US,en;q=0.8</td>\n",
              "      <td>bit.ly</td>\n",
              "      <td>http://www.shrewsbury-ma.gov/selco/</td>\n",
              "      <td>http://www.shrewsbury-ma.gov/egov/gallery/1341...</td>\n",
              "      <td>1333607030</td>\n",
              "      <td>1333607039</td>\n",
              "      <td>Shrewsbury</td>\n",
              "      <td>[42.286499, -71.714699]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKi...</td>\n",
              "      <td>US</td>\n",
              "      <td>0</td>\n",
              "      <td>America/New_York</td>\n",
              "      <td>MA</td>\n",
              "      <td>axNK8c</td>\n",
              "      <td>axNK8c</td>\n",
              "      <td>bitly</td>\n",
              "      <td>en-US,en;q=0.8</td>\n",
              "      <td>bit.ly</td>\n",
              "      <td>http://www.shrewsbury-ma.gov/selco/</td>\n",
              "      <td>http://www.shrewsbury-ma.gov/egov/gallery/1341...</td>\n",
              "      <td>1333707030</td>\n",
              "      <td>1333707048</td>\n",
              "      <td>Shrewsbury</td>\n",
              "      <td>[42.286499, -71.714699]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Mozilla/5.0 (Windows NT 5.1) AppleWebKit/535.1...</td>\n",
              "      <td>PL</td>\n",
              "      <td>0</td>\n",
              "      <td>Europe/Warsaw</td>\n",
              "      <td>77</td>\n",
              "      <td>wcndER</td>\n",
              "      <td>zkpJBR</td>\n",
              "      <td>bnjacobs</td>\n",
              "      <td>pl-PL,pl;q=0.8,en-US;q=0.6,en;q=0.4</td>\n",
              "      <td>1.usa.gov</td>\n",
              "      <td>http://plus.url.google.com/url?sa=z&amp;n=13319232...</td>\n",
              "      <td>http://www.nasa.gov/mission_pages/nustar/main/...</td>\n",
              "      <td>1333807030</td>\n",
              "      <td>1333807040</td>\n",
              "      <td>Luban</td>\n",
              "      <td>[51.116699, 15.2833]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/2...</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td></td>\n",
              "      <td>NaN</td>\n",
              "      <td>wcndER</td>\n",
              "      <td>zkpJBR</td>\n",
              "      <td>bnjacobs</td>\n",
              "      <td>bg,en-us;q=0.7,en;q=0.3</td>\n",
              "      <td>1.usa.gov</td>\n",
              "      <td>http://www.facebook.com/</td>\n",
              "      <td>http://www.nasa.gov/mission_pages/nustar/main/...</td>\n",
              "      <td>1334007036</td>\n",
              "      <td>13340070364</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Opera/9.80 (Ubuntu 14.04.6; Linux zbov; U; en)...</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td></td>\n",
              "      <td>NaN</td>\n",
              "      <td>wcndER</td>\n",
              "      <td>zkpJBR</td>\n",
              "      <td>bnjacobs</td>\n",
              "      <td>en-US, en</td>\n",
              "      <td>1.usa.gov</td>\n",
              "      <td>http://www.facebook.com/l.php?u=http%3A%2F%2F1...</td>\n",
              "      <td>http://www.nasa.gov/mission_pages/nustar/main/...</td>\n",
              "      <td>1333907030</td>\n",
              "      <td>1333907042</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKi...</td>\n",
              "      <td>None</td>\n",
              "      <td>0</td>\n",
              "      <td></td>\n",
              "      <td>NaN</td>\n",
              "      <td>zCaLwp</td>\n",
              "      <td>zUtuOu</td>\n",
              "      <td>alelex88</td>\n",
              "      <td>pt-BR,pt;q=0.8,en-US;q=0.6,en;q=0.4</td>\n",
              "      <td>1.usa.gov</td>\n",
              "      <td>http://t.co/o1Pd0WeV</td>\n",
              "      <td>http://apod.nasa.gov/apod/ap120312.html</td>\n",
              "      <td>1334007030</td>\n",
              "      <td>1334007040</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2)...</td>\n",
              "      <td>US</td>\n",
              "      <td>1</td>\n",
              "      <td>America/Los_Angeles</td>\n",
              "      <td>WA</td>\n",
              "      <td>vNJS4H</td>\n",
              "      <td>u0uD9q</td>\n",
              "      <td>o_4us71ccioa</td>\n",
              "      <td>en-us,en;q=0.5</td>\n",
              "      <td>1.usa.gov</td>\n",
              "      <td>direct</td>\n",
              "      <td>https://www.nysdot.gov/rexdesign/design/commun...</td>\n",
              "      <td>1334107030</td>\n",
              "      <td>1334107040</td>\n",
              "      <td>Seattle</td>\n",
              "      <td>[47.5951, -122.332603]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4...</td>\n",
              "      <td>US</td>\n",
              "      <td>0</td>\n",
              "      <td>America/New_York</td>\n",
              "      <td>DC</td>\n",
              "      <td>wG7OIH</td>\n",
              "      <td>A0nRz4</td>\n",
              "      <td>darrellissa</td>\n",
              "      <td>en-us,en;q=0.5</td>\n",
              "      <td>1.usa.gov</td>\n",
              "      <td>http://t.co/ND7SoPyo</td>\n",
              "      <td>http://oversight.house.gov/wp-content/uploads/...</td>\n",
              "      <td>1334207040</td>\n",
              "      <td>1334207043</td>\n",
              "      <td>Washington</td>\n",
              "      <td>[38.937599, -77.092796]</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bd14ddff-2672-4cee-911e-79db19ce2326')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-bd14ddff-2672-4cee-911e-79db19ce2326 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-bd14ddff-2672-4cee-911e-79db19ce2326');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "##**Extracting `browser` name into a new column**"
      ],
      "metadata": {
        "id": "QH0aXefV5FEn"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['web_browser'] = bitly['a'].str.extract('([A-Za-z0-9]+)', expand=True) #Extracting browser name"
      ],
      "metadata": {
        "id": "GTNHDwl-E5s_"
      },
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['web_browser'] #validating the changes"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "RGrngFLCe2xc",
        "outputId": "ad49e07b-7991-4b1b-a277-9b17c7fd2d6b"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0        Mozilla\n",
              "1     GoogleMaps\n",
              "2        Mozilla\n",
              "3        Mozilla\n",
              "4        Mozilla\n",
              "5        Mozilla\n",
              "6        Mozilla\n",
              "7        Mozilla\n",
              "8          Opera\n",
              "9        Mozilla\n",
              "10       Mozilla\n",
              "11       Mozilla\n",
              "Name: web_browser, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "##**Extracting `OS` name into a new column**"
      ],
      "metadata": {
        "id": "VNu_QJKs5Tt-"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['operating_sys'] = bitly['a'].str.replace('([A-Za-z]+/[0-9]*\\.[0-9]+)','', regex=True) #Simplifying the sentense to extract from next"
      ],
      "metadata": {
        "id": "E1gPfOKtW8pK"
      },
      "execution_count": 6,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['operating_sys'] = bitly['operating_sys'].str.extract('([A-Za-z]+)', expand=True) #Extracting OS Name"
      ],
      "metadata": {
        "id": "H9A-D7XaW-bJ"
      },
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['operating_sys'] #validating the changes"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "shQuTz6yc-28",
        "outputId": "57e51ce2-cd88-4162-defb-a447ea100504"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0        Windows\n",
              "1     GoogleMaps\n",
              "2        Windows\n",
              "3      Macintosh\n",
              "4        Windows\n",
              "5        Windows\n",
              "6        Windows\n",
              "7        Windows\n",
              "8         Ubuntu\n",
              "9        Windows\n",
              "10       Windows\n",
              "11     Macintosh\n",
              "Name: operating_sys, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "##**Extracting `from url` into a new column**"
      ],
      "metadata": {
        "id": "faDFcq9m5iIE"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['from_url'] = bitly['r'].str.replace('http://','') #Removing http://"
      ],
      "metadata": {
        "id": "OnX93aJGql8p"
      },
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['from_url'] = bitly['from_url'].str.replace('/+.*','', regex=True) #Removing anything after /"
      ],
      "metadata": {
        "id": "6TjrN949s8Ct"
      },
      "execution_count": 10,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['from_url'].head(12)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3lL-SP71jLmU",
        "outputId": "126be6cd-4d56-4b2b-d272-91205b93cf7e"
      },
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0          www.facebook.com\n",
              "1          www.AwareMap.com\n",
              "2                      t.co\n",
              "3                    direct\n",
              "4     www.shrewsbury-ma.gov\n",
              "5     www.shrewsbury-ma.gov\n",
              "6       plus.url.google.com\n",
              "7          www.facebook.com\n",
              "8          www.facebook.com\n",
              "9                      t.co\n",
              "10                   direct\n",
              "11                     t.co\n",
              "Name: from_url, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from_url = bitly['from_url']\n",
        "plt.figure(figsize=(15,8))\n",
        "sns.barplot(y= from_url.index, x= from_url.values)\n",
        "plt.tick_params(axis='x', colors='white')\n",
        "plt.tick_params(axis='y', colors='white')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 483
        },
        "id": "Fr9EJo1ac_Kc",
        "outputId": "20dbd995-aa5e-4cdb-b1aa-6bc07df0de9b"
      },
      "execution_count": 56,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 1080x576 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAA2cAAAHSCAYAAABo07OKAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/NK7nSAAAACXBIWXMAAAsTAAALEwEAmpwYAAAdv0lEQVR4nO3de5hkZX0n8O/AiFwUwRt4wYwal1UEMaBRASWIGy/xEqNRE3mUJ5F1d2MwGzOya7xusmswUROTmLDEkESC2fUSjdl1xQuKo6IgMAMi63qJMmsjakREVC69f/xObRdN90z3VNP1m+7P53nq6a5Tp855q85b7znf8751asPs7GwAAACYrj2mXQAAAACEMwAAgBaEMwAAgAaEMwAAgAaEMwAAgAaEMwAAgAY2rubK7n73u89u2rRpNVcJAADQxkUXXfSt2dnZeyz02KqGs02bNuXCCy9czVUCAAC0sWHDhn9a7DHDGgEAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABrYOO0CALDyNm/enJmZmRx88ME5/fTTp10cAGAJhDOANWhmZibbt2+fdjEAgGUwrBEAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKAB4QwAAKCBpYSztyX5ZpLLxqbdNcm5Sb44/D1w5YsGAACwfiwlnJ2V5Inzpp2W5MNJHjT8PW1liwUAALC+bFzCPB9PsmnetKcnOX74/6+SnJfk5StVKABgdWzevDkzMzM5+OCDc/rpp0+7OADr2lLC2UIOSvKN4f+Z4f5iThluAEAzMzMz2b59+7SLAUB2PZyNmx1uizljuGUn8wEAAKxbu3q1xquT3Gv4/16pC4YAAACwi3Y1nL0vyQuG/1+Q5L0rUxwAAID1aSnh7Jwkn0pyaJKrkvxKktcneULqUvonDvcBAADYRUv5ztnzFpn++JUsCAAAwHq2q8MaAQAAWEHCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAOThrPfSHJ5ksuSnJNk74lLBAAAsA5NEs7uk+TXkxyd5KFJ9kzy3JUoFAAAwHozac/ZxiT7DH/3TfJ/Jy4RAADAOjRJONue5PeTfC3JN5Jcm+SDK1EoAACA9WaScHZgkqcnuX+SeyfZL8nzF5jvlCQXDjcAAAAWMEk4OzHJV5Jck+TGJO9O8pgF5jsj9b20oydYFwAAwJo2STj7WpJHpb5rtiHJ45NcsRKFAgAAWG8mCWcXJHlnks8l2TYs64yVKBQAAMB6s3HC5796uAEAADCBSS+lDwAAwAoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABoQzgAAABrYOO0CAEzLMW85ZtpFuN3s9d29skf2yNe/+/U1+Tq3vGTLqq7vY4993KqubzXdsHHPZMOG3HDVVWv2dT7u4x+bdhEAlkTPGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAPCGQAAQAOThrMDkrwzyReSXJHk0ZMWCAAAYD3aOOHz/zDJB5I8K8leSfaduEQAAADr0CTh7C5JHpvkhcP9Hw83AAAAlmmSYY33T3JNkr9McnGSM5PstxKFAgAAWG8m6TnbmOSnkrwkyQWpIY6nJXnlvPlOGW4AAMDgd5//rGkXgQm84u3vXPFlTtJzdtVwu2C4/85UWJvvjCRHDzcAAAAWMEk4m0ny9SSHDvcfn+TzE5cIAABgHZr0ao0vSXJ26kqNX05y8sQlAgAAWIcmDWeXxHBFAACAiU36I9QAAACsAOEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACgAeEMAACggY3TLgAAALuHzZs3Z2ZmJgcffHBOP/30aRcH1hzhDACAJZmZmcn27dunXQxYswxrBAAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaGDjtAsAALCW/PFv/sO0i3C7+e63rv//f9fi6/y1P3jqtIvAOqfnDAAAoAHhDAAAoAHhDAAAoAHhDAAAoAHhDAAAoAHhDAAAoAHhDAAAoAHhDAAAoAHhDAAAoAHhDAAAoAHhDAAAoAHhDAAAoAHhDAAAoAHhDAAAoIGVCGd7Jrk4yftXYFkAAADr0kqEs1OTXLECywEAAFi3Jg1n903ylCRnrkBZAAAA1q1Jw9mbk2xOcsvkRQEAAFi/JglnP5fkm0ku2sl8pyS5cLgBAACwgI0TPPeYJE9L8uQkeyfZP8nbkzx/3nxnDLckmZ1gfQAATNF+e+1/q7/AypoknP2H4ZYkxyd5WW4bzAAAWCOOeeAzp10EWNP8zhkAAEADk/ScjTtvuAEAALAL9JwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0IJwBAAA0sHHaBQAApueA2dlb/QVgeoQzAFjHnn/zLdMuAgADwxoBAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAamCScHZLko0k+n+TyJKeuSIkAAADWoY0TPPemJL+Z5HNJ7pzkoiTnpsIaAAAAyzBJz9k3UsEsSa5LckWS+0xcIgAAgHVokp6zcZuSPDzJBQs8dspwAwAAYBErEc7ulORdSV6a5HsLPH7GcEuS2RVYHwA7MbvvbG7JLZndV7MLALuLScPZHVLB7Owk7568OACshBuPuXHaRQAAlmmS75xtSPIXqe+avXFligMAALA+TRLOjklyUpITklwy3J48eZEAAADWn0mGNX4i1XsGAADAhCbpOQMAAGCFCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANCGcAAAANbJx2AWAlfe11h0+7CEzgfq/aNu0iAABMjZ4zAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABiYNZ09McmWS/5PktMmLAwAAsD5NEs72TPInSZ6U5CFJnjf8BQAAYJkmCWePTPWYfTnJj5O8I8nTV6JQAAAA680k4ew+Sb4+dv+qYRoAAADLtGF2dnZXn/us1HfOfnW4f1KSn07ya/PmO2W4ZZ999jn0hz/84ZW7usK16qCDDrr71Vdf/a1pl4P+1BWWQ31hqdQVlkN9YanUlUX9xOzs7D0WemDjBAvdnuSQsfv3HabNd8Zwyw033DDB6ta0C5McPe1CsFtQV1gO9YWlUldYDvWFpVJXlmmSYY2fTfKgJPdPsleS5yZ530oUCgAAYL2ZpOfsptQQxv+VunLj25JcvhKFAgAAWG8mCWdJ8j+GG5M5Y9oFYLehrrAc6gtLpa6wHOoLS6WuLNMkFwQBAABghUzynTMAAABWiHC2fOck2ZrkN1Zwmd9foeWcF1fE6eDNqSuXrubn6zVJZpP85Ni0lw7T1Im154Ak/3bahWC38JokL0vyuiQnrsDyjkzy5BVYDpPZlOSyKaz3hUn+eArr5bbOy+ru31+Takum4azUT3itC8LZ8hyc5BFJjkjypimXhZ72SPLzqR9of9wKL3tn3xHdlrpq6siz4yI9a9UBEc5Ynlcl+dAC0/dc5nKOjHC2O5n02gIrrVt5WBrbbRWtlXD2W0l+ffj/TUk+Mvx/QpLrk7xxuH9qki8P/z8gyZZU2Hr3MO3pSW5I/TTA3mPzjnwwyX2SXJLkuCQvSv2kwKVJ3pVk32G+g5K8Z5h+aZLHDNOfn+Qzw/P/PLfeKb4pdSD94SSjH6U7MsmnUz1170ly4E6mj+yROsvwO7mtn0ztoC9N8rkkD0yyIckbUmfhtiV5zjDv8Uk+luS9w3vx+iS/PLyGbcNzdwerVT+Ses8uT/LWJM8bpi1lGYvVpbOS/FmSC5KcnnrPP5DkoiTnJ/mXY+v++2H5Gea7Nsn4Dz++NfV7I5cnee3Y9K8Oy96W2rbjvW8jeyb5/VQd2ZrkJcP0xye5eHju25LccWyZ/yVV1y9M8lOpK7t+KcmLF1g+y/P61Da+JPXZHffE1Gf70lR7kiR3TdWPram244jVKCRT84ok/zvJJ5IcOkw7K3Nnnr+a5PdS9eTZSf5Vkk8N9/97kjsN8z0iySdTdekzSe6S6oF7TqrujfYV69Vq7VsOy9yxw9bUzxgl1S7/11Sb/sEk+wzTz0uN4LhwWPdRqX35Ral2+F5J7jncT5KHpUZZ3G+4/6XUPujZqTb/0iQfHyvPIcM6vpjk1cO0Tbl1T97LUj0t88vziiRfSXKH4bH9590fOT5LO/54amr/eHHq2Oag3NYeSf40yReSnJu6kN3os7DQPuyJqc/BeFnev8ByV8umVNnPTnJFkndm7hhhZHwE1rNSn/dk8W04vuylbLdTd1C+e6Te18uTnJnkn5LcfXjs3w/Lvyw1mic7mf7KJFem2q5zsnBP3UL1eb47JfnL1HbdmuQXhunPG6ZdlmoDR76f2pdenqpHj0y9/i8nedoir/t2s1bC2fmpsJRUF++dUh/041IHnaPHjkvy7VTAOi5VUS9OhZ3R45elGs2fTn3gxz0t1WgdOazz3cO8D0t9YH5lmO+PUhXnYamD0suTPDi1IztmeP7NqYYmSfZLVf7DhueNGru/TvLy1IHUtiVMT+rsxtmpRvO3F3ivzk7yJ0PZHpPkG0meOZTpYalhL2/IXGV/WOpg+sFJTkryL1KV9szMHaB3t1r1I6kP/jmp0PyUYT1LWcZidSmpH3h/TKoxOyP1vh+VarT+dGy+76V67B6a6kH7u3lle8Xw+o9I9eqNH6Bfm+Tw1HCVNy/wuk5JNeJHDs87O3UQcVaqXh+eqnv/Zuw5X8vcZ+Ws1A7jUbl1MGTXnJa5tui3xqbfI3Ww9gupuvTsYfprU/XwiCT/MdWGsDYdlfr8H5nq4XrEIvN9O7V/+lBqX3HicP/CVFuzV6oNOTVz+4brUz1wfzcsf34bs96s1r7lxUn+cJj/6CRXDdMflNqfH5bku5k7AE1q+x2dOh55S6r9PSoVQH43yTdTbfj+w/ovHP7+xPDYD1Lb+mdT23/8APWRw7qOSLUxSxlaNyrPa1MHvU8Zpj83tf+7cYHnLOX44xOp/crDk7wjyeYFlvPM1P7rIcNyHj1MX2wf9qHUdthvmO85w7Kn6dDU/v7BqX39UkdOLLYNl2q03f5gB/O8OnVi4rBUcByF/KOSnJx6Lx+VOgn98B1Mf0Tm9l1PysL16g5ZuD7P98rMHdccMZTv3qlAdkLqs/SIJM8Y5t9v7DVcl+rceEJqJNTrdvDabxdrJZxdlNpI+yf5UeoM4NGphmZ0FvDOqbM9f5vkscNj56d+r+1LqQr/yNSZrvHHd+ShwzzbUkHrsGH6CaleiqRC2LWpszNHpXpHLhnuP2CY55bM7eTenuTY1BnKA1JhLUn+aijXYtNH/jzVyC9UWe+c2jm8Z7j/w1QDfGwqUNyc5Oph2aMd+mdTAe5Hqffpg8P0banGbnewWvVjr9TB0N+nGs8LUo3iUpaxWF3KUMabh3I+Zrh/SWpbzz9j9I7Uzu4ZmdvOI7+YOjN+8bD8h4w9ds7Y30fntk4c1nfTcP87qZ3FV1Jn6JPb1sXRj9JvS70X1yW5JrUNDlhgHUzuUakDv68M978z/D02yd8M/38kyd1SnwfWnuNSn/0fpNqh9y0y32if86hUW7Al1a68IHWAfmiq7f/sMN/3Mvf5p6zWvuVTqZMqL09tmxuG6V9JbbNRWTaNPWe0fQ9N7V/OHeb97dQJv6R6RY8Z1vufF1j/llR4eVFuPdLn3FTYvCEVrI5d7A1aoDxJhauTh/9PTvVwLGQpxx/3TfWebEudqDost3VsanvckmQmyUeH6Yvtw25KjVB5aiqwPSXVgzdNX09tj2TuOHEpFtuGS7WUEzDHZi68fiDJP49Nf0/qpM73U3XluB1MPyb1Pv8wdbzwDwusa0f1edyJqRMXI/+cOq49L3UcclPqJPPomOXHQ9mTqksfS50wmMqx7loJZzemPmAvTDU25yf5mdTwrCuGaSenukpHZ7oenbmK/vFUSr8xdcbk2OG2s3B2VuqHuA9PnQ3aewfzbkh98I8cbodmrut4vkl+3+CTqde+o7Isx4/G/r9l7P4t2X3GIK9W/fjZVOjYlho2dGzmhjbubBlnZfG6dP3wd4/U2dEjx24PnleG96fODH4tdTA1cv9UT9vjU2eR/nHeOmYX+X8S43Vlfj3aXeoOrFWjdmVD6kDnyOH2kNy6557Frda+5W9TvR43pIbknTBMH29Xb86t29Xx7Xt55rbv4alhrKP1j3rL3pvqsRhf/4tTB7+HpMLf3Ybp8/cRs6mD3fFjyvnHINeP/b8ldcB7fCowXJbqRblkuI16eJZy/PGW1IiPw5P86wXWu6vekTqheUKqV/G6FVrurlroPV/s/vh7sNg2HFnOdutgR/V5Ejdm7j2c+rHuWglnSTUmL0s1NuenKuTFqTd7/LGLU43nj1I9WqPnvjR1duqaVOU9NDu/EtKdU2d17pC5IYpJfc9jNLxrz1Rv14dT3bD3HKbfNdUgJrUdRuOffynVTX9tKumPhkWclEryi00f+YtU4/3fctsKdV1qOMQzhvt3TI1bPj/Vbb9naljUY1PjuteS1agfz0vyq6mdzqZUIHpC5t7jHS1jsbo07nupA4HRULUNqZ3puB+kzq7O7zndP9XIXpsak/+keY8/Z+zvpxZY97mpHd+oTt01dcCxKXPfUZtfF7n9XJeqM/N9OvX5vf9w/67D3/MzV6+OT30X8XthLfp4qo3fJ1VHnrqT+T+dOmM9+hzvlxo+dmWqZ340iuLOqc//YnVvvVqNfcsDUt99+aNUiFrOd0avTO3XRyMi7pC53qXzU9+F/2LqIPQ7qdEfnxgef2Bq1MOrhvIdMkx/Qqpt2SdV17akRt3cc3gNd0zyczsp11+nQueo1+yCzB1wL9bbu5C7pK6OnFSv70K2pIbL7ZHa/x0/TN/RPuxjqWG+L8r0hzQmNVRwtA1Hx4njrk6drB1dlGxksW04/rzlbLeFbEkF2aSC0ug6COen6se+qXbl54dpi03fkmqv9k71Oi9Ulh3V53HnJvl3Y/cPTB3XPi71fbg9U8dsLY9Z1lo4u1eqkbs61S16/thjh6QayJtT3cPjFfuC1Ad29GXJranej9nUGZzFxpu+cnjultSXNUdOTTXC21JnKh6S5POpsxcfHJZ/buaGpF2fGtZwWeoszWh9L0h9/2trqsHa2fSRN6Z2BH+T2sZnZm7s7kmpLzBvTZ3VOzjVvbw19YXRj6TGbM8s8pp3V7d3/dg39SXifxx73vXDcp66k2Uki9el+X45dVb70tTZo6cvMM87UsMXx12aqhNfSO0Qt8x7/MChTKdm7mcixuv+maneuFE9+aXUe3hyarjIttTO/c92UHZWzrdT2/CyVFtwyTD9mtT3A9+d2k6jISmvSQ2/2pr6Yv1iBzHs/j6X2u6XJvmfmRuWuJhrUj0/o5+J+VTqQkM/Tp2secuwrHNTB00fTe3TLokLgiSrc+zxi6nP+iWpIV3L+c7oj1Mnf38vtR0vydxFyr6aOsk3Wv8nUqMzRsPS3pC5iyeMLgyT1EHuu4byvivVs3TjUN7PpOrKjvZjSQ0pOzBzQ+p31WtS+6CLcusLYB2d2m9lKONVqeOwt6c+I9dmx/uwm1MjUZ6U6V4MZOTKVNi4IvW+vXXe46elyvnJ1InekYW24b1TJ/GT5W+3kRdn7uJer02FsstSJ49nUidxPpcaFfSZVF0/M3Ucstj0z6aC+dZU27UtcycyRnZUn8fL9Dup92l0MZSfGd6X01Jt2KWpOjPt4aoL2jA7u1IjmIDd1FdTO7Jv7WQ+AFgJz0qdXDxpldZ3p9T3m+6WCgXHZPc5Cb0pFbweOuVyLOaOqTB7U6pH662Zu9jNco22076pkwan5LYnm9c83/sAAGC1vCXVI7Wav5f3/tR3wvdK8p+y+wSz3cH9Ul+l2SPVs/WiCZZ1Rqpnfu/UdRrWXTBL9JwBAAC0sJa+cwYAALDbEs4AAAAaEM4AAAAaEM4AAAAaEM4AAAAaEM4AAAAa+H+bKwU9jVnkcgAAAABJRU5ErkJggg==\n"
          },
          "metadata": {
            "needs_background": "dark"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "##**Extracting `to url` into a new column**"
      ],
      "metadata": {
        "id": "kdlX5V7n51ua"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['to_url'] = bitly['u'].str.replace('https?://','', regex=True) #Removing http://"
      ],
      "metadata": {
        "id": "SonQ67WJyCss"
      },
      "execution_count": 12,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['to_url'] = bitly['to_url'].str.replace('/+.*','', regex=True) #Removing anything after /"
      ],
      "metadata": {
        "id": "a7lP8KpPyC2g"
      },
      "execution_count": 13,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['to_url']"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "pJ-VR45JyNKL",
        "outputId": "10af7dbc-c462-4c22-899f-367c9a95aedb"
      },
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0      www.ncbi.nlm.nih.gov\n",
              "1      www.monroecounty.gov\n",
              "2          boxer.senate.gov\n",
              "3             apod.nasa.gov\n",
              "4     www.shrewsbury-ma.gov\n",
              "5     www.shrewsbury-ma.gov\n",
              "6              www.nasa.gov\n",
              "7              www.nasa.gov\n",
              "8              www.nasa.gov\n",
              "9             apod.nasa.gov\n",
              "10           www.nysdot.gov\n",
              "11      oversight.house.gov\n",
              "Name: to_url, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "to_url = bitly['to_url']\n",
        "plt.figure(figsize=(20,8))\n",
        "sns.barplot(y= to_url.index, x= to_url.values)\n",
        "plt.tick_params(axis='x', colors='white')\n",
        "plt.tick_params(axis='y', colors='white')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 483
        },
        "id": "65Ipz7fsZmi7",
        "outputId": "3f0228a5-2035-4438-c644-335c95aefd47"
      },
      "execution_count": 55,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 1440x576 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAABH4AAAHSCAYAAACaUwwrAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/NK7nSAAAACXBIWXMAAAsTAAALEwEAmpwYAAAmuElEQVR4nO3de7xs93w38M9JDnJBIpcSGo4qUUVVo6VxSUU9LlVaaVG3aCuP53lcS1UfxaneFK22Wn1EqqiIS+JOEZcQQeTi5JxEGooQaRLUpaJSCb/nj++azpydmXP2PrOzZ5+f9/v1mteeWTOz1m/W+s1v/dZn/WbtDa21AAAAANCfPRZdAAAAAACuHYIfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATm1cy4UddNBBbdOmTWu5SAAAAICunX322V9rrR087bk1DX42bdqUs846ay0XCQAAANC1DRs2fHHWc37qBQAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAndq46AIAAAAAq2Pz5s2LLgJzuDa2nxE/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdWk7w88okX0ly3sS0A5KckuSzw98brX7RAAAAAJjHcoKfVyW535Jpz0rygSS3Hv4+a3WLBQAAAMC8lhP8fCTJ15dMe3CSVw/3X53kIatYJgAAAABWwcZdfN+Nk1w63L9seDzLscMNAACAXXDBn3xw0UVgF/3Es++96CLwQ25Xg59JbbjNctxwy05eBwAAAMAq2tX/6nV5kkOG+4ekLv4MAAAAwDqyq8HP25M8drj/2CRvW53iAAAAALBalhP8nJjk40kOS/LlJL+V5AVJfjH179zvMzwGAAAAYB1ZzjV+HjFj+lGrWRAAAAAAVteu/tQLAAAAgHVO8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANCpeYOfpyU5P8l5SU5MstfcJQIAAABgVcwT/NwsyZOTHJ7k9kn2TPLw1SgUAAAAAPObd8TPxiR7D3/3SfJvc5cIAAAAgFUxT/BzSZIXJ/lSkkuTfCvJ+1ajUAAAAADMb57g50ZJHpzklklummTfJI+a8rpjk5w13AAAAABYI/MEP/dJ8oUkX01yVZI3J/n5Ka87LnUdoMPnWBYAAAAAKzRP8POlJHdNXdtnQ5KjklywGoUCAAAAYH7zBD9nJDkpyTlJtg3zOm41CgUAAADA/DbO+f7nDTcAAAAA1pl5/507AAAAAOuU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBT8wY/+yc5Kcm/JLkgyd3mLRAAAAAAq2PjnO//6yTvSXJ0kusm2WfuEgEAAACwKuYJfvZLcs8kxwyPvzfcAAAAAFgH5vmp1y2TfDXJPyb5VJLjk+y7GoUCAAAAYH7zjPjZmOTOSZ6U5IzUz76eleQ5S1537HADAAAGf/KooxddBObw7NeetOgiACzLPCN+vjzczhgen5QKgpY6Lsnhww0AAACANTJP8HNZkouTHDY8PirJp+cuEQAAAACrYt7/6vWkJCek/qPX55M8bu4SAQAAALAq5g1+tsRPuAAAAADWpXl+6gUAAADAOib4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATm1cdAEAANg9PPOZz8xll12Wm9zkJnnhC1+46OIAAMsg+AEAYFkuu+yyXHLJJYsuBgCwAn7qBQAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0KmNiy4AAEBP/vbp71h0Ea413/zad/77b4+f84l/8aBFFwEAVp0RPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdGo1gp89k3wqyTtXYV4AAAAArJLVCH6ekuSCVZgPAAAAAKto3uDnR5M8MMnxq1AWAAAAAFbRvMHPXyV5ZpIfzF8UAAAAAFbTPMHPLyX5SpKzd/K6Y5OcNdwAAAAAWCMb53jvEUl+OckDkuyV5IZJXpvkUUted9xwS5I2x/IAAFigfa97w+3+AgDr3zzBz+8PtyQ5Mskzcs3QBwCAThxxq19ddBEAgBVajf/qBQAAAMA6NM+In0mnDjcAAAAA1gkjfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOrVx0QUAgPXuw/e816KLwBzu9ZEPL7oIAAALY8QPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECn5gl+Dk3yoSSfTnJ+kqesSokAAAAAWBUb53jv1UmenuScJDdIcnaSU1JBEAAAAAALNs+In0tToU+SfDvJBUluNneJAAAAAFgV84z4mbQpyU8nOWPKc8cON4B15YiXHrHoIrCLTn/S6YsuAgAA7BZWI/i5fpKTkzw1yX9Mef644ZYkbRWWBwAAAMAyzPtfva6TCn1OSPLm+YsDAAAAwGqZJ/jZkOQfUtf2+cvVKQ4AAAAAq2We4OeIJI9Ocu8kW4bbA+YvEgAAAACrYZ5r/Hw0NeoHAAAAgHVo3mv8AAAAALBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTgh8AAACATgl+AAAAADol+AEAAADolOAHAAAAoFOCHwAAAIBOCX4AAAAAOiX4AQAAAOiU4AcAAACgU4IfAAAAgE4JfgAAAAA6JfgBAAAA6JTgBwAAAKBTGxddAFhNX3r+HRZdBOZw8+duW3QRAAAAumLEDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0CnBDwAAAECnBD8AAAAAnRL8AAAAAHRK8AMAAADQKcEPAAAAQKcEPwAAAACdEvwAAAAAdErwAwAAANApwQ8AAABAp+YNfu6X5MIk/5rkWfMXBwAAAIDVMk/ws2eSv0ty/yS3S/KI4S8AAAAA68A8wc/Ppkb6fD7J95K8PsmDV6NQAAAAAMxvnuDnZkkunnj85WEaAAAAAOvAhtbarr736NQ1fn57ePzoJD+X5IlLXnfscMvee+992JVXXnnhri6wVze+8Y0Puvzyy7+26HKw/qkrrIT6wnKpK6yE+sJyqSushPrCcqkrM92itXbwtCc2zjHTS5IcOvH4R4dpSx033PLd7353jsV17awkhy+6EOwW1BVWQn1hudQVVkJ9YbnUFVZCfWG51JUVmuenXmcmuXWSWya5bpKHJ3n7ahQKAAAAgPnNM+Ln6tTPut6b+g9fr0xy/moUCgAAAID5zRP8JMm7hxvzOW7RBWC3oa6wEuoLy6WusBLqC8ulrrAS6gvLpa6s0DwXdwYAAABgHZvnGj8AAAAArGOCn/ltTvKMKdNvmuSkFc7rVUmOnrM80zwhyWOG+6fGFdBZmf2T/O9FF2Kd2ZTkvEUX4lrwfxddAOayKX3WS65pUxazrY9J8rcLWC7ww+3IJO9cxmt+/lovCSvx/CT32clrNmf6sfT+2fHxxxW7VqQfXoKfa8+/5doJcXbF/0vymkUXgmWZ97pb14b9I/hZlLWuD4If6Mt626est/IA/Tgygp9F2JDZmcJzk7x/F+e7fxx/rKrdKfj53SRPHu6/JMkHh/v3TvKdJH85PH5Kks8P938syelJ7pLkzcO0Byf5bupf0O818dqRY4bXvifJZ5O8cOK5+yU5J8m5ST4wMf2nknx8eP3jh2mbMv1s3KYkFyR5Req/oL0vyd5TXndRkj9LsiXJWUnunPoPap9LjeCZ5ookfzKU7xNJbjxM35ztk9RfS/LJJJ9Jco8Z83pOkguTfDTJiRPvv9Mw761J3pLkRkluO8xv8jNumzHfa8Na1o23JjkltX2emOR3knwqtU4OGF53p1xzHSU12urPc811f0yStw/l/sAwn7cO7/9EkjsOr9s39d/zPjks88HD9D2TvDhV37YmedIw/ajhdduG911vmH5RkoOG+4cP5UqqnrxyePz5jNfpC5LcKlUXX5QKER8ysV5OmChLkhw8rKPzkxyf5IsTy/udoZznJXnqxPz/z8T7N2d68r/ebEx99gtSo/v2yfR1fpfUdtkrtQ3PT3L7zN6ex2T7+jDpBUk+PczvxcO0g5OcnOTM4XbEMH1zpm/PpOrX2UNZjp2Y996p7XzCMO1RQ/m2JHl5qq4tNfp8W1L1Y9Tu7ZXkH4d18akkvzBM/0SSn5x4/6n54R2F+NZccztckWrHzk9t/4OH6XfK9HblZ1Jt/rnZ/ns0aVNm73cen6o356bq0T7D9F9Lbctzk3xkYj6npfaD52R2B/u3Um3cJ4dljkaIbErV663DZ7t5kv1SbcSoP7JvkouTXGfGvNeTtdr3/GTG38OtSW49TN8z07fpqUn+KtV3eEqqjnw4Vdfem+SQJD8yPE6qD9NS2yOpfsY+mV4HkuTQYRmfTfK8YdqmbN/neUaqDVpanmcn+ULG2/eGSx6PHDmU+W3D+nhBkkcO62Fbap+UJA9KckaqjXl/xv2eSXskeVmSf0ntm96d8Ym5aW32/ZK8aUlZdjbSYD1ZD/3lv09t7/OT/OHE9Gn7MNtw7Sy6bvxmqi0YefxQjn2TvCvV1pyX5GHD8/dLbfNzkvzqxPum9ZM3pY6PnpZqK5ce3+yT5I2p+veWVJ0b9T0ekao/56X66Rnm9aIln6mn0Y5L++M76ov/bqqfsDXj7/Om1HHia4Z5HJr65cp5qXX5tOF1r8r4u/qA1PY8O8nfZPvv5O2y8+OPaaYd927KNfsaS8uSjEcMHZLax20Zyj+qO/dNHd+fk2pPrj9l+bcalr0tyR9PzHNDxn3ibRnX6dcneeDE+5eW6drVWttdbndtrb1puH9aa+2TrbXrtNaeN9zOHJ47abh/s9baY1trf9Za29ha+/zw/IuH549ord2rtXbikuUcM7x2v9baXq21L7bWDm2tHdxau7i1dsvhdQcMfze31s5tre3dWjtoeM1NW2ubWmvnTfkcm1prV7fW7jQ8fmNr7VHD/Ve11o4e7l/UWvtfw/2XtNa2ttZuMJTj8hnrqLXWHjTcf2Fr7Q8myviM4f6prbW/GO4/oLX2/inzuUtrbcvw+W/QWvvsxPu3DustrbXnt9b+ari/ZWLd/N7EsnurG/86sR2+1Vp7wsQ2eupO1tGsdX9Ma+3LbVynXjqUO621ew/rNq21P23jurJ/a+0zrbV9W9WTk4bPMqqbe7Wqi7cZpr1monwXtaqraa0dPpRrVE8+1lq73vD8vw/rcWldvldr7a3D/f1aa1+YWHZaa3/bWvv94f79WjmotfYzrbVtQ5mv31o7v7X208PtwxPv/3Sr79xa1Z9duW0aPtcRw+NXtqrzs9b5H7eqX383sW5mbc+l9WF0O7C1dmFrbcPEe9Jae11r7e7D/Zu31i7YyfbMxLz3HrbtgcPjKyaW9xOttXdMvOdlrbXHTFkX57XW7jbcf0Eb15WnD+slrbXbtta+1KpePq219ofD9EOGz7To7bmo27Tt0FprjxymP7fV9yltdruytbV2z+H+i9rK9zsHTrzuj1trTxrub2vVVk7WtX2GbZjW2q1ba2dNWdZNW7UxB7SqO6dNfIZ3tGp701r7zTZuR97WWvuF4f7DWmvHr4Nts5zbWu17XtrGdeK6rerLjrbpqa2+rxnK87FW+6zR+h19L89vrd2wtfbEYfmPbK3dorX28Ta7DhzTWru0Vb0Z1dvD2zX3E89o1QYtLU9aa//YWnvIcP/YNt4vTt6ObK19s1Ubcb3W2iVt3G48pY3r/43auE387RnzOrq19u7W2h6ttZu01r4xTJu1n9zYqr3ad5j+9xPrdne4Lbq/nDZu2/Zstf3v2Gbvw2zDH566cf3W2ufauF/xsdbaHVprD22tvWLi/aP3XdxqX7OhVRv3zuH5Wf3kzW18vLL09ozW2suH+7dv1X4e3mqf9aVWbeTG1toHW7VPB7fq84/e/89t3Nfa3W+z+uPT+uL3ba0dN2yDPYZtcM9Wbf4PWtWp0TxPmXj//sPfV7Xtv6ujY8UTJ7bn5ra844+lt9amH/fO6muMyjJ6/6jP+/TW2rOH+3u2Os47qLX2kTZuQ36vVZ9saRne2Vp7xHD/CRPzfOiwPvZsrd24VR07pLX2K621Vw+vue6wTva+lrf3f992pxE/Z6fOWt0wyX+lErjDU6ncKIW7QSpxfF2Sew7PnZbk6tQZrJ9I8rOpRHvy+aU+kORbSa5MJcO3SHLXVBr4heE1X594/dtSyffXknxoWMaOfCGVKo4+16YZr3v78HdbKpn+dpKvpj7//lNe/72M09MdzffNO3nNEanPdOWwzHcM0/cblvvh4fGrU+sxqRR9lGY+LMkbZiz72rCWdeNDGW+Hb2W8bral1uWO1lEye92fknGdunuSfxrufzDJgcNnu2+SZ6Xqzqmpsyw3T/129uXDZ8kwn8NS9ewzM8oxy7tS6/BrSb6S6WfePpw643xw6izJyRPLHpX/9cP99yT5xsT0t6TOKl2RWhf3SJ2p+5HUdbF+anj9xcso66JdnDoLliSvTZ11nLXOn5/kF1P1cnTma9b2TLavDyOjNukfUme+/nOYfp/UWagtqTbjhhmflZi1PZ+c8RmSQzMeQTDpqNT36sxh3kelzvxN2j/13fr48Ph1E8/dPbVekjrD88Ukt0m1FaOzG7+elV8LrSfTtsMPMm4/X5taj7Palf2H22g0xqjdmGbWfuf2qbZuW2pExWg01umpM1GPz3ik13VSI0y2pdrW201Zzs8O5fx6kquy/Vn3u2VcR/5p+GxJfd7R/uPhWdv9xzzWat/z8dTPMH8v1R/57jB9R32J0To8LLWNTxle+wdJfnR47mOp/f09k/zplOVPqwMZ5vXvQznenPF23JHJbXp8kscN9x+XGhk4zZlJLk2t28+lRjUl4/1ths/y3mHa72b70YQjd09tjx8kuSy1H09m7yevTu27HpQa2fnAVJ9od7Ho/nJSbfs5qf37T6bailn7MNtw7Sy6blyR6tf+UurXAtdJbfdtqT7Snw/z+9bw/BdSI4Zaxv2JZHY/eUcm+6ajEfJJjWQ6NdWvvzo14vmew+PPp47/DhzKc3r6MKs/Pq0vft/h9qnUd/q2GfcZv5jqvyS1rn4syUtTI7X+Y8kybzu8ZnQcfeKS55dz/LHUrOPeWX2NWc5M7Ys2J7lD6jjvrql26/TUvvOxGbdvk+6WcT9naR/4xCTfT3J5ql90lyT/nBoBf70k90/1376bNbI7BT9XpSrLManOymmpFffjqSHsH0tttAuH5+6R2hijL+lHUiv4qtRQ0rsPt2mN1X9N3P9+dv6b9LaTx7s6/9HrfrDkPT+Y8Z6rJpa9nPku57Mt1xtSO/rbDGX47CrNdzkWVTcmt8usbTLr/UvX/XeW8d4NSR6a+snHnVIhwQXLeN9SV2f83d9rRvmmlXHSa1I/A3pcamj1vN6UCgPWOjScx9Lv+Td38NoDM+5Qjdb5jrbntPpwdaqzdVKq0/SeYfoeqR3UaD43y3io6bTteWQqLLpbauf+qVyzHozK9+qJ+R6W8U835nFJ6qDxjtm9tvdqOzLL2w47258s16zv9qtSP1u9Q2oI96gMT0iFBIemOlQHpoZuXz6U9/DUMP/V8PZUR/GA1EHJB3f88nVjrfY9r0vyy6nO4btTP8tIdtxej9qQDamf29xpuN0h1YkfLf8eqc7s21LbdXL50+pAMr3PM7lfSa5ZlyfbtNNTHfQjU4HSeUl+LtW53jJ81qWfb9b+9qWp4PsOSf7nlOXuqten+jT3Tv1k6durNN+1sOj+8i1TPxE5KtXOvyu1XWbtw2zDtbPoupFU8HtMtg99P5O6pMXo5zLPneMzrqZRHXpoKihZrf3xejWtL74hdemROw23H0+Ft8n27fo3UvuQU1P7juNXuOyVHnsnyz/uHZncT+2RcR/mI6mw75JUn+gxqc99Ssaf+3apn7HP68rUOvofWUAfeHcKfpJqWJ6R2kCnpSrWp1IbffK50fUk/iuVGo/e+9RUuv3VVAfmsCz/v2J8IlUpbjk8PmDiuQendlQHpjoyZ67wc603p6fOkuyVOlj9pWH6t1Jf7NFvHx+d8Rnoz6W+dM/JYg7kFlk3Ju1oHa3kszxyuH9kKv3+j9QZsSelGqMk+enh7ympztKowTsgtdPelGqgl5bjotTBVVI7s535diqwmPSqjK/R8+klz52e2lEmdYAxuhbJaalrA+2T+j33r2TcWXhD6kz/0dl+hMB6dvNUhyhJfiPVsdyU6ev85anvxgkZ/3581vac5fqpkR/vTh2A/9Qw/X0ZX9cpqR3UjuyXqqP/mToDc9eJ567K+FobH0htjx8ZHh+Qa57t+Gaqfvzc8PjhE89N1uPbpNbXhcPjNyR55lCWrfnhNGs77JHxiKjfSF1nbVa78s3hNjqbNVrfK3GD1KiK6yx5/61SI02fm2oXDx3KfGnqwPvRmX7NpzOT3Cv1vd+Y7duYj2VcRx6Z8ff/iuF9f506e/f9Xfgci7IW+54fS50p/ZtUQHPHFZTvwtTozFFbdZ2MR1SclgrwP5vapl9PXYPho8Pz0+pAUmfmD0hdU+ghqTb/8lRbcWDqTOao3zDLa1KB1ujA74yMO9hvn/6WqfZLddaTOiM7zemperhH6izykcP0He0nP5w6EH18xqMEdieL7BPdMHVA+K3U+r7/MH3WPsw2XFuL7i+fkWpLfiPjUR83Te0LX5u6LsqdUyOFN2V8Pa9HLPkM0/rJ0/qrI5N909ulgsakrht2r9S1KPccljOqQ29JHeM9In3VoVn98Wl98femrs00Gkl+s4z7hZMOSn0/T06dMLjzkucvTO3LNg2PH5ad29H23JFZfY2LMj7++eWM+7u3SO3DXpEKrO6cOu4/IuO2Zd9UX3apT2Tcz1naB35Yqk4dnMoQRtfDfUMq+LxHxgH4mtgdg59DUg3O5anU7LSJ5w5NNVbfTw1P++jEe89I7SxGQ+K3ppLlltr4z9/Jsr+auvjmm1ND8yfDja2pYaefSPJHqf/oNemmqR3dtWHLKs1nsoxnpjpeW1ND0rZl3Og/NtUob0110CbX2xtSncg3rlKZVmKRdWOpHa2j5dicapi2pi5sNuoI/VGqkdqaOoP7R8P045N8aZh+bmpnemWqUXnT8Fl+kPrvbkmd1f/rVFCxnAOsf0/tMM/L+OJql6fODo067U/I+KLjf5gKfM5LXRz0slTjfU4qMPpkap0fn+pYZPg8N0h1/i5dRpnWgwtTF8K7IHWQ+5JMX+ePSQUqr0ttz7ukzkDO2p5LvTv1/bxB6qB4a6r+/s7w/JNToy+2pkK4WRd/H3lP6oD8gqE8n5h47rhhPicM8/qDVLC0NRUwHjK87viML4r4W6md5ZbUjnHUVrwstY/Zlmobjsn4jM5JqR3kItqK9WLWdvhO6qz4eal6Mmo/ZrUrj0vyd6n1PwoRk+Xvd56T+j6enupoj7wo44tdfizVtrxsKMe5qbBq8mzfluHvJamfDX1ymOdFGdeJJw3l3Zo6QHvKxPtH+4/dbQTYWux7fj21Hbakfrb1mhWU73upTvyfp7bblowvyn1Rqs6Mlv/RVJA4+nnutDqQ1LY9eSjvyal9yVVDeT+Zaism69I0J6TazaXD/Vdqc6rNPTt18DdyeMZnnE9O8uVUm/ba1L5o9BOUWfvJ76fa2/tn97wo8CL7ROem9u3/ktrvjUaLzNqHbY5tuJbWQ3/5jal6MWpr7pDxBeyflxr1c2XquOtdqe39lYn3b870fvI7UiHGltRB9WSZXpY6AP/0MP/zU3Xo0tTP7j+UqrtnZ/yzwG+k9tG3yPb/xGZ3N6s/Pq0v/r7U9/jjqW19UqaHMTdLjWTZkvqO/v6S57+b+g9d70mt429n3DeYZdrxx5advCeZ3dd4RSrkOzd1MmTUhzky43brYaljpK+m+q0nDvP5eKrfk1SdGo1MfWqqLduaColGn+ktGR+XfTB1svOy4bn3DeV4f2ofvWY2tNb7qDV20fVTZ2H3STXwx6YaCkiqXmxLpeJLG+7rpToMV6ca1r/PzkehsPsatRVJdZ4OyfYH9KzMFZn+nyN2J6M6sTHV+Xnl8BdGjk6dSX/0Gi1vVCcPTB3sHJFxJ5zdg23Yj3emTpZ9YA2XuWfqZNuVqVFE70+NVlrTA+8fcqPv8IbUCavPpurB7myfVKjVUic0H5Ht/9PxurJa13ehP8elhkLulbrOh9CHkfukft/7kkxP62+eOpuzR2qH+vi1KxoL8MDUmZ2NqQv9HbPQ0rAebE61E3ulzmy9dZGFYd15aWoUxgPWcJnvTF0I/bqp0ZUCg92Pbbj72z8V2p2btQ19kjpA/1Aq/NmQGn0i9Flbj0+NzrpuanTNyxdbnFXxM6lrlG1IjZj9zYWWZieM+AEAAADo1O52jR8AAAAAlknwAwAAANApwQ8AAABApwQ/AAAAAJ0S/AAAAAB0SvADAAAA0Kn/Dxke66596bSbAAAAAElFTkSuQmCC\n"
          },
          "metadata": {
            "needs_background": "dark"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['to_url'].value_counts"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "trR0r4SRZ9pv",
        "outputId": "ea8ea3b3-5135-488a-e481-6c367a1c62f0"
      },
      "execution_count": 33,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "www.shrewsbury-ma.gov    2\n",
              "www.ncbi.nlm.nih.gov     1\n",
              "www.monroecounty.gov     1\n",
              "boxer.senate.gov         1\n",
              "apod.nasa.gov            1\n",
              "www.nasa.gov             1\n",
              "www.nysdot.gov           1\n",
              "oversight.house.gov      1\n",
              "Name: to_url, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "##**Copying `cy` and renaming the column to `city`**"
      ],
      "metadata": {
        "id": "BvY_6j8Zz-Oq"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['city'] = bitly['cy'].copy() #Taking a copy of 'cy' column into a new name 'city'"
      ],
      "metadata": {
        "id": "NQ-0meJ5jPFN"
      },
      "execution_count": 15,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "##**Splitting column `ll` into `Latitude` and `Longitude`**"
      ],
      "metadata": {
        "id": "rfPTwyf70GH-"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['ll'] #Viewing Latitude and Longitude data for a split in next line"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "pw-Q7MF4Ubk4",
        "outputId": "2bd59ade-9d13-4c4c-be90-01332a1c21e0"
      },
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0      [42.576698, -70.954903]\n",
              "1     [40.218102, -111.613297]\n",
              "2        [38.9007, -77.043098]\n",
              "3     [-23.549999, -46.616699]\n",
              "4      [42.286499, -71.714699]\n",
              "5      [42.286499, -71.714699]\n",
              "6         [51.116699, 15.2833]\n",
              "7                          NaN\n",
              "8                          NaN\n",
              "9                          NaN\n",
              "10      [47.5951, -122.332603]\n",
              "11     [38.937599, -77.092796]\n",
              "Name: ll, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['Latitude'] = bitly['ll'].str[0] #Extracting Latitude from 'll'\n",
        "bitly['longitude'] = bitly['ll'].str[1] #Extracting Longitude from 'll'"
      ],
      "metadata": {
        "id": "dpc_LUENS8za"
      },
      "execution_count": 17,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['Latitude'] #Verifying Latitude Output"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "TfE0eZQA6c4-",
        "outputId": "015e5e68-fd93-4d9f-9c57-28291b82e089"
      },
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0     42.576698\n",
              "1     40.218102\n",
              "2     38.900700\n",
              "3    -23.549999\n",
              "4     42.286499\n",
              "5     42.286499\n",
              "6     51.116699\n",
              "7           NaN\n",
              "8           NaN\n",
              "9           NaN\n",
              "10    47.595100\n",
              "11    38.937599\n",
              "Name: Latitude, dtype: float64"
            ]
          },
          "metadata": {},
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['longitude'] #Verifying Longitude Output"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "jT2qt1nWLjDc",
        "outputId": "9d0f4b6e-2258-4d7e-b31b-c56d159a8878"
      },
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0     -70.954903\n",
              "1    -111.613297\n",
              "2     -77.043098\n",
              "3     -46.616699\n",
              "4     -71.714699\n",
              "5     -71.714699\n",
              "6      15.283300\n",
              "7            NaN\n",
              "8            NaN\n",
              "9            NaN\n",
              "10   -122.332603\n",
              "11    -77.092796\n",
              "Name: longitude, dtype: float64"
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "##**Copying `tz` into a new column `time_zone`**"
      ],
      "metadata": {
        "id": "hrCXwQUVOfw-"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['time_zone'] = bitly['tz'].copy() #Taking a copy of 'tz' into a new column 'time_zone'"
      ],
      "metadata": {
        "id": "jwbTWi7GMYDW"
      },
      "execution_count": 20,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "time_zone = bitly['time_zone']\n",
        "plt.figure(figsize=(15,8))\n",
        "sns.barplot(y= time_zone.index, x= time_zone.values)\n",
        "plt.tick_params(axis='x', colors='white')\n",
        "plt.tick_params(axis='y', colors='white')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 484
        },
        "id": "E-duWWsyevzZ",
        "outputId": "84e4920c-f08b-4ee7-9d1e-1f1608001b1f"
      },
      "execution_count": 74,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 1080x576 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAA2cAAAHTCAYAAACjj2AvAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/NK7nSAAAACXBIWXMAAAsTAAALEwEAmpwYAAAcS0lEQVR4nO3de5htZX0f8O8JJyiCoUYoIpocMHhrvKPxiqCIGrWSqlGeajSakKQVsTWiiTZFH9NSTWzUmDSUKJqoUO/E1isGQQUUkHCReEVB4lFR461QQKZ//NZ+Zp9h7zMzZ+9z5jfM5/M865m91l577XfPvOvd73e9a63ZtLCwEAAAANbWz6x1AQAAABDOAAAAWhDOAAAAGhDOAAAAGhDOAAAAGhDOAAAAGti8K99sn332WdiyZcuufEsAAIA2LrjggmsWFhb2nfTcLg1nW7Zsyfnnn78r3xIAAKCNTZs2fX3ac05rBAAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaGAl4exNSb6d5NKxZT+f5KNJvjT8vN38iwYAALBxrCScnZLkcUuWvTTJGUkOHn6+dL7FAgAA2FhWEs7OSvK9JcuenOQtw+O3JDlqjmUCAADYcHb0mrP9knxzeLx1mAcAAGAHbZ7DNhaGaZpjhgkAANaFP3/R3611EWjo+X/6pJ26/R0dOftWkv2Hx/unbhgyzUlJDhkmAAAAJtjRcHZ6kmcPj5+d5P3zKQ4AAMDGtJJw9o4k5yS5W5JvJHlekhOTPCZ1K/0jhnkAAAB20EquOTt6yvJHz7MgAAAAG9mOntYIAADAHAlnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADQhnAAAADcwazv5DksuSXJrkHUluPXOJAAAANqBZwtkBSV6Q5JAkv5xktyTPmEehAAAANppZR842J9lj+HmbJP80c4kAAAA2oM0zvPbqJH+S5Mok1yb5yDCxCxx//PHZunVr7nCHO+TVr371WhcHAACY0SwjZ7dL8uQkBya5Y5I9kzxzwnrHJDl/mJiTrVu35uqrr87WrVvXuigAAMAczBLOjkhyRZLvJLkhyXuSPHTCeielrks7ZIb3AgAAuEWbJZxdmeTBqWvNNiV5dJLL51EoAACAjWaWcHZekncluTDJJcO2TppHoQAAADaaWW4IkiT/eZgAAACYway30gcAAGAOhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGhDMAAIAGZg1n/yLJu5L8Y5LLkzxk1gIBAABsRJtnfP3rknwoyVOT7J7kNjOXCAAAYAOaJZztneTQJM8Z5q8fJgAAAFZplnB2YJLvJHlzkvskuSDJcUl+smS9Y4YJAGAbnzj0kWtdBBp65FmfWOsiwJqY5ZqzzUnun+Qvk9wvFcpeOmG9k5IcMkwAAABMMEs4+8YwnTfMvysV1gAAAFilWcLZ1iRXJbnbMP/oJJ+fuUQAAAAb0Kx3azw2ydtSd2r8apLfnLlEAAAAG9Cs4eyiuJYMAABgZrP+E2oAAADmQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoQDgDAABoYPNaF2C1HvDit651EVq47TU/ym5JrrzmRxv+d3LBa35jrYsAAAAzM3IGAADQgHAGAADQgHAGAADQgHAGAADQgHAGAADQgHAGAADQgHAGAADQgHAGAADQgHAGAADQgHAGAADQgHAGAADQwDzC2W5JPpfkA3PYFgAAwIY0j3B2XJLL57AdAACADWvWcHanJE9IcvIcygIAALBhzRrO/izJ8Ulumr0oAAAAG9cs4eyJSb6d5IJl1jsmyfnDBAAAwASzhLOHJfnXSb6W5NQkj0rytxPWOynJIcMEAADABLOEsz9IXXO2Jckzknw8yTPnUCYAAIANx/85AwAAaGDznLZz5jABAACwA4ycAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANCCcAQAANLB5rQsAwM71sDc8bK2LQEOfOvZTa10EAJYwcgYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANDALOHszkn+Psnnk1yW5Li5lAgAAGAD2jzDa29M8qIkFya5bZILknw0FdYAAABYhVlGzr6ZCmZJ8qMklyc5YOYSAQAAbEDzuuZsS5L7JTlvTtsDAADYUGY5rXFkryTvTvLCJD+c8PwxwwQAAMAUs4azn00Fs7clec+UdU4apiRZmPH9AAAAbpFmOa1xU5K/Tl1r9tr5FAcAAGBjmiWcPSzJs5I8KslFw/SrsxcJAABg45nltMZPpkbPAAAAmNG87tYIAADADIQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABoQzAACABjavdQHYMTftvuc2PwEAgPVNOFunfnLwkWtdBAAAYI6c1ggAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANCAcAYAANDA5rUuANxSXPnKe611EWjoF/7okrUuAgCwThg5AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaEA4AwAAaGDWcPa4JF9I8uUkL529OAAAABvTLOFstyRvTPL4JPdMcvTwEwAAgFWaJZw9KDVi9tUk1yc5NcmT51EoAACAjWaWcHZAkqvG5r8xLAMAAGCVNi0sLOzoa5+auubst4b5ZyX5lSTPX7LeMcOUPfbY427XXXfdF3b0DdnWfvvtt8+3vvWta9a6HLCUuklX6iadqZ90pW7O3S8uLCzsO+mJzTNs9Ookdx6bv9OwbKmThinXXnvtDG/HBOcnOWStCwETqJt0pW7SmfpJV+rmLjLLaY2fTXJwkgOT7J7kGUlOn0ehAAAANppZRs5uTJ3C+OHUnRvflOSyeRQKAABgo5klnCXJ/xkm1sZJa10AmELdpCt1k87UT7pSN3eRWW4IAgAAwJzMcs0ZAAAAcyKcwfp2VJKFJHffSds/JMnrZ3j9M5K8LMlzknwnyeeSfCl1repDZy0cwA76aZKLxqaXrmFZkuSDSZ6d5H1jy/4gyZfH5p8UN16DWzzhbFtHZf10dG9Kcu+x5y5NsmWGbU/y20lOG5v/uSRfSXLQCl//4zmXh5s7Osknh5/ztjl169wXzLCNxyf50PD4tCT3S93l9cQk70lyj1kKuINmvdaWRUdlfbSZ+yX5QJJ/SPL5zP9a6VFH/9Ik70xymx3cjjZz17k2yX3HphNX8dp5tyF7JLl9ql4+eGz5Q5L8MMm/HOYfmuTTK9ymdq6Ho7I+2sjnJPnzeRRogn2S3JDkd3fS9pNbWNspnG1rPXV0v5HaoXamk1P/y+6IYf6VqbtyfnWZ122KurUr7JXk4Umel2pgk+SwJJ9I8v7U3+nEJP82yWeSXJLkLsN6+yZ5d+pfYnw2ycOG5Sck+Zsknxp+Hpbq1I7e783Ddi5O8pRh+V+m6vZlSV4xVr5NqU7PhRPK/vepi4uPGebvkqrbFyQ5O4tfZKekvng+PXyepw7LT03yhLHtnTI8t1uS1wyf6eIkvzP2ezk7ddT58xPKw45ZL23mK5N8NMl9ktwz8x8lGXX0fznJ9dm5nRB2rq+lOpNJdXzPHB6fkG3bxi1JPp5qZ85I8gvDeqck+R+puvvFJE8clk9rm5Jqn85MnV3wwyS/NCw/INVOj84yeOjw/k9Kcl7qTISPpQ4+TCrjv0q1/RcN73nwsN77Um3tZVlsg5+W5LXD4+Oy+D1/0LA9dsx6aSN3pqclOTc753dwi6QDvWi9dXQ/kGp47zbhsxyZ5Jxh3XcO7/XA1EhFkjw51ZnYPcmtMz1sLaQ6GX+W+pJ6dOrL5T+mjhBfmuSFw7pbknwhyVuH5eP/oHyfoTzjnWlm9+RUo/rFJN9N8oBh+X1Sf7d7JHlWkrsmeVAqbB87rPO6JP89VS+eMjw3cs9UIF/akP6nJD9Icq/UqO3Hh+UvS9WPeyd5ZBZHdO+XGqmYdtehC7MYwk4ayvaAJL+f5C/G1ts/tW8+MYtHt09L8uvD491TdfN/p/bfHwyf64Gp0d8Dh/Xun+p03HVKeVid9dRm7p86oDVy8dg2zxjWuSS1T41MaudW4uxU53p7HejfH1t/0lkPm1Jt7aVDuZ6+ivdnZfbItqc1ruR3PN42viHJW1Lt3duy7ejFllSb+4RUULt1tt82jXeQP5UKYXdLnQJ+7jC/OdW2fzbV2X9wqo09NcnxU8r4u6m2/r6pNnq0Dzw31dYekurY3z5Vbx8xPP+I1HfKAcPjs1bwu+Hm1lMbOc2kdnDP1PftPwzLl9t3jk7yolR9utPY8h8n+eNhO+dmsY28yzB/SZJXZdtRsRdn8QDH+GfJMuustsxryrD3ou11dO+R5HupHenkVKN7XKoz+cIsdnQ/mTp69uEsnq51z9TOeW1qJxoZ7+gmye2Gny8b3mu3VKfh3qkKtrSje1OSVyf5w9R56iP7JHl5qnH+SZKXpHau/5LaCZNqbC9NfUFsTnUgprl4+DxnDL+jeyX5zSS/ktqxz0s1NN9PHZV7dmqnGtkvNVrx8tSRa+bn6FTdS+oL+uhUI/3ZJN8cln8lyUeGx5ckOXx4fESqbo78XKphT+rvde2E9zsii18wSf3NkwpJx6Tq0v7Ddi9O8rjUdRTTbBp+7pXqfLxz7LlbjT1+X6q+fz6LjfcHU5/9VsP7nDWU+cjUPjMaYds7VS+vT335XbGd8rA666nNfGMq0D8/FZTenOSfklyX5NdSoxX7pNqu01NBflI797llfiebs9jRHnWgF5L8VqoD/aJlXj/yb1Lt9X2Gcn02Vce/uZ3XsDqj0c7VGG8bH5L6OyXVSX712Hr/K9VmfSm1D9w909umK1Id71Fg/3SqPdwtdVDzM0n+KFWf/zFVZw9O1ef9Uwenxtu18TKek9o/7pQ6OPulYfkLUvU+qQOpB6fq/l5Jbjsse3uSQ1P9hdGBXVZnPbWRkzwgk9vBg1Lt5+iA+97b+R3cOVVPP5PaL56e5E+H5/ZM1buXpfaf306FsdcN0zuy7VkIR6bq6oOG8pyeqqNnrWCdfVdR5jUnnC1ajx3dt6cq9YFjyx48vGZ0GsLuqQb6xqH890hV2temKuxuqSNm2/PGVIfjzFTj8d5U8Euq0X7E8Dm/nm2D2c+mGoJ/n9qhmZ+fT/KoVCO8kPo7LqSODP2/sfVuGpu/KYv7/M+k6sp1E7b9kwnLpjkw1al4YKoOn5I6SpxUI/mUyS9LUl8Mlw9l+edM7yiNf55RoLsuVR8fm2rsTx17/tjUF9m4w7K6z8Xy1lOb+eFUh+Jxqbbsc6lTEP85deDq0NT+cUDqAMDDM7mdmxbORqMwSbWnf50a+ZjWgV7Ow1Mdk58m+Vaq/Xxg3AxiV7gxi2cV3XrJcyttQ5Z2dhcyvW06KMlVqQNISX13H5tq0/9nkh8N5Tgsi9ebvSH1HX76sPyEKWV8e6pD/YTU9Wy/k6rnR6TC5f9NtaOjz/npVGf8C6l6/NxhvZUeVGBb66mNnGRaO/ihVMD6b8Pn2V4f8umpUJbU7+BNWQxn12dx1O+CJI8ZHj8kda1eUnX4T4bHRw7TqB3eKxXEloazSeucvYoyrznhrKzXju6Nqcr2krFlm1IjVJPO7T0r1TG5IXX0+JTUZ33xMuW6aZiWs/Sz3pja4R4b4Wzenpo6Wjt+3cInsnhaynI+kuoAvGaYv28WO5fTfDQVtF84zN8u9YXxk9TRuv2yGOL3Tu0f352yrUemviwOT41aXJE6L/2dqTp879QRve05LTUicUjqYuakOj6/lzrl8obUKYxXL7MdVm89tpnfS33Rvz315XxoapRg39QR4htS1xst7ZCvxKRRmGkd6PHOf3bw/dh5vpaqDx/M9g8ufTrVEf6b1Glp4529p6VOeTwwFb6+kOlt09Jrfi5PcsdUx/jfDcsuSo0gjE5f3DuL7dr4mTNLHZQamXl9avTl3qm29vupYHb3bHsDkrNT12e+MtW5PTxVt3+wnfdgsvXYRq7UF1NnF/xqaqTrjFSdmeToJHdI7SNJ1e2DU6O4N2TxQMZPs3wm2ZTkvyb5qx1cZ6VlXnOuOSujju4vps4Vv3OqAVttR3fkvit4zaijOzKto5tsv6N7Supoyb7D/LmpUyRGFxTvmcVrbM5OdazPSV14fPvU0d1LV1DekbNTRzRuM2z71zL9CMRC6sjb3bNtgGR2R6eOaI17d1Z+we0LUqHm4tTpgiu5gcGrUvX00lRwOnz4+bnU6TZvz+KI7WNSBwDGPT3Vyfhi6nTcp6Q6Ikk13M8btndZtr32Z5qPpELex7J41Pnk4fNcOJTzr+Ig1M6w3trMR2XxDoq3TV3TcOWw3rdTnYTDh8+TrK6dm2ZaB/prqU5Chp/jZz6MnJ3aX3ZLte2Hpk4LYn6WXnM2up71FanRjvNTHcZpjk2NMl2curb3uLHnrkz9vT6Yaluvy/S26XHZNpwtpEa7vpuql0l9Zx+UxZGzE1IHsi5Ics12yvjrw3tdlBopfuvwXptTbe+J2fZsl7NT+/JZw2e/KnVaHau33trISaa1g3dMhfu/TR3gvf+U1981NXJ1QOp3sCUVnJbrp5ybxdA4PhL44VSfcjSCeEAW72S63DorLXMLOi3l6NRQ57h3p45yfWUFr39B6tS/i1O/07OyfGf3VcNrLk01gq9IDRmPOrpXZfsd3ZHrU0fFRkPn30mNIrwji9ftvDzVIT4vtXOOhoAvTh3RmHa+8SQXpgLhqKNw8lDmLVPW/2nq93t66vSMv5iyHqtz+IRlr8/Nb6l72NjjM7N457FrMvmC2BOWzI+/5seZfJT2OROWnZxtbzJyyjBNc0Wqk7Lctvcae3xD6ujkuJtSwe8Plyw/M4ufg9mttzbzAanbRI9GrU5OnVp0RZK/S51OdP6wnWR6O7caJ6Q60N9PjZaMQti7k/xG6iDEeam2ean3pk7tGV0PcnySrat8f7ZvtynLz87kmwadsGT+66nQP8nHcvP6PKltulXqNLOvLVl36c2zTsm27ef7h2m5Mp6Yyf8i4PETliW1724amz9yynosb721kUl93x41Nv/gTG4HH5sKODelvod/b0p5ph1EPi3bH7V6YSpEvSx1MGE0cvuR1KU55wzzP07yzNQBtiyzzi+tsMwtbFpYWE2/nDUy6uieu9yKAGgzWTOnpE6bfdcalwO2p3MbeZvU6bQLqZGzo7Oys2luMYQzAACgg0ekznTYlLpp03OTfHktC7SrCWeMvDGL/0dj5HWpW04DbHS3T11EvtSjs/3rNgBu6d6bm18/+5Lc/O6krIBwBgAA0IC7NQIAADQgnAEAADQgnAEAADQgnAEAADQgnAEAADTw/wEJJdZ+c510ygAAAABJRU5ErkJggg==\n"
          },
          "metadata": {
            "needs_background": "dark"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "sns.barplot()"
      ],
      "metadata": {
        "id": "dY_WMH-Ke-xz"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "##**Converting `t` and `hc` to new columns yet in a `timestamp` format**\n"
      ],
      "metadata": {
        "id": "0U30YlqhLifL"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['time_in'] = bitly['t'].apply(datetime.fromtimestamp) #Converting 'int' into 'datetime'"
      ],
      "metadata": {
        "id": "5feIY9ShM6B2"
      },
      "execution_count": 21,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "bitly['time_out'] = bitly['hc'].apply(datetime.fromtimestamp) #Converting 'int' into 'datetime'"
      ],
      "metadata": {
        "id": "NJmmA2zt1HsG"
      },
      "execution_count": 22,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "###**Dropping unnecessary columns**"
      ],
      "metadata": {
        "id": "SRhbcEZJPTpQ"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "bitly.drop(['a','c','nk','tz','gr','g','h','l','al','hh','r','u','t','hc','cy','ll'], axis = 1, inplace=True)"
      ],
      "metadata": {
        "id": "U_KFrpNLLO1N"
      },
      "execution_count": 23,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "bitly.dropna(inplace= True) #Handling null values"
      ],
      "metadata": {
        "id": "UCLQBT32QOM2"
      },
      "execution_count": 24,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "bitly #Validating the final result"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 332
        },
        "id": "bBt6LjXBQxTB",
        "outputId": "574b1030-24e8-4002-e75f-0d7566060b3b"
      },
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   web_browser operating_sys               from_url                 to_url  \\\n",
              "0      Mozilla       Windows       www.facebook.com   www.ncbi.nlm.nih.gov   \n",
              "1   GoogleMaps    GoogleMaps       www.AwareMap.com   www.monroecounty.gov   \n",
              "2      Mozilla       Windows                   t.co       boxer.senate.gov   \n",
              "3      Mozilla     Macintosh                 direct          apod.nasa.gov   \n",
              "4      Mozilla       Windows  www.shrewsbury-ma.gov  www.shrewsbury-ma.gov   \n",
              "5      Mozilla       Windows  www.shrewsbury-ma.gov  www.shrewsbury-ma.gov   \n",
              "6      Mozilla       Windows    plus.url.google.com           www.nasa.gov   \n",
              "10     Mozilla       Windows                 direct         www.nysdot.gov   \n",
              "11     Mozilla     Macintosh                   t.co    oversight.house.gov   \n",
              "\n",
              "          city   Latitude   longitude            time_zone  \\\n",
              "0      Danvers  42.576698  -70.954903     America/New_York   \n",
              "1        Provo  40.218102 -111.613297       America/Denver   \n",
              "2   Washington  38.900700  -77.043098     America/New_York   \n",
              "3         Braz -23.549999  -46.616699    America/Sao_Paulo   \n",
              "4   Shrewsbury  42.286499  -71.714699     America/New_York   \n",
              "5   Shrewsbury  42.286499  -71.714699     America/New_York   \n",
              "6        Luban  51.116699   15.283300        Europe/Warsaw   \n",
              "10     Seattle  47.595100 -122.332603  America/Los_Angeles   \n",
              "11  Washington  38.937599  -77.092796     America/New_York   \n",
              "\n",
              "               time_in             time_out  \n",
              "0  2012-04-01 19:03:50  2012-04-01 19:03:57  \n",
              "1  2012-03-16 18:40:49  2011-06-16 22:13:13  \n",
              "2  2012-04-02 22:50:30  2012-04-02 22:50:35  \n",
              "3  2012-04-04 02:37:10  2012-04-04 02:37:24  \n",
              "4  2012-04-05 06:23:50  2012-04-05 06:23:59  \n",
              "5  2012-04-06 10:10:30  2012-04-06 10:10:48  \n",
              "6  2012-04-07 13:57:10  2012-04-07 13:57:20  \n",
              "10 2012-04-11 01:17:10  2012-04-11 01:17:20  \n",
              "11 2012-04-12 05:04:00  2012-04-12 05:04:03  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-9598756e-c41e-4fbe-abcd-6ed1a6837a21\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>web_browser</th>\n",
              "      <th>operating_sys</th>\n",
              "      <th>from_url</th>\n",
              "      <th>to_url</th>\n",
              "      <th>city</th>\n",
              "      <th>Latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>time_zone</th>\n",
              "      <th>time_in</th>\n",
              "      <th>time_out</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Mozilla</td>\n",
              "      <td>Windows</td>\n",
              "      <td>www.facebook.com</td>\n",
              "      <td>www.ncbi.nlm.nih.gov</td>\n",
              "      <td>Danvers</td>\n",
              "      <td>42.576698</td>\n",
              "      <td>-70.954903</td>\n",
              "      <td>America/New_York</td>\n",
              "      <td>2012-04-01 19:03:50</td>\n",
              "      <td>2012-04-01 19:03:57</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>GoogleMaps</td>\n",
              "      <td>GoogleMaps</td>\n",
              "      <td>www.AwareMap.com</td>\n",
              "      <td>www.monroecounty.gov</td>\n",
              "      <td>Provo</td>\n",
              "      <td>40.218102</td>\n",
              "      <td>-111.613297</td>\n",
              "      <td>America/Denver</td>\n",
              "      <td>2012-03-16 18:40:49</td>\n",
              "      <td>2011-06-16 22:13:13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Mozilla</td>\n",
              "      <td>Windows</td>\n",
              "      <td>t.co</td>\n",
              "      <td>boxer.senate.gov</td>\n",
              "      <td>Washington</td>\n",
              "      <td>38.900700</td>\n",
              "      <td>-77.043098</td>\n",
              "      <td>America/New_York</td>\n",
              "      <td>2012-04-02 22:50:30</td>\n",
              "      <td>2012-04-02 22:50:35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Mozilla</td>\n",
              "      <td>Macintosh</td>\n",
              "      <td>direct</td>\n",
              "      <td>apod.nasa.gov</td>\n",
              "      <td>Braz</td>\n",
              "      <td>-23.549999</td>\n",
              "      <td>-46.616699</td>\n",
              "      <td>America/Sao_Paulo</td>\n",
              "      <td>2012-04-04 02:37:10</td>\n",
              "      <td>2012-04-04 02:37:24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Mozilla</td>\n",
              "      <td>Windows</td>\n",
              "      <td>www.shrewsbury-ma.gov</td>\n",
              "      <td>www.shrewsbury-ma.gov</td>\n",
              "      <td>Shrewsbury</td>\n",
              "      <td>42.286499</td>\n",
              "      <td>-71.714699</td>\n",
              "      <td>America/New_York</td>\n",
              "      <td>2012-04-05 06:23:50</td>\n",
              "      <td>2012-04-05 06:23:59</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Mozilla</td>\n",
              "      <td>Windows</td>\n",
              "      <td>www.shrewsbury-ma.gov</td>\n",
              "      <td>www.shrewsbury-ma.gov</td>\n",
              "      <td>Shrewsbury</td>\n",
              "      <td>42.286499</td>\n",
              "      <td>-71.714699</td>\n",
              "      <td>America/New_York</td>\n",
              "      <td>2012-04-06 10:10:30</td>\n",
              "      <td>2012-04-06 10:10:48</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Mozilla</td>\n",
              "      <td>Windows</td>\n",
              "      <td>plus.url.google.com</td>\n",
              "      <td>www.nasa.gov</td>\n",
              "      <td>Luban</td>\n",
              "      <td>51.116699</td>\n",
              "      <td>15.283300</td>\n",
              "      <td>Europe/Warsaw</td>\n",
              "      <td>2012-04-07 13:57:10</td>\n",
              "      <td>2012-04-07 13:57:20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Mozilla</td>\n",
              "      <td>Windows</td>\n",
              "      <td>direct</td>\n",
              "      <td>www.nysdot.gov</td>\n",
              "      <td>Seattle</td>\n",
              "      <td>47.595100</td>\n",
              "      <td>-122.332603</td>\n",
              "      <td>America/Los_Angeles</td>\n",
              "      <td>2012-04-11 01:17:10</td>\n",
              "      <td>2012-04-11 01:17:20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Mozilla</td>\n",
              "      <td>Macintosh</td>\n",
              "      <td>t.co</td>\n",
              "      <td>oversight.house.gov</td>\n",
              "      <td>Washington</td>\n",
              "      <td>38.937599</td>\n",
              "      <td>-77.092796</td>\n",
              "      <td>America/New_York</td>\n",
              "      <td>2012-04-12 05:04:00</td>\n",
              "      <td>2012-04-12 05:04:03</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-9598756e-c41e-4fbe-abcd-6ed1a6837a21')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-9598756e-c41e-4fbe-abcd-6ed1a6837a21 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-9598756e-c41e-4fbe-abcd-6ed1a6837a21');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "###**Exporting `DataFrame` as `CSV`**"
      ],
      "metadata": {
        "id": "NtDkBB5SRPu1"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "bitly.to_csv('bitly_data_transformation.csv')"
      ],
      "metadata": {
        "id": "iR202AZvQ6xR"
      },
      "execution_count": 26,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "\n",
        "\n",
        "---\n",
        "\n",
        "\n",
        "\n",
        "#🔗**Get In Touch**\n",
        "\n",
        "### [**Email**](mailto:mustafaa7med@gmail.com)\n",
        "### [**Linkedin**](https://www.linkedin.com/in/mustafaa7med)"
      ],
      "metadata": {
        "id": "2R_Gc9G1a3-v"
      }
    }
  ]
}