CC.1.Sort.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Goal: Find (two) best candidates in each industry"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 207,
   "metadata": {},
   "outputs": [],
   "source": [
    "%store -r df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### What criteria have a positive impact on being a suitable/good startup?\n",
    "\n",
    "- Cofounder is already Investor: +\n",
    "- Investor is None: +\n",
    "- Valuation > 20 Mio.: +\n",
    "- Founder contains female: +\n",
    "- Founder is serial: (+)\n",
    "- Revenue is increasing (described by percentage 0 to 1): (+)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Filter HQ Country to Nordics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 208,
   "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>index</th>\n",
       "      <th>NAME</th>\n",
       "      <th>PROFILE URL</th>\n",
       "      <th>WEBSITE</th>\n",
       "      <th>HQ REGION</th>\n",
       "      <th>HQ COUNTRY</th>\n",
       "      <th>HQ CITY</th>\n",
       "      <th>INVESTORS</th>\n",
       "      <th>EACH INVESTOR TYPES</th>\n",
       "      <th>LEAD INVESTORS</th>\n",
       "      <th>...</th>\n",
       "      <th>FUNDING UP UNTIL VALUATION DATE</th>\n",
       "      <th>AVG REVENUE</th>\n",
       "      <th>AVG REVENUE GROWTH</th>\n",
       "      <th>AVG EMPLOYEE GROWTH</th>\n",
       "      <th>VALUATION TO FUNDING RATIO</th>\n",
       "      <th>FEMALE FOUNDER</th>\n",
       "      <th>MALE FOUNDER</th>\n",
       "      <th>UNKNOWN FOUNDER</th>\n",
       "      <th>FOUNDER SERIAL</th>\n",
       "      <th>MIXED TEAM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Let's Deal</td>\n",
       "      <td>https://app.dealroom.co/companies/let_s_deal</td>\n",
       "      <td>http://www.letsdeal.se</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Schibsted Growth;Sweet Deal</td>\n",
       "      <td>corporate_venture_fund;corporate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>11600000.0</td>\n",
       "      <td>0.919323</td>\n",
       "      <td>0.924211</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Disior Oy</td>\n",
       "      <td>https://app.dealroom.co/companies/disior_oy</td>\n",
       "      <td>http://www.disior.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Finland</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>Maki.vc;Tesi;Maria 01;Paragon 28</td>\n",
       "      <td>venture_capital;private_equity,venture_capital...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2.603584</td>\n",
       "      <td>375000.0</td>\n",
       "      <td>1.357209</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.264730</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Furhat Robotics</td>\n",
       "      <td>https://app.dealroom.co/companies/furhat_robotics</td>\n",
       "      <td>http://www.furhatrobotics.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>Balderton Capital;LocalGlobe;European Innovati...</td>\n",
       "      <td>venture_capital;venture_capital;government;acc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2.556600</td>\n",
       "      <td>1324250.0</td>\n",
       "      <td>1.955805</td>\n",
       "      <td>1.087380</td>\n",
       "      <td>4.889307</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Minerva</td>\n",
       "      <td>https://app.dealroom.co/companies/minerva_2</td>\n",
       "      <td>http://minerva-plm.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>Viby</td>\n",
       "      <td>Learn Capital;Aras</td>\n",
       "      <td>venture_capital;corporate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.092608</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Reblocs</td>\n",
       "      <td>https://app.dealroom.co/companies/reblocs</td>\n",
       "      <td>https://reblocs.co</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8693</th>\n",
       "      <td>8889</td>\n",
       "      <td>MNy Arkitekter Ab</td>\n",
       "      <td>https://app.dealroom.co/companies/mny_arkitekt...</td>\n",
       "      <td>http://mnyark.fi</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Finland</td>\n",
       "      <td>Hattula</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8694</th>\n",
       "      <td>8890</td>\n",
       "      <td>TREX Regional Exchanges</td>\n",
       "      <td>https://app.dealroom.co/companies/trex_regiona...</td>\n",
       "      <td>http://trex.fi</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Finland</td>\n",
       "      <td>Tampere</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8695</th>\n",
       "      <td>8891</td>\n",
       "      <td>SCATMAN</td>\n",
       "      <td>https://app.dealroom.co/companies/scatman</td>\n",
       "      <td>http://scatman.fi</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Finland</td>\n",
       "      <td>Oulu</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8696</th>\n",
       "      <td>8892</td>\n",
       "      <td>Trumo Finance</td>\n",
       "      <td>https://app.dealroom.co/companies/trumo_finance</td>\n",
       "      <td>http://trumo.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Finland</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8697</th>\n",
       "      <td>8893</td>\n",
       "      <td>Vogon-IT</td>\n",
       "      <td>https://app.dealroom.co/companies/vogon_it</td>\n",
       "      <td>http://vogon-it.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Finland</td>\n",
       "      <td>Ulvila</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8698 rows × 92 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      index                     NAME  \\\n",
       "0         0               Let's Deal   \n",
       "1         1                Disior Oy   \n",
       "2         2          Furhat Robotics   \n",
       "3         3                  Minerva   \n",
       "4         4                  Reblocs   \n",
       "...     ...                      ...   \n",
       "8693   8889        MNy Arkitekter Ab   \n",
       "8694   8890  TREX Regional Exchanges   \n",
       "8695   8891                  SCATMAN   \n",
       "8696   8892            Trumo Finance   \n",
       "8697   8893                 Vogon-IT   \n",
       "\n",
       "                                            PROFILE URL  \\\n",
       "0          https://app.dealroom.co/companies/let_s_deal   \n",
       "1           https://app.dealroom.co/companies/disior_oy   \n",
       "2     https://app.dealroom.co/companies/furhat_robotics   \n",
       "3           https://app.dealroom.co/companies/minerva_2   \n",
       "4             https://app.dealroom.co/companies/reblocs   \n",
       "...                                                 ...   \n",
       "8693  https://app.dealroom.co/companies/mny_arkitekt...   \n",
       "8694  https://app.dealroom.co/companies/trex_regiona...   \n",
       "8695          https://app.dealroom.co/companies/scatman   \n",
       "8696    https://app.dealroom.co/companies/trumo_finance   \n",
       "8697         https://app.dealroom.co/companies/vogon_it   \n",
       "\n",
       "                            WEBSITE HQ REGION HQ COUNTRY    HQ CITY  \\\n",
       "0            http://www.letsdeal.se    Europe     Sweden        NaN   \n",
       "1             http://www.disior.com    Europe    Finland   Helsinki   \n",
       "2     http://www.furhatrobotics.com    Europe     Sweden  Stockholm   \n",
       "3            http://minerva-plm.com    Europe    Denmark       Viby   \n",
       "4                https://reblocs.co    Europe     Sweden  Stockholm   \n",
       "...                             ...       ...        ...        ...   \n",
       "8693               http://mnyark.fi    Europe    Finland    Hattula   \n",
       "8694                 http://trex.fi    Europe    Finland    Tampere   \n",
       "8695              http://scatman.fi    Europe    Finland       Oulu   \n",
       "8696               http://trumo.com    Europe    Finland   Helsinki   \n",
       "8697            http://vogon-it.com    Europe    Finland     Ulvila   \n",
       "\n",
       "                                              INVESTORS  \\\n",
       "0                           Schibsted Growth;Sweet Deal   \n",
       "1                      Maki.vc;Tesi;Maria 01;Paragon 28   \n",
       "2     Balderton Capital;LocalGlobe;European Innovati...   \n",
       "3                                    Learn Capital;Aras   \n",
       "4                                                   NaN   \n",
       "...                                                 ...   \n",
       "8693                                                NaN   \n",
       "8694                                                NaN   \n",
       "8695                                                NaN   \n",
       "8696                                                NaN   \n",
       "8697                                                NaN   \n",
       "\n",
       "                                    EACH INVESTOR TYPES  LEAD INVESTORS  ...  \\\n",
       "0                      corporate_venture_fund;corporate             NaN  ...   \n",
       "1     venture_capital;private_equity,venture_capital...             NaN  ...   \n",
       "2     venture_capital;venture_capital;government;acc...             NaN  ...   \n",
       "3                             venture_capital;corporate             NaN  ...   \n",
       "4                                                   NaN             NaN  ...   \n",
       "...                                                 ...             ...  ...   \n",
       "8693                                                NaN             NaN  ...   \n",
       "8694                                                NaN             NaN  ...   \n",
       "8695                                                NaN             NaN  ...   \n",
       "8696                                                NaN             NaN  ...   \n",
       "8697                                                NaN             NaN  ...   \n",
       "\n",
       "      FUNDING UP UNTIL VALUATION DATE  AVG REVENUE AVG REVENUE GROWTH  \\\n",
       "0                            0.000000   11600000.0           0.919323   \n",
       "1                            2.603584     375000.0           1.357209   \n",
       "2                            2.556600    1324250.0           1.955805   \n",
       "3                            0.000000          0.0           0.000000   \n",
       "4                            0.000000          0.0           0.000000   \n",
       "...                               ...          ...                ...   \n",
       "8693                         0.000000          0.0           0.000000   \n",
       "8694                         0.000000          0.0           0.000000   \n",
       "8695                         0.000000          0.0           0.000000   \n",
       "8696                         0.000000          0.0           0.000000   \n",
       "8697                         0.000000          0.0           0.000000   \n",
       "\n",
       "      AVG EMPLOYEE GROWTH VALUATION TO FUNDING RATIO FEMALE FOUNDER  \\\n",
       "0                0.924211                   0.000000          False   \n",
       "1                0.000000                   3.264730           True   \n",
       "2                1.087380                   4.889307          False   \n",
       "3                1.092608                   0.000000          False   \n",
       "4                0.000000                   0.000000          False   \n",
       "...                   ...                        ...            ...   \n",
       "8693             0.000000                   0.000000          False   \n",
       "8694             0.000000                   0.000000          False   \n",
       "8695             0.000000                   0.000000          False   \n",
       "8696             0.000000                   0.000000          False   \n",
       "8697             0.000000                   0.000000          False   \n",
       "\n",
       "      MALE FOUNDER UNKNOWN FOUNDER FOUNDER SERIAL MIXED TEAM  \n",
       "0            False            True            0.5    Unknown  \n",
       "1             True           False          False       True  \n",
       "2             True           False          False      False  \n",
       "3            False            True          False    Unknown  \n",
       "4            False            True            0.5    Unknown  \n",
       "...            ...             ...            ...        ...  \n",
       "8693         False            True            0.5    Unknown  \n",
       "8694         False            True            0.5    Unknown  \n",
       "8695         False            True            0.5    Unknown  \n",
       "8696         False            True            0.5    Unknown  \n",
       "8697         False            True            0.5    Unknown  \n",
       "\n",
       "[8698 rows x 92 columns]"
      ]
     },
     "execution_count": 208,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countries = df['HQ COUNTRY'].unique()\n",
    "nordics = ['Sweden', 'Norway', 'Iceland', 'Denmark', 'Finland']\n",
    "df = df[df['HQ COUNTRY'].isin(nordics)]\n",
    "\n",
    "df.reset_index()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Delete unwanted growth stages:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 209,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(7098, 91)"
      ]
     },
     "execution_count": 209,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "neglected_growth_stages = ['late growth stage', 'not meaningful']\n",
    "\n",
    "indexrows = df[df['GROWTH STAGE'].isin(neglected_growth_stages)].index\n",
    "\n",
    "df = df.drop(indexrows)\n",
    "df.reset_index()\n",
    "df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Neglect certain GROWTH STAGE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 210,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5877, 91)"
      ]
     },
     "execution_count": 210,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "neglected_last_rounds = ['ACQUISITION',\n",
    "       'LATE VC', 'IPO', 'MERGER', 'POST IPO DEBT', 'POST IPO EQUITY',\n",
    "       'GROWTH EQUITY NON VC', 'GROWTH EQUITY VC',\n",
    "       'POST IPO CONVERTIBLE', 'SERIES C', 'SERIES B', 'SERIES D']\n",
    "\n",
    "indexrowsLR = df[df['LAST ROUND'].isin(neglected_last_rounds)].index\n",
    "\n",
    "df = df.drop(indexrowsLR)\n",
    "df.reset_index()\n",
    "df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Neglect LAST ROUND before 01/2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 211,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4086, 91)"
      ]
     },
     "execution_count": 211,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sort out for last funding dates older than jan 2018\n",
    "indexLFD = df[df['LAST FUNDING DATE'] < '2018-01-01'].index\n",
    "\n",
    "df = df.drop(indexLFD)\n",
    "df.reset_index()\n",
    "df.shape\n",
    "\n",
    "#df['LAST FUNDING DATE'].unique()\n",
    "#Reduces to 4086"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Neglect zero value records"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 212,
   "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>index</th>\n",
       "      <th>NAME</th>\n",
       "      <th>PROFILE URL</th>\n",
       "      <th>WEBSITE</th>\n",
       "      <th>HQ REGION</th>\n",
       "      <th>HQ COUNTRY</th>\n",
       "      <th>HQ CITY</th>\n",
       "      <th>INVESTORS</th>\n",
       "      <th>EACH INVESTOR TYPES</th>\n",
       "      <th>LEAD INVESTORS</th>\n",
       "      <th>...</th>\n",
       "      <th>FUNDING UP UNTIL VALUATION DATE</th>\n",
       "      <th>AVG REVENUE</th>\n",
       "      <th>AVG REVENUE GROWTH</th>\n",
       "      <th>AVG EMPLOYEE GROWTH</th>\n",
       "      <th>VALUATION TO FUNDING RATIO</th>\n",
       "      <th>FEMALE FOUNDER</th>\n",
       "      <th>MALE FOUNDER</th>\n",
       "      <th>UNKNOWN FOUNDER</th>\n",
       "      <th>FOUNDER SERIAL</th>\n",
       "      <th>MIXED TEAM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>Furhat Robotics</td>\n",
       "      <td>https://app.dealroom.co/companies/furhat_robotics</td>\n",
       "      <td>http://www.furhatrobotics.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>Balderton Capital;LocalGlobe;European Innovati...</td>\n",
       "      <td>venture_capital;venture_capital;government;acc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2.556600</td>\n",
       "      <td>1324250.0</td>\n",
       "      <td>1.955805</td>\n",
       "      <td>1.08738</td>\n",
       "      <td>4.889307</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6</td>\n",
       "      <td>Nowocoat</td>\n",
       "      <td>https://app.dealroom.co/companies/nowocoat</td>\n",
       "      <td>https://nowocoat.dk</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>Kolding</td>\n",
       "      <td>Waterland Private Equity</td>\n",
       "      <td>private_equity,venture_capital</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8</td>\n",
       "      <td>HJN Sverige</td>\n",
       "      <td>https://app.dealroom.co/companies/hjn_sverige</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Daniel Ek</td>\n",
       "      <td>angel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0.5</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9</td>\n",
       "      <td>Spectaflow</td>\n",
       "      <td>https://app.dealroom.co/companies/spectaflow</td>\n",
       "      <td>http://spectaflow.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Iceland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Frumtak;Icelandic New Business Venture Fund;Gr...</td>\n",
       "      <td>venture_capital;venture_capital;angel;angel;angel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.900000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14</td>\n",
       "      <td>Vignita</td>\n",
       "      <td>https://app.dealroom.co/companies/vignita</td>\n",
       "      <td>http://vignita.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Norway</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Link Capital;North venture;Penny Venture;Adler...</td>\n",
       "      <td>venture_capital;venture_capital;corporate;corp...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.747115</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>4.416988</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2349</th>\n",
       "      <td>8692</td>\n",
       "      <td>Clauslevin</td>\n",
       "      <td>https://app.dealroom.co/companies/clauslevin</td>\n",
       "      <td>http://clauslevin.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2350</th>\n",
       "      <td>8696</td>\n",
       "      <td>Beaubi</td>\n",
       "      <td>https://app.dealroom.co/companies/beaubi</td>\n",
       "      <td>http://beaubi.se</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2351</th>\n",
       "      <td>8700</td>\n",
       "      <td>Napper</td>\n",
       "      <td>https://app.dealroom.co/companies/napper</td>\n",
       "      <td>http://getnapper.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Unknown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2352</th>\n",
       "      <td>8742</td>\n",
       "      <td>Siminbooks</td>\n",
       "      <td>https://app.dealroom.co/companies/siminbooks</td>\n",
       "      <td>http://siminbooks.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Skövde</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2353</th>\n",
       "      <td>8747</td>\n",
       "      <td>RemoteCamp.io</td>\n",
       "      <td>https://app.dealroom.co/companies/remotecamp_io</td>\n",
       "      <td>http://remotecamp.io</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>Copenhagen</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2354 rows × 92 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      index             NAME  \\\n",
       "0         2  Furhat Robotics   \n",
       "1         6         Nowocoat   \n",
       "2         8      HJN Sverige   \n",
       "3         9       Spectaflow   \n",
       "4        14          Vignita   \n",
       "...     ...              ...   \n",
       "2349   8692       Clauslevin   \n",
       "2350   8696           Beaubi   \n",
       "2351   8700           Napper   \n",
       "2352   8742       Siminbooks   \n",
       "2353   8747    RemoteCamp.io   \n",
       "\n",
       "                                            PROFILE URL  \\\n",
       "0     https://app.dealroom.co/companies/furhat_robotics   \n",
       "1            https://app.dealroom.co/companies/nowocoat   \n",
       "2         https://app.dealroom.co/companies/hjn_sverige   \n",
       "3          https://app.dealroom.co/companies/spectaflow   \n",
       "4             https://app.dealroom.co/companies/vignita   \n",
       "...                                                 ...   \n",
       "2349       https://app.dealroom.co/companies/clauslevin   \n",
       "2350           https://app.dealroom.co/companies/beaubi   \n",
       "2351           https://app.dealroom.co/companies/napper   \n",
       "2352       https://app.dealroom.co/companies/siminbooks   \n",
       "2353    https://app.dealroom.co/companies/remotecamp_io   \n",
       "\n",
       "                            WEBSITE HQ REGION HQ COUNTRY     HQ CITY  \\\n",
       "0     http://www.furhatrobotics.com    Europe     Sweden   Stockholm   \n",
       "1               https://nowocoat.dk    Europe    Denmark     Kolding   \n",
       "2                               NaN    Europe     Sweden         NaN   \n",
       "3             http://spectaflow.com    Europe    Iceland         NaN   \n",
       "4                http://vignita.com    Europe     Norway         NaN   \n",
       "...                             ...       ...        ...         ...   \n",
       "2349          http://clauslevin.com    Europe    Denmark         NaN   \n",
       "2350               http://beaubi.se    Europe     Sweden   Stockholm   \n",
       "2351           http://getnapper.com    Europe     Sweden   Stockholm   \n",
       "2352          http://siminbooks.com    Europe     Sweden      Skövde   \n",
       "2353           http://remotecamp.io    Europe    Denmark  Copenhagen   \n",
       "\n",
       "                                              INVESTORS  \\\n",
       "0     Balderton Capital;LocalGlobe;European Innovati...   \n",
       "1                              Waterland Private Equity   \n",
       "2                                             Daniel Ek   \n",
       "3     Frumtak;Icelandic New Business Venture Fund;Gr...   \n",
       "4     Link Capital;North venture;Penny Venture;Adler...   \n",
       "...                                                 ...   \n",
       "2349                                                NaN   \n",
       "2350                                                NaN   \n",
       "2351                                                NaN   \n",
       "2352                                                NaN   \n",
       "2353                                                NaN   \n",
       "\n",
       "                                    EACH INVESTOR TYPES  LEAD INVESTORS  ...  \\\n",
       "0     venture_capital;venture_capital;government;acc...             NaN  ...   \n",
       "1                        private_equity,venture_capital             NaN  ...   \n",
       "2                                                 angel             NaN  ...   \n",
       "3     venture_capital;venture_capital;angel;angel;angel             NaN  ...   \n",
       "4     venture_capital;venture_capital;corporate;corp...             NaN  ...   \n",
       "...                                                 ...             ...  ...   \n",
       "2349                                                NaN             NaN  ...   \n",
       "2350                                                NaN             NaN  ...   \n",
       "2351                                                NaN             NaN  ...   \n",
       "2352                                                NaN             NaN  ...   \n",
       "2353                                                NaN             NaN  ...   \n",
       "\n",
       "      FUNDING UP UNTIL VALUATION DATE  AVG REVENUE AVG REVENUE GROWTH  \\\n",
       "0                            2.556600    1324250.0           1.955805   \n",
       "1                            0.000000          0.0           0.000000   \n",
       "2                            0.000000          0.0           0.000000   \n",
       "3                            1.900000          0.0           0.000000   \n",
       "4                            0.747115          0.0           0.000000   \n",
       "...                               ...          ...                ...   \n",
       "2349                         0.000000          0.0           0.000000   \n",
       "2350                         0.000000          0.0           0.000000   \n",
       "2351                         0.000000          0.0           0.000000   \n",
       "2352                         0.000000          0.0           0.000000   \n",
       "2353                         0.000000          0.0           0.000000   \n",
       "\n",
       "      AVG EMPLOYEE GROWTH VALUATION TO FUNDING RATIO FEMALE FOUNDER  \\\n",
       "0                 1.08738                   4.889307          False   \n",
       "1                 0.00000                   0.000000          False   \n",
       "2                 0.00000                   0.000000          False   \n",
       "3                 0.00000                   5.000000          False   \n",
       "4                 0.00000                   4.416988          False   \n",
       "...                   ...                        ...            ...   \n",
       "2349              0.00000                   0.000000          False   \n",
       "2350              0.00000                   0.000000           True   \n",
       "2351              0.00000                   0.000000          False   \n",
       "2352              0.00000                   0.000000          False   \n",
       "2353              0.00000                   0.000000          False   \n",
       "\n",
       "      MALE FOUNDER UNKNOWN FOUNDER FOUNDER SERIAL MIXED TEAM  \n",
       "0             True           False          False      False  \n",
       "1            False            True            0.5    Unknown  \n",
       "2            False            True            0.5    Unknown  \n",
       "3             True            True          False    Unknown  \n",
       "4             True           False           True      False  \n",
       "...            ...             ...            ...        ...  \n",
       "2349          True           False          False      False  \n",
       "2350          True           False          False       True  \n",
       "2351          True            True          False    Unknown  \n",
       "2352          True           False          False      False  \n",
       "2353          True           False           True      False  \n",
       "\n",
       "[2354 rows x 92 columns]"
      ]
     },
     "execution_count": 212,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Check if LAST FUNDING DATE, FIRST FUNDING DATE, SEED YEAR, REVENUE AS LIST, VALUATION DATE IS ZERO, FOUNDERS GENDER\n",
    "\n",
    "index_of_null_records = df[(df['LAST FUNDING DATE'].isnull() & df['FIRST FUNDING DATE'].isnull() & df['SEED YEAR'].isnull()& df['VALUATION DATE'].isnull()  & df['FOUNDERS GENDERS'].isnull())].index\n",
    "\n",
    "df = df.drop(index_of_null_records)\n",
    "df.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 213,
   "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>index</th>\n",
       "      <th>NAME</th>\n",
       "      <th>PROFILE URL</th>\n",
       "      <th>WEBSITE</th>\n",
       "      <th>HQ REGION</th>\n",
       "      <th>HQ COUNTRY</th>\n",
       "      <th>HQ CITY</th>\n",
       "      <th>INVESTORS</th>\n",
       "      <th>EACH INVESTOR TYPES</th>\n",
       "      <th>LEAD INVESTORS</th>\n",
       "      <th>...</th>\n",
       "      <th>FUNDING UP UNTIL VALUATION DATE</th>\n",
       "      <th>AVG REVENUE</th>\n",
       "      <th>AVG REVENUE GROWTH</th>\n",
       "      <th>AVG EMPLOYEE GROWTH</th>\n",
       "      <th>VALUATION TO FUNDING RATIO</th>\n",
       "      <th>FEMALE FOUNDER</th>\n",
       "      <th>MALE FOUNDER</th>\n",
       "      <th>UNKNOWN FOUNDER</th>\n",
       "      <th>FOUNDER SERIAL</th>\n",
       "      <th>MIXED TEAM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21</td>\n",
       "      <td>Advicera</td>\n",
       "      <td>https://app.dealroom.co/companies/advicera</td>\n",
       "      <td>http://advicera.org</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Finland</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>Ukrainian Startup Fund</td>\n",
       "      <td>angel_fund</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>117</td>\n",
       "      <td>Alvar Pet</td>\n",
       "      <td>https://app.dealroom.co/companies/alvar_pet</td>\n",
       "      <td>http://www.alvarpet.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Finland</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>Maria 01;Maki.vc;Ali Omar;Tesi</td>\n",
       "      <td>accelerator;venture_capital;angel;private_equi...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.671993</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.990443</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>140</td>\n",
       "      <td>Blisser</td>\n",
       "      <td>https://app.dealroom.co/companies/blisser</td>\n",
       "      <td>http://blisser.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>Justin Mateen;Michael Heller</td>\n",
       "      <td>angel;angel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.473514</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.918194</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>147</td>\n",
       "      <td>Sprint Bioscience</td>\n",
       "      <td>https://app.dealroom.co/companies/sprint_biosc...</td>\n",
       "      <td>http://sprintbioscience.com</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Flemingsberg</td>\n",
       "      <td>Almi Invest</td>\n",
       "      <td>venture_capital</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2.425354</td>\n",
       "      <td>3228000.0</td>\n",
       "      <td>0.890205</td>\n",
       "      <td>1.065757</td>\n",
       "      <td>46.384989</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>149</td>\n",
       "      <td>Cogo</td>\n",
       "      <td>https://app.dealroom.co/companies/cogo_1_1</td>\n",
       "      <td>http://cogoapp.io</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>Copenhagen</td>\n",
       "      <td>PreSeed Ventures;Pia Vemmelund;Jens Willumsen;...</td>\n",
       "      <td>venture_capital;angel;angel;angel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.131993</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.416988</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>8070</td>\n",
       "      <td>Wisebee Group AB</td>\n",
       "      <td>https://app.dealroom.co/companies/wisebee_grou...</td>\n",
       "      <td>http://wisebee.se</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>8286</td>\n",
       "      <td>The WOW Closet</td>\n",
       "      <td>https://app.dealroom.co/companies/the_wow_closet</td>\n",
       "      <td>http://thewowcloset.se</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>8420</td>\n",
       "      <td>Healthmakers Technologies AB</td>\n",
       "      <td>https://app.dealroom.co/companies/healthmakers...</td>\n",
       "      <td>http://kuravard.se</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Gothenburg</td>\n",
       "      <td>GU Ventures AB</td>\n",
       "      <td>accelerator</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>8488</td>\n",
       "      <td>Agronomics</td>\n",
       "      <td>https://app.dealroom.co/companies/agronomics_1</td>\n",
       "      <td>http://agronomics.se</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>8696</td>\n",
       "      <td>Beaubi</td>\n",
       "      <td>https://app.dealroom.co/companies/beaubi</td>\n",
       "      <td>http://beaubi.se</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>244 rows × 92 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     index                          NAME  \\\n",
       "0       21                      Advicera   \n",
       "1      117                     Alvar Pet   \n",
       "2      140                       Blisser   \n",
       "3      147             Sprint Bioscience   \n",
       "4      149                          Cogo   \n",
       "..     ...                           ...   \n",
       "239   8070              Wisebee Group AB   \n",
       "240   8286                The WOW Closet   \n",
       "241   8420  Healthmakers Technologies AB   \n",
       "242   8488                    Agronomics   \n",
       "243   8696                        Beaubi   \n",
       "\n",
       "                                           PROFILE URL  \\\n",
       "0           https://app.dealroom.co/companies/advicera   \n",
       "1          https://app.dealroom.co/companies/alvar_pet   \n",
       "2            https://app.dealroom.co/companies/blisser   \n",
       "3    https://app.dealroom.co/companies/sprint_biosc...   \n",
       "4           https://app.dealroom.co/companies/cogo_1_1   \n",
       "..                                                 ...   \n",
       "239  https://app.dealroom.co/companies/wisebee_grou...   \n",
       "240   https://app.dealroom.co/companies/the_wow_closet   \n",
       "241  https://app.dealroom.co/companies/healthmakers...   \n",
       "242     https://app.dealroom.co/companies/agronomics_1   \n",
       "243           https://app.dealroom.co/companies/beaubi   \n",
       "\n",
       "                         WEBSITE HQ REGION HQ COUNTRY       HQ CITY  \\\n",
       "0            http://advicera.org    Europe    Finland      Helsinki   \n",
       "1        http://www.alvarpet.com    Europe    Finland      Helsinki   \n",
       "2             http://blisser.com    Europe     Sweden     Stockholm   \n",
       "3    http://sprintbioscience.com    Europe     Sweden  Flemingsberg   \n",
       "4              http://cogoapp.io    Europe    Denmark    Copenhagen   \n",
       "..                           ...       ...        ...           ...   \n",
       "239            http://wisebee.se    Europe     Sweden     Stockholm   \n",
       "240       http://thewowcloset.se    Europe     Sweden     Stockholm   \n",
       "241           http://kuravard.se    Europe     Sweden    Gothenburg   \n",
       "242         http://agronomics.se    Europe     Sweden     Stockholm   \n",
       "243             http://beaubi.se    Europe     Sweden     Stockholm   \n",
       "\n",
       "                                             INVESTORS  \\\n",
       "0                               Ukrainian Startup Fund   \n",
       "1                       Maria 01;Maki.vc;Ali Omar;Tesi   \n",
       "2                         Justin Mateen;Michael Heller   \n",
       "3                                          Almi Invest   \n",
       "4    PreSeed Ventures;Pia Vemmelund;Jens Willumsen;...   \n",
       "..                                                 ...   \n",
       "239                                                NaN   \n",
       "240                                                NaN   \n",
       "241                                     GU Ventures AB   \n",
       "242                                                NaN   \n",
       "243                                                NaN   \n",
       "\n",
       "                                   EACH INVESTOR TYPES  LEAD INVESTORS  ...  \\\n",
       "0                                           angel_fund             NaN  ...   \n",
       "1    accelerator;venture_capital;angel;private_equi...             NaN  ...   \n",
       "2                                          angel;angel             NaN  ...   \n",
       "3                                      venture_capital             NaN  ...   \n",
       "4                    venture_capital;angel;angel;angel             NaN  ...   \n",
       "..                                                 ...             ...  ...   \n",
       "239                                                NaN             NaN  ...   \n",
       "240                                                NaN             NaN  ...   \n",
       "241                                        accelerator             NaN  ...   \n",
       "242                                                NaN             NaN  ...   \n",
       "243                                                NaN             NaN  ...   \n",
       "\n",
       "     FUNDING UP UNTIL VALUATION DATE  AVG REVENUE AVG REVENUE GROWTH  \\\n",
       "0                           0.000000          0.0           0.000000   \n",
       "1                           1.671993          0.0           0.000000   \n",
       "2                           1.473514          0.0           0.000000   \n",
       "3                           2.425354    3228000.0           0.890205   \n",
       "4                           1.131993          0.0           0.000000   \n",
       "..                               ...          ...                ...   \n",
       "239                         0.000000          0.0           0.000000   \n",
       "240                         0.000000          0.0           0.000000   \n",
       "241                         0.000000          0.0           0.000000   \n",
       "242                         0.000000          0.0           0.000000   \n",
       "243                         0.000000          0.0           0.000000   \n",
       "\n",
       "     AVG EMPLOYEE GROWTH VALUATION TO FUNDING RATIO FEMALE FOUNDER  \\\n",
       "0               0.000000                   0.000000           True   \n",
       "1               0.000000                   2.990443           True   \n",
       "2               0.000000                   2.918194           True   \n",
       "3               1.065757                  46.384989           True   \n",
       "4               0.000000                   4.416988           True   \n",
       "..                   ...                        ...            ...   \n",
       "239             0.000000                   0.000000           True   \n",
       "240             0.000000                   0.000000           True   \n",
       "241             0.000000                   0.000000           True   \n",
       "242             0.000000                   0.000000           True   \n",
       "243             0.000000                   0.000000           True   \n",
       "\n",
       "     MALE FOUNDER UNKNOWN FOUNDER FOUNDER SERIAL MIXED TEAM  \n",
       "0            True            True           True      False  \n",
       "1            True            True          False      False  \n",
       "2            True           False          False       True  \n",
       "3            True           False          False       True  \n",
       "4            True            True           True      False  \n",
       "..            ...             ...            ...        ...  \n",
       "239          True           False          False       True  \n",
       "240          True           False          False       True  \n",
       "241          True           False          False       True  \n",
       "242          True           False          False       True  \n",
       "243          True           False          False       True  \n",
       "\n",
       "[244 rows x 92 columns]"
      ]
     },
     "execution_count": 213,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indexMT = df[df['FEMALE FOUNDER'] == 0].index\n",
    "\n",
    "df = df.drop(indexMT)\n",
    "df.reset_index()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Sortieren"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 214,
   "metadata": {},
   "outputs": [],
   "source": [
    "# df['AVG REVENUE GROWTH'].value_counts()\n",
    "\n",
    "# We decide for Valuation Funding Ratio, because of less 0 values and more promising values \n",
    "# compared to REVENUE (quite low for Seed Startups)\n",
    "\n",
    "df['VALUATION TO FUNDING RATIO'].value_counts()\n",
    "df.sort_values(by = ['VALUATION TO FUNDING RATIO'], ascending = False, inplace = True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Change order of columns \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 215,
   "metadata": {},
   "outputs": [],
   "source": [
    "dff= df[['NAME','HQ COUNTRY', 'HQ CITY',\n",
    "       'INVESTORS', 'LAST ROUND',\n",
    "       'LAST FUNDING', 'LAST FUNDING DATE', 'FIRST FUNDING DATE', 'SEED YEAR',\n",
    "       'REVENUE MODEL', 'INDUSTRIES', 'GROWTH STAGE','TOTAL FUNDING USD',\n",
    "       'FUNDING FROM SEED TYPE', 'FUNDING FROM EARLY STAGES',\n",
    "       'FUNDING FROM EARLY STAGES > 2M', 'FUNDING UP UNTIL VALUATION DATE',\n",
    "       'REVENUE (2016,2017,2018,2019,2020,2021,2022,2023)', 'AVG REVENUE', 'AVG REVENUE GROWTH' , 'VALUATION',\n",
    "       'VALUATION (EUR)','VALUATION AVG', 'VALUATION (EUR) AVG', 'VALUATION DATE','VALUATION TO FUNDING RATIO', \n",
    "         'FEMALE FOUNDER', 'MALE FOUNDER', 'UNKNOWN FOUNDER', 'FOUNDER SERIAL','FOUNDERS IS SERIAL', 'MIXED TEAM','EMPLOYEES',\n",
    "       'EMPLOYEES (2016,2017,2018,2019,2020,2021,2022)', 'AVG EMPLOYEE GROWTH',\n",
    "         'SW TRAFFIC 6 MONTHS',\n",
    "       'SW TRAFFIC 12 MONTHS', \n",
    "       'FOUNDERS', 'FOUNDERS STATUSES', 'FOUNDERS GENDERS', 'FOUNDERS BACKGROUNDS',\n",
    "       'APP DOWNLOADS LATEST (IOS)', 'APP DOWNLOADS 6 MONTHS (IOS)',\n",
    "       'APP DOWNLOADS 12 MONTHS (IOS)', 'APP DOWNLOADS LATEST (ANDROID)',\n",
    "       'APP DOWNLOADS 6 MONTHS (ANDROID)', 'APP DOWNLOADS 12 MONTHS (ANDROID)', 'EACH ROUND AMOUNT AS LIST',\n",
    "       'EACH ROUND AMOUNT SUM', 'EACH ROUND AMOUNT SUM NULL',\n",
    "       'IS_MARKETING_INDUSTRY', 'IS_HEALTH_INDUSTRY',\n",
    "       'IS_ENTERPRISE SOFTWARE_INDUSTRY', 'IS_ROBOTICS_INDUSTRY',\n",
    "       'IS_EDUCATION_INDUSTRY', 'IS_FINTECH_INDUSTRY',\n",
    "       'IS_REAL ESTATE_INDUSTRY', 'IS_TELECOM_INDUSTRY', 'IS_TRAVEL_INDUSTRY',\n",
    "       'IS_FOOD_INDUSTRY', 'IS_ENERGY_INDUSTRY', 'IS_KIDS_INDUSTRY',\n",
    "       'IS_HOME LIVING_INDUSTRY', 'IS_SECURITY_INDUSTRY', 'IS_LEGAL_INDUSTRY',\n",
    "       'IS_TRANSPORTATION_INDUSTRY', 'IS_SPORTS_INDUSTRY',\n",
    "       'IS_JOBS RECRUITMENT_INDUSTRY', 'IS_WELLNESS BEAUTY_INDUSTRY',\n",
    "       'IS_MEDIA_INDUSTRY', 'IS_MUSIC_INDUSTRY', 'IS_FASHION_INDUSTRY',\n",
    "       'IS_GAMING_INDUSTRY', 'IS_SEMICONDUCTORS_INDUSTRY',\n",
    "       'IS_DATING_INDUSTRY', 'IS_EVENT TECH_INDUSTRY', 'IS_HOSTING_INDUSTRY']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 216,
   "metadata": {},
   "outputs": [],
   "source": [
    "dff.to_excel(\"resultsf1.xlsx\")"
   ]
  },
  {
   "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}