{ "cells": [ { "cell_type": "code", "id": "initial_id", "metadata": { "collapsed": true, "ExecuteTime": { "end_time": "2025-02-20T08:13:49.874971Z", "start_time": "2025-02-20T08:13:47.617744Z" } }, "source": [ "import pandas as pd\n", "from sympy import sequence\n", "\n", "books=pd.read_csv(\"books_cleaned.csv\")" ], "outputs": [], "execution_count": 1 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:13:49.964706Z", "start_time": "2025-02-20T08:13:49.923575Z" } }, "cell_type": "code", "source": "books[\"categories\"].value_counts()", "id": "2b9ae5eebd9998ff", "outputs": [ { "data": { "text/plain": [ "categories\n", "Fiction 2111\n", "Juvenile Fiction 390\n", "Biography & Autobiography 311\n", "History 207\n", "Literary Criticism 124\n", " ... \n", "Conspiracies 1\n", "Brothers and sisters 1\n", "Rock musicians 1\n", "Community life 1\n", "Indic fiction (English) 1\n", "Name: count, Length: 479, dtype: int64" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 2 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:13:51.339219Z", "start_time": "2025-02-20T08:13:51.266499Z" } }, "cell_type": "code", "source": "books[books[\"categories\"] == \"Juvenile Fiction\"]\n", "id": "c2bf33d979b4799a", "outputs": [ { "data": { "text/plain": [ " isbn13 isbn10 \\\n", "30 9780006646006 000664600X \n", "79 9780020442608 0020442602 \n", "85 9780030547744 0030547741 \n", "86 9780060000141 0060000147 \n", "87 9780060001537 0060001534 \n", "... ... ... \n", "4845 9781590385814 1590385810 \n", "4930 9781596792500 1596792507 \n", "4942 9781599900056 159990005X \n", "5010 9781844580514 1844580512 \n", "5157 9781932416374 1932416374 \n", "\n", " title \\\n", "30 Ocean Star Express \n", "79 The voyage of the Dawn Treader \n", "85 Where the Red Fern Grows \n", "86 Poppy's Return \n", "87 Diary of a Spider \n", "... ... \n", "4845 Fablehaven \n", "4930 Sherlock Holmes and the Case of the Hound of t... \n", "4942 The Drift House \n", "5010 Attack of the Jaguar \n", "5157 The Very Persistent Gappers of Frip \n", "\n", " authors categories \\\n", "30 Mark Haddon;Peter Sutton Juvenile Fiction \n", "79 Clive Staples Lewis Juvenile Fiction \n", "85 Wilson Rawls Juvenile Fiction \n", "86 Avi Juvenile Fiction \n", "87 Doreen Cronin Juvenile Fiction \n", "... ... ... \n", "4845 Brandon Mull Juvenile Fiction \n", "4930 Arthur Conan Doyle;Malvina G. Vogel Juvenile Fiction \n", "4942 Dale Peck Juvenile Fiction \n", "5010 M. A. Harvey Juvenile Fiction \n", "5157 George Saunders;Lane Smith Juvenile Fiction \n", "\n", " thumbnail \\\n", "30 http://books.google.com/books/content?id=I2QZA... \n", "79 http://books.google.com/books/content?id=fDD3C... \n", "85 http://books.google.com/books/content?id=IHpRw... \n", "86 http://books.google.com/books/content?id=XbcMJ... \n", "87 http://books.google.com/books/content?id=UWvZo... \n", "... ... \n", "4845 http://books.google.com/books/content?id=tbVIP... \n", "4930 http://books.google.com/books/content?id=EWgWP... \n", "4942 http://books.google.com/books/content?id=kbwPY... \n", "5010 http://books.google.com/books/content?id=3HUdt... \n", "5157 http://books.google.com/books/content?id=xYJOP... \n", "\n", " description published_year \\\n", "30 Joe and his parents are enjoying a summer holi... 2002.0 \n", "79 The \"Dawn Treader\" is the first ship Narnia ha... 1970.0 \n", "85 A young boy living in the Ozarks achieves his ... 2000.0 \n", "86 There's trouble at Gray House, the girlhood ho... 2006.0 \n", "87 This is the diary ... of a spider. But don't b... 2005.0 \n", "... ... ... \n", "4845 When Kendra and Seth go to stay at their grand... 2006.0 \n", "4930 Sherlock Holmes and Dr. Watson travel to the b... 2005.0 \n", "4942 Sent to stay with their uncle in a ship-like h... 2006.0 \n", "5010 This training manual for operatives of Xtreme ... 2004.0 \n", "5157 A novel set in the seaside village of Frip fol... 2006.0 \n", "\n", " average_rating num_pages ratings_count \\\n", "30 3.50 32.0 1.0 \n", "79 4.09 216.0 2869.0 \n", "85 4.37 288.0 95.0 \n", "86 3.99 256.0 1086.0 \n", "87 4.25 40.0 7903.0 \n", "... ... ... ... \n", "4845 4.09 351.0 111896.0 \n", "4930 4.51 237.0 28.0 \n", "4942 3.64 437.0 595.0 \n", "5010 3.40 125.0 4.0 \n", "5157 4.11 84.0 2317.0 \n", "\n", " title and subtitle \\\n", "30 Ocean Star Express \n", "79 The voyage of the Dawn Treader \n", "85 Where the Red Fern Grows: The Story of Two Dog... \n", "86 Poppy's Return \n", "87 Diary of a Spider \n", "... ... \n", "4845 Fablehaven \n", "4930 Sherlock Holmes and the Case of the Hound of t... \n", "4942 The Drift House: The First Voyage \n", "5010 Attack of the Jaguar \n", "5157 The Very Persistent Gappers of Frip \n", "\n", " tagged_description \n", "30 9780006646006 Joe and his parents are enjoying... \n", "79 9780020442608 The \"Dawn Treader\" is the first ... \n", "85 9780030547744 A young boy living in the Ozarks... \n", "86 9780060000141 There's trouble at Gray House, t... \n", "87 9780060001537 This is the diary ... of a spide... \n", "... ... \n", "4845 9781590385814 When Kendra and Seth go to stay ... \n", "4930 9781596792500 Sherlock Holmes and Dr. Watson t... \n", "4942 9781599900056 Sent to stay with their uncle in... \n", "5010 9781844580514 This training manual for operati... \n", "5157 9781932416374 A novel set in the seaside villa... \n", "\n", "[390 rows x 13 columns]" ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
isbn13isbn10titleauthorscategoriesthumbnaildescriptionpublished_yearaverage_ratingnum_pagesratings_counttitle and subtitletagged_description
309780006646006000664600XOcean Star ExpressMark Haddon;Peter SuttonJuvenile Fictionhttp://books.google.com/books/content?id=I2QZA...Joe and his parents are enjoying a summer holi...2002.03.5032.01.0Ocean Star Express9780006646006 Joe and his parents are enjoying...
7997800204426080020442602The voyage of the Dawn TreaderClive Staples LewisJuvenile Fictionhttp://books.google.com/books/content?id=fDD3C...The \"Dawn Treader\" is the first ship Narnia ha...1970.04.09216.02869.0The voyage of the Dawn Treader9780020442608 The \"Dawn Treader\" is the first ...
8597800305477440030547741Where the Red Fern GrowsWilson RawlsJuvenile Fictionhttp://books.google.com/books/content?id=IHpRw...A young boy living in the Ozarks achieves his ...2000.04.37288.095.0Where the Red Fern Grows: The Story of Two Dog...9780030547744 A young boy living in the Ozarks...
8697800600001410060000147Poppy's ReturnAviJuvenile Fictionhttp://books.google.com/books/content?id=XbcMJ...There's trouble at Gray House, the girlhood ho...2006.03.99256.01086.0Poppy's Return9780060000141 There's trouble at Gray House, t...
8797800600015370060001534Diary of a SpiderDoreen CroninJuvenile Fictionhttp://books.google.com/books/content?id=UWvZo...This is the diary ... of a spider. But don't b...2005.04.2540.07903.0Diary of a Spider9780060001537 This is the diary ... of a spide...
..........................................
484597815903858141590385810FablehavenBrandon MullJuvenile Fictionhttp://books.google.com/books/content?id=tbVIP...When Kendra and Seth go to stay at their grand...2006.04.09351.0111896.0Fablehaven9781590385814 When Kendra and Seth go to stay ...
493097815967925001596792507Sherlock Holmes and the Case of the Hound of t...Arthur Conan Doyle;Malvina G. VogelJuvenile Fictionhttp://books.google.com/books/content?id=EWgWP...Sherlock Holmes and Dr. Watson travel to the b...2005.04.51237.028.0Sherlock Holmes and the Case of the Hound of t...9781596792500 Sherlock Holmes and Dr. Watson t...
49429781599900056159990005XThe Drift HouseDale PeckJuvenile Fictionhttp://books.google.com/books/content?id=kbwPY...Sent to stay with their uncle in a ship-like h...2006.03.64437.0595.0The Drift House: The First Voyage9781599900056 Sent to stay with their uncle in...
501097818445805141844580512Attack of the JaguarM. A. HarveyJuvenile Fictionhttp://books.google.com/books/content?id=3HUdt...This training manual for operatives of Xtreme ...2004.03.40125.04.0Attack of the Jaguar9781844580514 This training manual for operati...
515797819324163741932416374The Very Persistent Gappers of FripGeorge Saunders;Lane SmithJuvenile Fictionhttp://books.google.com/books/content?id=xYJOP...A novel set in the seaside village of Frip fol...2006.04.1184.02317.0The Very Persistent Gappers of Frip9781932416374 A novel set in the seaside villa...
\n", "

390 rows × 13 columns

\n", "
" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 3 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:13:51.736917Z", "start_time": "2025-02-20T08:13:51.623604Z" } }, "cell_type": "code", "source": [ "\n", "books[books[\"categories\"] == \"Juvenile Nonfiction\"]" ], "id": "8887b3974ed08ba3", "outputs": [ { "data": { "text/plain": [ " isbn13 isbn10 \\\n", "107 9780060277406 0060277408 \n", "108 9780060278427 0060278420 \n", "228 9780060782139 0060782137 \n", "267 9780060882600 0060882603 \n", "434 9780064462044 0064462048 \n", "435 9780064462341 006446234X \n", "439 9780066236179 0066236177 \n", "812 9780142302279 0142302279 \n", "821 9780142407226 0142407224 \n", "823 9780142407929 0142407925 \n", "1014 9780198320272 0198320272 \n", "1074 9780237525378 0237525372 \n", "1739 9780375812934 0375812938 \n", "1742 9780375823787 0375823786 \n", "1770 9780380732548 0380732548 \n", "1972 9780395776087 0395776082 \n", "2105 9780439314558 0439314550 \n", "2117 9780439420068 0439420067 \n", "2139 9780439736466 0439736463 \n", "2183 9780440229353 0440229359 \n", "2211 9780440419174 0440419174 \n", "2320 9780448437439 0448437430 \n", "2323 9780448444826 0448444828 \n", "2503 9780486276809 0486276805 \n", "2509 9780486296388 0486296385 \n", "2609 9780521618748 0521618746 \n", "2615 9780525469780 0525469788 \n", "2858 9780590032490 0590032496 \n", "2859 9780590103879 0590103873 \n", "2897 9780618111206 0618111204 \n", "3133 9780679890522 0679890521 \n", "3202 9780689833762 0689833768 \n", "3203 9780689834196 0689834195 \n", "3204 9780689835612 0689835612 \n", "3219 9780689869907 0689869908 \n", "3223 9780689876707 068987670X \n", "3263 9780723247791 072324779X \n", "3270 9780736805995 0736805990 \n", "3292 9780739844328 0739844326 \n", "3522 9780753459645 0753459647 \n", "3552 9780756614195 0756614198 \n", "3565 9780761417101 0761417109 \n", "3797 9780789458209 0789458209 \n", "3798 9780791070482 0791070484 \n", "3799 9780791081266 0791081265 \n", "3800 9780792241737 0792241738 \n", "3861 9780805069853 0805069852 \n", "3863 9780805071061 0805071067 \n", "3921 9780810935204 0810935201 \n", "4069 9780822560562 0822560569 \n", "4072 9780823410781 0823410781 \n", "4409 9781400307845 1400307848 \n", "4596 9781560067849 1560067845 \n", "4744 9781580495868 1580495869 \n", "4808 9781586853334 1586853333 \n", "5041 9781857232097 1857232097 \n", "5142 9781931414166 1931414165 \n", "\n", " title \\\n", "107 The Secret Garden Cookbook \n", "108 Laura's Album \n", "228 Time For Kids: Butterflies! \n", "267 The Annotated Charlotte's Web \n", "434 My Little House Crafts Book \n", "435 Pioneer Girl \n", "439 A Light in the Attic Book and CD \n", "812 Dirty Beasts \n", "821 The Tough Guide to Fantasyland \n", "823 The BFG \n", "1014 Julius Caesar \n", "1074 Oliver Twist \n", "1739 Jurassic Park Institute Dinosaur Field Guide \n", "1742 Ancient Greece and the Olympics \n", "1770 Anne Frank \n", "1972 An American Plague \n", "2105 Conversations with J.K. Rowling \n", "2117 Eat! \n", "2139 Where We Are, what We See \n", "2183 How Angel Peterson Got His Name \n", "2211 Vincent Van Gogh \n", "2320 Who Was John F. Kennedy? \n", "2323 Who Was Anne Frank? \n", "2503 The Secret Garden Coloring Book \n", "2509 Ballet Class Coloring Book \n", "2609 Hamlet \n", "2615 Boy, Were We Wrong about Dinosaurs! \n", "2858 The witches \n", "2859 Expository Writing \n", "2897 Once a Wolf \n", "3133 The Trail of Tears \n", "3202 Sad Underwear and Other Complications \n", "3203 Salt in His Shoes \n", "3204 Where Is Baby's Mommy? \n", "3219 Beatrice's Goat \n", "3223 Star Bright \n", "3263 The Tale of The Flopsy Bunnies \n", "3270 The Girlhood Diary of Louisa May Alcott, 1843-... \n", "3292 Bill Gates \n", "3522 I Wonder Why the Sun Rises \n", "3552 Star Wars \n", "3565 The Star-Spangled Banner \n", "3797 Tree \n", "3798 Bram Stoker's Dracula \n", "3799 Edith Wharton's The Age of Innocence \n", "3800 Freedom Riders \n", "3861 You Come Too \n", "3863 Rosa \n", "3921 Lewis Carroll's Jabberwocky \n", "4069 Barack Obama \n", "4072 A Picture Book of Anne Frank \n", "4409 Writings to Young Women from Laura Ingalls Wil... \n", "4596 Flowers for Algernon \n", "4744 The Red Badge of Courage \n", "4808 The Big Book of Boy Stuff \n", "5041 The Fires of Heaven \n", "5142 The Brooklyn Bridge \n", "\n", " authors categories \\\n", "107 Amy Cotler Juvenile Nonfiction \n", "108 William Anderson Juvenile Nonfiction \n", "228 Editors of TIME For Kids Juvenile Nonfiction \n", "267 E. B. White Juvenile Nonfiction \n", "434 Carolyn Strom Collins Juvenile Nonfiction \n", "435 William Anderson Juvenile Nonfiction \n", "439 Shel Silverstein Juvenile Nonfiction \n", "812 Roald Dahl Juvenile Nonfiction \n", "821 Diana Wynne Jones Juvenile Nonfiction \n", "823 Roald Dahl;David Wood;Jane Walmsley Juvenile Nonfiction \n", "1014 William Shakespeare Juvenile Nonfiction \n", "1074 Pauline Francis;Charles Dickens Juvenile Nonfiction \n", "1739 Thomas R. Holtz;M. K. Brett-Surman Juvenile Nonfiction \n", "1742 Mary Pope Osborne;Natalie Pope Boyce Juvenile Nonfiction \n", "1770 Johanna Hurwitz Juvenile Nonfiction \n", "1972 Jim Murphy Juvenile Nonfiction \n", "2105 Lindsey Fraser Juvenile Nonfiction \n", "2117 Roberta Grobel Intrater Juvenile Nonfiction \n", "2139 David Levithan Juvenile Nonfiction \n", "2183 Gary Paulsen Juvenile Nonfiction \n", "2211 Jan Greenberg;Sandra Jane Jordan Juvenile Nonfiction \n", "2320 Yona Zeldis McDonough;Jill Weber Juvenile Nonfiction \n", "2323 Ann Abramson Juvenile Nonfiction \n", "2503 Frances Hodgson Burnett Juvenile Nonfiction \n", "2509 John Green;Caroline Denzler Juvenile Nonfiction \n", "2609 William Shakespeare Juvenile Nonfiction \n", "2615 Kathleen V. Kudlinski Juvenile Nonfiction \n", "2858 Roald Dahl Juvenile Nonfiction \n", "2859 Tara McCarthy Juvenile Nonfiction \n", "2897 Stephen R. Swinburne;Jim Brandenburg Juvenile Nonfiction \n", "3133 Joseph Bruchac;Diana Magnuson Juvenile Nonfiction \n", "3202 Judith Viorst Juvenile Nonfiction \n", "3203 Deloris Jordan;Roslyn M. Jordan Juvenile Nonfiction \n", "3204 Karen Katz Juvenile Nonfiction \n", "3219 Page McBrier Juvenile Nonfiction \n", "3223 Cathy Hapka Juvenile Nonfiction \n", "3263 Beatrix Potter Juvenile Nonfiction \n", "3270 Louisa May Alcott Juvenile Nonfiction \n", "3292 Sara Barton-Wood Juvenile Nonfiction \n", "3522 Brenda Walpole Juvenile Nonfiction \n", "3552 Kristin Lund;Simon Beecroft;Kerrie Dougherty Juvenile Nonfiction \n", "3565 Debra Hess Juvenile Nonfiction \n", "3797 David Burnie Juvenile Nonfiction \n", "3798 Harold Bloom Juvenile Nonfiction \n", "3799 Harold Bloom Juvenile Nonfiction \n", "3800 Ann Bausum Juvenile Nonfiction \n", "3861 Robert Frost Juvenile Nonfiction \n", "3863 Nikki Giovanni Juvenile Nonfiction \n", "3921 Graeme Base Juvenile Nonfiction \n", "4069 Marlene Targ Brill Juvenile Nonfiction \n", "4072 NaN Juvenile Nonfiction \n", "4409 Laura Ingalls Wilder;Stephen W. Hines Juvenile Nonfiction \n", "4596 Patrice Cassedy Juvenile Nonfiction \n", "4744 Stephen Crane Juvenile Nonfiction \n", "4808 Bart King Juvenile Nonfiction \n", "5041 Robert Jordan Juvenile Nonfiction \n", "5142 Elizabeth Mann;Alan Witschonke Juvenile Nonfiction \n", "\n", " thumbnail \\\n", "107 http://books.google.com/books/content?id=c7E_H... \n", "108 http://books.google.com/books/content?id=_zTkq... \n", "228 http://books.google.com/books/content?id=OdZxn... \n", "267 http://books.google.com/books/content?id=vaYYH... \n", "434 http://books.google.com/books/content?id=lTzrs... \n", "435 http://books.google.com/books/content?id=Sj4UD... \n", "439 http://books.google.com/books/content?id=FJfQs... \n", "812 NaN \n", "821 http://books.google.com/books/content?id=v5jxA... \n", "823 http://books.google.com/books/content?id=aDf-O... \n", "1014 http://books.google.com/books/content?id=Nlmkh... \n", "1074 http://books.google.com/books/content?id=X6RvT... \n", "1739 http://books.google.com/books/content?id=vW3hm... \n", "1742 http://books.google.com/books/content?id=5cPbW... \n", "1770 http://books.google.com/books/content?id=3ja19... \n", "1972 NaN \n", "2105 http://books.google.com/books/content?id=Ly8dl... \n", "2117 http://books.google.com/books/content?id=BnQ2n... \n", "2139 NaN \n", "2183 http://books.google.com/books/content?id=maJrL... \n", "2211 http://books.google.com/books/content?id=n7kv9... \n", "2320 http://books.google.com/books/content?id=qjCzJ... \n", "2323 http://books.google.com/books/content?id=Bz37n... \n", "2503 http://books.google.com/books/content?id=sxHdA... \n", "2509 http://books.google.com/books/content?id=p6PBk... \n", "2609 http://books.google.com/books/content?id=5m2UP... \n", "2615 http://books.google.com/books/content?id=QrRKD... \n", "2858 http://books.google.com/books/content?id=tpQxo... \n", "2859 http://books.google.com/books/content?id=9HKHF... \n", "2897 http://books.google.com/books/content?id=UkZWu... \n", "3133 http://books.google.com/books/content?id=QxRUP... \n", "3202 http://books.google.com/books/content?id=e-sEA... \n", "3203 http://books.google.com/books/content?id=hYzQw... \n", "3204 NaN \n", "3219 http://books.google.com/books/content?id=4MNED... \n", "3223 http://books.google.com/books/content?id=JPuiC... \n", "3263 http://books.google.com/books/content?id=D2uQt... \n", "3270 http://books.google.com/books/content?id=_dP35... \n", "3292 http://books.google.com/books/content?id=Fr814... \n", "3522 http://books.google.com/books/content?id=SqpYs... \n", "3552 http://books.google.com/books/content?id=PAq2A... \n", "3565 http://books.google.com/books/content?id=e-uzI... \n", "3797 http://books.google.com/books/content?id=Qwsqj... \n", "3798 http://books.google.com/books/content?id=vQ6SQ... \n", "3799 http://books.google.com/books/content?id=MNuFk... \n", "3800 http://books.google.com/books/content?id=JIlhQ... \n", "3861 http://books.google.com/books/content?id=gZWM6... \n", "3863 http://books.google.com/books/content?id=3pulA... \n", "3921 http://books.google.com/books/content?id=tyMFA... \n", "4069 http://books.google.com/books/content?id=FIhyP... \n", "4072 http://books.google.com/books/content?id=CSNxW... \n", "4409 http://books.google.com/books/content?id=e5gSD... \n", "4596 http://books.google.com/books/content?id=x_CUf... \n", "4744 http://books.google.com/books/content?id=lN1ga... \n", "4808 http://books.google.com/books/content?id=08Ilm... \n", "5041 http://books.google.com/books/content?id=4HyfQ... \n", "5142 http://books.google.com/books/content?id=s28MA... \n", "\n", " description published_year \\\n", "107 Frances Hodgson Burnett's The Secret Garden de... 1999.0 \n", "108 Though best known as the author of the Little ... 1998.0 \n", "228 Butterflies There are 20,000 different kinds o... 2006.0 \n", "267 Charlotte's Web, one of America's best-loved c... 2006.0 \n", "434 Make the same pioneer crafts that Laura did! I... 1998.0 \n", "435 The pioneer spirit lives on... Readers around ... 2000.0 \n", "439 Last night while I lay thinking here Some What... 2001.0 \n", "812 Poems tell the stories of a smart pig who outw... 2002.0 \n", "821 A unique guide to fantasy literature helps rea... 2006.0 \n", "823 With notes on staging, props, and costumes, a ... 2007.0 \n", "1014 Caesar returns from a triumphant battle to Rom... 2001.0 \n", "1074 This wonderful series is a quick way into a ra... 2003.0 \n", "1739 Discusses dinosaur research and what can be le... 2001.0 \n", "1742 Filled with fascinating facts, a Magic Tree Ho... 2004.0 \n", "1770 From July 1942 until August 1944, a young girl... 1999.0 \n", "1972 Recreates the devastation rendered to the city... 2003.0 \n", "2105 From her birth in Chipping Sodbury near Bristo... 2001.0 \n", "2117 A group of babies enjoys some favorite foods--... 2002.0 \n", "2139 A collection of poems, stories, essays, and ar... 2005.0 \n", "2183 Author Gary Paulsen relates tales from his you... 2004.0 \n", "2211 Profiles the turbulent life of Vincent van Gog... 2003.0 \n", "2320 Chronicles the life of the president who saw A... 2004.0 \n", "2323 Looks closely at Anne Frank's life before the ... 2007.0 \n", "2503 Ten-year-old Mary comes to live in a lonely ho... 2014.0 \n", "2509 Forty-two clear, accurate drawings (all in pro... 1997.0 \n", "2609 This edition of Hamlet is part of the groundbr... 2005.0 \n", "2615 Examines what is known about dinosaur bones, b... 2005.0 \n", "2858 A young boy and his Norwegian grandmother, who... 1997.0 \n", "2859 A Down-to-Earth Approach James Henslin shares ... 1998.0 \n", "2897 With powerful and rare photos by a former phot... 2001.0 \n", "3133 In 1838, settlers moving west forced the great... 1999.0 \n", "3202 Knock, knock. Who's there? Someone with sad un... 2000.0 \n", "3203 Young Michael Jordan, who is smaller than the ... 2003.0 \n", "3204 Is Mommy behind the chair? Is Mommy behind the... 2001.0 \n", "3219 In this story based on a case from Project Hei... 2004.0 \n", "3223 PopTV is going to follow Star around for twent... 2005.0 \n", "3263 This original, authorised version has been lov... 2010.0 \n", "3270 Excerpts from the girlhood diary of Louisa May... 2001.0 \n", "3292 Presents the life of Bill Gates, from his chil... 2001.0 \n", "3522 What is a leap year? Why are bees busy in summ... 2006.0 \n", "3552 Glorious full-color illustrations create a sea... 2005.0 \n", "3565 Looks at the events leading up to the War of 1... 2003.0 \n", "3797 Photographs and text explore the anatomy and l... 2000.0 \n", "3798 Presents a collection of critical essays on Br... 2003.0 \n", "3799 One of Edith Wharton's most critically acclaim... 2005.0 \n", "3800 Offers the true account of two young men who t... 2006.0 \n", "3861 An introduction to Robert Frost features an ab... 2002.0 \n", "3863 Provides the story of the black woman whose re... 2005.0 \n", "3921 Lewis Carroll's classic and inventive verse co... 1996.0 \n", "4069 Chronicles the life and career of the communit... 2006.0 \n", "4072 Traces the life of the young Jewish girl whose... 1993.0 \n", "4409 Using selections from her works and memoirs of... 2006.0 \n", "4596 Discusses the young adult book \"Flowers for Al... 2000.0 \n", "4744 As he faces battle in the Civil War for the fi... 2004.0 \n", "4808 There's this boy. Let's say he's somewhere bet... 2004.0 \n", "5041 The fifth book in Robert Jordan's internationa... 1994.0 \n", "5142 Describes the construction of the Brooklyn Bri... 2006.0 \n", "\n", " average_rating num_pages ratings_count \\\n", "107 4.28 128.0 142.0 \n", "108 4.30 80.0 713.0 \n", "228 4.00 32.0 20.0 \n", "267 4.16 320.0 41.0 \n", "434 4.05 64.0 56.0 \n", "435 4.15 32.0 414.0 \n", "439 4.34 176.0 590.0 \n", "812 4.02 32.0 3953.0 \n", "821 3.94 234.0 3897.0 \n", "823 4.26 128.0 452.0 \n", "1014 3.67 128.0 133575.0 \n", "1074 3.66 48.0 92.0 \n", "1739 4.08 160.0 2.0 \n", "1742 4.06 119.0 1044.0 \n", "1770 3.99 64.0 143.0 \n", "1972 3.80 165.0 3338.0 \n", "2105 3.99 96.0 4184.0 \n", "2117 3.95 10.0 54.0 \n", "2139 3.73 288.0 41.0 \n", "2183 3.93 111.0 1139.0 \n", "2211 3.95 144.0 209.0 \n", "2320 4.19 112.0 598.0 \n", "2323 4.26 103.0 1763.0 \n", "2503 4.25 48.0 4.0 \n", "2509 3.64 48.0 11.0 \n", "2609 4.01 289.0 577429.0 \n", "2615 3.93 32.0 243.0 \n", "2858 4.17 208.0 254867.0 \n", "2859 4.33 88.0 3.0 \n", "2897 4.06 48.0 42.0 \n", "3133 3.88 48.0 155.0 \n", "3202 3.87 80.0 104.0 \n", "3203 4.21 32.0 1054.0 \n", "3204 4.15 14.0 408.0 \n", "3219 4.24 40.0 523.0 \n", "3223 3.67 160.0 3.0 \n", "3263 4.19 58.0 5051.0 \n", "3270 3.87 32.0 26.0 \n", "3292 5.00 48.0 0.0 \n", "3522 3.95 32.0 50.0 \n", "3552 4.30 175.0 128.0 \n", "3565 4.00 40.0 1.0 \n", "3797 4.07 64.0 5.0 \n", "3798 3.83 243.0 6.0 \n", "3799 3.71 205.0 11.0 \n", "3800 3.97 80.0 247.0 \n", "3861 4.16 92.0 77.0 \n", "3863 4.35 40.0 5942.0 \n", "3921 4.14 14.0 31.0 \n", "4069 3.96 48.0 19.0 \n", "4072 4.17 32.0 208.0 \n", "4409 3.95 113.0 100.0 \n", "4596 3.00 96.0 1.0 \n", "4744 3.23 170.0 74477.0 \n", "4808 4.24 292.0 141.0 \n", "5041 4.15 912.0 106302.0 \n", "5142 4.44 46.0 35.0 \n", "\n", " title and subtitle \\\n", "107 The Secret Garden Cookbook: Recipes Inspired b... \n", "108 Laura's Album: A Remembrance Scrapbook of Laur... \n", "228 Time For Kids: Butterflies! \n", "267 The Annotated Charlotte's Web \n", "434 My Little House Crafts Book: 18 Projects from ... \n", "435 Pioneer Girl: The Story of Laura Ingalls Wilder \n", "439 A Light in the Attic Book and CD \n", "812 Dirty Beasts \n", "821 The Tough Guide to Fantasyland \n", "823 The BFG: A Set of Plays \n", "1014 Julius Caesar \n", "1074 Oliver Twist \n", "1739 Jurassic Park Institute Dinosaur Field Guide \n", "1742 Ancient Greece and the Olympics: A Nonfiction ... \n", "1770 Anne Frank: Life in Hiding \n", "1972 An American Plague: The True and Terrifying St... \n", "2105 Conversations with J.K. Rowling \n", "2117 Eat! \n", "2139 Where We Are, what We See: The Best Young Arti... \n", "2183 How Angel Peterson Got His Name: And Other Out... \n", "2211 Vincent Van Gogh: Portrait of an Artist \n", "2320 Who Was John F. Kennedy? \n", "2323 Who Was Anne Frank? \n", "2503 The Secret Garden Coloring Book \n", "2509 Ballet Class Coloring Book \n", "2609 Hamlet \n", "2615 Boy, Were We Wrong about Dinosaurs! \n", "2858 The witches \n", "2859 Expository Writing \n", "2897 Once a Wolf: How Wildlife Biologists Fought to... \n", "3133 The Trail of Tears \n", "3202 Sad Underwear and Other Complications: More Po... \n", "3203 Salt in His Shoes: Michael Jordan in Pursuit o... \n", "3204 Where Is Baby's Mommy?: A Karen Katz Lift-the-... \n", "3219 Beatrice's Goat \n", "3223 Star Bright \n", "3263 The Tale of The Flopsy Bunnies \n", "3270 The Girlhood Diary of Louisa May Alcott, 1843-... \n", "3292 Bill Gates: Computer Legend \n", "3522 I Wonder Why the Sun Rises: and Other Question... \n", "3552 Star Wars: Complete Locations \n", "3565 The Star-Spangled Banner \n", "3797 Tree \n", "3798 Bram Stoker's Dracula \n", "3799 Edith Wharton's The Age of Innocence \n", "3800 Freedom Riders: John Lewis and Jim Zwerg on th... \n", "3861 You Come Too: Favorite Poems for Readers of Al... \n", "3863 Rosa \n", "3921 Lewis Carroll's Jabberwocky: A Book of Brillig... \n", "4069 Barack Obama: Working to Make a Difference \n", "4072 A Picture Book of Anne Frank \n", "4409 Writings to Young Women from Laura Ingalls Wil... \n", "4596 Flowers for Algernon \n", "4744 The Red Badge of Courage \n", "4808 The Big Book of Boy Stuff \n", "5041 The Fires of Heaven \n", "5142 The Brooklyn Bridge \n", "\n", " tagged_description \n", "107 9780060277406 Frances Hodgson Burnett's The Se... \n", "108 9780060278427 Though best known as the author ... \n", "228 9780060782139 Butterflies There are 20,000 dif... \n", "267 9780060882600 Charlotte's Web, one of America'... \n", "434 9780064462044 Make the same pioneer crafts tha... \n", "435 9780064462341 The pioneer spirit lives on... R... \n", "439 9780066236179 Last night while I lay thinking ... \n", "812 9780142302279 Poems tell the stories of a smar... \n", "821 9780142407226 A unique guide to fantasy litera... \n", "823 9780142407929 With notes on staging, props, an... \n", "1014 9780198320272 Caesar returns from a triumphant... \n", "1074 9780237525378 This wonderful series is a quick... \n", "1739 9780375812934 Discusses dinosaur research and ... \n", "1742 9780375823787 Filled with fascinating facts, a... \n", "1770 9780380732548 From July 1942 until August 1944... \n", "1972 9780395776087 Recreates the devastation render... \n", "2105 9780439314558 From her birth in Chipping Sodbu... \n", "2117 9780439420068 A group of babies enjoys some fa... \n", "2139 9780439736466 A collection of poems, stories, ... \n", "2183 9780440229353 Author Gary Paulsen relates tale... \n", "2211 9780440419174 Profiles the turbulent life of V... \n", "2320 9780448437439 Chronicles the life of the presi... \n", "2323 9780448444826 Looks closely at Anne Frank's li... \n", "2503 9780486276809 Ten-year-old Mary comes to live ... \n", "2509 9780486296388 Forty-two clear, accurate drawin... \n", "2609 9780521618748 This edition of Hamlet is part o... \n", "2615 9780525469780 Examines what is known about din... \n", "2858 9780590032490 A young boy and his Norwegian gr... \n", "2859 9780590103879 A Down-to-Earth Approach James H... \n", "2897 9780618111206 With powerful and rare photos by... \n", "3133 9780679890522 In 1838, settlers moving west fo... \n", "3202 9780689833762 Knock, knock. Who's there? Someo... \n", "3203 9780689834196 Young Michael Jordan, who is sma... \n", "3204 9780689835612 Is Mommy behind the chair? Is Mo... \n", "3219 9780689869907 In this story based on a case fr... \n", "3223 9780689876707 PopTV is going to follow Star ar... \n", "3263 9780723247791 This original, authorised versio... \n", "3270 9780736805995 Excerpts from the girlhood diary... \n", "3292 9780739844328 Presents the life of Bill Gates,... \n", "3522 9780753459645 What is a leap year? Why are bee... \n", "3552 9780756614195 Glorious full-color illustration... \n", "3565 9780761417101 Looks at the events leading up t... \n", "3797 9780789458209 Photographs and text explore the... \n", "3798 9780791070482 Presents a collection of critica... \n", "3799 9780791081266 One of Edith Wharton's most crit... \n", "3800 9780792241737 Offers the true account of two y... \n", "3861 9780805069853 An introduction to Robert Frost ... \n", "3863 9780805071061 Provides the story of the black ... \n", "3921 9780810935204 Lewis Carroll's classic and inve... \n", "4069 9780822560562 Chronicles the life and career o... \n", "4072 9780823410781 Traces the life of the young Jew... \n", "4409 9781400307845 Using selections from her works ... \n", "4596 9781560067849 Discusses the young adult book \"... \n", "4744 9781580495868 As he faces battle in the Civil ... \n", "4808 9781586853334 There's this boy. Let's say he's... \n", "5041 9781857232097 The fifth book in Robert Jordan'... \n", "5142 9781931414166 Describes the construction of th... " ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
isbn13isbn10titleauthorscategoriesthumbnaildescriptionpublished_yearaverage_ratingnum_pagesratings_counttitle and subtitletagged_description
10797800602774060060277408The Secret Garden CookbookAmy CotlerJuvenile Nonfictionhttp://books.google.com/books/content?id=c7E_H...Frances Hodgson Burnett's The Secret Garden de...1999.04.28128.0142.0The Secret Garden Cookbook: Recipes Inspired b...9780060277406 Frances Hodgson Burnett's The Se...
10897800602784270060278420Laura's AlbumWilliam AndersonJuvenile Nonfictionhttp://books.google.com/books/content?id=_zTkq...Though best known as the author of the Little ...1998.04.3080.0713.0Laura's Album: A Remembrance Scrapbook of Laur...9780060278427 Though best known as the author ...
22897800607821390060782137Time For Kids: Butterflies!Editors of TIME For KidsJuvenile Nonfictionhttp://books.google.com/books/content?id=OdZxn...Butterflies There are 20,000 different kinds o...2006.04.0032.020.0Time For Kids: Butterflies!9780060782139 Butterflies There are 20,000 dif...
26797800608826000060882603The Annotated Charlotte's WebE. B. WhiteJuvenile Nonfictionhttp://books.google.com/books/content?id=vaYYH...Charlotte's Web, one of America's best-loved c...2006.04.16320.041.0The Annotated Charlotte's Web9780060882600 Charlotte's Web, one of America'...
43497800644620440064462048My Little House Crafts BookCarolyn Strom CollinsJuvenile Nonfictionhttp://books.google.com/books/content?id=lTzrs...Make the same pioneer crafts that Laura did! I...1998.04.0564.056.0My Little House Crafts Book: 18 Projects from ...9780064462044 Make the same pioneer crafts tha...
4359780064462341006446234XPioneer GirlWilliam AndersonJuvenile Nonfictionhttp://books.google.com/books/content?id=Sj4UD...The pioneer spirit lives on... Readers around ...2000.04.1532.0414.0Pioneer Girl: The Story of Laura Ingalls Wilder9780064462341 The pioneer spirit lives on... R...
43997800662361790066236177A Light in the Attic Book and CDShel SilversteinJuvenile Nonfictionhttp://books.google.com/books/content?id=FJfQs...Last night while I lay thinking here Some What...2001.04.34176.0590.0A Light in the Attic Book and CD9780066236179 Last night while I lay thinking ...
81297801423022790142302279Dirty BeastsRoald DahlJuvenile NonfictionNaNPoems tell the stories of a smart pig who outw...2002.04.0232.03953.0Dirty Beasts9780142302279 Poems tell the stories of a smar...
82197801424072260142407224The Tough Guide to FantasylandDiana Wynne JonesJuvenile Nonfictionhttp://books.google.com/books/content?id=v5jxA...A unique guide to fantasy literature helps rea...2006.03.94234.03897.0The Tough Guide to Fantasyland9780142407226 A unique guide to fantasy litera...
82397801424079290142407925The BFGRoald Dahl;David Wood;Jane WalmsleyJuvenile Nonfictionhttp://books.google.com/books/content?id=aDf-O...With notes on staging, props, and costumes, a ...2007.04.26128.0452.0The BFG: A Set of Plays9780142407929 With notes on staging, props, an...
101497801983202720198320272Julius CaesarWilliam ShakespeareJuvenile Nonfictionhttp://books.google.com/books/content?id=Nlmkh...Caesar returns from a triumphant battle to Rom...2001.03.67128.0133575.0Julius Caesar9780198320272 Caesar returns from a triumphant...
107497802375253780237525372Oliver TwistPauline Francis;Charles DickensJuvenile Nonfictionhttp://books.google.com/books/content?id=X6RvT...This wonderful series is a quick way into a ra...2003.03.6648.092.0Oliver Twist9780237525378 This wonderful series is a quick...
173997803758129340375812938Jurassic Park Institute Dinosaur Field GuideThomas R. Holtz;M. K. Brett-SurmanJuvenile Nonfictionhttp://books.google.com/books/content?id=vW3hm...Discusses dinosaur research and what can be le...2001.04.08160.02.0Jurassic Park Institute Dinosaur Field Guide9780375812934 Discusses dinosaur research and ...
174297803758237870375823786Ancient Greece and the OlympicsMary Pope Osborne;Natalie Pope BoyceJuvenile Nonfictionhttp://books.google.com/books/content?id=5cPbW...Filled with fascinating facts, a Magic Tree Ho...2004.04.06119.01044.0Ancient Greece and the Olympics: A Nonfiction ...9780375823787 Filled with fascinating facts, a...
177097803807325480380732548Anne FrankJohanna HurwitzJuvenile Nonfictionhttp://books.google.com/books/content?id=3ja19...From July 1942 until August 1944, a young girl...1999.03.9964.0143.0Anne Frank: Life in Hiding9780380732548 From July 1942 until August 1944...
197297803957760870395776082An American PlagueJim MurphyJuvenile NonfictionNaNRecreates the devastation rendered to the city...2003.03.80165.03338.0An American Plague: The True and Terrifying St...9780395776087 Recreates the devastation render...
210597804393145580439314550Conversations with J.K. RowlingLindsey FraserJuvenile Nonfictionhttp://books.google.com/books/content?id=Ly8dl...From her birth in Chipping Sodbury near Bristo...2001.03.9996.04184.0Conversations with J.K. Rowling9780439314558 From her birth in Chipping Sodbu...
211797804394200680439420067Eat!Roberta Grobel IntraterJuvenile Nonfictionhttp://books.google.com/books/content?id=BnQ2n...A group of babies enjoys some favorite foods--...2002.03.9510.054.0Eat!9780439420068 A group of babies enjoys some fa...
213997804397364660439736463Where We Are, what We SeeDavid LevithanJuvenile NonfictionNaNA collection of poems, stories, essays, and ar...2005.03.73288.041.0Where We Are, what We See: The Best Young Arti...9780439736466 A collection of poems, stories, ...
218397804402293530440229359How Angel Peterson Got His NameGary PaulsenJuvenile Nonfictionhttp://books.google.com/books/content?id=maJrL...Author Gary Paulsen relates tales from his you...2004.03.93111.01139.0How Angel Peterson Got His Name: And Other Out...9780440229353 Author Gary Paulsen relates tale...
221197804404191740440419174Vincent Van GoghJan Greenberg;Sandra Jane JordanJuvenile Nonfictionhttp://books.google.com/books/content?id=n7kv9...Profiles the turbulent life of Vincent van Gog...2003.03.95144.0209.0Vincent Van Gogh: Portrait of an Artist9780440419174 Profiles the turbulent life of V...
232097804484374390448437430Who Was John F. Kennedy?Yona Zeldis McDonough;Jill WeberJuvenile Nonfictionhttp://books.google.com/books/content?id=qjCzJ...Chronicles the life of the president who saw A...2004.04.19112.0598.0Who Was John F. Kennedy?9780448437439 Chronicles the life of the presi...
232397804484448260448444828Who Was Anne Frank?Ann AbramsonJuvenile Nonfictionhttp://books.google.com/books/content?id=Bz37n...Looks closely at Anne Frank's life before the ...2007.04.26103.01763.0Who Was Anne Frank?9780448444826 Looks closely at Anne Frank's li...
250397804862768090486276805The Secret Garden Coloring BookFrances Hodgson BurnettJuvenile Nonfictionhttp://books.google.com/books/content?id=sxHdA...Ten-year-old Mary comes to live in a lonely ho...2014.04.2548.04.0The Secret Garden Coloring Book9780486276809 Ten-year-old Mary comes to live ...
250997804862963880486296385Ballet Class Coloring BookJohn Green;Caroline DenzlerJuvenile Nonfictionhttp://books.google.com/books/content?id=p6PBk...Forty-two clear, accurate drawings (all in pro...1997.03.6448.011.0Ballet Class Coloring Book9780486296388 Forty-two clear, accurate drawin...
260997805216187480521618746HamletWilliam ShakespeareJuvenile Nonfictionhttp://books.google.com/books/content?id=5m2UP...This edition of Hamlet is part of the groundbr...2005.04.01289.0577429.0Hamlet9780521618748 This edition of Hamlet is part o...
261597805254697800525469788Boy, Were We Wrong about Dinosaurs!Kathleen V. KudlinskiJuvenile Nonfictionhttp://books.google.com/books/content?id=QrRKD...Examines what is known about dinosaur bones, b...2005.03.9332.0243.0Boy, Were We Wrong about Dinosaurs!9780525469780 Examines what is known about din...
285897805900324900590032496The witchesRoald DahlJuvenile Nonfictionhttp://books.google.com/books/content?id=tpQxo...A young boy and his Norwegian grandmother, who...1997.04.17208.0254867.0The witches9780590032490 A young boy and his Norwegian gr...
285997805901038790590103873Expository WritingTara McCarthyJuvenile Nonfictionhttp://books.google.com/books/content?id=9HKHF...A Down-to-Earth Approach James Henslin shares ...1998.04.3388.03.0Expository Writing9780590103879 A Down-to-Earth Approach James H...
289797806181112060618111204Once a WolfStephen R. Swinburne;Jim BrandenburgJuvenile Nonfictionhttp://books.google.com/books/content?id=UkZWu...With powerful and rare photos by a former phot...2001.04.0648.042.0Once a Wolf: How Wildlife Biologists Fought to...9780618111206 With powerful and rare photos by...
313397806798905220679890521The Trail of TearsJoseph Bruchac;Diana MagnusonJuvenile Nonfictionhttp://books.google.com/books/content?id=QxRUP...In 1838, settlers moving west forced the great...1999.03.8848.0155.0The Trail of Tears9780679890522 In 1838, settlers moving west fo...
320297806898337620689833768Sad Underwear and Other ComplicationsJudith ViorstJuvenile Nonfictionhttp://books.google.com/books/content?id=e-sEA...Knock, knock. Who's there? Someone with sad un...2000.03.8780.0104.0Sad Underwear and Other Complications: More Po...9780689833762 Knock, knock. Who's there? Someo...
320397806898341960689834195Salt in His ShoesDeloris Jordan;Roslyn M. JordanJuvenile Nonfictionhttp://books.google.com/books/content?id=hYzQw...Young Michael Jordan, who is smaller than the ...2003.04.2132.01054.0Salt in His Shoes: Michael Jordan in Pursuit o...9780689834196 Young Michael Jordan, who is sma...
320497806898356120689835612Where Is Baby's Mommy?Karen KatzJuvenile NonfictionNaNIs Mommy behind the chair? Is Mommy behind the...2001.04.1514.0408.0Where Is Baby's Mommy?: A Karen Katz Lift-the-...9780689835612 Is Mommy behind the chair? Is Mo...
321997806898699070689869908Beatrice's GoatPage McBrierJuvenile Nonfictionhttp://books.google.com/books/content?id=4MNED...In this story based on a case from Project Hei...2004.04.2440.0523.0Beatrice's Goat9780689869907 In this story based on a case fr...
32239780689876707068987670XStar BrightCathy HapkaJuvenile Nonfictionhttp://books.google.com/books/content?id=JPuiC...PopTV is going to follow Star around for twent...2005.03.67160.03.0Star Bright9780689876707 PopTV is going to follow Star ar...
32639780723247791072324779XThe Tale of The Flopsy BunniesBeatrix PotterJuvenile Nonfictionhttp://books.google.com/books/content?id=D2uQt...This original, authorised version has been lov...2010.04.1958.05051.0The Tale of The Flopsy Bunnies9780723247791 This original, authorised versio...
327097807368059950736805990The Girlhood Diary of Louisa May Alcott, 1843-...Louisa May AlcottJuvenile Nonfictionhttp://books.google.com/books/content?id=_dP35...Excerpts from the girlhood diary of Louisa May...2001.03.8732.026.0The Girlhood Diary of Louisa May Alcott, 1843-...9780736805995 Excerpts from the girlhood diary...
329297807398443280739844326Bill GatesSara Barton-WoodJuvenile Nonfictionhttp://books.google.com/books/content?id=Fr814...Presents the life of Bill Gates, from his chil...2001.05.0048.00.0Bill Gates: Computer Legend9780739844328 Presents the life of Bill Gates,...
352297807534596450753459647I Wonder Why the Sun RisesBrenda WalpoleJuvenile Nonfictionhttp://books.google.com/books/content?id=SqpYs...What is a leap year? Why are bees busy in summ...2006.03.9532.050.0I Wonder Why the Sun Rises: and Other Question...9780753459645 What is a leap year? Why are bee...
355297807566141950756614198Star WarsKristin Lund;Simon Beecroft;Kerrie DoughertyJuvenile Nonfictionhttp://books.google.com/books/content?id=PAq2A...Glorious full-color illustrations create a sea...2005.04.30175.0128.0Star Wars: Complete Locations9780756614195 Glorious full-color illustration...
356597807614171010761417109The Star-Spangled BannerDebra HessJuvenile Nonfictionhttp://books.google.com/books/content?id=e-uzI...Looks at the events leading up to the War of 1...2003.04.0040.01.0The Star-Spangled Banner9780761417101 Looks at the events leading up t...
379797807894582090789458209TreeDavid BurnieJuvenile Nonfictionhttp://books.google.com/books/content?id=Qwsqj...Photographs and text explore the anatomy and l...2000.04.0764.05.0Tree9780789458209 Photographs and text explore the...
379897807910704820791070484Bram Stoker's DraculaHarold BloomJuvenile Nonfictionhttp://books.google.com/books/content?id=vQ6SQ...Presents a collection of critical essays on Br...2003.03.83243.06.0Bram Stoker's Dracula9780791070482 Presents a collection of critica...
379997807910812660791081265Edith Wharton's The Age of InnocenceHarold BloomJuvenile Nonfictionhttp://books.google.com/books/content?id=MNuFk...One of Edith Wharton's most critically acclaim...2005.03.71205.011.0Edith Wharton's The Age of Innocence9780791081266 One of Edith Wharton's most crit...
380097807922417370792241738Freedom RidersAnn BausumJuvenile Nonfictionhttp://books.google.com/books/content?id=JIlhQ...Offers the true account of two young men who t...2006.03.9780.0247.0Freedom Riders: John Lewis and Jim Zwerg on th...9780792241737 Offers the true account of two y...
386197808050698530805069852You Come TooRobert FrostJuvenile Nonfictionhttp://books.google.com/books/content?id=gZWM6...An introduction to Robert Frost features an ab...2002.04.1692.077.0You Come Too: Favorite Poems for Readers of Al...9780805069853 An introduction to Robert Frost ...
386397808050710610805071067RosaNikki GiovanniJuvenile Nonfictionhttp://books.google.com/books/content?id=3pulA...Provides the story of the black woman whose re...2005.04.3540.05942.0Rosa9780805071061 Provides the story of the black ...
392197808109352040810935201Lewis Carroll's JabberwockyGraeme BaseJuvenile Nonfictionhttp://books.google.com/books/content?id=tyMFA...Lewis Carroll's classic and inventive verse co...1996.04.1414.031.0Lewis Carroll's Jabberwocky: A Book of Brillig...9780810935204 Lewis Carroll's classic and inve...
406997808225605620822560569Barack ObamaMarlene Targ BrillJuvenile Nonfictionhttp://books.google.com/books/content?id=FIhyP...Chronicles the life and career of the communit...2006.03.9648.019.0Barack Obama: Working to Make a Difference9780822560562 Chronicles the life and career o...
407297808234107810823410781A Picture Book of Anne FrankNaNJuvenile Nonfictionhttp://books.google.com/books/content?id=CSNxW...Traces the life of the young Jewish girl whose...1993.04.1732.0208.0A Picture Book of Anne Frank9780823410781 Traces the life of the young Jew...
440997814003078451400307848Writings to Young Women from Laura Ingalls Wil...Laura Ingalls Wilder;Stephen W. HinesJuvenile Nonfictionhttp://books.google.com/books/content?id=e5gSD...Using selections from her works and memoirs of...2006.03.95113.0100.0Writings to Young Women from Laura Ingalls Wil...9781400307845 Using selections from her works ...
459697815600678491560067845Flowers for AlgernonPatrice CassedyJuvenile Nonfictionhttp://books.google.com/books/content?id=x_CUf...Discusses the young adult book \"Flowers for Al...2000.03.0096.01.0Flowers for Algernon9781560067849 Discusses the young adult book \"...
474497815804958681580495869The Red Badge of CourageStephen CraneJuvenile Nonfictionhttp://books.google.com/books/content?id=lN1ga...As he faces battle in the Civil War for the fi...2004.03.23170.074477.0The Red Badge of Courage9781580495868 As he faces battle in the Civil ...
480897815868533341586853333The Big Book of Boy StuffBart KingJuvenile Nonfictionhttp://books.google.com/books/content?id=08Ilm...There's this boy. Let's say he's somewhere bet...2004.04.24292.0141.0The Big Book of Boy Stuff9781586853334 There's this boy. Let's say he's...
504197818572320971857232097The Fires of HeavenRobert JordanJuvenile Nonfictionhttp://books.google.com/books/content?id=4HyfQ...The fifth book in Robert Jordan's internationa...1994.04.15912.0106302.0The Fires of Heaven9781857232097 The fifth book in Robert Jordan'...
514297819314141661931414165The Brooklyn BridgeElizabeth Mann;Alan WitschonkeJuvenile Nonfictionhttp://books.google.com/books/content?id=s28MA...Describes the construction of the Brooklyn Bri...2006.04.4446.035.0The Brooklyn Bridge9781931414166 Describes the construction of th...
\n", "
" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 4 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:13:52.091860Z", "start_time": "2025-02-20T08:13:52.073839Z" } }, "cell_type": "code", "source": [ "category_mapping = {'Fiction' : \"Fiction\",\n", " 'Juvenile Fiction': \"Children's Fiction\",\n", " 'Biography & Autobiography': \"Nonfiction\",\n", " 'History': \"Nonfiction\",\n", " 'Literary Criticism': \"Nonfiction\",\n", " 'Philosophy': \"Nonfiction\",\n", " 'Religion': \"Nonfiction\",\n", " 'Comics & Graphic Novels': \"Fiction\",\n", " 'Drama': \"Fiction\",\n", " 'Juvenile Nonfiction': \"Children's Nonfiction\",\n", " 'Science': \"Nonfiction\",\n", " 'Poetry': \"Fiction\"}\n", "\n", "books[\"simple_categories\"] = books[\"categories\"].map(category_mapping)" ], "id": "d10c6d19d9213da2", "outputs": [], "execution_count": 5 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:13:52.763387Z", "start_time": "2025-02-20T08:13:52.726980Z" } }, "cell_type": "code", "source": "books.head()", "id": "6df324facd8cdd4", "outputs": [ { "data": { "text/plain": [ " isbn13 isbn10 title \\\n", "0 9780002005883 0002005883 Gilead \n", "1 9780002261982 0002261987 Spider's Web \n", "2 9780006178736 0006178731 Rage of angels \n", "3 9780006280897 0006280897 The Four Loves \n", "4 9780006280934 0006280935 The Problem of Pain \n", "\n", " authors categories \\\n", "0 Marilynne Robinson Fiction \n", "1 Charles Osborne;Agatha Christie Detective and mystery stories \n", "2 Sidney Sheldon Fiction \n", "3 Clive Staples Lewis Christian life \n", "4 Clive Staples Lewis Christian life \n", "\n", " thumbnail \\\n", "0 http://books.google.com/books/content?id=KQZCP... \n", "1 http://books.google.com/books/content?id=gA5GP... \n", "2 http://books.google.com/books/content?id=FKo2T... \n", "3 http://books.google.com/books/content?id=XhQ5X... \n", "4 http://books.google.com/books/content?id=Kk-uV... \n", "\n", " description published_year \\\n", "0 A NOVEL THAT READERS and critics have been eag... 2004.0 \n", "1 A new 'Christie for Christmas' -- a full-lengt... 2000.0 \n", "2 A memorable, mesmerizing heroine Jennifer -- b... 1993.0 \n", "3 Lewis' work on the nature of love divides love... 2002.0 \n", "4 \"In The Problem of Pain, C.S. Lewis, one of th... 2002.0 \n", "\n", " average_rating num_pages ratings_count title and subtitle \\\n", "0 3.85 247.0 361.0 Gilead \n", "1 3.83 241.0 5164.0 Spider's Web: A Novel \n", "2 3.93 512.0 29532.0 Rage of angels \n", "3 4.15 170.0 33684.0 The Four Loves \n", "4 4.09 176.0 37569.0 The Problem of Pain \n", "\n", " tagged_description simple_categories \n", "0 9780002005883 A NOVEL THAT READERS and critics... Fiction \n", "1 9780002261982 A new 'Christie for Christmas' -... NaN \n", "2 9780006178736 A memorable, mesmerizing heroine... Fiction \n", "3 9780006280897 Lewis' work on the nature of lov... NaN \n", "4 9780006280934 \"In The Problem of Pain, C.S. Le... NaN " ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
isbn13isbn10titleauthorscategoriesthumbnaildescriptionpublished_yearaverage_ratingnum_pagesratings_counttitle and subtitletagged_descriptionsimple_categories
097800020058830002005883GileadMarilynne RobinsonFictionhttp://books.google.com/books/content?id=KQZCP...A NOVEL THAT READERS and critics have been eag...2004.03.85247.0361.0Gilead9780002005883 A NOVEL THAT READERS and critics...Fiction
197800022619820002261987Spider's WebCharles Osborne;Agatha ChristieDetective and mystery storieshttp://books.google.com/books/content?id=gA5GP...A new 'Christie for Christmas' -- a full-lengt...2000.03.83241.05164.0Spider's Web: A Novel9780002261982 A new 'Christie for Christmas' -...NaN
297800061787360006178731Rage of angelsSidney SheldonFictionhttp://books.google.com/books/content?id=FKo2T...A memorable, mesmerizing heroine Jennifer -- b...1993.03.93512.029532.0Rage of angels9780006178736 A memorable, mesmerizing heroine...Fiction
397800062808970006280897The Four LovesClive Staples LewisChristian lifehttp://books.google.com/books/content?id=XhQ5X...Lewis' work on the nature of love divides love...2002.04.15170.033684.0The Four Loves9780006280897 Lewis' work on the nature of lov...NaN
497800062809340006280935The Problem of PainClive Staples LewisChristian lifehttp://books.google.com/books/content?id=Kk-uV...\"In The Problem of Pain, C.S. Lewis, one of th...2002.04.09176.037569.0The Problem of Pain9780006280934 \"In The Problem of Pain, C.S. Le...NaN
\n", "
" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 6 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:13:53.065556Z", "start_time": "2025-02-20T08:13:53.015674Z" } }, "cell_type": "code", "source": "books[~(books[\"simple_categories\"].isna())].head()", "id": "51369ca7d06980ba", "outputs": [ { "data": { "text/plain": [ " isbn13 isbn10 title authors \\\n", "0 9780002005883 0002005883 Gilead Marilynne Robinson \n", "2 9780006178736 0006178731 Rage of angels Sidney Sheldon \n", "8 9780006482079 0006482074 Warhost of Vastmark Janny Wurts \n", "30 9780006646006 000664600X Ocean Star Express Mark Haddon;Peter Sutton \n", "46 9780007121014 0007121016 Taken at the Flood Agatha Christie \n", "\n", " categories thumbnail \\\n", "0 Fiction http://books.google.com/books/content?id=KQZCP... \n", "2 Fiction http://books.google.com/books/content?id=FKo2T... \n", "8 Fiction http://books.google.com/books/content?id=uOL0f... \n", "30 Juvenile Fiction http://books.google.com/books/content?id=I2QZA... \n", "46 Fiction http://books.google.com/books/content?id=3gWlx... \n", "\n", " description published_year \\\n", "0 A NOVEL THAT READERS and critics have been eag... 2004.0 \n", "2 A memorable, mesmerizing heroine Jennifer -- b... 1993.0 \n", "8 Tricked once more by his wily half-brother, Ly... 1995.0 \n", "30 Joe and his parents are enjoying a summer holi... 2002.0 \n", "46 A Few Weeks After Marrying An Attractive Young... 2002.0 \n", "\n", " average_rating num_pages ratings_count title and subtitle \\\n", "0 3.85 247.0 361.0 Gilead \n", "2 3.93 512.0 29532.0 Rage of angels \n", "8 4.03 522.0 2966.0 Warhost of Vastmark \n", "30 3.50 32.0 1.0 Ocean Star Express \n", "46 3.71 352.0 8852.0 Taken at the Flood \n", "\n", " tagged_description simple_categories \n", "0 9780002005883 A NOVEL THAT READERS and critics... Fiction \n", "2 9780006178736 A memorable, mesmerizing heroine... Fiction \n", "8 9780006482079 Tricked once more by his wily ha... Fiction \n", "30 9780006646006 Joe and his parents are enjoying... Children's Fiction \n", "46 9780007121014 A Few Weeks After Marrying An At... Fiction " ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
isbn13isbn10titleauthorscategoriesthumbnaildescriptionpublished_yearaverage_ratingnum_pagesratings_counttitle and subtitletagged_descriptionsimple_categories
097800020058830002005883GileadMarilynne RobinsonFictionhttp://books.google.com/books/content?id=KQZCP...A NOVEL THAT READERS and critics have been eag...2004.03.85247.0361.0Gilead9780002005883 A NOVEL THAT READERS and critics...Fiction
297800061787360006178731Rage of angelsSidney SheldonFictionhttp://books.google.com/books/content?id=FKo2T...A memorable, mesmerizing heroine Jennifer -- b...1993.03.93512.029532.0Rage of angels9780006178736 A memorable, mesmerizing heroine...Fiction
897800064820790006482074Warhost of VastmarkJanny WurtsFictionhttp://books.google.com/books/content?id=uOL0f...Tricked once more by his wily half-brother, Ly...1995.04.03522.02966.0Warhost of Vastmark9780006482079 Tricked once more by his wily ha...Fiction
309780006646006000664600XOcean Star ExpressMark Haddon;Peter SuttonJuvenile Fictionhttp://books.google.com/books/content?id=I2QZA...Joe and his parents are enjoying a summer holi...2002.03.5032.01.0Ocean Star Express9780006646006 Joe and his parents are enjoying...Children's Fiction
4697800071210140007121016Taken at the FloodAgatha ChristieFictionhttp://books.google.com/books/content?id=3gWlx...A Few Weeks After Marrying An Attractive Young...2002.03.71352.08852.0Taken at the Flood9780007121014 A Few Weeks After Marrying An At...Fiction
\n", "
" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 7 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:14:48.148764Z", "start_time": "2025-02-20T08:13:53.631038Z" } }, "cell_type": "code", "source": [ "from transformers import pipeline\n", "\n", "fiction_categories=[\"Fiction\",\"Nonfiction\"]\n", "pipe = pipeline(\"zero-shot-classification\", model=\"facebook/bart-large-mnli\",device=\"cpu\")" ], "id": "81e76d83ec330f3a", "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "Device set to use cpu\n" ] } ], "execution_count": 8 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:14:48.345341Z", "start_time": "2025-02-20T08:14:48.331271Z" } }, "cell_type": "code", "source": "sequence=books.loc[books[\"simple_categories\"]==\"Fiction\",\"description\"].reset_index(drop=True)[0]", "id": "a6e0d3836c7b80de", "outputs": [], "execution_count": 9 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:14:59.097698Z", "start_time": "2025-02-20T08:14:48.531509Z" } }, "cell_type": "code", "source": "pipe(sequence,fiction_categories)", "id": "4e1a901d7db7f650", "outputs": [ { "data": { "text/plain": [ "{'sequence': 'A NOVEL THAT READERS and critics have been eagerly anticipating for over a decade, Gilead is an astonishingly imagined story of remarkable lives. John Ames is a preacher, the son of a preacher and the grandson (both maternal and paternal) of preachers. It’s 1956 in Gilead, Iowa, towards the end of the Reverend Ames’s life, and he is absorbed in recording his family’s story, a legacy for the young son he will never see grow up. Haunted by his grandfather’s presence, John tells of the rift between his grandfather and his father: the elder, an angry visionary who fought for the abolitionist cause, and his son, an ardent pacifist. He is troubled, too, by his prodigal namesake, Jack (John Ames) Boughton, his best friend’s lost son who returns to Gilead searching for forgiveness and redemption. Told in John Ames’s joyous, rambling voice that finds beauty, humour and truth in the smallest of life’s details, Gilead is a song of celebration and acceptance of the best and the worst the world has to offer. At its heart is a tale of the sacred bonds between fathers and sons, pitch-perfect in style and story, set to dazzle critics and readers alike.',\n", " 'labels': ['Fiction', 'Nonfiction'],\n", " 'scores': [0.8438266515731812, 0.15617337822914124]}" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 10 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:15:10.686732Z", "start_time": "2025-02-20T08:14:59.177576Z" } }, "cell_type": "code", "source": [ "import numpy as np\n", "\n", "max_index=np.argmax(pipe(sequence,fiction_categories)[\"scores\"])\n", "max_label=pipe(sequence,fiction_categories)[\"labels\"][max_index]\n", "max_label" ], "id": "b011cbe611bb0a57", "outputs": [ { "data": { "text/plain": [ "'Fiction'" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 11 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:15:10.718438Z", "start_time": "2025-02-20T08:15:10.708664Z" } }, "cell_type": "code", "source": [ "\n", "def generate_predictions(sequence, categories):\n", " predictions = pipe(sequence, categories)\n", " max_index = np.argmax(predictions[\"scores\"])\n", " max_label = predictions[\"labels\"][max_index]\n", " return max_label" ], "id": "8a5768484a58ee30", "outputs": [], "execution_count": 12 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:31:24.992567Z", "start_time": "2025-02-20T08:15:10.752653Z" } }, "cell_type": "code", "source": [ "from tqdm import tqdm\n", "\n", "actual_cats = []\n", "predicted_cats = []\n", "\n", "for i in tqdm(range(0, 300)):\n", " sequence = books.loc[books[\"simple_categories\"] == \"Fiction\", \"description\"].reset_index(drop=True)[i]\n", " predicted_cats += [generate_predictions(sequence, fiction_categories)]\n", " actual_cats += [\"Fiction\"]" ], "id": "b5dee8fa2330c19f", "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "100%|██████████| 300/300 [16:14<00:00, 3.25s/it]\n" ] } ], "execution_count": 13 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:46:15.588896Z", "start_time": "2025-02-20T08:31:25.156996Z" } }, "cell_type": "code", "source": [ "for i in tqdm(range(0, 300)):\n", " sequence = books.loc[books[\"simple_categories\"] == \"Nonfiction\", \"description\"].reset_index(drop=True)[i]\n", " predicted_cats += [generate_predictions(sequence, fiction_categories)]\n", " actual_cats += [\"Nonfiction\"]" ], "id": "aac20b89c9296b7", "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "100%|██████████| 300/300 [14:50<00:00, 2.97s/it]\n" ] } ], "execution_count": 14 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:46:15.651319Z", "start_time": "2025-02-20T08:46:15.644104Z" } }, "cell_type": "code", "source": [ "import pandas as pd\n", "prediction_df=pd.DataFrame({\"actual_categories\":actual_cats,\"predicted_categories\":predicted_cats})" ], "id": "859a94ee63532f20", "outputs": [], "execution_count": 15 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:46:15.724673Z", "start_time": "2025-02-20T08:46:15.717192Z" } }, "cell_type": "code", "source": [ "prediction_df[\"correct_predictions\"]=(\n", " np.where(prediction_df[\"actual_categories\"]==prediction_df[\"predicted_categories\"],1,0)\n", ")" ], "id": "e05e480e2b2d21fe", "outputs": [], "execution_count": 16 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:46:15.755661Z", "start_time": "2025-02-20T08:46:15.745607Z" } }, "cell_type": "code", "source": "prediction_df[\"correct_predictions\"].sum()/len(prediction_df)", "id": "f67f2492861dd212", "outputs": [ { "data": { "text/plain": [ "0.7783333333333333" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 17 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T08:46:15.797812Z", "start_time": "2025-02-20T08:46:15.784305Z" } }, "cell_type": "code", "source": [ "isbns=[]\n", "predicted_cats=[]\n", "\n", "missing_cats= books.loc[books[\"simple_categories\"].isna(),[\"isbn13\",\"description\"]].reset_index(drop=True)" ], "id": "64605982e9f10ed4", "outputs": [], "execution_count": 18 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T12:30:56.125151Z", "start_time": "2025-02-20T11:26:19.938840Z" } }, "cell_type": "code", "source": [ "for i in tqdm(range(0, len(missing_cats))):\n", " sequence=missing_cats[\"description\"][i]\n", " predicted_cats+=[generate_predictions(sequence,fiction_categories)]\n", " isbns+=[missing_cats[\"isbn13\"][i]]" ], "id": "82ebac1a84d118d4", "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "100%|██████████| 1454/1454 [1:04:36<00:00, 2.67s/it]\n" ] } ], "execution_count": 21 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T15:27:37.559044Z", "start_time": "2025-02-20T15:27:37.459781Z" } }, "cell_type": "code", "source": "missing_predicted_df = pd.DataFrame({\"isbn13\": isbns, \"predicted_categories\": predicted_cats})", "id": "3e652f374b1f71d1", "outputs": [], "execution_count": 24 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T15:27:39.143021Z", "start_time": "2025-02-20T15:27:39.016437Z" } }, "cell_type": "code", "source": "missing_predicted_df", "id": "4baa28617dd72071", "outputs": [ { "data": { "text/plain": [ " isbn13 predicted_categories\n", "0 9780002261982 Fiction\n", "1 9780006280897 Nonfiction\n", "2 9780006280934 Nonfiction\n", "3 9780006380832 Nonfiction\n", "4 9780006470229 Fiction\n", "... ... ...\n", "2281 9788125026600 Nonfiction\n", "2282 9788171565641 Fiction\n", "2283 9788172235222 Fiction\n", "2284 9788173031014 Nonfiction\n", "2285 9788179921623 Fiction\n", "\n", "[2286 rows x 2 columns]" ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
isbn13predicted_categories
09780002261982Fiction
19780006280897Nonfiction
29780006280934Nonfiction
39780006380832Nonfiction
49780006470229Fiction
.........
22819788125026600Nonfiction
22829788171565641Fiction
22839788172235222Fiction
22849788173031014Nonfiction
22859788179921623Fiction
\n", "

2286 rows × 2 columns

\n", "
" ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 25 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T15:27:40.643401Z", "start_time": "2025-02-20T15:27:40.424029Z" } }, "cell_type": "code", "source": [ "books=pd.merge(books,missing_predicted_df,on=\"isbn13\",how=\"left\")\n", "books[\"simple_categories\"]=np.where(books[\"simple_categories\"].isna(),books[\"predicted_categories\"],books[\"simple_categories\"])\n", "books=books.drop(columns=\"predicted_categories\")" ], "id": "78a7af27a2e355ed", "outputs": [], "execution_count": 26 }, { "metadata": {}, "cell_type": "markdown", "source": "One challenge is we face using zero shot classification is that for fiction and non-fiction we had significant dataset available to test it out but it is not the same case for other categories as well", "id": "d45fb70ff7686a68" }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T15:27:42.022497Z", "start_time": "2025-02-20T15:27:41.945879Z" } }, "cell_type": "code", "source": [ "books[books[\"categories\"].str.lower().isin([\n", " \"romance\",\n", " \"science fiction\",\n", " \"scifi\",\n", " \"fantasy\",\n", " \"horror\",\n", " \"mystery\",\n", " \"thriller\",\n", " \"comedy\",\n", " \"crime\",\n", " \"historical\"\n", "])]" ], "id": "cf6c9bb736636f41", "outputs": [ { "data": { "text/plain": [ " isbn13 isbn10 title \\\n", "53 9780006513087 0006513085 Gravity \n", "54 9780006513087 0006513085 Gravity \n", "620 9780099410355 0099410354 Traitor \n", "621 9780099410355 0099410354 Traitor \n", "626 9780099422341 0099422344 Yeats is Dead! \n", "627 9780099422341 0099422344 Yeats is Dead! \n", "651 9780099446729 0099446723 Blackwood Farm \n", "652 9780099446729 0099446723 Blackwood Farm \n", "1431 9780261102422 0261102427 The Silmarillion \n", "1432 9780261102422 0261102427 The Silmarillion \n", "1893 9780340837955 0340837950 Stranger in a Strange Land \n", "1894 9780340837955 0340837950 Stranger in a Strange Land \n", "1900 9780345251220 0345251229 Visions from Nowhere \n", "1901 9780345251220 0345251229 Visions from Nowhere \n", "3602 9780575075597 0575075597 Replay \n", "3603 9780575075597 0575075597 Replay \n", "3626 9780590254762 0590254766 The lion, the witch and the wardrobe \n", "3627 9780590254762 0590254766 The lion, the witch and the wardrobe \n", "4120 9780739423851 0739423851 Wizard's Castle \n", "4121 9780739439708 0739439707 Time Quartet \n", "4395 9780760728505 076072850X 20,000 Leagues Under the Sea \n", "5315 9781416502043 1416502041 The Voyage of the Jerle Shannara Trilogy \n", "5811 9781841494081 1841494089 The Darkness that Comes Before \n", "5872 9781857231359 185723135X Use of Weapons \n", "5889 9781857989342 1857989341 The Gods Themselves \n", "\n", " authors categories \\\n", "53 Tess Gerritsen Science fiction \n", "54 Tess Gerritsen Science fiction \n", "620 Matthew Woodring Stover Science fiction \n", "621 Matthew Woodring Stover Science fiction \n", "626 Joseph O'Connor Comedy \n", "627 Joseph O'Connor Comedy \n", "651 Anne Rice Horror \n", "652 Anne Rice Horror \n", "1431 John Ronald Reuel Tolkien Fantasy \n", "1432 John Ronald Reuel Tolkien Fantasy \n", "1893 Robert A. Heinlein Science fiction \n", "1894 Robert A. Heinlein Science fiction \n", "1900 William Arrow Science fiction \n", "1901 William Arrow Science fiction \n", "3602 Ken Grimwood Fantasy \n", "3603 Ken Grimwood Fantasy \n", "3626 Clive Staples Lewis Fantasy \n", "3627 Clive Staples Lewis Fantasy \n", "4120 Diana Wynne Jones Fantasy \n", "4121 Madeleine L'Engle Science fiction \n", "4395 Jules Verne Science fiction \n", "5315 Terry Brooks Fantasy \n", "5811 R. Scott Bakker Fantasy \n", "5872 Iain Banks Science fiction \n", "5889 Isaac Asimov Science fiction \n", "\n", " thumbnail \\\n", "53 http://books.google.com/books/content?id=KI66c... \n", "54 http://books.google.com/books/content?id=KI66c... \n", "620 http://books.google.com/books/content?id=VbICO... \n", "621 http://books.google.com/books/content?id=VbICO... \n", "626 http://books.google.com/books/content?id=DrE3I... \n", "627 http://books.google.com/books/content?id=DrE3I... \n", "651 http://books.google.com/books/content?id=cIn8T... \n", "652 http://books.google.com/books/content?id=cIn8T... \n", "1431 http://books.google.com/books/content?id=22ePu... \n", "1432 http://books.google.com/books/content?id=22ePu... \n", "1893 http://books.google.com/books/content?id=ZQhiP... \n", "1894 http://books.google.com/books/content?id=ZQhiP... \n", "1900 NaN \n", "1901 NaN \n", "3602 http://books.google.com/books/content?id=9vmNP... \n", "3603 http://books.google.com/books/content?id=9vmNP... \n", "3626 NaN \n", "3627 NaN \n", "4120 http://books.google.com/books/content?id=hB7hA... \n", "4121 NaN \n", "4395 NaN \n", "5315 http://books.google.com/books/content?id=jqVsA... \n", "5811 http://books.google.com/books/content?id=BG8qG... \n", "5872 NaN \n", "5889 http://books.google.com/books/content?id=8ClIP... \n", "\n", " description published_year \\\n", "53 Emma Watson a research physician has been trai... 2004.0 \n", "54 Emma Watson a research physician has been trai... 2004.0 \n", "620 From the depths of catastrophe, a glimmer of h... 2002.0 \n", "621 From the depths of catastrophe, a glimmer of h... 2002.0 \n", "626 In aid of Amnesty International, this is a bri... 2002.0 \n", "627 In aid of Amnesty International, this is a bri... 2002.0 \n", "651 Lestat Is Back, Saviour And Demon, Presiding O... 2003.0 \n", "652 Lestat Is Back, Saviour And Demon, Presiding O... 2003.0 \n", "1431 Tolkien's Silmarillion is the core work of the... 1999.0 \n", "1432 Tolkien's Silmarillion is the core work of the... 1999.0 \n", "1893 Epic, entertaining, Stranger in a Strange Land... 2005.0 \n", "1894 Epic, entertaining, Stranger in a Strange Land... 2005.0 \n", "1900 The first novel in the series, \"Return to the ... 1976.0 \n", "1901 The first novel in the series, \"Return to the ... 1976.0 \n", "3602 At forty-three Jeff Winston is tired of his lo... 2005.0 \n", "3603 At forty-three Jeff Winston is tired of his lo... 2005.0 \n", "3626 Four English school children enter the magic l... 1995.0 \n", "3627 Four English school children enter the magic l... 1995.0 \n", "4120 Howl's moving castle - Eldest of three sisters... 2002.0 \n", "4121 Blending magic with quantum physics, Madeleine... 2003.0 \n", "4395 Retells the adventures of a French professor a... 2002.0 \n", "5315 When the body of a half-drowned elf is found f... 2004.0 \n", "5811 A score of centuries has passed since the Firs... 2005.0 \n", "5872 The man known as Cheradenine Zakalwe was one o... 1992.0 \n", "5889 In the year 2100, mankind on Earth, settlers i... 2000.0 \n", "\n", " average_rating num_pages ratings_count \\\n", "53 4.04 342.0 8024.0 \n", "54 4.04 342.0 8024.0 \n", "620 4.00 320.0 6765.0 \n", "621 4.00 320.0 6765.0 \n", "626 3.39 298.0 34.0 \n", "627 3.39 298.0 34.0 \n", "651 3.86 774.0 26145.0 \n", "652 3.86 774.0 26145.0 \n", "1431 3.91 384.0 253.0 \n", "1432 3.91 384.0 253.0 \n", "1893 3.92 672.0 563.0 \n", "1894 3.92 672.0 563.0 \n", "1900 3.23 183.0 10.0 \n", "1901 3.23 183.0 10.0 \n", "3602 4.16 272.0 412.0 \n", "3603 4.16 272.0 412.0 \n", "3626 4.21 189.0 860.0 \n", "3627 4.21 189.0 860.0 \n", "4120 4.44 376.0 439.0 \n", "4121 4.35 646.0 165.0 \n", "4395 3.88 394.0 135778.0 \n", "5315 4.26 1260.0 84.0 \n", "5811 3.79 638.0 317.0 \n", "5872 4.19 411.0 30779.0 \n", "5889 4.09 288.0 41304.0 \n", "\n", " title and subtitle \\\n", "53 Gravity \n", "54 Gravity \n", "620 Traitor \n", "621 Traitor \n", "626 Yeats is Dead!: A Novel by Fifteen Irish Writers \n", "627 Yeats is Dead!: A Novel by Fifteen Irish Writers \n", "651 Blackwood Farm \n", "652 Blackwood Farm \n", "1431 The Silmarillion \n", "1432 The Silmarillion \n", "1893 Stranger in a Strange Land \n", "1894 Stranger in a Strange Land \n", "1900 Visions from Nowhere \n", "1901 Visions from Nowhere \n", "3602 Replay \n", "3603 Replay \n", "3626 The lion, the witch and the wardrobe \n", "3627 The lion, the witch and the wardrobe \n", "4120 Wizard's Castle \n", "4121 Time Quartet \n", "4395 20,000 Leagues Under the Sea \n", "5315 The Voyage of the Jerle Shannara Trilogy \n", "5811 The Darkness that Comes Before \n", "5872 Use of Weapons \n", "5889 The Gods Themselves \n", "\n", " tagged_description simple_categories \n", "53 9780006513087 Emma Watson a research physician... Nonfiction \n", "54 9780006513087 Emma Watson a research physician... Nonfiction \n", "620 9780099410355 From the depths of catastrophe, ... Fiction \n", "621 9780099410355 From the depths of catastrophe, ... Fiction \n", "626 9780099422341 In aid of Amnesty International,... Fiction \n", "627 9780099422341 In aid of Amnesty International,... Fiction \n", "651 9780099446729 Lestat Is Back, Saviour And Demo... Fiction \n", "652 9780099446729 Lestat Is Back, Saviour And Demo... Fiction \n", "1431 9780261102422 Tolkien's Silmarillion is the co... Fiction \n", "1432 9780261102422 Tolkien's Silmarillion is the co... Fiction \n", "1893 9780340837955 Epic, entertaining, Stranger in ... Fiction \n", "1894 9780340837955 Epic, entertaining, Stranger in ... Fiction \n", "1900 9780345251220 The first novel in the series, \"... Fiction \n", "1901 9780345251220 The first novel in the series, \"... Fiction \n", "3602 9780575075597 At forty-three Jeff Winston is t... Fiction \n", "3603 9780575075597 At forty-three Jeff Winston is t... Fiction \n", "3626 9780590254762 Four English school children ent... Nonfiction \n", "3627 9780590254762 Four English school children ent... Nonfiction \n", "4120 9780739423851 Howl's moving castle - Eldest of... Fiction \n", "4121 9780739439708 Blending magic with quantum phys... Fiction \n", "4395 9780760728505 Retells the adventures of a Fren... Fiction \n", "5315 9781416502043 When the body of a half-drowned ... Fiction \n", "5811 9781841494081 A score of centuries has passed ... Nonfiction \n", "5872 9781857231359 The man known as Cheradenine Zak... Nonfiction \n", "5889 9781857989342 In the year 2100, mankind on Ear... Fiction " ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
isbn13isbn10titleauthorscategoriesthumbnaildescriptionpublished_yearaverage_ratingnum_pagesratings_counttitle and subtitletagged_descriptionsimple_categories
5397800065130870006513085GravityTess GerritsenScience fictionhttp://books.google.com/books/content?id=KI66c...Emma Watson a research physician has been trai...2004.04.04342.08024.0Gravity9780006513087 Emma Watson a research physician...Nonfiction
5497800065130870006513085GravityTess GerritsenScience fictionhttp://books.google.com/books/content?id=KI66c...Emma Watson a research physician has been trai...2004.04.04342.08024.0Gravity9780006513087 Emma Watson a research physician...Nonfiction
62097800994103550099410354TraitorMatthew Woodring StoverScience fictionhttp://books.google.com/books/content?id=VbICO...From the depths of catastrophe, a glimmer of h...2002.04.00320.06765.0Traitor9780099410355 From the depths of catastrophe, ...Fiction
62197800994103550099410354TraitorMatthew Woodring StoverScience fictionhttp://books.google.com/books/content?id=VbICO...From the depths of catastrophe, a glimmer of h...2002.04.00320.06765.0Traitor9780099410355 From the depths of catastrophe, ...Fiction
62697800994223410099422344Yeats is Dead!Joseph O'ConnorComedyhttp://books.google.com/books/content?id=DrE3I...In aid of Amnesty International, this is a bri...2002.03.39298.034.0Yeats is Dead!: A Novel by Fifteen Irish Writers9780099422341 In aid of Amnesty International,...Fiction
62797800994223410099422344Yeats is Dead!Joseph O'ConnorComedyhttp://books.google.com/books/content?id=DrE3I...In aid of Amnesty International, this is a bri...2002.03.39298.034.0Yeats is Dead!: A Novel by Fifteen Irish Writers9780099422341 In aid of Amnesty International,...Fiction
65197800994467290099446723Blackwood FarmAnne RiceHorrorhttp://books.google.com/books/content?id=cIn8T...Lestat Is Back, Saviour And Demon, Presiding O...2003.03.86774.026145.0Blackwood Farm9780099446729 Lestat Is Back, Saviour And Demo...Fiction
65297800994467290099446723Blackwood FarmAnne RiceHorrorhttp://books.google.com/books/content?id=cIn8T...Lestat Is Back, Saviour And Demon, Presiding O...2003.03.86774.026145.0Blackwood Farm9780099446729 Lestat Is Back, Saviour And Demo...Fiction
143197802611024220261102427The SilmarillionJohn Ronald Reuel TolkienFantasyhttp://books.google.com/books/content?id=22ePu...Tolkien's Silmarillion is the core work of the...1999.03.91384.0253.0The Silmarillion9780261102422 Tolkien's Silmarillion is the co...Fiction
143297802611024220261102427The SilmarillionJohn Ronald Reuel TolkienFantasyhttp://books.google.com/books/content?id=22ePu...Tolkien's Silmarillion is the core work of the...1999.03.91384.0253.0The Silmarillion9780261102422 Tolkien's Silmarillion is the co...Fiction
189397803408379550340837950Stranger in a Strange LandRobert A. HeinleinScience fictionhttp://books.google.com/books/content?id=ZQhiP...Epic, entertaining, Stranger in a Strange Land...2005.03.92672.0563.0Stranger in a Strange Land9780340837955 Epic, entertaining, Stranger in ...Fiction
189497803408379550340837950Stranger in a Strange LandRobert A. HeinleinScience fictionhttp://books.google.com/books/content?id=ZQhiP...Epic, entertaining, Stranger in a Strange Land...2005.03.92672.0563.0Stranger in a Strange Land9780340837955 Epic, entertaining, Stranger in ...Fiction
190097803452512200345251229Visions from NowhereWilliam ArrowScience fictionNaNThe first novel in the series, \"Return to the ...1976.03.23183.010.0Visions from Nowhere9780345251220 The first novel in the series, \"...Fiction
190197803452512200345251229Visions from NowhereWilliam ArrowScience fictionNaNThe first novel in the series, \"Return to the ...1976.03.23183.010.0Visions from Nowhere9780345251220 The first novel in the series, \"...Fiction
360297805750755970575075597ReplayKen GrimwoodFantasyhttp://books.google.com/books/content?id=9vmNP...At forty-three Jeff Winston is tired of his lo...2005.04.16272.0412.0Replay9780575075597 At forty-three Jeff Winston is t...Fiction
360397805750755970575075597ReplayKen GrimwoodFantasyhttp://books.google.com/books/content?id=9vmNP...At forty-three Jeff Winston is tired of his lo...2005.04.16272.0412.0Replay9780575075597 At forty-three Jeff Winston is t...Fiction
362697805902547620590254766The lion, the witch and the wardrobeClive Staples LewisFantasyNaNFour English school children enter the magic l...1995.04.21189.0860.0The lion, the witch and the wardrobe9780590254762 Four English school children ent...Nonfiction
362797805902547620590254766The lion, the witch and the wardrobeClive Staples LewisFantasyNaNFour English school children enter the magic l...1995.04.21189.0860.0The lion, the witch and the wardrobe9780590254762 Four English school children ent...Nonfiction
412097807394238510739423851Wizard's CastleDiana Wynne JonesFantasyhttp://books.google.com/books/content?id=hB7hA...Howl's moving castle - Eldest of three sisters...2002.04.44376.0439.0Wizard's Castle9780739423851 Howl's moving castle - Eldest of...Fiction
412197807394397080739439707Time QuartetMadeleine L'EngleScience fictionNaNBlending magic with quantum physics, Madeleine...2003.04.35646.0165.0Time Quartet9780739439708 Blending magic with quantum phys...Fiction
43959780760728505076072850X20,000 Leagues Under the SeaJules VerneScience fictionNaNRetells the adventures of a French professor a...2002.03.88394.0135778.020,000 Leagues Under the Sea9780760728505 Retells the adventures of a Fren...Fiction
531597814165020431416502041The Voyage of the Jerle Shannara TrilogyTerry BrooksFantasyhttp://books.google.com/books/content?id=jqVsA...When the body of a half-drowned elf is found f...2004.04.261260.084.0The Voyage of the Jerle Shannara Trilogy9781416502043 When the body of a half-drowned ...Fiction
581197818414940811841494089The Darkness that Comes BeforeR. Scott BakkerFantasyhttp://books.google.com/books/content?id=BG8qG...A score of centuries has passed since the Firs...2005.03.79638.0317.0The Darkness that Comes Before9781841494081 A score of centuries has passed ...Nonfiction
58729781857231359185723135XUse of WeaponsIain BanksScience fictionNaNThe man known as Cheradenine Zakalwe was one o...1992.04.19411.030779.0Use of Weapons9781857231359 The man known as Cheradenine Zak...Nonfiction
588997818579893421857989341The Gods ThemselvesIsaac AsimovScience fictionhttp://books.google.com/books/content?id=8ClIP...In the year 2100, mankind on Earth, settlers i...2000.04.09288.041304.0The Gods Themselves9781857989342 In the year 2100, mankind on Ear...Fiction
\n", "
" ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 27 }, { "metadata": { "ExecuteTime": { "end_time": "2025-02-20T15:27:43.397468Z", "start_time": "2025-02-20T15:27:43.164710Z" } }, "cell_type": "code", "source": "books.to_csv(\"books_with_categories.csv\", index=False)", "id": "dd0dc0f432b2182d", "outputs": [], "execution_count": 28 } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 2 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython2", "version": "2.7.6" } }, "nbformat": 4, "nbformat_minor": 5 }