-
Notifications
You must be signed in to change notification settings - Fork 0
ricecooker/ca-license-plates
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
{
"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
}
About
No description, website, or topics provided.
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published