Copyright 2020 Arjuna Sky Kok

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program.  If not, see <https://www.gnu.org/licenses/>.

Analisa Pendiri Perintis yang Didanai East Ventures

In [1]:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
In [2]:
dataset_url = "https://arjunaskykok.s3-ap-southeast-1.amazonaws.com/pendiri/east_ventures/2020-10-06_east-ventures.csv"
dataset = pd.read_csv(dataset_url, dtype={"Tahun Lahir (Perkiraan)": "Int64"})
In [3]:
dataset.head()
Out[3]:
Perintis Situs Vertikal Pendiri Jabatan Tahun Lahir (Perkiraan) Linkedin Negara S1 Universitas S1 Jurusan/Gelar S1 ... Universitas S2 Jurusan/Gelar S2 Negara S3 Universitas S3 Jurusan/Gelar S3 Negara Pendidikan Dinormalisasi Kategori Pendiri Seks Warga Negara Negara Asal
0 Aruna https://aruna.id/ Logistics & Supply Chain Farid Naufal Aslam CEO 1993 https://www.linkedin.com/in/faridnaslam/ Indonesia Telkom University Management of ICT Business ... NaN NaN NaN NaN NaN Indonesia 100% Teknikal L WNI NaN
1 Aruna https://aruna.id/ Logistics & Supply Chain Indraka Fadhlillah COO 1993 https://www.linkedin.com/in/indraka-fadhlillah... Indonesia Telkom University Computer/Information Technology Administration... ... NaN NaN NaN NaN NaN Indonesia 100% Bisnis L WNI NaN
2 Aruna https://aruna.id/ Logistics & Supply Chain Utari Octavianty Director General 1993 https://www.linkedin.com/in/utari-octavianty-9... Indonesia Telkom University ICT Management ... NaN NaN NaN NaN NaN Indonesia 100% Bisnis P WNI NaN
3 Bonza https://thebonza.com AI & Deep Tech Elsa Chandra NaN 1988 https://www.linkedin.com/in/elsachandra/ Inggris The London School of Economics and Political S... Bachelor of Science ... NaN NaN NaN NaN NaN Luar Negeri Non-Amerika 100% Bisnis P WNI NaN
4 Bonza https://thebonza.com AI & Deep Tech Philip Thomas NaN 1987 https://www.linkedin.com/in/philipthom/ Indonesia Institut Teknologi Bandung (ITB) Petrolium Engineering ... Universitetet i Stavanger Petrolium Engineering Norwegia University of Stavanger NaN Luar Negeri Non-Amerika 90%, Indonesia 10% Teknikal L WNI NaN

5 rows × 21 columns

Pendiri perintis perempuan masih sedikit. Cuma 10%. Artinya dari 10 pendiri, cuma 1 perempuan.

In [4]:
dataset["Seks"].value_counts()
Out[4]:
L    153
P     18
Name: Seks, dtype: int64
In [5]:
labels = ["Laki-laki", "Perempuan"]
numbers = [153, 18]

plt.pie(numbers, labels=labels)
plt.show()

Perintis dengan 1 pendiri (pendiri solo) cukup banyak. Malah 4 pendiri 1 perintis yang amat jarang.

In [6]:
dataset.groupby("Perintis").count()["Situs"].value_counts()
Out[6]:
2    29
3    24
1    21
4     5
Name: Situs, dtype: int64

Umur pendiri yang dominan adalah 30-an, yaitu 70%. Anak muda (20-an) sebanyak 20%.

In [7]:
thn = "Tahun Lahir (Perkiraan)"
thn_1980 = dataset[(dataset[thn]>1980) & (dataset[thn]<=1990)]["Pendiri"].count()
thn_1970 = dataset[(dataset[thn]>1970) & (dataset[thn]<=1980)]["Pendiri"].count()
thn_1960 = dataset[(dataset[thn]>1960) & (dataset[thn]<=1970)]["Pendiri"].count()
thn_1990 = dataset[(dataset[thn]>1990) & (dataset[thn]<=2000)]["Pendiri"].count()
[thn_1960, thn_1970, thn_1980, thn_1990]
Out[7]:
[3, 11, 105, 30]

Lulusan Amerika mendominasi sekali....

  • Jumlah mahasiswa terdaftar di dalam negeri itu 7 juta
  • Jumlah mahasiswa yang keluar negeri (termasuk Amerika) itu 50 ribu
  • Jumlah mahasiswa yang belajar di Amerika itu 9 ribu

Semua angkanya kira-kira.

In [8]:
lulusan = "Negara Pendidikan Dinormalisasi"
dataset[lulusan].unique()
Out[8]:
array(['Indonesia 100%', 'Luar Negeri Non-Amerika 100%',
       'Luar Negeri Non-Amerika 90%, Indonesia 10%', nan, 'Amerika 100%',
       'Indonesia 70%, Luar Negeri Non-Amerika 30%',
       'Luar Negeri Non-Amerika 60%, Indonesia 40%',
       'Amerika 60%, Indonesia 40%',
       'Amerika 60%, Luar Negeri Non-Amerika 40%',
       'Indonesia 60%, Amerika 40%', 'Amerika 60%, Singapura 40%',
       'Luar Negeri Non-Amerika 60%, ? 40%',
       'Indonesia 60%, Luar Negeri Non-Amerika 40%',
       'Singapura 60%, ??? 40%', 'Indonesia 60%, ??? 40%',
       'Indonesia 50%, Luar Negeri Non-Amerika 50%'], dtype=object)

Maaf, ngerjainnya malam-malam. Jadi terselip kesalahan seperti ini. Mari kita perbaiki! :)

In [9]:
def convert_singapura_to_ln(x):
    if x is not np.nan:
        return x.replace("Singapura", "Luar Negeri Non-Amerika")
    return x
dataset[lulusan] = dataset[lulusan].apply(convert_singapura_to_ln)
In [10]:
lulusan = "Negara Pendidikan Dinormalisasi"
ina = "Indonesia"
ln = "Luar Negeri Non-Amerika"
amrik = "Amerika"

def is_ina(x):
    if x is np.nan:
        return False
    return (x == f"{ina} 100%") or (f"{ina} 60" in x) or (f"{ina} 50" in x) or (f"{ina} 70" in x) or (f"{ina} 90" in x)

def is_ln(x):
    if x is np.nan:
        return False
    return (x == f"{ln} 100%") or (f"{ln} 60" in x) or (f"{ln} 50" in x) or (f"{ln} 70" in x) or (f"{ln} 90" in x)

def is_amrik(x):
    if x is np.nan:
        return False
    return ("Luar" not in x) and ((x == f"{amrik} 100%") or (f"{amrik} 60" in x) or (f"{amrik} 50" in x) or (f"{amrik} 70" in x) or (f"{amrik} 90" in x))

dataset["lulusan_dalam_negeri"] = dataset[lulusan].apply(is_ina)
dataset["lulusan_luar_negeri_non_amerika"] = dataset[lulusan].apply(is_ln)
dataset["lulusan_amerika"] = dataset[lulusan].apply(is_amrik)
In [11]:
dlm_negeri = dataset["lulusan_dalam_negeri"].values.sum()
ln_negeri = dataset["lulusan_luar_negeri_non_amerika"].values.sum()
amrik = dataset["lulusan_amerika"].values.sum()
[dlm_negeri, ln_negeri, amrik]
Out[11]:
[53, 49, 56]
In [12]:
labels = ["Lulusan Dalam Negeri", "Lulusan Luar Negeri Non-Amerika", "Lulusan Amerika"]
numbers = [53, 49, 56]

barlist = plt.bar(labels, numbers)
barlist[0].set_color('r')
barlist[1].set_color('g')
barlist[2].set_color('b')
plt.xticks(rotation=15)
plt.show()
In [13]:
dataset[dataset["Negara S1"]=="Indonesia"]["Universitas S1"].value_counts()
Out[13]:
Institut Teknologi Bandung (ITB)             14
University of Indonesia                       8
BINUS University                              7
STMIK Mikroskil                               4
Universitas Gadjah Mada (UGM)                 4
Telkom University                             4
Institut Teknologi Telkom                     3
School of Business and Management ITB         2
Institut Pertanian Bogor (IPB)                2
Universitas Trisakti                          2
Universitas Surabaya (UBAYA)                  1
Prasetiya Mulya Business School               1
Universitas Kristen Satya Wacana              1
Universitas Tarumanagara (Untar)              1
Pelita Harapan University                     1
Stiesia School of Economics                   1
Universitas Atma Jaya Yogyakarta              1
Universitas Kristen Maranatha Bandung         1
Institut Teknologi Sepuluh November           1
Universitas Prof. Dr. Moestopo (Beragama)     1
Universitas Katolik Parahyangan               1
STT Telkom                                    1
UIN Jakarta                                   1
Name: Universitas S1, dtype: int64
In [14]:
dataset[dataset["lulusan_dalam_negeri"]]["Universitas S1"].value_counts()
Out[14]:
Institut Teknologi Bandung (ITB)                                                                8
BINUS University                                                                                7
STMIK Mikroskil                                                                                 4
University of Indonesia                                                                         4
Universitas Gadjah Mada (UGM)                                                                   4
Telkom University                                                                               4
Institut Teknologi Telkom                                                                       3
Institut Pertanian Bogor (IPB)                                                                  2
Universitas Trisakti                                                                            2
The University of British Columbia                                                              1
Stiesia School of Economics                                                                     1
Universitas Katolik Parahyangan                                                                 1
Universitas Prof. Dr. Moestopo (Beragama)                                                       1
Universitas Atma Jaya Yogyakarta                                                                1
Pelita Harapan University                                                                       1
School of Business and Management ITB                                                           1
Universitas Kristen Satya Wacana                                                                1
University of Washington                                                                        1
Prasetiya Mulya Business School                                                                 1
Universitas Islam Negeri Syarif Hidayatullah Jakarta / Universiti Islam Antarbangsa Malaysia    1
Universitas Surabaya (UBAYA)                                                                    1
Universitas Kristen Maranatha Bandung                                                           1
Universitas Tarumanagara (Untar)                                                                1
UIN Jakarta                                                                                     1
Name: Universitas S1, dtype: int64
In [15]:
dataset[dataset["Negara S1"]=="Amerika Serikat"]["Universitas S1"].value_counts()
Out[15]:
University of California, Berkeley                                 9
Purdue University                                                  5
University of Southern California                                  4
University of Washington                                           4
The Ohio State University                                          2
University of Pennsylvania – The Wharton School                    2
University of Southern California – Marshall School of Business    2
The University of Texas at Austin                                  1
University of Chicago                                              1
University of San Francisco                                        1
California State University – Fullerton                            1
University of California, Los Angeles                              1
Stanford University                                                1
University of Nebraska                                             1
University of Oregon School of Journalism and Communication        1
University of Hawaii – Shidler College of Business                 1
Shoreline Community College / Seattle University                   1
University of Wisconsin – Madison                                  1
University of Michigan                                             1
California State Polytechnic University-Pomona                     1
New York University                                                1
California State University – Los Angeles                          1
Missouri State University                                          1
Seattle University                                                 1
Syracuse University                                                1
University of Illinois at Urbana-Champaign                         1
California State University – Northridge                           1
Babson College                                                     1
University of Pennsylvania / University of Washington              1
Name: Universitas S1, dtype: int64
In [16]:
dataset[dataset["lulusan_amerika"]]["Universitas S1"].value_counts()
Out[16]:
University of California, Berkeley                                 9
Purdue University                                                  5
University of Southern California                                  4
University of Indonesia                                            3
University of Washington                                           3
The Ohio State University                                          2
University of Pennsylvania – The Wharton School                    2
University of Southern California – Marshall School of Business    2
The University of Texas at Austin                                  1
University of Michigan                                             1
University of San Francisco                                        1
California State University – Fullerton                            1
University of California, Los Angeles                              1
Stanford University                                                1
University of Nebraska                                             1
Nanyang Polytechnic                                                1
University of Hawaii – Shidler College of Business                 1
Shoreline Community College / Seattle University                   1
University of Oregon School of Journalism and Communication        1
California State Polytechnic University-Pomona                     1
Institut Teknologi Sepuluh November                                1
University of Chicago                                              1
New York University                                                1
California State University – Los Angeles                          1
University of Wisconsin – Madison                                  1
Missouri State University                                          1
Seattle University                                                 1
Institut Teknologi Bandung (ITB)                                   1
Syracuse University                                                1
University of Illinois at Urbana-Champaign                         1
California State University – Northridge                           1
Babson College                                                     1
University of Pennsylvania / University of Washington              1
Name: Universitas S1, dtype: int64
In [17]:
dataset[dataset["lulusan_amerika"]]["Universitas S2"].value_counts()
Out[17]:
Columbia University in the City of New York                                                3
Haas School of Business, UC Berkeley                                                       2
Stanford University                                                                        2
University of Pennsylvania – The Wharton School                                            2
University of Southern California                                                          2
Harvard Law School                                                                         1
University of Nebraska / University of Washington, Michael G. Foster School of Business    1
Harvard Business School                                                                    1
UCLA Anderson School of Management                                                         1
Carnegie Mellon University                                                                 1
Saint Louis University                                                                     1
The University of Texas at Dallas                                                          1
University of Washington                                                                   1
The University of Texas at Austin                                                          1
University of Michigan                                                                     1
Teachers College of Columbia University                                                    1
Boston University                                                                          1
Northwestern University                                                                    1
San Jose State University                                                                  1
Name: Universitas S2, dtype: int64
In [18]:
dataset[dataset["lulusan_luar_negeri_non_amerika"]]["Universitas S1"].value_counts()
Out[18]:
Institut Teknologi Bandung (ITB)                                                                5
University of New South Wales                                                                   5
Singapore Management University                                                                 3
National University of Singapore                                                                2
The London School of Economics and Political Science                                            2
Nanyang Technological University                                                                2
University of Melbourne                                                                         2
RMIT University                                                                                 2
Monash University                                                                               2
Birla Institute of Technology and Science                                                       1
Macquarie University                                                                            1
The University of British Columbia                                                              1
Nanyang Polytechnic / University of New South Wales                                             1
University of New South Wales / University of Technology, Sydney                                1
University of Indonesia                                                                         1
Edith Cowan University                                                                          1
University of Melbourne – Melbourne Business School                                             1
School of Business and Management ITB                                                           1
TMC Academy Singapore / Monash University                                                       1
Billy Blue College of Design                                                                    1
Technische Universität Hamburg-Harburg                                                          1
Indian Institute of Technology, Bombay                                                          1
Simon Fraser University                                                                         1
STT Telkom                                                                                      1
Deakin University                                                                               1
Victoria University                                                                             1
McMaster University                                                                             1
The University of Manchester                                                                    1
Hamburn University of Technology                                                                1
Nanyang Academy of Fine Arts                                                                    1
Universitas Islam Negeri Syarif Hidayatullah Jakarta / Universiti Islam Antarbangsa Malaysia    1
Name: Universitas S1, dtype: int64
In [19]:
dataset[(dataset["Negara S1"]!="Indonesia") & (dataset["Negara S1"]!="Amerika Serikat")]["Universitas S1"].value_counts()
Out[19]:
University of New South Wales                                                                   6
Nanyang Technological University                                                                5
Singapore Management University                                                                 3
National University of Singapore                                                                3
The London School of Economics and Political Science                                            2
The University of British Columbia                                                              2
RMIT University                                                                                 2
Monash University                                                                               2
University of Melbourne                                                                         2
Nanyang Polytechnic / University of New South Wales                                             1
Edith Cowan University                                                                          1
University of New South Wales / University of Technology, Sydney                                1
Nanyang Polytechnic                                                                             1
TMC Academy Singapore / Monash University                                                       1
Macquarie University                                                                            1
University of Melbourne – Melbourne Business School                                             1
Birla Institute of Technology and Science                                                       1
Nanyang Academy of Fine Arts                                                                    1
Billy Blue College of Design                                                                    1
Technische Universität Hamburg-Harburg                                                          1
Indian Institute of Technology, Bombay                                                          1
Simon Fraser University                                                                         1
Deakin University                                                                               1
Victoria University                                                                             1
McMaster University                                                                             1
The University of Manchester                                                                    1
Hamburn University of Technology                                                                1
Universitas Islam Negeri Syarif Hidayatullah Jakarta / Universiti Islam Antarbangsa Malaysia    1
Name: Universitas S1, dtype: int64
In [20]:
dataset[(dataset["Negara S1"]!="Indonesia") & (dataset["Negara S1"]!="Amerika Serikat")]["Negara S1"].value_counts()
Out[20]:
Australia                19
Singapura                13
Kanada                    4
Inggris                   3
Jerman                    2
Singapura / Australia     2
India                     2
Indonesia / Malaysia      1
Name: Negara S1, dtype: int64

Bisnis vs Teknikal

In [21]:
dataset["Kategori Pendiri"].value_counts()
Out[21]:
Bisnis            91
Teknikal          64
Sains              2
Sains/Teknikal     1
Lain               1
Hukum              1
Jurnalisme         1
Desain             1
Pendidikan         1
Name: Kategori Pendiri, dtype: int64

Mana yang lebih banyak? CEO latar belakang bisnis atau CEO teknikal?

In [22]:
ceo_bisnis = dataset[(dataset["Kategori Pendiri"]=="Bisnis") & (dataset["Jabatan"]=="CEO")]["Pendiri"].count()
ceo_teknikal = dataset[(dataset["Kategori Pendiri"]=="Teknikal") & (dataset["Jabatan"]=="CEO")]["Pendiri"].count()
[ceo_bisnis, ceo_teknikal]
Out[22]:
[43, 18]
In [ ]: