Guardian Data: TV chefs’ recipes

A screenshot of some of the visualisations in the celebrity chefs story in the Guardian

A screenshot of some of the visualisations in the celebrity chefs story in the Guardian

During my stint of work experience at Guardian Data the British Medical Journal found that supermarket ready meals are often healthier than the meals in TV chefs’ recipe books. It was covered in the Guardian and elsewhere as a news story. We decided to do a data angle on the story.

The important point about the data we had was the different serving sizes between supermarket ready meals and recipes from Jamie Oliver and the other celebrities. Supermarket ready meals are usually designed for one, whereas the chefs’ recipes are usually for three or four people. We had to divide the servings of salt, sugar, saturated fat and so on by the number of servings if there was more than one serving.

After that, we took the median averages, copied the values only into a new sheet and visualised the data using Google charts.

We found that the saturated fat content, for example, of the celebrity chefs was higher than the supermarket ready meals, which appeared to back up the main news story.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s