Dataset: MysteryDetective-AnimeManga

About this Dataset

MysteryDetective-AnimeManga

Inspiration
This data collection is part of a research project on the usage of mystery games in a game based learning context. We are looking at different digital media related to mystery genre for inspiration and data-driven insights to design our games.

Context
The purpose of this dataset is to gain insights into popular manga and anime series, and factors driving the popularity.
I am particularly interested in the following questions:

What kind of mystery/detective manga/anime series have the highest rating or fan following (fantasy, science fiction, slice of life)?
Are there any similarities between popular series in terms of story (kinds of mysteries solved, methods used to solve the mysteries)?
Does there exist a correlation between author/studio and manga/anime rating?
Which series are popular in certain demographic audience (young/teen/old males/females)? Can we infer why from the synopsis?
What patterns can be discovered from the data considering the source of the series (manga, novel, TV original, game)?
Kagglers are welcome to contribute through data analysis and visualization. NLP enthusiasts are cheerfully requested to join.

Source
The data was scraped from MyAnimeList website with Mystery and Detective genres.
On 14th July 2022, around 2.5K manga and 1K anime titles were scraped.

Tables

Myanimelist Anime Mystery Detective Cleaned

@kaggle.muhammadadiltalay_mysteryanimemanga.myanimelist_anime_mystery_detective_cleaned

410.04 KB
922 rows
33 columns


CREATE TABLE myanimelist_anime_mystery_detective_cleaned (
  "title" VARCHAR,
  "subtitle" VARCHAR,
  "title_url" VARCHAR,
  "status" VARCHAR,
  "episodes" VARCHAR,
  "episodeduration" VARCHAR,
  "synopsis" VARCHAR,
  "studio" VARCHAR,
  "source" VARCHAR,
  "demography" VARCHAR,
  "rating" DOUBLE,
  "members" VARCHAR,
  "type" VARCHAR,
  "year" VARCHAR,
  "gourmet" BOOLEAN,
  "sports" BOOLEAN,
  "romance" BOOLEAN,
  "adventure" BOOLEAN,
  "avant_garde" BOOLEAN,
  "supernatural" BOOLEAN,
  "suspense" BOOLEAN,
  "slice_of_life" BOOLEAN,
  "sci_fi" BOOLEAN,
  "horror" BOOLEAN,
  "comedy" BOOLEAN,
  "drama" BOOLEAN,
  "fantasy" BOOLEAN,
  "mystery" BOOLEAN,
  "boys_love" BOOLEAN,
  "hentai" BOOLEAN,
  "action" BOOLEAN,
  "ecchi" BOOLEAN,
  "girls_love" BOOLEAN
);

Myanimelist Anime Mystery Detective

@kaggle.muhammadadiltalay_mysteryanimemanga.myanimelist_anime_mystery_detective

407.09 KB
922 rows
16 columns


CREATE TABLE myanimelist_anime_mystery_detective (
  "title" VARCHAR,
  "title_url" VARCHAR,
  "title1" VARCHAR,
  "info" VARCHAR,
  "item2" VARCHAR,
  "info3" VARCHAR,
  "info4" VARCHAR,
  "genre" VARCHAR,
  "genre6" VARCHAR,
  "genre8" VARCHAR,
  "genre10" VARCHAR,
  "preline" VARCHAR,
  "property12" VARCHAR,
  "property14" VARCHAR,
  "property20" VARCHAR,
  "keywords" VARCHAR
);

Myanimelist Manga Mystery Detective Cleaned

@kaggle.muhammadadiltalay_mysteryanimemanga.myanimelist_manga_mystery_detective_cleaned

776.47 KB
2489 rows
33 columns


CREATE TABLE myanimelist_manga_mystery_detective_cleaned (
  "title" VARCHAR,
  "title_url" VARCHAR,
  "status" VARCHAR,
  "synopsis" VARCHAR,
  "author" VARCHAR,
  "demography" VARCHAR,
  "rating" DOUBLE,
  "members" VARCHAR,
  "type" VARCHAR,
  "year" VARCHAR,
  "volumes" VARCHAR,
  "chapters" VARCHAR,
  "fantasy" BOOLEAN,
  "avant_garde" BOOLEAN,
  "sports" BOOLEAN,
  "ecchi" BOOLEAN,
  "boys_love" BOOLEAN,
  "comedy" BOOLEAN,
  "award_winning" BOOLEAN,
  "drama" BOOLEAN,
  "slice_of_life" BOOLEAN,
  "girls_love" BOOLEAN,
  "horror" BOOLEAN,
  "erotica" BOOLEAN,
  "hentai" BOOLEAN,
  "supernatural" BOOLEAN,
  "mystery" BOOLEAN,
  "action" BOOLEAN,
  "sci_fi" BOOLEAN,
  "romance" BOOLEAN,
  "gourmet" BOOLEAN,
  "adventure" BOOLEAN,
  "suspense" BOOLEAN
);

Myanimelist Manga Mystery Detective

@kaggle.muhammadadiltalay_mysteryanimemanga.myanimelist_manga_mystery_detective

771.47 KB
2489 rows
14 columns


CREATE TABLE myanimelist_manga_mystery_detective (
  "title_url" VARCHAR,
  "title1" VARCHAR,
  "info" VARCHAR,
  "item2" VARCHAR,
  "info3" VARCHAR,
  "genre" VARCHAR,
  "genre5" VARCHAR,
  "genre7" VARCHAR,
  "genre9" VARCHAR,
  "preline" VARCHAR,
  "property" VARCHAR,
  "property21" VARCHAR,
  "score" VARCHAR,
  "scormemitem" VARCHAR
);