Books Lara Recommends

This is a fun little activity I did while taking my data analysis course.

Lara_Books_Read...2023 <- read.csv("/cloud/project/Books Data/Lara_Books_Read - 2023.csv")
summary(Lara_Books_Read...2023)
##     title              author             pub_year      page_count   
##  Length:136         Length:136         Min.   :1943   Min.   : 96.0  
##  Class :character   Class :character   1st Qu.:2015   1st Qu.:292.2  
##  Mode  :character   Mode  :character   Median :2021   Median :334.0  
##                                        Mean   :2016   Mean   :344.7  
##                                        3rd Qu.:2022   3rd Qu.:393.8  
##                                        Max.   :2023   Max.   :849.0  
##  date_completed         rating         genre              owned          
##  Length:136         Min.   :2.500   Length:136         Length:136        
##  Class :character   1st Qu.:3.500   Class :character   Class :character  
##  Mode  :character   Median :4.000   Mode  :character   Mode  :character  
##                     Mean   :3.892                                        
##                     3rd Qu.:4.000                                        
##                     Max.   :5.000

Book List Source

This is a complete list of all the books I read in 2023. This dataset was complied by me using the information in my Storygraph app. This app keeps track of books I read, when I finished reading the book, page count, and how I rated each book.

Genres

These are all the genres I read in 2023. As you can see, I’m not a big fan of memoirs or biographies.

pie(table(Lara_Books_Read...2023$genre))

Here is a list of some of my top rated books in 2023:

library(dplyr)
Lara_Books_Read...2023 %>% 
  filter(rating==5)
##                                              title            author pub_year
## 1                               Blacktop Wasteland        S.A. Cosby     2020
## 2                The Cabin at the End of the World     Paul Tremblay     2018
## 3                       A Psalm for the Wild-Built    Becky Chambers     2021
## 4                      Where All LIght Tends to Go         David Joy     2015
## 5                          Smoke Gets in Your Eyes   Caitlin Doughty     2014
## 6                      How to Sell a Haunted House     Grady Hendrix     2023
## 7                               Legends and Lattes    Travis Baldree     2022
## 8                                  Nettle and Bone     T. Kingfisher     2022
## 9                           In the LIves of Pupets        T.J. Klune     2023
## 10                               The Hollow Places     T. Kingfisher     2020
## 11         The Wisteria Society of Lady Scoundrels      India Holton     2021
## 12                                 Lock Every Door       Riley Sager     2019
## 13                               The Only One Left       Riley Sager     2023
## 14                            Silence for the Dead  Simone St. James     2014
## 15                                The Perfect Liar       Debra Lynch     2020
## 16                                  The Night Ship         Jess Kidd     2022
## 17                                         Untamed     Glennon Doyle     2020
## 18                             I'll Stop the World     Lauren Thoman     2023
## 19                         The Cat Who Saved Books  Sosuke Natsukawa     2017
## 20                               My Darkest Prayer        S.A. Cosby     2019
## 21            A Wizard's Guide to Defensive Baking      T.Kingfisher     2020
## 22 Hard-Boiled Wonderland and the End of the World   Haruki Murakami     1985
## 23                                 The House Witch         Delemhach     2022
## 24                      A Prayer for the Crown-Shy    Becky Chambers     2022
##    page_count date_completed rating              genre owned
## 1         304      1/22/2023      5            fiction   yes
## 2         272       2/1/2023      5            fiction   yes
## 3         174      2/19/2023      5            fantasy   yes
## 4         304       4/3/2023      5            fiction   yes
## 5         272       4/8/2023      5        non-fiction   yes
## 6         419      4/17/2023      5             horror   yes
## 7         305      4/23/2023      5            fantasy   yes
## 8         243      5/22/2023      5            fantasy   yes
## 9         420       6/9/2023      5            fantasy   yes
## 10        341       7/4/2023      5            fantasy   yes
## 11        339      7/20/2023      5            fantasy   yes
## 12        400       8/2/2023      5           thriller   yes
## 13        383       8/5/2023      5           thriller   yes
## 14        384      8/11/2023      5            mystery   yes
## 15        315      8/12/2023      5           thriller    no
## 16        400      8/18/2023      5 historical fiction   yes
## 17        349      8/24/2023      5        non-fiction   yes
## 18        446      9/11/2023      5            fiction   yes
## 19        198      9/22/2023      5            fantasy   yes
## 20        267      9/24/2023      5            fiction   yes
## 21        306     11/11/2023      5            fantasy    no
## 22        400     11/19/2023      5            fantasy   yes
## 23        468     11/23/2023      5            fantasy   yes
## 24        152     12/15/2023      5            fantasy   yes

Clearly, I am a mood reader! Here is a scatterplot of all the books I read by genre and overall rating:

library(ggplot2)
ggplot(data=Lara_Books_Read...2023)+
geom_point(mapping=aes(x=date_completed,y=rating,color=genre))

As stated in my introduction. This dataset was an exercise but I had such a good time compiling and manipulating the data I just couldn’t stop. Feel free to use this as a starting point for your own reading journey.

For a little extra fun, here is a tableau version of the scatterplot data for you to play with…