{"id":53588,"date":"2022-04-18T07:34:58","date_gmt":"2022-04-18T07:34:58","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/write-a-python-code-on-the-anaconda-navigator\/"},"modified":"2022-04-18T07:34:58","modified_gmt":"2022-04-18T07:34:58","slug":"write-a-python-code-on-the-anaconda-navigator","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/write-a-python-code-on-the-anaconda-navigator\/","title":{"rendered":"Write a python code on the anaconda navigator"},"content":{"rendered":"
\n

Resource Information<\/strong><\/h3>\n

In this assignment, you should work with books.csv<\/a> 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<\/a><\/p>\n

Each row in the file includes ten columns. Detailed description for each column is provided in the following:<\/p>\n

    \n
  1. bookID<\/strong>: A unique Identification number for each book.<\/li>\n
  2. title<\/strong>: The name under which the book was published.<\/li>\n
  3. authors<\/strong>: Names of the authors of the book. Multiple authors are delimited with -.<\/li>\n
  4. average_rating<\/strong>: The average rating of the book received in total.<\/li>\n
  5. isbn<\/strong>: Another unique number to identify the book, the International Standard Book Number.<\/li>\n
  6. isbn13<\/strong>: A 13-digit ISBN to identify the book, instead of the standard 11-digit ISBN.<\/li>\n
  7. language_code<\/strong>: Helps understand what is the primary language of the book.\u00a0<\/li>\n
  8. num_pages<\/strong>: Number of pages the book contains.<\/li>\n
  9. ratings_count<\/strong>: Total number of ratings the book received.<\/li>\n
  10. text_reviews_count<\/strong>: Total number of written text reviews the book received.<\/li>\n<\/ol>\n

    Task<\/strong><\/h3>\n
      \n
    1. Write the following codes:\n
        \n
      1. Use pandas to read the file as a dataframe (named as books). bookID<\/strong>column should be the index of the dataframe.<\/li>\n
      2. Use books.head() to see the first 5 rows of the dataframe.<\/li>\n
      3. Use book.shape to find the number of rows and columns in the dataframe.<\/li>\n
      4. Use books.describe() to summarize the data.<\/li>\n
      5. Use books[‘authors’].describe() to find about number of unique authors in the dataset and also most frequent author.<\/li>\n
      6. 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.<\/li>\n<\/ol>\n<\/li>\n
      7. Summarize your findings in a Word file.<\/li>\n<\/ol>\n

        Instructions<\/strong><\/h3>\n

        Please follow these directions carefully.<\/strong><\/h4>\n
          \n
        1. Please type your codes in a Jupyter Network file and your summary in a word document named as follows:
          HW6YourFirstNameYourLastName.<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

          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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-53588","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/53588","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=53588"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/53588\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=53588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=53588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=53588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}