Anime Recommendation Database 2020

Recommendation data from 320.0000 users and 16.000 animes at myanimelist.net

@kaggle.hernan4444_anime_recommendation_database_2020

Table List

5 tables(443.39 MB)

Anime

Anime

@kaggle.hernan4444_anime_recommendation_database_2020.anime

2.39 MB
17562 rows
35 columns

mal_id MAL ID	name Name	score Score	genres Genres	english_name English Name	japanese_name Japanese Name	type Type	episodes Episodes	aired Aired	premiered Premiered	producers Producers	licensors Licensors	studios Studios	source Source	duration Duration	rating Rating	ranked Ranked	popularity Popularity	members Members	favorites Favorites	watching Watching	completed Completed	on_hold On-Hold	dropped Dropped	plan_to_watch Plan To Watch	score_10 Score-10	score_9 Score-9	score_8 Score-8	score_7 Score-7	score_6 Score-6	score_5 Score-5	score_4 Score-4	score_3 Score-3	score_2 Score-2	score_1 Score-1
1	Cowboy Bebop	8.78	Action, Adventure, Comedy, Drama, Sci-Fi, Space	Cowboy Bebop	カウボーイビバップ	TV	26	Apr 3, 1998 to Apr 24, 1999	Spring 1998	Bandai Visual	Funimation, Bandai Entertainment	Sunrise	Original	24 min. per ep.	R - 17+ (violence & profanity)	28.0	39	1251960	61971	105808	718161	71513	26678	329800	229170.0	182126.0	131625.0	62330.0	20688.0	8904.0	3184.0	1357.0	741.0	1580.0
5	Cowboy Bebop: Tengoku no Tobira	8.39	Action, Drama, Mystery, Sci-Fi, Space	Cowboy Bebop:The Movie	カウボーイビバップ天国の扉	Movie	1	Sep 1, 2001	Unknown	Sunrise, Bandai Visual	Sony Pictures Entertainment	Bones	Original	1 hr. 55 min.	R - 17+ (violence & profanity)	159.0	518	273145	1174	4143	208333	1935	770	57964	30043.0	49201.0	49505.0	22632.0	5805.0	1877.0	577.0	221.0	109.0	379.0
6	Trigun	8.24	Action, Sci-Fi, Adventure, Comedy, Drama, Shounen	Trigun	トライガン	TV	26	Apr 1, 1998 to Sep 30, 1998	Spring 1998	Victor Entertainment	Funimation, Geneon Entertainment USA	Madhouse	Manga	24 min. per ep.	PG-13 - Teens 13 or older	266.0	201	558913	12944	29113	343492	25465	13925	146918	50229.0	75651.0	86142.0	49432.0	15376.0	5838.0	1965.0	664.0	316.0	533.0
7	Witch Hunter Robin	7.27	Action, Mystery, Police, Supernatural, Drama, Magic	Witch Hunter Robin	Witch Hunter ROBIN (ウイッチハンターロビン)	TV	26	Jul 2, 2002 to Dec 24, 2002	Summer 2002	TV Tokyo, Bandai Visual, Dentsu, Victor Entertainment	Funimation, Bandai Entertainment	Sunrise	Original	25 min. per ep.	PG-13 - Teens 13 or older	2481.0	1467	94683	587	4300	46165	5121	5378	33719	2182.0	4806.0	10128.0	11618.0	5709.0	2920.0	1083.0	353.0	164.0	131.0
8	Bouken Ou Beet	6.98	Adventure, Fantasy, Shounen, Supernatural	Beet the Vandel Buster	冒険王ビィト	TV	52	Sep 30, 2004 to Sep 29, 2005	Fall 2004	TV Tokyo, Dentsu	Unknown	Toei Animation	Manga	23 min. per ep.	PG - Children	3710.0	4369	13224	18	642	7314	766	1108	3394	312.0	529.0	1242.0	1713.0	1068.0	634.0	265.0	83.0	50.0	27.0
15	Eyeshield 21	7.95	Action, Sports, Comedy, Shounen	Unknown	アイシールド21	TV	145	Apr 6, 2005 to Mar 19, 2008	Spring 2005	TV Tokyo, Nihon Ad Systems, TV Tokyo Music, Shueisha	VIZ Media, Sentai Filmworks	Gallop	Manga	23 min. per ep.	PG-13 - Teens 13 or older	604.0	1003	148259	2066	13907	78349	14228	11573	30202	9226.0	14904.0	22811.0	16734.0	6206.0	2621.0	795.0	336.0	140.0	151.0
16	Hachimitsu to Clover	8.06	Comedy, Drama, Josei, Romance, Slice of Life	Honey and Clover	ハチミツとクローバー	TV	24	Apr 15, 2005 to Sep 27, 2005	Spring 2005	Genco, Fuji TV, Shueisha	VIZ Media, Discotek Media	J.C.Staff	Manga	23 min. per ep.	PG-13 - Teens 13 or older	468.0	687	214499	4101	11909	81145	11901	11026	98518	11829.0	16309.0	20008.0	13062.0	5574.0	3148.0	1339.0	484.0	278.0	321.0
17	Hungry Heart: Wild Striker	7.59	Slice of Life, Comedy, Sports, Shounen	Unknown	ハングリーハート Wild Striker	TV	52	Sep 11, 2002 to Sep 10, 2003	Fall 2002	Unknown	Unknown	Nippon Animation	Manga	23 min. per ep.	PG-13 - Teens 13 or older	1317.0	3612	20470	231	817	13778	828	1168	3879	1123.0	1777.0	3102.0	3075.0	1286.0	602.0	218.0	88.0	31.0	32.0
18	Initial D Fourth Stage	8.15	Action, Cars, Sports, Drama, Seinen	Unknown	頭文字〈イニシャル〉D FOURTH STAGE	TV	24	Apr 17, 2004 to Feb 18, 2006	Spring 2004	OB Planning, Studio Jack	Funimation	A.C.G.T.	Manga	27 min. per ep.	PG-13 - Teens 13 or older	360.0	1233	117929	979	6082	90967	3053	1356	16471	10948.0	15820.0	22379.0	12912.0	3874.0	1236.0	369.0	97.0	48.0	259.0
19	Monster	8.76	Drama, Horror, Mystery, Police, Psychological, Seinen, Thriller	Monster	モンスター	TV	74	Apr 7, 2004 to Sep 28, 2005	Spring 2004	VAP, Shogakukan-Shueisha Productions, Nippon Television Network	VIZ Media	Madhouse	Manga	24 min. per ep.	R+ - Mild Nudity	30.0	169	614100	29436	64648	214491	47488	23008	264465	77350.0	60652.0	43459.0	22045.0	8861.0	4381.0	2086.0	882.0	593.0	1177.0


CREATE TABLE anime (
  "mal_id" BIGINT,
  "name" VARCHAR,
  "score" VARCHAR,
  "genres" VARCHAR,
  "english_name" VARCHAR,
  "japanese_name" VARCHAR,
  "type" VARCHAR,
  "episodes" VARCHAR,
  "aired" VARCHAR,
  "premiered" VARCHAR,
  "producers" VARCHAR,
  "licensors" VARCHAR,
  "studios" VARCHAR,
  "source" VARCHAR,
  "duration" VARCHAR,
  "rating" VARCHAR,
  "ranked" VARCHAR,
  "popularity" BIGINT,
  "members" BIGINT,
  "favorites" BIGINT,
  "watching" BIGINT,
  "completed" BIGINT,
  "on_hold" BIGINT,
  "dropped" BIGINT,
  "plan_to_watch" BIGINT,
  "score_10" VARCHAR,
  "score_9" VARCHAR,
  "score_8" VARCHAR,
  "score_7" VARCHAR,
  "score_6" VARCHAR,
  "score_5" VARCHAR,
  "score_4" VARCHAR,
  "score_3" VARCHAR,
  "score_2" VARCHAR,
  "score_1" VARCHAR
);