Food that kills

[Palarisk]

Pitch

Summary

I'm interested in foodborne outbreaks and for this project, I want to explore what kind of contaminated food is the biggest killer.

Details

Possible headline(s): Food that kills https://wwwn.cdc.gov/norsdashboard/

Code repository: https://github.com/Palarisk/data-studio/tree/master/code/project2_outbreaks_alarisku

Possible problems/fears/questions: I think I might need to combine all the animal related stuff somehow together. Now it might give a wrong impression that fuits and vegetables are soooo dangerous, when in fact the turkey, beef. chicken, pork etc meat and fish are responsible for 57 deaths, which is roughly equal to fruits.

And also: you have to keep in mind that it's really hard to die from contaminated food: e.g. in car accidents, 37,000 people die EVERY year, where as this food statistics are for almost 20 years!

Work so far

I have downloaded my data set from the address above and cleaned and analyzed the data. I have done the following graph:

Checklist

This checklist must be completed before you submit your draft.

• [x] I have already spent time with my data set, opening it, exploring it, etc
• [ ] I have created a "DIARY.md" file to save links and list all of the terrible, no good problems I come across
• [x] My issue links to my data set(s)
• [x] My issue links to my code repository
• [x] My issue explains what I'd like to explore in the data set
• [x] My issue includes images - either inspiration or what I've done so far

[jsoma]

• That graph looks like a really solid base to build on! Nice top axis, nice single color, just really solid!
• Design wise, I'd push the subtitle up a little bit, and recently I've really like left-aligned titles/subtitles. Maybe give it a try?
• No need for tick marks on the left axis, the labels and bars do a good enough job. I think it's ax.tick_params(left=False).
• "root vegetables" not under "vegetables"?
• I think it might be nice to throw in a highlight here, but I'm not sure what. "Meat isn't that deadly" or "spinach is the worst, it's considered a vegetable" or something? Maybe not.

Now it might give a wrong impression that fuits and vegetables are soooo dangerous, when in fact the turkey, beef. chicken, pork etc meat and fish are responsible for 57 deaths, which is roughly equal to fruits. d I didn't originally read your note! I guess you're right. Maybe make a few different graphs with the data combined in a few different ways? I'd probably copy my df and do a df.foodtype.replace to change all of the turkey/pork/etc and stuff to meat. But I guess you'd also need to combine the fruits? And where do nuts go! Where do eggs go!

I think that your "also" and "and also" would be really good as a whole piece - I think we approach a lot of these things as make a graphic instead of make a story. If you approached this as walking through a series of graphics and text to explain why some things might or might not be scary, I think ti would be really useful! Like how when The Pudding starts by showing you something complicated and then breaks it out piece by piece? Same thing, but without interactivity 👍

[Palarisk]

Update

Here are some visual changes to the chart. I also merged root vegetables with vegetables.

Any changes in direction or topic?

For the next step, I’ll create 2 or 3 different kind of charts:

1)A chart comparing animal products & vegetable based products

2)More detailed chart on the food types that has caused deaths

3)A chart comparing deaths caused by food poisonings and car accidents (it’s so much safer to eat than drive.) Working title: Don’t stop eating lettuce yet

Problems/Questions

Should I combine the number 1 and 2 charts and make a stacked bar chart? I usually don't loke stacked bar chart cause I think they are messy and it is hard to compare stuff in them: is there any good reasons/occasions to use them? If so, when?

Checklist

• [x] I have included my visuals
• [x] I have filled out the sections above
• [ ] I have been updating my DIARY.md with details about my process
• [x] I have uploaded/updated any Jupyter Notebooks or other datasets into my code repository

[playfairbot]

Hi! I'm a little robot, let's see what's been going on here.

You need some feedback, let me summon @ElinaMak, @zle2105, @collleenwang for you

It looks like we need to fix up your your update a little bit! Edit it by clicking the pencil in the top right-hand corner. It requires:

• New, updated content for your project
• The checklist (be sure you're using the template!)

Maybe you just didn't use the template? If not, edit your comment, cut and paste the template in, and then fill it out.

[collleenwang]

I like the creative title! What a surprising that fruit ranks No.1 and goes ahead so much!

[zle2105]

This project is really interesting. I think that you could even combine the plant v. animal designation in the first chart to save some time.

[ElinaMak]

Super, super interesting idea! Just from an editor's point of view, is not very clear to me what sort of contamination are we talking about, pesticides, GMO and if yes, can all these fit into a same category of contamination with a life threatening impact for humans?

[Palarisk]

Update

Your project content: images/words/etc

Out of 3 charts I'm planning to do, I have done 2 (preliminary, I have to still fix the design)

1/3

2/3

Not yet done. I'm planning to explore in detail the Plant-based and Animal categories. What kind of foods are the most deadliest?

3/3

I should definitely add the numbers to the chart: there are on average 19 deaths by contaminated food vs 28,626 deaths by car accidents.

Any changes in direction or topic?

Nope.

Problems/Questions

For some reason I spent ages trying to create a new column to categorize my data into animal/plant/ unknown categories. Finally I was able to do it by defining a function to do it.

Thanks for the feedback, I'll definitely explain what a contaminated food means in a greater detail.

Checklist

• [x] I have included my visuals
• [x] I have filled out the sections above
• [ ] I have been updating my DIARY.md with details about my process
• [x] I have uploaded/updated any Jupyter Notebooks or other datasets into my code repository

[Palarisk]

Final

Project visuals/text

Details

Headline: Food that kills - foodborne outbreaks from 1998 to 2016

Published website version: https://palarisk.github.io/foodkills/

Code repository: https://github.com/Palarisk/data-studio/tree/master/code/project2_outbreaks_alarisku Final data set(s): https://github.com/Palarisk/data-studio/blob/master/code/project2_outbreaks_alarisku/NationalOutbreakPublicDataTool.xlsx

What did you find to be the most difficult part of this project?

To decide on the categories for graph 2.

Are you satisfied with what you produced? Is there anything you would like to change or improve?

I'm satisfied. I would love to explore some more: what were the most common bacteria/viruses etc..

Checklist

• [x] I have included my visuals
• [x] I have posted my project to my project website
• [ ] I have been updating my DIARY.md with details about my process
• [x] I have uploaded/updated any Jupyter Notebooks or other datasets into my code repository

[benbitoun]

I guess it's silly since you have already finished this project but that robot told me today I should give you feedback, so here it is. I like the second graph a lot because it does really put the stuff you found out into perspective while staying within the topic. The third one in my opinion is kind of useless because there you are drifting away - just from looking at the low numbers it is cristal clear that more people die because of car accidents (or basically any other thing other then, maybe, shark attacks).

I really like that red you've chosen for your graphs - I might steal it :-)

[cfelke]

Same here, but the robot assigned me to your final project, so here we go: I like the color too and I like your topic, it's funny. Your second graph is informative and the annotation is good (not sure whether it's a bit too dense but I like it). Regarding your third graph I would have played with different parameters, maybe dish the absolute numbers for some ratio. And I'd like more context, are we talking about Americans who died, which year are we talking about etc. Maybe you can apply this in your next project.

Good job!

[castorsia]

As with the rest f the good people of Lede, I'm chiming in a bit late. But I liked your project nonetheless. Interesting and quirky topic and good work on the visuals, this red gradient is really appealing. However, I would colour the top bars in your second graph somewhat more flashy, in order to stand out a bit. Now you have too much of the same, I think. Overall, lovely work!