In [1]:
import pandas as pd
In [2]:
!pip install pandas
Requirement already satisfied (use --upgrade to upgrade): pandas in /usr/local/lib/python3.5/site-packages
Requirement already satisfied (use --upgrade to upgrade): pytz>=2011k in /usr/local/lib/python3.5/site-packages (from pandas)
Requirement already satisfied (use --upgrade to upgrade): python-dateutil>=2 in /usr/local/lib/python3.5/site-packages (from pandas)
Requirement already satisfied (use --upgrade to upgrade): numpy>=1.7.0 in /usr/local/lib/python3.5/site-packages (from pandas)
Requirement already satisfied (use --upgrade to upgrade): six>=1.5 in /usr/local/lib/python3.5/site-packages (from python-dateutil>=2->pandas)
In [3]:
df = pd.read_excel("Billionaire Characteristics Database/richpeople.xlsx")
In [4]:
!pip install xlrd
Requirement already satisfied (use --upgrade to upgrade): xlrd in /usr/local/lib/python3.5/site-packages
In [5]:
df.head(1)
Out[5]:
year
name
rank
citizenship
countrycode
networthusbillion
selfmade
typeofwealth
gender
age
...
relationshiptocompany
foundingdate
gdpcurrentus
sourceofwealth
notes
notes2
source
source_2
source_3
source_4
0
2001
A Jerrold Perenchio
151
United States
USA
3.0
self-made
executive
male
70.0
...
former chairman and CEO
1955.0
1.062180e+13
NaN
represented Marlon Brando and Elizabeth Taylor
NaN
http://en.wikipedia.org/wiki/Jerry_Perenchio
http://www.forbes.com/profile/a-jerrold-perenc...
COLUMN ONE; A Hollywood Player Who Owns the Ga...
NaN
1 rows × 30 columns
In [6]:
df.columns
Out[6]:
Index(['year', 'name', 'rank', 'citizenship', 'countrycode',
'networthusbillion', 'selfmade', 'typeofwealth', 'gender', 'age',
'industry', 'IndustryAggregates', 'region', 'north',
'politicalconnection', 'founder', 'generationofinheritance', 'sector',
'company', 'companytype', 'relationshiptocompany', 'foundingdate',
'gdpcurrentus', 'sourceofwealth', 'notes', 'notes2', 'source',
'source_2', 'source_3', 'source_4'],
dtype='object')
In [7]:
recent = df[df['year'] == 2014]
recent.head(1)
Out[7]:
year
name
rank
citizenship
countrycode
networthusbillion
selfmade
typeofwealth
gender
age
...
relationshiptocompany
foundingdate
gdpcurrentus
sourceofwealth
notes
notes2
source
source_2
source_3
source_4
1
2014
A. Jerrold Perenchio
663
United States
USA
2.6
self-made
executive
male
83.0
...
former chairman and CEO
1955.0
NaN
television, Univision
represented Marlon Brando and Elizabeth Taylor
NaN
http://en.wikipedia.org/wiki/Jerry_Perenchio
http://www.forbes.com/profile/a-jerrold-perenc...
COLUMN ONE; A Hollywood Player Who Owns the Ga...
NaN
1 rows × 30 columns
In [8]:
recent['countrycode'].value_counts().head()
#df['animal'].value_counts()
Out[8]:
USA 499
CHN 152
RUS 111
DEU 85
BRA 65
Name: countrycode, dtype: int64
In [9]:
Swiss_billionaires = recent[recent['countrycode'] == 'CHE']
Swiss_billionaires.count().head(1)
Out[9]:
year 22
dtype: int64
In [10]:
Swiss_billionaires = recent[recent['countrycode'] == 'CHE']
Swiss_billionaires_sorted = Swiss_billionaires.sort_values(by='networthusbillion', ascending=False)
Swiss_billionaires_sorted
Out[10]:
year
name
rank
citizenship
countrycode
networthusbillion
selfmade
typeofwealth
gender
age
...
relationshiptocompany
foundingdate
gdpcurrentus
sourceofwealth
notes
notes2
source
source_2
source_3
source_4
676
2014
Ernesto Bertarelli
92
Switzerland
CHE
12.0
inherited
inherited
male
48.0
...
relation
1906.0
NaN
biotech, investments
3rd generation
inherited along with sister, who isn't on the ...
http://en.wikipedia.org/wiki/Ernesto_Bertarelli
http://www.forbes.com/profile/ernesto-bertarelli/
http://www.emdserono.com/en/about_us/history/H...
NaN
882
2014
Hansjoerg Wyss
111
Switzerland
CHE
10.5
self-made
founder non-finance
male
79.0
...
founder/CEO
1974.0
NaN
medical devices
NaN
NaN
http://en.wikipedia.org/wiki/Hansj%C3%B6rg_Wyss
http://www.swissinfo.ch/eng/bernese-billionair...
http://emea.depuysynthes.com/about/corporate-i...
NaN
1557
2014
Margarita Louis-Dreyfus
165
Switzerland
CHE
8.1
inherited
inherited
female
50.0
...
relation
1851.0
NaN
commodities
widow of 4th generation heir
holds 60% of organization
http://en.wikipedia.org/wiki/Robert_Louis-Dreyfus
NaN
NaN
NaN
2374
2014
Thomas Schmidheiny
256
Switzerland
CHE
5.5
inherited
inherited
male
68.0
...
relation
1912.0
NaN
cement
4th generation
NaN
http://en.wikipedia.org/wiki/Thomas_Schmidheiny
NaN
NaN
NaN
2173
2014
Sergio Mantegazza
319
Switzerland
CHE
4.7
inherited
inherited
male
86.0
...
relation
1928.0
NaN
travel
inherited from father, current ceo
NaN
http://en.wikipedia.org/wiki/Group_Voyagers
http://www.groupvoyagers.com/index.php/do/get_...
NaN
NaN
2256
2014
Stephan Schmidheiny
483
Switzerland
CHE
3.3
inherited
inherited
male
66.0
...
relation
1912.0
NaN
investments
4th generation, recently sentanced to 18 years...
NaN
http://en.wikipedia.org/wiki/Stephan_Schmidheiny
NaN
http://en.wikipedia.org/wiki/Thomas_Schmidheiny
NaN
812
2014
Gianluigi Aponte
506
Switzerland
CHE
3.2
self-made
founder non-finance
male
NaN
...
founder
1970.0
NaN
NaN
listed as co-founders of company
NaN
http://www.forbes.com/profile/gianluigi-rafael...
http://www.swiss-ships.ch/reeder/reederei-beri...
NaN
NaN
1921
2014
Rafaela Aponte
506
Switzerland
CHE
3.2
self-made
founder non-finance
female
NaN
...
founder
1970.0
NaN
NaN
listed as co-founders of company
NaN
http://www.forbes.com/profile/gianluigi-rafael...
https://businessexecutives.wordpress.com/2014/...
NaN
NaN
1537
2014
Magdalena Martullo-Blocher
580
Switzerland
CHE
2.9
inherited
inherited
female
45.0
...
relation and ceo
1936.0
NaN
chemicals
inherited from father
NaN
http://de.wikipedia.org/wiki/Ems-Chemie
http://www.ems-group.com/en/about-ems/about-em...
NaN
NaN
1666
2014
Michael Pieper
580
Switzerland
CHE
2.9
inherited
inherited
male
68.0
...
relation
1911.0
NaN
kitchen appliances
father aquired company
NaN
http://www.forbes.com/profile/michael-pieper/
NaN
NaN
NaN
1924
2014
Rahel Blocher
580
Switzerland
CHE
2.9
inherited
inherited
female
38.0
...
relation
1936.0
NaN
chemicals
inherited from father
NaN
http://de.wikipedia.org/wiki/Ems-Chemie
http://www.ems-group.com/en/about-ems/about-em...
NaN
NaN
686
2014
Eva Maria Bucher-Haefner
642
Switzerland
CHE
2.7
inherited
inherited
female
57.0
...
relation
1976.0
NaN
Computer Associates
inherited from father
split between siblings
http://www.forbes.com/profile/eva-maria-bucher...
http://www.ca.com/us/about-us/company-informat...
NaN
NaN
678
2014
Esther Grether
731
Switzerland
CHE
2.4
inherited
inherited
female
78.0
...
relation
1899.0
NaN
art collection, Swatch
widow
NaN
http://en.wikipedia.org/wiki/Esther_Grether
http://www.forbes.com/profile/esther-grether/
NaN
NaN
1538
2014
Maja Oeri
731
Switzerland
CHE
2.4
inherited
inherited
female
59.0
...
relative
1896.0
NaN
Roche Holding
long time family ownership
holds 5% share in company
http://www.forbes.com/sites/tatianaserafin/201...
http://en.wikipedia.org/wiki/Hoffmann-La_Roche
NaN
NaN
1083
2014
Jean Claude Gandur
764
Switzerland
CHE
2.3
self-made
privatized and resources
male
65.0
...
founder
1994.0
NaN
oil trading, exploration
NaN
NaN
http://fr.wikipedia.org/wiki/Jean_Claude_Gandur
http://en.wikipedia.org/wiki/Addax_Petroleum
http://www.oryxpetroleum.com/en/about-us/organ...
NaN
1594
2014
Martin Haefner
796
Switzerland
CHE
2.2
inherited
inherited
male
60.0
...
relation
1976.0
NaN
technology, investments
inherited from father
NaN
http://www.forbes.com/profile/eva-maria-bucher...
NaN
NaN
NaN
257
2014
Benjamin de Rothschild
869
Switzerland
CHE
2.0
inherited
inherited
male
50.0
...
relation
1953.0
NaN
banking
member of Rothschild banking family (founded i...
only child
http://en.wikipedia.org/wiki/Benjamin_de_Roths...
http://en.wikipedia.org/wiki/LCF_Rothschild_Group
http://en.wikipedia.org/wiki/Edmond_Adolphe_de...
http://www.nytimes.com/1997/11/04/business/bar...
2367
2014
Thomas Meyer
988
Switzerland
CHE
1.8
self-made
founder non-finance
male
NaN
...
founder
1984.0
NaN
Desigual
NaN
NaN
http://www.forbes.com/profile/thomas-meyer-1/
http://www.bloomberg.com/news/articles/2013-02...
NaN
NaN
609
2014
Edgar de Picciotto
1078
Switzerland
CHE
1.7
self-made
self-made finance
male
84.0
...
founder
1969.0
NaN
private banking
NaN
NaN
http://en.wikipedia.org/wiki/Union_Bancaire_Pr...
http://www.ubp.com/en/private-bank/swiss-bank/...
NaN
NaN
2461
2014
Walter Frey
1284
Switzerland
CHE
1.3
inherited
inherited
male
70.0
...
relation
1926.0
NaN
Emil Frey Group
inherited from father
NaN
http://www.forbes.com/profile/walter-frey/
NaN
NaN
NaN
1697
2014
Miriam Blocher
1465
Switzerland
CHE
1.1
inherited
inherited
female
39.0
...
relation
1936.0
NaN
chemicals
inherited from father
NaN
http://de.wikipedia.org/wiki/Ems-Chemie
http://www.ems-group.com/en/about-ems/about-em...
NaN
NaN
2379
2014
Thomas Straumann
1465
Switzerland
CHE
1.1
inherited
inherited
male
50.0
...
relation
1954.0
NaN
dental implants
3rd generation
NaN
http://en.wikipedia.org/wiki/Straumann
NaN
NaN
NaN
22 rows × 30 columns
In [11]:
female_Swiss_billionaires = Swiss_billionaires[Swiss_billionaires['gender'] == 'female'].count().head(1)
female_Swiss_billionaires
Out[11]:
year 8
dtype: int64
In [12]:
male_Swiss_billionaire = Swiss_billionaires[Swiss_billionaires['gender'] == 'male'].count().head(1)
male_Swiss_billionaire
Out[12]:
year 14
dtype: int64
So that is 8 female Swiss billionaires and 14 male ones.
In [13]:
female_Swiss_billionaires_list = Swiss_billionaires[Swiss_billionaires['gender'] == 'female']
female_mean = female_Swiss_billionaires_list['networthusbillion'].mean()
print(female_mean)
#print("Swiss female billionaire's average wealth:", female_Swiss_billionaire['networthusbillion'].mean())
#print("Swiss male billionaire's average wealth:", male_Swiss_billionaire['networthusbillion'].mean())
3.2125
In [14]:
male_Swiss_billionaires_list = Swiss_billionaires[Swiss_billionaires['gender'] == 'male']
male_mean = male_Swiss_billionaires_list['networthusbillion'].mean()
print(male_mean)
3.89285714286
In [15]:
diff = male_mean - female_mean
Millions_diff = diff * 1000
male_sum = male_Swiss_billionaires_list['networthusbillion'].sum()
female_sum = female_Swiss_billionaires_list['networthusbillion'].sum()
print("In total Swiss male billionaires have funds of", male_sum, "billion US-Dollars. Female billionaires own", female_sum,"billion meaning that in average a Swiss male billionaire has", Millions_diff, "million USD more than Swiss female billionaires. That's qite a bit of cash!")
In total Swiss male billionaires have funds of 54.5 billion US-Dollars. Female billionaires own 25.7 billion meaning that in average a Swiss male billionaire has 680.357142857 million USD more than Swiss female billionaires. That's qite a bit of cash!
In [16]:
#df[(df['animal'] == 'cat') & (df['inches'] > 12)]
male_Swiss_billionaires_list[male_Swiss_billionaires_list['selfmade'] == 'inherited'].count().head(1)
inherited = male_Swiss_billionaires_list[male_Swiss_billionaires_list['selfmade'] == 'inherited'].count().head(1)
print("So out of 14 male Swiss billionaires 9 of them inherited their fortune.")
So out of 14 male Swiss billionaires 9 of them inherited their fortune.
In [17]:
female_Swiss_billionaires_list[female_Swiss_billionaires_list['selfmade'] == 'inherited'].count().head(1)
female_inherited = female_Swiss_billionaires_list[female_Swiss_billionaires_list['selfmade'] == 'inherited'].count().head()
female_inherited
#print("Out of 8 Swiss female billionaires, only one woman made her fortune on her own")
Out[17]:
year 7
name 7
rank 7
citizenship 7
countrycode 7
dtype: int64
In [18]:
recent[(recent['gender'] == 'female') & (recent['selfmade'] == 'self-made') & (recent['countrycode'] == 'CHE')]
Out[18]:
year
name
rank
citizenship
countrycode
networthusbillion
selfmade
typeofwealth
gender
age
...
relationshiptocompany
foundingdate
gdpcurrentus
sourceofwealth
notes
notes2
source
source_2
source_3
source_4
1921
2014
Rafaela Aponte
506
Switzerland
CHE
3.2
self-made
founder non-finance
female
NaN
...
founder
1970.0
NaN
NaN
listed as co-founders of company
NaN
http://www.forbes.com/profile/gianluigi-rafael...
https://businessexecutives.wordpress.com/2014/...
NaN
NaN
1 rows × 30 columns
In [19]:
recent[(recent['gender'] == 'female')].sort_values(by='networthusbillion', ascending=False)
Out[19]:
year
name
rank
citizenship
countrycode
networthusbillion
selfmade
typeofwealth
gender
age
...
relationshiptocompany
foundingdate
gdpcurrentus
sourceofwealth
notes
notes2
source
source_2
source_3
source_4
429
2014
Christy Walton
9
United States
USA
36.7
inherited
inherited
female
59.0
...
relation
1962.0
NaN
Wal-Mart
widow
NaN
http://www.forbes.com/profile/christy-walton/
NaN
NaN
NaN
1469
2014
Liliane Bettencourt
11
France
FRA
34.5
inherited
inherited
female
91.0
...
relation
1909.0
NaN
L'Oreal
inherited from father
NaN
http://www.forbes.com/profile/liliane-bettenco...
NaN
NaN
NaN
106
2014
Alice Walton
13
United States
USA
34.3
inherited
inherited
female
64.0
...
relation
1962.0
NaN
Wal-Mart
inherited from father
NaN
http://www.forbes.com/profile/nancy-walton-lau...
NaN
NaN
NaN
1029
2014
Jacqueline Mars
31
United States
USA
20.0
inherited
inherited
female
74.0
...
relation
1911.0
NaN
candy
3rd generation
NaN
http://en.wikipedia.org/wiki/Forrest_Mars,_Jr.
http://www.forbes.com/lists/2010/10/billionair...
NaN
NaN
819
2014
Gina Rinehart
46
Australia
AUS
17.7
inherited
inherited
female
60.0
...
relation
1955.0
NaN
mining
inherited from father
NaN
http://www.ft.com/cms/s/2/047b7ab0-7643-11e5-a...
NaN
NaN
NaN
2311
2014
Susanne Klatten
49
Germany
DEU
17.4
inherited
inherited
female
51.0
...
relation
1916.0
NaN
BMW, pharmaceuticals
inherited from father
NaN
http://en.wikipedia.org/wiki/Susanne_Klatten
NaN
NaN
NaN
12
2014
Abigail Johnson
50
United States
USA
17.3
inherited
inherited
female
52.0
...
relation
1946.0
NaN
money management
3rd generation
no male siblings
http://en.wikipedia.org/wiki/Edward_Johnson,_III
https://www.fidelity.com/about-fidelity/our-he...
NaN
NaN
998
2014
Iris Fontbona
58
Chile
CHL
15.5
inherited
inherited
female
71.0
...
relation
1888.0
NaN
mining
widow
NaN
http://en.wikipedia.org/wiki/Andr%C3%B3nico_Lu...
http://www.nytimes.com/2005/08/29/business/wor...
NaN
NaN
181
2014
Anne Cox Chambers
58
United States
USA
15.5
inherited
inherited
female
94.0
...
relation
1898.0
NaN
media
inherited from brother
NaN
http://en.wikipedia.org/wiki/Anne_Cox_Chambers
http://www.forbes.com/lists/2010/10/billionair...
http://www.nytimes.com/2007/05/30/business/med...
NaN
1386
2014
Laurene Powell Jobs
73
United States
USA
14.0
inherited
inherited
female
50.0
...
relation
1976.0
NaN
Apple, Disney
widow
NaN
http://www.nytimes.com/2011/10/06/business/ste...
NaN
NaN
NaN
1147
2014
Johanna Quandt
82
Germany
DEU
12.8
inherited
inherited
female
87.0
...
relation
1916.0
NaN
BMW
widow
NaN
http://en.wikipedia.org/wiki/Stefan_Quandt
NaN
NaN
NaN
1703
2014
Miuccia Prada
102
Italy
ITA
11.1
inherited
inherited
female
64.0
...
relation
1913.0
NaN
Prada
inherited from uncle
NaN
http://en.wikipedia.org/wiki/Miuccia_Prada
http://www.forbes.com/profile/miuccia-prada/
NaN
NaN
363
2014
Charlene de Carvalho-Heineken
113
Netherlands
NLD
10.4
inherited
inherited
female
59.0
...
relation
1864.0
NaN
Heineken
inherited 3 billion pounds upon death of fathe...
NaN
http://en.wikipedia.org/wiki/Charlene_de_Carva...
http://en.wikipedia.org/wiki/Freddy_Heineken
http://fortune.com/2014/12/03/heineken-charlen...
NaN
350
2014
Carrie Perrodo
122
France
FRA
10.0
inherited
inherited
female
63.0
...
relation
1975.0
NaN
Inherited
widow
NaN
http://en.wikipedia.org/wiki/Perenco
NaN
NaN
NaN
636
2014
Elaine Marshall
147
United States
USA
8.8
inherited
inherited
female
71.0
...
relation
1940.0
NaN
diversified
widow
NaN
http://www.forbes.com/profile/elaine-marshall/
NaN
NaN
NaN
192
2014
Antonia Johnson
153
Sweden
SWE
8.5
inherited
inherited
female
70.0
...
relation
1873.0
NaN
diversified
4th generation
NaN
http://en.wikipedia.org/wiki/Antonia_Ax:son_Jo...
http://www.forbes.com/profile/antonia-johnson/
NaN
NaN
1557
2014
Margarita Louis-Dreyfus
165
Switzerland
CHE
8.1
inherited
inherited
female
50.0
...
relation
1851.0
NaN
commodities
widow of 4th generation heir
holds 60% of organization
http://en.wikipedia.org/wiki/Robert_Louis-Dreyfus
NaN
NaN
NaN
290
2014
Blair Parry-Okeden
168
United States
USA
7.7
inherited
inherited
female
63.0
...
relation
1898.0
NaN
media
3rd generation
no role in company
http://www.forbes.com/profile/blair-parry-okeden/
NaN
NaN
NaN
2559
2014
Yang Huiyan
196
China
CHN
6.9
inherited
inherited
female
32.0
...
relation
1997.0
NaN
real estate
inherited from father
NaN
http://en.wikipedia.org/wiki/Yang_Huiyan
NaN
NaN
NaN
685
2014
Eva Gonda Rivera
212
Mexico
MEX
6.4
inherited
inherited
female
NaN
...
relation
1890.0
NaN
beverages
widow of former president
shares went to her and her four daughers
http://es.wikipedia.org/wiki/Eva_Gonda_Rivera
http://en.wikipedia.org/wiki/FEMSA
http://www.forbes.com/profile/eva-gonda-de-riv...
NaN
1802
2014
Pansy Ho
212
Hong Kong
HKG
6.4
inherited
inherited
female
51.0
...
relation
1962.0
NaN
casinos
inherited from father,family had 40 year gover...
one of 17 children, co-chair of MGM China, hei...
http://en.wikipedia.org/wiki/Pansy_Ho
http://en.wikipedia.org/wiki/Sociedade_de_Turi...
http://www.telegraph.co.uk/news/worldnews/asia...
NaN
480
2014
Dannine Avara
215
United States
USA
6.3
inherited
inherited
female
50.0
...
relation
1968.0
NaN
pipelines
inherited from father
NaN
http://en.wikipedia.org/wiki/Dannine_Avara
http://www.forbes.com/profile/dannine-avara/
NaN
NaN
1933
2014
Randa Williams
215
United States
USA
6.3
inherited
inherited
female
52.0
...
relation
1968.0
NaN
pipelines
inherited from father
NaN
http://en.wikipedia.org/wiki/Randa_Williams
http://www.forbes.com/profile/dannine-avara/
NaN
NaN
1694
2014
Milane Frantz
215
United States
USA
6.3
inherited
inherited
female
44.0
...
relation
1968.0
NaN
pipelines
inherited from father
NaN
http://en.wikipedia.org/wiki/Milane_Frantz
http://www.forbes.com/profile/dannine-avara/
NaN
NaN
2143
2014
Sandra Ortega Mera
227
Spain
ESP
6.1
inherited
inherited
female
45.0
...
relation
1975.0
NaN
Zara
inherited from mother
NaN
http://www.forbes.com/profile/sandra-ortega-mera/
NaN
NaN
NaN
355
2014
Chan Laiwa
234
China
CHN
6.0
self-made
self-made finance
female
73.0
...
founder
1988.0
NaN
real estate
NaN
NaN
http://en.wikipedia.org/wiki/Chan_Laiwa
http://www.fuwahgroup.com/index.php?option=com...
NaN
NaN
769
2014
Gayle Cook
240
United States
USA
5.8
self-made
founder non-finance
female
80.0
...
founder
1963.0
NaN
medical devices
NaN
NaN
http://www.forbes.com/profile/gayle-cook/
http://www.bloomberg.com/news/articles/2014-06...
NaN
NaN
1561
2014
Maria Asuncion Aramburuzabala
270
Mexico
MEX
5.2
inherited
inherited
female
50.0
...
relation
1925.0
NaN
beer
3rd generation
NaN
http://en.wikipedia.org/wiki/Mar%C3%ADa_Asunci...
http://www.forbes.com/profile/maria-asuncion-a...
NaN
NaN
1330
2014
Kirsten Rausing
278
Sweden
SWE
5.1
inherited
inherited
female
61.0
...
relation
1951.0
NaN
packaging
3rd generation
NaN
http://en.wikipedia.org/wiki/Rausing_family
http://www.forbes.com/profile/finn-rausing/
NaN
NaN
1026
2014
Jacqueline Desmarais
278
Canada
CAN
5.1
inherited
inherited
female
85.0
...
relation
1925.0
NaN
financial services
widow
NaN
http://en.wikipedia.org/wiki/Paul_Desmarais
NaN
NaN
NaN
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
1564
2014
Maria Ines de Lafuente Lacroze
1372
Argentina
ARG
1.2
inherited
inherited
female
69.0
...
relation
1926.0
NaN
cement firm inheritance
inherited from mother
only daughter
http://www.forbes.com/profile/maria-ines-de-la...
http://en.wikipedia.org/wiki/Loma_Negra
NaN
NaN
459
2014
Daisy Igel
1442
Brazil
BRA
1.2
inherited
inherited
female
86.0
...
relation
1930.0
NaN
gas, petrochemicals
inherited from father
not involved in company, brother chaired until...
http://www.forbes.com/profile/daisy-igel/
http://en.wikipedia.org/wiki/Ultrapar
NaN
NaN
2554
2014
Xiu Li Hawken
1372
United Kingdom
GBR
1.2
self-made
self-made finance
female
51.0
...
owner
2007.0
NaN
real estate
NaN
NaN
http://www.forbes.com/profile/xiu-li-hawken/
http://investing.businessweek.com/research/sto...
NaN
NaN
1071
2014
Jane Lauder
1442
United States
USA
1.2
inherited
inherited
female
41.0
...
relation
1946.0
NaN
inherited, cosmetics
3rd generation
NaN
http://en.wikipedia.org/wiki/Jane_Lauder
http://www.bloomberg.com/news/articles/2013-11...
NaN
NaN
533
2014
Denise York
1372
United States
USA
1.2
inherited
inherited
female
63.0
...
relation
1944.0
NaN
San Francisco 49ers
inherited from father
co-chair of corporation before its selloff, ha...
http://en.wikipedia.org/wiki/Denise_DeBartolo_...
http://en.wikipedia.org/wiki/The_DeBartolo_Cor...
http://www.nytimes.com/1994/12/20/obituaries/e...
NaN
1410
2014
Lee Seo-Hyun
1442
South Korea
KOR
1.2
inherited
inherited
female
40.0
...
relation
1938.0
NaN
Samsung
3rd generation
divisional president
http://www.forbes.com/profile/lee-seo-hyun/
NaN
NaN
NaN
596
2014
Dorothea Steinbruch
1372
Brazil
BRA
1.2
inherited
inherited
female
NaN
...
relation
1967.0
NaN
steel
widow
NaN
http://pt.wikipedia.org/wiki/Doroth%C3%A9a_Ste...
http://investing.businessweek.com/research/sto...
NaN
NaN
1460
2014
Lia Maria Aguiar
1372
Brazil
BRA
1.2
inherited
inherited
female
76.0
...
relation
1943.0
NaN
banking inheritance
inherited from father
NaN
http://www.forbes.com/profile/lina-maria-aguiar/
http://en.wikipedia.org/wiki/Banco_Bradesco
NaN
NaN
988
2014
Ilona Herlin
1465
Finland
FIN
1.1
inherited
inherited
female
49.0
...
relation
1924.0
NaN
elevators, escalators
4th generation
NaN
http://www.forbes.com/profile/ilona-herlin/
NaN
NaN
NaN
412
2014
Cheung Yan
1540
China
CHN
1.1
self-made
founder non-finance
female
57.0
...
founder
1995.0
NaN
paper
NaN
NaN
http://www.forbes.com/profile/cheung-yan/
http://en.wikipedia.org/wiki/Nine_Dragons_Pape...
http://www.newyorker.com/magazine/2009/03/30/w...
NaN
2477
2014
Wang Laichun
1540
China
CHN
1.1
self-made
executive
female
46.0
...
chairwomen
2004.0
NaN
electronics components
NaN
NaN
http://www.forbes.com/profile/wang-laichun/
http://web.luxshare-ict.com/en/AboutLuxshare-I...
NaN
NaN
130
2014
Ana Lucia de Mattos Barretto Villela
1465
Brazil
BRA
1.1
inherited
inherited
female
40.0
...
relation
1966.0
NaN
banking
inherited from parents
NaN
http://www.forbes.com/profile/ana-lucia-de-mat...
NaN
NaN
NaN
2189
2014
Sheryl Sandberg
1540
United States
USA
1.1
self-made
executive
female
44.0
...
COO
2004.0
NaN
Facebook
NaN
NaN
http://en.wikipedia.org/wiki/Sheryl_Sandberg
http://www.newyorker.com/magazine/2011/07/11/a...
NaN
NaN
23
2014
Aerin Lauder Zinterhofer
1465
United States
USA
1.1
inherited
inherited
female
44.0
...
relation
1946.0
NaN
inherited, cosmetics
3rd generation
NaN
http://en.wikipedia.org/wiki/Jane_Lauder
http://investing.businessweek.com/research/sto...
NaN
NaN
1605
2014
Mary Perkins
1540
United States
USA
1.1
self-made
founder non-finance
female
NaN
...
founder
1984.0
NaN
NaN
NaN
NaN
http://en.wikipedia.org/wiki/Mary_Perkins
http://www.express.co.uk/life-style/life/44946...
NaN
NaN
1697
2014
Miriam Blocher
1465
Switzerland
CHE
1.1
inherited
inherited
female
39.0
...
relation
1936.0
NaN
chemicals
inherited from father
NaN
http://de.wikipedia.org/wiki/Ems-Chemie
http://www.ems-group.com/en/about-ems/about-em...
NaN
NaN
534
2014
Deniz Sahenk
1540
Turkey
TUR
1.1
inherited
inherited
female
68.0
...
relation
1951.0
NaN
bank, media
widow
NaN
http://en.wikipedia.org/wiki/Do%C4%9Fu%C5%9F_H...
http://www.forbes.com/profile/deniz-sahenk/
http://www.dogusgrubu.com.tr/en/about-us/histo...
NaN
1752
2014
Neide Helena de Moraes
1540
Brazil
BRA
1.1
inherited
inherited
female
59.0
...
relation
1919.0
NaN
diversified
inherited from father
NaN
http://en.wikipedia.org/wiki/Ant%C3%B4nio_Erm%...
http://www.reuters.com/article/brazil-ermirio-...
NaN
NaN
2047
2014
Roberta Anamaria Civita
1540
Brazil
BRA
1.1
inherited
inherited
female
NaN
...
relation
1950.0
NaN
media
3rd generation
NaN
http://www.forbes.com/profile/roberta-anamaria...
NaN
NaN
NaN
1488
2014
Liu Xiaomeng
1565
China
CHN
1.0
self-made
executive
female
59.0
...
investor
1990.0
NaN
appliance retailer
NaN
NaN
http://www.forbes.com/profile/liu-xiaomeng/
NaN
NaN
NaN
2147
2014
Sara Blakely
1565
United States
USA
1.0
self-made
founder non-finance
female
43.0
...
founder
2000.0
NaN
Spanx
NaN
NaN
http://en.wikipedia.org/wiki/Spanx
http://www.wsj.com/articles/a-day-in-the-life-...
NaN
NaN
178
2014
Anne Beaufour
1565
France
FRA
1.0
inherited
inherited
female
50.0
...
relation
1929.0
NaN
pharmaceuticals
3rd generation
NaN
http://en.wikipedia.org/wiki/Ipsen
http://www.ipsen.com/le-groupe/historique-du-g...
http://www.forbes.com/profile/anne-beaufour/
NaN
2401
2014
Tory Burch
1565
United States
USA
1.0
self-made
founder non-finance
female
47.0
...
founder
2004.0
NaN
fashion
NaN
NaN
http://en.wikipedia.org/wiki/J._Christopher_Burch
http://www.vanityfair.com/news/2007/02/tory-bu...
NaN
NaN
1720
2014
Monika Schoeller
1565
Germany
DEU
1.0
inherited
inherited
female
75.0
...
relation
1948.0
NaN
publishing
inherited from father
NaN
http://www.forbes.com/profile/monika-schoeller/
NaN
NaN
NaN
1089
2014
Jeanine Dick
1565
France
FRA
1.0
inherited
inherited
female
77.0
...
relation
1968.0
NaN
animal pharmaceuticals
widow
NaN
http://www.forbes.com/profile/jeanine-dick/
NaN
NaN
NaN
145
2014
Andrea Reimann-Ciardelli
1565
United States
USA
1.0
inherited
inherited
female
NaN
...
relation
1923.0
NaN
consumer goods
inherited from father
no involvement in company
http://www.forbes.com/profile/matthias-reimann...
NaN
NaN
NaN
1371
2014
Lam Fong Ngo
1565
Macau
MAC
1.0
self-made
self-made finance
female
NaN
...
Vice Chairman
1997.0
NaN
casinos
NaN
NaN
http://www.forbes.com/profile/david-chow-1/
http://www.macaulegend.com/html/about_mileston...
Macau Legend to roll the dice on HK IPO; But l...
NaN
171
2014
Angela Bennett
1565
Australia
AUS
1.0
inherited
inherited
female
69.0
...
relation
1955.0
NaN
mining
inherited from father
shared fortune with brother
http://www.forbes.com/profile/angela-bennett/
NaN
NaN
NaN
638
2014
Elena Baturina
1565
Russia
RUS
1.0
self-made
privatized and resources
female
50.0
...
founder
1991.0
NaN
construction
former wife mayor of moscow
NaN
http://en.wikipedia.org/wiki/Yelena_Baturina
MOSCOW OVERTAKES NEW YORK AS THE BILLIONAIRES'...
NaN
NaN
990
2014
Ina Chan
1565
Hong Kong
HKG
1.0
inherited
inherited
female
60.0
...
relation
1962.0
NaN
casinos
3rd wife
NaN
http://www.forbes.com/profile/ina-chan/
NaN
NaN
NaN
180 rows × 30 columns
In [20]:
recent[(recent['gender'] == 'female') & (recent['selfmade'] == 'self-made')].sort_values(by='networthusbillion', ascending=False)
Out[20]:
year
name
rank
citizenship
countrycode
networthusbillion
selfmade
typeofwealth
gender
age
...
relationshiptocompany
foundingdate
gdpcurrentus
sourceofwealth
notes
notes2
source
source_2
source_3
source_4
355
2014
Chan Laiwa
234
China
CHN
6.0
self-made
self-made finance
female
73.0
...
founder
1988.0
NaN
real estate
NaN
NaN
http://en.wikipedia.org/wiki/Chan_Laiwa
http://www.fuwahgroup.com/index.php?option=com...
NaN
NaN
769
2014
Gayle Cook
240
United States
USA
5.8
self-made
founder non-finance
female
80.0
...
founder
1963.0
NaN
medical devices
NaN
NaN
http://www.forbes.com/profile/gayle-cook/
http://www.bloomberg.com/news/articles/2014-06...
NaN
NaN
546
2014
Diane Hendricks
325
United States
USA
4.6
self-made
founder non-finance
female
67.0
...
founder
1982.0
NaN
roofing
NaN
NaN
http://en.wikipedia.org/wiki/Ken_Hendricks
http://en.wikipedia.org/wiki/ABC_Supply
http://www.gazettextra.com/news/2007/dec/21/bi...
NaN
2550
2014
Wu Yajun
408
China
CHN
3.7
self-made
privatized and resources
female
50.0
...
founder
1995.0
NaN
real estate
used her time working as a journalist at the S...
NaN
http://en.wikipedia.org/wiki/Wu_Yajun
NaN
NaN
NaN
1005
2014
Isabel dos Santos
408
Angola
AGO
3.7
self-made
privatized and resources
female
40.0
...
founder
1997.0
NaN
investments
daughter of Angolan president Jose Eduaredo do...
NaN
The Philadelphia Daily News January 6, 2016 We...
http://www.forbes.com/profile/isabel-dos-santos/
http://www.forbes.com/sites/kerryadolan/2013/0...
NaN
2599
2014
Zhang Xin
408
China
CHN
3.7
self-made
self-made finance
female
48.0
...
founder
1995.0
NaN
real estate
NaN
NaN
http://en.wikipedia.org/wiki/Zhang_Xin_(busine...
NaN
NaN
NaN
595
2014
Doris Fisher
483
United States
USA
3.3
self-made
founder non-finance
female
82.0
...
founder
1969.0
NaN
Gap
NaN
NaN
http://en.wikipedia.org/wiki/Doris_F._Fisher
http://en.wikipedia.org/wiki/Gap_(clothing_ret...
http://www.forbes.com/profile/doris-fisher/
NaN
1921
2014
Rafaela Aponte
506
Switzerland
CHE
3.2
self-made
founder non-finance
female
NaN
...
founder
1970.0
NaN
NaN
listed as co-founders of company
NaN
http://www.forbes.com/profile/gianluigi-rafael...
https://businessexecutives.wordpress.com/2014/...
NaN
NaN
1255
2014
Judy Faulkner
520
United States
USA
3.1
self-made
founder non-finance
female
70.0
...
founder
1979.0
NaN
health IT
NaN
NaN
http://en.wikipedia.org/wiki/Judith_Faulkner
http://www.forbes.com/sites/zinamoukheiber/201...
http://www.epic.com/about-index.php
NaN
822
2014
Giuliana Benetton
580
Italy
ITA
2.9
self-made
founder non-finance
female
76.0
...
founder
1965.0
NaN
clothing, investments
NaN
NaN
http://en.wikipedia.org/wiki/Benetton_family
http://www.benettongroup.com/the-group/profile...
http://www.forbes.com/profile/giuliana-benetton/
NaN
1791
2014
Oprah Winfrey
580
United States
USA
2.9
self-made
founder non-finance
female
60.0
...
founder, chairwoman, ceo
1986.0
NaN
television
NaN
NaN
http://en.wikipedia.org/wiki/Oprah_Winfrey
http://www.nytimes.com/1989/03/12/arts/televis...
NaN
NaN
1130
2014
Jin Sook Chang
580
United States
USA
2.9
self-made
founder non-finance
female
NaN
...
founder
1984.0
NaN
NaN
NaN
NaN
http://www.forbes.com/profile/jin-sook-do-won-...
HOW I MADE IT: DO WON CHANG; Keeping Forever 2...
NaN
NaN
637
2014
Elaine Wynn
642
United States
USA
2.7
self-made
self-made finance
female
70.0
...
founder
1973.0
NaN
casinos, hotels
NaN
NaN
http://www.forbes.com/profile/elaine-wynn/
A DREAM IN THE DESERT;LAS VEGAS -- KNOWN FOR S...
NaN
NaN
451
2014
Cristina Green
663
United Kingdom
GBR
2.6
self-made
executive
female
NaN
...
owner
1903.0
NaN
NaN
NaN
NaN
http://en.wikipedia.org/wiki/Arcadia_Group
http://www.forbes.com/profile/philip-cristina-...
NaN
NaN
711
2014
Folorunsho Alakija
687
Nigeria
NGA
2.5
self-made
privatized and resources
female
63.0
...
founder
1991.0
NaN
oil
fashion company included clients such as the f...
NaN
http://en.wikipedia.org/wiki/Folorunsho_Alakija
http://www.famfa.com/
The other side of Africa: number of billionair...
NaN
1210
2014
Johnelle Hunt
828
United States
USA
2.1
self-made
founder non-finance
female
82.0
...
founder
1961.0
NaN
trucking
NaN
NaN
http://www.forbes.com/profile/johnelle-hunt/
http://en.wikipedia.org/wiki/Johnnie_Bryan_Hunt
Fayetteville First couple, woman elected to st...
NaN
1625
2014
Meg Whitman
869
United States
USA
2.0
self-made
executive
female
57.0
...
president and ceo
1935.0
NaN
Ebay
NaN
NaN
http://en.wikipedia.org/wiki/Meg_Whitman
http://en.wikipedia.org/wiki/Hewlett-Packard
http://www.forbes.com/profile/meg-whitman/
NaN
604
2014
Dulce Pugliese de Godoy Bueno
931
Brazil
BRA
1.9
self-made
founder non-finance
female
66.0
...
founder
1972.0
NaN
hospitals, health care
NaN
NaN
http://www.forbes.com/profile/edson-de-godoy-b...
http://www.bloomberg.com/research/stocks/priva...
NaN
NaN
558
2014
Dinara Kulibaeva
988
Kazakhstan
KAZ
1.8
self-made
privatized and resources
female
46.0
...
owner
1923.0
NaN
banking
daughter of Kazakhstan's president
NaN
http://www.halykbank.kz/en/history
http://www.forbes.com/profile/dinara-kulibaeva/
NaN
NaN
430
2014
Chu Lam Yiu
988
Hong Kong
HKG
1.8
self-made
founder non-finance
female
44.0
...
founder and chairwoman
1990.0
NaN
flavorings
NaN
NaN
http://www.forbes.com/profile/chu-lam-yiu/
http://www.wantchinatimes.com/news-subclass-cn...
NaN
NaN
1567
2014
Marian Ilitch
1036
United States
USA
1.8
self-made
founder non-finance
female
NaN
...
founder
1959.0
NaN
NaN
NaN
NaN
http://en.wikipedia.org/wiki/Mike_Ilitch
http://www.littlecaesars.com/AboutUs/TheIlitch...
A Marriage Is a Partnership, Except in Basebal...
NaN
1527
2014
Lynda Resnick
1036
United States
USA
1.8
self-made
executive
female
NaN
...
owner
1934.0
NaN
NaN
Purchased in 1979
NaN
http://en.wikipedia.org/wiki/Lynda_Resnick
http://www.forbes.com/profile/stewart-and-lynd...
http://www.teleflora.com/info/about
NaN
1256
2014
Judy Love
1036
United States
USA
1.8
self-made
founder non-finance
female
NaN
...
founder
1964.0
NaN
NaN
NaN
NaN
http://en.wikipedia.org/wiki/Love's_Travel_Sto...
http://www.loves.com/AboutUs/History.aspx
Oklahoma's Judy Love among nation's wealthiest...
NaN
1893
2014
Pollyanna Chu
1092
Hong Kong
HKG
1.6
self-made
self-made finance
female
56.0
...
founder
1992.0
NaN
financial services
NaN
NaN
http://en.wikipedia.org/wiki/Pollyanna_Chu
NaN
NaN
NaN
532
2014
Denise Coates
1092
United Kingdom
GBR
1.6
self-made
founder non-finance
female
46.0
...
founder
2000.0
NaN
Online Gambling
NaN
NaN
http://en.wikipedia.org/wiki/Denise_Coates
http://www.forbes.com/profile/denise-coates/
NaN
NaN
899
2014
He Qiaonu
1154
China
CHN
1.5
self-made
founder non-finance
female
48.0
...
founder
1992.0
NaN
landscape architecture
NaN
NaN
http://www.orientscape.com/index.php/About/ove...
forbes
NaN
NaN
1415
2014
Lei Jufang
1210
China
CHN
1.4
self-made
founder non-finance
female
61.0
...
founder
1993.0
NaN
pharmaceuticals
NaN
NaN
http://www.forbes.com/profile/lei-jufang/
http://cheezheng.en.hisupplier.com/about-us.html
NaN
NaN
1836
2014
Peggy Cherng
1270
United States
USA
1.4
self-made
founder non-finance
female
NaN
...
founder
1973.0
NaN
NaN
NaN
NaN
http://en.wikipedia.org/wiki/Andrew_Cherng
http://www.forbes.com/profile/andrew-peggy-che...
Cooking Up a Powerhouse of Chinese Fast Food L...
NaN
2554
2014
Xiu Li Hawken
1372
United Kingdom
GBR
1.2
self-made
self-made finance
female
51.0
...
owner
2007.0
NaN
real estate
NaN
NaN
http://www.forbes.com/profile/xiu-li-hawken/
http://investing.businessweek.com/research/sto...
NaN
NaN
1605
2014
Mary Perkins
1540
United States
USA
1.1
self-made
founder non-finance
female
NaN
...
founder
1984.0
NaN
NaN
NaN
NaN
http://en.wikipedia.org/wiki/Mary_Perkins
http://www.express.co.uk/life-style/life/44946...
NaN
NaN
412
2014
Cheung Yan
1540
China
CHN
1.1
self-made
founder non-finance
female
57.0
...
founder
1995.0
NaN
paper
NaN
NaN
http://www.forbes.com/profile/cheung-yan/
http://en.wikipedia.org/wiki/Nine_Dragons_Pape...
http://www.newyorker.com/magazine/2009/03/30/w...
NaN
2189
2014
Sheryl Sandberg
1540
United States
USA
1.1
self-made
executive
female
44.0
...
COO
2004.0
NaN
Facebook
NaN
NaN
http://en.wikipedia.org/wiki/Sheryl_Sandberg
http://www.newyorker.com/magazine/2011/07/11/a...
NaN
NaN
2477
2014
Wang Laichun
1540
China
CHN
1.1
self-made
executive
female
46.0
...
chairwomen
2004.0
NaN
electronics components
NaN
NaN
http://www.forbes.com/profile/wang-laichun/
http://web.luxshare-ict.com/en/AboutLuxshare-I...
NaN
NaN
1371
2014
Lam Fong Ngo
1565
Macau
MAC
1.0
self-made
self-made finance
female
NaN
...
Vice Chairman
1997.0
NaN
casinos
NaN
NaN
http://www.forbes.com/profile/david-chow-1/
http://www.macaulegend.com/html/about_mileston...
Macau Legend to roll the dice on HK IPO; But l...
NaN
2147
2014
Sara Blakely
1565
United States
USA
1.0
self-made
founder non-finance
female
43.0
...
founder
2000.0
NaN
Spanx
NaN
NaN
http://en.wikipedia.org/wiki/Spanx
http://www.wsj.com/articles/a-day-in-the-life-...
NaN
NaN
2401
2014
Tory Burch
1565
United States
USA
1.0
self-made
founder non-finance
female
47.0
...
founder
2004.0
NaN
fashion
NaN
NaN
http://en.wikipedia.org/wiki/J._Christopher_Burch
http://www.vanityfair.com/news/2007/02/tory-bu...
NaN
NaN
638
2014
Elena Baturina
1565
Russia
RUS
1.0
self-made
privatized and resources
female
50.0
...
founder
1991.0
NaN
construction
former wife mayor of moscow
NaN
http://en.wikipedia.org/wiki/Yelena_Baturina
MOSCOW OVERTAKES NEW YORK AS THE BILLIONAIRES'...
NaN
NaN
1488
2014
Liu Xiaomeng
1565
China
CHN
1.0
self-made
executive
female
59.0
...
investor
1990.0
NaN
appliance retailer
NaN
NaN
http://www.forbes.com/profile/liu-xiaomeng/
NaN
NaN
NaN
38 rows × 30 columns
Interesting. Chan Laiwa, the richest self made woman in the world is from China. She is also above 70. The second on the list, Gayle Cook, is even over 80.
In [21]:
recent[(recent['gender'] == 'male') & (recent['selfmade'] == 'self-made')].sort_values(by='networthusbillion', ascending=False)
Out[21]:
year
name
rank
citizenship
countrycode
networthusbillion
selfmade
typeofwealth
gender
age
...
relationshiptocompany
foundingdate
gdpcurrentus
sourceofwealth
notes
notes2
source
source_2
source_3
source_4
284
2014
Bill Gates
1
United States
USA
76.0
self-made
founder non-finance
male
58.0
...
founder
1975.0
NaN
Microsoft
NaN
NaN
http://www.forbes.com/profile/bill-gates/
NaN
NaN
NaN
348
2014
Carlos Slim Helu
2
Mexico
MEX
72.0
self-made
privatized and resources
male
74.0
...
founder
1990.0
NaN
telecom
NaN
NaN
http://www.ozy.com/provocateurs/carlos-slims-w...
NaN
NaN
NaN
124
2014
Amancio Ortega
3
Spain
ESP
64.0
self-made
founder non-finance
male
77.0
...
founder
1975.0
NaN
retail
NaN
NaN
http://www.forbes.com/profile/amancio-ortega/
NaN
NaN
NaN
2491
2014
Warren Buffett
4
United States
USA
58.2
self-made
founder non-finance
male
83.0
...
founder
1839.0
NaN
Berkshire Hathaway
NaN
NaN
http://www.forbes.com/lists/2009/10/billionair...
http://www.forbes.com/companies/berkshire-hath...
NaN
NaN
1377
2014
Larry Ellison
5
United States
USA
48.0
self-made
founder non-finance
male
69.0
...
founder
1977.0
NaN
Oracle
NaN
NaN
http://www.forbes.com/profile/larry-ellison/
http://www.businessinsider.com/how-larry-ellis...
NaN
NaN
2185
2014
Sheldon Adelson
8
United States
USA
38.0
self-made
self-made finance
male
80.0
...
founder
1952.0
NaN
casinos
NaN
NaN
http://www.forbes.com/profile/sheldon-adelson/
http://lasvegassun.com/news/1996/nov/26/rat-pa...
NaN
NaN
267
2014
Bernard Arnault
15
France
FRA
33.5
self-made
founder non-finance
male
64.0
...
founder
1987.0
NaN
LVMH
NaN
NaN
http://www.forbes.com/profile/bernard-arnault/
http://www.lvmh.com/group/milestones/1593-to-t...
NaN
NaN
1642
2014
Michael Bloomberg
16
United States
USA
33.0
self-made
founder non-finance
male
72.0
...
founder
1981.0
NaN
Bloomberg LP
NaN
NaN
http://www.bloomberg.com/company/bloomberg-fac...
NaN
NaN
NaN
1378
2014
Larry Page
17
United States
USA
32.3
self-made
founder non-finance
male
40.0
...
founder
1998.0
NaN
Google
NaN
NaN
http://www.forbes.com/profile/larry-page/
http://www.businessinsider.com/larry-page-the-...
NaN
NaN
1093
2014
Jeff Bezos
18
United States
USA
32.0
self-made
founder non-finance
male
50.0
...
founder
1995.0
NaN
Amazon.com
NaN
NaN
http://www.businessinsider.com/amazon-jeff-bez...
NaN
NaN
NaN
2169
2014
Sergey Brin
19
United States
USA
31.8
self-made
founder non-finance
male
40.0
...
founder
1998.0
NaN
Google
NaN
NaN
http://www.forbes.com/profile/larry-page/
NaN
NaN
NaN
1454
2014
Li Ka-shing
20
Hong Kong
HKG
31.0
self-made
self-made finance
male
85.0
...
founder
1950.0
NaN
diversified
(Made money because real estate price fell aft...
NaN
http://www.ckh.com.hk/en/about/chairman.php
NaN
NaN
NaN
1586
2014
Mark Zuckerberg
21
United States
USA
28.5
self-made
founder non-finance
male
29.0
...
founder
2004.0
NaN
Facebook
NaN
NaN
http://www.forbes.com/profile/mark-zuckerberg/
NaN
NaN
NaN
1680
2014
Michele Ferrero
22
Italy
ITA
26.5
self-made
executive
male
88.0
...
relation
1946.0
NaN
chocolates
relauched father's initial recepie for hazeln...
NaN
http://en.wikipedia.org/wiki/Ferrero_SpA
http://www.bbc.com/news/business-31477547
NaN
NaN
111
2014
Aliko Dangote
23
Nigeria
NGA
25.0
self-made
founder non-finance
male
56.0
...
founder and CEO
1981.0
NaN
cement, sugar, flour
NaN
NaN
http://en.wikipedia.org/wiki/Aliko_Dangote
http://www.nigerianobservernews.com/2014/12/23...
NaN
NaN
1275
2014
Karl Albrecht
23
Germany
DEU
25.0
self-made
executive
male
94.0
...
relation
1914.0
NaN
retail
(split from Aldi Nord in 1966, but both branch...
took over mother's single grocerty store
http://en.wikipedia.org/wiki/Karl_Albrecht
http://www.bloomberg.com/news/articles/2014-07...
http://aldiuscareers.com/about-aldi/history
NaN
330
2014
Carl Icahn
25
United States
USA
24.5
self-made
self-made finance
male
78.0
...
founder
1968.0
NaN
investments
NaN
NaN
http://en.wikipedia.org/wiki/Carl_Icahn
http://www.bloomberg.com/research/stocks/priva...
NaN
NaN
789
2014
George Soros
26
United States
USA
23.0
self-made
self-made finance
male
83.0
...
founder
1969.0
NaN
hedge funds
(made money by speculating against pound durin...
NaN
http://en.wikipedia.org/wiki/George_Soros
http://www.bloomberg.com/research/stocks/priva...
NaN
NaN
1518
2014
Lui Che Woo
28
Hong Kong
HKG
22.0
self-made
self-made finance
male
84.0
...
founder/chairman
1955.0
NaN
casinos
NaN
NaN
http://www.ft.com/intl/cms/s/0/492a829c-94a8-1...
http://www.kwah.com/aboutus_process.php?lang=en
NaN
NaN
1902
2014
Prince Alwaleed Bin Talal Alsaud
30
Saudi Arabia
SAU
20.4
self-made
privatized and resources
male
58.0
...
founder
1980.0
NaN
investments
member of Saudi Royal family
NaN
http://www.kingdom.com.sa/about-us/history
Murdoch's saviour: a rich prince Australian Fi...
NaN
NaN
1223
2014
Jorge Paulo Lemann
34
Brazil
BRA
19.7
self-made
founder non-finance
male
74.0
...
founder
1999.0
NaN
beer
also founded Banco Garantia in 1970s, sold in ...
NaN
http://en.wikipedia.org/wiki/Jorge_Paulo_Lemann
http://www.theguardian.com/business/2008/jul/1...
NaN
NaN
1413
2014
Lee Shau Kee
35
Hong Kong
HKG
19.6
self-made
self-made finance
male
86.0
...
founder/chairman
1976.0
NaN
diversified
NaN
NaN
http://en.wikipedia.org/wiki/Lee_Shau-kee
http://www.hld.com/en/about/profile.shtml
NaN
NaN
2268
2014
Steve Ballmer
36
United States
USA
19.3
self-made
executive
male
57.0
...
CEO
1975.0
NaN
Microsoft
NaN
NaN
http://en.wikipedia.org/wiki/Steve_Ballmer
http://www.bloomberg.com/news/articles/2015-12...
NaN
NaN
1437
2014
Leonardo Del Vecchio
38
Italy
ITA
19.2
self-made
founder non-finance
male
78.0
...
founder
1961.0
NaN
eyeglasses
NaN
NaN
http://en.wikipedia.org/wiki/Leonardo_Del_Vecchio
http://www.forbes.com/profile/leonardo-del-vec...
NaN
NaN
1420
2014
Len Blavatnik
39
United States
USA
18.7
self-made
self-made finance
male
56.0
...
founder
1990.0
NaN
diversified
NaN
NaN
http://www.renova.ru/en/about/history/
http://www.forbes.com/profile/len-blavatnik/
http://www.businessinsider.com/len-blavatnik-i...
NaN
112
2014
Alisher Usmanov
40
Russia
RUS
18.6
self-made
privatized and resources
male
60.0
...
founder
1999.0
NaN
steel, telecom, investments
NaN
NaN
http://usm-group.com/
https://en.wikipedia.org/wiki/Metalloinvest
Russia and the Rams Oligarchy: How the Rams, c...
NaN
1617
2014
Masayoshi Son
42
Japan
JPN
18.4
self-made
founder non-finance
male
56.0
...
founder/CEO
1981.0
NaN
internet, telecom
NaN
NaN
http://en.wikipedia.org/wiki/Masayoshi_Son
http://www.softbank.jp/en/corp/about/history/
http://www.softbank.jp/en/corp/about/message/
NaN
1864
2014
Phil Knight
42
United States
USA
18.4
self-made
founder non-finance
male
76.0
...
founder
1964.0
NaN
Nike
NaN
NaN
http://en.wikipedia.org/wiki/Phil_Knight
http://www.usatoday.com/story/sports/2015/09/3...
NaN
NaN
2321
2014
Tadashi Yanai
45
Japan
JPN
17.9
self-made
founder non-finance
male
65.0
...
founder
1963.0
NaN
retail
NaN
NaN
http://www.forbes.com/profile/tadashi-yanai/
http://www.telegraph.co.uk/fashion/brands/meet...
NaN
NaN
1690
2014
Mikhail Fridman
47
Russia
RUS
17.6
self-made
privatized and resources
male
49.0
...
founder
1989.0
NaN
oil, banking, telecom
NaN
NaN
http://www.forbes.com/profile/mikhail-fridman/
The Autumn Of the Oligarchs The New York Times...
NaN
NaN
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
560
2014
Ding Shizhong
1565
China
CHN
1.0
self-made
executive
male
43.0
...
director
1966.0
NaN
retail
NaN
NaN
http://www.sce-re.com/en/about.asp
http://www.forbes.com/profile/ding-shizhong/
NaN
NaN
843
2014
Graham Kirkham
1565
United Kingdom
GBR
1.0
self-made
founder non-finance
male
69.0
...
founder
1983.0
NaN
furniture retail
NaN
NaN
http://en.wikipedia.org/wiki/Graham_Kirkham,_B...
http://www.forbes.com/profile/graham-kirkham/
http://www.independent.co.uk/news/business/kir...
NaN
81
2014
Alexander Vik
1565
Norway
NOR
1.0
self-made
self-made finance
male
59.0
...
investor
1980.0
NaN
investments
many business ventures have failed but still m...
NaN
http://www.forbes.com/sites/nathanvardi/2014/0...
NaN
NaN
NaN
2316
2014
T.S. Kalyanaraman
1565
India
IND
1.0
self-made
founder non-finance
male
66.0
...
founder
1993.0
NaN
jewelry
NaN
NaN
http://en.wikipedia.org/wiki/T.S._Kalyanaraman
http://www.bloomberg.com/news/articles/2013-01...
NaN
NaN
952
2014
Horst Julius Pudwill
1565
Germany
DEU
1.0
self-made
founder non-finance
male
69.0
...
founder
1985.0
NaN
manufacturing
NaN
NaN
http://www.forbes.com/profile/horst-julius-pud...
NaN
NaN
NaN
569
2014
Dmitry Korzhev
1565
Russia
RUS
1.0
self-made
founder non-finance
male
50.0
...
founder
1993.0
NaN
retail
NaN
NaN
http://www.forbes.com/profile/dmitry-korzhev/
http://www.bloomberg.com/profiles/people/16388...
NaN
NaN
573
2014
Dmitry Troitsky
1565
Russia
RUS
1.0
self-made
founder non-finance
male
49.0
...
founder
1993.0
NaN
retail
NaN
NaN
http://www.forbes.com/profile/dmitry-troitsky/
NaN
NaN
NaN
2359
2014
Thomas Bailey
1565
United States
USA
1.0
self-made
self-made finance
male
77.0
...
founder
1969.0
NaN
finance
NaN
NaN
http://en.wikipedia.org/wiki/Thomas_H._Bailey
http://en.wikipedia.org/wiki/Janus_Capital_Group
http://archive.fortune.com/magazines/fortune/f...
NaN
2365
2014
Thomas Kaplan
1565
United States
USA
1.0
self-made
self-made finance
male
51.0
...
founder
1993.0
NaN
investments
NaN
NaN
http://en.wikipedia.org/wiki/Thomas_Kaplan
http://www.wsj.com/articles/SB1000142405270230...
NaN
NaN
2158
2014
Seo Jung-Jin
1565
South Korea
KOR
1.0
self-made
founder non-finance
male
56.0
...
founder
2002.0
NaN
Celltrion
NaN
NaN
http://www.forbes.com/profile/seo-jung-jin/
http://www.bloomberg.com/research/stocks/peopl...
NaN
NaN
482
2014
Dariusz Milek
1565
Poland
POL
1.0
self-made
self-made finance
male
46.0
...
founder
1989.0
NaN
real estate, retail
NaN
NaN
http://pl.wikipedia.org/wiki/Dariusz_Mi%C5%82ek
http://www.forbes.com/profile/dariusz-milek/
NaN
NaN
2472
2014
Wang Jianfeng
1565
China
CHN
1.0
self-made
founder non-finance
male
44.0
...
founder
2004.0
NaN
auto parts
NaN
NaN
http://www.forbes.com/profile/wang-jianfeng/
http://en.joyson.cn/About/RongYuZiZHi.html
NaN
NaN
1971
2014
Richard Chang
1565
Taiwan
Taiwan
1.0
self-made
self-made finance
male
67.0
...
founder
1984.0
NaN
real estate, electronics
NaN
NaN
http://www.forbes.com/profile/richard-chang-1/
http://www.aseglobal.com/en/About/Milestones.asp
NaN
NaN
2549
2014
Wu Xiong
1565
China
CHN
1.0
self-made
executive
male
NaN
...
owner
1999.0
NaN
infant formula
NaN
NaN
http://www.forbes.com/profile/wu-xiong/
NaN
NaN
NaN
2547
2014
Wu Chung-Yi
1565
Taiwan
Taiwan
1.0
self-made
executive
male
55.0
...
investor
1991.0
NaN
manufacturing
NaN
NaN
http://www.forbes.com/profile/wu-chung-yi/
http://en.wikipedia.org/wiki/Tingyi_(Cayman_Is...
Tingyi-Campbell sale talks stay on track South...
NaN
1834
2014
Pavel Tykac
1565
Czech Republic
CZE
1.0
self-made
privatized and resources
male
49.0
...
investor
1995.0
NaN
coal mine
took advantage of Czech Republics privitizatio...
NaN
http://www.forbes.com/profile/pavel-tykac/
http://cs.wikipedia.org/wiki/Pavel_Tyka%C4%8D
NaN
NaN
234
2014
B.R. Shetty
1565
India
IND
1.0
self-made
founder non-finance
male
72.0
...
founder
1975.0
NaN
healthcare
NaN
NaN
http://en.wikipedia.org/wiki/B._R._Shetty
http://www.nmchealth.com/dr-br-shetty/
NaN
NaN
1868
2014
Philip Falcone
1565
United States
USA
1.0
self-made
self-made finance
male
51.0
...
founder
2001.0
NaN
hedge funds
NaN
NaN
http://en.wikipedia.org/wiki/Philip_Falcone
FROM IRON RANGE HOCKEY HERO TO WALL STREET STA...
NaN
NaN
660
2014
Enrique Banuelos
1565
Spain
ESP
1.0
self-made
self-made finance
male
48.0
...
founder
1982.0
NaN
real estate
NaN
NaN
http://en.wikipedia.org/wiki/Enrique_Ba%C3%B1u...
http://www.forbes.com/lists/2010/10/billionair...
NaN
NaN
164
2014
Andrew Gotianun
1565
Philippines
PHL
1.0
self-made
self-made finance
male
86.0
...
founder
1955.0
NaN
real estate
NaN
NaN
http://en.wikipedia.org/wiki/Andrew_Gotianun
http://www.forbes.com/profile/andrew-gotianun/
Second-hand car dealer discovers road to riche...
NaN
1204
2014
John Van Lieshout
1565
Australia
AUS
1.0
self-made
self-made finance
male
68.0
...
founder
NaN
NaN
real estate
NaN
NaN
http://www.forbes.com/profile/john-van-lieshout/
The Courier Mail (Australia) July 25, 2015 Sat...
NaN
NaN
2107
2014
Ryan Kavanaugh
1565
United States
USA
1.0
self-made
founder non-finance
male
39.0
...
founder
2004.0
NaN
Movies
NaN
NaN
http://en.wikipedia.org/wiki/Ryan_Kavanaugh
http://en.wikipedia.org/wiki/Relativity_Media
http://www.vanityfair.com/news/2010/03/kavanau...
NaN
1191
2014
John Morgridge
1565
United States
USA
1.0
self-made
executive
male
80.0
...
ceo
1984.0
NaN
Cisco
NaN
NaN
A hiring that changed the course of networking...
http://en.wikipedia.org/wiki/Cisco_Systems
http://www.forbes.com/profile/john-morgridge/
NaN
2484
2014
Wang Yong
1565
China
CHN
1.0
self-made
founder non-finance
male
63.0
...
founder
1986.0
NaN
food sweeteners
NaN
NaN
http://www.forbes.com/profile/wang-yong/
NaN
NaN
NaN
2024
2014
Robert Ingham
1565
Australia
AUS
1.0
self-made
executive
male
82.0
...
relation
1918.0
NaN
agribusiness
inherited family farm and turned it into poutr...
NaN
http://www.forbes.com/profile/robert-ingham/
http://en.wikipedia.org/wiki/Inghams_Enterprises
NaN
NaN
1131
2014
Jitendra Virwani
1565
India
IND
1.0
self-made
self-made finance
male
48.0
...
founder
1993.0
NaN
real estate
NaN
NaN
http://www.forbes.com/profile/jitendra-virwani/
NaN
NaN
NaN
2479
2014
Wang Muqing
1565
China
CHN
1.0
self-made
founder non-finance
male
63.0
...
founder
1999.0
NaN
auto distribution
NaN
NaN
http://www.forbes.com/profile/wang-muqing/
http://www.zhengtongauto.com/en/milestone.html
NaN
NaN
1125
2014
Jim Thompson
1565
United States
USA
1.0
self-made
founder non-finance
male
74.0
...
founder
1965.0
NaN
logistics
NaN
NaN
http://en.wikipedia.org/wiki/James_E._Thompson
http://en.wikipedia.org/wiki/Crown_Worldwide_G...
http://www.forbes.com/profile/jim-thompson/
NaN
2092
2014
Rostam Azizi
1565
Tanzania
TZA
1.0
self-made
executive
male
49.0
...
investor
1999.0
NaN
telecom, investments
NaN
NaN
http://www.forbes.com/profile/rostam-azizi/
http://en.wikipedia.org/wiki/Vodacom_Tanzania
http://www.thecitizen.co.tz/News/Rostam--Dewji...
NaN
1225
2014
Jorge Rodriguez Rodriguez
1565
Peru
PER
1.0
self-made
founder non-finance
male
68.0
...
founder
1967.0
NaN
processed milk
NaN
NaN
http://www.forbes.com/profile/jorge-rodriguez-...
http://www.bloomberg.com/research/stocks/priva...
NaN
NaN
1108 rows × 30 columns
In [22]:
recent.sort_values(by='age').head(5)
Out[22]:
year
name
rank
citizenship
countrycode
networthusbillion
selfmade
typeofwealth
gender
age
...
relationshiptocompany
foundingdate
gdpcurrentus
sourceofwealth
notes
notes2
source
source_2
source_3
source_4
1838
2014
Perenna Kei
1284
Hong Kong
HKG
1.3
inherited
inherited
female
24.0
...
relation
1996.0
NaN
real estate
inherited from father
NaN
http://en.wikipedia.org/wiki/Perenna_Kei
http://www.loganestate.com/en/about.aspx?ftid=294
NaN
NaN
605
2014
Dustin Moskovitz
202
United States
USA
6.8
self-made
founder non-finance
male
29.0
...
founder
2004.0
NaN
Facebook
NaN
NaN
http://en.wikipedia.org/wiki/Dustin_Moskovitz
http://www.forbes.com/profile/dustin-moskovitz/
https://www.facebook.com/facebook/info?tab=pag...
NaN
1586
2014
Mark Zuckerberg
21
United States
USA
28.5
self-made
founder non-finance
male
29.0
...
founder
2004.0
NaN
Facebook
NaN
NaN
http://www.forbes.com/profile/mark-zuckerberg/
NaN
NaN
NaN
189
2014
Anton Kathrein, Jr.
1270
Germany
DEU
1.4
inherited
inherited
male
29.0
...
relation
1919.0
NaN
antennas
3rd generation
NaN
http://www.forbes.com/profile/anton-kathrein-jr/#
NaN
NaN
NaN
602
2014
Drew Houston
1372
United States
USA
1.2
self-made
founder non-finance
male
30.0
...
founder
2007.0
NaN
Dropbox
NaN
NaN
http://en.wikipedia.org/wiki/Drew_Houston
http://en.wikipedia.org/wiki/Dropbox_(service)
http://www.forbes.com/profile/drew-houston/
NaN
5 rows × 30 columns
In [23]:
female_billionaires = recent[recent['gender'] == 'female']
male_billionaires = recent[recent['gender'] == 'male']
print("Female billionaire average wealth:", female_billionaires['networthusbillion'].mean())
print("Male billionaire average wealth:", male_billionaires['networthusbillion'].mean())
females = female_billionaires['networthusbillion'].mean()
males = male_billionaires['networthusbillion'].mean()
difference = ((float(females) - float(males)) * 1000000000)
females_more_than_males = int(difference) / 1000000
Female billionaire average wealth: 3.92055555556
Male billionaire average wealth: 3.9027155465
In [24]:
print("Female billionaires are slighthly richer than their mail counterparts. In average they have", int(females_more_than_males), "Million US-Dollars more than men." )
Female billionaires are slighthly richer than their mail counterparts. In average they have 17 Million US-Dollars more than men.
In [25]:
total_billions_women = int(female_billionaires['networthusbillion'].sum())
In [26]:
total_billions_men = int(male_billionaires['networthusbillion'].sum())
In [27]:
print("In total, however, male billions have", int(total_billions_men / total_billions_women), "times more billions than women. In total:",total_billions_men, "billion US-Dollars. That is more than the GDP of France.")
In total, however, male billions have 8 times more billions than women. In total: 5748 billion US-Dollars. That is more than the GDP of France.
In [28]:
recent.sort_values(by='networthusbillion', ascending = False).head(5)
Out[28]:
year
name
rank
citizenship
countrycode
networthusbillion
selfmade
typeofwealth
gender
age
...
relationshiptocompany
foundingdate
gdpcurrentus
sourceofwealth
notes
notes2
source
source_2
source_3
source_4
284
2014
Bill Gates
1
United States
USA
76.0
self-made
founder non-finance
male
58.0
...
founder
1975.0
NaN
Microsoft
NaN
NaN
http://www.forbes.com/profile/bill-gates/
NaN
NaN
NaN
348
2014
Carlos Slim Helu
2
Mexico
MEX
72.0
self-made
privatized and resources
male
74.0
...
founder
1990.0
NaN
telecom
NaN
NaN
http://www.ozy.com/provocateurs/carlos-slims-w...
NaN
NaN
NaN
124
2014
Amancio Ortega
3
Spain
ESP
64.0
self-made
founder non-finance
male
77.0
...
founder
1975.0
NaN
retail
NaN
NaN
http://www.forbes.com/profile/amancio-ortega/
NaN
NaN
NaN
2491
2014
Warren Buffett
4
United States
USA
58.2
self-made
founder non-finance
male
83.0
...
founder
1839.0
NaN
Berkshire Hathaway
NaN
NaN
http://www.forbes.com/lists/2009/10/billionair...
http://www.forbes.com/companies/berkshire-hath...
NaN
NaN
1377
2014
Larry Ellison
5
United States
USA
48.0
self-made
founder non-finance
male
69.0
...
founder
1977.0
NaN
Oracle
NaN
NaN
http://www.forbes.com/profile/larry-ellison/
http://www.businessinsider.com/how-larry-ellis...
NaN
NaN
5 rows × 30 columns
In [29]:
recent.groupby(['countrycode'])['networthusbillion'].mean().sort_values(ascending = False).head(15)
Out[29]:
countrycode
MEX 8.931250
NGA 8.325000
COL 7.650000
SAU 7.000000
SWE 6.142105
FRA 5.472093
GEO 5.200000
IRL 5.100000
CYP 4.925000
NZL 4.900000
HKG 4.748889
DEU 4.722353
ESP 4.715385
USA 4.654108
ITA 4.517143
Name: networthusbillion, dtype: float64
In [30]:
%matplotlib inline
In [31]:
import matplotlib.pyplot as plt
plt.style.available
plt.style.use('fivethirtyeight')
In [32]:
recent.plot(kind='scatter', x='age', y='networthusbillion')
plt.savefig("Scatterplot_billionaires_worldwide.svg")
In [ ]:
In [ ]:
Content source: barjacks/foundations-homework
Similar notebooks: