funding_round_descriptive.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.metrics import classification_report\n",
    "from sklearn.metrics import confusion_matrix\n",
    "from sklearn.metrics import accuracy_score\n",
    "from nltk.corpus import stopwords\n",
    "import matplotlib.pylab as pylab\n",
    "import matplotlib.pyplot as plt\n",
    "from pandas import get_dummies\n",
    "import matplotlib as mpl\n",
    "import seaborn as sns\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib\n",
    "import warnings\n",
    "import sklearn\n",
    "import string\n",
    "import scipy\n",
    "import numpy\n",
    "import nltk\n",
    "import json\n",
    "import sys\n",
    "import csv\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#import dataset\n",
    "funding_rounds = pd.read_csv(\"/Users/lucyhyde/Desktop/Practicum_Data/funding_rounds.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(funding_rounds)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(102628, 10)\n"
     ]
    }
   ],
   "source": [
    "#shape\n",
    "print(funding_rounds.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 102628 entries, 0 to 102627\n",
      "Data columns (total 10 columns):\n",
      "org_permalink                            102628 non-null object\n",
      "funding_round_permalink                  102628 non-null object\n",
      "round_number                             102628 non-null int64\n",
      "funding_round_announced_on               102628 non-null object\n",
      "days_btw_rounds                          50160 non-null float64\n",
      "funding_round_type                       102628 non-null object\n",
      "funding_round_series                     26847 non-null object\n",
      "clean_round                              97579 non-null object\n",
      "funding_round_money_raised_usd           80630 non-null float64\n",
      "funding_round_pre_money_valuation_usd    3490 non-null float64\n",
      "dtypes: float64(3), int64(1), object(6)\n",
      "memory usage: 7.8+ MB\n",
      "None\n"
     ]
    }
   ],
   "source": [
    "print(funding_rounds.info())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>org_permalink</th>\n",
       "      <th>funding_round_permalink</th>\n",
       "      <th>round_number</th>\n",
       "      <th>funding_round_announced_on</th>\n",
       "      <th>days_btw_rounds</th>\n",
       "      <th>funding_round_type</th>\n",
       "      <th>funding_round_series</th>\n",
       "      <th>clean_round</th>\n",
       "      <th>funding_round_money_raised_usd</th>\n",
       "      <th>funding_round_pre_money_valuation_usd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>004-technologies</td>\n",
       "      <td>1278dd4e6a37fa4b7d7e06c21b3c1830</td>\n",
       "      <td>1</td>\n",
       "      <td>7/24/14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>venture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0chain</td>\n",
       "      <td>8643015e6d6e45ab8508e658bf0e18f7</td>\n",
       "      <td>1</td>\n",
       "      <td>2/7/18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>initial_coin_offering</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ICO</td>\n",
       "      <td>39000000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0chain</td>\n",
       "      <td>009ec1dbf7604d37b307be8d7202c442</td>\n",
       "      <td>2</td>\n",
       "      <td>2/8/18</td>\n",
       "      <td>1.0</td>\n",
       "      <td>seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0x-project</td>\n",
       "      <td>ea1d53d8a2e2110bd44f137a07b0c149</td>\n",
       "      <td>1</td>\n",
       "      <td>6/29/17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>initial_coin_offering</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ICO</td>\n",
       "      <td>24000000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0x-project</td>\n",
       "      <td>79ebc1b84e4e47daa5c0f43be784fe6c</td>\n",
       "      <td>2</td>\n",
       "      <td>8/15/17</td>\n",
       "      <td>47.0</td>\n",
       "      <td>seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0x-project</td>\n",
       "      <td>af09dbc1c670427984f44515bdf4ef62</td>\n",
       "      <td>3</td>\n",
       "      <td>10/1/17</td>\n",
       "      <td>47.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0x-project</td>\n",
       "      <td>cc83f2013ecb4d2ab565d0693446c381</td>\n",
       "      <td>4</td>\n",
       "      <td>10/1/17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>undisclosed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>e82464f22241715dd1a6c77241055ed1</td>\n",
       "      <td>1</td>\n",
       "      <td>7/20/11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>1000050.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>5de6d8828aef7d925d97918d15727670</td>\n",
       "      <td>2</td>\n",
       "      <td>2/5/13</td>\n",
       "      <td>566.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>03b975068632eba5bfdb937ec8c07a68</td>\n",
       "      <td>3</td>\n",
       "      <td>2/5/14</td>\n",
       "      <td>365.0</td>\n",
       "      <td>seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>150000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      org_permalink           funding_round_permalink  round_number  \\\n",
       "0  004-technologies  1278dd4e6a37fa4b7d7e06c21b3c1830             1   \n",
       "1            0chain  8643015e6d6e45ab8508e658bf0e18f7             1   \n",
       "2            0chain  009ec1dbf7604d37b307be8d7202c442             2   \n",
       "3        0x-project  ea1d53d8a2e2110bd44f137a07b0c149             1   \n",
       "4        0x-project  79ebc1b84e4e47daa5c0f43be784fe6c             2   \n",
       "5        0x-project  af09dbc1c670427984f44515bdf4ef62             3   \n",
       "6        0x-project  cc83f2013ecb4d2ab565d0693446c381             4   \n",
       "7                 1  e82464f22241715dd1a6c77241055ed1             1   \n",
       "8                 1  5de6d8828aef7d925d97918d15727670             2   \n",
       "9                 1  03b975068632eba5bfdb937ec8c07a68             3   \n",
       "\n",
       "  funding_round_announced_on  days_btw_rounds     funding_round_type  \\\n",
       "0                    7/24/14              NaN                venture   \n",
       "1                     2/7/18              NaN  initial_coin_offering   \n",
       "2                     2/8/18              1.0                   seed   \n",
       "3                    6/29/17              NaN  initial_coin_offering   \n",
       "4                    8/15/17             47.0                   seed   \n",
       "5                    10/1/17             47.0                venture   \n",
       "6                    10/1/17              0.0            undisclosed   \n",
       "7                    7/20/11              NaN                   seed   \n",
       "8                     2/5/13            566.0                venture   \n",
       "9                     2/5/14            365.0                   seed   \n",
       "\n",
       "  funding_round_series clean_round  funding_round_money_raised_usd  \\\n",
       "0                  NaN     Unknown                             NaN   \n",
       "1                  NaN         ICO                      39000000.0   \n",
       "2                  NaN        Seed                             NaN   \n",
       "3                  NaN         ICO                      24000000.0   \n",
       "4                  NaN        Seed                             NaN   \n",
       "5                  NaN        Seed                             NaN   \n",
       "6                  NaN        Seed                             NaN   \n",
       "7                  NaN        Seed                       1000050.0   \n",
       "8                  NaN        Seed                             NaN   \n",
       "9                  NaN        Seed                        150000.0   \n",
       "\n",
       "   funding_round_pre_money_valuation_usd  \n",
       "0                                    NaN  \n",
       "1                                    NaN  \n",
       "2                                    NaN  \n",
       "3                                    NaN  \n",
       "4                                    NaN  \n",
       "5                                    NaN  \n",
       "6                                    NaN  \n",
       "7                                    NaN  \n",
       "8                                    NaN  \n",
       "9                                    NaN  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "funding_rounds.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>org_permalink</th>\n",
       "      <th>funding_round_permalink</th>\n",
       "      <th>round_number</th>\n",
       "      <th>funding_round_announced_on</th>\n",
       "      <th>days_btw_rounds</th>\n",
       "      <th>funding_round_type</th>\n",
       "      <th>funding_round_series</th>\n",
       "      <th>clean_round</th>\n",
       "      <th>funding_round_money_raised_usd</th>\n",
       "      <th>funding_round_pre_money_valuation_usd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>102618</th>\n",
       "      <td>zyrl-ecdd</td>\n",
       "      <td>ae5ef5b3383b49aaa644f9fa9d95b8d6</td>\n",
       "      <td>1</td>\n",
       "      <td>1/17/17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>undisclosed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102619</th>\n",
       "      <td>zyrl-ecdd</td>\n",
       "      <td>67f1dafc3fb04d7aac501c5eefa3bbd1</td>\n",
       "      <td>2</td>\n",
       "      <td>7/1/17</td>\n",
       "      <td>165.0</td>\n",
       "      <td>convertible_note</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>200000.0</td>\n",
       "      <td>2000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102620</th>\n",
       "      <td>zyrl-ecdd</td>\n",
       "      <td>ca4de8e696f14b0389d73fcfc0f9e035</td>\n",
       "      <td>3</td>\n",
       "      <td>4/2/18</td>\n",
       "      <td>275.0</td>\n",
       "      <td>seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>250000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102621</th>\n",
       "      <td>zyston</td>\n",
       "      <td>3589a164533898b3ab14d8e7edc796b9</td>\n",
       "      <td>1</td>\n",
       "      <td>6/28/16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>venture</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>3700000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102622</th>\n",
       "      <td>zyston</td>\n",
       "      <td>5da00dbb5d71919b77698ec513c9ffad</td>\n",
       "      <td>2</td>\n",
       "      <td>5/10/17</td>\n",
       "      <td>316.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "      <td>2200000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102623</th>\n",
       "      <td>zystor</td>\n",
       "      <td>7ea37c0ff4132b084832039a9380d34e</td>\n",
       "      <td>1</td>\n",
       "      <td>12/16/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>venture</td>\n",
       "      <td>A</td>\n",
       "      <td>A</td>\n",
       "      <td>8500000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102624</th>\n",
       "      <td>zy-therapeutics</td>\n",
       "      <td>2f15bae5c5749c44b8b2edca9ca30188</td>\n",
       "      <td>1</td>\n",
       "      <td>6/14/16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>venture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A</td>\n",
       "      <td>6000000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102625</th>\n",
       "      <td>zyudly-labs</td>\n",
       "      <td>b945f9835425a2ac808bbab2d5dcc1db</td>\n",
       "      <td>1</td>\n",
       "      <td>5/11/17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102626</th>\n",
       "      <td>zz-biotech</td>\n",
       "      <td>182f7b627217f117c7fdd0addee9bf6c</td>\n",
       "      <td>1</td>\n",
       "      <td>3/13/14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>seed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Seed</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102627</th>\n",
       "      <td>zz-biotech</td>\n",
       "      <td>5aeb3087f3aaa56eff24f8275c38ca6d</td>\n",
       "      <td>2</td>\n",
       "      <td>1/1/15</td>\n",
       "      <td>294.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A</td>\n",
       "      <td>6930000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          org_permalink           funding_round_permalink  round_number  \\\n",
       "102618        zyrl-ecdd  ae5ef5b3383b49aaa644f9fa9d95b8d6             1   \n",
       "102619        zyrl-ecdd  67f1dafc3fb04d7aac501c5eefa3bbd1             2   \n",
       "102620        zyrl-ecdd  ca4de8e696f14b0389d73fcfc0f9e035             3   \n",
       "102621           zyston  3589a164533898b3ab14d8e7edc796b9             1   \n",
       "102622           zyston  5da00dbb5d71919b77698ec513c9ffad             2   \n",
       "102623           zystor  7ea37c0ff4132b084832039a9380d34e             1   \n",
       "102624  zy-therapeutics  2f15bae5c5749c44b8b2edca9ca30188             1   \n",
       "102625      zyudly-labs  b945f9835425a2ac808bbab2d5dcc1db             1   \n",
       "102626       zz-biotech  182f7b627217f117c7fdd0addee9bf6c             1   \n",
       "102627       zz-biotech  5aeb3087f3aaa56eff24f8275c38ca6d             2   \n",
       "\n",
       "       funding_round_announced_on  days_btw_rounds funding_round_type  \\\n",
       "102618                    1/17/17              NaN        undisclosed   \n",
       "102619                     7/1/17            165.0   convertible_note   \n",
       "102620                     4/2/18            275.0               seed   \n",
       "102621                    6/28/16              NaN            venture   \n",
       "102622                    5/10/17            316.0            venture   \n",
       "102623                   12/16/04              NaN            venture   \n",
       "102624                    6/14/16              NaN            venture   \n",
       "102625                    5/11/17              NaN               seed   \n",
       "102626                    3/13/14              NaN               seed   \n",
       "102627                     1/1/15            294.0            venture   \n",
       "\n",
       "       funding_round_series clean_round  funding_round_money_raised_usd  \\\n",
       "102618                  NaN        Seed                        100000.0   \n",
       "102619                  NaN        Seed                        200000.0   \n",
       "102620                  NaN        Seed                        250000.0   \n",
       "102621                    A           A                       3700000.0   \n",
       "102622                  NaN           B                       2200000.0   \n",
       "102623                    A           A                       8500000.0   \n",
       "102624                  NaN           A                       6000000.0   \n",
       "102625                  NaN        Seed                             NaN   \n",
       "102626                  NaN        Seed                       1000000.0   \n",
       "102627                  NaN           A                       6930000.0   \n",
       "\n",
       "        funding_round_pre_money_valuation_usd  \n",
       "102618                                    NaN  \n",
       "102619                              2000000.0  \n",
       "102620                                    NaN  \n",
       "102621                                    NaN  \n",
       "102622                                    NaN  \n",
       "102623                                    NaN  \n",
       "102624                                    NaN  \n",
       "102625                                    NaN  \n",
       "102626                                    NaN  \n",
       "102627                                    NaN  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "funding_rounds.tail(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>round_number</th>\n",
       "      <th>days_btw_rounds</th>\n",
       "      <th>funding_round_money_raised_usd</th>\n",
       "      <th>funding_round_pre_money_valuation_usd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>102628.000000</td>\n",
       "      <td>50160.000000</td>\n",
       "      <td>8.063000e+04</td>\n",
       "      <td>3.490000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2.127188</td>\n",
       "      <td>474.988975</td>\n",
       "      <td>9.064468e+06</td>\n",
       "      <td>3.558772e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1.635953</td>\n",
       "      <td>458.756568</td>\n",
       "      <td>4.742619e+07</td>\n",
       "      <td>2.790302e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.000000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>190.000000</td>\n",
       "      <td>4.300040e+05</td>\n",
       "      <td>2.000000e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>365.000000</td>\n",
       "      <td>2.000000e+06</td>\n",
       "      <td>5.000000e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>612.000000</td>\n",
       "      <td>7.300000e+06</td>\n",
       "      <td>2.437500e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>13.000000</td>\n",
       "      <td>6665.000000</td>\n",
       "      <td>7.700000e+09</td>\n",
       "      <td>7.150000e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        round_number  days_btw_rounds  funding_round_money_raised_usd  \\\n",
       "count  102628.000000     50160.000000                    8.063000e+04   \n",
       "mean        2.127188       474.988975                    9.064468e+06   \n",
       "std         1.635953       458.756568                    4.742619e+07   \n",
       "min         1.000000         0.000000                    0.000000e+00   \n",
       "25%         1.000000       190.000000                    4.300040e+05   \n",
       "50%         1.000000       365.000000                    2.000000e+06   \n",
       "75%         3.000000       612.000000                    7.300000e+06   \n",
       "max        13.000000      6665.000000                    7.700000e+09   \n",
       "\n",
       "       funding_round_pre_money_valuation_usd  \n",
       "count                           3.490000e+03  \n",
       "mean                            3.558772e+08  \n",
       "std                             2.790302e+09  \n",
       "min                             5.000000e+04  \n",
       "25%                             2.000000e+06  \n",
       "50%                             5.000000e+06  \n",
       "75%                             2.437500e+07  \n",
       "max                             7.150000e+10  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "funding_rounds.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>org_permalink</th>\n",
       "      <th>funding_round_permalink</th>\n",
       "      <th>round_number</th>\n",
       "      <th>funding_round_announced_on</th>\n",
       "      <th>days_btw_rounds</th>\n",
       "      <th>funding_round_type</th>\n",
       "      <th>funding_round_series</th>\n",
       "      <th>clean_round</th>\n",
       "      <th>funding_round_money_raised_usd</th>\n",
       "      <th>funding_round_pre_money_valuation_usd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>93392</th>\n",
       "      <td>uber</td>\n",
       "      <td>fc34230ad1da1702997983a75b8f1d7f</td>\n",
       "      <td>8</td>\n",
       "      <td>12/28/17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>secondary_market</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Post IPO</td>\n",
       "      <td>7.700000e+09</td>\n",
       "      <td>4.030000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93388</th>\n",
       "      <td>uber</td>\n",
       "      <td>3561e0558d4fa07f0dc27a9d380fd0ae</td>\n",
       "      <td>4</td>\n",
       "      <td>6/1/16</td>\n",
       "      <td>110.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>G</td>\n",
       "      <td>Post D</td>\n",
       "      <td>3.500000e+09</td>\n",
       "      <td>5.900000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42522</th>\n",
       "      <td>infor</td>\n",
       "      <td>d39e11a9c575b22749a538878043a9bd</td>\n",
       "      <td>3</td>\n",
       "      <td>11/16/16</td>\n",
       "      <td>1686.0</td>\n",
       "      <td>private_equity</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PE</td>\n",
       "      <td>2.500000e+09</td>\n",
       "      <td>7.500000e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15425</th>\n",
       "      <td>carestream-health</td>\n",
       "      <td>7850c5af2d7229dbef8246a2d8e8cdea</td>\n",
       "      <td>1</td>\n",
       "      <td>6/12/13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>debt_financing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Debt</td>\n",
       "      <td>2.400000e+09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31249</th>\n",
       "      <td>faraday-future</td>\n",
       "      <td>08d8ce45d4e04c39bc53ced70b5ca666</td>\n",
       "      <td>2</td>\n",
       "      <td>12/20/17</td>\n",
       "      <td>134.0</td>\n",
       "      <td>corporate_round</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>2.000000e+09</td>\n",
       "      <td>2.450000e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101646</th>\n",
       "      <td>zebra-technologies</td>\n",
       "      <td>cd35f92a07d13fc19fa196b6b72aecab</td>\n",
       "      <td>2</td>\n",
       "      <td>9/16/14</td>\n",
       "      <td>2329.0</td>\n",
       "      <td>post_ipo_debt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Post IPO</td>\n",
       "      <td>2.000000e+09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56992</th>\n",
       "      <td>mpt-operating-partnership</td>\n",
       "      <td>8b9e29ed9b7644d4459347c2bcc105c2</td>\n",
       "      <td>1</td>\n",
       "      <td>2/2/17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>debt_financing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Debt</td>\n",
       "      <td>1.700000e+09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3132</th>\n",
       "      <td>airbnb</td>\n",
       "      <td>8ab0470b7e24485f60b57ad0378ba13a</td>\n",
       "      <td>5</td>\n",
       "      <td>6/28/15</td>\n",
       "      <td>438.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>E</td>\n",
       "      <td>Post D</td>\n",
       "      <td>1.500000e+09</td>\n",
       "      <td>2.400000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95342</th>\n",
       "      <td>venari-resources</td>\n",
       "      <td>5947e073d9d3bbdbd9714f38258fbfae</td>\n",
       "      <td>1</td>\n",
       "      <td>7/23/14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>private_equity</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PE</td>\n",
       "      <td>1.498515e+09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26325</th>\n",
       "      <td>dupage-medical-group</td>\n",
       "      <td>538a14274a17e33e27cad6567c792d59</td>\n",
       "      <td>2</td>\n",
       "      <td>8/16/17</td>\n",
       "      <td>588.0</td>\n",
       "      <td>private_equity</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PE</td>\n",
       "      <td>1.450000e+09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    org_permalink           funding_round_permalink  \\\n",
       "93392                        uber  fc34230ad1da1702997983a75b8f1d7f   \n",
       "93388                        uber  3561e0558d4fa07f0dc27a9d380fd0ae   \n",
       "42522                       infor  d39e11a9c575b22749a538878043a9bd   \n",
       "15425           carestream-health  7850c5af2d7229dbef8246a2d8e8cdea   \n",
       "31249              faraday-future  08d8ce45d4e04c39bc53ced70b5ca666   \n",
       "101646         zebra-technologies  cd35f92a07d13fc19fa196b6b72aecab   \n",
       "56992   mpt-operating-partnership  8b9e29ed9b7644d4459347c2bcc105c2   \n",
       "3132                       airbnb  8ab0470b7e24485f60b57ad0378ba13a   \n",
       "95342            venari-resources  5947e073d9d3bbdbd9714f38258fbfae   \n",
       "26325        dupage-medical-group  538a14274a17e33e27cad6567c792d59   \n",
       "\n",
       "        round_number funding_round_announced_on  days_btw_rounds  \\\n",
       "93392              8                   12/28/17              0.0   \n",
       "93388              4                     6/1/16            110.0   \n",
       "42522              3                   11/16/16           1686.0   \n",
       "15425              1                    6/12/13              NaN   \n",
       "31249              2                   12/20/17            134.0   \n",
       "101646             2                    9/16/14           2329.0   \n",
       "56992              1                     2/2/17              NaN   \n",
       "3132               5                    6/28/15            438.0   \n",
       "95342              1                    7/23/14              NaN   \n",
       "26325              2                    8/16/17            588.0   \n",
       "\n",
       "       funding_round_type funding_round_series clean_round  \\\n",
       "93392    secondary_market                  NaN    Post IPO   \n",
       "93388             venture                    G      Post D   \n",
       "42522      private_equity                  NaN          PE   \n",
       "15425      debt_financing                  NaN        Debt   \n",
       "31249     corporate_round                  NaN   Corporate   \n",
       "101646      post_ipo_debt                  NaN    Post IPO   \n",
       "56992      debt_financing                  NaN        Debt   \n",
       "3132              venture                    E      Post D   \n",
       "95342      private_equity                  NaN          PE   \n",
       "26325      private_equity                  NaN          PE   \n",
       "\n",
       "        funding_round_money_raised_usd  funding_round_pre_money_valuation_usd  \n",
       "93392                     7.700000e+09                           4.030000e+10  \n",
       "93388                     3.500000e+09                           5.900000e+10  \n",
       "42522                     2.500000e+09                           7.500000e+09  \n",
       "15425                     2.400000e+09                                    NaN  \n",
       "31249                     2.000000e+09                           2.450000e+09  \n",
       "101646                    2.000000e+09                                    NaN  \n",
       "56992                     1.700000e+09                                    NaN  \n",
       "3132                      1.500000e+09                           2.400000e+10  \n",
       "95342                     1.498515e+09                                    NaN  \n",
       "26325                     1.450000e+09                                    NaN  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "funding_rounds.nlargest(10, 'funding_round_money_raised_usd')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>org_permalink</th>\n",
       "      <th>funding_round_permalink</th>\n",
       "      <th>round_number</th>\n",
       "      <th>funding_round_announced_on</th>\n",
       "      <th>days_btw_rounds</th>\n",
       "      <th>funding_round_type</th>\n",
       "      <th>funding_round_series</th>\n",
       "      <th>clean_round</th>\n",
       "      <th>funding_round_money_raised_usd</th>\n",
       "      <th>funding_round_pre_money_valuation_usd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>93394</th>\n",
       "      <td>uber</td>\n",
       "      <td>be7136e2486e4ad2a909b7da62e6c029</td>\n",
       "      <td>10</td>\n",
       "      <td>8/27/18</td>\n",
       "      <td>96.0</td>\n",
       "      <td>corporate_round</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>5.000000e+08</td>\n",
       "      <td>7.150000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93391</th>\n",
       "      <td>uber</td>\n",
       "      <td>ca0a4dde120d4dec9520cf7c48ed17ae</td>\n",
       "      <td>7</td>\n",
       "      <td>12/28/17</td>\n",
       "      <td>253.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.250000e+09</td>\n",
       "      <td>6.880000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93388</th>\n",
       "      <td>uber</td>\n",
       "      <td>3561e0558d4fa07f0dc27a9d380fd0ae</td>\n",
       "      <td>4</td>\n",
       "      <td>6/1/16</td>\n",
       "      <td>110.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>G</td>\n",
       "      <td>Post D</td>\n",
       "      <td>3.500000e+09</td>\n",
       "      <td>5.900000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93393</th>\n",
       "      <td>uber</td>\n",
       "      <td>6dae3de6bded4eaeaf37ad588ab0eee9</td>\n",
       "      <td>9</td>\n",
       "      <td>5/23/18</td>\n",
       "      <td>146.0</td>\n",
       "      <td>secondary_market</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Post IPO</td>\n",
       "      <td>6.000000e+08</td>\n",
       "      <td>5.600000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93385</th>\n",
       "      <td>uber</td>\n",
       "      <td>c738765257ab10e721f1a02d5af54681</td>\n",
       "      <td>1</td>\n",
       "      <td>7/31/15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>venture</td>\n",
       "      <td>F</td>\n",
       "      <td>Post D</td>\n",
       "      <td>1.000000e+09</td>\n",
       "      <td>5.000000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93392</th>\n",
       "      <td>uber</td>\n",
       "      <td>fc34230ad1da1702997983a75b8f1d7f</td>\n",
       "      <td>8</td>\n",
       "      <td>12/28/17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>secondary_market</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Post IPO</td>\n",
       "      <td>7.700000e+09</td>\n",
       "      <td>4.030000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3137</th>\n",
       "      <td>airbnb</td>\n",
       "      <td>e707522703416c958a9256485dc239a3</td>\n",
       "      <td>10</td>\n",
       "      <td>3/9/17</td>\n",
       "      <td>143.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>F</td>\n",
       "      <td>Post D</td>\n",
       "      <td>4.480000e+08</td>\n",
       "      <td>3.000000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3135</th>\n",
       "      <td>airbnb</td>\n",
       "      <td>b7e02f8303ee22acff0db6b477a781be</td>\n",
       "      <td>8</td>\n",
       "      <td>9/22/16</td>\n",
       "      <td>98.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>F</td>\n",
       "      <td>Post D</td>\n",
       "      <td>5.554621e+08</td>\n",
       "      <td>2.940000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3133</th>\n",
       "      <td>airbnb</td>\n",
       "      <td>47de508203de515a569130787dc50dbe</td>\n",
       "      <td>6</td>\n",
       "      <td>11/20/15</td>\n",
       "      <td>145.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>E</td>\n",
       "      <td>Post D</td>\n",
       "      <td>1.000000e+08</td>\n",
       "      <td>2.450000e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3132</th>\n",
       "      <td>airbnb</td>\n",
       "      <td>8ab0470b7e24485f60b57ad0378ba13a</td>\n",
       "      <td>5</td>\n",
       "      <td>6/28/15</td>\n",
       "      <td>438.0</td>\n",
       "      <td>venture</td>\n",
       "      <td>E</td>\n",
       "      <td>Post D</td>\n",
       "      <td>1.500000e+09</td>\n",
       "      <td>2.400000e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      org_permalink           funding_round_permalink  round_number  \\\n",
       "93394          uber  be7136e2486e4ad2a909b7da62e6c029            10   \n",
       "93391          uber  ca0a4dde120d4dec9520cf7c48ed17ae             7   \n",
       "93388          uber  3561e0558d4fa07f0dc27a9d380fd0ae             4   \n",
       "93393          uber  6dae3de6bded4eaeaf37ad588ab0eee9             9   \n",
       "93385          uber  c738765257ab10e721f1a02d5af54681             1   \n",
       "93392          uber  fc34230ad1da1702997983a75b8f1d7f             8   \n",
       "3137         airbnb  e707522703416c958a9256485dc239a3            10   \n",
       "3135         airbnb  b7e02f8303ee22acff0db6b477a781be             8   \n",
       "3133         airbnb  47de508203de515a569130787dc50dbe             6   \n",
       "3132         airbnb  8ab0470b7e24485f60b57ad0378ba13a             5   \n",
       "\n",
       "      funding_round_announced_on  days_btw_rounds funding_round_type  \\\n",
       "93394                    8/27/18             96.0    corporate_round   \n",
       "93391                   12/28/17            253.0            venture   \n",
       "93388                     6/1/16            110.0            venture   \n",
       "93393                    5/23/18            146.0   secondary_market   \n",
       "93385                    7/31/15              NaN            venture   \n",
       "93392                   12/28/17              0.0   secondary_market   \n",
       "3137                      3/9/17            143.0            venture   \n",
       "3135                     9/22/16             98.0            venture   \n",
       "3133                    11/20/15            145.0            venture   \n",
       "3132                     6/28/15            438.0            venture   \n",
       "\n",
       "      funding_round_series clean_round  funding_round_money_raised_usd  \\\n",
       "93394                  NaN   Corporate                    5.000000e+08   \n",
       "93391                  NaN         NaN                    1.250000e+09   \n",
       "93388                    G      Post D                    3.500000e+09   \n",
       "93393                  NaN    Post IPO                    6.000000e+08   \n",
       "93385                    F      Post D                    1.000000e+09   \n",
       "93392                  NaN    Post IPO                    7.700000e+09   \n",
       "3137                     F      Post D                    4.480000e+08   \n",
       "3135                     F      Post D                    5.554621e+08   \n",
       "3133                     E      Post D                    1.000000e+08   \n",
       "3132                     E      Post D                    1.500000e+09   \n",
       "\n",
       "       funding_round_pre_money_valuation_usd  \n",
       "93394                           7.150000e+10  \n",
       "93391                           6.880000e+10  \n",
       "93388                           5.900000e+10  \n",
       "93393                           5.600000e+10  \n",
       "93385                           5.000000e+10  \n",
       "93392                           4.030000e+10  \n",
       "3137                            3.000000e+10  \n",
       "3135                            2.940000e+10  \n",
       "3133                            2.450000e+10  \n",
       "3132                            2.400000e+10  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "funding_rounds.nlargest(10, 'funding_round_pre_money_valuation_usd')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "org_permalink                                0\n",
       "funding_round_permalink                      0\n",
       "round_number                                 0\n",
       "funding_round_announced_on                   0\n",
       "days_btw_rounds                          52468\n",
       "funding_round_type                           0\n",
       "funding_round_series                     75781\n",
       "clean_round                               5049\n",
       "funding_round_money_raised_usd           21998\n",
       "funding_round_pre_money_valuation_usd    99138\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "funding_rounds.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['org_permalink', 'funding_round_permalink', 'round_number',\n",
       "       'funding_round_announced_on', 'days_btw_rounds', 'funding_round_type',\n",
       "       'funding_round_series', 'clean_round', 'funding_round_money_raised_usd',\n",
       "       'funding_round_pre_money_valuation_usd'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "funding_rounds.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}