Difference between revisions of "User talk:Charlesnepote"
Jump to navigation
Jump to search
(More complex examples) |
(Data quality issue with percentage) |
||
(3 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | I'm also going to use this page for some tests. | + | I'm also going to use this page for some tests with https://www.mediawiki.org/wiki/Extension:External_Data . |
{{#get_web_data: | {{#get_web_data: | ||
Line 45: | Line 45: | ||
{{!}} {{{code}}} | {{!}} {{{code}}} | ||
{{!}} {{{name}}} | {{!}} {{{name}}} | ||
+ | }} | ||
+ | |} | ||
+ | |||
+ | == Data quality test == | ||
+ | |||
+ | {{#get_web_data: | ||
+ | url=https://world.openfoodfacts.org/category/vegetable-oils/nutrition-grade/b.json&fields=code,product_name&page_size=100&nocache=1 | ||
+ | |format=JSON | ||
+ | |use jsonpath | ||
+ | |data=count=$.count,code=$.products[*].code,name=$.products[*].product_name | ||
+ | |cache seconds=360 | ||
+ | |use stale cache | ||
+ | }} | ||
+ | |||
+ | {{#get_web_data: | ||
+ | url=https://world.openfoodfacts.org/category/vegetable-oils.json&fields=count&nocache=1 | ||
+ | |format=JSON | ||
+ | |use jsonpath | ||
+ | |data=count_category=$.count | ||
+ | |cache seconds=360 | ||
+ | |use stale cache | ||
+ | }} | ||
+ | |||
+ | {{#external_value:count}} of {{#external_value:count_category}} ({{#expr: ({{#external_value:count}} / {{#external_value:count_category}} * 100)round2}}%) vegetable oils with Nutri-Score B (100 products max displayed): | ||
+ | {| class="wikitable" | ||
+ | ! Name | ||
+ | ! Code | ||
+ | {{#for_external_table:<nowiki/> | ||
+ | {{!}}- | ||
+ | {{!}} {{{name}}} | ||
+ | {{!}} {{Product|{{{code}}}}} | ||
}} | }} | ||
|} | |} |
Latest revision as of 09:35, 1 October 2021
I'm also going to use this page for some tests with https://www.mediawiki.org/wiki/Extension:External_Data .
Simple test
Products with funny barcodes:
Code |
---|
7622210501240 |
4003171036249 |
0678963100206 |
6408430010998 |
4388844148840 |
4056489230403 |
23006096 |
5760466878333 |
4012824401983 |
4056489526872 |
8857124162105 |
4903333066254 |
5060250610058 |
6001108028044 |
4388844237773 |
5292705000064 |
6291002400019 |
8480000105684 |
7501020515343 |
8002469561421 |
20036188 |
4036303138467 |
4036303138481 |
4104060024931 |
4104060027789 |
4104060030772 |
4104060031533 |
4104060030796 |
4104060031304 |
4104060031427 |
4104060031649 |
4104060011184 |
4104060000041 |
4104060024726 |
4104060029196 |
8424790109040 |
8424790210029 |
8424790200037 |
8424790111012 |
8424790111005 |
8424790210036 |
8424790101341 |
8424790106025 |
5601024131111 |
5601024134136 |
5601024122522 |
5601024301231 |
40363486 |
40363028 |
40466071 |
5000181028133 |
4016241015228 |
7310865075376 |
5711953116681 |
20092016 |
7613033174667 |
7613033162220 |
7613036271868 |
7613037962215 |
7613036268882 |
7613037933017 |
7613034704436 |
7613032341640 |
7613036862295 |
7613034584236 |
7613035001848 |
7613035617216 |
7613033157776 |
7613031587339 |
7613034389398 |
7613033091391 |
5011546498492 |
5608531001043 |
5608531001036 |
0050000274444 |
0072310001770 |
0072310010925 |
5060490400051 |
8004673700320 |
4056489272410 |
3250391610389 |
3250390808411 |
3250391201327 |
40876191 |
4056489189121 |
4056489209997 |
4056489300786 |
4006952006912 |
4006952002532 |
4006952007896 |
4006952007940 |
4006952007902 |
20406561 |
4006952008121 |
4006952007421 |
4006952006943 |
4006952008169 |
4006952007049 |
20123550 |
7622210475411 |
7622210608741 |
8410000817911 |
7622300654177 |
7622300563523 |
7622300366827 |
7613031300655 |
8480000108487 |
8480000108128 |
8480000107480 |
17579988 |
7622210244864 |
20899677 |
8695077100092 |
5601175101124 |
5601175103135 |
5601244202318 |
5601244202677 |
5601244202660 |
5601244202684 |
5603722508752 |
5601244700005 |
5601244500063 |
5601244202332 |
5601244201960 |
4056489210009 |
6342462000315 |
6342462010000 |
3173286828204 |
3850104266218 |
20621483 |
4056489515951 |
5601009942121 |
5601050034516 |
5601244500070 |
0869198000137 |
0850034069340 |
29074945 |
3373831215606 |
6281022167726 |
4601576012624 |
20351168 |
4056489592402 |
3760122961876 |
5287001688047 |
4901330573041 |
4056489488194 |
6009881007614 |
4056489136354 |
8000500407394 |
3292590842345 |
4056489671442 |
3332930012073 |
8002885007480 |
8002885000573 |
8850389112144 |
4903333214327 |
6009881007645 |
8936119181168 |
0612322000776 |
189913891365460 |
7613031625758 |
4012824402614 |
3760279120171 |
7071688004614 |
3033491485756 |
4601075391923 |
8426904170533 |
4056489246053 |
8426904171875 |
8426904176849 |
8426904170687 |
8426904172650 |
8426904170786 |
8426904170069 |
8426904176351 |
8426904176344 |
8426904170700 |
8426904170601 |
0612322000790 |
0612322030087 |
3252210390014 |
4036300002648 |
20632984 |
3507001000161 |
5601244201984 |
3387390326468 |
3339572120005 |
5601511000012 |
3273221113195 |
4056489696216 |
8412600028605 |
8480000861603 |
4056489470717 |
5601050037272 |
7613036668378 |
3250392712525 |
5601050037777 |
5900020036988 |
5603722520594 |
5603729555995 |
5601050037289 |
20619848 |
7613032222109 |
7613036669498 |
5601050036909 |
5900020032799 |
20255138 |
5601050037517 |
5900020036179 |
3387390326574 |
8006460022004 |
5601050036268 |
5900020036162 |
7613038969510 |
56002621 |
7501059243873 |
5601511000708 |
Test with "product" macro
Products with funny barcodes:
Rich test chaining two requests
Products with funny barcodes:
Code | Name |
---|---|
4056489300786 | Bio Muesli croustillant chocolat |
3252210390014 | |
3387390326574 | Cookie Crisp |
3033491485756 | Hipro Fraise Framboise |
20621483 | Special Flakes Bran Flakes |
7613036669498 | Cheerios Bio |
4056489189121 | Roggen Vollkorn-Knäckebrot |
40876191 | nuss-beeren-mix |
4056489526872 | Muesli Crunchy chocolat noir et noisettes grillées |
3250392712525 | Skyr nature |
5900020036988 | Cheerios Aveia |
5000181028133 | LactoFree Semi Skimmed Milk Drink 1 Litre |
3760122961876 | Petits beurre Comté et poivre noir de Madagascar |
4104060024931 | Bio-Kefir mild |
7613033174667 | Dolce Gusto Café au Lait |
8424790111005 | Kefir |
3387390326468 | Chocolat au Lait |
4056489246053 | Biscuits au Choconussa |
4056489209997 | Crunchy Muesli Choco & Nuts |
4056489515951 | Fruta Muesli Integral |
0612322030087 | Chocolate Chip Oat Biscuit Breaks |
7613036271868 | Capsules NESCAFE Dolce Gusto Cappuccino Extra Crema 16 Capsules |
7613033162220 | Dolce Gusto Nesquik |
20036188 | Runde braune Lebkuchen - Zartbitterschokolade |
Data quality test
226 of 21883 (1.03%) vegetable oils with Nutri-Score B (100 products max displayed):
Name | Code
|
---|---|
Nutrioli | (see product 7501039120149 m) |
Crinkle Cut Oven Chips | (see product 20809973 m) |
tame and shine spray | (see product 5012254058541 m) |
Naturalia Avocado Oil | (see product 0059749979702 m) |
castor oil | (see product 0746092298054 m) |
Olive oil flavoured with chilli | (see product 01709834 m) |
Aceite de oliva virgen extra ecológico | (see product 8437010369896 m) |
Butter Flavored Cooking Spray | (see product 0021130512553 m) |
Field day, coconut oil cooking spray | (see product 0042563603854 m) |
Olio | (see product 8005305600032 m) |
Huile de tournesol | (see product 5060463190002 m) |
Original vegetable oil spray | (see product 0040600341226 m) |
Flavored no stick cooking spray | (see product 0078742229423 m) |
Sesame oil | (see product 8210040351006 m) |
Extra Virgin Olive Oil | (see product 9415102000833 m) |
Pure huile végétale | (see product 6046000006400 m) |
Sunflower oil | (see product 5904413693031 m) |
Cooking Spray, Original | (see product 0040600215893 m) |
Aceite de coco | (see product 7798260050233 m) |
Grapeseed oil | (see product 5010251481683 m) |
Coconut oil non-stick cooking spray | (see product 0026700156182 m) |
Omaar pure sunflower oil | (see product 8691313988851 m) |
Chill oil cooking spray | (see product 5000442008089 m) |
Trader joe's, coconut oil spray | (see product 00505000 m) |
Avocado oil | (see product 0041220414789 m) |
Vegetable Oil Cooking Spray | (see product 0078742229416 m) |
Bakers baking spray | (see product 0605021774000 m) |
Spray butter | (see product 0029000651517 m) |
Urbani White Truffle Oil | (see product 8000146500046 m) |
Canola Oil Cooking Spray | (see product 0849607090515 m) |
Canola cooking spray | (see product 9415077035519 m) |
Sunflower oil | (see product 0022506117105 m) |
Huile de sesame | (see product 4892958998227 m) |
Canola oil | (see product 9300601250769 m) |
Aceite comestible puro de canola | (see product 0096619597727 m) |
non stick cooking spray | (see product 0036800459922 m) |
Tahin chiaro | (see product 8057733610039 m) |
Haricots verts | (see product 00954464 m) |
Detox citron | (see product 04559757 m) |
Ghee cooking spray | (see product 0742392931172 m) |
100% Avocado Oil Cooking Spray | (see product 0070404004539 m) |
Coconut oil | (see product 0070404004522 m) |
Baking No-Stick Cooking Spray | (see product 0041303043035 m) |
Vegetable oil no-stick cooking spray | (see product 0041303019221 m) |
Chosen blend safflower, coconut & avocado oils spray, chosen blend | (see product 0853807005965 m) |
Healthy chef, butter cooking spray | (see product 0849607090522 m) |
Coconut Oil Cooking Spay | (see product 0711535509042 m) |
Shoprite, vegetable oil cooking spray | (see product 0041190048625 m) |
Azafran organic cold pressed sesame oil | (see product 02763909 m) |
Toasted Sesame Oil | (see product 0731050004556 m) |
Ghee blend non stick cooking spray | (see product 0021130076024 m) |
Ahold cooking spray vegetable oil | (see product 0688267061318 m) |
Extra Virgin olive oil | (see product 8002470031623 m) |
Huile d’avocat | (see product 3245270003321 m) |
Vegalene premium - 3 oil blend | (see product 0080378220217 m) |
Pure Grapeseed Oil | (see product 0052851060023 m) |
Huile d’argane | (see product 6111262583867 m) |
Sunflower seed oil | (see product 8697419812038 m) |
100% Natural Canola Cooking Spray | (see product 0048155905764 m) |
Garlic flavored organic extra virgin olive oil | (see product 0658686600689 m) |
White truffle Oil | (see product 0656285171081 m) |
Avocado oil spray | (see product 0671635701879 m) |
Organic artisan oils extra virgin olive spray | (see product 0854259005183 m) |
Artisan oils high-heat cooking grapeseed spray | (see product 0854259005367 m) |
Coconut oil spray | (see product 0853807005972 m) |
Warm gingerbread avocado oil spray | (see product 0815074021925 m) |
Canola oil spray | (see product 0041220129706 m) |
Garlic Oil | (see product 0722487330103 m) |
Canola oil & extra virgin olive oil | (see product 0838670593214 m) |
Coconut Oil | (see product 0041220129676 m) |
Pure Avocado oil | (see product 0077890487068 m) |
Coconut oil spray | (see product 0041415046320 m) |
Vegetable Oil Cooking Spray | (see product 0193476001265 m) |
100% Pure Olive Oil | (see product 0078336826366 m) |
Winco foods, non-stick vegetable oil | (see product 0070552900141 m) |
Nonstick canola oil cooking spray | (see product 0085239026274 m) |
Pure Grapeseed Oil | (see product 0052851060061 m) |
100% pure avocado oil spray | (see product 0061483059367 m) |
Coconut oil | (see product 0708547015029 m) |
Olive Oil | (see product 0022506265813 m) |
Italian herb spray | (see product 0815074021871 m) |
Chipotle avocado oil spray | (see product 0815074021864 m) |
Avocado Oil | (see product 7502006272298 m) |
Coconut oil | (see product 0070552900301 m) |
Non-stick Vegetable Oil Cooking Spray | (see product 0842379191992 m) |
Coconut oil cooking spray | (see product 0481037814509 m) |
Butter Flavor Cooking Spray | (see product 0038024301315 m) |
Huile pépins de raisin | (see product 3077318891696 m) |
Vegetable oil | (see product 0070784443607 m) |
Light Flavor Grapeseed Oil Spray | (see product 0658686600412 m) |
Infused avocado oil spray garlic | (see product 0815074021857 m) |
Extra virgin coconut oil non-stick cooking spray | (see product 0857320002104 m) |
Avocoado oil | (see product 0021130295715 m) |
Huile de noix de coco | (see product 0628235330343 m) |
Huile de chanvre | (see product 0872428000364 m) |
Gmo hemp oil | (see product 0844197011964 m) |
Coconut Oil | (see product 0032251463228 m) |
Kirkland Canola Oil Cooking Spray | (see product 0096619659050 m) |
Basilolio Condiment, Extra Virgin Olive Oil With | (see product 0039153100268 m) |
No Stick Toasted Sesame Oil Cooking Spray | (see product 0041220414826 m) |