library(tidyr)
library(dplyr)##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionlibrary(stringr)
library(ggplot2)# Get data from file I uploaded to github
theURL <- "https://raw.githubusercontent.com/bpersaud104/Data607/master/candyhierarchy2017.csv"
Candy <- read.csv(file = theURL, header = TRUE, sep = ",")
head(Candy)## Internal.ID Q1..GOING.OUT. Q2..GENDER Q3..AGE Q4..COUNTRY
## 1 90258773
## 2 90272821 No Male 44 USA
## 3 90272829 Male 49 USA
## 4 90272840 No Male 40 us
## 5 90272841 No Male 23 usa
## 6 90272852 No Male
## Q5..STATE..PROVINCE..COUNTY..ETC Q6...100.Grand.Bar
## 1
## 2 NM MEH
## 3 Virginia
## 4 or MEH
## 5 exton pa JOY
## 6 JOY
## Q6...Anonymous.brown.globs.that.come.in.black.and.orange.wrappers..a.k.a..Mary.Janes.
## 1
## 2 DESPAIR
## 3
## 4 DESPAIR
## 5 DESPAIR
## 6 DESPAIR
## Q6...Any.full.sized.candy.bar Q6...Black.Jacks Q6...Bonkers..the.candy.
## 1
## 2 JOY MEH DESPAIR
## 3
## 4 JOY MEH MEH
## 5 JOY DESPAIR MEH
## 6 JOY
## Q6...Bonkers..the.board.game. Q6...Bottle.Caps Q6...Box.o.Raisins
## 1
## 2 DESPAIR DESPAIR DESPAIR
## 3
## 4 DESPAIR MEH DESPAIR
## 5 DESPAIR MEH DESPAIR
## 6 MEH MEH
## Q6...Broken.glow.stick Q6...Butterfinger Q6...Cadbury.Creme.Eggs
## 1
## 2 DESPAIR DESPAIR MEH
## 3
## 4 DESPAIR MEH MEH
## 5 DESPAIR MEH MEH
## 6 DESPAIR JOY DESPAIR
## Q6...Candy.Corn
## 1
## 2 MEH
## 3
## 4 DESPAIR
## 5 DESPAIR
## 6 MEH
## Q6...Candy.that.is.clearly.just.the.stuff.given.out.for.free.at.restaurants
## 1
## 2 DESPAIR
## 3
## 4 DESPAIR
## 5 DESPAIR
## 6 MEH
## Q6...Caramellos Q6...Cash..or.other.forms.of.legal.tender
## 1
## 2 MEH JOY
## 3
## 4 MEH JOY
## 5 JOY MEH
## 6 JOY JOY
## Q6...Chardonnay Q6...Chick.o.Sticks..we.donÕt.know.what.that.is.
## 1
## 2 MEH DESPAIR
## 3
## 4 MEH JOY
## 5 JOY DESPAIR
## 6 JOY MEH
## Q6...Chiclets Q6...Coffee.Crisp
## 1
## 2 DESPAIR DESPAIR
## 3
## 4 MEH DESPAIR
## 5 DESPAIR MEH
## 6 MEH JOY
## Q6...Creepy.Religious.comics.Chick.Tracts Q6...Dental.paraphenalia
## 1
## 2 DESPAIR DESPAIR
## 3
## 4 DESPAIR DESPAIR
## 5 DESPAIR DESPAIR
## 6 DESPAIR MEH
## Q6...Dots Q6...Dove.Bars Q6...Fuzzy.Peaches
## 1
## 2 MEH JOY DESPAIR
## 3
## 4 JOY JOY MEH
## 5 MEH JOY DESPAIR
## 6 MEH JOY
## Q6...Generic.Brand.Acetaminophen Q6...Glow.sticks Q6...Goo.Goo.Clusters
## 1
## 2 DESPAIR DESPAIR DESPAIR
## 3
## 4 MEH JOY JOY
## 5 DESPAIR DESPAIR MEH
## 6 DESPAIR MEH JOY
## Q6...Good.N..Plenty Q6...Gum.from.baseball.cards
## 1
## 2 MEH DESPAIR
## 3
## 4 MEH DESPAIR
## 5 MEH DESPAIR
## 6 MEH DESPAIR
## Q6...Gummy.Bears.straight.up Q6...Hard.Candy Q6...Healthy.Fruit
## 1
## 2 MEH MEH DESPAIR
## 3
## 4 JOY MEH MEH
## 5 JOY MEH DESPAIR
## 6 MEH MEH MEH
## Q6...Heath.Bar Q6...Hershey.s.Dark.Chocolate
## 1
## 2 MEH JOY
## 3
## 4 DESPAIR MEH
## 5 DESPAIR JOY
## 6 JOY JOY
## Q6...HersheyÕs.Milk.Chocolate Q6...Hershey.s.Kisses
## 1
## 2 JOY MEH
## 3
## 4 MEH MEH
## 5 MEH MEH
## 6 MEH MEH
## Q6...Hugs..actual.physical.hugs. Q6...Jolly.Rancher..bad.flavor.
## 1
## 2 DESPAIR DESPAIR
## 3
## 4 MEH MEH
## 5 DESPAIR MEH
## 6 MEH MEH
## Q6...Jolly.Ranchers..good.flavor. Q6...JoyJoy..Mit.Iodine..
## 1
## 2 MEH DESPAIR
## 3
## 4 MEH DESPAIR
## 5 JOY MEH
## 6 MEH
## Q6...Junior.Mints Q6...Senior.Mints Q6...Kale.smoothie
## 1
## 2 DESPAIR DESPAIR DESPAIR
## 3
## 4 DESPAIR DESPAIR DESPAIR
## 5 JOY DESPAIR DESPAIR
## 6 JOY DESPAIR
## Q6...Kinder.Happy.Hippo Q6...Kit.Kat Q6...LaffyTaffy Q6...LemonHeads
## 1
## 2 DESPAIR JOY DESPAIR MEH
## 3
## 4 MEH MEH JOY JOY
## 5 JOY JOY JOY JOY
## 6 JOY MEH MEH
## Q6...Licorice..not.black. Q6...Licorice..yes.black. Q6...Lindt.Truffle
## 1
## 2 MEH JOY MEH
## 3
## 4 MEH JOY JOY
## 5 MEH DESPAIR JOY
## 6 MEH MEH JOY
## Q6...Lollipops Q6...Mars Q6...Maynards Q6...Mike.and.Ike Q6...Milk.Duds
## 1
## 2 DESPAIR DESPAIR DESPAIR MEH MEH
## 3
## 4 DESPAIR JOY MEH MEH DESPAIR
## 5 MEH MEH DESPAIR MEH MEH
## 6 MEH JOY JOY JOY
## Q6...Milky.Way Q6...Regular.M.Ms Q6...Peanut.M.MÕs Q6...Blue.M.M.s
## 1
## 2 JOY JOY MEH JOY
## 3
## 4 JOY MEH JOY MEH
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY JOY
## Q6...Red.M.M.s Q6...Green.Party.M.M.s Q6...Independent.M.M.s
## 1
## 2 JOY JOY JOY
## 3
## 4 MEH MEH MEH
## 5 JOY JOY JOY
## 6 JOY
## Q6...Abstained.from.M.M.ing. Q6...Minibags.of.chips Q6...Mint.Kisses
## 1
## 2 DESPAIR DESPAIR MEH
## 3
## 4 MEH DESPAIR DESPAIR
## 5 MEH DESPAIR JOY
## 6 JOY JOY
## Q6...Mint.Juleps Q6...Mr..Goodbar Q6...Necco.Wafers Q6...Nerds
## 1
## 2 DESPAIR DESPAIR DESPAIR DESPAIR
## 3
## 4 MEH MEH DESPAIR MEH
## 5 JOY MEH DESPAIR JOY
## 6 JOY JOY MEH JOY
## Q6...Nestle.Crunch Q6...Now.n.Laters Q6...Peeps Q6...Pencils
## 1
## 2 JOY DESPAIR DESPAIR DESPAIR
## 3
## 4 MEH MEH DESPAIR DESPAIR
## 5 JOY JOY MEH DESPAIR
## 6 MEH MEH DESPAIR DESPAIR
## Q6...Pixy.Stix Q6...Real.Housewives.of.Orange.County.Season.9.Blue.Ray
## 1
## 2 DESPAIR DESPAIR
## 3
## 4 DESPAIR DESPAIR
## 5 JOY DESPAIR
## 6 MEH DESPAIR
## Q6...ReeseÕs.Peanut.Butter.Cups Q6...Reese.s.Pieces
## 1
## 2 JOY JOY
## 3
## 4 JOY MEH
## 5 JOY JOY
## 6 JOY JOY
## Q6...Reggie.Jackson.Bar Q6...Rolos
## 1
## 2 DESPAIR JOY
## 3
## 4 MEH MEH
## 5 MEH JOY
## 6 DESPAIR JOY
## Q6...Sandwich.sized.bags.filled.with.BooBerry.Crunch Q6...Skittles
## 1
## 2 DESPAIR DESPAIR
## 3
## 4 DESPAIR DESPAIR
## 5 JOY
## 6 DESPAIR JOY
## Q6...Smarties..American. Q6...Smarties..Commonwealth. Q6...Snickers
## 1
## 2 DESPAIR DESPAIR MEH
## 3
## 4 DESPAIR MEH JOY
## 5 JOY DESPAIR
## 6 JOY JOY JOY
## Q6...Sourpatch.Kids..i.e..abominations.of.nature. Q6...Spotted.Dick
## 1
## 2 DESPAIR DESPAIR
## 3
## 4 MEH DESPAIR
## 5 MEH DESPAIR
## 6 DESPAIR DESPAIR
## Q6...Starburst Q6...Sweet.Tarts Q6...Swedish.Fish
## 1
## 2 MEH DESPAIR MEH
## 3
## 4 MEH MEH JOY
## 5 JOY JOY MEH
## 6 MEH MEH MEH
## Q6...Sweetums..a.friend.to.diabetes. Q6...Take.5 Q6...Tic.Tacs
## 1
## 2 DESPAIR DESPAIR DESPAIR
## 3
## 4 MEH JOY MEH
## 5 DESPAIR MEH DESPAIR
## 6 MEH
## Q6...Those.odd.marshmallow.circus.peanut.things Q6...Three.Musketeers
## 1
## 2 DESPAIR JOY
## 3
## 4 DESPAIR DESPAIR
## 5 DESPAIR JOY
## 6 DESPAIR JOY
## Q6...Tolberone.something.or.other Q6...Trail.Mix Q6...Twix
## 1
## 2 JOY DESPAIR JOY
## 3
## 4 JOY MEH JOY
## 5 JOY DESPAIR JOY
## 6 JOY MEH JOY
## Q6...Vials.of.pure.high.fructose.corn.syrup..for.main.lining.into.your.vein
## 1
## 2 DESPAIR
## 3
## 4 DESPAIR
## 5 MEH
## 6 DESPAIR
## Q6...Vicodin Q6...Whatchamacallit.Bars Q6...White.Bread
## 1
## 2 DESPAIR DESPAIR DESPAIR
## 3
## 4 JOY JOY DESPAIR
## 5 JOY JOY DESPAIR
## 6 DESPAIR JOY DESPAIR
## Q6...Whole.Wheat.anything Q6...York.Peppermint.Patties
## 1
## 2 DESPAIR DESPAIR
## 3
## 4 DESPAIR DESPAIR
## 5 DESPAIR JOY
## 6 DESPAIR JOY
## Q7..JOY.OTHER
## 1
## 2 Mounds
## 3
## 4 Reese's crispy crunchy bars, 5th avenue bars, ferrero rocher, dries fruit other than raisins
## 5
## 6
## Q8..DESPAIR.OTHER
## 1
## 2
## 3
## 4
## 5
## 6
## Q9..OTHER.COMMENTS
## 1
## 2 Bottom line is Twix is really the only candy worth eating.
## 3
## 4 Raisins can go to hell
## 5
## 6
## Q10..DRESS X Q11..DAY Q12..MEDIA..Daily.Dish. Q12..MEDIA..Science.
## 1 NA NA
## 2 White and gold Sunday NA 1
## 3 NA NA
## 4 White and gold Sunday NA 1
## 5 White and gold Friday NA 1
## 6 NA 1
## Q12..MEDIA..ESPN. Q12..MEDIA..Yahoo. Click.Coordinates..x..y.
## 1 NA NA
## 2 NA NA (84, 25)
## 3 NA NA
## 4 NA NA (75, 23)
## 5 NA NA (70, 10)
## 6 NA NA (75, 23)This is a huge dataset. It shows a survey of people who gave their opinion on what candies they liked. “Joy” means they liked the candy, “meh” means they didn’t like or hate the candy, and “despair” means they didn’t like the candy. I went through the dataset and noticed that there are some columns that list unspecific candies and some that are not even candies at all. For these columns I will be removing them since we want to analyze the data to see what candies people like.
Candy_revised <- Candy[, -c(8, 9, 12, 14, 15, 19, 21, 22, 23, 26, 27, 29, 30, 31, 32, 35, 38, 43, 46, 48, 49, 68, 69, 70, 74, 79, 81, 84, 86, 89, 92, 96, 99, 102, 104, 105, 106, 107, 108, 109, 110, 111, 113, 114, 115, 116, 117, 118, 119, 120)]
head(Candy_revised)## Internal.ID Q1..GOING.OUT. Q2..GENDER Q3..AGE Q4..COUNTRY
## 1 90258773
## 2 90272821 No Male 44 USA
## 3 90272829 Male 49 USA
## 4 90272840 No Male 40 us
## 5 90272841 No Male 23 usa
## 6 90272852 No Male
## Q5..STATE..PROVINCE..COUNTY..ETC Q6...100.Grand.Bar Q6...Black.Jacks
## 1
## 2 NM MEH MEH
## 3 Virginia
## 4 or MEH MEH
## 5 exton pa JOY DESPAIR
## 6 JOY
## Q6...Bonkers..the.candy. Q6...Bottle.Caps Q6...Butterfinger
## 1
## 2 DESPAIR DESPAIR DESPAIR
## 3
## 4 MEH MEH MEH
## 5 MEH MEH MEH
## 6 MEH JOY
## Q6...Cadbury.Creme.Eggs Q6...Candy.Corn Q6...Caramellos Q6...Chiclets
## 1
## 2 MEH MEH MEH DESPAIR
## 3
## 4 MEH DESPAIR MEH MEH
## 5 MEH DESPAIR JOY DESPAIR
## 6 DESPAIR MEH JOY MEH
## Q6...Coffee.Crisp Q6...Dots Q6...Goo.Goo.Clusters Q6...Good.N..Plenty
## 1
## 2 DESPAIR MEH DESPAIR MEH
## 3
## 4 DESPAIR JOY JOY MEH
## 5 MEH MEH MEH MEH
## 6 JOY MEH JOY MEH
## Q6...Gummy.Bears.straight.up Q6...Hard.Candy Q6...Heath.Bar
## 1
## 2 MEH MEH MEH
## 3
## 4 JOY MEH DESPAIR
## 5 JOY MEH DESPAIR
## 6 MEH MEH JOY
## Q6...Hershey.s.Dark.Chocolate Q6...HersheyÕs.Milk.Chocolate
## 1
## 2 JOY JOY
## 3
## 4 MEH MEH
## 5 JOY MEH
## 6 JOY MEH
## Q6...Hershey.s.Kisses Q6...Jolly.Rancher..bad.flavor.
## 1
## 2 MEH DESPAIR
## 3
## 4 MEH MEH
## 5 MEH MEH
## 6 MEH MEH
## Q6...Jolly.Ranchers..good.flavor. Q6...Junior.Mints
## 1
## 2 MEH DESPAIR
## 3
## 4 MEH DESPAIR
## 5 JOY JOY
## 6 MEH JOY
## Q6...Kinder.Happy.Hippo Q6...Kit.Kat Q6...LaffyTaffy Q6...LemonHeads
## 1
## 2 DESPAIR JOY DESPAIR MEH
## 3
## 4 MEH MEH JOY JOY
## 5 JOY JOY JOY JOY
## 6 JOY MEH MEH
## Q6...Licorice..not.black. Q6...Licorice..yes.black. Q6...Lindt.Truffle
## 1
## 2 MEH JOY MEH
## 3
## 4 MEH JOY JOY
## 5 MEH DESPAIR JOY
## 6 MEH MEH JOY
## Q6...Lollipops Q6...Mars Q6...Maynards Q6...Mike.and.Ike Q6...Milk.Duds
## 1
## 2 DESPAIR DESPAIR DESPAIR MEH MEH
## 3
## 4 DESPAIR JOY MEH MEH DESPAIR
## 5 MEH MEH DESPAIR MEH MEH
## 6 MEH JOY JOY JOY
## Q6...Milky.Way Q6...Regular.M.Ms Q6...Peanut.M.MÕs Q6...Blue.M.M.s
## 1
## 2 JOY JOY MEH JOY
## 3
## 4 JOY MEH JOY MEH
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY JOY
## Q6...Red.M.M.s Q6...Green.Party.M.M.s Q6...Mint.Kisses Q6...Mint.Juleps
## 1
## 2 JOY JOY MEH DESPAIR
## 3
## 4 MEH MEH DESPAIR MEH
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY
## Q6...Mr..Goodbar Q6...Nerds Q6...Nestle.Crunch Q6...Now.n.Laters
## 1
## 2 DESPAIR DESPAIR JOY DESPAIR
## 3
## 4 MEH MEH MEH MEH
## 5 MEH JOY JOY JOY
## 6 JOY JOY MEH MEH
## Q6...Peeps Q6...Pixy.Stix Q6...ReeseÕs.Peanut.Butter.Cups
## 1
## 2 DESPAIR DESPAIR JOY
## 3
## 4 DESPAIR DESPAIR JOY
## 5 MEH JOY JOY
## 6 DESPAIR MEH JOY
## Q6...Reese.s.Pieces Q6...Rolos Q6...Skittles Q6...Smarties..American.
## 1
## 2 JOY JOY DESPAIR DESPAIR
## 3
## 4 MEH MEH DESPAIR DESPAIR
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY JOY
## Q6...Snickers Q6...Sourpatch.Kids..i.e..abominations.of.nature.
## 1
## 2 MEH DESPAIR
## 3
## 4 JOY MEH
## 5 MEH
## 6 JOY DESPAIR
## Q6...Starburst Q6...Sweet.Tarts Q6...Swedish.Fish Q6...Take.5
## 1
## 2 MEH DESPAIR MEH DESPAIR
## 3
## 4 MEH MEH JOY JOY
## 5 JOY JOY MEH MEH
## 6 MEH MEH MEH
## Q6...Tic.Tacs Q6...Three.Musketeers Q6...Tolberone.something.or.other
## 1
## 2 DESPAIR JOY JOY
## 3
## 4 MEH DESPAIR JOY
## 5 DESPAIR JOY JOY
## 6 MEH JOY JOY
## Q6...Twix Q9..OTHER.COMMENTS
## 1
## 2 JOY Bottom line is Twix is really the only candy worth eating.
## 3
## 4 JOY Raisins can go to hell
## 5 JOY
## 6 JOYNow the data is looking more readable. There are some blank spaces in the data that shows that there was no answer given. So I decided to leave those blank. Next I;m going to create subsets of the data to seperate the data based on age, gender, and location.
#Create a subset for gender
Candy_gender <- select(Candy_revised,Internal.ID, Q2..GENDER, Q6...100.Grand.Bar:Q6...Twix)
head(Candy_gender)## Internal.ID Q2..GENDER Q6...100.Grand.Bar Q6...Black.Jacks
## 1 90258773
## 2 90272821 Male MEH MEH
## 3 90272829 Male
## 4 90272840 Male MEH MEH
## 5 90272841 Male JOY DESPAIR
## 6 90272852 Male JOY
## Q6...Bonkers..the.candy. Q6...Bottle.Caps Q6...Butterfinger
## 1
## 2 DESPAIR DESPAIR DESPAIR
## 3
## 4 MEH MEH MEH
## 5 MEH MEH MEH
## 6 MEH JOY
## Q6...Cadbury.Creme.Eggs Q6...Candy.Corn Q6...Caramellos Q6...Chiclets
## 1
## 2 MEH MEH MEH DESPAIR
## 3
## 4 MEH DESPAIR MEH MEH
## 5 MEH DESPAIR JOY DESPAIR
## 6 DESPAIR MEH JOY MEH
## Q6...Coffee.Crisp Q6...Dots Q6...Goo.Goo.Clusters Q6...Good.N..Plenty
## 1
## 2 DESPAIR MEH DESPAIR MEH
## 3
## 4 DESPAIR JOY JOY MEH
## 5 MEH MEH MEH MEH
## 6 JOY MEH JOY MEH
## Q6...Gummy.Bears.straight.up Q6...Hard.Candy Q6...Heath.Bar
## 1
## 2 MEH MEH MEH
## 3
## 4 JOY MEH DESPAIR
## 5 JOY MEH DESPAIR
## 6 MEH MEH JOY
## Q6...Hershey.s.Dark.Chocolate Q6...HersheyÕs.Milk.Chocolate
## 1
## 2 JOY JOY
## 3
## 4 MEH MEH
## 5 JOY MEH
## 6 JOY MEH
## Q6...Hershey.s.Kisses Q6...Jolly.Rancher..bad.flavor.
## 1
## 2 MEH DESPAIR
## 3
## 4 MEH MEH
## 5 MEH MEH
## 6 MEH MEH
## Q6...Jolly.Ranchers..good.flavor. Q6...Junior.Mints
## 1
## 2 MEH DESPAIR
## 3
## 4 MEH DESPAIR
## 5 JOY JOY
## 6 MEH JOY
## Q6...Kinder.Happy.Hippo Q6...Kit.Kat Q6...LaffyTaffy Q6...LemonHeads
## 1
## 2 DESPAIR JOY DESPAIR MEH
## 3
## 4 MEH MEH JOY JOY
## 5 JOY JOY JOY JOY
## 6 JOY MEH MEH
## Q6...Licorice..not.black. Q6...Licorice..yes.black. Q6...Lindt.Truffle
## 1
## 2 MEH JOY MEH
## 3
## 4 MEH JOY JOY
## 5 MEH DESPAIR JOY
## 6 MEH MEH JOY
## Q6...Lollipops Q6...Mars Q6...Maynards Q6...Mike.and.Ike Q6...Milk.Duds
## 1
## 2 DESPAIR DESPAIR DESPAIR MEH MEH
## 3
## 4 DESPAIR JOY MEH MEH DESPAIR
## 5 MEH MEH DESPAIR MEH MEH
## 6 MEH JOY JOY JOY
## Q6...Milky.Way Q6...Regular.M.Ms Q6...Peanut.M.MÕs Q6...Blue.M.M.s
## 1
## 2 JOY JOY MEH JOY
## 3
## 4 JOY MEH JOY MEH
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY JOY
## Q6...Red.M.M.s Q6...Green.Party.M.M.s Q6...Mint.Kisses Q6...Mint.Juleps
## 1
## 2 JOY JOY MEH DESPAIR
## 3
## 4 MEH MEH DESPAIR MEH
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY
## Q6...Mr..Goodbar Q6...Nerds Q6...Nestle.Crunch Q6...Now.n.Laters
## 1
## 2 DESPAIR DESPAIR JOY DESPAIR
## 3
## 4 MEH MEH MEH MEH
## 5 MEH JOY JOY JOY
## 6 JOY JOY MEH MEH
## Q6...Peeps Q6...Pixy.Stix Q6...ReeseÕs.Peanut.Butter.Cups
## 1
## 2 DESPAIR DESPAIR JOY
## 3
## 4 DESPAIR DESPAIR JOY
## 5 MEH JOY JOY
## 6 DESPAIR MEH JOY
## Q6...Reese.s.Pieces Q6...Rolos Q6...Skittles Q6...Smarties..American.
## 1
## 2 JOY JOY DESPAIR DESPAIR
## 3
## 4 MEH MEH DESPAIR DESPAIR
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY JOY
## Q6...Snickers Q6...Sourpatch.Kids..i.e..abominations.of.nature.
## 1
## 2 MEH DESPAIR
## 3
## 4 JOY MEH
## 5 MEH
## 6 JOY DESPAIR
## Q6...Starburst Q6...Sweet.Tarts Q6...Swedish.Fish Q6...Take.5
## 1
## 2 MEH DESPAIR MEH DESPAIR
## 3
## 4 MEH MEH JOY JOY
## 5 JOY JOY MEH MEH
## 6 MEH MEH MEH
## Q6...Tic.Tacs Q6...Three.Musketeers Q6...Tolberone.something.or.other
## 1
## 2 DESPAIR JOY JOY
## 3
## 4 MEH DESPAIR JOY
## 5 DESPAIR JOY JOY
## 6 MEH JOY JOY
## Q6...Twix
## 1
## 2 JOY
## 3
## 4 JOY
## 5 JOY
## 6 JOY#Create a subset for age
Candy_age <- select(Candy_revised,Internal.ID, Q3..AGE, Q6...100.Grand.Bar:Q6...Twix)
head(Candy_age)## Internal.ID Q3..AGE Q6...100.Grand.Bar Q6...Black.Jacks
## 1 90258773
## 2 90272821 44 MEH MEH
## 3 90272829 49
## 4 90272840 40 MEH MEH
## 5 90272841 23 JOY DESPAIR
## 6 90272852 JOY
## Q6...Bonkers..the.candy. Q6...Bottle.Caps Q6...Butterfinger
## 1
## 2 DESPAIR DESPAIR DESPAIR
## 3
## 4 MEH MEH MEH
## 5 MEH MEH MEH
## 6 MEH JOY
## Q6...Cadbury.Creme.Eggs Q6...Candy.Corn Q6...Caramellos Q6...Chiclets
## 1
## 2 MEH MEH MEH DESPAIR
## 3
## 4 MEH DESPAIR MEH MEH
## 5 MEH DESPAIR JOY DESPAIR
## 6 DESPAIR MEH JOY MEH
## Q6...Coffee.Crisp Q6...Dots Q6...Goo.Goo.Clusters Q6...Good.N..Plenty
## 1
## 2 DESPAIR MEH DESPAIR MEH
## 3
## 4 DESPAIR JOY JOY MEH
## 5 MEH MEH MEH MEH
## 6 JOY MEH JOY MEH
## Q6...Gummy.Bears.straight.up Q6...Hard.Candy Q6...Heath.Bar
## 1
## 2 MEH MEH MEH
## 3
## 4 JOY MEH DESPAIR
## 5 JOY MEH DESPAIR
## 6 MEH MEH JOY
## Q6...Hershey.s.Dark.Chocolate Q6...HersheyÕs.Milk.Chocolate
## 1
## 2 JOY JOY
## 3
## 4 MEH MEH
## 5 JOY MEH
## 6 JOY MEH
## Q6...Hershey.s.Kisses Q6...Jolly.Rancher..bad.flavor.
## 1
## 2 MEH DESPAIR
## 3
## 4 MEH MEH
## 5 MEH MEH
## 6 MEH MEH
## Q6...Jolly.Ranchers..good.flavor. Q6...Junior.Mints
## 1
## 2 MEH DESPAIR
## 3
## 4 MEH DESPAIR
## 5 JOY JOY
## 6 MEH JOY
## Q6...Kinder.Happy.Hippo Q6...Kit.Kat Q6...LaffyTaffy Q6...LemonHeads
## 1
## 2 DESPAIR JOY DESPAIR MEH
## 3
## 4 MEH MEH JOY JOY
## 5 JOY JOY JOY JOY
## 6 JOY MEH MEH
## Q6...Licorice..not.black. Q6...Licorice..yes.black. Q6...Lindt.Truffle
## 1
## 2 MEH JOY MEH
## 3
## 4 MEH JOY JOY
## 5 MEH DESPAIR JOY
## 6 MEH MEH JOY
## Q6...Lollipops Q6...Mars Q6...Maynards Q6...Mike.and.Ike Q6...Milk.Duds
## 1
## 2 DESPAIR DESPAIR DESPAIR MEH MEH
## 3
## 4 DESPAIR JOY MEH MEH DESPAIR
## 5 MEH MEH DESPAIR MEH MEH
## 6 MEH JOY JOY JOY
## Q6...Milky.Way Q6...Regular.M.Ms Q6...Peanut.M.MÕs Q6...Blue.M.M.s
## 1
## 2 JOY JOY MEH JOY
## 3
## 4 JOY MEH JOY MEH
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY JOY
## Q6...Red.M.M.s Q6...Green.Party.M.M.s Q6...Mint.Kisses Q6...Mint.Juleps
## 1
## 2 JOY JOY MEH DESPAIR
## 3
## 4 MEH MEH DESPAIR MEH
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY
## Q6...Mr..Goodbar Q6...Nerds Q6...Nestle.Crunch Q6...Now.n.Laters
## 1
## 2 DESPAIR DESPAIR JOY DESPAIR
## 3
## 4 MEH MEH MEH MEH
## 5 MEH JOY JOY JOY
## 6 JOY JOY MEH MEH
## Q6...Peeps Q6...Pixy.Stix Q6...ReeseÕs.Peanut.Butter.Cups
## 1
## 2 DESPAIR DESPAIR JOY
## 3
## 4 DESPAIR DESPAIR JOY
## 5 MEH JOY JOY
## 6 DESPAIR MEH JOY
## Q6...Reese.s.Pieces Q6...Rolos Q6...Skittles Q6...Smarties..American.
## 1
## 2 JOY JOY DESPAIR DESPAIR
## 3
## 4 MEH MEH DESPAIR DESPAIR
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY JOY
## Q6...Snickers Q6...Sourpatch.Kids..i.e..abominations.of.nature.
## 1
## 2 MEH DESPAIR
## 3
## 4 JOY MEH
## 5 MEH
## 6 JOY DESPAIR
## Q6...Starburst Q6...Sweet.Tarts Q6...Swedish.Fish Q6...Take.5
## 1
## 2 MEH DESPAIR MEH DESPAIR
## 3
## 4 MEH MEH JOY JOY
## 5 JOY JOY MEH MEH
## 6 MEH MEH MEH
## Q6...Tic.Tacs Q6...Three.Musketeers Q6...Tolberone.something.or.other
## 1
## 2 DESPAIR JOY JOY
## 3
## 4 MEH DESPAIR JOY
## 5 DESPAIR JOY JOY
## 6 MEH JOY JOY
## Q6...Twix
## 1
## 2 JOY
## 3
## 4 JOY
## 5 JOY
## 6 JOY#Create a subset for location
Candy_location <- select(Candy_revised,Internal.ID, Q4..COUNTRY, Q5..STATE..PROVINCE..COUNTY..ETC, Q6...100.Grand.Bar:Q6...Twix)
head(Candy_location)## Internal.ID Q4..COUNTRY Q5..STATE..PROVINCE..COUNTY..ETC
## 1 90258773
## 2 90272821 USA NM
## 3 90272829 USA Virginia
## 4 90272840 us or
## 5 90272841 usa exton pa
## 6 90272852
## Q6...100.Grand.Bar Q6...Black.Jacks Q6...Bonkers..the.candy.
## 1
## 2 MEH MEH DESPAIR
## 3
## 4 MEH MEH MEH
## 5 JOY DESPAIR MEH
## 6 JOY
## Q6...Bottle.Caps Q6...Butterfinger Q6...Cadbury.Creme.Eggs
## 1
## 2 DESPAIR DESPAIR MEH
## 3
## 4 MEH MEH MEH
## 5 MEH MEH MEH
## 6 MEH JOY DESPAIR
## Q6...Candy.Corn Q6...Caramellos Q6...Chiclets Q6...Coffee.Crisp
## 1
## 2 MEH MEH DESPAIR DESPAIR
## 3
## 4 DESPAIR MEH MEH DESPAIR
## 5 DESPAIR JOY DESPAIR MEH
## 6 MEH JOY MEH JOY
## Q6...Dots Q6...Goo.Goo.Clusters Q6...Good.N..Plenty
## 1
## 2 MEH DESPAIR MEH
## 3
## 4 JOY JOY MEH
## 5 MEH MEH MEH
## 6 MEH JOY MEH
## Q6...Gummy.Bears.straight.up Q6...Hard.Candy Q6...Heath.Bar
## 1
## 2 MEH MEH MEH
## 3
## 4 JOY MEH DESPAIR
## 5 JOY MEH DESPAIR
## 6 MEH MEH JOY
## Q6...Hershey.s.Dark.Chocolate Q6...HersheyÕs.Milk.Chocolate
## 1
## 2 JOY JOY
## 3
## 4 MEH MEH
## 5 JOY MEH
## 6 JOY MEH
## Q6...Hershey.s.Kisses Q6...Jolly.Rancher..bad.flavor.
## 1
## 2 MEH DESPAIR
## 3
## 4 MEH MEH
## 5 MEH MEH
## 6 MEH MEH
## Q6...Jolly.Ranchers..good.flavor. Q6...Junior.Mints
## 1
## 2 MEH DESPAIR
## 3
## 4 MEH DESPAIR
## 5 JOY JOY
## 6 MEH JOY
## Q6...Kinder.Happy.Hippo Q6...Kit.Kat Q6...LaffyTaffy Q6...LemonHeads
## 1
## 2 DESPAIR JOY DESPAIR MEH
## 3
## 4 MEH MEH JOY JOY
## 5 JOY JOY JOY JOY
## 6 JOY MEH MEH
## Q6...Licorice..not.black. Q6...Licorice..yes.black. Q6...Lindt.Truffle
## 1
## 2 MEH JOY MEH
## 3
## 4 MEH JOY JOY
## 5 MEH DESPAIR JOY
## 6 MEH MEH JOY
## Q6...Lollipops Q6...Mars Q6...Maynards Q6...Mike.and.Ike Q6...Milk.Duds
## 1
## 2 DESPAIR DESPAIR DESPAIR MEH MEH
## 3
## 4 DESPAIR JOY MEH MEH DESPAIR
## 5 MEH MEH DESPAIR MEH MEH
## 6 MEH JOY JOY JOY
## Q6...Milky.Way Q6...Regular.M.Ms Q6...Peanut.M.MÕs Q6...Blue.M.M.s
## 1
## 2 JOY JOY MEH JOY
## 3
## 4 JOY MEH JOY MEH
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY JOY
## Q6...Red.M.M.s Q6...Green.Party.M.M.s Q6...Mint.Kisses Q6...Mint.Juleps
## 1
## 2 JOY JOY MEH DESPAIR
## 3
## 4 MEH MEH DESPAIR MEH
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY
## Q6...Mr..Goodbar Q6...Nerds Q6...Nestle.Crunch Q6...Now.n.Laters
## 1
## 2 DESPAIR DESPAIR JOY DESPAIR
## 3
## 4 MEH MEH MEH MEH
## 5 MEH JOY JOY JOY
## 6 JOY JOY MEH MEH
## Q6...Peeps Q6...Pixy.Stix Q6...ReeseÕs.Peanut.Butter.Cups
## 1
## 2 DESPAIR DESPAIR JOY
## 3
## 4 DESPAIR DESPAIR JOY
## 5 MEH JOY JOY
## 6 DESPAIR MEH JOY
## Q6...Reese.s.Pieces Q6...Rolos Q6...Skittles Q6...Smarties..American.
## 1
## 2 JOY JOY DESPAIR DESPAIR
## 3
## 4 MEH MEH DESPAIR DESPAIR
## 5 JOY JOY JOY JOY
## 6 JOY JOY JOY JOY
## Q6...Snickers Q6...Sourpatch.Kids..i.e..abominations.of.nature.
## 1
## 2 MEH DESPAIR
## 3
## 4 JOY MEH
## 5 MEH
## 6 JOY DESPAIR
## Q6...Starburst Q6...Sweet.Tarts Q6...Swedish.Fish Q6...Take.5
## 1
## 2 MEH DESPAIR MEH DESPAIR
## 3
## 4 MEH MEH JOY JOY
## 5 JOY JOY MEH MEH
## 6 MEH MEH MEH
## Q6...Tic.Tacs Q6...Three.Musketeers Q6...Tolberone.something.or.other
## 1
## 2 DESPAIR JOY JOY
## 3
## 4 MEH DESPAIR JOY
## 5 DESPAIR JOY JOY
## 6 MEH JOY JOY
## Q6...Twix
## 1
## 2 JOY
## 3
## 4 JOY
## 5 JOY
## 6 JOYThe analysis requested in the discussion post is determining the kind of candy people like based off of age, gender, demographics, geography, and type of candy, etc. I will be analyzing the data to determine what candy is liked based off of age, gender, demographics, and geography. Determining the kinds of candy people like based off of the type of candy is a little difficult to show, since the data doesn’t specify the type that each candy is. You would have to make an assumption on what that candy is.
I managed to tidy the data somewhat for this huge dataset. Unfortunately, further analysis shows that some people didn’t answer seriously and put some joke responses in the survey. I attempted to tidy the joke responses out of the data by removing the joke candies that people had listed. But when I was going to do the analysis that was requested in the discusson post I realized that the analysis asked for couldn’t be shown. For example, trying to find what candies are liked based on age can’t be done since some people put joke responses about their age. If you were to remove these people you would be removing their responses as well, and doing this would mean that you can’t perform an accurate analysis on the dataset.