Discover Food Insights with Mirabelle—A Datasette-Powered Tool

Mirabelle is a customized version of the powerful Datasette tool, specifically tailored for exploring the Open Food Facts database—a collaborative, free, and open resource of food products from around the globe.

Originally created by Simon Wilson, Datasette allows users to discover patterns in data and share their findings effortlessly through interactive websites. It's built on top of SQLite, a lightweight database engine used in popular applications like Google Chrome, Firefox, iPhones, Android devices, and more.

With Mirabelle, you can query the food product database through a form -

If you have basic knowledge of SQL, you can easily dive into the Open Food Facts database via an intuitive, user-friendly interface and customize the queries - 

Plus, it offers built-in features to generate simple line, bar, and scatter plot charts, making it a versatile tool for both data exploration and visualization.


By using appropriate queries, the data can be refined to generate meaningful visualizations -
Bar chart ranking products by Protein content (generated after a tweak by Alex Garel)

Beside viewing the results of the query online, you can also export the records as CSV or JSON files.

Comments

Post a Comment

Popular posts from this blog

A Beginner's Guide to Data & Analytics - Highlights

Image
The 22-page free ebook " A Beginner's Guide to Data & Analytics " from Harvard Business School Online offers essential definitions and practical advice for those looking to learn more about the field. * Data science is the process of building, cleaning, and structuring datasets to analyze and extract meaning.  * Data analytics refers to the process and practice of analyzing data to answer questions, extract insights, and identify trends * Types of Analytics: Descriptive analytics looks at data to examine, understand, and describe something that’s already happened. Diagnostic analytics goes deeper than descriptive analytics by seeking to understand the “why” behind what happened. Predictive analytics relies on historical data, past trends, and assumptions to answer questions about what will happen in the future. Prescriptive analytics identifies specific actions an individual or organization should take to reach future targets or goals * Data literacy is the ability to
Read more

AI - Reflections & Perspectives

Image
Image generated by AI * "AI is comparable in scale to the Industrial Revolution or electricity, or even the wheel". - Geoffrey Hinton, Godfather of Deep Learning * "The hottest new programming language is English" -  Andrej Karpathy * "Treat AI assistants as a slightly-drunk knowledgeable friend" - Richard Seroter * "No matter how valuable your skills are in the market today, they may or may not be highly valued by the market over the course of your lifetime. With artificial intelligence (AI) threatening to devalue entire categories of human work, we need to be more purposeful in recognizing a key distinction: the market value of a set of skills is not the same as its human value.  ...the US has become a service economy.  Many people still don’t recognize caregiving, for example — whether for the very young or very old — as a particularly skilled profession. This is mistaken. Anyone who has ever had a teacher who changed the course of their life simpl
Read more

Workshop Highlights - Build AI Apps using Google AI Studio & Gemini AI

Image
Harsh Dattani's ~60-minute walkthrough of Google AI Studio during the workshop " Build AI Apps using Google AI Studio & Gemini AI " provides all the essentials you need to get started. Topics covered: Google AI Studio -browser-based IDE for prototyping with generative models Gemini AI - lets you access the latest generative models from Google API key - prerequisite for building apps with Gemini AI Prompt engineering Prompt Gallery  - examples of what's possible with Gemini models Fine tuning  - provides a mechanism for curating output when you have a small dataset of input/output examples System Instructions - for developers to manage prompts  idx.dev - cloud-based IDE for building Web, Android apps Focus of the workshop is on the inner loop of software development Google AI Studio provides several interfaces for prompts that are designed for different use cases Google AI Studio is a good starting point for beginners and small-scale projects, while Vertex AI St
Read more