Unicorn Company Analysis
Introduction
Exploratory data analysis is an essential step toward gaining insights from data. In this project, we will perform data cleaning and EDA on unicorn companies. The term unicorn refers to a privately held startup company with a value of over $1 billion. The report provides a comprehensive analysis of the data collected on unicorn companies, including their geographical distribution, industry focus, and funding history.
Data Information
The sorce of this dataset is Maven Analytics. The dataset has 10 columns and 1074 rows.
Dataset URL: Unicorn Company Maven Analytics
| Column Name | Description |
|---|---|
| Company | Company name |
| Valuation | Company valuation in billions of dollars |
| Date Joined | The date in which the company reached $1 billion in valuation |
| Industry | Company industry |
| City | City the company was founded in |
| Country | Country the company was founded in |
| Continent | Continent the company was founded in |
| Year Founded | Year the company was founded |
| Funding | Total amount raised across all funding rounds in billions (B) or millions (M) of dollars |
| Select Investors | Top 4 investing firms or individual investors (some have less than 4) |
Data Cleaning
Check missing value all column and dropping row that have "NULL''.
Check duplicate company name
Spiltting Data Joined into Year, Month, Day will be helpful to find the year taken to become a unicorn.
Dropping rows with value less than "$1M" or "Unknow" in Funding and Valuation
Fixing data types and spell errors
Data Analysis
1. Which unicorn companies have had the biggest return on investment?Zapier, Dunamu, Workhuman, CFGI and Manner companies are the top 5 companies with the highest Return on Investment (ROI) among unicorn companies.
2. How long does it usually take for a company to become a unicorn? Has it always been this way?This data reveals that while some companies achieved unicorn status immediately upon founding, the longest recorded journey to unicornhood was 37 years. On average, startups took approximately 6.9 years to reach a valuation of one billion dollars.The top 5 companies that achieved unicorn status in the shortest amount of time are Ola Electric Mobility, Devoted Health, Instacart, Revolut and Stripe.
3. Which countries have the most unicorns? Are there any cities that appear to be industry hubs?Ranked first, the United States has the highest number of unicorn companies at 555, followed by China with 170 and India with 65.
The cities that are the centers of each type of industry are as follows:
| City | Industry | Count of Company |
|---|---|---|
| San Francisco | Fintech | 222 |
| Surry Hills | Internet software & services | 203 |
| Shenzhen | E-commerce & direct-to-consumer | 109 |
| Beijing | Artificial intelligence | 84 |
| Waltham | Health | 73 |
| San Francisco | Supply chain, logistics, & delivery | 56 |
| Hawthorne | Other | 56 |
| Boston | Cybersecurity | 50 |
| San Francisco | Data management & analytics | 40 |
| San Francisco | Mobile & telecommunications | 37 |
| Beijing | Hardware | 34 |
| Shanghai | Auto & transportation | 31 |
| Bengaluru | Edtech | 28 |
| San Francisco | Consumer & retail | 24 |
| Gurugram | Travel | 14 |
4. Which investors have funded the most unicorns?The top 5 investors most interested in investing in unicorns are:
| Investors | Count of Company |
|---|---|
| Tiger Global Management | 39 |
| Accel | 32 |
| Sequoia Capital | 30 |
| Sequoia Capital China | 30 |
| Andreessen Horowitz | 29 |