Pickle_Project_Final
2023-12-14
The purpose of collecting this data was to determine how the local community feels about dill pickles. When reading online forums there is quite a bit of debate on what brand is the best, which one is overpriced, etc. By collecting this data from our fellow peers and instructors, we could really get a grasp on the best dill pickle brand.
In order to collect the data we have below, we decided to create a survey to acquire genuine answers. The survey was posted on a popular social media platform, SnapChat, on a story only viewed by OSU students. In addition, the survey was put up around the OSU campus.
By posting the survey on social media and physically around campus, the survey had approximately 150 responses from all OSU students, and possibly staff/faculty.
Caption for this figure 1
An important note, this data was only for dill pickles. The survey did receive a response from an avid sweet pickle hater. This person, rather than appropriately responding to the survey questions in regards to dill pickles, had mentioned sweet pickles in every response. We had to forfeit this data as it was irrelevant to dill pickles.
We utilized this data to form graphs, networks, and analysis between our variables to understand the important aspects of dill pickles and determine what aspects resulted in the best dill pickle.
| do you prefer singular pickles (travel-sized snack pickles) or bulk pickles (jar) or both? | if you enjoy jar pickles, what is your favorite brand of jar dill pickle? | if you enjoy single-packaged pickles, what brand do you enjoy the most? | what is your favorite cut of dill pickle? | what do you look for most in a dill pickle? | how much do you spend on a jar of pickles | how often do you consume dill pickles? | where do you purchase dill pickles? | do you enjoy homemade pickles? | if yes, have you ever made your own pickles? | do you eat pickles by themselves or with other food items? | if yes, what do you eat with pickles? | how old are you? | what gender do you identify as? |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| both | trader joe’s | oh snap! | whole | crunch | $2 - $4 | once a week | safeway, trader joe’s | never had homemade pickles | NA | both | sandwhiches, burgers, bar food | 21 - 23 | non-binary |
| both | grillos | NA | spears | crunch | $2 - $4 | everyday | costco | never had homemade pickles | NA | by themselves | sandwhiches, burgers | 18 - 20 | male |
| bulk | gedney | NA | spears | salinity | $4.01 - $6 | everyday | winco | yes | yes | both | sandwhiches, burgers, wraps, bar food, salads | 39 - 41 | male |
| bulk | kroger (fred meyer brand) | oh snap! | sliced | crunch | $2 - $4 | once a week | winco | yes | no | with other foods | sandwhiches, burgers | 18 - 20 | male |
| bulk | mt. olives | NA | whole | crunch | $6.00 | once a week | winco | never had homemade pickles | NA | with other foods | sandwhiches | 24 - 26 | demi girl |
| bulk | vlassic | oh snap! | sliced | crunch | $4.01 - $6 | once a week | fred meyer | never had homemade pickles | no | with other foods | sandwhiches, burgers, salads | 21 - 23 | non-binary |
Graph 1 This heatmap shows the relationship between preferred cost and favorite pickle brand:
## New names:
## Rows: 139 Columns: 3
## ── Column specification
## ──────────────────────────────────────────────────────── Delimiter: "," chr
## (2): favorite, spendy lgl (1): ...3
## ℹ Use `spec()` to retrieve the full column specification for this data. ℹ
## Specify the column types or set `show_col_types = FALSE` to quiet this message.
## `summarise()` has grouped output by 'favorite'. You can override using the
## `.groups` argument.
## • `` -> `...3`
This heatmap visualizes the relationship between the favorite brands of pickles and the preferred cost of pickle buyers. The more yellow, the more that specific brand shows up with the preferred cost. So, individuals who purchase Bubbies pickles feel like they prefer to spend $6+ on pickles.
The purpose of this graph is to show the relationship between brands and the ingredients contained in the brands:
## Rows: 16 Columns: 29
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (29): brand, cucumber, water, distilled vinegar, salt, calcium chloride,...
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
This plot demonstrates the brand of pickles and the ingredients within each brand. If the color defined as yes shows up on the brand and specific ingredient, then that means that the brand contains that specific ingredient, vice versa for ingredients not contained in the brands. This graph helps to build a better understanding of the nutritional value of certain brands of pickles. For example, which brand of pickles uses less natural ingredients compared to the brands that only use natural ingredients. With this knowledge, we can examine which of these brands is most liked.
To show relationship between the top three brands and the ingredients in those brands:
## Rows: 16 Columns: 29
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (29): brand, cucumber, water, distilled vinegar, salt, calcium chloride,...
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
This is the same thing as above except we are only looking at the top
three most liked brands from the data, Vlasic, Claussen, and Mt. Olive.
Again, we can examine the nutritional value of the ingredients and
determine which brand might be “healthier”. Claussen is the only brand
of pickle that has high fructose corn syrup, as many of us already know,
that ingredient is highly addictive because it is sugar. That could
explain why so many individuals love Claussens.
This table shows the difference in nutrition labels between brands
## Rows: 15 Columns: 8
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (8): brand, calories, fat, cholesterol, sodium, carbohydrate, protein, i...
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.| brand | calories | fat | cholesterol | sodium | carbohydrate | protein | ingredients |
|---|---|---|---|---|---|---|---|
| vlasic | 0g | 0g | 0mg | 220mg | 1g | 0g | cucumbers water distilled/vinegar salt calcium/chloride turmeric/extract polysorbate/80 natural/flavor |
| mt. olive | 0g | 0g | 0g | 290mg | 1g | 0g | cucumbers water distilled/vinegar salt calcium/chloride sodium/benzoate alum natural/flavor polysorbate/80 yellow/5 |
| claussen | 0g | 0g | 0g | 330mg | 0g | 0g | fresh/cucmbers water distilled/vinegar salt high/fructose/corn/syrup dried/garlic calcium/chloride sodium/benzoate spice mustard/seed natural/flavor dried/red/peppers polysorbate/80 |
| grillos | 5g | 0g | 0g | 250mg | 1g | 0g | cucumbers water distilled/white/vinegar salt garlic dill grape/leaves |
| nalley | 0g | 0g | 0g | 260mg | 1g | 0g | fresh/cucumbers water vinegar salt dehydrated/garlic calcium/chloride natural/flavors polysorbate/80 yellow/5 |
| great value | 5g | 0g | 0g | 260mg | 1g | 0g | cucumbers water vingar salt calcium/chloride sodium/benzoate natural/flavors polysorbate/80 yellow/5 turmeric |
The purpose behind the information in this table is to evaluation differences between nutritional value between known pickle brands. In addition, comparing the differences between ingredients used between different brands. From the information gathered, we determined that the more expensive brands had higher quality ingredients like including fresh/dried herbs and garlic, and using tumeric to substitute food coloring.
The graph below incorporate data from the table to show a comparison between levels of sodium in milligrams and amount of carbohydrates and calories in each brand.
## Inverted geom defaults of fill and color/colour.
## To change them back, use invert_geom_defaults().## Warning: Using size for a discrete variable is not advised.
## Rows: 151 Columns: 14
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (14): single or bulk, bulk, single, cut, desirablity, cost, frequency, s...
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
This is a graph comparing frequency in pickle consumption with cut and cost in relation to consumed by gender.
## Rows: 151 Columns: 14
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (14): single or bulk, bulk, single, cut, desirablity, cost, frequency, s...
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
We made this graph because we were curious on what demographic enjoyed which cuts of pickles and how often they enjoyed it. Based on our evidence we can determined that by majority, women enjoyed pickles the most and purchased them at least once a week. They most enjoyed the spears type cut of dill pickles.
We created this network to show the correlation between the frequency of dill pickles consumed, preferred price range, favorite brand, most desirable trait when looking at brands of pickles, and favorite cut of dill pickles.
After evaluating the data we can see the most relevant information utilizing Eigenvector centrality, we see the most significant object within the data set with the most connections is consuming a dill pickle once a week. This is followed by the preferred price range of $4.01-$6, crunch being the most desirable trait, spears being the favorite cut, and Vlassic being the favorite brand.
After reviewing and compiling the data we found that the most popular brand of dill pickles is Vlassic dill pickles. These pickles are preferred by women by the majority vote, and enjoyed in the spears style of cut, with the most desirable trait being crunch, and the monetary amount to purchase the dill pickles being within the $4.01-$6 range.
