Video Games Rating By 'ESRB'

Predict the ESRB rating for games based on the content that the game rated on.

@kaggle.imohtn_video_games_rating_by_esrb

Table List

2 tables(101.28 KB)

Test Esrb

@kaggle.imohtn_video_games_rating_by_esrb.test_esrb

35.76 KB
500 rows
34 columns

title Title	console Console	blood Blood	blood_and_gore Blood And Gore	cartoon_violence Cartoon Violence	crude_humor Crude Humor	fantasy_violence Fantasy Violence	intense_violence Intense Violence	lyrics Lyrics	mild_blood Mild Blood	mild_suggestive_themes Mild Suggestive Themes	no_descriptors No Descriptors	nudity Nudity	sexual_content Sexual Content	strong_janguage Strong Janguage	suggestive_themes Suggestive Themes	violence Violence	esrb_rating Esrb Rating
Still Time		1														1	T
Surf World Series	1										1						E
The Metronomicon: Slay the Dance Floor	1		1			1											T
Windjammers											1						E
Rock of Ages 2: Bigger and Boulder					1		1	1									ET
South Park: The Fractured but Whole	1		1						1			1	1	1			M
Dishonored: Death of the Outsider	1		1				1								1		M
Battle of the Bulge	1					1											ET
F1 2017	1										1						E
NARUTO SHIPPUDEN™: Ultimate Ninja® STORM 2	1			1					1	1		1					T


CREATE TABLE test_esrb (
  "title" VARCHAR,
  "console" BIGINT,
  "alcohol_reference" BIGINT,
  "animated_blood" BIGINT,
  "blood" BIGINT,
  "blood_and_gore" BIGINT,
  "cartoon_violence" BIGINT,
  "crude_humor" BIGINT,
  "drug_reference" BIGINT,
  "fantasy_violence" BIGINT,
  "intense_violence" BIGINT,
  "language" BIGINT,
  "lyrics" BIGINT,
  "mature_humor" BIGINT,
  "mild_blood" BIGINT,
  "mild_cartoon_violence" BIGINT,
  "mild_fantasy_violence" BIGINT,
  "mild_language" BIGINT,
  "mild_lyrics" BIGINT,
  "mild_suggestive_themes" BIGINT,
  "mild_violence" BIGINT,
  "no_descriptors" BIGINT,
  "nudity" BIGINT,
  "partial_nudity" BIGINT,
  "sexual_content" BIGINT,
  "sexual_themes" BIGINT,
  "simulated_gambling" BIGINT,
  "strong_janguage" BIGINT,
  "strong_sexual_content" BIGINT,
  "suggestive_themes" BIGINT,
  "use_of_alcohol" BIGINT,
  "use_of_drugs_and_alcohol" BIGINT,
  "violence" BIGINT,
  "esrb_rating" VARCHAR
);