1
edit
Reusing Open Food Facts Data: Difference between revisions
Reusing Open Food Facts Data (view source)
Revision as of 08:21, 30 September 2020
, 30 September 2020→R stat
(Add JSONL doc) |
(→R stat) |
||
| Line 77: | Line 77: | ||
==== R stat ==== | ==== R stat ==== | ||
For people who have R stat skills, there are [https://www.kaggle.com/openfoodfacts/world-food-facts/kernels?sortBy=hotness&group=everyone&pageSize=20&datasetId=20&language=R more than 50 notebooks from Kaggle community]. | For people who have R stat skills, there are [https://www.kaggle.com/openfoodfacts/world-food-facts/kernels?sortBy=hotness&group=everyone&pageSize=20&datasetId=20&language=R more than 50 notebooks from Kaggle community]. | ||
Moreover, here a link to transform .bson file to a dataframe: https://github.com/gnaweric/openfoodfact_database_queries | |||
With the use of {mongolite}, first connect to the base, then import the .bson file, then get a sample of it to make sure it is ready. Finally save it to a .rdata file for example. | |||
Beware, each line is a product and some variable need to be unnest: tidyverser::unnest_wider() | |||
=== JSONL export === | === JSONL export === | ||