| \n", " | count | \n", "unique | \n", "top | \n", "freq | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | \n", "462651 | \n", "462651 | \n", "r:9999 | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| entity_type | \n", "462651 | \n", "4 | \n", "Person | \n", "226708 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| entity_id | \n", "462651.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "132915.761775 | \n", "88768.946816 | \n", "1.0 | \n", "45249.5 | \n", "143072.0 | \n", "213868.5 | \n", "286215.0 | \n", "
| parent_id | \n", "27715 | \n", "11972 | \n", "c:2728 | \n", "152 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| name | \n", "462647 | \n", "445203 | \n", "Bob Hebig | \n", "40 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| normalized_name | \n", "462620 | \n", "439326 | \n", "bob hebig | \n", "40 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| permalink | \n", "462651 | \n", "462435 | \n", "/person/bob-hebig-4 | \n", "19 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| category_code | \n", "123186 | \n", "42 | \n", "software | \n", "17922 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| status | \n", "462651 | \n", "9 | \n", "operating | \n", "443663 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| founded_at | \n", "100441 | \n", "6323 | \n", "2011-01-01 | \n", "3937 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| closed_at | \n", "2809 | \n", "999 | \n", "2012-01-01 | \n", "184 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| domain | \n", "174942 | \n", "155458 | \n", "about.me | \n", "818 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| homepage_url | \n", "174942 | \n", "163622 | \n", "http://m.www.yahoo.com | \n", "31 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| twitter_username | \n", "126089 | \n", "119504 | \n", "iJetMedia | \n", "48 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| logo_url | \n", "208850 | \n", "208850 | \n", "http://s3.amazonaws.com/crunchbase_prod_assets... | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| logo_width | \n", "462651.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "189.159799 | \n", "432.403482 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "216.0 | \n", "18200.0 | \n", "
| logo_height | \n", "462651.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "130.488664 | \n", "337.191612 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "139.0 | \n", "9600.0 | \n", "
| short_description | \n", "7617 | \n", "7614 | \n", "American Kidney Stone Management provides lith... | \n", "2 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| description | \n", "95005 | \n", "85369 | \n", "private equity | \n", "360 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| overview | \n", "235235 | \n", "234263 | \n", "Founder | \n", "54 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| tag_list | \n", "106496 | \n", "101997 | \n", "garage-door-springs, broken-spring-repair--rep... | \n", "218 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| country_code | \n", "95043 | \n", "177 | \n", "USA | \n", "55584 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| state_code | \n", "54760 | \n", "51 | \n", "CA | \n", "17537 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| city | \n", "90684 | \n", "11077 | \n", "New York | \n", "4395 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| region | \n", "462651 | \n", "5977 | \n", "unknown | \n", "369052 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| first_investment_at | \n", "16956 | \n", "2682 | \n", "2007-01-01 | \n", "183 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| last_investment_at | \n", "16956 | \n", "2378 | \n", "2012-01-01 | \n", "148 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| investment_rounds | \n", "462651.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.173939 | \n", "3.637983 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "529.0 | \n", "
| invested_companies | \n", "462651.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.138132 | \n", "2.549245 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "459.0 | \n", "
| first_funding_at | \n", "31507 | \n", "3208 | \n", "2008-01-01 | \n", "343 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| last_funding_at | \n", "31507 | \n", "2978 | \n", "2012-01-01 | \n", "272 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| funding_rounds | \n", "462651.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.113749 | \n", "0.524229 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "15.0 | \n", "
| funding_total_usd | \n", "462651.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "892672.20911 | \n", "17001196.984982 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "5700000000.0 | \n", "
| first_milestone_at | \n", "100358 | \n", "4225 | \n", "2010-01-01 | \n", "3240 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| last_milestone_at | \n", "100358 | \n", "4029 | \n", "2012-01-01 | \n", "3023 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| milestones | \n", "462651.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.265196 | \n", "0.568577 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "9.0 | \n", "
| relationships | \n", "462651.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1.794305 | \n", "5.456711 | \n", "0.0 | \n", "0.0 | \n", "1.0 | \n", "2.0 | \n", "1189.0 | \n", "
| created_by | \n", "339486 | \n", "80505 | \n", "dhawalarco | \n", "15162 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| created_at | \n", "462591 | \n", "337606 | \n", "2008-02-05 22:41:40 | \n", "41 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| updated_at | \n", "462651 | \n", "383541 | \n", "2008-02-05 22:45:37 | \n", "81 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| \n", " | funding_total_usd | \n", "
|---|---|
| count | \n", "1.965530e+05 | \n", "
| mean | \n", "2.101193e+06 | \n", "
| std | \n", "2.603485e+07 | \n", "
| min | \n", "0.000000e+00 | \n", "
| 25% | \n", "0.000000e+00 | \n", "
| 50% | \n", "0.000000e+00 | \n", "
| 75% | \n", "0.000000e+00 | \n", "
| max | \n", "5.700000e+09 | \n", "
| \n", " | feature | \n", "coef | \n", "
|---|---|---|
| 3 | \n", "milestones | \n", "0.157360 | \n", "
| 4 | \n", "relationships | \n", "0.291816 | \n", "
| 1 | \n", "investment_rounds | \n", "0.733409 | \n", "
| 2 | \n", "invested_companies | \n", "-0.848146 | \n", "
| 5 | \n", "age_at_first_funding_years | \n", "-3.165738 | \n", "
| 6 | \n", "age_at_last_funding_years | \n", "3.837702 | \n", "
| 0 | \n", "funding_rounds | \n", "6.393696 | \n", "
| \n", " | funding_total_usd_m | \n", "log_funding_total_m | \n", "industry_top | \n", "country_top | \n", "
|---|---|---|---|---|
| 0 | \n", "39.75 | \n", "3.707456 | \n", "web | \n", "USA | \n", "
| 1 | \n", "0.00 | \n", "0.000000 | \n", "games_video | \n", "USA | \n", "
| 2 | \n", "0.00 | \n", "0.000000 | \n", "games_video | \n", "USA | \n", "
| 3 | \n", "0.00 | \n", "0.000000 | \n", "Other | \n", "Unknown | \n", "
| 4 | \n", "0.00 | \n", "0.000000 | \n", "games_video | \n", "Unknown | \n", "
| \n", " | funding_rounds | \n", "investment_rounds | \n", "invested_companies | \n", "milestones | \n", "relationships | \n", "age_at_first_funding_years | \n", "age_at_last_funding_years | \n", "
|---|---|---|---|---|---|---|---|
| cluster_id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
| 0.0 | \n", "1.372491 | \n", "0.012346 | \n", "0.011926 | \n", "0.830199 | \n", "3.240622 | \n", "2.257349 | \n", "2.720199 | \n", "
| 1.0 | \n", "3.209227 | \n", "0.301690 | \n", "0.272071 | \n", "1.764192 | \n", "11.193469 | \n", "8.358840 | \n", "11.154287 | \n", "
| \n", " | coef | \n", "
|---|---|
| invested_companies | \n", "13.588713 | \n", "
| funding_rounds | \n", "11.263996 | \n", "
| ind_Unknown | \n", "4.824575 | \n", "
| ind_Other | \n", "3.811243 | \n", "
| cty_IND | \n", "3.274840 | \n", "
| ind_other | \n", "3.236093 | \n", "
| cty_IRL | \n", "2.788048 | \n", "
| ind_ecommerce | \n", "2.702824 | \n", "
| cty_Other | \n", "2.529366 | \n", "
| milestones | \n", "2.236058 | \n", "
| age_at_last_funding_years | \n", "2.085096 | \n", "
| cty_Unknown | \n", "1.550202 | \n", "
| relationships | \n", "0.904792 | \n", "
| ind_games_video | \n", "0.679187 | \n", "
| ind_mobile | \n", "0.543320 | \n", "
| \n", " | MAE | \n", "RMSE | \n", "R² | \n", "
|---|---|---|---|
| Linear Regression | \n", "15.089334 | \n", "52.386184 | \n", "0.079016 | \n", "
| Random Forest | \n", "13.580779 | \n", "56.006015 | \n", "-0.052659 | \n", "
| Gradient Boosting | \n", "12.936657 | \n", "53.936073 | \n", "0.023714 | \n", "
| \n", " | Train % | \n", "Test % | \n", "
|---|---|---|
| funding_total_usd_m | \n", "\n", " | \n", " |
| 0 | \n", "0.500823 | \n", "0.496606 | \n", "
| 1 | \n", "0.499177 | \n", "0.503394 | \n", "