Candy Clean-up
David Rucinski
2019 December 8th
Objective
Clean up this somewhat messy data, and try some html stylizing.
Variable names have square brackets, I would like to remove that and any column with too much missing data.
The ‘Age’ variable had all of its input as a character/string class/type and thus not numeric. With no limit people had answered with “old enough” , “too old” , “>39” , “-” , “30+” , “37,” , or even three pages worth in digits of pi. With no uniform way to correct it, this was the main problem to solve.
Packages
library(data.table)
library(ggplot2)
library(dplyr)
library(plyr) # revalue()
library(readxl)
library(DataExplorer) #Mhm
library(kableExtra)Cleaning Data
Note: this is a tab bar
Data
CandayData-2015.xlsxLet’s take a look at the data, see what columns we have.
# CandyData_2014 <- read_excel("CandyData-2014.xlsx")
# glimpse(CandyData_2014)
#
# tail(CandyData_2014)
# CandyData_2014 <- CandyData_2014[-87,] #Last row looks to be the total, may use this for proportions but for now, out.
#
# names(CandyData_2014)
CandyData_2015 <- read_excel("CandyData-2015.xlsx")
head(names(CandyData_2015), 7)## [1] "Timestamp"
## [2] "How old are you?"
## [3] "Are you going actually going trick or treating yourself?"
## [4] "[Butterfinger]"
## [5] "[100 Grand Bar]"
## [6] "[Anonymous brown globs that come in black and orange wrappers]"
## [7] "[Any full-sized candy bar]"tail(names(CandyData_2015), 7)## [1] "Please estimate the degrees of separation you have from the following folks [JK Rowling]"
## [2] "Please estimate the degrees of separation you have from the following folks [Malala Yousafzai]"
## [3] "Please estimate the degrees of separation you have from the following folks [Thom Yorke]"
## [4] "Please estimate the degrees of separation you have from the following folks [JJ Abrams]"
## [5] "Please estimate the degrees of separation you have from the following folks [Hillary Clinton]"
## [6] "Please estimate the degrees of separation you have from the following folks [Donald Trump]"
## [7] "Please estimate the degrees of separation you have from the following folks [Beyoncé Knowles]"length(names(CandyData_2015))## [1] 124We got 124 variables. All the columns that have square brackets will be annoying to refer to, they also look a bit messy in the output. Let’s adjust this by just removing them.
Preprocessing
# Removing '[]' from variable names since it will be a pain to refer to them
colnames(CandyData_2015) <- gsub("\\[|\\]", "", names(CandyData_2015))
head(names(CandyData_2015), 7)## [1] "Timestamp"
## [2] "How old are you?"
## [3] "Are you going actually going trick or treating yourself?"
## [4] "Butterfinger"
## [5] "100 Grand Bar"
## [6] "Anonymous brown globs that come in black and orange wrappers"
## [7] "Any full-sized candy bar"tail(names(CandyData_2015), 7)## [1] "Please estimate the degrees of separation you have from the following folks JK Rowling"
## [2] "Please estimate the degrees of separation you have from the following folks Malala Yousafzai"
## [3] "Please estimate the degrees of separation you have from the following folks Thom Yorke"
## [4] "Please estimate the degrees of separation you have from the following folks JJ Abrams"
## [5] "Please estimate the degrees of separation you have from the following folks Hillary Clinton"
## [6] "Please estimate the degrees of separation you have from the following folks Donald Trump"
## [7] "Please estimate the degrees of separation you have from the following folks Beyoncé Knowles"
That looks better. Let’s take a look at the structure of our data and then onto the first variable (ignoring the timestamp), ‘How old are you?’ to see what kind of values we have.
A scrollable window for the first 50 records
knitr::kable(head(CandyData_2015, 50)) %>%
kable_styling(bootstrap_options = c("striped", "hover")) %>%
scroll_box(width = "900px", height = "600px")| Timestamp | How old are you? | Are you going actually going trick or treating yourself? | Butterfinger | 100 Grand Bar | Anonymous brown globs that come in black and orange wrappers | Any full-sized candy bar | Black Jacks | Bonkers | Bottle Caps | Box’o’ Raisins | Brach products (not including candy corn) | Bubble Gum | Cadbury Creme Eggs | Candy Corn | Vials of pure high fructose corn syrup, for main-lining into your vein | Candy that is clearly just the stuff given out for free at restaurants | Cash, or other forms of legal tender | Chiclets | Caramellos | Snickers | Dark Chocolate Hershey | Dental paraphenalia | Dots | Fuzzy Peaches | Generic Brand Acetaminophen | Glow sticks | Broken glow stick | Goo Goo Clusters | Good N’ Plenty | Gum from baseball cards | Gummy Bears straight up | Creepy Religious comics/Chick Tracts | Healthy Fruit | Heath Bar | Hershey’s Kissables | Hershey’s Milk Chocolate | Hugs (actual physical hugs) | Jolly Rancher (bad flavor) | Jolly Ranchers (good flavor) | Kale smoothie | Kinder Happy Hippo | Kit Kat | Hard Candy | Lapel Pins | LemonHeads | Licorice | Licorice (not black) | Lindt Truffle | Lollipops | Mars | Mary Janes | Maynards | Milk Duds | LaffyTaffy | Minibags of chips | JoyJoy (Mit Iodine) | Reggie Jackson Bar | Pixy Stix | Nerds | Nestle Crunch | Now’n’Laters | Pencils | Milky Way | Reese’s Peanut Butter Cups | Tolberone something or other | Runts | Junior Mints | Senior Mints | Mint Kisses | Mint Juleps | Mint Leaves | Peanut M&M’s | Regular M&Ms | Mint M&Ms | Ribbon candy | Rolos | Skittles | Smarties (American) | Smarties (Commonwealth) | Chick-o-Sticks (we don’t know what that is) | Spotted Dick | Starburst | Swedish Fish | Sweetums | Those odd marshmallow circus peanut things | Three Musketeers | Peterson Brand Sidewalk Chalk | Peanut Butter Bars | Peanut Butter Jars | Trail Mix | Twix | Vicodin | White Bread | Whole Wheat anything | York Peppermint Patties | Please leave any remarks or comments regarding your choices. | Please list any items not included above that give you JOY. | Please list any items not included above that give you DESPAIR. | Guess the number of mints in my hand. | Betty or Veronica? | Check all that apply: “I cried tears of sadness at the end of ____________” | “That dress* that went viral early this year - when I first saw it, it was ________” | Fill in the blank: “Taylor Swift is a force for ___________” | What is your favourite font? | If you squint really hard, the words “Intelligent Design” would look like. | Fill in the blank: “Imitation is a form of ____________” | Please estimate the degree(s) of separation you have from the following celebrities JK Rowling | Please estimate the degree(s) of separation you have from the following celebrities JJ Abrams | Please estimate the degree(s) of separation you have from the following celebrities Beyoncé | Please estimate the degree(s) of separation you have from the following celebrities Bieber | Please estimate the degree(s) of separation you have from the following celebrities Kevin Bacon | Please estimate the degree(s) of separation you have from the following celebrities Francis Bacon (1561 - 1626) | Sea-salt flavored stuff, probably chocolate, since this is the “it” flavor of the year | Necco Wafers | Which day do you prefer, Friday or Sunday? | Please estimate the degrees of separation you have from the following folks Bruce Lee | Please estimate the degrees of separation you have from the following folks JK Rowling | Please estimate the degrees of separation you have from the following folks Malala Yousafzai | Please estimate the degrees of separation you have from the following folks Thom Yorke | Please estimate the degrees of separation you have from the following folks JJ Abrams | Please estimate the degrees of separation you have from the following folks Hillary Clinton | Please estimate the degrees of separation you have from the following folks Donald Trump | Please estimate the degrees of separation you have from the following folks Beyoncé Knowles |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2015-10-23 08:46:20 | 35.0 | No | JOY | NA | DESPAIR | JOY | NA | NA | NA | NA | DESPAIR | DESPAIR | DESPAIR | NA | DESPAIR | DESPAIR | JOY | NA | NA | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | NA | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | JOY | JOY | NA | NA | JOY | NA | NA | NA | NA | JOY | JOY | NA | NA | JOY | NA | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 2.0 | Veronica | The last Republican Debate | White and gold | NA | fuck you | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 1.0 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:46:51 | 41.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | NA | NA | NA | 10.0 | Betty | The last Pixar movie I saw | Blue and black | NA | arial | “Bullsh*t!" | Laziness | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:47:34 | 33.0 | No | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | NA | Butterscotch, Mike & Ike | Salmiakki | 4.0 | Betty | The last Pixar movie I saw | Blue and black | NA | Proggy Clean | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:47:58 | 31.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | NA | NA | NA | 5.0 | Veronica | The last Pixar movie I saw | White and gold | NA | georgia | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:48:11 | 30.0 | No | NA | JOY | DESPAIR | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | JOY | NA | JOY | NA | NA | NA | JOY | JOY | NA | JOY | NA | NA | NA | NA | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | JOY | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | JOY | NA | NA | NA | NA | JOY | NA | NA | NA | NA | JOY | NA | NA | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | sour patch kids | NA | 0.0 | ??? | The last Pixar movie I saw, The last Republican Debate | White and gold | NA | verdana | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:49:06 | 38.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | NA | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | NA | NA | NA | 2.0 | Betty | The last Republican Debate | Blue and black | NA | Calibri | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:50:08 | 48.0 | No | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | NA | Sno-Caps | NA | 0.0 | Veronica | NA | Blue and black | NA | century gothic | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 2.0 | 2.0 | 2.0 | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:52:14 | 39.0 | No | DESPAIR | JOY | DESPAIR | NA | NA | NA | JOY | NA | NA | NA | DESPAIR | NA | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | NA | JOY | NA | JOY | NA | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | NA | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | NA | JOY | JOY | JOY | NA | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | NA | JOY | NA | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | NA | NA | NA | JOY | JOY | NA | DESPAIR | JOY | JOY | JOY | NA | JOY | JOY | NA | DESPAIR | DESPAIR | JOY | NA | NA | NA | 12.0 | Betty | NA | Blue and black | NA | winddings | “Interior Design” | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:52:22 | 9.0E22 | Yes | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | NA | NA | 5.0 | Betty | The last Pixar movie I saw, Star Wars: The Phantom Menace, The last Republican Debate | Blue and black | NA | comic sans | “Bullsh*t!" | Flattery | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | DESPAIR | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:53:30 | 54.0 | No | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | NA | NA | NA | 7.0 | Betty | The last Pixar movie I saw, The last Republican Debate | Blue and black | NA | Comic sans | Intaglio Defined | Flattery | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 2.0 | 3 or higher | JOY | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:54:15 | 40.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | NA | NA | NA | 4.0 | Betty | The last Pixar movie I saw | White and gold | NA | Calibri | I tailgate tonight! | Lazily flattering someone | 2.0 | 2.0 | 3 or higher | 2.0 | 2.0 | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:54:15 | 38.0 | No | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | NA | Take 5 | Popcorn Ball | 10.0 | ??? | The last Republican Debate | Blue and black | NA | Amazon’s New Font | “Bullsh*t!" | Laziness | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:54:56 | 33.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | JOY | NA | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | NA | NA | NA | 5.0 | ??? | NA | White and gold | NA | courier new | “Bullsh*t!" | Flattery | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:55:00 | 36.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | NA | NA | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | NA | DESPAIR | JOY | DESPAIR | JOY | NA | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | NA | JOY | JOY | DESPAIR | DESPAIR | JOY | WHERE ARE THE @\(^\)$#! TOOTSIE ROLLS??? My passwords are: oh thank god Google told me to delete those. Close call! | wrapped gummy bears, cinnamon bears, three little bears, mounds, payday | Anything home made, tootsie rolls, toostie pops, blow pops | 0.0 | ??? | NA | Blue and black | NA | Times new roman | “Interior Design” | Laziness | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:55:06 | 47.0 | No | JOY | NA | DESPAIR | NA | NA | NA | NA | DESPAIR | NA | DESPAIR | JOY | JOY | NA | DESPAIR | NA | DESPAIR | JOY | JOY | NA | DESPAIR | NA | NA | NA | JOY | DESPAIR | NA | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | NA | NA | JOY | DESPAIR | NA | DESPAIR | NA | JOY | NA | DESPAIR | NA | DESPAIR | DESPAIR | NA | NA | DESPAIR | NA | NA | DESPAIR | DESPAIR | NA | NA | NA | JOY | DESPAIR | NA | NA | DESPAIR | NA | JOY | NA | DESPAIR | DESPAIR | DESPAIR | NA | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | DESPAIR | NA | NA | NA | NA | 4.0 | Veronica | Star Wars: The Phantom Menace, The last Republican Debate | White and gold | NA | Nebuchadnezzar | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 2.0 | 3 or higher | 3 or higher | 2.0 | 3 or higher | DESPAIR | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:56:20 | 60.0 | Yes | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | NA | bounty bars | NA | 16.0 | Veronica | The last Republican Debate | White and gold | NA | creaky frank | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 2.0 | 2.0 | 2.0 | 1.0 | 1.0 | JOY | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:56:25 | 34.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | NA | JOY | NA | almond joy | caramel apple | 42.0 | Veronica | The last US Election, The last Republican Debate | Blue and black | NA | ariel | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 1.0 | 3 or higher | 1.0 | 1.0 | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:57:21 | 44.0 | Yes | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | NA | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | NA | NA | NA | No | Veronica | NA | White and gold | NA | Optima | Stupidity | Flattery | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:57:58 | 46.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | NA | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | NA | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | NA | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | NA | NA | 6.0 | Veronica | The last Pixar movie I saw | White and gold | NA | NA | “Interior Design” | Laziness | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | DESPAIR | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:58:14 | 34.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | NA | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | NA | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | NA | JOY | JOY | NA | NA | DESPAIR | JOY | NA | NA | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | NA | NA | NA | 3.0 | Veronica | The last Republican Debate | NA | NA | Huxley Titling | “Bullsh*t!" | Lazily flattering someone | 2.0 | 3 or higher | 2.0 | 3 or higher | 1.0 | 1.0 | DESPAIR | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:58:41 | 46.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | NA | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | NA | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | NA | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | NA | NA | 6.0 | Veronica | The last Pixar movie I saw | White and gold | NA | NA | “Interior Design” | Laziness | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | DESPAIR | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:59:19 | 47.0 | No | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | NA | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY |
“Anonymous Brown Globs in Black & Orange Wrappers” are molasses candies, and they’re awesome if fresh and soft (if they’re old and hard, not so much). Baseball cards haven’t had gum with them for decades. |
Jelly Belly’s | WarHeads | 6.0 | Veronica | Star Wars: The Phantom Menace | Blue and black | NA | Starfleet Bold Extended | “Interior Design” | Flattery | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | DESPAIR | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 08:59:39 | 52.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | The Fault in Our Stars, The last Pixar movie I saw, Star Wars: The Phantom Menace, The last US Election, The last Republican Debate | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:00:13 | 38.0 | No | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | I used to love the weird detritus that people would hand out instead of candy, especially weird pencils and 25 cent toys. In my teens I would visit the crazy Christians multiple times to get tracts to cut up and paste together into offensive zines. | Stickers | NA | 8.0 | Veronica | The last Republican Debate | White and gold | NA | monaco | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:00:23 | 33.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | NA | NA | 3.0 | Veronica | The last Pixar movie I saw | White and gold | NA | Arial | “Bullsh*t!" | Laziness | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | DESPAIR | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:00:41 | 44.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | NA | Pearson’s Salted Nut Roll | old jelly beans | 12.0 | Betty | The last Republican Debate | White and gold | NA | garamond | “Interior Design” | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 2.0 | JOY | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:00:54 | 37.0 | No | JOY | JOY | DESPAIR | JOY | NA | NA | NA | DESPAIR | NA | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | NA | NA | NA | JOY | DESPAIR | NA | NA | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | NA | JOY | NA | DESPAIR | JOY | DESPAIR | DESPAIR | NA | DESPAIR | JOY | NA | NA | DESPAIR | DESPAIR | JOY | NA | NA | JOY | JOY | JOY | NA | DESPAIR | JOY | JOY | JOY | NA | NA | NA | JOY | JOY | NA | JOY | JOY | JOY | NA | NA | JOY | JOY | NA | NA | NA | NA | NA | NA | JOY | NA | NA | NA | NA | NA | JOY | JOY | DESPAIR | DESPAIR | JOY | NA | NA | NA | 3.0 | NA | The last Republican Debate | White and gold | NA | Trade Gothic | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:01:35 | 33.0 | No | NA | NA | DESPAIR | JOY | NA | NA | NA | JOY | DESPAIR | DESPAIR | JOY | JOY | NA | NA | JOY | DESPAIR | JOY | DESPAIR | JOY | NA | JOY | DESPAIR | NA | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | NA | NA | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | NA | DESPAIR | NA | JOY | JOY | NA | NA | NA | JOY | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | NA | JOY | JOY | NA | NA | JOY | JOY | JOY | NA | NA | DESPAIR | JOY | JOY | NA | DESPAIR | JOY | NA | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | A lot of this is nostalgic. I have a mantra from Neil from the Young Ones that I only sometimes follow: “Sugar rots your teeth and gives you brain damage.” | Whatchamacallit. Do they still make those? | I’m just going to say Good and Plenty again because YUCK | 3.14 | ??? | NA | White and gold | NA | I use comic sans and papyrus at work just to piss off my co-workers | I liek turtles | Lazily flattering someone | 1.0 | NA | NA | NA | NA | 1.0 | DESPAIR | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:01:47 | 57.0 | No | JOY | NA | DESPAIR | JOY | DESPAIR | NA | NA | DESPAIR | NA | NA | JOY | JOY | NA | DESPAIR | JOY | DESPAIR | NA | JOY | NA | DESPAIR | JOY | JOY | NA | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | NA | JOY | NA | NA | NA | NA | JOY | DESPAIR | NA | JOY | NA | NA | JOY | DESPAIR | DESPAIR | JOY | NA | JOY | JOY | NA | NA | DESPAIR | NA | NA | JOY | JOY | NA | JOY | NA | NA | JOY | JOY | JOY | NA | NA | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | NA | DESPAIR | JOY | JOY | JOY | NA | NA | DESPAIR | JOY | NA | NA | DESPAIR | NA | NA | JOY | NA | NA | JOY | JOY | NA | NA | NA | As a person who distributes rather than collects I have found it critical to purchase the kind of candy you will not mind eating yourself if there are leftovers. | turtles and turtle imitators, almond joy | sno caps, cookies in a plastic bag | 7.0 | Veronica | The last Pixar movie I saw | White and gold | NA | Verdana | “Interior Design” | Lazily flattering someone | 3 or higher | 3 or higher | 1.0 | 3 or higher | 2.0 | 2.0 | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:01:51 | 32.0 | No | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | NA | Nutella | stale popcorn ball | 8.0 | Veronica | The last Pixar movie I saw | Blue and black | NA | helvetica | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 2.0 | 3 or higher | 2.0 | 1.0 | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:02:17 | 45.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | NA | Colorado MJ Candy | Lightbulbs | 6.0 | Veronica | The last Pixar movie I saw | White and gold | NA | courier new | NA | Flattery | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:02:29 | 38.0 | No | DESPAIR | NA | NA | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | NA | caramels | pennies | 4.0 | ??? | Star Wars: The Phantom Menace | Blue and black | NA | Helvetica | “Bullsh*t!" | Laziness | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:02:30 | 58.0 | Yes | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | NA | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | NA | NA | NA | 5.0 | Veronica | The last Republican Debate | Blue and black | NA | any | “Bullsh*t!" | Laziness | 1.0 | 2.0 | 3 or higher | 3 or higher | 3 or higher | 1.0 | DESPAIR | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:03:50 | 43.0 | No | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | NA | NA | NA | 4.0 | Betty | The Fault in Our Stars, The last Pixar movie I saw | White and gold | NA | Hack | “Interior Design” | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 2.0 | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:04:38 | 45.0 | Yes | JOY | JOY | DESPAIR | JOY | DESPAIR | NA | NA | NA | NA | JOY | NA | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | NA | NA | DESPAIR | NA | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | NA | JOY | NA | NA | NA | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | NA | JOY | JOY | NA | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | NA | NA | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | NA | NA | NA | 4.0 | Veronica | The last Pixar movie I saw | Blue and black | NA | NA | “Bullsh*t!" | Flattery | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 1.0 | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:05:03 | 60.0 | No | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | NA | NA | NA | NA | Betty | The last Republican Debate | Blue and black | NA | ventana | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | DESPAIR | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:05:17 | NA | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | NA | NA | NA | 0.0 | Veronica | The last Pixar movie I saw | NA | NA | NA | NA | Laziness | NA | NA | NA | NA | NA | NA | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:05:32 | 49.0 | No | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | NA | JOY | Did I mention the Pop Rocks? We give out Pop Rocks every year: the kids are mystified at first until their parents suddenly light up “OH! POP ROCKS! These are so cool! I remember these!” | Pop Rocks | Rain | 2.0 | Veronica | The last Pixar movie I saw, Star Wars: The Phantom Menace | White and gold | NA | Caslon Antique | “Bullsh*t!" | Flattery | 3 or higher | 2.0 | 3 or higher | 3 or higher | 3 or higher | 2.0 | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:05:42 | 34.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | NA | NA | NA | NA | Veronica | The last Pixar movie I saw | White and gold | NA | NA | NA | Flattery | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | DESPAIR | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:06:38 | NA | No | JOY | NA | DESPAIR | JOY | NA | NA | JOY | DESPAIR | NA | NA | JOY | DESPAIR | NA | DESPAIR | JOY | JOY | NA | JOY | JOY | DESPAIR | NA | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:07:14 | 36.0 | No | JOY | JOY | DESPAIR | JOY | NA | NA | NA | DESPAIR | NA | NA | JOY | DESPAIR | NA | NA | JOY | DESPAIR | JOY | JOY | JOY | NA | NA | NA | DESPAIR | NA | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | NA | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | NA | JOY | NA | JOY | JOY | NA | JOY | NA | JOY | NA | NA | NA | JOY | JOY | DESPAIR | NA | JOY | JOY | JOY | NA | JOY | NA | NA | JOY | NA | JOY | JOY | JOY | DESPAIR | JOY | NA | JOY | NA | JOY | NA | JOY | JOY | NA | DESPAIR | JOY | NA | NA | NA | NA | NA | NA | DESPAIR | DESPAIR | JOY |
Those peanut-shaped marshmallow things are the most hideous candy ever created. All chocolate candy bars are good, but Snickers are the finest and most delicious of all. 3 Musketeers are really fun to put in the microwave. DUDE. WHERE ARE THE POPROCKS? |
Microwave popcorn | Wax lips | 12.0 | Veronica | The last Pixar movie I saw | Blue and black | NA | Garamond | “Bullsh*t!" | Laziness | 1.0 | 2.0 | 3 or higher | 3 or higher | 3 or higher | 3 or higher | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:07:30 | 47.0 | No | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | NA | Sour stuff | NA | 13.0 | Veronica | The last US Election, The last Republican Debate | Blue and black | NA | The Trevi is nice | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:07:44 | 52.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | NA | Almond Joy, Mounds | Dog poop | 9.0 | Veronica | The last Republican Debate | Blue and black | NA | Ransom Note | indecent exposure | Lazily flattering someone | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:08:07 | 30.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | NA | Weed | Halloween violence | 2.0 | Veronica | The last Republican Debate | Blue and black | NA | Kingthings Trypewriter | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 1.0 | 2.0 | 3 or higher | 1.0 | 3 or higher | JOY | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:08:25 | 54.0 | No | JOY | JOY | DESPAIR | JOY | NA | NA | JOY | DESPAIR | NA | NA | JOY | NA | NA | NA | JOY | NA | JOY | JOY | JOY | DESPAIR | NA | NA | NA | JOY | NA | NA | NA | NA | NA | NA | DESPAIR | JOY | NA | JOY | NA | JOY | JOY | DESPAIR | NA | JOY | JOY | NA | JOY | NA | NA | NA | JOY | JOY | NA | NA | NA | NA | NA | NA | JOY | JOY | JOY | JOY | NA | DESPAIR | JOY | JOY | JOY | NA | JOY | NA | NA | NA | NA | JOY | JOY | JOY | NA | JOY | JOY | JOY | NA | NA | DESPAIR | JOY | NA | NA | NA | JOY | NA | NA | NA | NA | JOY | JOY | NA | DESPAIR | NA | Single serve pork rind packets should be a thing on Halloween. | NA | NA | 3.0 | Veronica | The last Pixar movie I saw | White and gold | NA | Times Roman | Twix | Laziness | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | NA | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:09:13 | 64.0 | No | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | NA | Marshmallow (Peeps) Ghosts | Aging | 7.0 | Veronica | The Fault in Our Stars | White and gold | NA | Helvetica | “Bullsh*t!" | Laziness | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | DESPAIR | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:09:18 | 26.0 | No | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | JOY | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | NA | blowpop, airheads, cowtails | candy corn pumpkins, | 3.0 | Betty | The last US Election, The last Republican Debate | Blue and black | NA | Comic Sans | “Bullsh*t!" | Laziness | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 1.0 | JOY | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:09:33 | 64.0 | No | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | DESPAIR | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | NA | Marshmallow (Peeps) Ghosts | Aging | 7.0 | Veronica | The Fault in Our Stars | White and gold | NA | Helvetica | “Bullsh*t!" | Laziness | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | DESPAIR | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:10:49 | 46.0 | Yes | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | JOY | DESPAIR | JOY | JOY | JOY | JOY | JOY | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | NA | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | NA | Good chocolate | Stickers | 6.0 | Veronica | NA | Blue and black | NA | Times New Roman | “Bullsh*t!" | Flattery | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 3 or higher | 2.0 | DESPAIR | DESPAIR | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| 2015-10-23 09:10:54 | 53.0 | No | JOY | JOY | JOY | JOY | JOY | NA | DESPAIR | NA | DESPAIR | JOY | NA | DESPAIR | NA | DESPAIR | JOY | NA | JOY | JOY | NA | DESPAIR | NA | DESPAIR | JOY | DESPAIR | DESPAIR | JOY | JOY | DESPAIR | DESPAIR | JOY | DESPAIR | DESPAIR | DESPAIR | JOY | DESPAIR | NA | JOY | DESPAIR | DESPAIR | NA | NA | JOY | NA | JOY | NA | JOY | NA | JOY | JOY | NA | DESPAIR | DESPAIR | DESPAIR | NA | NA | NA | DESPAIR | NA | NA | DESPAIR | NA | JOY | JOY | DESPAIR | JOY | NA | NA | JOY | JOY | JOY | NA | NA | DESPAIR | JOY | DESPAIR | DESPAIR | NA | NA | DESPAIR | DESPAIR | NA | DESPAIR | DESPAIR | NA | NA | JOY | JOY | NA | NA | JOY | NA | DESPAIR | JOY | NA | Squirrel Nut Chews, Payday bars, Condoms, Garret’s Chicago mix | apples. Carmel corn (not Garret’s) | 0.0 | Betty | The last Republican Debate | White and gold | NA | Proxy 6 | “Bullsh*t!" | Lazily flattering someone | 3 or higher | 3 or higher | 2.0 | 3 or higher | 2.0 | 1.0 | JOY | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
glimpse(CandyData_2015)## Observations: 5,630
## Variables: 124
## $ Timestamp <dttm> ...
## $ `How old are you?` <chr> ...
## $ `Are you going actually going trick or treating yourself?` <chr> ...
## $ Butterfinger <chr> ...
## $ `100 Grand Bar` <chr> ...
## $ `Anonymous brown globs that come in black and orange wrappers` <chr> ...
## $ `Any full-sized candy bar` <chr> ...
## $ `Black Jacks` <chr> ...
## $ Bonkers <chr> ...
## $ `Bottle Caps` <chr> ...
## $ `Box’o’ Raisins` <chr> ...
## $ `Brach products (not including candy corn)` <chr> ...
## $ `Bubble Gum` <chr> ...
## $ `Cadbury Creme Eggs` <chr> ...
## $ `Candy Corn` <chr> ...
## $ `Vials of pure high fructose corn syrup, for main-lining into your vein` <chr> ...
## $ `Candy that is clearly just the stuff given out for free at restaurants` <chr> ...
## $ `Cash, or other forms of legal tender` <chr> ...
## $ Chiclets <chr> ...
## $ Caramellos <chr> ...
## $ Snickers <chr> ...
## $ `Dark Chocolate Hershey` <chr> ...
## $ `Dental paraphenalia` <chr> ...
## $ Dots <chr> ...
## $ `Fuzzy Peaches` <chr> ...
## $ `Generic Brand Acetaminophen` <chr> ...
## $ `Glow sticks` <chr> ...
## $ `Broken glow stick` <chr> ...
## $ `Goo Goo Clusters` <chr> ...
## $ `Good N' Plenty` <chr> ...
## $ `Gum from baseball cards` <chr> ...
## $ `Gummy Bears straight up` <chr> ...
## $ `Creepy Religious comics/Chick Tracts` <chr> ...
## $ `Healthy Fruit` <chr> ...
## $ `Heath Bar` <chr> ...
## $ `Hershey’s Kissables` <chr> ...
## $ `Hershey’s Milk Chocolate` <chr> ...
## $ `Hugs (actual physical hugs)` <chr> ...
## $ `Jolly Rancher (bad flavor)` <chr> ...
## $ `Jolly Ranchers (good flavor)` <chr> ...
## $ `Kale smoothie` <chr> ...
## $ `Kinder Happy Hippo` <chr> ...
## $ `Kit Kat` <chr> ...
## $ `Hard Candy` <chr> ...
## $ `Lapel Pins` <chr> ...
## $ LemonHeads <chr> ...
## $ Licorice <chr> ...
## $ `Licorice (not black)` <chr> ...
## $ `Lindt Truffle` <chr> ...
## $ Lollipops <chr> ...
## $ Mars <chr> ...
## $ `Mary Janes` <chr> ...
## $ Maynards <chr> ...
## $ `Milk Duds` <chr> ...
## $ LaffyTaffy <chr> ...
## $ `Minibags of chips` <chr> ...
## $ `JoyJoy (Mit Iodine)` <chr> ...
## $ `Reggie Jackson Bar` <chr> ...
## $ `Pixy Stix` <chr> ...
## $ Nerds <chr> ...
## $ `Nestle Crunch` <chr> ...
## $ `Now'n'Laters` <chr> ...
## $ Pencils <chr> ...
## $ `Milky Way` <chr> ...
## $ `Reese’s Peanut Butter Cups` <chr> ...
## $ `Tolberone something or other` <chr> ...
## $ Runts <chr> ...
## $ `Junior Mints` <chr> ...
## $ `Senior Mints` <chr> ...
## $ `Mint Kisses` <chr> ...
## $ `Mint Juleps` <chr> ...
## $ `Mint Leaves` <chr> ...
## $ `Peanut M&M’s` <chr> ...
## $ `Regular M&Ms` <chr> ...
## $ `Mint M&Ms` <chr> ...
## $ `Ribbon candy` <chr> ...
## $ Rolos <chr> ...
## $ Skittles <chr> ...
## $ `Smarties (American)` <chr> ...
## $ `Smarties (Commonwealth)` <chr> ...
## $ `Chick-o-Sticks (we don’t know what that is)` <chr> ...
## $ `Spotted Dick` <chr> ...
## $ Starburst <chr> ...
## $ `Swedish Fish` <chr> ...
## $ Sweetums <chr> ...
## $ `Those odd marshmallow circus peanut things` <chr> ...
## $ `Three Musketeers` <chr> ...
## $ `Peterson Brand Sidewalk Chalk` <chr> ...
## $ `Peanut Butter Bars` <chr> ...
## $ `Peanut Butter Jars` <chr> ...
## $ `Trail Mix` <chr> ...
## $ Twix <chr> ...
## $ Vicodin <chr> ...
## $ `White Bread` <chr> ...
## $ `Whole Wheat anything` <chr> ...
## $ `York Peppermint Patties` <chr> ...
## $ `Please leave any remarks or comments regarding your choices.` <chr> ...
## $ `Please list any items not included above that give you JOY.` <chr> ...
## $ `Please list any items not included above that give you DESPAIR.` <chr> ...
## $ `Guess the number of mints in my hand.` <chr> ...
## $ `Betty or Veronica?` <chr> ...
## $ `Check all that apply: "I cried tears of sadness at the end of ____________"` <chr> ...
## $ `"That dress* that went viral early this year - when I first saw it, it was ________"` <chr> ...
## $ `Fill in the blank: "Taylor Swift is a force for ___________"` <lgl> ...
## $ `What is your favourite font?` <chr> ...
## $ `If you squint really hard, the words "Intelligent Design" would look like.` <chr> ...
## $ `Fill in the blank: "Imitation is a form of ____________"` <chr> ...
## $ `Please estimate the degree(s) of separation you have from the following celebrities JK Rowling` <chr> ...
## $ `Please estimate the degree(s) of separation you have from the following celebrities JJ Abrams` <chr> ...
## $ `Please estimate the degree(s) of separation you have from the following celebrities Beyoncé` <chr> ...
## $ `Please estimate the degree(s) of separation you have from the following celebrities Bieber` <chr> ...
## $ `Please estimate the degree(s) of separation you have from the following celebrities Kevin Bacon` <chr> ...
## $ `Please estimate the degree(s) of separation you have from the following celebrities Francis Bacon (1561 - 1626)` <chr> ...
## $ `Sea-salt flavored stuff, probably chocolate, since this is the "it" flavor of the year` <chr> ...
## $ `Necco Wafers` <chr> ...
## $ `Which day do you prefer, Friday or Sunday?` <chr> ...
## $ `Please estimate the degrees of separation you have from the following folks Bruce Lee` <lgl> ...
## $ `Please estimate the degrees of separation you have from the following folks JK Rowling` <lgl> ...
## $ `Please estimate the degrees of separation you have from the following folks Malala Yousafzai` <lgl> ...
## $ `Please estimate the degrees of separation you have from the following folks Thom Yorke` <lgl> ...
## $ `Please estimate the degrees of separation you have from the following folks JJ Abrams` <lgl> ...
## $ `Please estimate the degrees of separation you have from the following folks Hillary Clinton` <lgl> ...
## $ `Please estimate the degrees of separation you have from the following folks Donald Trump` <lgl> ...
## $ `Please estimate the degrees of separation you have from the following folks Beyoncé Knowles` <lgl> ...
So other than the timestamp as a date class, everything is a string of characters including the age variable.
Let’s take a glance at the age responses, we can do a count for frequency.
count(CandyData_2015$`How old are you?`) %>%
arrange(desc(freq)) %>%
knitr::kable() %>%
kable_styling(bootstrap_options = c("striped", "hover")) %>%
row_spec(100, bold = T, color = "white", background = "#D7261E") %>%
scroll_box(width = "900px", height = "400px")| x | freq |
|---|---|
| 35.0 | 241 |
| 30.0 | 239 |
| 32.0 | 224 |
| 31.0 | 218 |
| 33.0 | 217 |
| 34.0 | 214 |
| NA | 200 |
| 45.0 | 190 |
| 29.0 | 181 |
| 27.0 | 179 |
| 36.0 | 167 |
| 28.0 | 166 |
| 40.0 | 161 |
| 37.0 | 160 |
| 38.0 | 158 |
| 26.0 | 155 |
| 44.0 | 133 |
| 42.0 | 132 |
| 39.0 | 129 |
| 46.0 | 126 |
| 43.0 | 125 |
| 25.0 | 118 |
| 24.0 | 117 |
| 41.0 | 116 |
| 50.0 | 97 |
| 47.0 | 88 |
| 23.0 | 77 |
| 22.0 | 74 |
| 48.0 | 74 |
| 52.0 | 74 |
| 49.0 | 68 |
| 51.0 | 66 |
| 21.0 | 62 |
| 53.0 | 55 |
| 54.0 | 54 |
| 55.0 | 51 |
| 58.0 | 51 |
| 20.0 | 47 |
| 57.0 | 44 |
| 19.0 | 42 |
| 18.0 | 37 |
| 56.0 | 37 |
| 17.0 | 27 |
| 59.0 | 27 |
| 60.0 | 26 |
| 13.0 | 25 |
| 62.0 | 24 |
| 16.0 | 21 |
| 67.0 | 19 |
| 61.0 | 18 |
| 64.0 | 17 |
| 65.0 | 16 |
| 14.0 | 15 |
| 63.0 | 13 |
| 66.0 | 13 |
| 12.0 | 12 |
| 15.0 | 10 |
| 70.0 | 10 |
| 69.0 | 9 |
| 9.0 | 9 |
| 11.0 | 8 |
| old | 8 |
| too old | 6 |
| Too old | 6 |
| 10.0 | 5 |
| 68.0 | 5 |
| 71.0 | 5 |
| 72.0 | 5 |
| Old | 5 |
| very | 5 |
| 6.0 | 4 |
| 8.0 | 4 |
| old enough | 4 |
| 100.0 | 3 |
| 74.0 | 3 |
| 75.0 | 3 |
| 350.0 | 2 |
| 46: | 2 |
| 7.0 | 2 |
| 99.0 | 2 |
| enough | 2 |
| older than dirt | 2 |
| – | 1 |
| >39 | 1 |
| 0.0 | 1 |
| 0.62 | 1 |
| 108.0 | 1 |
| 115.0 | 1 |
| 120.0 | 1 |
| 123.0 | 1 |
| 18.17 | 1 |
| 18.75 | 1 |
| 1880.0 | 1 |
| 2000.0 | 1 |
| 200587.0 | 1 |
| 27^ | 1 |
| 30’s | 1 |
| 30+ | 1 |
| 30s | 1 |
| 31415926535897932384626433832795028841971693993751058209749445923078164062862089986280348253421170679821480865132823066470938446095505822317253594081284811174502841027019385211055596446229489549303819644288109756659334461284756482337867831652712019091456485669234603486104543266482133936072602491412737245870066063155881748815209209628292540917153643678925903600113305305488204665213841469519415116094330572703657595919530921861173819326117931051185480744623799627495673518857527248912279381830119491298336733624406566430860213949463952247371907021798609437027705392171762931767523846748184676694051320005681271452635608277857713427577896091736371787214684409012249534301465495853710507922796892589235420199561121290219608640344181598136297747713099605187072113499999983729780499510597317328160963185950244594553469083026425223082533446850352619311881710100031378387528865875332083814206171776691473035982534904287554687311595628638823537875937519577818577805321712268066130019278766111959092164201989380952572010654858632788659361533818279682303019520353018529689957736225994138912497217752834791315155748572424541506959508295331168617278558890750983817546374649393192550604009277016711390098488240128583616035637076601047101819429555961989467678374494482553797747268471040475346462080466842590694912933136770289891521047521620569660240580381501935112533824300355876402474964732639141992726042699227967823547816360093417216412199245863150302861829745557067498385054945885869269956909272107975093029553211653449872027559602364806654991198818347977535663698074265425278625518184175746728909777727938000816470600161452491921732172147723501414419735685481613611573525521334757418494684385233239073941433345477624168625189835694855620992192221842725502542568876717904946016534668049886272327917860857843838279679766814541009538837863609506800642251252051173929848960841284886269456042419652850222106611863067442786220391949450471237137869609563643719172874677646575739624138908658326459958133904780275900994657640789512694683983525957098258226205224894077267194782684826014769909026401363944374553050682034962524517493996514314298091906592509372216964615157098583874105978859597729754989301617539284681382686838689427741559918559252459539594310499725246808459872736446958486538367362226260991246080512438843904512441365497627807977156914359977001296160894416948685558484063534220722258284886481584560285060168427394522674676788952521385225499546667278239864565961163548862305774564980355936345681743241125150760694794510965960940252288797108931456691368672287489405601015033086179286809208747609178249385890097149096759852613655497818931297848216829989487226588048575640142704775551323796414515237462343645428584447952658678210511413547357395231134271661021359695362314429524849371871101457654035902799344037420073105785390621983874478084784896833214457138687519435064302184531910484810053706146806749192781911979399520614196634287544406437451237181921799983910159195618146751426912397489409071864942319615679452080951465502252316038819301420937621378559566389377870830390697920773467221825625996615014215030680384477345492026054146659252014974428507325186660021324340881907104863317346496514539057962685610055081066587969981635747363840525714591028970641401109712062804390397595156771577004203378699360072305587631763594218731251471205329281918261861258673215791984148488291644706095752706957220917567116722910981690915280173506712748583222871835209353965725121083579151369882091444210067510334671103141267111369908658516398315019701651511685171437657618351556508849099898599823873455283316355076479185358932261854896321329330898570642046752590709154814165498594616371802709819943099244889575712828905923233260972997120844335732654893823911932597463667305836041428138830320382490375898524374417029132765618093773444030707469211201913020330380197621101100449293215160842444859637669838952286847831235526582131449576857262433441893039686426243410773226978028073189154411010446823252716201052652272111660396665573092547110557853763466820653109896526918620564769312570586356620185581007293606598764861179104533488503461136576867532494416680396265797877185560845529654126654085306143444318586769751456614068007002378776591344017127494704205622305389945613140711270004078547332699390814546646458807972708266830634328587856983052358089330657574067954571637752542021149557615814002501262285941302164715509792592309907965473761255176567513575178296664547791745011299614890304639947132962107340437518957359614589019389713111790429782856475032031986915140287080859904801094121472213179476477726224142548545403321571853061422881375850430633217518297986622371721591607716692547487389866549494501146540628433663937900397692656721463853067360965712091807638327166416274888800786925602902284721040317211860820419000422966171196377921337575114959501566049631862947265473642523081770367515906735023507283540567040386743513622224771589150495309844489333096340878076932599397805419341447377441842631298608099888687413260472156951623965864573021631598193195167353812974167729478672422924654366800980676928238280689964004824354037014163149658979409243237896907069779422362508221688957383798623001593776471651228935786015881617557829735233446042815126272037343146531977774160319906655418763979293344195215413418994854447345673831624993419131814809277771038638773431772075456545322077709212019051660962804909263601975988281613323166636528619326686336062735676303544776280350450777235547105859548702790814356240145171806246436267945612753181340783303362542327839449753824372058353114771199260638133467768796959703098339130771098704085913374641442822772634659470474587847787201927715280731767907707157213444730605700733492436931138350493163128404251219256517980694113528013147013047816437885185290928545201165839341965621349143415956258658655705526904965209858033850722426482939728584783163057777560688876446248246857926039535277348030480290058760758251047470916439613626760449256274204208320856611906254543372131535958450687724602901618766795240616342522577195429162991930645537799140373404328752628889639958794757291746426357455254079091451357111369410911939325191076020825202618798531887705842972591677813149699009019211697173727847684726860849003377024242916513005005168323364350389517029893922334517220138128069650117844087451960121228599371623130171144484640903890644954440061986907548516026327505298349187407866808818338510228334508504860825039302133219715518430635455007668282949304137765527939751754613953984683393638304746119966538581538420568533862186725233402830871123282789212507712629463229563989898935821167456270102183564622013496715188190973038119800497340723961036854066431939509790190699639552453005450580685501956730229219139339185680344903982059551002263535361920419947455385938102343955449597783779023742161727111723643435439478221818528624085140066604433258885698670543154706965747458550332323342107301545940516553790686627333799585115625784322988273723198987571415957811196358330059408730681216028764962867446047746491599505497374256269010490377819868359381465741268049256487985561453723478673303904688383436346553794986419270563872931748723320837601123029911367938627089438799362016295154133714248928307220126901475466847653576164773794675200490757155527819653621323926406160136358155907422020203187277605277219005561484255518792530343513984425322341576233610642506390497500865627109535919465897514131034822769306247435363256916078154781811528436679570611086153315044521274739245449454236828860613408414863776700961207151249140430272538607648236341433462351897576645216413767969031495019108575984423919862916421939949072362346468441173940326591840443780513338945257423995082965912285085558215725031071257012668302402929525220118726767562204154205161841634847565169998116141010029960783869092916030288400269104140792886215078424516709087000699282120660418371806535567252532567532861291042487761825829765157959847035622262934860034158722980534989650226291748788202734209222245339856264766914905562842503912757710284027998066365825488926488025456610172967026640765590429099456815065265305371829412703369313785 | 1 |
| 37 (I’m taking a child) | 1 |
| 37, | 1 |
| 388.0 | 1 |
|
1 |
| 400.0 | 1 |
| 40s | 1 |
| 40something | 1 |
| 42 - I’m taking my kid | 1 |
| 44.4444 | 1 |
| 45, but the 8-year-old Huntress and bediapered Unicorn give me political cover and social respectability. However, I WILL eat more than they do combined. | 1 |
| 490.0 | 1 |
| 5 months | 1 |
| 5.0 | 1 |
| 50 (despair) | 1 |
| 50, taking a 13 year old. | 1 |
| 50+ | 1 |
| 50ish | 1 |
| 50t | 1 |
| 65+ | 1 |
| ７１＋ | 1 |
| 77.0 | 1 |
| 85.0 | 1 |
| 9.0E22 | 1 |
| 97.0 | 1 |
| a million | 1 |
| Adult | 1 |
| dadt | 1 |
| Enough | 1 |
| gofuckyourself | 1 |
| Good Lord! I’m 43! | 1 |
| In dog years? | 1 |
| Many | 1 |
| middle-aged | 1 |
| Nevermind | 1 |
| none of your business | 1 |
| Not tell | 1 |
| old but still know joy from despair | 1 |
| old enough to know better | 1 |
| old enough to party | 1 |
| Old, very old | 1 |
| Older than you | 1 |
| over 40 | 1 |
| So old | 1 |
| too | 1 |
| too old for this | 1 |
| x | 1 |
Hm.. 200 NA values, a lot of text, and someone thought it would be funny to put 8103 digits of pi.
Though this technique may miss the ‘5 months’ and return someone who is ‘5’, the person filling out the survey would not be that age. If needed to change that entry into an invalid one [0.5] it will be easy since there should only be a two values at ‘5’.
# Print
unique( as.numeric(
gsub("[^0-9.]", "",
substr(CandyData_2015$`How old are you?`,1,3)
)
)
)## [1] 35.0 41.0 33.0 31.0 30.0 38.0 48.0 39.0 9.0 54.0 40.0
## [12] 36.0 47.0 60.0 34.0 44.0 46.0 52.0 37.0 57.0 32.0 45.0
## [23] 58.0 43.0 NA 49.0 64.0 26.0 53.0 27.0 50.0 42.0 28.0
## [34] 13.0 51.0 70.0 19.0 25.0 59.0 61.0 23.0 55.0 12.0 21.0
## [45] 16.0 56.0 22.0 6.0 29.0 24.0 8.0 20.0 188.0 15.0 71.0
## [56] 75.0 18.0 17.0 63.0 65.0 62.0 69.0 67.0 66.0 74.0 10.0
## [67] 72.0 200.0 14.0 11.0 68.0 99.0 5.0 7.0 77.0 100.0 115.0
## [78] 123.0 388.0 120.0 314.0 0.6 108.0 350.0 400.0 85.0 97.0 490.0
## [89] 0.0# Saving object
CandyData_2015$`How old are you?` <-
as.numeric(
gsub("[^0-9.]", "",
substr(CandyData_2015$`How old are you?`,1,3)
)
)
These are the unique values after removing the text and taking the first 3 characters that are numeric in the response including the decimal. Which means anyone who answered as 40.5 or 40.3 would be reduced to 40.0, including responses where something like ‘46 but taking 11 yr old’ will result in 46.0.
(I doubt anyone over 100 would want to fill out a survey like this so we will use it as an end point) Any values exceeding 100 or NA can be seen as an invalid response, but there are some people who may not wish to actually share their actual age and some given the option to joke will do so. Though the age may be invalid the rest of the survey may but filled out honestly, and a comparison analysis could be done on that. Therefore any invalid age response will be changed to 0.5 to keep track of further analysis.
# test <- CandyData_2015$`How old are you?`
#
# test[is.na(test)] = 0.5
# unique(test)
#
# count(test) %>%
# arrange(desc(freq)) %>%
# knitr::kable()
#
#
#
# for (i in 1:length(test)){
# if (test[i] > 100){
# test[i] = 0.5
# }
# }
CandyData_2015$`How old are you?`[is.na(CandyData_2015$`How old are you?`)] = 0.5
# to handle the NA values I'll give them a value of 0.5 to recognize they are NA or any entry other than numeric
# also for any unlikely ages i.e. over 100 will be registered as NA/0.5, some people may not like giving their age. Though the age may be invalid their survey may still be.
for (i in 1:length(CandyData_2015$`How old are you?`)){
if (CandyData_2015$`How old are you?`[i] > 100 || CandyData_2015$`How old are you?`[i] < 1){
CandyData_2015$`How old are you?`[i] = 0.5
}
}
count(CandyData_2015$`How old are you?`) %>%
arrange(desc(freq)) %>%
knitr::kable() %>%
kable_styling(bootstrap_options = c("striped", "hover"), position = "left", full_width = FALSE)| x | freq |
|---|---|
| 0.5 | 277 |
| 30.0 | 242 |
| 35.0 | 241 |
| 32.0 | 224 |
| 31.0 | 218 |
| 33.0 | 217 |
| 34.0 | 214 |
| 45.0 | 191 |
| 29.0 | 181 |
| 27.0 | 180 |
| 36.0 | 167 |
| 28.0 | 166 |
| 40.0 | 164 |
| 37.0 | 162 |
| 38.0 | 158 |
| 26.0 | 155 |
| 44.0 | 134 |
| 42.0 | 133 |
| 39.0 | 130 |
| 46.0 | 128 |
| 43.0 | 125 |
| 25.0 | 118 |
| 24.0 | 117 |
| 41.0 | 116 |
| 50.0 | 102 |
| 47.0 | 88 |
| 23.0 | 77 |
| 22.0 | 74 |
| 48.0 | 74 |
| 52.0 | 74 |
| 49.0 | 68 |
| 51.0 | 66 |
| 21.0 | 62 |
| 53.0 | 55 |
| 54.0 | 54 |
| 55.0 | 51 |
| 58.0 | 51 |
| 20.0 | 47 |
| 57.0 | 44 |
| 19.0 | 42 |
| 18.0 | 39 |
| 56.0 | 37 |
| 17.0 | 27 |
| 59.0 | 27 |
| 60.0 | 26 |
| 13.0 | 25 |
| 62.0 | 24 |
| 16.0 | 21 |
| 67.0 | 19 |
| 61.0 | 18 |
| 64.0 | 17 |
| 65.0 | 17 |
| 14.0 | 15 |
| 63.0 | 13 |
| 66.0 | 13 |
| 12.0 | 12 |
| 9.0 | 10 |
| 15.0 | 10 |
| 70.0 | 10 |
| 69.0 | 9 |
| 11.0 | 8 |
| 10.0 | 5 |
| 68.0 | 5 |
| 71.0 | 5 |
| 72.0 | 5 |
| 6.0 | 4 |
| 8.0 | 4 |
| 74.0 | 3 |
| 75.0 | 3 |
| 100.0 | 3 |
| 5.0 | 2 |
| 7.0 | 2 |
| 99.0 | 2 |
| 77.0 | 1 |
| 85.0 | 1 |
| 97.0 | 1 |
# it seems a '0.6' and '0.0' has slipped by -> adjust if statement to include <1277 is now our total for invalid age responses. That’s still pretty good considering the sample. Since all the variables that refer to candy is NA/DESPAIR/JOY we can change that to numeric or as a factor to manage it better.
# For all Candy change to numeric (to sum and play around)
#
# JOY = +1
# NA = 0
# DESPAIR = -1
#
# Can create a net value and sum
names(CandyData_2015[,97:124])## [1] "Please leave any remarks or comments regarding your choices."
## [2] "Please list any items not included above that give you JOY."
## [3] "Please list any items not included above that give you DESPAIR."
## [4] "Guess the number of mints in my hand."
## [5] "Betty or Veronica?"
## [6] "Check all that apply: \"I cried tears of sadness at the end of ____________\""
## [7] "\"That dress* that went viral early this year - when I first saw it, it was ________\""
## [8] "Fill in the blank: \"Taylor Swift is a force for ___________\""
## [9] "What is your favourite font?"
## [10] "If you squint really hard, the words \"Intelligent Design\" would look like."
## [11] "Fill in the blank: \"Imitation is a form of ____________\""
## [12] "Please estimate the degree(s) of separation you have from the following celebrities JK Rowling"
## [13] "Please estimate the degree(s) of separation you have from the following celebrities JJ Abrams"
## [14] "Please estimate the degree(s) of separation you have from the following celebrities Beyoncé"
## [15] "Please estimate the degree(s) of separation you have from the following celebrities Bieber"
## [16] "Please estimate the degree(s) of separation you have from the following celebrities Kevin Bacon"
## [17] "Please estimate the degree(s) of separation you have from the following celebrities Francis Bacon (1561 - 1626)"
## [18] "Sea-salt flavored stuff, probably chocolate, since this is the \"it\" flavor of the year"
## [19] "Necco Wafers"
## [20] "Which day do you prefer, Friday or Sunday?"
## [21] "Please estimate the degrees of separation you have from the following folks Bruce Lee"
## [22] "Please estimate the degrees of separation you have from the following folks JK Rowling"
## [23] "Please estimate the degrees of separation you have from the following folks Malala Yousafzai"
## [24] "Please estimate the degrees of separation you have from the following folks Thom Yorke"
## [25] "Please estimate the degrees of separation you have from the following folks JJ Abrams"
## [26] "Please estimate the degrees of separation you have from the following folks Hillary Clinton"
## [27] "Please estimate the degrees of separation you have from the following folks Donald Trump"
## [28] "Please estimate the degrees of separation you have from the following folks Beyoncé Knowles"plot_missing(CandyData_2015)
# Most of the questions with "Please..." have missing data and the rest there is nothing of value
# to me so I will exclude it. It measures degrees of separation from famous people?
# Also will drop the Taylor Swift question as it's 100% missing values.
CandyData_2015 %>% select(contains("Please"), contains("Taylor")) %>% names()## [1] "Please leave any remarks or comments regarding your choices."
## [2] "Please list any items not included above that give you JOY."
## [3] "Please list any items not included above that give you DESPAIR."
## [4] "Please estimate the degree(s) of separation you have from the following celebrities JK Rowling"
## [5] "Please estimate the degree(s) of separation you have from the following celebrities JJ Abrams"
## [6] "Please estimate the degree(s) of separation you have from the following celebrities Beyoncé"
## [7] "Please estimate the degree(s) of separation you have from the following celebrities Bieber"
## [8] "Please estimate the degree(s) of separation you have from the following celebrities Kevin Bacon"
## [9] "Please estimate the degree(s) of separation you have from the following celebrities Francis Bacon (1561 - 1626)"
## [10] "Please estimate the degrees of separation you have from the following folks Bruce Lee"
## [11] "Please estimate the degrees of separation you have from the following folks JK Rowling"
## [12] "Please estimate the degrees of separation you have from the following folks Malala Yousafzai"
## [13] "Please estimate the degrees of separation you have from the following folks Thom Yorke"
## [14] "Please estimate the degrees of separation you have from the following folks JJ Abrams"
## [15] "Please estimate the degrees of separation you have from the following folks Hillary Clinton"
## [16] "Please estimate the degrees of separation you have from the following folks Donald Trump"
## [17] "Please estimate the degrees of separation you have from the following folks Beyoncé Knowles"
## [18] "Fill in the blank: \"Taylor Swift is a force for ___________\""Candy_2015_clean <- CandyData_2015 %>% select(-contains("Please"), -contains("Taylor"))
plot_missing(Candy_2015_clean)
Although we still have some missing values, the degree of missing values is “OK” so let’s export this data. Some functions will work better on NA, for this reason else where in the data where there is NA it will be left as is.
plot_bar(Candy_2015_clean %>%
select(-contains("Guess"), -contains("___"))
)
library(DT)
datatable(head(Candy_2015_clean), rownames = FALSE, filter="top", options = list(pageLength = 5, scrollX=T) )Export
library("openxlsx")
write.xlsx(Candy_2015_clean, file = "CandyData_2015_clean.xlsx")
write.csv(Candy_2015_clean, file = "CandyData_2015_clean.csv", row.names = FALSE)
# Since some functions deal with NA a bit differently I won't change all of them, though a simple
# dt[is.na(dt)] <- value
# in R can change all the na values to 0, 0.5, MEH etc.
Raw CSV:
CandayData_2015_clean.csv