7739 zilli dr tracy ca

Write A Python Code On The Anaconda Navigator

Resource Information
In this assignment, you should work with books.csv file. This file contains the detailed information about books scraped via the Goodreads . The dataset is downloaded from Kaggle website: https://www.kaggle.com/jealousleopard/goodreadsbooks/downloads/goodreadsbooks.zip/6

Each row in the file includes ten columns. Detailed description for each column is provided in the following:

bookID: A unique Identification number for each book.
title: The name under which the book was published.
authors: Names of the authors of the book. Multiple authors are delimited with -.
average_rating: The average rating of the book received in total.
isbn: Another unique number to identify the book, the International Standard Book Number.
isbn13: A 13-digit ISBN to identify the book, instead of the standard 11-digit ISBN.
language_code: Helps understand what is the primary language of the book.
num_pages: Number of pages the book contains.
ratings_count: Total number of ratings the book received.
text_reviews_count: Total number of written text reviews the book received.
Task
Write the following codes:
Use pandas to read the file as a dataframe (named as books). bookIDcolumn should be the index of the dataframe.
Use books.head() to see the first 5 rows of the dataframe.
Use book.shape to find the number of rows and columns in the dataframe.
Use books.describe() to summarize the data.
Use books['authors'].describe() to find about number of unique authors in the dataset and also most frequent author.
Use OLS regression to test if average rating of a book is dependent to number of pages, number of ratings, and total number of written text reviews the book received.
Summarize your findings in a Word file.
Instructions
Please follow these directions carefully.
Please type your codes in a Jupyter Network file and your summary in a word document named as follows:
HW6YourFirstNameYourLastName.

bookID,title,authors,average_rating,isbn,isbn13,language_code,num_pages,ratings_count,text_reviews_count 1,Harry Potter and the Half-Blood Prince (Harry Potter #6),J.K. Rowling-Mary GrandPré,4.56,439785960,9.78E+12,eng,652,1944099,26249 2,Harry Potter and the Order of the Phoenix (Harry Potter #5),J.K. Rowling-Mary GrandPré,4.49,439358078,9.78E+12,eng,870,1996446,27613 3,Harry Potter and the Sorcerer's Stone (Harry Potter #1),J.K. Rowling-Mary GrandPré,4.47,439554934,9.78E+12,eng,320,5629932,70390 4,Harry Potter and the Chamber of Secrets (Harry Potter #2),J.K. Rowling,4.41,439554896,9.78E+12,eng,352,6267,272 5,Harry Potter and the Prisoner of Azkaban (Harry Potter #3),J.K. Rowling-Mary GrandPré,4.55,043965548X,9.78E+12,eng,435,2149872,33964 8,Harry Potter Boxed Set Books 1-5 (Harry Potter #1-5),J.K. Rowling-Mary GrandPré,4.78,439682584,9.78E+12,eng,2690,38872,154 9,"Unauthorized Harry Potter Book Seven News: ""Half-Blood Prince"" Analysis and Speculation",W. Frederick Zimmerman,3.69,976540606,9.78E+12,en-US,152,18,1 10,Harry Potter Collection (Harry Potter #1-6),J.K. Rowling,4.73,439827604,9.78E+12,eng,3342,27410,820 12,The Ultimate Hitchhiker's Guide: Five Complete Novels and One Story (Hitchhiker's Guide to the Galaxy #1-5),Douglas Adams,4.38,517226952,9.78E+12,eng,815,3602,258 13,The Ultimate Hitchhiker's Guide to the Galaxy,Douglas Adams,4.38,345453743,9.78E+12,eng,815,240189,3954 14,The Hitchhiker's Guide to the Galaxy (Hitchhiker's Guide to the Galaxy #1),Douglas Adams,4.22,1400052920,9.78E+12,eng,215,4416,408 16,The Hitchhiker's Guide to the Galaxy (Hitchhiker's Guide to the Galaxy #1),Douglas Adams-Stephen Fry,4.22,739322206,9.78E+12,eng,6,1222,253 18,The Ultimate Hitchhiker's Guide (Hitchhiker's Guide to the Galaxy #1-5),Douglas Adams,4.38,517149257,9.78E+12,en-US,815,2801,192 21,A Short History of Nearly Everything,Bill Bryson-William Roberts,4.2,076790818X,9.78E+12,eng,544,228522,8840 22,Bill Bryson's African Diary,Bill Bryson,3.43,767915062,9.78E+12,eng,55,6993,470 23,Bryson's Dictionary of Troublesome Words: A Writer's Guide to Getting It Right,Bill Bryson,3.88,767910435,9.78E+12,eng,256,2020,124 24,In a Sunburned Country,Bill Bryson,4.07,767903862,9.78E+12,eng,335,68213,4077 25,I'm a Stranger Here Myself: Notes on Returning to America After Twenty Years Away,Bill Bryson,3.9,076790382X,9.78E+12,eng,304,47490,2153 26,The Lost Continent: Travels in Small Town America,Bill Bryson,3.83,60920084,9.78E+12,en-US,299,43779,2146 27,Neither Here nor There: Travels in Europe,Bill Bryson,3.87,380713802,9.78E+12,eng,254,46397,2127 28,Notes from a Small Island,Bill Bryson,3.92,380727501,9.78E+12,eng,324,76476,3159 29,The Mother Tongue: English and How It Got That Way,Bill Bryson,3.94,380715430,9.78E+12,eng,270,26672,1986 30,J.R.R. Tolkien 4-Book Boxed Set: The Hobbit and The Lord of the Rings,J.R.R. Tolkien,4.59,345538374,9.78E+12,eng,1728,97731,1536 31,The Lord of the Rings (The Lord of the Rings #1-3),J.R.R. Tolkien,4.49,618517650,9.78E+12,eng,1184,1670,91 32,The Lord of the Rings (The Lord of the Rings #1-3),J.R.R. Tolkien,4.49,618346244,9.78E+12,eng,1137,2819,139 34,The Fellowship of the Ring (The Lord of the Rings #1),J.R.R. Tolkien,4.35,618346252,9.78E+12,eng,398,2009749,12784 35,The Lord of the Rings (The Lord of the Rings #1-3),J.R.R. Tolkien-Alan Lee,4.49,618260587,9.78E+12,en-US,1216,1606,139 36,The Lord of the Rings: Weapons and Warfare,Chris Smith-Christopher Lee-Richard Taylor,4.53,618391002,9.78E+12,eng,218,18934,43 37,The Lord of the Rings: Complete Visual Companion,Jude Fisher,4.5,618510826,9.78E+12,eng,224,343,6 38,The Lord of the Rings Box Set,J.R.R. Tolkien,4.49,618153977,9.78E+12,eng,1223,216,19 40,Cooking with Fernet Branca (Gerald Samper #1),James Hamilton-Paterson,3.61,193337201X,9.78E+12,eng,288,1214,202 45,Agile Web Development with Rails: A Pragmatic Guide,Dave Thomas-David Heinemeier Hansson-Leon Breedt-Mike Clark-Thomas Fuchs-Andreas Schwarz,3.89,097669400X,9.78E+12,eng,558,1269,59 50,Hatchet,Gary Paulsen,3.7,689840926,9.78E+12,eng,208,254827,11346 51,"Hatchet: A Guide for Using ""Hatchet"" in the Classroom",Donna Ickes-Edward Sciranko-Keith Vasconcelles,3.97,1557344493,9.78E+12,eng,48,35,2 53,Guts: The True Stories behind Hatchet and the Brian Books,Gary Paulsen,3.87,385326505,9.78E+12,eng,144,1996,326 54,Molly Hatchet - 5 of the Best,Molly Hatchet,4.33,1575606240,9.78E+12,eng,56,6,0 55,Hatchet Jobs: Writings on Contemporary Fiction,Dale Peck,3.48,1595580271,9.78E+12,en-US,228,99,16 57,A Changeling for All Seasons (Changeling Seasons #1),Angela Knight-Sahara Kelly-Judy Mays-Marteeka Karland-Kate Douglas-Shelby Morgen-Lacey Savage-Kate Hill-Willa Okati,3.75,1595962808,9.78E+12,eng,304,167,4 58,Changeling (Changeling #1),Delia Sherman,3.6,670059676,9.78E+12,eng,256,957,112 59,The Changeling Sea,Patricia A. McKillip,4.07,141312629,9.78E+12,eng,137,4319,289 61,The Changeling,Zilpha Keatley Snyder,4.17,595321801,9.78E+12,eng,228,1155,92 63,The Changeling,Kate Horsley,3.56,1590301943,9.78E+12,eng,339,295,42 66,The Changeling (Daughters of England #15),Philippa Carr,3.99,449146979,9.78E+12,eng,369,341,12 67,The Known World,Edward P. Jones,3.83,61159174,9.78E+12,eng,388,28962,2576 68,The Known World,Edward P. Jones-Kevin R. Free,3.83,006076273X,9.78E+12,en-US,14,50,12 69,The Known World,Edward P. Jones,3.83,60749911,9.78E+12,eng,576,22,3 71,Traders Guns & Money: Knowns and Unknowns in the Dazzling World of Derivatives,Satyajit