COP3076_F22_A01_TashiDillon

import pandas as pd books=pd.read_csv("/work/bestsellers with categories.csv") books.head()

Nameobject

Authorobject

10-Day Green Smoothie Cleanse

JJ Smith

11/22/63: A Novel

Stephen King

12 Rules for Life: An Antidote to Chaos

Jordan B. Peterson

1984 (Signet Classics)

George Orwell

5,000 Awesome Facts (About Everything!) (National Geographic Kids)

National Geographic Kids

#A: Altering Row Names books.set_index("Author")

Nameobject

Publication Manual of the American Psychological Association, 6th Edition1.8%

StrengthsFinder 2.01.6%

349 others96.5%

User Ratingfloat64

3.3 - 4.9

JJ Smith

10-Day Green Smoothie Cleanse

4.7

Stephen King

11/22/63: A Novel

4.6

Jordan B. Peterson

12 Rules for Life: An Antidote to Chaos

4.7

George Orwell

1984 (Signet Classics)

4.7

National Geographic Kids

5,000 Awesome Facts (About Everything!) (National Geographic Kids)

4.8

George R. R. Martin

A Dance with Dragons (A Song of Ice and Fire)

4.4

George R. R. Martin

A Game of Thrones / A Clash of Kings / A Storm of Swords / A Feast of Crows / A Dance with Dragons

4.7

Amor Towles

A Gentleman in Moscow: A Novel

4.7

James Comey

A Higher Loyalty: Truth, Lies, and Leadership

4.7

Fredrik Backman

A Man Called Ove: A Novel

4.6

#a. altering rows or columns #modifying the code to only select author and year as columns with name as index books_transpose = books.set_index('Name')[['Year', 'Author']] books_transpose.head()

Yearint64

Authorobject

10-Day Green Smoothie Cleanse

2016

JJ Smith

11/22/63: A Novel

2011

Stephen King

12 Rules for Life: An Antidote to Chaos

2018

Jordan B. Peterson

1984 (Signet Classics)

2017

George Orwell

5,000 Awesome Facts (About Everything!) (National Geographic Kids)

2019

National Geographic Kids

#a continued: switching rows and columns using tranpose books_transpose = books.set_index('Name')[['Year', 'Author']].transpose() # Print the new code print(books_transpose)

Name   10-Day Green Smoothie Cleanse 11/22/63: A Novel  \
Year                            2016              2011   
Author                      JJ Smith      Stephen King   

Name   12 Rules for Life: An Antidote to Chaos 1984 (Signet Classics)  \
Year                                      2018                   2017   
Author                      Jordan B. Peterson          George Orwell   

Name   5,000 Awesome Facts (About Everything!) (National Geographic Kids)  \
Year                                                 2019                   
Author                           National Geographic Kids                   

Name   A Dance with Dragons (A Song of Ice and Fire)  \
Year                                            2011   
Author                           George R. R. Martin   

Name   A Game of Thrones / A Clash of Kings / A Storm of Swords / A Feast of Crows / A Dance with Dragons  \
Year                                                 2014                                                   
Author                                George R. R. Martin                                                   

Name   A Gentleman in Moscow: A Novel  \
Year                             2017   
Author                    Amor Towles   

Name   A Higher Loyalty: Truth, Lies, and Leadership  \
Year                                            2018   
Author                                   James Comey   

Name   A Man Called Ove: A Novel  ...         Wonder         Wonder  \
Year                        2016  ...           2013           2014   
Author           Fredrik Backman  ...  R. J. Palacio  R. J. Palacio   

Name           Wonder         Wonder         Wonder  \
Year             2015           2016           2017   
Author  R. J. Palacio  R. J. Palacio  R. J. Palacio   

Name   Wrecking Ball (Diary of a Wimpy Kid Book 14)  \
Year                                           2019   
Author                                  Jeff Kinney   

Name   You Are a Badass: How to Stop Doubting Your Greatness and Start Living an Awesome Life  \
Year                                                 2016                                       
Author                                        Jen Sincero                                       

Name   You Are a Badass: How to Stop Doubting Your Greatness and Start Living an Awesome Life  \
Year                                                 2017                                       
Author                                        Jen Sincero                                       

Name   You Are a Badass: How to Stop Doubting Your Greatness and Start Living an Awesome Life  \
Year                                                 2018                                       
Author                                        Jen Sincero                                       

Name   You Are a Badass: How to Stop Doubting Your Greatness and Start Living an Awesome Life  
Year                                                 2019                                      
Author                                        Jen Sincero                                      

[2 rows x 550 columns]

#b: using pivot table or groupby # Use pivot table to get all user ratings by year and author books_pivot_table = books.pivot_table (index='Year', columns='Author', aggfunc='mean') books_pivot_table.head()

Price Abraham Verghesefloat64

Price Adam Gasiewskifloat64

2009

nan

2010

11.0

nan

2011

11.0

nan

2012

nan

2013

nan

#B Ex 2 GroupBy #display the count of the number of books for each author books.groupby('Author').Price.count()

#c Applying functions to entire dataset or columns #print the most expensive book and the author based on the author books[['Author', 'Price']][books.Price==books['Price'].max()]

Authorobject

Priceint64

American Psychiatric Association

105

American Psychiatric Association

105

#C Ex 2: Applying mean function to data to get average price by author as index and genre as columns books_pivot_table=books.pivot_table(index='Author', columns='Genre', aggfunc='mean') print(books_pivot_table)

                             Price              Reviews                \
Genre                      Fiction Non Fiction  Fiction   Non Fiction   
Author                                                                  
Abraham Verghese              11.0         NaN   4866.0           NaN   
Adam Gasiewski                 NaN    6.000000      NaN   3113.000000   
Adam Mansbach                  9.0         NaN   9568.0           NaN   
Adir Levy                     13.0         NaN   8170.0           NaN   
Admiral William H. McRaven     NaN   11.000000      NaN  10199.000000   
...                            ...         ...      ...           ...   
Walter Isaacson                NaN   20.333333      NaN   6222.666667   
William Davis                  NaN    6.000000      NaN   7497.000000   
William P. Young               8.0         NaN  19720.0           NaN   
Wizards RPG Team              27.0         NaN  16990.0           NaN   
Zhi Gang Sha                   NaN   11.500000      NaN    128.500000   

                           User Rating                Year               
Genre                          Fiction Non Fiction Fiction  Non Fiction  
Author                                                                   
Abraham Verghese                   4.6         NaN  2010.5          NaN  
Adam Gasiewski                     NaN    4.400000     NaN  2017.000000  
Adam Mansbach                      4.8         NaN  2011.0          NaN  
Adir Levy                          4.8         NaN  2019.0          NaN  
Admiral William H. McRaven         NaN    4.700000     NaN  2017.000000  
...                                ...         ...     ...          ...  
Walter Isaacson                    NaN    4.566667     NaN  2013.333333  
William Davis                      NaN    4.400000     NaN  2012.500000  
William P. Young                   4.6         NaN  2013.0          NaN  
Wizards RPG Team                   4.8         NaN  2018.0          NaN  
Zhi Gang Sha                       NaN    4.600000     NaN  2011.000000  

[248 rows x 8 columns]

#d: creating new column 'rate_number' based off existing one books_rating=books.melt(id_vars=['Name', 'Author'], value_vars=['User Rating', 'Reviews'], var_name='feature', value_name='rate_number') books_rating.head()

Nameobject

Authorobject

10-Day Green Smoothie Cleanse

JJ Smith

11/22/63: A Novel

Stephen King

12 Rules for Life: An Antidote to Chaos

Jordan B. Peterson

1984 (Signet Classics)

George Orwell

5,000 Awesome Facts (About Everything!) (National Geographic Kids)

National Geographic Kids

#D Ex2 books['yearlyrate']=books['Year']/ books['User Rating'] books[['yearlyrate', 'Year', 'User Rating']].head()

yearlyratefloat64

Yearint64

428.93617021276594

2016

437.1739130434783

2011

429.36170212765956

2018

429.1489361702128

2017

420.625

2019

#e: descriptive stats books.describe()

User Ratingfloat64

Reviewsfloat64

count

550.0

mean

4.618363636363637

11953.281818181818

std

0.2269803650251963

11731.132017431892

min

3.3

37.0

25%

4.5

4058.0

50%

4.7

8580.0

75%

4.8

17253.25

max

4.9

87841.0

#e books.describe(include='object')

Nameobject

Authorobject

count

550

unique

351

248

top

Publication Manual of the American Psychological Association, 6th Edition

Jeff Kinney

freq