RecSYS Book User

Data for recommendation systems user-item

@kaggle.aleksandrmogilevskiy_recsys_book_user

Table List

2 tables(57.57 MB)

Books Poetry

@kaggle.aleksandrmogilevskiy_recsys_book_user.books_poetry

37.94 MB
36514 rows
30 columns

unnamed_0 Unnamed: 0	isbn Isbn	text_reviews_count Text Reviews Count	series Series	country_code Country Code	language_code Language Code	popular_shelves Popular Shelves	asin Asin	is_ebook Is Ebook	average_rating Average Rating	kindle_asin Kindle Asin	similar_books Similar Books	description Description	format Format	link Link	authors Authors	publisher Publisher	num_pages Num Pages	publication_day Publication Day	isbn13 Isbn13	publication_month Publication Month	edition_information Edition Information	publication_year Publication Year	url Url	image_url Image Url	book_id Book Id	ratings_count Ratings Count	work_id Work Id	title Title	title_without_series Title Without Series
	nan	1	[]	US	eng	[{'count': '8', 'name': 'to-read'}, {'count': '3', 'name': 'poetry'}, {'count': '2', 'name': 'currently-reading'}, {'count': '1', 'name': '01-kindle'}, {'count': '1', 'name': 'real-books'}, {'count': '1', 'name': 'personal-library'}]	nan		3.83	nan	[]	Number 30 in a series of literary pamphlets published monthly and available at the price of 15 cents per copy, or a yearly subscription (19 numbers) for $1.25	Paperback	https://www.goodreads.com/book/show/16037549-vision-of-sir-launfal-and-other-poems	[{'author_id': '15585', 'role': ''}]	Houghton, Mifflin and Company	80	1	nan	11	nan	1887	https://www.goodreads.com/book/show/16037549-vision-of-sir-launfal-and-other-poems	https://images.gr-assets.com/books/1348176637m/16037549.jpg	16037549	3	5212748	Vision of Sir Launfal and Other Poems	Vision of Sir Launfal and Other Poems
1	0811223981	2	[]	US	nan	[{'count': '100', 'name': 'to-read'}, {'count': '6', 'name': 'currently-reading'}, {'count': '3', 'name': 'drama'}, {'count': '3', 'name': 'plays'}, {'count': '2', 'name': 'books-i-own'}, {'count': '2', 'name': 'play'}, {'count': '2', 'name': 'read-2015'}, {'count': '1', 'name': 'golden'}, {'count':…	nan		3.83	B00U2WY9U8	[]	Fairy Tales gathers the unconventional verse dramolettes of the Swiss writer Robert Walser. Narrated in Walser's inimitable, playful language, these theatrical pieces overturn traditional notions of the fairy tale, transforming the Brothers Grimm into metatheater, even metareflections. Snow White fo…	Paperback	https://www.goodreads.com/book/show/22466716-fairy-tales	[{'author_id': '16073', 'role': ''}, {'author_id': '3484503', 'role': 'Translator'}, {'author_id': '367928', 'role': 'Translator'}, {'author_id': '1028358', 'role': 'Preface'}]	New Directions	128	20	9780811223980	4	nan	2015	https://www.goodreads.com/book/show/22466716-fairy-tales	https://images.gr-assets.com/books/1404958407m/22466716.jpg	22466716	37	41905435	Fairy Tales: Dramolettes	Fairy Tales: Dramolettes
2	0374428115	7	[]	US	nan	[{'count': '32', 'name': 'to-read'}, {'count': '7', 'name': 'poetry'}, {'count': '5', 'name': 'picture-books'}, {'count': '3', 'name': 'childrens'}, {'count': '2', 'name': 'illustration'}, {'count': '2', 'name': 'animals'}, {'count': '2', 'name': 'cats'}, {'count': '2', 'name': 'errol-le-cain'}, {'c…	nan		4.38	nan	[]	Three poems describe the nighttime adventures of some rather special cats.	Paperback	https://www.goodreads.com/book/show/926662.Growltiger_s_Last_Stand_and_Other_Poems	[{'author_id': '18540', 'role': ''}, {'author_id': '248155', 'role': 'Illustrator'}]	Farrar Straus Giroux		12	9780374428112	7	nan	2008	https://www.goodreads.com/book/show/926662.Growltiger_s_Last_Stand_and_Other_Poems	https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png	926662	45	911665	Growltiger's Last Stand and Other Poems	Growltiger's Last Stand and Other Poems
3	0156182890	12	[]	US	nan	[{'count': '554', 'name': 'to-read'}, {'count': '92', 'name': 'plays'}, {'count': '52', 'name': 'drama'}, {'count': '37', 'name': 'classics'}, {'count': '30', 'name': 'fiction'}, {'count': '27', 'name': 'poetry'}, {'count': '22', 'name': 'currently-reading'}, {'count': '16', 'name': 'favorites'}, {'…	nan		3.71	B00IWTRB1W	['1230072', '315167', '676169', '18522', '124335', '882631', '237701', '12105', '53025', '13510441', '300452', '77214', '116156', '136095', '249486', '911316']	A modern verse play about the search for meaning, in which a psychiatrist is the catalyst for the action. "An authentic modern masterpiece" (New York Post). "Eliot really does portray real-seeming characters. He cuts down his poetic effects to the minimum, and then finally rewards us with most beaut…	Paperback	https://www.goodreads.com/book/show/926667.The_Cocktail_Party	[{'author_id': '18540', 'role': ''}]	Mariner Books	190	18	9780156182898	3	nan	1964	https://www.goodreads.com/book/show/926667.The_Cocktail_Party	https://images.gr-assets.com/books/1382939971m/926667.jpg	926667	115	995066	The Cocktail Party	The Cocktail Party
4	1942004192	4	[]	US	eng	[{'count': '228', 'name': 'to-read'}, {'count': '2', 'name': 'poetry'}, {'count': '1', 'name': 'to-buy'}, {'count': '1', 'name': 'giveaways'}, {'count': '1', 'name': 'misc'}, {'count': '1', 'name': 'giveaway-books'}, {'count': '1', 'name': 'lost'}]	nan		5	nan	['25869488', '23630890', '25448131', '25464039', '4216656', '24804101', '26047380', '17287061', '25420487', '25709143', '29418026', '23873444', '25931921', '25124491']	Louder Than Everything You Love is about transformation. The narrator in these poems is many: women who talk to the dead, women who mourn dead mothers and grandmothers, women suicides, women who've been raped/escaped rape, women who cradle premature babies, women who suffer depression, women who pre…	Paperback	https://www.goodreads.com/book/show/29065952-louder-than-everything-you-love	[{'author_id': '14308759', 'role': ''}]	ELJ Publications	118	23	9781942004196	12	First	2015	https://www.goodreads.com/book/show/29065952-louder-than-everything-you-love	https://images.gr-assets.com/books/1455198396m/29065952.jpg	29065952	9	49294781	Louder Than Everything You Love	Louder Than Everything You Love
5	nan	1	[]	US	tur	[{'count': '1208', 'name': 'to-read'}, {'count': '41', 'name': 'currently-reading'}, {'count': '31', 'name': 'non-fiction'}, {'count': '31', 'name': 'poetry'}, {'count': '28', 'name': 'favorites'}, {'count': '27', 'name': 'travel'}, {'count': '22', 'name': 'italy'}, {'count': '22', 'name': 'essays'}…	nan		4.09	nan	['15796750', '1504664', '138241', '254039', '92852', '4194156', '1225688', '241235', '515678', '106458', '2568', '61043', '940167', '992809', '205194', '2578021', '897487']	"... Cunku gocup gideriz, guzellik ise kalicidir. Cunku gelecege yonelmis olmamiza ragmen guzellik ebedi simdiki zamandir." Su Seviyesi icin bir sehrin portresi denebilir. Ancak Nobel Odullu sair ve denemeci Brodsky'nin kalemi ve bakis acisi bu portreyi zeki, bilge, dokunakli ve tam anlamiyla zarif …	Paperback	https://www.goodreads.com/book/show/35235890-su-seviyesi	[{'author_id': '11563', 'role': ''}, {'author_id': '14182642', 'role': 'Translator'}]	Everest Yayinlari	128	26	9786051851471	5	nan	2017	https://www.goodreads.com/book/show/35235890-su-seviyesi	https://images.gr-assets.com/books/1495907022m/35235890.jpg	35235890	4	1306728	Su Seviyesi	Su Seviyesi
6	nan	3	[]	US	eng	[{'count': '5', 'name': 'to-read'}, {'count': '3', 'name': 'poetry'}, {'count': '1', 'name': 'currently-reading'}, {'count': '1', 'name': 'glbt'}, {'count': '1', 'name': 'england'}]	nan		4.75	nan	[]	Into Temptation is the debut collection of poems from Sophia Blackwell, a regular on the UK poetry scene who has been holding crowds spellbound for over five years in bars, nightclubs, and festival tents. Sophia takes us through love in all its guises - burning obsession, one-night stands that last …	Paperback	https://www.goodreads.com/book/show/15861988-into-temptation	[{'author_id': '2988946', 'role': ''}]	Tollington Press	80		nan		nan	2009	https://www.goodreads.com/book/show/15861988-into-temptation	https://images.gr-assets.com/books/1346225281m/15861988.jpg	15861988	8	21611807	Into Temptation	Into Temptation
7	nan	1	[]	US	nan	[{'count': '504', 'name': 'to-read'}, {'count': '41', 'name': 'poetry'}, {'count': '24', 'name': 'young-adult'}, {'count': '19', 'name': 'ya'}, {'count': '13', 'name': 'historical-fiction'}, {'count': '11', 'name': 'currently-reading'}, {'count': '10', 'name': 'african-american'}, {'count': '9', 'na…	B003XIIVBG	true	3.83	B003XIIVBG	['2078239', '178478', '709979', '824499', '4417990', '3873511', '1851603', '4215733', '702855', '2058371', '619833', '11248976', '342068', '645144', '3198720', '862675', '6238740', '2219479']	nan	nan	https://www.goodreads.com/book/show/9495428-dark-sons	[{'author_id': '25492', 'role': ''}]	nan			nan		nan		https://www.goodreads.com/book/show/9495428-dark-sons	https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png	9495428	4	2360399	Dark Sons	Dark Sons
8	9646138675	16	[]	US	per	[{'count': '81', 'name': 'to-read'}, {'count': '7', 'name': 'poetry'}, {'count': '5', 'name': 'شعر'}, {'count': '3', 'name': 'favorites'}, {'count': '2', 'name': 'currently-reading'}, {'count': '2', 'name': 'persian-literature'}, {'count': '2', 'name': 'persian'}, {'count': '2', 'name': 'poem'}, {'c…	nan		3.47	nan	['265786', '163339', '650197', '383428', '346507', '8160588', '433433', '327750', '4811737', '1867959', '145713']	nan	Paperback	https://www.goodreads.com/book/show/346381._	[{'author_id': '619932', 'role': ''}]	frzn	72		nan		nan	2005	https://www.goodreads.com/book/show/346381._	https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png	346381	405	336680	دریا پری، کاکل زری	دریا پری، کاکل زری
9	1879960125	8	[]	US	nan	[{'count': '6960', 'name': 'to-read'}, {'count': '214', 'name': 'currently-reading'}, {'count': '173', 'name': 'non-fiction'}, {'count': '156', 'name': 'feminism'}, {'count': '116', 'name': 'favorites'}, {'count': '111', 'name': 'poetry'}, {'count': '111', 'name': 'nonfiction'}, {'count': '57', 'nam…	nan		4.25	nan	['143367', '342834', '61442', '476775', '379013', '568869', '151266', '32951', '577490', '353598', '8170980', '534753', '1330051', '1451718', '51378', '635635']	First published in 1987, "Borderlands" has become a classic in Chicano border studies, feminist theory, gay and lesbian studies, and cultural studies. Anzaldua, a Chicana native of Texas, explores in prose and poetry the murky, precarious existence of those living on the frontier between cultures an…	Paperback	https://www.goodreads.com/book/show/598195.Borderlands_La_Frontera	[{'author_id': '516921', 'role': ''}]	Aunt Lute Books		12	9781879960121	12	nan	1987	https://www.goodreads.com/book/show/598195.Borderlands_La_Frontera	https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png	598195	98	45046	Borderlands/La Frontera	Borderlands/La Frontera


CREATE TABLE books_poetry (
  "unnamed_0" BIGINT,
  "isbn" VARCHAR,
  "text_reviews_count" BIGINT,
  "series" VARCHAR,
  "country_code" VARCHAR,
  "language_code" VARCHAR,
  "popular_shelves" VARCHAR,
  "asin" VARCHAR,
  "is_ebook" BOOLEAN,
  "average_rating" DOUBLE,
  "kindle_asin" VARCHAR,
  "similar_books" VARCHAR,
  "description" VARCHAR,
  "format" VARCHAR,
  "link" VARCHAR,
  "authors" VARCHAR,
  "publisher" VARCHAR,
  "num_pages" DOUBLE,
  "publication_day" DOUBLE,
  "isbn13" VARCHAR,
  "publication_month" DOUBLE,
  "edition_information" VARCHAR,
  "publication_year" DOUBLE,
  "url" VARCHAR,
  "image_url" VARCHAR,
  "book_id" BIGINT,
  "ratings_count" BIGINT,
  "work_id" BIGINT,
  "title" VARCHAR,
  "title_without_series" VARCHAR
);