Project 2 - Preparing different datasets
Load Libraries
library(dplyr)##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionlibrary(tidyr)
library(ggplot2)
library(knitr)## Warning: package 'knitr' was built under R version 3.5.3Data Set 1
Topic: Avocado Prices
Posted by: Samriti Malhotra
URL: http://www.hassavocadoboard.com/retail/volume-and-price-data
Create a .CSV file and Read .CSV into R
I combined both Conventional and Organic 2018 tables into one table.
## ï..Type Date AveragePrice Total.Volume X4046 X4225
## 1 Conventional 2018-12-02 1.22 27652426 9516477 7462866
## 2 Conventional 2018-11-25 1.25 21855494 7140335 6021450
## 3 Conventional 2018-11-18 1.14 29871135 9719229 7271528
## 4 Conventional 2018-11-11 1.00 39042283 13355864 10385141
## 5 Conventional 2018-11-04 1.01 38363283 12420772 10192035
## 6 Conventional 2018-10-28 1.01 39402227 12142265 10845124
## X4770 Total.Bags Small.Bags Large.Bags XLarge.Bags
## 1 521910.0 10151173 7174281 2895343 81547.92
## 2 402865.8 8290842 6016143 2183011 91688.68
## 3 497404.3 12382973 9174635 3103023 105315.78
## 4 603032.8 14698246 10721367 3865596 111282.12
## 5 528277.9 15222197 10602849 4538743 80604.81
## 6 549490.8 15865346 11437563 4320345 107438.89avocadoprices<-read.csv("https://raw.githubusercontent.com/IsARam/DATA607/master/avocado.csv",sep=",")
head(avocadoprices)Tidy Data
I am using tidyr to tidy data.
Rename Column Names
I wanted to rename columns names to make the table more readable.
colnames(avocadoprices)## [1] "ï..Type" "Date" "AveragePrice" "Total.Volume"
## [5] "X4046" "X4225" "X4770" "Total.Bags"
## [9] "Small.Bags" "Large.Bags" "XLarge.Bags"colnames(avocadoprices)<- c("Type", "Date", "AveragePrice","TotalVolume","Product4046", "Product4225" , "Product4770", "TotalBags", "SmallBags","LargeBags","XLargeBags")
head(avocadoprices)## Type Date AveragePrice TotalVolume Product4046 Product4225
## 1 Conventional 2018-12-02 1.22 27652426 9516477 7462866
## 2 Conventional 2018-11-25 1.25 21855494 7140335 6021450
## 3 Conventional 2018-11-18 1.14 29871135 9719229 7271528
## 4 Conventional 2018-11-11 1.00 39042283 13355864 10385141
## 5 Conventional 2018-11-04 1.01 38363283 12420772 10192035
## 6 Conventional 2018-10-28 1.01 39402227 12142265 10845124
## Product4770 TotalBags SmallBags LargeBags XLargeBags
## 1 521910.0 10151173 7174281 2895343 81547.92
## 2 402865.8 8290842 6016143 2183011 91688.68
## 3 497404.3 12382973 9174635 3103023 105315.78
## 4 603032.8 14698246 10721367 3865596 111282.12
## 5 528277.9 15222197 10602849 4538743 80604.81
## 6 549490.8 15865346 11437563 4320345 107438.89Gather Data
I wanted to create a column for volume type. A common problem is a dataset where some of the column names are not names of variables, but values of a variable.
avocadoprices<-avocadoprices %>% gather("Product4046","Product4225","Product4770", "TotalBags", "SmallBags","LargeBags","XLargeBags", key="VolumeType", value = "Volume")
head(avocadoprices)## Type Date AveragePrice TotalVolume VolumeType Volume
## 1 Conventional 2018-12-02 1.22 27652426 Product4046 9516477
## 2 Conventional 2018-11-25 1.25 21855494 Product4046 7140335
## 3 Conventional 2018-11-18 1.14 29871135 Product4046 9719229
## 4 Conventional 2018-11-11 1.00 39042283 Product4046 13355864
## 5 Conventional 2018-11-04 1.01 38363283 Product4046 12420772
## 6 Conventional 2018-10-28 1.01 39402227 Product4046 12142265Seperate Data
I wanted to distinguish the Date Column primarily summarizing within the month.
avocadoprices<-avocadoprices %>% separate(Date, into = c("Year","Month","Date"), sep="-")
head(avocadoprices)Data Transformation
I am using dplyr to transform data.
Descriptive Statistics
summary(avocadoprices)## Type Date AveragePrice TotalVolume
## Conventional:308 2018-01-07: 14 Min. :0.870 Min. : 1160388
## Organic :308 2018-01-14: 14 1st Qu.:1.070 1st Qu.: 1559103
## 2018-01-21: 14 Median :1.350 Median :11985035
## 2018-01-28: 14 Mean :1.321 Mean :21314346
## 2018-02-04: 14 3rd Qu.:1.550 3rd Qu.:40737103
## 2018-02-11: 14 Max. :1.710 Max. :63716144
## (Other) :532
## VolumeType Volume
## Length:616 Min. : 0
## Class :character 1st Qu.: 188822
## Mode :character Median : 816982
## Mean : 4193917
## 3rd Qu.: 9886183
## Max. :21625373
## Analysis
Which Avocado type has the highest total volume, conventional or organic?
Conventional Avocado's has a higher Total Volume over Organic.avocadobytype<-
avocadoprices %>%
group_by(Type) %>%
summarize(TotalVolume = sum(TotalVolume))
avocadobytype## # A tibble: 2 x 2
## Type TotalVolume
## <fct> <dbl>
## 1 Conventional 12645931337.
## 2 Organic 483705819.ggplot(avocadobytype)+ geom_point(aes(Type,TotalVolume)) + labs(x="Type",Y= "Total Volume")
Which month has the Highest Volume?
April has the highest month of Total Volume sold.code chunk works in Console however when Knitting I get the following error: Error: Column avocadoprices$Monthis unkown
avocadobymonth<-avocadoprices %>%group_by(avocadoprices$Month) %>% summarize(TotalVolume = sum(TotalVolume))
avocadobymonthggplot(avocadobymonth)+ geom_point(aes(Month,TotalVolume)) + labs(x="Month",Y= "Total_Volume")Data Set 2
Topic: Cold and Heat Absorbtion
Posted by: Christopher Ayre
Create a .CSV file and Read .CSV into R
## color minute.0 minute.10 minute.20 minute.30 minute.40 minute.50
## 1 white 78 81 83 88 93 96
## 2 red 78 82 90 93 98 106
## 3 pink 78 82 84 90 96 99
## 4 black 78 88 92 98 108 116
## 5 green 78 81 85 91 95 102
## 6 white 98 96 93 80 78 78
## minute.60 phase
## 1 98 heating
## 2 109 heating
## 3 102 heating
## 4 121 heating
## 5 105 heating
## 6 78 coolingabs<-read.csv("https://raw.githubusercontent.com/IsARam/DATA607/master/science%20proj%20data.csv",sep = ",")
head(abs)Tidy Data
Rename Column Names
colnames(abs) <- c("color",0,10,20,30,40,50,60,"phase")Gather Data
I wanted to convert the table from a wide format to a long format by using gather. Upon using the str function, I discovered that time was stored as a chr data type so I need to convert newabs$time to a numeric data type.
newabs<-gather(abs, time, temperature, "0":"60")
str(newabs)## 'data.frame': 70 obs. of 4 variables:
## $ color : Factor w/ 5 levels "black","green",..: 5 4 3 1 2 5 4 3 1 2 ...
## $ phase : Factor w/ 2 levels "cooling","heating": 2 2 2 2 2 1 1 1 1 1 ...
## $ time : chr "0" "0" "0" "0" ...
## $ temperature: int 78 78 78 78 78 98 109 102 121 105 ...newabs$time <- as.numeric(newabs$time)
str(newabs)## 'data.frame': 70 obs. of 4 variables:
## $ color : Factor w/ 5 levels "black","green",..: 5 4 3 1 2 5 4 3 1 2 ...
## $ phase : Factor w/ 2 levels "cooling","heating": 2 2 2 2 2 1 1 1 1 1 ...
## $ time : num 0 0 0 0 0 0 0 0 0 0 ...
## $ temperature: int 78 78 78 78 78 98 109 102 121 105 ...head(newabs)## color phase time temperature
## 1 white heating 0 78
## 2 red heating 0 78
## 3 pink heating 0 78
## 4 black heating 0 78
## 5 green heating 0 78
## 6 white cooling 0 98Data Transformation
Descriptive Statistics
summary(newabs)## color phase time temperature
## black:14 cooling:35 Min. : 0 Min. : 78.00
## green:14 heating:35 1st Qu.:10 1st Qu.: 80.00
## pink :14 Median :30 Median : 90.00
## red :14 Mean :30 Mean : 90.74
## white:14 3rd Qu.:50 3rd Qu.: 98.00
## Max. :60 Max. :121.00Analysis
ggplot(newabs)+ geom_point(aes(newabs$color,newabs$temperature)) + labs(x="Color",Y= "Temperature")
Data Set 3
Topic: Top Best Seller Books on Amazon
Posted by: Henry otuadinma
Create a .CSV file and Read .CSV into R
books<- read.csv("topBooks.csv",sep=",")
head(books)## ï..title author genre rating
## 1 Zoo Nebraska Carson Vaughan History 4.5
## 2 Code Girls Liza Mundy History 4.5
## 3 Extraordinary Lives William Zinsser History 4.3
## 4 The Threat Andrew G. McCabe History 4.7
## 5 Extreme Ownership Jocko Willink History 4.8
## 6 Sapiens Yuval Noah Harari History 4.5
## img
## 1 https://images-na.ssl-images-amazon.com/images/I/91Lm8MYUs2L.__BG0,0,0,0_FMpng_AC_UL200_SR200,200_.jpg
## 2 https://images-na.ssl-images-amazon.com/images/I/81wLZGJfUcL.__BG0,0,0,0_FMpng_AC_UL200_SR200,200_.jpg
## 3 https://images-na.ssl-images-amazon.com/images/I/71ZvpEUKP%2BL.__BG0,0,0,0_FMpng_AC_UL200_SR200,200_.jpg
## 4 https://images-na.ssl-images-amazon.com/images/I/81daKLuXheL._AC_UL200_SR200,200_.jpg
## 5 https://images-na.ssl-images-amazon.com/images/I/81zCJh6xsQL._AC_UL200_SR200,200_.jpg
## 6 https://images-na.ssl-images-amazon.com/images/I/81tPEe0egBL._AC_UL200_SR200,200_.jpg
## numRater type price
## 1 16 Kindle Edition 4.99
## 2 459 Kindle Edition 11.99
## 3 53 Kindle Edition 1.99
## 4 192 Audible Audiobook Free with Audible trial
## 5 2597 Audible Audiobook Free with Audible trial
## 6 5630 Audible Audiobook Free with Audible trialstr(books)## 'data.frame': 250 obs. of 8 variables:
## $ ï..title: Factor w/ 186 levels "10 Actual, Official LSAT PrepTests Volume V",..: 186 32 43 154 44 96 113 153 154 97 ...
## $ author : Factor w/ 176 levels "A.G. Riddle",..: 29 96 175 9 78 176 57 112 9 128 ...
## $ genre : Factor w/ 5 levels "History","Law",..: 1 1 1 1 1 1 1 1 1 1 ...
## $ rating : num 4.5 4.5 4.3 4.7 4.8 4.5 4.5 4.6 4.7 4.8 ...
## $ img : Factor w/ 239 levels "https://images-na.ssl-images-amazon.com/images/I/415mwgZ7kSL._AC_UL200_SR200,200_.jpg",..: 192 131 58 78 152 121 175 222 138 231 ...
## $ numRater: int 16 459 53 192 2597 5630 269 630 192 19 ...
## $ type : Factor w/ 5 levels "Audible Audiobook",..: 4 4 4 1 1 1 4 4 3 3 ...
## $ price : Factor w/ 86 levels " Free with Audible trial",..: 64 13 4 1 1 1 64 4 48 45 ...Tidy Data
I am using tidyr to tidy data. I will only be working with the total columns as opposed to the quarterly data focusing on Region.
Subset Data and Rename Column Names
colnames(books)<- c("Title", "Author", "Genre","Rating","Image", "Rating" , "Type", "Price")
colnames(books)## [1] "Title" "Author" "Genre" "Rating" "Image" "Rating" "Type" "Price"newbooks<- subset(books, select = c(1:4))
newbooks## Title
## 1 Zoo Nebraska
## 2 Code Girls
## 3 Extraordinary Lives
## 4 The Threat
## 5 Extreme Ownership
## 6 Sapiens
## 7 The Broken Circle
## 8 The Things Our Fathers Sawâ\200The Untold Stories of the World War II Generation From Hometown, USA-Volume I
## 9 The Threat
## 10 Say Nothing
## 11 The Threat
## 12 Bury My Heart at Wounded Knee
## 13 Mastering the Art of French Eating
## 14 Say Nothing
## 15 Born Survivors
## 16 Sapiens
## 17 Dissolving Illusions
## 18 Queen of Scots
## 19 The Case for Trump
## 20 Say Nothing
## 21 Extreme Ownership
## 22 The Worst Hard Time
## 23 At the Existentialist Café
## 24 Topgun
## 25 Spearhead
## 26 Sapiens
## 27 21 Lessons for the 21st Century
## 28 The Day the World Came to Town
## 29 Monster City
## 30 D DAY Through German Eyes - Book Two - More hidden stories from June 6th 1944 (D DAY - Through German Eyes)
## 31 Thunder Dog
## 32 Fly Girls
## 33 What You Should Know About Politics . . . But Don't
## 34 Five Presidents
## 35 Man's Search for Meaning
## 36 Prague Winter
## 37 Stuff Matters
## 38 The Library Book
## 39 Madame Fourcade's Secret War
## 40 Homo Deus
## 41 Spearhead
## 42 The Forgotten 500
## 43 Boomerang
## 44 The First Conspiracy
## 45 The Library Book
## 46 Five Presidents
## 47 The First Conspiracy
## 48 Astrophysics for People in a Hurry
## 49 Midnight in Chernobyl
## 50 The Negro Motorist Green-Book
## 51 Girl, Stop Apologizing
## 52 Thief of Corinth
## 53 Girl, Stop Apologizing (Audible Exclusive Edition)
## 54 Girl, Wash Your Face
## 55 The Miracle Morning
## 56 Girl, Wash Your Face
## 57 A World Full of Strangers
## 58 The Life-Changing Magic of Tidying Up
## 59 The 5 Love Languages
## 60 The Lost Girls of Paris
## 61 The Tattooist of Auschwitz
## 62 Capital Gaines
## 63 Along the Cane River
## 64 It's Not Supposed to Be This Way
## 65 Choosing Happiness Even When Life Is Hard
## 66 The Four Agreements
## 67 The Total Money Makeover
## 68 The Rock, the Road, and the Rabbi
## 69 Once Upon a Prince (Royal Wedding Series Book 1)
## 70 The Tattooist of Auschwitz
## 71 The Five Love Languages
## 72 Girl, Wash Your Face
## 73 The Life-Changing Magic of Tidying Up
## 74 The Power of Now
## 75 The Tattooist of Auschwitz
## 76 Girl, Stop Apologizing
## 77 Things I Never Told You (Thatcher Sisters)
## 78 Attempt to Locate (Lantern Beach P.D. Book 2)
## 79 The Total Money Makeover
## 80 The Four Agreements
## 81 Same Kind of Different As Me
## 82 The Complete Holy Bible - KJV
## 83 Explosive Force (Military K-9 Unit)
## 84 When I Pray for You
## 85 Warrior of the Light
## 86 The 5 Love Languages
## 87 Justice Comes Home (The Texas Riders Western) (A Western Frontier Fiction)
## 88 It's Not Supposed to Be This Way
## 89 Jesus Calling
## 90 A Mother's Love
## 91 Consciousness Beyond Life
## 92 The Gifts of Imperfection
## 93 The Lost Girls of Paris
## 94 The Alchemist
## 95 Willow Falls (Matt Bannister Western Book 1)
## 96 Becoming Supernatural
## 97 How to Change Your Mind
## 98 A New Earth
## 99 My Spiritual Journey
## 100 Spark Joy
## 101 The Elephant in the Brain
## 102 12 Rules for Life
## 103 Sapiens
## 104 The Uninhabitable Earth
## 105 Mama's Last Hug
## 106 Sapiens
## 107 Thinking, Fast and Slow
## 108 The Undoing Project
## 109 The Uninhabitable Earth
## 110 Consciousness Beyond Life
## 111 The Worst Hard Time
## 112 Feeding You Lies
## 113 If I Understood You, Would I Have This Look on My Face?
## 114 Sapiens
## 115 The Plant Paradox Quick and Easy
## 116 Digital Minimalism
## 117 Misbehaving
## 118 Maps of Meaning
## 119 Thinking, Fast and Slow
## 120 Outliers
## 121 There's No Place Like Space
## 122 Astrophysics for People in a Hurry
## 123 The Untethered Soul
## 124 Stuff Matters
## 125 The Uninhabitable Earth
## 126 The Untethered Soul
## 127 Homo Deus
## 128 The Power of Habit
## 129 Grit
## 130 Walden (AmazonClassics Edition)
## 131 Mama's Last Hug
## 132 No-Drama Discipline
## 133 The Body Keeps the Score
## 134 Astrophysics for People in a Hurry
## 135 Midnight in Chernobyl
## 136 Digital Minimalism
## 137 The Truth About Men
## 138 Grit
## 139 Wine Grapes
## 140 The Story of Earth
## 141 Why We Sleep
## 142 Attached
## 143 Quiet
## 144 Influence
## 145 Why We Sleep
## 146 Attached
## 147 Astrophysics for People in a Hurry
## 148 Midnight in Chernobyl
## 149 Algorithms to Live By
## 150 Women in Science
## 151 The Rescue (Ryan Decker Book 1)
## 152 I'm Fine and Neither Are You
## 153 A Lily in the Light
## 154 Beyond the Shadow of Night
## 155 Tumble (Dogwood Lane Book 1)
## 156 Where the Crawdads Sing
## 157 Surprise Delivery
## 158 Where the Forest Meets the Stars
## 159 A Curve in the Road
## 160 The Handmaid's Tale
## 161 Where the Crawdads Sing
## 162 Stillhouse Lake
## 163 The Beantown Girls
## 164 Verses for the Dead (Agent Pendergast)
## 165 What the Wind Knows
## 166 Thief of Corinth
## 167 Beneath a Scarlet Sky
## 168 The Storyteller's Secret
## 169 On the Island
## 170 Harry Potter and the Sorcerer's Stone
## 171 Where the Crawdads Sing
## 172 Southern Player
## 173 Every Breath
## 174 The Victory Garden
## 175 Ex's Best Friend
## 176 Lethal White (A Cormoran Strike Novel Book 4)
## 177 The Perfect Child
## 178 All This I Will Give to You
## 179 Runner (Sam Dryden series Book 1)
## 180 The Killer Collective
## 181 X (Kinsey Millhone Book 24)
## 182 Flirting with the Frenemy (Bro Code Book 1)
## 183 Since You've Been Gone
## 184 Winter Cottage
## 185 The Strange Journey of Alice Pendelbury
## 186 In Farleigh Field
## 187 Mr Spencer
## 188 Since We Fell
## 189 The Secret Orphan
## 190 My Sister's Grave (Tracy Crosswhite Book 1)
## 191 A World Full of Strangers
## 192 The Spitfire Girls
## 193 Winter World (The Long Winter Book 1)
## 194 Edge of Eternity (The Century Trilogy, Book 3)
## 195 Blue Moon
## 196 The Magnolia Inn
## 197 Inevitable
## 198 Heartless (An Enemies To Lovers Novel Book 1)
## 199 Daddy
## 200 The Beach House
## 201 Becoming
## 202 Becoming
## 203 My Own Words
## 204 Mindset
## 205 Just Mercy
## 206 Just Mercy
## 207 The New Jim Crow
## 208 Michelle Obama
## 209 Doing Justice
## 210 Doing Justice
## 211 The Mueller Report
## 212 Licensed to Lie
## 213 Bending Toward Justice
## 214 Until We Reckon
## 215 10 Actual, Official LSAT PrepTests Volume VI
## 216 The Unwinding of the Miracle
## 217 The Sun Does Shine
## 218 All Good Things
## 219 The Mastermind
## 220 A Higher Loyalty
## 221 The Adventures of Big-Foot Wallace
## 222 The Color of Law
## 223 The New Jim Crow
## 224 The Unwinding of the Miracle
## 225 Mindhunter
## 226 Just Mercy
## 227 Notorious RBG
## 228 The Innocent Man
## 229 Separate
## 230 Robert's Rules of Order Newly Revised (Robert's Rules of Order (Paperback))
## 231 A Higher Loyalty
## 232 Doing Justice
## 233 Becoming
## 234 The LSAT Trainer
## 235 The Mastermind
## 236 Becoming
## 237 Quicken Willmaker Plus 2019 Edition
## 238 The Unwinding of the Miracle
## 239 10 Actual, Official LSAT PrepTests Volume V
## 240 My Own Words
## 241 How to Debate Leftists and Destroy Them
## 242 Notorious RBG
## 243 The Smartest Guys in the Room
## 244 ASVAB Study Guide 2018-2019
## 245 My Own Words
## 246 Black Klansman
## 247 The Gulag Archipelago Abridged
## 248 Becoming
## 249 The Complete Sherlock Holmes
## 250 The Mastermind
## Author Genre Rating
## 1 Carson Vaughan History 4.5
## 2 Liza Mundy History 4.5
## 3 William Zinsser History 4.3
## 4 Andrew G. McCabe History 4.7
## 5 Jocko Willink History 4.8
## 6 Yuval Noah Harari History 4.5
## 7 Enjeela Ahmadi-Miller History 4.5
## 8 Matthew Rozell History 4.6
## 9 Andrew G. McCabe History 4.7
## 10 Patrick Radden Keefe History 4.8
## 11 Andrew G. McCabe History 4.7
## 12 Dee Brown History 4.7
## 13 Ann Mah History 4.2
## 14 Patrick Radden Keefe History 4.8
## 15 Wendy Holden History 4.8
## 16 Yuval Noah Harari History 4.5
## 17 Suzanne Humphries MD History 4.8
## 18 John Guy History 4.2
## 19 Victor Davis Hanson History NA
## 20 Patrick Radden Keefe History 4.8
## 21 Jocko Willink History 4.8
## 22 Timothy Egan History 4.5
## 23 Sarah Bakewell History 4.5
## 24 Dan Pedersen History 4.6
## 25 Adam Makos History 5.0
## 26 Yuval Noah Harari History 4.5
## 27 Yuval Noah Harari History 4.2
## 28 Jim DeFede History 4.6
## 29 Michael Arntfield History 4.3
## 30 Holger Eckhertz History 4.6
## 31 Michael Hingson History 4.6
## 32 Keith O'Brien History 4.5
## 33 Jessamyn Conrad History 4.4
## 34 Clint Hill History 4.6
## 35 Viktor E. Frankl History 4.7
## 36 Madeleine Korbel Albright History 4.4
## 37 Mark Miodownik History 4.5
## 38 Susan Orlean History 4.2
## 39 Lynne Olson History NA
## 40 Yuval Noah Harari History 4.4
## 41 Adam Makos History 5.0
## 42 Gregory A. Freeman History 4.6
## 43 Michael Lewis History 4.3
## 44 Brad Meltzer History 4.2
## 45 Susan Orlean History 4.2
## 46 Clint Hill History 4.6
## 47 Brad Meltzer History 4.2
## 48 Neil deGrasse Tyson History 4.6
## 49 Adam Higginbotham History 4.6
## 50 Victor H. Green History 4.7
## 51 Rachel Hollis Religion NA
## 52 Tessa Afshar Religion 4.7
## 53 Rachel Hollis Religion NA
## 54 Rachel Hollis Religion 4.7
## 55 Hal Elrod Religion 4.6
## 56 Rachel Hollis Religion 4.7
## 57 Cynthia Freeman Religion 4.0
## 58 Marie Kondo Religion 4.4
## 59 Gary Chapman Religion 4.8
## 60 Pam Jenoff Religion 4.3
## 61 Heather Morris Religion 4.6
## 62 Chip Gaines Religion 4.7
## 63 Mary Jane Hathaway Religion 4.7
## 64 Lysa TerKeurst Religion 4.8
## 65 Frank Minirth Religion 4.2
## 66 Don Miguel Ruiz Religion 4.6
## 67 Dave Ramsey Religion 4.7
## 68 Kathie Lee Gifford Religion 4.7
## 69 Rachel Hauck Religion 4.5
## 70 Heather Morris Religion 4.6
## 71 Gary Chapman Religion 4.8
## 72 Rachel Hollis Religion 4.7
## 73 Marie Kondo Religion 4.4
## 74 Eckhart Tolle Religion 4.6
## 75 Heather Morris Religion 4.6
## 76 Rachel Hollis Religion NA
## 77 Beth K. Vogt Religion 4.6
## 78 Christy Barritt Religion 4.8
## 79 Dave Ramsey Religion 4.7
## 80 don Miguel Ruiz Religion 4.6
## 81 Ron Hall Religion 4.8
## 82 Topics Media Group Religion 4.5
## 83 Lynette Eason Religion 4.6
## 84 Matthew Paul Turner Religion 4.9
## 85 Paulo Coelho Religion 4.3
## 86 Gary Chapman Religion 4.8
## 87 Joseph Powell Religion 4.3
## 88 Lysa TerKeurst Religion 4.8
## 89 Sarah Young Religion 4.9
## 90 Charlotte Hubbard Religion 4.6
## 91 Pim van Lommel Religion 4.5
## 92 Brené Brown Religion 4.6
## 93 Pam Jenoff Religion 4.3
## 94 Paulo Coelho Religion 4.6
## 95 Ken Pratt Religion 4.3
## 96 Dr. Joe Dispenza Religion 4.8
## 97 Michael Pollan Religion 4.6
## 98 Eckhart Tolle Religion 4.6
## 99 Dalai Lama Religion 4.4
## 100 Marie Kondo Religion 4.6
## 101 Kevin Simler Science & Math 4.1
## 102 Jordan B. Peterson Science & Math 4.6
## 103 Yuval Noah Harari Science & Math 4.5
## 104 David Wallace-Wells Science & Math 4.5
## 105 Frans de Waal Science & Math 5.0
## 106 Yuval Noah Harari Science & Math 4.5
## 107 Daniel Kahneman Science & Math 4.5
## 108 Michael Lewis Science & Math 4.2
## 109 David Wallace-Wells Science & Math 4.5
## 110 Pim van Lommel Science & Math 4.5
## 111 Timothy Egan Science & Math 4.5
## 112 Vani Hari Science & Math 4.9
## 113 Alan Alda Science & Math 4.4
## 114 Yuval Noah Harari Science & Math 4.5
## 115 Dr. Steven R Gundry M.D. Science & Math 4.1
## 116 Cal Newport Science & Math 4.5
## 117 Richard H. Thaler Science & Math 4.4
## 118 Jordan B. Peterson Science & Math 4.6
## 119 Daniel Kahneman Science & Math 4.5
## 120 Malcolm Gladwell Science & Math 4.6
## 121 Tish Rabe Science & Math 4.7
## 122 Neil deGrasse Tyson Science & Math 4.6
## 123 Michael A. Singer Science & Math 4.7
## 124 Mark Miodownik Science & Math 4.5
## 125 David Wallace-Wells Science & Math 4.5
## 126 Michael A. Singer Science & Math 4.7
## 127 Yuval Noah Harari Science & Math 4.4
## 128 Charles Duhigg Science & Math 4.5
## 129 Angela Duckworth Science & Math 4.5
## 130 Henry David Thoreau Science & Math 4.2
## 131 Frans de Waal Science & Math 5.0
## 132 Daniel J. Siegel Science & Math 4.6
## 133 Bessel Van der Kolk MD Science & Math 4.8
## 134 Neil deGrasse Tyson Science & Math 4.6
## 135 Adam Higginbotham Science & Math 4.6
## 136 Cal Newport Science & Math 4.5
## 137 DeVon Franklin Science & Math 4.5
## 138 Angela Duckworth Science & Math 4.5
## 139 Jancis Robinson Science & Math 4.7
## 140 Robert M. Hazen Science & Math 4.7
## 141 Matthew Walker PhD Science & Math 4.7
## 142 Amir Levine Science & Math 4.7
## 143 Susan Cain Science & Math 4.5
## 144 Robert B. Cialdini Science & Math 4.5
## 145 Matthew Walker PhD Science & Math 4.7
## 146 Amir Levine Science & Math 4.7
## 147 Neil de Grasse Tyson Science & Math 4.6
## 148 Adam Higginbotham Science & Math 4.6
## 149 Brian Christian Science & Math 4.5
## 150 Rachel Ignotofsky Science & Math 4.6
## 151 Steven Konkoly Literature & Fiction 4.9
## 152 Camille Pagán Literature & Fiction 4.6
## 153 Kristin Fields Literature & Fiction 4.0
## 154 Ray Kingfisher Literature & Fiction 4.4
## 155 Adriana Locke Literature & Fiction 4.4
## 156 Delia Owens Literature & Fiction 4.8
## 157 R.R. Banks Literature & Fiction 4.1
## 158 Glendy Vanderah Literature & Fiction 4.7
## 159 Julianne MacLean Literature & Fiction 4.3
## 160 Margaret Atwood Literature & Fiction 4.1
## 161 Delia Owens Literature & Fiction 4.8
## 162 Rachel Caine Literature & Fiction 4.5
## 163 Jane Healey Literature & Fiction 4.7
## 164 Douglas Preston Literature & Fiction 4.3
## 165 Amy Harmon Literature & Fiction 4.8
## 166 Tessa Afshar Literature & Fiction 4.7
## 167 Mark Sullivan Literature & Fiction 4.8
## 168 Sejal Badani Literature & Fiction 4.8
## 169 Tracey Garvis Graves Literature & Fiction 4.6
## 170 J.K. Rowling Literature & Fiction 4.8
## 171 Delia Owens Literature & Fiction 4.8
## 172 Jessica Peterson Literature & Fiction 4.8
## 173 Nicholas Sparks Literature & Fiction 4.7
## 174 Rhys Bowen Literature & Fiction 4.4
## 175 Aubrey Wright Literature & Fiction 4.8
## 176 Robert Galbraith Literature & Fiction 4.5
## 177 Lucinda Berry Literature & Fiction 4.1
## 178 Dolores Redondo Literature & Fiction 4.6
## 179 Patrick Lee Literature & Fiction 4.5
## 180 Barry Eisler Literature & Fiction 4.4
## 181 Sue Grafton Literature & Fiction 4.3
## 182 Pippa Grant Literature & Fiction 4.8
## 183 Christa Allan Literature & Fiction 4.4
## 184 Mary Ellen Taylor Literature & Fiction 4.6
## 185 Marc Levy Literature & Fiction 4.5
## 186 Rhys Bowen Literature & Fiction 4.2
## 187 T L Swan Literature & Fiction 4.8
## 188 Dennis Lehane Literature & Fiction 3.6
## 189 Glynis Peters Literature & Fiction 4.5
## 190 Robert Dugoni Literature & Fiction 4.4
## 191 Cynthia Freeman Literature & Fiction 4.0
## 192 Soraya M. Lane Literature & Fiction 4.4
## 193 A.G. Riddle Literature & Fiction 4.9
## 194 Ken Follett Literature & Fiction 4.1
## 195 Lee Child Literature & Fiction NA
## 196 Carolyn Brown Literature & Fiction 4.4
## 197 C.J. Petit Literature & Fiction 4.7
## 198 Michelle Heard Literature & Fiction 4.4
## 199 Katy Kaylee Literature & Fiction 4.5
## 200 Mary Alice Monroe Literature & Fiction 4.6
## 201 Michelle Obama Law 4.9
## 202 Michelle Obama Law 4.9
## 203 Ruth Bader Ginsburg Law 4.3
## 204 Carol S. Dweck Law 4.5
## 205 Bryan Stevenson Law 4.8
## 206 Bryan Stevenson Law 4.8
## 207 Michelle Alexander Law 4.7
## 208 Peter Slevin Law 4.4
## 209 Preet Bharara Law NA
## 210 Preet Bharara Law NA
## 211 Robert S. Mueller III Law NA
## 212 Sidney Powell Law 4.9
## 213 Doug Jones Law 4.1
## 214 Danielle Sered Law NA
## 215 Law School Admission Council Law 4.6
## 216 Julie Yip-Williams Law 4.6
## 217 Anthony Ray Hinton Law 4.9
## 218 Rosemary Reeve Law 4.9
## 219 Evan Ratliff Law 4.6
## 220 James Comey Law 4.7
## 221 John C. Duval Law 4.2
## 222 Richard Rothstein Law 4.8
## 223 Michelle Alexander Law 4.7
## 224 Julie Yip-Williams Law 4.6
## 225 John E. Douglas Law 4.4
## 226 Bryan Stevenson Law 4.8
## 227 Irin Carmon Law 4.5
## 228 John Grisham Law 4.2
## 229 Steve Luxenberg Law 5.0
## 230 Henry M. Robert III Law 4.6
## 231 James Comey Law 4.7
## 232 Preet Bharara Law NA
## 233 Michelle Obama Law 4.4
## 234 Mike Kim Law 4.5
## 235 Evan Ratliff Law 4.6
## 236 Michelle Obama Law 4.9
## 237 Editors of Nolo Law 4.2
## 238 Julie Yip-Williams Law 4.6
## 239 Law School Admission Council Law 4.7
## 240 Ruth Bader Ginsburg Law 4.3
## 241 Ben Shapiro Law 4.5
## 242 Irin Carmon Law 4.5
## 243 Bethany McLean Law 4.5
## 244 Test Prep Books Military Team Law 4.5
## 245 Ruth Bader Ginsburg Law 4.3
## 246 Ron Stallworth Law 4.2
## 247 Aleksandr Solzhenitsyn Law 4.6
## 248 Michelle Obama Law 4.9
## 249 Arthur Conan Doyle Law 4.5
## 250 Evan Ratliff Law 4.6newbookswona<-na.omit(newbooks)
newbookswona## Title
## 1 Zoo Nebraska
## 2 Code Girls
## 3 Extraordinary Lives
## 4 The Threat
## 5 Extreme Ownership
## 6 Sapiens
## 7 The Broken Circle
## 8 The Things Our Fathers Sawâ\200The Untold Stories of the World War II Generation From Hometown, USA-Volume I
## 9 The Threat
## 10 Say Nothing
## 11 The Threat
## 12 Bury My Heart at Wounded Knee
## 13 Mastering the Art of French Eating
## 14 Say Nothing
## 15 Born Survivors
## 16 Sapiens
## 17 Dissolving Illusions
## 18 Queen of Scots
## 20 Say Nothing
## 21 Extreme Ownership
## 22 The Worst Hard Time
## 23 At the Existentialist Café
## 24 Topgun
## 25 Spearhead
## 26 Sapiens
## 27 21 Lessons for the 21st Century
## 28 The Day the World Came to Town
## 29 Monster City
## 30 D DAY Through German Eyes - Book Two - More hidden stories from June 6th 1944 (D DAY - Through German Eyes)
## 31 Thunder Dog
## 32 Fly Girls
## 33 What You Should Know About Politics . . . But Don't
## 34 Five Presidents
## 35 Man's Search for Meaning
## 36 Prague Winter
## 37 Stuff Matters
## 38 The Library Book
## 40 Homo Deus
## 41 Spearhead
## 42 The Forgotten 500
## 43 Boomerang
## 44 The First Conspiracy
## 45 The Library Book
## 46 Five Presidents
## 47 The First Conspiracy
## 48 Astrophysics for People in a Hurry
## 49 Midnight in Chernobyl
## 50 The Negro Motorist Green-Book
## 52 Thief of Corinth
## 54 Girl, Wash Your Face
## 55 The Miracle Morning
## 56 Girl, Wash Your Face
## 57 A World Full of Strangers
## 58 The Life-Changing Magic of Tidying Up
## 59 The 5 Love Languages
## 60 The Lost Girls of Paris
## 61 The Tattooist of Auschwitz
## 62 Capital Gaines
## 63 Along the Cane River
## 64 It's Not Supposed to Be This Way
## 65 Choosing Happiness Even When Life Is Hard
## 66 The Four Agreements
## 67 The Total Money Makeover
## 68 The Rock, the Road, and the Rabbi
## 69 Once Upon a Prince (Royal Wedding Series Book 1)
## 70 The Tattooist of Auschwitz
## 71 The Five Love Languages
## 72 Girl, Wash Your Face
## 73 The Life-Changing Magic of Tidying Up
## 74 The Power of Now
## 75 The Tattooist of Auschwitz
## 77 Things I Never Told You (Thatcher Sisters)
## 78 Attempt to Locate (Lantern Beach P.D. Book 2)
## 79 The Total Money Makeover
## 80 The Four Agreements
## 81 Same Kind of Different As Me
## 82 The Complete Holy Bible - KJV
## 83 Explosive Force (Military K-9 Unit)
## 84 When I Pray for You
## 85 Warrior of the Light
## 86 The 5 Love Languages
## 87 Justice Comes Home (The Texas Riders Western) (A Western Frontier Fiction)
## 88 It's Not Supposed to Be This Way
## 89 Jesus Calling
## 90 A Mother's Love
## 91 Consciousness Beyond Life
## 92 The Gifts of Imperfection
## 93 The Lost Girls of Paris
## 94 The Alchemist
## 95 Willow Falls (Matt Bannister Western Book 1)
## 96 Becoming Supernatural
## 97 How to Change Your Mind
## 98 A New Earth
## 99 My Spiritual Journey
## 100 Spark Joy
## 101 The Elephant in the Brain
## 102 12 Rules for Life
## 103 Sapiens
## 104 The Uninhabitable Earth
## 105 Mama's Last Hug
## 106 Sapiens
## 107 Thinking, Fast and Slow
## 108 The Undoing Project
## 109 The Uninhabitable Earth
## 110 Consciousness Beyond Life
## 111 The Worst Hard Time
## 112 Feeding You Lies
## 113 If I Understood You, Would I Have This Look on My Face?
## 114 Sapiens
## 115 The Plant Paradox Quick and Easy
## 116 Digital Minimalism
## 117 Misbehaving
## 118 Maps of Meaning
## 119 Thinking, Fast and Slow
## 120 Outliers
## 121 There's No Place Like Space
## 122 Astrophysics for People in a Hurry
## 123 The Untethered Soul
## 124 Stuff Matters
## 125 The Uninhabitable Earth
## 126 The Untethered Soul
## 127 Homo Deus
## 128 The Power of Habit
## 129 Grit
## 130 Walden (AmazonClassics Edition)
## 131 Mama's Last Hug
## 132 No-Drama Discipline
## 133 The Body Keeps the Score
## 134 Astrophysics for People in a Hurry
## 135 Midnight in Chernobyl
## 136 Digital Minimalism
## 137 The Truth About Men
## 138 Grit
## 139 Wine Grapes
## 140 The Story of Earth
## 141 Why We Sleep
## 142 Attached
## 143 Quiet
## 144 Influence
## 145 Why We Sleep
## 146 Attached
## 147 Astrophysics for People in a Hurry
## 148 Midnight in Chernobyl
## 149 Algorithms to Live By
## 150 Women in Science
## 151 The Rescue (Ryan Decker Book 1)
## 152 I'm Fine and Neither Are You
## 153 A Lily in the Light
## 154 Beyond the Shadow of Night
## 155 Tumble (Dogwood Lane Book 1)
## 156 Where the Crawdads Sing
## 157 Surprise Delivery
## 158 Where the Forest Meets the Stars
## 159 A Curve in the Road
## 160 The Handmaid's Tale
## 161 Where the Crawdads Sing
## 162 Stillhouse Lake
## 163 The Beantown Girls
## 164 Verses for the Dead (Agent Pendergast)
## 165 What the Wind Knows
## 166 Thief of Corinth
## 167 Beneath a Scarlet Sky
## 168 The Storyteller's Secret
## 169 On the Island
## 170 Harry Potter and the Sorcerer's Stone
## 171 Where the Crawdads Sing
## 172 Southern Player
## 173 Every Breath
## 174 The Victory Garden
## 175 Ex's Best Friend
## 176 Lethal White (A Cormoran Strike Novel Book 4)
## 177 The Perfect Child
## 178 All This I Will Give to You
## 179 Runner (Sam Dryden series Book 1)
## 180 The Killer Collective
## 181 X (Kinsey Millhone Book 24)
## 182 Flirting with the Frenemy (Bro Code Book 1)
## 183 Since You've Been Gone
## 184 Winter Cottage
## 185 The Strange Journey of Alice Pendelbury
## 186 In Farleigh Field
## 187 Mr Spencer
## 188 Since We Fell
## 189 The Secret Orphan
## 190 My Sister's Grave (Tracy Crosswhite Book 1)
## 191 A World Full of Strangers
## 192 The Spitfire Girls
## 193 Winter World (The Long Winter Book 1)
## 194 Edge of Eternity (The Century Trilogy, Book 3)
## 196 The Magnolia Inn
## 197 Inevitable
## 198 Heartless (An Enemies To Lovers Novel Book 1)
## 199 Daddy
## 200 The Beach House
## 201 Becoming
## 202 Becoming
## 203 My Own Words
## 204 Mindset
## 205 Just Mercy
## 206 Just Mercy
## 207 The New Jim Crow
## 208 Michelle Obama
## 212 Licensed to Lie
## 213 Bending Toward Justice
## 215 10 Actual, Official LSAT PrepTests Volume VI
## 216 The Unwinding of the Miracle
## 217 The Sun Does Shine
## 218 All Good Things
## 219 The Mastermind
## 220 A Higher Loyalty
## 221 The Adventures of Big-Foot Wallace
## 222 The Color of Law
## 223 The New Jim Crow
## 224 The Unwinding of the Miracle
## 225 Mindhunter
## 226 Just Mercy
## 227 Notorious RBG
## 228 The Innocent Man
## 229 Separate
## 230 Robert's Rules of Order Newly Revised (Robert's Rules of Order (Paperback))
## 231 A Higher Loyalty
## 233 Becoming
## 234 The LSAT Trainer
## 235 The Mastermind
## 236 Becoming
## 237 Quicken Willmaker Plus 2019 Edition
## 238 The Unwinding of the Miracle
## 239 10 Actual, Official LSAT PrepTests Volume V
## 240 My Own Words
## 241 How to Debate Leftists and Destroy Them
## 242 Notorious RBG
## 243 The Smartest Guys in the Room
## 244 ASVAB Study Guide 2018-2019
## 245 My Own Words
## 246 Black Klansman
## 247 The Gulag Archipelago Abridged
## 248 Becoming
## 249 The Complete Sherlock Holmes
## 250 The Mastermind
## Author Genre Rating
## 1 Carson Vaughan History 4.5
## 2 Liza Mundy History 4.5
## 3 William Zinsser History 4.3
## 4 Andrew G. McCabe History 4.7
## 5 Jocko Willink History 4.8
## 6 Yuval Noah Harari History 4.5
## 7 Enjeela Ahmadi-Miller History 4.5
## 8 Matthew Rozell History 4.6
## 9 Andrew G. McCabe History 4.7
## 10 Patrick Radden Keefe History 4.8
## 11 Andrew G. McCabe History 4.7
## 12 Dee Brown History 4.7
## 13 Ann Mah History 4.2
## 14 Patrick Radden Keefe History 4.8
## 15 Wendy Holden History 4.8
## 16 Yuval Noah Harari History 4.5
## 17 Suzanne Humphries MD History 4.8
## 18 John Guy History 4.2
## 20 Patrick Radden Keefe History 4.8
## 21 Jocko Willink History 4.8
## 22 Timothy Egan History 4.5
## 23 Sarah Bakewell History 4.5
## 24 Dan Pedersen History 4.6
## 25 Adam Makos History 5.0
## 26 Yuval Noah Harari History 4.5
## 27 Yuval Noah Harari History 4.2
## 28 Jim DeFede History 4.6
## 29 Michael Arntfield History 4.3
## 30 Holger Eckhertz History 4.6
## 31 Michael Hingson History 4.6
## 32 Keith O'Brien History 4.5
## 33 Jessamyn Conrad History 4.4
## 34 Clint Hill History 4.6
## 35 Viktor E. Frankl History 4.7
## 36 Madeleine Korbel Albright History 4.4
## 37 Mark Miodownik History 4.5
## 38 Susan Orlean History 4.2
## 40 Yuval Noah Harari History 4.4
## 41 Adam Makos History 5.0
## 42 Gregory A. Freeman History 4.6
## 43 Michael Lewis History 4.3
## 44 Brad Meltzer History 4.2
## 45 Susan Orlean History 4.2
## 46 Clint Hill History 4.6
## 47 Brad Meltzer History 4.2
## 48 Neil deGrasse Tyson History 4.6
## 49 Adam Higginbotham History 4.6
## 50 Victor H. Green History 4.7
## 52 Tessa Afshar Religion 4.7
## 54 Rachel Hollis Religion 4.7
## 55 Hal Elrod Religion 4.6
## 56 Rachel Hollis Religion 4.7
## 57 Cynthia Freeman Religion 4.0
## 58 Marie Kondo Religion 4.4
## 59 Gary Chapman Religion 4.8
## 60 Pam Jenoff Religion 4.3
## 61 Heather Morris Religion 4.6
## 62 Chip Gaines Religion 4.7
## 63 Mary Jane Hathaway Religion 4.7
## 64 Lysa TerKeurst Religion 4.8
## 65 Frank Minirth Religion 4.2
## 66 Don Miguel Ruiz Religion 4.6
## 67 Dave Ramsey Religion 4.7
## 68 Kathie Lee Gifford Religion 4.7
## 69 Rachel Hauck Religion 4.5
## 70 Heather Morris Religion 4.6
## 71 Gary Chapman Religion 4.8
## 72 Rachel Hollis Religion 4.7
## 73 Marie Kondo Religion 4.4
## 74 Eckhart Tolle Religion 4.6
## 75 Heather Morris Religion 4.6
## 77 Beth K. Vogt Religion 4.6
## 78 Christy Barritt Religion 4.8
## 79 Dave Ramsey Religion 4.7
## 80 don Miguel Ruiz Religion 4.6
## 81 Ron Hall Religion 4.8
## 82 Topics Media Group Religion 4.5
## 83 Lynette Eason Religion 4.6
## 84 Matthew Paul Turner Religion 4.9
## 85 Paulo Coelho Religion 4.3
## 86 Gary Chapman Religion 4.8
## 87 Joseph Powell Religion 4.3
## 88 Lysa TerKeurst Religion 4.8
## 89 Sarah Young Religion 4.9
## 90 Charlotte Hubbard Religion 4.6
## 91 Pim van Lommel Religion 4.5
## 92 Brené Brown Religion 4.6
## 93 Pam Jenoff Religion 4.3
## 94 Paulo Coelho Religion 4.6
## 95 Ken Pratt Religion 4.3
## 96 Dr. Joe Dispenza Religion 4.8
## 97 Michael Pollan Religion 4.6
## 98 Eckhart Tolle Religion 4.6
## 99 Dalai Lama Religion 4.4
## 100 Marie Kondo Religion 4.6
## 101 Kevin Simler Science & Math 4.1
## 102 Jordan B. Peterson Science & Math 4.6
## 103 Yuval Noah Harari Science & Math 4.5
## 104 David Wallace-Wells Science & Math 4.5
## 105 Frans de Waal Science & Math 5.0
## 106 Yuval Noah Harari Science & Math 4.5
## 107 Daniel Kahneman Science & Math 4.5
## 108 Michael Lewis Science & Math 4.2
## 109 David Wallace-Wells Science & Math 4.5
## 110 Pim van Lommel Science & Math 4.5
## 111 Timothy Egan Science & Math 4.5
## 112 Vani Hari Science & Math 4.9
## 113 Alan Alda Science & Math 4.4
## 114 Yuval Noah Harari Science & Math 4.5
## 115 Dr. Steven R Gundry M.D. Science & Math 4.1
## 116 Cal Newport Science & Math 4.5
## 117 Richard H. Thaler Science & Math 4.4
## 118 Jordan B. Peterson Science & Math 4.6
## 119 Daniel Kahneman Science & Math 4.5
## 120 Malcolm Gladwell Science & Math 4.6
## 121 Tish Rabe Science & Math 4.7
## 122 Neil deGrasse Tyson Science & Math 4.6
## 123 Michael A. Singer Science & Math 4.7
## 124 Mark Miodownik Science & Math 4.5
## 125 David Wallace-Wells Science & Math 4.5
## 126 Michael A. Singer Science & Math 4.7
## 127 Yuval Noah Harari Science & Math 4.4
## 128 Charles Duhigg Science & Math 4.5
## 129 Angela Duckworth Science & Math 4.5
## 130 Henry David Thoreau Science & Math 4.2
## 131 Frans de Waal Science & Math 5.0
## 132 Daniel J. Siegel Science & Math 4.6
## 133 Bessel Van der Kolk MD Science & Math 4.8
## 134 Neil deGrasse Tyson Science & Math 4.6
## 135 Adam Higginbotham Science & Math 4.6
## 136 Cal Newport Science & Math 4.5
## 137 DeVon Franklin Science & Math 4.5
## 138 Angela Duckworth Science & Math 4.5
## 139 Jancis Robinson Science & Math 4.7
## 140 Robert M. Hazen Science & Math 4.7
## 141 Matthew Walker PhD Science & Math 4.7
## 142 Amir Levine Science & Math 4.7
## 143 Susan Cain Science & Math 4.5
## 144 Robert B. Cialdini Science & Math 4.5
## 145 Matthew Walker PhD Science & Math 4.7
## 146 Amir Levine Science & Math 4.7
## 147 Neil de Grasse Tyson Science & Math 4.6
## 148 Adam Higginbotham Science & Math 4.6
## 149 Brian Christian Science & Math 4.5
## 150 Rachel Ignotofsky Science & Math 4.6
## 151 Steven Konkoly Literature & Fiction 4.9
## 152 Camille Pagán Literature & Fiction 4.6
## 153 Kristin Fields Literature & Fiction 4.0
## 154 Ray Kingfisher Literature & Fiction 4.4
## 155 Adriana Locke Literature & Fiction 4.4
## 156 Delia Owens Literature & Fiction 4.8
## 157 R.R. Banks Literature & Fiction 4.1
## 158 Glendy Vanderah Literature & Fiction 4.7
## 159 Julianne MacLean Literature & Fiction 4.3
## 160 Margaret Atwood Literature & Fiction 4.1
## 161 Delia Owens Literature & Fiction 4.8
## 162 Rachel Caine Literature & Fiction 4.5
## 163 Jane Healey Literature & Fiction 4.7
## 164 Douglas Preston Literature & Fiction 4.3
## 165 Amy Harmon Literature & Fiction 4.8
## 166 Tessa Afshar Literature & Fiction 4.7
## 167 Mark Sullivan Literature & Fiction 4.8
## 168 Sejal Badani Literature & Fiction 4.8
## 169 Tracey Garvis Graves Literature & Fiction 4.6
## 170 J.K. Rowling Literature & Fiction 4.8
## 171 Delia Owens Literature & Fiction 4.8
## 172 Jessica Peterson Literature & Fiction 4.8
## 173 Nicholas Sparks Literature & Fiction 4.7
## 174 Rhys Bowen Literature & Fiction 4.4
## 175 Aubrey Wright Literature & Fiction 4.8
## 176 Robert Galbraith Literature & Fiction 4.5
## 177 Lucinda Berry Literature & Fiction 4.1
## 178 Dolores Redondo Literature & Fiction 4.6
## 179 Patrick Lee Literature & Fiction 4.5
## 180 Barry Eisler Literature & Fiction 4.4
## 181 Sue Grafton Literature & Fiction 4.3
## 182 Pippa Grant Literature & Fiction 4.8
## 183 Christa Allan Literature & Fiction 4.4
## 184 Mary Ellen Taylor Literature & Fiction 4.6
## 185 Marc Levy Literature & Fiction 4.5
## 186 Rhys Bowen Literature & Fiction 4.2
## 187 T L Swan Literature & Fiction 4.8
## 188 Dennis Lehane Literature & Fiction 3.6
## 189 Glynis Peters Literature & Fiction 4.5
## 190 Robert Dugoni Literature & Fiction 4.4
## 191 Cynthia Freeman Literature & Fiction 4.0
## 192 Soraya M. Lane Literature & Fiction 4.4
## 193 A.G. Riddle Literature & Fiction 4.9
## 194 Ken Follett Literature & Fiction 4.1
## 196 Carolyn Brown Literature & Fiction 4.4
## 197 C.J. Petit Literature & Fiction 4.7
## 198 Michelle Heard Literature & Fiction 4.4
## 199 Katy Kaylee Literature & Fiction 4.5
## 200 Mary Alice Monroe Literature & Fiction 4.6
## 201 Michelle Obama Law 4.9
## 202 Michelle Obama Law 4.9
## 203 Ruth Bader Ginsburg Law 4.3
## 204 Carol S. Dweck Law 4.5
## 205 Bryan Stevenson Law 4.8
## 206 Bryan Stevenson Law 4.8
## 207 Michelle Alexander Law 4.7
## 208 Peter Slevin Law 4.4
## 212 Sidney Powell Law 4.9
## 213 Doug Jones Law 4.1
## 215 Law School Admission Council Law 4.6
## 216 Julie Yip-Williams Law 4.6
## 217 Anthony Ray Hinton Law 4.9
## 218 Rosemary Reeve Law 4.9
## 219 Evan Ratliff Law 4.6
## 220 James Comey Law 4.7
## 221 John C. Duval Law 4.2
## 222 Richard Rothstein Law 4.8
## 223 Michelle Alexander Law 4.7
## 224 Julie Yip-Williams Law 4.6
## 225 John E. Douglas Law 4.4
## 226 Bryan Stevenson Law 4.8
## 227 Irin Carmon Law 4.5
## 228 John Grisham Law 4.2
## 229 Steve Luxenberg Law 5.0
## 230 Henry M. Robert III Law 4.6
## 231 James Comey Law 4.7
## 233 Michelle Obama Law 4.4
## 234 Mike Kim Law 4.5
## 235 Evan Ratliff Law 4.6
## 236 Michelle Obama Law 4.9
## 237 Editors of Nolo Law 4.2
## 238 Julie Yip-Williams Law 4.6
## 239 Law School Admission Council Law 4.7
## 240 Ruth Bader Ginsburg Law 4.3
## 241 Ben Shapiro Law 4.5
## 242 Irin Carmon Law 4.5
## 243 Bethany McLean Law 4.5
## 244 Test Prep Books Military Team Law 4.5
## 245 Ruth Bader Ginsburg Law 4.3
## 246 Ron Stallworth Law 4.2
## 247 Aleksandr Solzhenitsyn Law 4.6
## 248 Michelle Obama Law 4.9
## 249 Arthur Conan Doyle Law 4.5
## 250 Evan Ratliff Law 4.6Gather Data
Data Transformation
After subsetting the table, this table is in an ideal form to analyze.
Descriptive Statistics
summary(newbookswona)## Title Author
## Sapiens : 6 Yuval Noah Harari : 9
## Becoming : 5 Michelle Obama : 5
## Astrophysics for People in a Hurry: 4 Adam Higginbotham : 3
## Girl, Wash Your Face : 3 Andrew G. McCabe : 3
## Just Mercy : 3 Bryan Stevenson : 3
## Midnight in Chernobyl : 3 David Wallace-Wells: 3
## (Other) :215 (Other) :213
## Genre Rating
## History :48 Min. :3.600
## Law :45 1st Qu.:4.400
## Literature & Fiction:49 Median :4.600
## Religion :47 Mean :4.557
## Science & Math :50 3rd Qu.:4.700
## Max. :5.000
## Analysis
avgratingbygenre<-
newbookswona %>%
group_by(Genre) %>%
summarize(AverageRating = mean(Rating))
avgratingbygenre## # A tibble: 5 x 2
## Genre AverageRating
## <fct> <dbl>
## 1 History 4.55
## 2 Law 4.59
## 3 Literature & Fiction 4.51
## 4 Religion 4.59
## 5 Science & Math 4.56qplot(x = avgratingbygenre$Genre, y = avgratingbygenre$AverageRating, data = avgratingbygenre, geom="point")
Religion appears to be the highest rated Genre and Literature & Fiction appear to be the lowest rated Genre.