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.