feature_engineering.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# data analysis and wrangling\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import random as rnd\n",
    "\n",
    "# visualization\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "\n",
    "# machine learning\n",
    "from sklearn.linear_model import LogisticRegression\n",
    "from sklearn.svm import SVC, LinearSVC\n",
    "from sklearn.ensemble import RandomForestClassifier\n",
    "from sklearn.neighbors import KNeighborsClassifier\n",
    "from sklearn.naive_bayes import GaussianNB # Gaussian Naive Bays\n",
    "from sklearn.linear_model import Perceptron\n",
    "from sklearn.linear_model import SGDClassifier #stochastic gradient descent\n",
    "from sklearn.tree import DecisionTreeClassifier"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = pd.read_csv('data/input_data.csv', encoding = \"ISO-8859-1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Founding Time</th>\n",
       "      <th>Previous startups?</th>\n",
       "      <th>Consulting before start-up</th>\n",
       "      <th>Undergraduate College</th>\n",
       "      <th>Standardized University</th>\n",
       "      <th>Education (Type of degree/major)</th>\n",
       "      <th>Standardized Major</th>\n",
       "      <th>Degree Type</th>\n",
       "      <th>...</th>\n",
       "      <th>Standardized Graduate Institution</th>\n",
       "      <th>Graduate Studies</th>\n",
       "      <th>Standardized Graduate Studies</th>\n",
       "      <th>Graduate Diploma</th>\n",
       "      <th>Ever served as TA/Teacher/Professor/Mentor?</th>\n",
       "      <th># Years of employment (non-founder)</th>\n",
       "      <th>Worked as product manager/director/head/VP?</th>\n",
       "      <th>Worked at Google?</th>\n",
       "      <th>Worked at Microsoft?</th>\n",
       "      <th>Worked in Sales?</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chad Hurley</td>\n",
       "      <td>YouTube</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Indiana University of Pennsylvania</td>\n",
       "      <td>Indiana University of Pennsylvania</td>\n",
       "      <td>Fine Art</td>\n",
       "      <td>Design</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gwyneth Paltrow</td>\n",
       "      <td>Goop Inc.</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jason Calacanis</td>\n",
       "      <td>Inside.com</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>Psychology</td>\n",
       "      <td>Psychology</td>\n",
       "      <td>BA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tony Fadell</td>\n",
       "      <td>Nest Labs</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Michigan</td>\n",
       "      <td>University of Michigan</td>\n",
       "      <td>Computer Engineering</td>\n",
       "      <td>Computer Science</td>\n",
       "      <td>BS</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matt Mullenweg</td>\n",
       "      <td>Automattic</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Full Name Primary Company  Founding Time  Previous startups?  \\\n",
       "0      Chad Hurley         YouTube         2005.0                 0.0   \n",
       "1  Gwyneth Paltrow       Goop Inc.         2008.0                 0.0   \n",
       "2  Jason Calacanis      Inside.com         2007.0                 3.0   \n",
       "3      Tony Fadell       Nest Labs         2010.0                 1.0   \n",
       "4   Matt Mullenweg      Automattic         2005.0                 1.0   \n",
       "\n",
       "   Consulting before start-up               Undergraduate College  \\\n",
       "0                         0.0  Indiana University of Pennsylvania   \n",
       "1                         0.0                                 NaN   \n",
       "2                         0.0                  Fordham University   \n",
       "3                         0.0              University of Michigan   \n",
       "4                         0.0               University of Houston   \n",
       "\n",
       "              Standardized University Education (Type of degree/major)  \\\n",
       "0  Indiana University of Pennsylvania                         Fine Art   \n",
       "1                                 NaN                              NaN   \n",
       "2                  Fordham University                       Psychology   \n",
       "3              University of Michigan             Computer Engineering   \n",
       "4               University of Houston                              NaN   \n",
       "\n",
       "  Standardized Major Degree Type        ...         \\\n",
       "0             Design         NaN        ...          \n",
       "1                NaN         NaN        ...          \n",
       "2         Psychology          BA        ...          \n",
       "3   Computer Science          BS        ...          \n",
       "4                NaN         NaN        ...          \n",
       "\n",
       "   Standardized Graduate Institution Graduate Studies  \\\n",
       "0                                NaN              NaN   \n",
       "1                                NaN              NaN   \n",
       "2                                NaN              NaN   \n",
       "3                                NaN              NaN   \n",
       "4                                NaN              NaN   \n",
       "\n",
       "  Standardized Graduate Studies Graduate Diploma  \\\n",
       "0                           NaN              NaN   \n",
       "1                           NaN              NaN   \n",
       "2                           NaN              NaN   \n",
       "3                           NaN              NaN   \n",
       "4                           NaN              NaN   \n",
       "\n",
       "  Ever served as TA/Teacher/Professor/Mentor?  \\\n",
       "0                                         0.0   \n",
       "1                                         0.0   \n",
       "2                                         0.0   \n",
       "3                                         0.0   \n",
       "4                                         0.0   \n",
       "\n",
       "  # Years of employment (non-founder)  \\\n",
       "0                                 4.0   \n",
       "1                                12.0   \n",
       "2                                 4.0   \n",
       "3                                18.0   \n",
       "4                                15.0   \n",
       "\n",
       "   Worked as product manager/director/head/VP?  Worked at Google?  \\\n",
       "0                                          1.0                1.0   \n",
       "1                                          1.0                0.0   \n",
       "2                                          1.0                0.0   \n",
       "3                                          1.0                0.0   \n",
       "4                                          1.0                0.0   \n",
       "\n",
       "   Worked at Microsoft?  Worked in Sales?  \n",
       "0                   0.0               0.0  \n",
       "1                   0.0               0.0  \n",
       "2                   0.0               0.0  \n",
       "3                   0.0               0.0  \n",
       "4                   0.0               0.0  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Full Name', 'Primary Company', 'Founding Time', 'Previous startups?',\n",
       "       'Consulting before start-up', 'Undergraduate College',\n",
       "       'Standardized University', 'Education (Type of degree/major)',\n",
       "       'Standardized Major', 'Degree Type', 'Graduate Degree Time',\n",
       "       'Graduate Institution', 'Standardized Graduate Institution',\n",
       "       'Graduate Studies', 'Standardized Graduate Studies', 'Graduate Diploma',\n",
       "       'Ever served as TA/Teacher/Professor/Mentor?',\n",
       "       '# Years of employment (non-founder)',\n",
       "       'Worked as product manager/director/head/VP?', 'Worked at Google?',\n",
       "       'Worked at Microsoft?', 'Worked in Sales?'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#create Ivy Leage column\n",
    "def ivy_league(row):\n",
    "    ivies = ['Harvard University', 'Yale University', 'Princeton University', 'Columbia University', 'Cornell University', 'Dartmouth College', 'Brown University' ]\n",
    "    if row['Standardized University'] in ivies:\n",
    "        return 1\n",
    "    return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def stanford_berkeley(row):\n",
    "    colleges = ['Stanford University','University of California Berkeley']\n",
    "    if row['Standardized University'] in colleges:\n",
    "        return 1\n",
    "    return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Full Name                                                                       Craig H. Misrach\n",
       "Primary Company                                                                 Freedom Meditech\n",
       "Founding Time                                                                               2006\n",
       "Previous startups?                                                                             0\n",
       "Consulting before start-up                                                                     1\n",
       "Undergraduate College                                             Indiana University Bloomington\n",
       "Standardized University                                           Indiana University Bloomington\n",
       "Education (Type of degree/major)                                            Accounting & Finance\n",
       "Standardized Major                                                                      Business\n",
       "Degree Type                                                                                   BS\n",
       "Graduate Degree Time                                                                        2004\n",
       "Graduate Institution                           University of Virginia - Darden Graduate Schoo...\n",
       "Standardized Graduate Institution                                                            NaN\n",
       "Graduate Studies                                                                        Business\n",
       "Standardized Graduate Studies                                                           Business\n",
       "Graduate Diploma                                                                             MBA\n",
       "Ever served as TA/Teacher/Professor/Mentor?                                                    0\n",
       "# Years of employment (non-founder)                                                            5\n",
       "Worked as product manager/director/head/VP?                                                    0\n",
       "Worked at Google?                                                                              0\n",
       "Worked at Microsoft?                                                                           0\n",
       "Worked in Sales?                                                                               0\n",
       "Name: 675, dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[675]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = df.drop(df.index[676:])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Founding Time</th>\n",
       "      <th>Previous startups?</th>\n",
       "      <th>Consulting before start-up</th>\n",
       "      <th>Undergraduate College</th>\n",
       "      <th>Standardized University</th>\n",
       "      <th>Education (Type of degree/major)</th>\n",
       "      <th>Standardized Major</th>\n",
       "      <th>Degree Type</th>\n",
       "      <th>...</th>\n",
       "      <th>Standardized Graduate Institution</th>\n",
       "      <th>Graduate Studies</th>\n",
       "      <th>Standardized Graduate Studies</th>\n",
       "      <th>Graduate Diploma</th>\n",
       "      <th>Ever served as TA/Teacher/Professor/Mentor?</th>\n",
       "      <th># Years of employment (non-founder)</th>\n",
       "      <th>Worked as product manager/director/head/VP?</th>\n",
       "      <th>Worked at Google?</th>\n",
       "      <th>Worked at Microsoft?</th>\n",
       "      <th>Worked in Sales?</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>671</th>\n",
       "      <td>Prat Moghe</td>\n",
       "      <td>Cazena</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of California, Los Angeles</td>\n",
       "      <td>University of California Los Angeles</td>\n",
       "      <td>Electrical Engineering</td>\n",
       "      <td>Electrical Engineering</td>\n",
       "      <td>PhD</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>672</th>\n",
       "      <td>Brian Spector</td>\n",
       "      <td>CertiVox</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Arizona State University</td>\n",
       "      <td>Arizona State University</td>\n",
       "      <td>Political Science and Government</td>\n",
       "      <td>Political Science</td>\n",
       "      <td>BS</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>Nish Kukadia</td>\n",
       "      <td>SecretSales</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>The University of Manchester</td>\n",
       "      <td>University of Manchester</td>\n",
       "      <td>Management &amp; Marketing</td>\n",
       "      <td>Business</td>\n",
       "      <td>BS</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Finance</td>\n",
       "      <td>Business</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>674</th>\n",
       "      <td>Jesse Rothstein</td>\n",
       "      <td>ExtraHop Networks</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Rice University</td>\n",
       "      <td>Rice University</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>675</th>\n",
       "      <td>Craig H. Misrach</td>\n",
       "      <td>Freedom Meditech</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Indiana University Bloomington</td>\n",
       "      <td>Indiana University Bloomington</td>\n",
       "      <td>Accounting &amp; Finance</td>\n",
       "      <td>Business</td>\n",
       "      <td>BS</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Business</td>\n",
       "      <td>Business</td>\n",
       "      <td>MBA</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Full Name    Primary Company  Founding Time  Previous startups?  \\\n",
       "671        Prat Moghe             Cazena         2013.0                 2.0   \n",
       "672     Brian Spector           CertiVox         2009.0                 0.0   \n",
       "673      Nish Kukadia        SecretSales         2007.0                 0.0   \n",
       "674   Jesse Rothstein  ExtraHop Networks         2007.0                 0.0   \n",
       "675  Craig H. Misrach   Freedom Meditech         2006.0                 0.0   \n",
       "\n",
       "     Consulting before start-up                  Undergraduate College  \\\n",
       "671                         0.0  University of California, Los Angeles   \n",
       "672                         0.0               Arizona State University   \n",
       "673                         0.0           The University of Manchester   \n",
       "674                         0.0                        Rice University   \n",
       "675                         1.0         Indiana University Bloomington   \n",
       "\n",
       "                  Standardized University  Education (Type of degree/major)  \\\n",
       "671  University of California Los Angeles            Electrical Engineering   \n",
       "672              Arizona State University  Political Science and Government   \n",
       "673              University of Manchester            Management & Marketing   \n",
       "674                       Rice University                               NaN   \n",
       "675        Indiana University Bloomington              Accounting & Finance   \n",
       "\n",
       "         Standardized Major Degree Type        ...         \\\n",
       "671  Electrical Engineering         PhD        ...          \n",
       "672       Political Science          BS        ...          \n",
       "673                Business          BS        ...          \n",
       "674                     NaN         NaN        ...          \n",
       "675                Business          BS        ...          \n",
       "\n",
       "     Standardized Graduate Institution Graduate Studies  \\\n",
       "671                                NaN              NaN   \n",
       "672                                NaN              NaN   \n",
       "673                                NaN          Finance   \n",
       "674                                NaN              NaN   \n",
       "675                                NaN         Business   \n",
       "\n",
       "    Standardized Graduate Studies Graduate Diploma  \\\n",
       "671                           NaN              NaN   \n",
       "672                           NaN              NaN   \n",
       "673                      Business              NaN   \n",
       "674                           NaN              NaN   \n",
       "675                      Business              MBA   \n",
       "\n",
       "    Ever served as TA/Teacher/Professor/Mentor?  \\\n",
       "671                                         0.0   \n",
       "672                                         0.0   \n",
       "673                                         0.0   \n",
       "674                                         0.0   \n",
       "675                                         0.0   \n",
       "\n",
       "    # Years of employment (non-founder)  \\\n",
       "671                                 7.0   \n",
       "672                                14.0   \n",
       "673                                 3.0   \n",
       "674                                10.0   \n",
       "675                                 5.0   \n",
       "\n",
       "     Worked as product manager/director/head/VP?  Worked at Google?  \\\n",
       "671                                          1.0                0.0   \n",
       "672                                          0.0                0.0   \n",
       "673                                          0.0                0.0   \n",
       "674                                          0.0                0.0   \n",
       "675                                          0.0                0.0   \n",
       "\n",
       "     Worked at Microsoft?  Worked in Sales?  \n",
       "671                   0.0               0.0  \n",
       "672                   0.0               1.0  \n",
       "673                   0.0               0.0  \n",
       "674                   0.0               0.0  \n",
       "675                   0.0               0.0  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Founding Time</th>\n",
       "      <th>Previous startups?</th>\n",
       "      <th>Consulting before start-up</th>\n",
       "      <th>Undergraduate College</th>\n",
       "      <th>Standardized University</th>\n",
       "      <th>Education (Type of degree/major)</th>\n",
       "      <th>Standardized Major</th>\n",
       "      <th>Degree Type</th>\n",
       "      <th>...</th>\n",
       "      <th>Graduate Studies</th>\n",
       "      <th>Standardized Graduate Studies</th>\n",
       "      <th>Graduate Diploma</th>\n",
       "      <th>Ever served as TA/Teacher/Professor/Mentor?</th>\n",
       "      <th># Years of employment (non-founder)</th>\n",
       "      <th>Worked as product manager/director/head/VP?</th>\n",
       "      <th>Worked at Google?</th>\n",
       "      <th>Worked at Microsoft?</th>\n",
       "      <th>Worked in Sales?</th>\n",
       "      <th>Stanford or Berkeley</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chad Hurley</td>\n",
       "      <td>YouTube</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Indiana University of Pennsylvania</td>\n",
       "      <td>Indiana University of Pennsylvania</td>\n",
       "      <td>Fine Art</td>\n",
       "      <td>Design</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gwyneth Paltrow</td>\n",
       "      <td>Goop Inc.</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jason Calacanis</td>\n",
       "      <td>Inside.com</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>Psychology</td>\n",
       "      <td>Psychology</td>\n",
       "      <td>BA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tony Fadell</td>\n",
       "      <td>Nest Labs</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Michigan</td>\n",
       "      <td>University of Michigan</td>\n",
       "      <td>Computer Engineering</td>\n",
       "      <td>Computer Science</td>\n",
       "      <td>BS</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matt Mullenweg</td>\n",
       "      <td>Automattic</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Full Name Primary Company  Founding Time  Previous startups?  \\\n",
       "0      Chad Hurley         YouTube         2005.0                 0.0   \n",
       "1  Gwyneth Paltrow       Goop Inc.         2008.0                 0.0   \n",
       "2  Jason Calacanis      Inside.com         2007.0                 3.0   \n",
       "3      Tony Fadell       Nest Labs         2010.0                 1.0   \n",
       "4   Matt Mullenweg      Automattic         2005.0                 1.0   \n",
       "\n",
       "   Consulting before start-up               Undergraduate College  \\\n",
       "0                         0.0  Indiana University of Pennsylvania   \n",
       "1                         0.0                                 NaN   \n",
       "2                         0.0                  Fordham University   \n",
       "3                         0.0              University of Michigan   \n",
       "4                         0.0               University of Houston   \n",
       "\n",
       "              Standardized University Education (Type of degree/major)  \\\n",
       "0  Indiana University of Pennsylvania                         Fine Art   \n",
       "1                                 NaN                              NaN   \n",
       "2                  Fordham University                       Psychology   \n",
       "3              University of Michigan             Computer Engineering   \n",
       "4               University of Houston                              NaN   \n",
       "\n",
       "  Standardized Major Degree Type          ...           Graduate Studies  \\\n",
       "0             Design         NaN          ...                        NaN   \n",
       "1                NaN         NaN          ...                        NaN   \n",
       "2         Psychology          BA          ...                        NaN   \n",
       "3   Computer Science          BS          ...                        NaN   \n",
       "4                NaN         NaN          ...                        NaN   \n",
       "\n",
       "  Standardized Graduate Studies Graduate Diploma  \\\n",
       "0                           NaN              NaN   \n",
       "1                           NaN              NaN   \n",
       "2                           NaN              NaN   \n",
       "3                           NaN              NaN   \n",
       "4                           NaN              NaN   \n",
       "\n",
       "  Ever served as TA/Teacher/Professor/Mentor?  \\\n",
       "0                                         0.0   \n",
       "1                                         0.0   \n",
       "2                                         0.0   \n",
       "3                                         0.0   \n",
       "4                                         0.0   \n",
       "\n",
       "  # Years of employment (non-founder)  \\\n",
       "0                                 4.0   \n",
       "1                                12.0   \n",
       "2                                 4.0   \n",
       "3                                18.0   \n",
       "4                                15.0   \n",
       "\n",
       "  Worked as product manager/director/head/VP?  Worked at Google?  \\\n",
       "0                                         1.0                1.0   \n",
       "1                                         1.0                0.0   \n",
       "2                                         1.0                0.0   \n",
       "3                                         1.0                0.0   \n",
       "4                                         1.0                0.0   \n",
       "\n",
       "   Worked at Microsoft?  Worked in Sales?  Stanford or Berkeley  \n",
       "0                   0.0               0.0                     0  \n",
       "1                   0.0               0.0                     0  \n",
       "2                   0.0               0.0                     0  \n",
       "3                   0.0               0.0                     0  \n",
       "4                   0.0               0.0                     0  \n",
       "\n",
       "[5 rows x 23 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Stanford or Berkeley'] = df.apply(stanford_berkeley,axis=1)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Founding Time</th>\n",
       "      <th>Previous startups?</th>\n",
       "      <th>Consulting before start-up</th>\n",
       "      <th>Undergraduate College</th>\n",
       "      <th>Standardized University</th>\n",
       "      <th>Education (Type of degree/major)</th>\n",
       "      <th>Standardized Major</th>\n",
       "      <th>Degree Type</th>\n",
       "      <th>...</th>\n",
       "      <th>Standardized Graduate Studies</th>\n",
       "      <th>Graduate Diploma</th>\n",
       "      <th>Ever served as TA/Teacher/Professor/Mentor?</th>\n",
       "      <th># Years of employment (non-founder)</th>\n",
       "      <th>Worked as product manager/director/head/VP?</th>\n",
       "      <th>Worked at Google?</th>\n",
       "      <th>Worked at Microsoft?</th>\n",
       "      <th>Worked in Sales?</th>\n",
       "      <th>Stanford or Berkeley</th>\n",
       "      <th>Ivy League</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chad Hurley</td>\n",
       "      <td>YouTube</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Indiana University of Pennsylvania</td>\n",
       "      <td>Indiana University of Pennsylvania</td>\n",
       "      <td>Fine Art</td>\n",
       "      <td>Design</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gwyneth Paltrow</td>\n",
       "      <td>Goop Inc.</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jason Calacanis</td>\n",
       "      <td>Inside.com</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>Psychology</td>\n",
       "      <td>Psychology</td>\n",
       "      <td>BA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tony Fadell</td>\n",
       "      <td>Nest Labs</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Michigan</td>\n",
       "      <td>University of Michigan</td>\n",
       "      <td>Computer Engineering</td>\n",
       "      <td>Computer Science</td>\n",
       "      <td>BS</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matt Mullenweg</td>\n",
       "      <td>Automattic</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Full Name Primary Company  Founding Time  Previous startups?  \\\n",
       "0      Chad Hurley         YouTube         2005.0                 0.0   \n",
       "1  Gwyneth Paltrow       Goop Inc.         2008.0                 0.0   \n",
       "2  Jason Calacanis      Inside.com         2007.0                 3.0   \n",
       "3      Tony Fadell       Nest Labs         2010.0                 1.0   \n",
       "4   Matt Mullenweg      Automattic         2005.0                 1.0   \n",
       "\n",
       "   Consulting before start-up               Undergraduate College  \\\n",
       "0                         0.0  Indiana University of Pennsylvania   \n",
       "1                         0.0                                 NaN   \n",
       "2                         0.0                  Fordham University   \n",
       "3                         0.0              University of Michigan   \n",
       "4                         0.0               University of Houston   \n",
       "\n",
       "              Standardized University Education (Type of degree/major)  \\\n",
       "0  Indiana University of Pennsylvania                         Fine Art   \n",
       "1                                 NaN                              NaN   \n",
       "2                  Fordham University                       Psychology   \n",
       "3              University of Michigan             Computer Engineering   \n",
       "4               University of Houston                              NaN   \n",
       "\n",
       "  Standardized Major Degree Type     ...      Standardized Graduate Studies  \\\n",
       "0             Design         NaN     ...                                NaN   \n",
       "1                NaN         NaN     ...                                NaN   \n",
       "2         Psychology          BA     ...                                NaN   \n",
       "3   Computer Science          BS     ...                                NaN   \n",
       "4                NaN         NaN     ...                                NaN   \n",
       "\n",
       "  Graduate Diploma Ever served as TA/Teacher/Professor/Mentor?  \\\n",
       "0              NaN                                         0.0   \n",
       "1              NaN                                         0.0   \n",
       "2              NaN                                         0.0   \n",
       "3              NaN                                         0.0   \n",
       "4              NaN                                         0.0   \n",
       "\n",
       "  # Years of employment (non-founder)  \\\n",
       "0                                 4.0   \n",
       "1                                12.0   \n",
       "2                                 4.0   \n",
       "3                                18.0   \n",
       "4                                15.0   \n",
       "\n",
       "  Worked as product manager/director/head/VP? Worked at Google?  \\\n",
       "0                                         1.0               1.0   \n",
       "1                                         1.0               0.0   \n",
       "2                                         1.0               0.0   \n",
       "3                                         1.0               0.0   \n",
       "4                                         1.0               0.0   \n",
       "\n",
       "   Worked at Microsoft?  Worked in Sales?  Stanford or Berkeley  Ivy League  \n",
       "0                   0.0               0.0                     0           0  \n",
       "1                   0.0               0.0                     0           0  \n",
       "2                   0.0               0.0                     0           0  \n",
       "3                   0.0               0.0                     0           0  \n",
       "4                   0.0               0.0                     0           0  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Ivy League'] = df.apply(ivy_league,axis=1)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Founding Time</th>\n",
       "      <th>Previous startups?</th>\n",
       "      <th>Consulting before start-up</th>\n",
       "      <th>Undergraduate College</th>\n",
       "      <th>Standardized University</th>\n",
       "      <th>Education (Type of degree/major)</th>\n",
       "      <th>Standardized Major</th>\n",
       "      <th>Degree Type</th>\n",
       "      <th>...</th>\n",
       "      <th>Standardized Graduate Studies</th>\n",
       "      <th>Graduate Diploma</th>\n",
       "      <th>Ever served as TA/Teacher/Professor/Mentor?</th>\n",
       "      <th># Years of employment (non-founder)</th>\n",
       "      <th>Worked as product manager/director/head/VP?</th>\n",
       "      <th>Worked at Google?</th>\n",
       "      <th>Worked at Microsoft?</th>\n",
       "      <th>Worked in Sales?</th>\n",
       "      <th>Stanford or Berkeley</th>\n",
       "      <th>Ivy League</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chad Hurley</td>\n",
       "      <td>YouTube</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Indiana University of Pennsylvania</td>\n",
       "      <td>Indiana University of Pennsylvania</td>\n",
       "      <td>Fine Art</td>\n",
       "      <td>Design</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gwyneth Paltrow</td>\n",
       "      <td>Goop Inc.</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jason Calacanis</td>\n",
       "      <td>Inside.com</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>Psychology</td>\n",
       "      <td>Psychology</td>\n",
       "      <td>BA</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tony Fadell</td>\n",
       "      <td>Nest Labs</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Michigan</td>\n",
       "      <td>University of Michigan</td>\n",
       "      <td>Computer Engineering</td>\n",
       "      <td>Computer Science</td>\n",
       "      <td>BS</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matt Mullenweg</td>\n",
       "      <td>Automattic</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Full Name Primary Company  Founding Time  Previous startups?  \\\n",
       "0      Chad Hurley         YouTube         2005.0                 0.0   \n",
       "1  Gwyneth Paltrow       Goop Inc.         2008.0                 0.0   \n",
       "2  Jason Calacanis      Inside.com         2007.0                 3.0   \n",
       "3      Tony Fadell       Nest Labs         2010.0                 1.0   \n",
       "4   Matt Mullenweg      Automattic         2005.0                 1.0   \n",
       "\n",
       "   Consulting before start-up               Undergraduate College  \\\n",
       "0                         0.0  Indiana University of Pennsylvania   \n",
       "1                         0.0                                 NaN   \n",
       "2                         0.0                  Fordham University   \n",
       "3                         0.0              University of Michigan   \n",
       "4                         0.0               University of Houston   \n",
       "\n",
       "              Standardized University Education (Type of degree/major)  \\\n",
       "0  Indiana University of Pennsylvania                         Fine Art   \n",
       "1                                 NaN                              NaN   \n",
       "2                  Fordham University                       Psychology   \n",
       "3              University of Michigan             Computer Engineering   \n",
       "4               University of Houston                              NaN   \n",
       "\n",
       "  Standardized Major Degree Type     ...      Standardized Graduate Studies  \\\n",
       "0             Design         NaN     ...                                NaN   \n",
       "1                NaN         NaN     ...                                NaN   \n",
       "2         Psychology          BA     ...                                NaN   \n",
       "3   Computer Science          BS     ...                                NaN   \n",
       "4                NaN         NaN     ...                                NaN   \n",
       "\n",
       "  Graduate Diploma Ever served as TA/Teacher/Professor/Mentor?  \\\n",
       "0              NaN                                         0.0   \n",
       "1              NaN                                         0.0   \n",
       "2              NaN                                         0.0   \n",
       "3              NaN                                         0.0   \n",
       "4              NaN                                         0.0   \n",
       "\n",
       "  # Years of employment (non-founder)  \\\n",
       "0                                 4.0   \n",
       "1                                12.0   \n",
       "2                                 4.0   \n",
       "3                                18.0   \n",
       "4                                15.0   \n",
       "\n",
       "  Worked as product manager/director/head/VP? Worked at Google?  \\\n",
       "0                                         1.0               1.0   \n",
       "1                                         1.0               0.0   \n",
       "2                                         1.0               0.0   \n",
       "3                                         1.0               0.0   \n",
       "4                                         1.0               0.0   \n",
       "\n",
       "   Worked at Microsoft?  Worked in Sales?  Stanford or Berkeley  Ivy League  \n",
       "0                   0.0               0.0                     0           0  \n",
       "1                   0.0               0.0                     0           0  \n",
       "2                   0.0               0.0                     0           0  \n",
       "3                   0.0               0.0                     0           0  \n",
       "4                   0.0               0.0                     0           0  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.drop([\"Founding Time\", \"Undergraduate College\", \"Education (Type of degree/major)\", \"Graduate Institution\", \n",
    "        \"Graduate Studies\", \"Graduate Degree Time\"], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Previous startups?</th>\n",
       "      <th>Consulting before start-up</th>\n",
       "      <th>Standardized University</th>\n",
       "      <th>Standardized Major</th>\n",
       "      <th>Degree Type</th>\n",
       "      <th>Standardized Graduate Institution</th>\n",
       "      <th>Standardized Graduate Studies</th>\n",
       "      <th>Graduate Diploma</th>\n",
       "      <th>Ever served as TA/Teacher/Professor/Mentor?</th>\n",
       "      <th># Years of employment (non-founder)</th>\n",
       "      <th>Worked as product manager/director/head/VP?</th>\n",
       "      <th>Worked at Google?</th>\n",
       "      <th>Worked at Microsoft?</th>\n",
       "      <th>Worked in Sales?</th>\n",
       "      <th>Stanford or Berkeley</th>\n",
       "      <th>Ivy League</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chad Hurley</td>\n",
       "      <td>YouTube</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Indiana University of Pennsylvania</td>\n",
       "      <td>Design</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gwyneth Paltrow</td>\n",
       "      <td>Goop Inc.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jason Calacanis</td>\n",
       "      <td>Inside.com</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>Psychology</td>\n",
       "      <td>BA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tony Fadell</td>\n",
       "      <td>Nest Labs</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Michigan</td>\n",
       "      <td>Computer Science</td>\n",
       "      <td>BS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matt Mullenweg</td>\n",
       "      <td>Automattic</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Full Name Primary Company  Previous startups?  \\\n",
       "0      Chad Hurley         YouTube                 0.0   \n",
       "1  Gwyneth Paltrow       Goop Inc.                 0.0   \n",
       "2  Jason Calacanis      Inside.com                 3.0   \n",
       "3      Tony Fadell       Nest Labs                 1.0   \n",
       "4   Matt Mullenweg      Automattic                 1.0   \n",
       "\n",
       "   Consulting before start-up             Standardized University  \\\n",
       "0                         0.0  Indiana University of Pennsylvania   \n",
       "1                         0.0                                 NaN   \n",
       "2                         0.0                  Fordham University   \n",
       "3                         0.0              University of Michigan   \n",
       "4                         0.0               University of Houston   \n",
       "\n",
       "  Standardized Major Degree Type Standardized Graduate Institution  \\\n",
       "0             Design         NaN                               NaN   \n",
       "1                NaN         NaN                               NaN   \n",
       "2         Psychology          BA                               NaN   \n",
       "3   Computer Science          BS                               NaN   \n",
       "4                NaN         NaN                               NaN   \n",
       "\n",
       "  Standardized Graduate Studies Graduate Diploma  \\\n",
       "0                           NaN              NaN   \n",
       "1                           NaN              NaN   \n",
       "2                           NaN              NaN   \n",
       "3                           NaN              NaN   \n",
       "4                           NaN              NaN   \n",
       "\n",
       "   Ever served as TA/Teacher/Professor/Mentor?  \\\n",
       "0                                          0.0   \n",
       "1                                          0.0   \n",
       "2                                          0.0   \n",
       "3                                          0.0   \n",
       "4                                          0.0   \n",
       "\n",
       "   # Years of employment (non-founder)  \\\n",
       "0                                  4.0   \n",
       "1                                 12.0   \n",
       "2                                  4.0   \n",
       "3                                 18.0   \n",
       "4                                 15.0   \n",
       "\n",
       "   Worked as product manager/director/head/VP?  Worked at Google?  \\\n",
       "0                                          1.0                1.0   \n",
       "1                                          1.0                0.0   \n",
       "2                                          1.0                0.0   \n",
       "3                                          1.0                0.0   \n",
       "4                                          1.0                0.0   \n",
       "\n",
       "   Worked at Microsoft?  Worked in Sales?  Stanford or Berkeley  Ivy League  \n",
       "0                   0.0               0.0                     0           0  \n",
       "1                   0.0               0.0                     0           0  \n",
       "2                   0.0               0.0                     0           0  \n",
       "3                   0.0               0.0                     0           0  \n",
       "4                   0.0               0.0                     0           0  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Previous startups?</th>\n",
       "      <th>Consulting before start-up</th>\n",
       "      <th>Standardized University</th>\n",
       "      <th>Standardized Major</th>\n",
       "      <th>Degree Type</th>\n",
       "      <th>Standardized Graduate Institution</th>\n",
       "      <th>Standardized Graduate Studies</th>\n",
       "      <th>Graduate Diploma</th>\n",
       "      <th>Ever served as TA/Teacher/Professor/Mentor?</th>\n",
       "      <th># Years of employment (non-founder)</th>\n",
       "      <th>Worked as product manager/director/head/VP?</th>\n",
       "      <th>Worked at Google?</th>\n",
       "      <th>Worked at Microsoft?</th>\n",
       "      <th>Worked in Sales?</th>\n",
       "      <th>Stanford or Berkeley</th>\n",
       "      <th>Ivy League</th>\n",
       "      <th>Crunchbase</th>\n",
       "      <th>LinkedIn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chad Hurley</td>\n",
       "      <td>YouTube</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Indiana University of Pennsylvania</td>\n",
       "      <td>Design</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/chad-hurley</td>\n",
       "      <td>http://www.linkedin.com/profile/view?id=5711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gwyneth Paltrow</td>\n",
       "      <td>Goop Inc.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/gwyneth-paltrow</td>\n",
       "      <td>https://www.linkedin.com/in/gwyneth-paltrow-48...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jason Calacanis</td>\n",
       "      <td>Inside.com</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>Psychology</td>\n",
       "      <td>BA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/jason-calacanis</td>\n",
       "      <td>http://www.linkedin.com/in/jasoncalacanis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tony Fadell</td>\n",
       "      <td>Nest Labs</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Michigan</td>\n",
       "      <td>Computer Science</td>\n",
       "      <td>BS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/tony-fadell</td>\n",
       "      <td>http://www.linkedin.com/pub/tony-fadell/0/1/380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matt Mullenweg</td>\n",
       "      <td>Automattic</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/matt-mullenweg</td>\n",
       "      <td>http://www.linkedin.com/in/mattm</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Full Name Primary Company  Previous startups?  \\\n",
       "0      Chad Hurley         YouTube                 0.0   \n",
       "1  Gwyneth Paltrow       Goop Inc.                 0.0   \n",
       "2  Jason Calacanis      Inside.com                 3.0   \n",
       "3      Tony Fadell       Nest Labs                 1.0   \n",
       "4   Matt Mullenweg      Automattic                 1.0   \n",
       "\n",
       "   Consulting before start-up             Standardized University  \\\n",
       "0                         0.0  Indiana University of Pennsylvania   \n",
       "1                         0.0                                 NaN   \n",
       "2                         0.0                  Fordham University   \n",
       "3                         0.0              University of Michigan   \n",
       "4                         0.0               University of Houston   \n",
       "\n",
       "  Standardized Major Degree Type Standardized Graduate Institution  \\\n",
       "0             Design         NaN                               NaN   \n",
       "1                NaN         NaN                               NaN   \n",
       "2         Psychology          BA                               NaN   \n",
       "3   Computer Science          BS                               NaN   \n",
       "4                NaN         NaN                               NaN   \n",
       "\n",
       "  Standardized Graduate Studies Graduate Diploma  \\\n",
       "0                           NaN              NaN   \n",
       "1                           NaN              NaN   \n",
       "2                           NaN              NaN   \n",
       "3                           NaN              NaN   \n",
       "4                           NaN              NaN   \n",
       "\n",
       "   Ever served as TA/Teacher/Professor/Mentor?  \\\n",
       "0                                          0.0   \n",
       "1                                          0.0   \n",
       "2                                          0.0   \n",
       "3                                          0.0   \n",
       "4                                          0.0   \n",
       "\n",
       "   # Years of employment (non-founder)  \\\n",
       "0                                  4.0   \n",
       "1                                 12.0   \n",
       "2                                  4.0   \n",
       "3                                 18.0   \n",
       "4                                 15.0   \n",
       "\n",
       "   Worked as product manager/director/head/VP?  Worked at Google?  \\\n",
       "0                                          1.0                1.0   \n",
       "1                                          1.0                0.0   \n",
       "2                                          1.0                0.0   \n",
       "3                                          1.0                0.0   \n",
       "4                                          1.0                0.0   \n",
       "\n",
       "   Worked at Microsoft?  Worked in Sales?  Stanford or Berkeley  Ivy League  \\\n",
       "0                   0.0               0.0                     0           0   \n",
       "1                   0.0               0.0                     0           0   \n",
       "2                   0.0               0.0                     0           0   \n",
       "3                   0.0               0.0                     0           0   \n",
       "4                   0.0               0.0                     0           0   \n",
       "\n",
       "                                          Crunchbase  \\\n",
       "0      https://www.crunchbase.com/person/chad-hurley   \n",
       "1  https://www.crunchbase.com/person/gwyneth-paltrow   \n",
       "2  https://www.crunchbase.com/person/jason-calacanis   \n",
       "3      https://www.crunchbase.com/person/tony-fadell   \n",
       "4   https://www.crunchbase.com/person/matt-mullenweg   \n",
       "\n",
       "                                            LinkedIn  \n",
       "0       http://www.linkedin.com/profile/view?id=5711  \n",
       "1  https://www.linkedin.com/in/gwyneth-paltrow-48...  \n",
       "2          http://www.linkedin.com/in/jasoncalacanis  \n",
       "3    http://www.linkedin.com/pub/tony-fadell/0/1/380  \n",
       "4                   http://www.linkedin.com/in/mattm  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "links = pd.read_csv('data/links.csv', encoding = \"ISO-8859-1\")\n",
    "df = pd.merge(df, links, on='Full Name')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#years of employment - get rid of rows with nan\n",
    "df = df.rename(columns={'# Years of employment (non-founder)': 'Years of Employment'})\n",
    "df = df[df['Years of Employment'].notnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df=df.fillna(\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Previous startups?</th>\n",
       "      <th>Consulting before start-up</th>\n",
       "      <th>Standardized University</th>\n",
       "      <th>Standardized Major</th>\n",
       "      <th>Degree Type</th>\n",
       "      <th>Standardized Graduate Institution</th>\n",
       "      <th>Standardized Graduate Studies</th>\n",
       "      <th>Graduate Diploma</th>\n",
       "      <th>Ever served as TA/Teacher/Professor/Mentor?</th>\n",
       "      <th>Years of Employment</th>\n",
       "      <th>Worked as product manager/director/head/VP?</th>\n",
       "      <th>Worked at Google?</th>\n",
       "      <th>Worked at Microsoft?</th>\n",
       "      <th>Worked in Sales?</th>\n",
       "      <th>Stanford or Berkeley</th>\n",
       "      <th>Ivy League</th>\n",
       "      <th>Crunchbase</th>\n",
       "      <th>LinkedIn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chad Hurley</td>\n",
       "      <td>YouTube</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Indiana University of Pennsylvania</td>\n",
       "      <td>Design</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/chad-hurley</td>\n",
       "      <td>http://www.linkedin.com/profile/view?id=5711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gwyneth Paltrow</td>\n",
       "      <td>Goop Inc.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/gwyneth-paltrow</td>\n",
       "      <td>https://www.linkedin.com/in/gwyneth-paltrow-48...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jason Calacanis</td>\n",
       "      <td>Inside.com</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fordham University</td>\n",
       "      <td>Psychology</td>\n",
       "      <td>BA</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/jason-calacanis</td>\n",
       "      <td>http://www.linkedin.com/in/jasoncalacanis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tony Fadell</td>\n",
       "      <td>Nest Labs</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Michigan</td>\n",
       "      <td>Computer Science</td>\n",
       "      <td>BS</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/tony-fadell</td>\n",
       "      <td>http://www.linkedin.com/pub/tony-fadell/0/1/380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matt Mullenweg</td>\n",
       "      <td>Automattic</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/matt-mullenweg</td>\n",
       "      <td>http://www.linkedin.com/in/mattm</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Full Name Primary Company  Previous startups?  \\\n",
       "0      Chad Hurley         YouTube                 0.0   \n",
       "1  Gwyneth Paltrow       Goop Inc.                 0.0   \n",
       "2  Jason Calacanis      Inside.com                 3.0   \n",
       "3      Tony Fadell       Nest Labs                 1.0   \n",
       "4   Matt Mullenweg      Automattic                 1.0   \n",
       "\n",
       "   Consulting before start-up             Standardized University  \\\n",
       "0                         0.0  Indiana University of Pennsylvania   \n",
       "1                         0.0                                       \n",
       "2                         0.0                  Fordham University   \n",
       "3                         0.0              University of Michigan   \n",
       "4                         0.0               University of Houston   \n",
       "\n",
       "  Standardized Major Degree Type Standardized Graduate Institution  \\\n",
       "0             Design                                                 \n",
       "1                                                                    \n",
       "2         Psychology          BA                                     \n",
       "3   Computer Science          BS                                     \n",
       "4                                                                    \n",
       "\n",
       "  Standardized Graduate Studies Graduate Diploma  \\\n",
       "0                                                  \n",
       "1                                                  \n",
       "2                                                  \n",
       "3                                                  \n",
       "4                                                  \n",
       "\n",
       "  Ever served as TA/Teacher/Professor/Mentor?  Years of Employment  \\\n",
       "0                                           0                  4.0   \n",
       "1                                           0                 12.0   \n",
       "2                                           0                  4.0   \n",
       "3                                           0                 18.0   \n",
       "4                                           0                 15.0   \n",
       "\n",
       "   Worked as product manager/director/head/VP?  Worked at Google?  \\\n",
       "0                                          1.0                1.0   \n",
       "1                                          1.0                0.0   \n",
       "2                                          1.0                0.0   \n",
       "3                                          1.0                0.0   \n",
       "4                                          1.0                0.0   \n",
       "\n",
       "  Worked at Microsoft? Worked in Sales?  Stanford or Berkeley  Ivy League  \\\n",
       "0                    0                0                     0           0   \n",
       "1                    0                0                     0           0   \n",
       "2                    0                0                     0           0   \n",
       "3                    0                0                     0           0   \n",
       "4                    0                0                     0           0   \n",
       "\n",
       "                                          Crunchbase  \\\n",
       "0      https://www.crunchbase.com/person/chad-hurley   \n",
       "1  https://www.crunchbase.com/person/gwyneth-paltrow   \n",
       "2  https://www.crunchbase.com/person/jason-calacanis   \n",
       "3      https://www.crunchbase.com/person/tony-fadell   \n",
       "4   https://www.crunchbase.com/person/matt-mullenweg   \n",
       "\n",
       "                                            LinkedIn  \n",
       "0       http://www.linkedin.com/profile/view?id=5711  \n",
       "1  https://www.linkedin.com/in/gwyneth-paltrow-48...  \n",
       "2          http://www.linkedin.com/in/jasoncalacanis  \n",
       "3    http://www.linkedin.com/pub/tony-fadell/0/1/380  \n",
       "4                   http://www.linkedin.com/in/mattm  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Previous startups?</th>\n",
       "      <th>Consulting before start-up</th>\n",
       "      <th>Standardized University</th>\n",
       "      <th>Standardized Major</th>\n",
       "      <th>Degree Type</th>\n",
       "      <th>Standardized Graduate Institution</th>\n",
       "      <th>Standardized Graduate Studies</th>\n",
       "      <th>Graduate Diploma</th>\n",
       "      <th>Ever served as TA/Teacher/Professor/Mentor?</th>\n",
       "      <th>Years of Employment</th>\n",
       "      <th>Worked as product manager/director/head/VP?</th>\n",
       "      <th>Worked at Google?</th>\n",
       "      <th>Worked at Microsoft?</th>\n",
       "      <th>Worked in Sales?</th>\n",
       "      <th>Stanford or Berkeley</th>\n",
       "      <th>Ivy League</th>\n",
       "      <th>Crunchbase</th>\n",
       "      <th>LinkedIn</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>599</th>\n",
       "      <td>Cliff Moon</td>\n",
       "      <td>Opsee</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>University of Delaware</td>\n",
       "      <td>Computer Science</td>\n",
       "      <td>BS</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/cliff-moon</td>\n",
       "      <td>http://www.linkedin.com/pub/cliff-moon/4/44b/283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>Hesaam Esfandyarpour</td>\n",
       "      <td>Genapsys</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Sharif University of Technology</td>\n",
       "      <td>Electrical Engineering</td>\n",
       "      <td>BS</td>\n",
       "      <td>Stanford University</td>\n",
       "      <td>Medicine</td>\n",
       "      <td>MS</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/hesaam-esfan...</td>\n",
       "      <td>https://www.linkedin.com/pub/hesaam-esfandyarp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601</th>\n",
       "      <td>Marc Ruxin</td>\n",
       "      <td>TastemakerX</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Hamilton College</td>\n",
       "      <td>History</td>\n",
       "      <td>BA</td>\n",
       "      <td></td>\n",
       "      <td>Business</td>\n",
       "      <td>MBA</td>\n",
       "      <td>0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/marc-ruxin</td>\n",
       "      <td>http://www.linkedin.com/in/marcruxin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>602</th>\n",
       "      <td>Radu B. Rusu</td>\n",
       "      <td>Fyusion</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Computer Science</td>\n",
       "      <td>PhD</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/radu-b--rusu</td>\n",
       "      <td>https://www.linkedin.com/in/radubogdanrusu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603</th>\n",
       "      <td>Ronni Zehavi</td>\n",
       "      <td>Hibob</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Tel Aviv University</td>\n",
       "      <td>History</td>\n",
       "      <td>BA</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.crunchbase.com/person/ronni-zehavi-2</td>\n",
       "      <td>https://www.linkedin.com/in/ronnizehavi</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Full Name Primary Company  Previous startups?  \\\n",
       "599            Cliff Moon           Opsee                 1.0   \n",
       "600  Hesaam Esfandyarpour        Genapsys                 1.0   \n",
       "601            Marc Ruxin     TastemakerX                 0.0   \n",
       "602          Radu B. Rusu         Fyusion                 0.0   \n",
       "603          Ronni Zehavi           Hibob                 2.0   \n",
       "\n",
       "     Consulting before start-up          Standardized University  \\\n",
       "599                         0.0           University of Delaware   \n",
       "600                         0.0  Sharif University of Technology   \n",
       "601                         0.0                 Hamilton College   \n",
       "602                         0.0                                    \n",
       "603                         0.0              Tel Aviv University   \n",
       "\n",
       "         Standardized Major Degree Type Standardized Graduate Institution  \\\n",
       "599        Computer Science          BS                                     \n",
       "600  Electrical Engineering          BS               Stanford University   \n",
       "601                 History          BA                                     \n",
       "602                                                                         \n",
       "603                 History          BA                                     \n",
       "\n",
       "    Standardized Graduate Studies Graduate Diploma  \\\n",
       "599                                                  \n",
       "600                      Medicine               MS   \n",
       "601                      Business              MBA   \n",
       "602              Computer Science              PhD   \n",
       "603                                                  \n",
       "\n",
       "    Ever served as TA/Teacher/Professor/Mentor?  Years of Employment  \\\n",
       "599                                           0                  6.0   \n",
       "600                                           1                  6.0   \n",
       "601                                           0                 15.0   \n",
       "602                                           1                 10.0   \n",
       "603                                           0                 11.0   \n",
       "\n",
       "     Worked as product manager/director/head/VP?  Worked at Google?  \\\n",
       "599                                          0.0                0.0   \n",
       "600                                          0.0                0.0   \n",
       "601                                          0.0                0.0   \n",
       "602                                          0.0                0.0   \n",
       "603                                          0.0                0.0   \n",
       "\n",
       "    Worked at Microsoft? Worked in Sales?  Stanford or Berkeley  Ivy League  \\\n",
       "599                    0                0                     0           0   \n",
       "600                    0                0                     0           0   \n",
       "601                    0                1                     0           0   \n",
       "602                    0                0                     0           0   \n",
       "603                    0                1                     0           0   \n",
       "\n",
       "                                            Crunchbase  \\\n",
       "599       https://www.crunchbase.com/person/cliff-moon   \n",
       "600  https://www.crunchbase.com/person/hesaam-esfan...   \n",
       "601       https://www.crunchbase.com/person/marc-ruxin   \n",
       "602     https://www.crunchbase.com/person/radu-b--rusu   \n",
       "603   https://www.crunchbase.com/person/ronni-zehavi-2   \n",
       "\n",
       "                                              LinkedIn  \n",
       "599   http://www.linkedin.com/pub/cliff-moon/4/44b/283  \n",
       "600  https://www.linkedin.com/pub/hesaam-esfandyarp...  \n",
       "601               http://www.linkedin.com/in/marcruxin  \n",
       "602         https://www.linkedin.com/in/radubogdanrusu  \n",
       "603            https://www.linkedin.com/in/ronnizehavi  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv(\"data/cleaned_input_data.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "output = pd.read_csv('data/output_data.csv', encoding = \"ISO-8859-1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Seed Valuation</th>\n",
       "      <th>A Valuation</th>\n",
       "      <th>B Valuation</th>\n",
       "      <th>Valuation Increase</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Series A Month</th>\n",
       "      <th>Series A Day</th>\n",
       "      <th>Series A Year</th>\n",
       "      <th>Unnamed: 10</th>\n",
       "      <th>Unnamed: 11</th>\n",
       "      <th>Unnamed: 12</th>\n",
       "      <th>CEO at A</th>\n",
       "      <th>CEO at B</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chad Hurley</td>\n",
       "      <td>YouTube</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14,000,000.00</td>\n",
       "      <td>88,400,000.00</td>\n",
       "      <td>6.314285714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gwyneth Paltrow</td>\n",
       "      <td>Goop Inc.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40,000,000.00</td>\n",
       "      <td>65,000,000.00</td>\n",
       "      <td>1.625</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jason Calacanis</td>\n",
       "      <td>Inside.com</td>\n",
       "      <td>$7,000,000.00</td>\n",
       "      <td>11,250,000.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>#VALUE!</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tony Fadell</td>\n",
       "      <td>Nest Labs</td>\n",
       "      <td>$2,700,000.00</td>\n",
       "      <td>49,210,000.00</td>\n",
       "      <td>288,120,000.00</td>\n",
       "      <td>5.854907539</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matt Mullenweg</td>\n",
       "      <td>Automattic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8,650,000.00</td>\n",
       "      <td>238,590,000.00</td>\n",
       "      <td>27.58265896</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Full Name Primary Company  Seed Valuation    A Valuation  \\\n",
       "0      Chad Hurley         YouTube             NaN  14,000,000.00   \n",
       "1  Gwyneth Paltrow       Goop Inc.             NaN  40,000,000.00   \n",
       "2  Jason Calacanis      Inside.com  $7,000,000.00   11,250,000.00   \n",
       "3      Tony Fadell       Nest Labs  $2,700,000.00   49,210,000.00   \n",
       "4   Matt Mullenweg      Automattic             NaN   8,650,000.00   \n",
       "\n",
       "      B Valuation Valuation Increase  Unnamed: 6 Series A Month  Series A Day  \\\n",
       "0   88,400,000.00        6.314285714         NaN            NaN           NaN   \n",
       "1   65,000,000.00              1.625         NaN            NaN           NaN   \n",
       "2             NaN            #VALUE!         NaN            NaN           NaN   \n",
       "3  288,120,000.00        5.854907539         NaN            NaN           NaN   \n",
       "4  238,590,000.00        27.58265896         NaN            NaN           NaN   \n",
       "\n",
       "   Series A Year  Unnamed: 10  Unnamed: 11  Unnamed: 12  CEO at A  CEO at B  \n",
       "0            NaN          NaN          NaN          NaN       1.0       1.0  \n",
       "1            NaN          NaN          NaN          NaN       1.0       1.0  \n",
       "2            NaN          NaN          NaN          NaN       1.0       NaN  \n",
       "3            NaN          NaN          NaN          NaN       1.0       1.0  \n",
       "4            NaN          NaN          NaN          NaN       1.0       1.0  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Seed Valuation</th>\n",
       "      <th>A Valuation</th>\n",
       "      <th>B Valuation</th>\n",
       "      <th>Valuation Increase</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chad Hurley</td>\n",
       "      <td>YouTube</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14,000,000.00</td>\n",
       "      <td>88,400,000.00</td>\n",
       "      <td>6.314285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gwyneth Paltrow</td>\n",
       "      <td>Goop Inc.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40,000,000.00</td>\n",
       "      <td>65,000,000.00</td>\n",
       "      <td>1.625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jason Calacanis</td>\n",
       "      <td>Inside.com</td>\n",
       "      <td>$7,000,000.00</td>\n",
       "      <td>11,250,000.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>#VALUE!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tony Fadell</td>\n",
       "      <td>Nest Labs</td>\n",
       "      <td>$2,700,000.00</td>\n",
       "      <td>49,210,000.00</td>\n",
       "      <td>288,120,000.00</td>\n",
       "      <td>5.854907539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matt Mullenweg</td>\n",
       "      <td>Automattic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8,650,000.00</td>\n",
       "      <td>238,590,000.00</td>\n",
       "      <td>27.58265896</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Full Name Primary Company  Seed Valuation    A Valuation  \\\n",
       "0      Chad Hurley         YouTube             NaN  14,000,000.00   \n",
       "1  Gwyneth Paltrow       Goop Inc.             NaN  40,000,000.00   \n",
       "2  Jason Calacanis      Inside.com  $7,000,000.00   11,250,000.00   \n",
       "3      Tony Fadell       Nest Labs  $2,700,000.00   49,210,000.00   \n",
       "4   Matt Mullenweg      Automattic             NaN   8,650,000.00   \n",
       "\n",
       "      B Valuation Valuation Increase  \n",
       "0   88,400,000.00        6.314285714  \n",
       "1   65,000,000.00              1.625  \n",
       "2             NaN            #VALUE!  \n",
       "3  288,120,000.00        5.854907539  \n",
       "4  238,590,000.00        27.58265896  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output.columns[6:]\n",
    "output = output.drop(output.columns[6:], axis=1 )\n",
    "output.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "output=output.fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Primary Company</th>\n",
       "      <th>Seed Valuation</th>\n",
       "      <th>A Valuation</th>\n",
       "      <th>B Valuation</th>\n",
       "      <th>Valuation Increase</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chad Hurley</td>\n",
       "      <td>YouTube</td>\n",
       "      <td>0</td>\n",
       "      <td>14,000,000.00</td>\n",
       "      <td>88,400,000.00</td>\n",
       "      <td>6.314285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gwyneth Paltrow</td>\n",
       "      <td>Goop Inc.</td>\n",
       "      <td>0</td>\n",
       "      <td>40,000,000.00</td>\n",
       "      <td>65,000,000.00</td>\n",
       "      <td>1.625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jason Calacanis</td>\n",
       "      <td>Inside.com</td>\n",
       "      <td>$7,000,000.00</td>\n",
       "      <td>11,250,000.00</td>\n",
       "      <td>0</td>\n",
       "      <td>#VALUE!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tony Fadell</td>\n",
       "      <td>Nest Labs</td>\n",
       "      <td>$2,700,000.00</td>\n",
       "      <td>49,210,000.00</td>\n",
       "      <td>288,120,000.00</td>\n",
       "      <td>5.854907539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Matt Mullenweg</td>\n",
       "      <td>Automattic</td>\n",
       "      <td>0</td>\n",
       "      <td>8,650,000.00</td>\n",
       "      <td>238,590,000.00</td>\n",
       "      <td>27.58265896</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Full Name Primary Company  Seed Valuation    A Valuation  \\\n",
       "0      Chad Hurley         YouTube               0  14,000,000.00   \n",
       "1  Gwyneth Paltrow       Goop Inc.               0  40,000,000.00   \n",
       "2  Jason Calacanis      Inside.com  $7,000,000.00   11,250,000.00   \n",
       "3      Tony Fadell       Nest Labs  $2,700,000.00   49,210,000.00   \n",
       "4   Matt Mullenweg      Automattic               0   8,650,000.00   \n",
       "\n",
       "      B Valuation Valuation Increase  \n",
       "0   88,400,000.00        6.314285714  \n",
       "1   65,000,000.00              1.625  \n",
       "2               0            #VALUE!  \n",
       "3  288,120,000.00        5.854907539  \n",
       "4  238,590,000.00        27.58265896  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "output.to_csv(\"data/cleaned_output_data.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}