Game Of Thrones

Explore deaths and battles from this fantasy world

@kaggle.mylesoneill_game_of_thrones

Table List

3 tables(137.22 KB)

Battles

Character Deaths

Character Predictions

Character Predictions

@kaggle.mylesoneill_game_of_thrones.character_predictions

92.27 KB
1946 rows
33 columns

s_no S.No	actual Actual	pred Pred	alive Alive	plod Plod	name Name	title Title	male Male	culture Culture	dateofbirth DateOfBirth	dateofdeath DateoFdeath	mother Mother	father Father	heir Heir	house House	spouse Spouse	book1 Book1	book2 Book2	book3 Book3	book4 Book4	book5 Book5	isalivemother IsAliveMother	isalivefather IsAliveFather	isaliveheir IsAliveHeir	isalivespouse IsAliveSpouse	ismarried IsMarried	isnoble IsNoble	age Age	numdeadrelations NumDeadRelations	booldeadrelations BoolDeadRelations	ispopular IsPopular	popularity Popularity	isalive IsAlive
1			0.054	0.946	Viserys II Targaryen	nan	1	nan			Rhaenyra Targaryen	Daemon Targaryen	Aegon IV Targaryen	nan	nan						1							11	1	1	0.605351170568561
2	1		0.387	0.613	Walder Frey	Lord of the Crossing	1	Rivermen	208		nan	nan	nan	House Frey	Perra Royce	1	1	1	1	1				1	1	1	97	1	1	1	0.896321070234113	1
3	1		0.493	0.507	Addison Hill	Ser	1	nan			nan	nan	nan	House Swyft	nan				1							1					0.267558528428093	1
4			0.076	0.924	Aemma Arryn	Queen		nan	82	105	nan	nan	nan	House Arryn	Viserys I Targaryen										1	1	23				0.183946488294314
5	1	1	0.617	0.383	Sylva Santagar	Greenstone		Dornish	276		nan	nan	nan	House Santagar	Eldon Estermont				1					1	1	1	29				0.0434782608695652	1
6	1		0.021	0.979	Tommen Baratheon	nan	1	nan			Cersei Lannister	Robert Baratheon	Myrcella Baratheon	nan	nan						1	1	1					5	1	1	1	1
7			0.014	0.986	Valarr Targaryen	Hand of the King	1	Valyrian	183	209	nan	nan	nan	House Targaryen	Kiera of Tyrosh									1	1	1	26			1	0.431438127090301
8			0.036	0.964	Viserys I Targaryen	nan	1	nan			Alyssa Targaryen	Baelon Targaryen	Rhaenyra Targaryen	nan	nan						1	1	1					5	1	1	0.678929765886287
9		1	0.724	0.276	Wilbert	Ser	1	nan		298	nan	nan	nan	nan	nan			1								1					0.0066889632107023
10	1		0.391	0.609	Wilbert Osgrey	Ser	1	nan			nan	nan	nan	House Osgrey	nan											1					0.020066889632107	1


CREATE TABLE character_predictions (
  "s_no" BIGINT,
  "actual" BIGINT,
  "pred" BIGINT,
  "alive" DOUBLE,
  "plod" DOUBLE,
  "name" VARCHAR,
  "title" VARCHAR,
  "male" BIGINT,
  "culture" VARCHAR,
  "dateofbirth" DOUBLE,
  "dateofdeath" DOUBLE,
  "mother" VARCHAR,
  "father" VARCHAR,
  "heir" VARCHAR,
  "house" VARCHAR,
  "spouse" VARCHAR,
  "book1" BIGINT,
  "book2" BIGINT,
  "book3" BIGINT,
  "book4" BIGINT,
  "book5" BIGINT,
  "isalivemother" DOUBLE,
  "isalivefather" DOUBLE,
  "isaliveheir" DOUBLE,
  "isalivespouse" DOUBLE,
  "ismarried" BIGINT,
  "isnoble" BIGINT,
  "age" DOUBLE,
  "numdeadrelations" BIGINT,
  "booldeadrelations" BIGINT,
  "ispopular" BIGINT,
  "popularity" DOUBLE,
  "isalive" BIGINT
);