Anime-Planet Character Recommendation

Waifus and husbando dataset

@kaggle.hernan4444_animeplanet_character_recommendation

Table List

2 tables(35.71 MB)

Characters Metadata

@kaggle.hernan4444_animeplanet_character_recommendation.characters_metadata

8.13 MB
132028 rows
15 columns

id ID	name Name	alias Alias	gender Gender	hair_color Hair Color	love_rank Love Rank	hate_rank Hate Rank	eye_color Eye Color	birthday Birthday	blood_type Blood Type	tags Tags	love_count Love Count	hate_count Hate Count	description Description	url Url
	L	Ryuzaki	Male	Black	1	48	Black	October 31, 1979	Unknown	Analytical, Barefoot, Detectives, Eye Bags, Sweet Tooth	44.829	3.447	Secretive, meticulous and cunning, L's desire to win coupled with his intellect give him the reputation of being the best detective in the world. His disheveled and childish exterior masks his sharp and analytical mind, throwing off his adversaries. Reclusive and paranoid, L solves his cases by comm…	https://www.anime-planet.com/characters/l-death-note
1	Haru YOSHIDA	Unknown	Male	Black	346	4.172	Black	April 2	Unknown	High School Students, Hot-Headed, Teenagers	4.669	124	Unknown	https://www.anime-planet.com/characters/haru-yoshida
2	Shinobu MAEHARA	Unknown	Female	Blue	2.942	9.11	Unknown	Unknown	Unknown	Cooks, Crybabies, Middle School Students, Shy	823	53	Unknown	https://www.anime-planet.com/characters/shinobu-maehara
3	Chizuru OSHIMA	Unknown	Female	Black	3.877	1.801	Unknown	Unknown	Unknown	Class Representatives, Glasses, High School Students, Teenagers	633	269	Unknown	https://www.anime-planet.com/characters/chizuru-oshima
4	Yuuzan YOSHIDA	Unknown	Male	Black	3.577	2.819	Unknown	Unknown	Unknown	Unknown	684	180	Unknown	https://www.anime-planet.com/characters/yuuzan-yoshida
5	Gabi	Unknown	Female	Black	4.676	97	Brown	April 14	Unknown	Big Ego, Bossy, Hot-Headed, Hyperactive, Military, Selfish, Vengeful	521	2.384	Unknown	https://www.anime-planet.com/characters/gabi-attack-on-titan
6	Si-Hoo HAN	Unknown	Male	White	47.197	68.894	Unknown	Unknown	Unknown	Unknown	17	2	Unknown	https://www.anime-planet.com/characters/si-hoo-han
7	Falco GRICE	Unknown	Male	Blonde	2.129	6.091	Brown	February 10	Unknown	Eternal Optimists, Military, Pacifists	1.118	85	Unknown	https://www.anime-planet.com/characters/falco-grice
8	Hatori SOHMA	Unknown	Male	Black	392	4.757	Unknown	Unknown	A	Adults, Blinding Bangs, Cursebearers, Doctors, Smokers	4.238	109	Unknown	https://www.anime-planet.com/characters/hatori-sohma
9	Sasame	Unknown	Male	Unknown	6.672	11.161	Unknown	December 30	AB	Piercings, Magic Users, Glasses	347	41	Unknown	https://www.anime-planet.com/characters/sasame


CREATE TABLE characters_metadata (
  "id" BIGINT,
  "name" VARCHAR,
  "alias" VARCHAR,
  "gender" VARCHAR,
  "hair_color" VARCHAR,
  "love_rank" DOUBLE,
  "hate_rank" DOUBLE,
  "eye_color" VARCHAR,
  "birthday" VARCHAR,
  "blood_type" VARCHAR,
  "tags" VARCHAR,
  "love_count" VARCHAR,
  "hate_count" VARCHAR,
  "description" VARCHAR,
  "url" VARCHAR
);