Dataset: Chalchitra Talks Book Recommendations

About this Dataset

Chalchitra Talks Book Recommendations

Context

Chalchitra Talks aims to be the one-stop destination for all our recommendations - movies, books, podcasts, TV shows, poetry, sports and so on!
They have a great collection of book recommendations from their guests which include comedians like Rohan Joshi and Ashish Shakya, actors like Gulshan Deviah, Ratna Pathak Shah, filmmakers like Peter Gould, Anand Gadhi, etc.

I have scraped these book recommendations along with info about the guests and info about the books from google books.

Content

File Structure

guests.csv - contains info about the guests

guest_id: unique identifier for the guest
guest_name: name of the guest
guest_profession_or_org: profession of the guest or the organization they belong to
guest_info: info about the guest from chalchitra.com
guest_page_url: url for the guest's page on chalchitra.com (it has the list of their recommendations)

books.csv - contains info about the books

book_id: unique identifier for books
book_name: name/title of the book
book_description: description of the book from chalchitra.com
authors: list of authors of the book
publisher: name of the publisher
publishedDate: date of publishing
pageCount: number of pages in the book
categories: category of the book
averageRating: average rating from google books
ratingsCount: count of ratings on the book
language: language in which the book is written
description: description of the book from google books
synopsis: synopsis of the book from google books

recommendation.csv - maps guest_id with book_id to show which guest recommended which books

book_id: identifier for the book from books.csv
guest_id: identifier for the guest from guests.csv

Acknowledgements

Thanks a lot to Chalchitra Talks for the fun and entertaining videos and making the recommendations available on the website. Shout-out to their youtube channel.

Tables

Books

@kaggle.mananjhaveri_chalchitra_talks_book_recommendations.books

437.75 KB
319 rows
13 columns


CREATE TABLE books (
  "book_id" BIGINT,
  "book_name" VARCHAR,
  "book_description_from_chalchitra" VARCHAR,
  "authors" VARCHAR,
  "publisher" VARCHAR,
  "publisheddate" VARCHAR,
  "pagecount" DOUBLE,
  "categories" VARCHAR,
  "averagerating" DOUBLE,
  "ratingscount" DOUBLE,
  "language" VARCHAR,
  "description" VARCHAR,
  "synopsis" VARCHAR
);

Guests

@kaggle.mananjhaveri_chalchitra_talks_book_recommendations.guests

9.42 KB
28 rows
5 columns


CREATE TABLE guests (
  "guest_id" BIGINT,
  "guest_name" VARCHAR,
  "guest_profession_or_org" VARCHAR,
  "guest_info" VARCHAR,
  "guest_page_url" VARCHAR
);

Recommendations

@kaggle.mananjhaveri_chalchitra_talks_book_recommendations.recommendations

3.97 KB
335 rows
2 columns


CREATE TABLE recommendations (
  "book_id" BIGINT,
  "guest_id" BIGINT
);