{ "cells": [ { "cell_type": "code", "execution_count": 2, "id": "1ec6fe36", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "books=pd.read_csv(\"books_cleaned.csv\")\n", "books=pd.DataFrame(books)" ] }, { "cell_type": "code", "execution_count": 3, "id": "08743373", "metadata": {}, "outputs": [ { "data": { "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", "
categoriescount
0Fiction2111
1Juvenile Fiction390
2Biography & Autobiography311
3History207
4Literary Criticism124
5Philosophy117
6Religion117
7Comics & Graphic Novels116
8Drama86
9Juvenile Nonfiction57
10Science56
11Poetry51
\n", "
" ], "text/plain": [ " categories count\n", "0 Fiction 2111\n", "1 Juvenile Fiction 390\n", "2 Biography & Autobiography 311\n", "3 History 207\n", "4 Literary Criticism 124\n", "5 Philosophy 117\n", "6 Religion 117\n", "7 Comics & Graphic Novels 116\n", "8 Drama 86\n", "9 Juvenile Nonfiction 57\n", "10 Science 56\n", "11 Poetry 51" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "books[\"categories\"].value_counts().reset_index().query(\"count>50\")" ] }, { "cell_type": "code", "execution_count": 4, "id": "b5345c50", "metadata": {}, "outputs": [ { "data": { "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", "
" ], "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]" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "books[books[\"categories\"]== \"Juvenile Fiction\"]" ] }, { "cell_type": "code", "execution_count": 5, "id": "16521acc", "metadata": {}, "outputs": [ { "data": { "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", "
" ], "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... " ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "books[books[\"categories\"]== \"Juvenile Nonfiction\"]" ] }, { "cell_type": "code", "execution_count": 6, "id": "0a8c60f3", "metadata": {}, "outputs": [], "source": [ "category_mapping={'Fiction': \"Fiction\",\n", " 'Juvenile Fiction': \"Children's Fiction\",\n", " 'Juvenile Nonfiction': \"Children's Nonfiction\",\n", " 'Nonfiction': \"Nonfiction\",\n", " 'Biography & Autobiography':\"Nonfiction\",\n", " 'Science':\"Fiction\",\n", " 'History':\"Nonfiction\",\n", " 'Literary Criticism':\"Nonfiction\",\n", " 'Poetry':\"Fiction\",\n", " 'Religion':\"Nonfiction\",\n", " 'Philosophy':\"Nonfiction\",\n", " 'Drama':\"Fiction\",\n", " 'Comics & Graphic Novels':\"Fiction\",}\n", "books[\"simple_categories\"]=books[\"categories\"].map(category_mapping)" ] }, { "cell_type": "code", "execution_count": 7, "id": "febdb21a", "metadata": {}, "outputs": [ { "data": { "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", "
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
.............................................
519297881722352228172235224Mistaken IdentityNayantara SahgalIndic fiction (English)http://books.google.com/books/content?id=q-tKP...On A Train Journey Home To North India After L...2003.02.93324.00.0Mistaken Identity9788172235222 On A Train Journey Home To North...NaN
519397881730310148173031010Journey to the EastHermann HesseAdventure storieshttp://books.google.com/books/content?id=rq6JP...This book tells the tale of a man who goes on ...2002.03.70175.024.0Journey to the East9788173031014 This book tells the tale of a ma...NaN
51949788179921623817992162XThe Monk Who Sold His Ferrari: A Fable About F...Robin SharmaHealth & Fitnesshttp://books.google.com/books/content?id=c_7mf...Wisdom to Create a Life of Passion, Purpose, a...2003.03.82198.01568.0The Monk Who Sold His Ferrari: A Fable About F...9788179921623 Wisdom to Create a Life of Passi...NaN
519597881853005358185300534I Am thatSri Nisargadatta Maharaj;Sudhakar S. DikshitPhilosophyhttp://books.google.com/books/content?id=Fv_JP...This collection of the timeless teachings of o...1999.04.51531.0104.0I Am that: Talks with Sri Nisargadatta Maharaj9788185300535 This collection of the timeless ...Nonfiction
519697890277120599027712050The Berlin PhenomenologyGeorg Wilhelm Friedrich HegelHistoryhttp://books.google.com/books/content?id=Vy7Sk...Since the three volume edition ofHegel's Philo...1981.00.00210.00.0The Berlin Phenomenology9789027712059 Since the three volume edition o...Nonfiction
\n", "

5197 rows × 14 columns

\n", "
" ], "text/plain": [ " isbn13 isbn10 \\\n", "0 9780002005883 0002005883 \n", "1 9780002261982 0002261987 \n", "2 9780006178736 0006178731 \n", "3 9780006280897 0006280897 \n", "4 9780006280934 0006280935 \n", "... ... ... \n", "5192 9788172235222 8172235224 \n", "5193 9788173031014 8173031010 \n", "5194 9788179921623 817992162X \n", "5195 9788185300535 8185300534 \n", "5196 9789027712059 9027712050 \n", "\n", " title \\\n", "0 Gilead \n", "1 Spider's Web \n", "2 Rage of angels \n", "3 The Four Loves \n", "4 The Problem of Pain \n", "... ... \n", "5192 Mistaken Identity \n", "5193 Journey to the East \n", "5194 The Monk Who Sold His Ferrari: A Fable About F... \n", "5195 I Am that \n", "5196 The Berlin Phenomenology \n", "\n", " authors \\\n", "0 Marilynne Robinson \n", "1 Charles Osborne;Agatha Christie \n", "2 Sidney Sheldon \n", "3 Clive Staples Lewis \n", "4 Clive Staples Lewis \n", "... ... \n", "5192 Nayantara Sahgal \n", "5193 Hermann Hesse \n", "5194 Robin Sharma \n", "5195 Sri Nisargadatta Maharaj;Sudhakar S. Dikshit \n", "5196 Georg Wilhelm Friedrich Hegel \n", "\n", " categories \\\n", "0 Fiction \n", "1 Detective and mystery stories \n", "2 Fiction \n", "3 Christian life \n", "4 Christian life \n", "... ... \n", "5192 Indic fiction (English) \n", "5193 Adventure stories \n", "5194 Health & Fitness \n", "5195 Philosophy \n", "5196 History \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", "5192 http://books.google.com/books/content?id=q-tKP... \n", "5193 http://books.google.com/books/content?id=rq6JP... \n", "5194 http://books.google.com/books/content?id=c_7mf... \n", "5195 http://books.google.com/books/content?id=Fv_JP... \n", "5196 http://books.google.com/books/content?id=Vy7Sk... \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", "5192 On A Train Journey Home To North India After L... 2003.0 \n", "5193 This book tells the tale of a man who goes on ... 2002.0 \n", "5194 Wisdom to Create a Life of Passion, Purpose, a... 2003.0 \n", "5195 This collection of the timeless teachings of o... 1999.0 \n", "5196 Since the three volume edition ofHegel's Philo... 1981.0 \n", "\n", " average_rating num_pages ratings_count \\\n", "0 3.85 247.0 361.0 \n", "1 3.83 241.0 5164.0 \n", "2 3.93 512.0 29532.0 \n", "3 4.15 170.0 33684.0 \n", "4 4.09 176.0 37569.0 \n", "... ... ... ... \n", "5192 2.93 324.0 0.0 \n", "5193 3.70 175.0 24.0 \n", "5194 3.82 198.0 1568.0 \n", "5195 4.51 531.0 104.0 \n", "5196 0.00 210.0 0.0 \n", "\n", " title_and_subtitle \\\n", "0 Gilead \n", "1 Spider's Web: A Novel \n", "2 Rage of angels \n", "3 The Four Loves \n", "4 The Problem of Pain \n", "... ... \n", "5192 Mistaken Identity \n", "5193 Journey to the East \n", "5194 The Monk Who Sold His Ferrari: A Fable About F... \n", "5195 I Am that: Talks with Sri Nisargadatta Maharaj \n", "5196 The Berlin Phenomenology \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 \n", "... ... ... \n", "5192 9788172235222 On A Train Journey Home To North... NaN \n", "5193 9788173031014 This book tells the tale of a ma... NaN \n", "5194 9788179921623 Wisdom to Create a Life of Passi... NaN \n", "5195 9788185300535 This collection of the timeless ... Nonfiction \n", "5196 9789027712059 Since the three volume edition o... Nonfiction \n", "\n", "[5197 rows x 14 columns]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "books" ] }, { "cell_type": "code", "execution_count": 8, "id": "10c42e74", "metadata": {}, "outputs": [ { "data": { "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", "
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
.............................................
517897819336482791933648279Night Has a Thousand EyesCornell WoolrichFictionhttp://books.google.com/books/content?id=3Gk6s...\"Cornell Woolrich's novels define the essence ...2007.03.77344.0680.0Night Has a Thousand Eyes9781933648279 \"Cornell Woolrich's novels defin...Fiction
518897847700289694770028962Coin Locker Babies村上龍Fictionhttp://books.google.com/books/content?id=87DJw...Rescued from the lockers in which they were le...2002.03.75393.05560.0Coin Locker Babies9784770028969 Rescued from the lockers in whic...Fiction
518997881222008508122200850Cry, the PeacockAnita DesaiFictionhttp://books.google.com/books/content?id=_QKwV...This book is the story of a young girl obsesse...1980.03.22218.0134.0Cry, the Peacock9788122200850 This book is the story of a youn...Fiction
519597881853005358185300534I Am thatSri Nisargadatta Maharaj;Sudhakar S. DikshitPhilosophyhttp://books.google.com/books/content?id=Fv_JP...This collection of the timeless teachings of o...1999.04.51531.0104.0I Am that: Talks with Sri Nisargadatta Maharaj9788185300535 This collection of the timeless ...Nonfiction
519697890277120599027712050The Berlin PhenomenologyGeorg Wilhelm Friedrich HegelHistoryhttp://books.google.com/books/content?id=Vy7Sk...Since the three volume edition ofHegel's Philo...1981.00.00210.00.0The Berlin Phenomenology9789027712059 Since the three volume edition o...Nonfiction
\n", "

3743 rows × 14 columns

\n", "
" ], "text/plain": [ " isbn13 isbn10 title \\\n", "0 9780002005883 0002005883 Gilead \n", "2 9780006178736 0006178731 Rage of angels \n", "8 9780006482079 0006482074 Warhost of Vastmark \n", "30 9780006646006 000664600X Ocean Star Express \n", "46 9780007121014 0007121016 Taken at the Flood \n", "... ... ... ... \n", "5178 9781933648279 1933648279 Night Has a Thousand Eyes \n", "5188 9784770028969 4770028962 Coin Locker Babies \n", "5189 9788122200850 8122200850 Cry, the Peacock \n", "5195 9788185300535 8185300534 I Am that \n", "5196 9789027712059 9027712050 The Berlin Phenomenology \n", "\n", " authors categories \\\n", "0 Marilynne Robinson Fiction \n", "2 Sidney Sheldon Fiction \n", "8 Janny Wurts Fiction \n", "30 Mark Haddon;Peter Sutton Juvenile Fiction \n", "46 Agatha Christie Fiction \n", "... ... ... \n", "5178 Cornell Woolrich Fiction \n", "5188 村上龍 Fiction \n", "5189 Anita Desai Fiction \n", "5195 Sri Nisargadatta Maharaj;Sudhakar S. Dikshit Philosophy \n", "5196 Georg Wilhelm Friedrich Hegel History \n", "\n", " thumbnail \\\n", "0 http://books.google.com/books/content?id=KQZCP... \n", "2 http://books.google.com/books/content?id=FKo2T... \n", "8 http://books.google.com/books/content?id=uOL0f... \n", "30 http://books.google.com/books/content?id=I2QZA... \n", "46 http://books.google.com/books/content?id=3gWlx... \n", "... ... \n", "5178 http://books.google.com/books/content?id=3Gk6s... \n", "5188 http://books.google.com/books/content?id=87DJw... \n", "5189 http://books.google.com/books/content?id=_QKwV... \n", "5195 http://books.google.com/books/content?id=Fv_JP... \n", "5196 http://books.google.com/books/content?id=Vy7Sk... \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", "5178 \"Cornell Woolrich's novels define the essence ... 2007.0 \n", "5188 Rescued from the lockers in which they were le... 2002.0 \n", "5189 This book is the story of a young girl obsesse... 1980.0 \n", "5195 This collection of the timeless teachings of o... 1999.0 \n", "5196 Since the three volume edition ofHegel's Philo... 1981.0 \n", "\n", " average_rating num_pages ratings_count \\\n", "0 3.85 247.0 361.0 \n", "2 3.93 512.0 29532.0 \n", "8 4.03 522.0 2966.0 \n", "30 3.50 32.0 1.0 \n", "46 3.71 352.0 8852.0 \n", "... ... ... ... \n", "5178 3.77 344.0 680.0 \n", "5188 3.75 393.0 5560.0 \n", "5189 3.22 218.0 134.0 \n", "5195 4.51 531.0 104.0 \n", "5196 0.00 210.0 0.0 \n", "\n", " title_and_subtitle \\\n", "0 Gilead \n", "2 Rage of angels \n", "8 Warhost of Vastmark \n", "30 Ocean Star Express \n", "46 Taken at the Flood \n", "... ... \n", "5178 Night Has a Thousand Eyes \n", "5188 Coin Locker Babies \n", "5189 Cry, the Peacock \n", "5195 I Am that: Talks with Sri Nisargadatta Maharaj \n", "5196 The Berlin Phenomenology \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 \n", "... ... ... \n", "5178 9781933648279 \"Cornell Woolrich's novels defin... Fiction \n", "5188 9784770028969 Rescued from the lockers in whic... Fiction \n", "5189 9788122200850 This book is the story of a youn... Fiction \n", "5195 9788185300535 This collection of the timeless ... Nonfiction \n", "5196 9789027712059 Since the three volume edition o... Nonfiction \n", "\n", "[3743 rows x 14 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "books[~(books[\"simple_categories\"].isna())]" ] }, { "cell_type": "code", "execution_count": 9, "id": "b0d7c84d", "metadata": {}, "outputs": [], "source": [ "# Use a pipeline as a high-level helper\n", "\n", "# from transformers import pipeline\n", "# fiction_categories=[\"Fiction\",\"Nonfiction\"]\n", "# pipe = pipeline(\"zero-shot-classification\", model=\"facebook/bart-large-mnli\",device=getattr(__import__('torch'), 'cuda', None) is not None)" ] }, { "cell_type": "code", "execution_count": 10, "id": "e9dac519", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "c:\\Users\\KRISH\\miniconda3\\Lib\\site-packages\\tqdm\\auto.py:21: TqdmWarning: IProgress not found. Please update jupyter and ipywidgets. See https://ipywidgets.readthedocs.io/en/stable/user_install.html\n", " from .autonotebook import tqdm as notebook_tqdm\n", "Device set to use cuda:0\n" ] } ], "source": [ "# Use a pipeline as a high-level helper\n", "import torch\n", "import os\n", "os.environ[\"CUDA_VISIBLE_DEVICES\"] = \"0\" # before you create the pipeline\n", "from transformers import pipeline\n", "fiction_categories=[\"Fiction\",\"Nonfiction\"]\n", "pipe = pipeline(\"zero-shot-classification\", model=\"facebook/bart-large-mnli\",device=0 )" ] }, { "cell_type": "code", "execution_count": 11, "id": "687e2df9", "metadata": {}, "outputs": [], "source": [ "sequence=(books.loc[books[\"simple_categories\"]==\"Fiction\",\"description\"].reset_index(drop=True)[0])" ] }, { "cell_type": "code", "execution_count": 12, "id": "00a304a4", "metadata": {}, "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.8438262343406677, 0.15617379546165466]}" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pipe(sequence,fiction_categories)" ] }, { "cell_type": "code", "execution_count": 13, "id": "9b6d6d84", "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "max_index=np.argmax(pipe(sequence,fiction_categories))\n", "max_label=pipe(sequence,fiction_categories)[\"labels\"][max_index]" ] }, { "cell_type": "code", "execution_count": 14, "id": "a842ec71", "metadata": {}, "outputs": [], "source": [ "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" ] }, { "cell_type": "code", "execution_count": 15, "id": "a1404921", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ " 2%|▏ | 7/300 [00:02<01:27, 3.34it/s]You seem to be using the pipelines sequentially on GPU. In order to maximize efficiency please use a dataset\n", "100%|██████████| 300/300 [00:58<00:00, 5.09it/s]\n" ] } ], "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\"]\n" ] }, { "cell_type": "code", "execution_count": 16, "id": "4faae0cf", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "100%|██████████| 300/300 [00:57<00:00, 5.21it/s]\n" ] } ], "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\"]" ] }, { "cell_type": "code", "execution_count": 17, "id": "ed02fd8c", "metadata": {}, "outputs": [], "source": [ "predictions_df=pd.DataFrame({\"actual_categories\":actual_cats,\"predicted_categories\":predicted_cats})" ] }, { "cell_type": "code", "execution_count": 18, "id": "27270606", "metadata": {}, "outputs": [], "source": [ "predictions_df[\"correct_prediction\"]=(np.where(predictions_df[\"actual_categories\"]== predictions_df[\"predicted_categories\"],1,0))" ] }, { "cell_type": "code", "execution_count": 19, "id": "acad7b23", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0.775" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "predictions_df[\"correct_prediction\"].sum()/len(predictions_df)" ] }, { "cell_type": "code", "execution_count": 20, "id": "1a78bc73", "metadata": {}, "outputs": [], "source": [ "isbns=[]\n", "predicted_cats=[]\n", "\n", "missing_cats=books.loc[books[\"simple_categories\"].isna(),[\"isbn13\",\"description\"]].reset_index(drop=True)" ] }, { "cell_type": "code", "execution_count": 21, "id": "c7ec0905", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "100%|██████████| 1454/1454 [04:27<00:00, 5.44it/s]\n" ] } ], "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]]" ] }, { "cell_type": "code", "execution_count": 27, "id": "85cdf570", "metadata": {}, "outputs": [], "source": [ "missing_predicted_df=pd.DataFrame({\"isbn13\":isbns,\"predicted_categories\":predicted_cats})" ] }, { "cell_type": "code", "execution_count": 28, "id": "0640e87e", "metadata": {}, "outputs": [ { "data": { "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
.........
14499788125026600Nonfiction
14509788171565641Fiction
14519788172235222Fiction
14529788173031014Nonfiction
14539788179921623Fiction
\n", "

1454 rows × 2 columns

\n", "
" ], "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", "1449 9788125026600 Nonfiction\n", "1450 9788171565641 Fiction\n", "1451 9788172235222 Fiction\n", "1452 9788173031014 Nonfiction\n", "1453 9788179921623 Fiction\n", "\n", "[1454 rows x 2 columns]" ] }, "execution_count": 28, "metadata": {}, "output_type": "execute_result" } ], "source": [ "missing_predicted_df" ] }, { "cell_type": "code", "execution_count": 29, "id": "bb0dfc33", "metadata": {}, "outputs": [], "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\"])" ] }, { "cell_type": "code", "execution_count": 31, "id": "cb04bb3e", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", "RangeIndex: 5197 entries, 0 to 5196\n", "Data columns (total 14 columns):\n", " # Column Non-Null Count Dtype \n", "--- ------ -------------- ----- \n", " 0 isbn13 5197 non-null int64 \n", " 1 isbn10 5197 non-null object \n", " 2 title 5197 non-null object \n", " 3 authors 5165 non-null object \n", " 4 categories 5167 non-null object \n", " 5 thumbnail 5031 non-null object \n", " 6 description 5197 non-null object \n", " 7 published_year 5197 non-null float64\n", " 8 average_rating 5197 non-null float64\n", " 9 num_pages 5197 non-null float64\n", " 10 ratings_count 5197 non-null float64\n", " 11 title_and_subtitle 5197 non-null object \n", " 12 tagged_description 5197 non-null object \n", " 13 simple_categories 5197 non-null object \n", "dtypes: float64(4), int64(1), object(9)\n", "memory usage: 568.6+ KB\n" ] } ], "source": [ "books.info()" ] }, { "cell_type": "code", "execution_count": 32, "id": "dd95344e", "metadata": {}, "outputs": [ { "data": { "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", "
isbn13isbn10titleauthorscategoriesthumbnaildescriptionpublished_yearaverage_ratingnum_pagesratings_counttitle_and_subtitletagged_descriptionsimple_categories
2497800065130870006513085GravityTess 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
47597800994103550099410354TraitorMatthew 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
47897800994223410099422344Yeats 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
49197800994467290099446723Blackwood 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
109097802611024220261102427The 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
143597803408379550340837950Stranger 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
143997803452512200345251229Visions 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
284597805750755970575075597ReplayKen 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
286097805902547620590254766The 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
328897807394238510739423851Wizard'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
328997807394397080739439707Time QuartetMadeleine L'EngleScience fictionNaNBlending magic with quantum physics, Madeleine...2003.04.35646.0165.0Time Quartet9780739439708 Blending magic with quantum phys...Fiction
35639780760728505076072850X20,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
448397814165020431416502041The 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
497997818414940811841494089The 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
50409781857231359185723135XUse 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
505797818579893421857989341The 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", "
" ], "text/plain": [ " isbn13 isbn10 title \\\n", "24 9780006513087 0006513085 Gravity \n", "475 9780099410355 0099410354 Traitor \n", "478 9780099422341 0099422344 Yeats is Dead! \n", "491 9780099446729 0099446723 Blackwood Farm \n", "1090 9780261102422 0261102427 The Silmarillion \n", "1435 9780340837955 0340837950 Stranger in a Strange Land \n", "1439 9780345251220 0345251229 Visions from Nowhere \n", "2845 9780575075597 0575075597 Replay \n", "2860 9780590254762 0590254766 The lion, the witch and the wardrobe \n", "3288 9780739423851 0739423851 Wizard's Castle \n", "3289 9780739439708 0739439707 Time Quartet \n", "3563 9780760728505 076072850X 20,000 Leagues Under the Sea \n", "4483 9781416502043 1416502041 The Voyage of the Jerle Shannara Trilogy \n", "4979 9781841494081 1841494089 The Darkness that Comes Before \n", "5040 9781857231359 185723135X Use of Weapons \n", "5057 9781857989342 1857989341 The Gods Themselves \n", "\n", " authors categories \\\n", "24 Tess Gerritsen Science fiction \n", "475 Matthew Woodring Stover Science fiction \n", "478 Joseph O'Connor Comedy \n", "491 Anne Rice Horror \n", "1090 John Ronald Reuel Tolkien Fantasy \n", "1435 Robert A. Heinlein Science fiction \n", "1439 William Arrow Science fiction \n", "2845 Ken Grimwood Fantasy \n", "2860 Clive Staples Lewis Fantasy \n", "3288 Diana Wynne Jones Fantasy \n", "3289 Madeleine L'Engle Science fiction \n", "3563 Jules Verne Science fiction \n", "4483 Terry Brooks Fantasy \n", "4979 R. Scott Bakker Fantasy \n", "5040 Iain Banks Science fiction \n", "5057 Isaac Asimov Science fiction \n", "\n", " thumbnail \\\n", "24 http://books.google.com/books/content?id=KI66c... \n", "475 http://books.google.com/books/content?id=VbICO... \n", "478 http://books.google.com/books/content?id=DrE3I... \n", "491 http://books.google.com/books/content?id=cIn8T... \n", "1090 http://books.google.com/books/content?id=22ePu... \n", "1435 http://books.google.com/books/content?id=ZQhiP... \n", "1439 NaN \n", "2845 http://books.google.com/books/content?id=9vmNP... \n", "2860 NaN \n", "3288 http://books.google.com/books/content?id=hB7hA... \n", "3289 NaN \n", "3563 NaN \n", "4483 http://books.google.com/books/content?id=jqVsA... \n", "4979 http://books.google.com/books/content?id=BG8qG... \n", "5040 NaN \n", "5057 http://books.google.com/books/content?id=8ClIP... \n", "\n", " description published_year \\\n", "24 Emma Watson a research physician has been trai... 2004.0 \n", "475 From the depths of catastrophe, a glimmer of h... 2002.0 \n", "478 In aid of Amnesty International, this is a bri... 2002.0 \n", "491 Lestat Is Back, Saviour And Demon, Presiding O... 2003.0 \n", "1090 Tolkien's Silmarillion is the core work of the... 1999.0 \n", "1435 Epic, entertaining, Stranger in a Strange Land... 2005.0 \n", "1439 The first novel in the series, \"Return to the ... 1976.0 \n", "2845 At forty-three Jeff Winston is tired of his lo... 2005.0 \n", "2860 Four English school children enter the magic l... 1995.0 \n", "3288 Howl's moving castle - Eldest of three sisters... 2002.0 \n", "3289 Blending magic with quantum physics, Madeleine... 2003.0 \n", "3563 Retells the adventures of a French professor a... 2002.0 \n", "4483 When the body of a half-drowned elf is found f... 2004.0 \n", "4979 A score of centuries has passed since the Firs... 2005.0 \n", "5040 The man known as Cheradenine Zakalwe was one o... 1992.0 \n", "5057 In the year 2100, mankind on Earth, settlers i... 2000.0 \n", "\n", " average_rating num_pages ratings_count \\\n", "24 4.04 342.0 8024.0 \n", "475 4.00 320.0 6765.0 \n", "478 3.39 298.0 34.0 \n", "491 3.86 774.0 26145.0 \n", "1090 3.91 384.0 253.0 \n", "1435 3.92 672.0 563.0 \n", "1439 3.23 183.0 10.0 \n", "2845 4.16 272.0 412.0 \n", "2860 4.21 189.0 860.0 \n", "3288 4.44 376.0 439.0 \n", "3289 4.35 646.0 165.0 \n", "3563 3.88 394.0 135778.0 \n", "4483 4.26 1260.0 84.0 \n", "4979 3.79 638.0 317.0 \n", "5040 4.19 411.0 30779.0 \n", "5057 4.09 288.0 41304.0 \n", "\n", " title_and_subtitle \\\n", "24 Gravity \n", "475 Traitor \n", "478 Yeats is Dead!: A Novel by Fifteen Irish Writers \n", "491 Blackwood Farm \n", "1090 The Silmarillion \n", "1435 Stranger in a Strange Land \n", "1439 Visions from Nowhere \n", "2845 Replay \n", "2860 The lion, the witch and the wardrobe \n", "3288 Wizard's Castle \n", "3289 Time Quartet \n", "3563 20,000 Leagues Under the Sea \n", "4483 The Voyage of the Jerle Shannara Trilogy \n", "4979 The Darkness that Comes Before \n", "5040 Use of Weapons \n", "5057 The Gods Themselves \n", "\n", " tagged_description simple_categories \n", "24 9780006513087 Emma Watson a research physician... Nonfiction \n", "475 9780099410355 From the depths of catastrophe, ... Fiction \n", "478 9780099422341 In aid of Amnesty International,... Fiction \n", "491 9780099446729 Lestat Is Back, Saviour And Demo... Fiction \n", "1090 9780261102422 Tolkien's Silmarillion is the co... Fiction \n", "1435 9780340837955 Epic, entertaining, Stranger in ... Fiction \n", "1439 9780345251220 The first novel in the series, \"... Fiction \n", "2845 9780575075597 At forty-three Jeff Winston is t... Fiction \n", "2860 9780590254762 Four English school children ent... Nonfiction \n", "3288 9780739423851 Howl's moving castle - Eldest of... Fiction \n", "3289 9780739439708 Blending magic with quantum phys... Fiction \n", "3563 9780760728505 Retells the adventures of a Fren... Fiction \n", "4483 9781416502043 When the body of a half-drowned ... Fiction \n", "4979 9781841494081 A score of centuries has passed ... Nonfiction \n", "5040 9781857231359 The man known as Cheradenine Zak... Nonfiction \n", "5057 9781857989342 In the year 2100, mankind on Ear... Fiction " ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "books[books[\"categories\"].str.lower().isin([\n", " \"romance\",\n", " \"science fiction\",\n", " \"fantasy\",\n", " \"mystery\",\n", " \"thriller\",\n", " \"horror\",\n", " \"scifi\",\n", " \"comedy\",\n", " \"crime\",\n", " \"historical\"\n", "])]" ] }, { "cell_type": "code", "execution_count": 33, "id": "2e9a8477", "metadata": {}, "outputs": [], "source": [ "books.to_csv(\"books_with_categories.csv\",index=False)" ] }, { "cell_type": "code", "execution_count": null, "id": "6d4ef731", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "base", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.12.3" } }, "nbformat": 4, "nbformat_minor": 5 }