About this Dataset

Video Games Rating By 'ESRB'

This data contains the name for 1895 games with 34 of ESRB rating content with the name and console as features for each game.
A single data point is represented as a binary value 0-1 for Console and a binary vector for the features of ESRB content.
RP, EC, A, rating is not provided in the current version of the data, it might be included in the next updates.

File descriptions:

Video_games_esrb_rating.csv - the training set
test_esrb.csv - the test set

Data dictionary

Feature	type	description	Keys
title	string	Name of the game.	----
console	int	The console on which the game was released.	0 = PS4 1 = PS4 & Xbox_one
Alcohol_Reference	int	Reference to and/or images of alcoholic beverages.	0 = no1 = yes
Animated_Blood	int	Discolored and/or unrealistic depictions of blood.	0 = no1 = yes
Blood	int	Depictions of blood.	0 = no1 = yes
Blood_and_Gore	int	Depictions of blood or the mutilation of body parts.	0 = no1 = yes
Cartoon_Violence	int	Violent actions involving cartoon-like situations and characters. May include violence where a character is unharmed after the action has been inflicted.	0 = no1 = yes
Crude_Humor	int	Depictions or dialogue involving vulgar antics, including "bathroom" humor.	0 = no1 = yes
DrugRe_ference	int	Reference to and/or images of illegal drugs.	0 = no1 = yes
Fantasy_Violence	int	Violent actions of a fantasy nature, involving human or non-human characters in situations easily distinguishable from real life.	0 = no1 = yes
Intense_Violence	int	Graphic and realistic-looking depictions of physical conflict. May involve extreme and/or realistic blood, gore, weapons, and depictions of human injury and death.	0 = no1 = yes
Language	int	Moderate use of profanity.	0 = no1 = yes
Lyrics	int	References to profanity, sexuality, violence, alcohol, or drug use in music.	0 = no1 = yes
Mature_Humor	int	Depictions or dialogue involving "adult" humor, including sexual references.	0 = no1 = yes
Mild_Blood	int	Some blood.	0 = no1 = yes
Mild_Cartoon_Violence	int	Some violent actions involving cartoon.	0 = no1 = yes
Mild_Fantasy_Violence	int	Some violent actions of a fantasy nature.	0 = no1 = yes
Mild_Language	int	Mild to moderate use of profanity.	0 = no1 = yes
Mild_Lyrics	int	Mild References to profanity, sexuality, violence, alcohol, or drug use in music.	0 = no1 = yes
Mild_Suggestive_Themes	int	some provocative references or materials	0 = no1 = yes
Mild_Violence	int	Some scenes involving aggressive conflict.	0 = no1 = yes
No_Descriptors	int	No content descriptors.	0 = no1 = yes
Nudity	int	Graphic or prolonged depictions of nudity.	0 = no1 = yes
Partial_Nudity	int	Brief and/or mild depictions of nudity.	0 = no1 = yes
Sexual_Content	int	Non-explicit depictions of sexual behavior, possibly including partial nudity.	0 = no1 = yes
Sexual_Themes	int	References to sex or sexuality.	0 = no1 = yes
Simulated_Gambling	int	Player can gamble without betting or wagering real cash or currency.	0 = no1 = yes
Strong_Language	int	Explicit and/or frequent use of profanity.	0 = no1 = yes
Strong_Sexual_Content	int	Explicit and/or frequent depictions of sexual behavior, possibly including nudity.	0 = no1 = yes
Suggestive_Themes	int	Provocative references or materials.	0 = no1 = yes
Use_of_Alcohol	int	The consumption of alcoholic beverages.	0 = no1 = yes
Use_of_Drugs_and_Alcohol	int	The consumption of alcoholic and drugs beverages.	0 = no1 = yes
Violence	int	Scenes involving aggressive conflict. May contain bloodless dismemberment.	0 = no1 = yes
ESRB_rating	string	rating: RP - EC - E - E+10 - T - M - A	RP , EC , E , ET , T , M , A

ESRB rating description:

ESRB_rating	Description
RP	Rating Pending
EC	Early Childhood
E	Everyone
E 10+	Everyone 10+
T	Teen
M	Mature
A	Adult

Tables

Test Esrb

@kaggle.imohtn_video_games_rating_by_esrb.test_esrb

35.76 KB
500 rows
34 columns


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
);

Video Games Esrb Rating

@kaggle.imohtn_video_games_rating_by_esrb.video_games_esrb_rating

65.52 KB
1895 rows
34 columns


CREATE TABLE video_games_esrb_rating (
  "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
);