icone soleil icone lune

DB management with SQL

Project Description

For this project, I had to perform data extraction on an open-source database (OpenFood Facts), which listed several hundred products with various nutritional information and their nutriscores. It was necessary to explore the data, remove incomplete records, identify relevant data to answer the question, manipulate it, and extract it into a CSV file. Then, we used this data to create charts with RStudio and carry out a complete mathematical analysis written in English.

Skills Acquired

Data exploration and analysis

Database querying

Cleaning incorrect or incomplete data

Selecting relevant data

Exporting data as usable CSV files

Creating charts with RStudio to visualize and analyze results

Complete analysis of the results in English