normalize country names for plant origins against Wikidata

[petermr]

@ambarishK Please collect all sections which mention where plants/oils originated (titles usually like "Origin of plant material").

Build a new TSV file which records

• name of section containing plant or oil origin
• country/countries mentioned in this section specifying where oil came from
• look up country in Wikidata

[ambarishK]

OK sir.

[ambarishK]

Sir, please review the extraction sheet for plant material location - country20191222.tsv.

Most of locations are into sub-section of Materials and methods - Plant material.

There are records extracted from first 30 articles of oil186.

[petermr]

Looks a useful start

On Sun, 22 Dec 2019, 12:13 Ambarish Kumar, notifications@github.com wrote:

Sir, please review the extraction sheet for plant material location - country20191222.tsv https://github.com/petermr/CEVOpen/blob/master/articleAnalysis/oil186/raw/country20191222.tsv .

There are records extracted from first '30' articles of 'oil186'.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/petermr/CEVOpen/issues/72?email_source=notifications&email_token=AAFTCS65LUHRZ3VP6633WJDQZ5KW5A5CNFSM4J6JBMG2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEHPORWY#issuecomment-568256731, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAFTCS4CHSYTCSN2D3GT3BDQZ5KW5ANCNFSM4J6JBMGQ .

[ambarishK]

Sir, please review the complete extraction of plant material location extraction sheet - country20191222.tsv

There are 138 articles which mention plant material location.

Two articles which mentions multiple plant names.

PMC5674267 PMC5694587

Articles which mentions multiple plant locations are as following.

PMC5622398 | Essential Oil Extracted from Rosemary (R   EO) | England | Q21
PMC5622398 | Essential Oil Extracted from Rosemary (R EO) | France | Q142
PMC5622398 | Essential Oil Extracted from Rosemary (R EO) | Portugal | Q45
PMC5622398 | Essential Oil Extracted from Rosemary (R EO) | Russia | Q159
PMC5622398 | Essential Oil Extracted from Rosemary (R EO) | Spain | Q29

PMC5622403 | Chemical Composition of Essential oils of   Artemisia Species | Iran | Q794
PMC5622403 | Chemical Composition of Essential oils of Artemisia Species | India | Q668
PMC5622403 | Chemical Composition of Essential oils of Artemisia Species | China | Q29520

PMC5849928 | Preparation and analysis of AEO | Iran | Q794
PMC5852288 | Material | Cameroon | Q1009

PMC5970210 | Acaricidal activities and color deformation   effects of the essential oils of M. officinalis cultivated in the three   different countries | France | Q142
PMC5970210 | Acaricidal activities and color deformation effects of the essential oils   of M. officinalis cultivated in the three different countries | Ireland | Q27
PMC5970210 | Acaricidal activities and color deformation effects of the essential oils   of M. officinalis cultivated in the three different countries | Serbia | Q403

There are 48 articles which either does not mention plant material location or not related with plant EO.