What to choose?

I was doing my preparation for the diet and of course plain yoghurt plays quite a part in the breakfast section. So off to the local supermarket to buy some, except there are lots of different ones all with varying amounts of sugar, fat and carbs. So which one?.

The calorie counters I’ve seen really just say things like plain yoghurt with no brand name and community sites like myfitnesspal don’t really present the data in a useable form.

I mentioned in a previous post that I work in IT so could I use my skills to get the data to make a choice? Well it turns out yes!. Tesco have what we call an API which means you can write programs around it to retrieve information, it stand for Application Programming Interface if you’re interested. So what I did is sign up to the service, write a program which retrieves details at a high level e.g. yoghurt. The API returns around 700 items some of which have sugar etc. against them, some don’t. I then took this data and cleaned it up so it could work in a spreadsheet (excel in my case but any spreadsheet application would work).

When the data comes back it has lots of products that don’t look to be yoghurt so I filtered the data to only show me things with yoghurt in the title. After this I sorted on sugar and a sample of the results is shown below.

My conclusion I should be using Onken Natural Set Yoghurt 500G, so off to Tesco to buy some. It’s ok not what I would choose normally, that would be a Muller. The one I would get normally is one of the items that doesn’t return the sugar contents so as an example I picked a Muller with some figures just to highlight the difference.

  If anyone can suggest an alternative I'd be gratefull

When I work out how to get comments etc if anyone would like a copy of the data I'm sure I can arrange it.