Billionaires Dataset Cleaned

ready for Exploratory Data Analysis and Modeling

@kaggle.javiersab_billionaires_dataset_cleaned

Table List

1 table(185.12 KB)

Df Ready

@kaggle.javiersab_billionaires_dataset_cleaned.df_ready

185.12 KB
2591 rows
30 columns

position Position	wealth Wealth	industry Industry	full_name Full Name	age Age	country_of_residence Country Of Residence	city_of_residence City Of Residence	source Source	citizenship Citizenship	gender Gender	birth_date Birth Date	last_name Last Name	first_name First Name	residence_state Residence State	residence_region Residence Region	birth_year Birth Year	birth_month Birth Month	birth_day Birth Day	cpi_country Cpi Country	cpi_change_country Cpi Change Country	gdp_country Gdp Country	g_tertiary_ed_enroll G Tertiary Ed Enroll	g_primary_ed_enroll G Primary Ed Enroll	life_expectancy Life Expectancy	tax_revenue Tax Revenue	tax_rate Tax Rate	country_pop Country Pop	country_lat Country Lat	country_long Country Long	continent Continent
1	211000	Fashion & Retail	Bernard Arnault & family	74	France	Paris	LVMH	France	M	Sat Mar 05 1949 00:00:00 GMT+0000 (Coordinated Universal Time)	Arnault	Bernard	No subdivisions info	No subdivisions info	1949	3	5	110.05	1.1	2715518274227	65.6	102.5	82.5	24.2	60.7	67059887	46.227638	2.213749	Europe
2	180000	Automotive	Elon Musk	51	United States	Austin	Tesla, SpaceX	United States	M	Mon Jun 28 1971 00:00:00 GMT+0000 (Coordinated Universal Time)	Musk	Elon	Texas	South	1971	6	28	117.24	7.5	21427700000000	88.2	101.8	78.5	9.6	36.6	328239523	37.09024	-95.712891	North America
3	114000	Technology	Jeff Bezos	59	United States	Medina	Amazon	United States	M	Sun Jan 12 1964 00:00:00 GMT+0000 (Coordinated Universal Time)	Bezos	Jeff	Washington	West	1964	1	12	117.24	7.5	21427700000000	88.2	101.8	78.5	9.6	36.6	328239523	37.09024	-95.712891	North America
4	107000	Technology	Larry Ellison	78	United States	Lanai	Oracle	United States	M	Thu Aug 17 1944 00:00:00 GMT+0000 (Coordinated Universal Time)	Ellison	Larry	Hawaii	West	1944	8	17	117.24	7.5	21427700000000	88.2	101.8	78.5	9.6	36.6	328239523	37.09024	-95.712891	North America
5	106000	Finance & Investments	Warren Buffett	92	United States	Omaha	Berkshire Hathaway	United States	M	Sat Aug 30 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Buffett	Warren	Nebraska	Midwest	1930	8	30	117.24	7.5	21427700000000	88.2	101.8	78.5	9.6	36.6	328239523	37.09024	-95.712891	North America
6	104000	Technology	Bill Gates	67	United States	Medina	Microsoft	United States	M	Fri Oct 28 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	Gates	Bill	Washington	West	1955	10	28	117.24	7.5	21427700000000	88.2	101.8	78.5	9.6	36.6	328239523	37.09024	-95.712891	North America
7	94500	Media & Entertainment	Michael Bloomberg	81	United States	New York	Bloomberg LP	United States	M	Sat Feb 14 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	Bloomberg	Michael	New York	Northeast	1942	2	14	117.24	7.5	21427700000000	88.2	101.8	78.5	9.6	36.6	328239523	37.09024	-95.712891	North America
8	93000	Telecom	Carlos Slim Helu & family	83	Mexico	Mexico City	Telecom	Mexico	M	Sun Jan 28 1940 00:00:00 GMT+0000 (Coordinated Universal Time)	Slim Helu	Carlos	No subdivisions info	No subdivisions info	1940	1	28	141.54	3.6	1258286717125	40.2	105.8	75	13.1	55.1	126014024	23.634501	-102.552784	North America
9	83400	Diversified	Mukesh Ambani	65	India	Mumbai	Diversified	India	M	Fri Apr 19 1957 00:00:00 GMT+0000 (Coordinated Universal Time)	Ambani	Mukesh	No subdivisions info	No subdivisions info	1957	4	19	180.44	7.7	2611000000000	28.1	113	69.4	11.2	49.7	1366417754	20.593684	78.96288	Asia
10	80700	Technology	Steve Ballmer	67	United States	Hunts Point	Microsoft	United States	M	Sat Mar 24 1956 00:00:00 GMT+0000 (Coordinated Universal Time)	Ballmer	Steve	Washington	West	1956	3	24	117.24	7.5	21427700000000	88.2	101.8	78.5	9.6	36.6	328239523	37.09024	-95.712891	North America


CREATE TABLE df_ready (
  "position" BIGINT,
  "wealth" BIGINT,
  "industry" VARCHAR,
  "full_name" VARCHAR,
  "age" BIGINT,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "source" VARCHAR,
  "citizenship" VARCHAR,
  "gender" VARCHAR,
  "birth_date" TIMESTAMP,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "residence_state" VARCHAR,
  "residence_region" VARCHAR,
  "birth_year" BIGINT,
  "birth_month" BIGINT,
  "birth_day" BIGINT,
  "cpi_country" VARCHAR,
  "cpi_change_country" VARCHAR,
  "gdp_country" BIGINT,
  "g_tertiary_ed_enroll" DOUBLE,
  "g_primary_ed_enroll" DOUBLE,
  "life_expectancy" DOUBLE,
  "tax_revenue" DOUBLE,
  "tax_rate" DOUBLE,
  "country_pop" BIGINT,
  "country_lat" DOUBLE,
  "country_long" DOUBLE,
  "continent" VARCHAR
);