Downloading and parsing of 27M XML datasets
$30-250 USD
Pagado a la entrega
1. Please download 27M datasets from [login to view URL] to [login to view URL]
2. Parse the following fields and store them into MySQL
<PMID>
<ArticleDate>
<ArticleTitle>
<Language>
<Journal>
<Keyword>
<Author>
<AffiliationInfo>
Parsing details:
- Make sure to parse first and last name of the Authors
- Because Keywords can be multiple, please store then in an extra table and use a mapping table to map them to the articles.
- Create a mapping table between Author and PMID, as one PMID can have n Authors.
- Store assign unique IDs to Authors and AffiliationInfo and store them in two tables to then map them because the same author can be linked to n AffiliatenInfo
- Please parse AffiliationInfo in different fields, seperated by comma - like on [login to view URL]
<AffiliationInfo>
<Affiliation>Institute of Pathology, University of Heidelberg, Heidelberg, Germany ; Present address: Institute of Pathology, Elbe Kliniken, Klinikum Stade, Bremervörder Str. 111, D- 21682 Stade, Germany.</Affiliation>
</AffiliationInfo>
Becomes:
AffiliationInfoLine01: Institute of Pathology
AffiliationInfoLine02: University of Heidelberg
AffiliationInfoLine03: Heidelberg
AffiliationInfoLine04: Germany
AffiliationInfoLine05: Present address: Institute of Pathology
AffiliationInfoLine06: Elbe Kliniken
AffiliationInfoLine07: Klinikum Stade
AffiliationInfoLine08: Bremervörder Str. 111
AffiliationInfoLine09: D- 21682 Stade
AffiliationInfoLine10: Germany
Nº del proyecto: #10476684
Sobre el proyecto
22 freelancers están ofertando un promedio de $135 por este trabajo
Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W Más
Hi, my name is Sevinc. I read your "Downloading and parsing of 27M XML datasets" project descriptions carefully before bidding. I checked the urls you provided, along with your required data fields as well... I got w Más
Hi, Greetings of the day!! Thanks for review my Bid. I have gone through from your description and can do this work comfortably. Please open this PMB. Waiting for your response!! Regards, Ashi Más
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start
hello, sir: c/c++/python expert worked for samsung & huawei maybe more details will be helpful a sample can be provided before hired. hope to get message from u ty
Hi, I have a lot of experience in web scraping and data extraction with python. I know my way around with mysql database and I can provide you finished project within 3 days. Look forward to hearing from you.
Hello, I have done this a few different ways once in Java and twice in PHP. 27 million entries shouldn't be a problem. I already have a library that handles MySQL entries of 1,000 inserts per 5ms. All three times w Más
Hello sir, We do all type of data entry works. And I have a staff of 15 people and more then 10 typist as a backup. Regarding accurancy and TImeline I always give a guranteed task. You can surely expect a power Más
I am looking for an opportunity to utilize my skills and abilities working with organization that offer professional growth while being resourceful, innovative and flexible
Hi, If you are ok with the proposal, the date will be parsed as soon the files are donwloaded (as there are alot of files this can take some time). Best regards, Goran