license_plates.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = 'https://github.com/veltman/ca-license-plates/blob/master/applications.csv?raw=true'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>plate</th>\n",
       "      <th>review_reason_code</th>\n",
       "      <th>customer_meaning</th>\n",
       "      <th>reviewer_comments</th>\n",
       "      <th>status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AZIZ714</td>\n",
       "      <td>2</td>\n",
       "      <td>LAST NAME</td>\n",
       "      <td>714 AREA CODE</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BATBOX1</td>\n",
       "      <td>1</td>\n",
       "      <td>BATMOBILE (BATMAN) PLUS SHAPE OF VEHICLE (SCIO...</td>\n",
       "      <td>BOX</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BBOMBS</td>\n",
       "      <td>2</td>\n",
       "      <td>NO MICRO AVAILABLE</td>\n",
       "      <td>BOMBS</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BEACHY1</td>\n",
       "      <td>4</td>\n",
       "      <td>LOVE THE BEACH</td>\n",
       "      <td>BEACHY LOOKS LIKE BITCHY 1</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BLK PWR5</td>\n",
       "      <td>2</td>\n",
       "      <td>STRENGTH OF FAMILY</td>\n",
       "      <td>BLACK POWER</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23458</th>\n",
       "      <td>4KTMGAL</td>\n",
       "      <td>1</td>\n",
       "      <td>TO TRAILER MY KTM BIKE</td>\n",
       "      <td>FORKED(FUCKED) MY GAL. SHE DOES HAVE A KTM M/C...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23459</th>\n",
       "      <td>88 CAP</td>\n",
       "      <td>2</td>\n",
       "      <td>88 CAPITAL</td>\n",
       "      <td>88=HATE SYMBOL, NO 88 CAR ON ANI</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23460</th>\n",
       "      <td>BLNT 4C</td>\n",
       "      <td>2</td>\n",
       "      <td>MY LAST NAME, BLUNT</td>\n",
       "      <td>BLUNT FORCE (TRAUMA) KILLS PEOPLE, HIS LAST NA...</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23461</th>\n",
       "      <td>VIBRATR</td>\n",
       "      <td>1</td>\n",
       "      <td>VIBRATOR, IT IS FOR A HARLEY DAVIDSON WITH RUB...</td>\n",
       "      <td>VIBRATOR, SEXUAL CONNOTATION</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23462</th>\n",
       "      <td>666KIDD</td>\n",
       "      <td>2</td>\n",
       "      <td>MY CHILDHOOD NICKNAME IS KID. I WANTED TO MAKE...</td>\n",
       "      <td>666 MARK OF THE BEAST</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23463 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          plate review_reason_code  \\\n",
       "0       AZIZ714                  2   \n",
       "1       BATBOX1                  1   \n",
       "2        BBOMBS                  2   \n",
       "3       BEACHY1                  4   \n",
       "4      BLK PWR5                  2   \n",
       "...         ...                ...   \n",
       "23458   4KTMGAL                  1   \n",
       "23459    88 CAP                  2   \n",
       "23460   BLNT 4C                  2   \n",
       "23461   VIBRATR                  1   \n",
       "23462   666KIDD                  2   \n",
       "\n",
       "                                        customer_meaning  \\\n",
       "0                                              LAST NAME   \n",
       "1      BATMOBILE (BATMAN) PLUS SHAPE OF VEHICLE (SCIO...   \n",
       "2                                     NO MICRO AVAILABLE   \n",
       "3                                         LOVE THE BEACH   \n",
       "4                                     STRENGTH OF FAMILY   \n",
       "...                                                  ...   \n",
       "23458                             TO TRAILER MY KTM BIKE   \n",
       "23459                                         88 CAPITAL   \n",
       "23460                                MY LAST NAME, BLUNT   \n",
       "23461  VIBRATOR, IT IS FOR A HARLEY DAVIDSON WITH RUB...   \n",
       "23462  MY CHILDHOOD NICKNAME IS KID. I WANTED TO MAKE...   \n",
       "\n",
       "                                       reviewer_comments status  \n",
       "0                                          714 AREA CODE      N  \n",
       "1                                                    BOX      N  \n",
       "2                                                  BOMBS      N  \n",
       "3                             BEACHY LOOKS LIKE BITCHY 1      N  \n",
       "4                                            BLACK POWER      N  \n",
       "...                                                  ...    ...  \n",
       "23458  FORKED(FUCKED) MY GAL. SHE DOES HAVE A KTM M/C...      Y  \n",
       "23459                   88=HATE SYMBOL, NO 88 CAR ON ANI      N  \n",
       "23460  BLUNT FORCE (TRAUMA) KILLS PEOPLE, HIS LAST NA...      N  \n",
       "23461                       VIBRATOR, SEXUAL CONNOTATION      N  \n",
       "23462                              666 MARK OF THE BEAST      Y  \n",
       "\n",
       "[23463 rows x 5 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  },
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}