Open ambarishK opened 5 years ago
First glance ... This is NOT a normalised bibliography table. Here are three records which contain duplicated bibliography but different "bibliography codes"
These are NOT bibliography codes. I suspect they are profile codes and they have no place in bibliography.
Deduplicate the bibliographic records, remove the profile codes. Do the profile codes occur in the Profile data.
Personally I think a table of Profiles (i.e. compound _ percent) would be much easier to manage.
I have not checked anything else.
P.
50,JEFvusp2000Lea,"VOL. 12, 159-162 (Mar/Apr 2000)","Chemical Composition of Fennel Oil, Foeniculum vulgare Miller, from Spain","Noemi Garcia-Jimenez, Maria Jose Perez-Alonso, Arturo Velasco-Negueruela",Journal of Essential Oil Research,https://doi.org/10.1080/10412905.2000.9699487,10.1080/10412905.2000.9699487, 51,JEFvusp2000See,"VOL. 12, 159-162 (Mar/Apr 2000)","Chemical Composition of Fennel Oil, Foeniculum vulgare Miller, from Spain","Noemi Garcia-Jimenez, Maria Jose Perez-Alonso, Arturo Velasco-Negueruela",Journal of Essential Oil Research,https://doi.org/10.1080/10412905.2000.9699487,10.1080/10412905.2000.9699487, 52,JEFvusp2000Ste,"VOL. 12, 159-162 (Mar/Apr 2000)","Chemical Composition of Fennel Oil, Foeniculum vulgare Miller, from Spain","Noemi Garcia-Jimenez, Maria Jose Perez-Alonso, Arturo Velasco-Negueruela",Journal of Essential Oil Research,https://doi.org/10.1080/10412905.2000.9699487,10.1080/10412905.2000.9699487,
On Sun, May 12, 2019 at 8:58 PM Ambarish Kumar notifications@github.com wrote:
Sir,
I have uploaded the bibliography table - bibliography.csv. Please go through it and suggest in case of any change.
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/gilienv/EssOilDB/issues/35, or mute the thread https://github.com/notifications/unsubscribe-auth/AAFTCS6D7V3IZICDLPCOTUTPVBZFNANCNFSM4HMLDURA .
-- Peter Murray-Rust Reader Emeritus in Molecular Informatics Unilever Centre, Dept. Of Chemistry University of Cambridge CB2 1EW, UK +44-1223-763069
Sir,
I duplicated the bibliographic records and removed the profile codes. Profile codes are present in the infopdata as primary key.
Updated table - bibliography.csv
Please check.
Sir,
I have uploaded the bibliography table -
bibliography.csv
. Please go through it and suggest in case of any change.