Find Jobs
Hire Freelancers

extract data from web database and paste it to excel - Repost - open to bidding

$2-8 USD / hour

Closed
Posted about 10 years ago

$2-8 USD / hour

I want the terms to be searched in the expert search field on www.clinicaltrials.gov. This expert search is difficult to find: first go to advanced search, type in anything, click on search, then click on modify the search results. You'll find the link for expert search in the upper right part of the website. Expert search is characterized by a large search field... Just delete the prior search string and copy & paste the search strings from the attached excel file (input data sheet). There are about 500 search strings of them. There is no data for every year, as you'll notice. Then please download the entire results list. You'll find the download link above the results list. I want to have all 21 data fields. Select the number of studies to download: click on the option at the bottom of the dropdown menu, where you'll find the number of total hits. There are multiple download formats. Please choose comma-separated (csv) and xml). I want to have XML as a backup, only csv shall be processed. Please name the downloaded xml files as follows: Combination of firmname from column A and year from line 1 (years 2003-2010), (what you'll do with csv depends on you - if you directly extract the content, then it's fine. If you prefer to download all files first, then please make sure that you name them properly!) I want the data to be in columns as with the csv files. Then I want the data to be in the following format: Column A contains the firm name, column B contains the year (2003-2010). Columns C, D, E.... are the data you downloaded. Please have a look at the example which, at the same time, is the file to be completed... Just in case there should be too many entry terms in the first field (where you get an error message), please proceed with the others and notify me. You may notice that the data is somewhat overlapping (actually I look for 2001-2003, 2002-2004, 2003-2005, so entries for years 2003 appear three times - that's correct). Summarizing: Go to that website and use the expert search Copy the search terms for the companies and year listed in the attached excel file (input data sheet) and paste them to the web database search field. Then download the files (csv + xml) for ALL hits and ALL fields (attention, you may forget to adjust that when you download hundreds of files). Open the csv file, copy its content and paste it to the file (results sheet) that I attached. Rename the xml files as described. Finally, please provide the excel file plus the xml files (the latter all inside one or a few ZIP files). Please provide an estimate how many hours you'll need and on which day you'll be able to complete the task. Thank you very much.
Project ID: 5817463

About the project

16 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average $4 USD/hour for this job
User Avatar
Hello Sir, We are a well built set up with excellent skilled operator with lot of experience in this segment/skill,have complete more than 200 similar job, i have gone through your project description, its really a simple task, we can make a well formatted,error free list. Sir, we are waiting for your reply for communicate also like to make a sample if you allow by a single reply. Thanks DG
$2 USD in 40 days
4.7 (221 reviews)
7.0
7.0
User Avatar
Dear hiring manager, Thank you for this wonderful opportunity. Your job post has caught my attention because I'm a web-research addict and I’m considering your job post for me with the required capabilities. I have excellent experience in web research, data mining, extracting email address and other related contact information of any business and personals, searching in Google, Bing and Yahoo search engines. I use some secret and useful search engine keywords tricks in order to extract the exact and required information. I have excellent experience in managing the extracted data in MS Excel, MS Work, Google Docs, Google Spreadsheet, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 30 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Ajharul
$3 USD in 40 days
4.9 (139 reviews)
6.3
6.3
User Avatar
Hello and have a good day! I very very interested to work in your posted job with all my knowledge, skills and ability can assure to attain good quality results. I understand what you need and I'm offer my services to work that job for you. I'm capable to begin this job now until we done completely to meet your expectations as per details & instructions. I'm very willing to give all my best I can to exert more best effort and quality time to have best result with timely manner. It's my goal to make you feel satisfy, happy and convenience with the services I will provide for this project. I will make sure efficient, reliable and accurate work to start and finish this job well done. Looking forward to join hands and work together for many years.... Thanks a lot and God bless you always! Juliepearl Yana
$2 USD in 10 days
5.0 (7 reviews)
3.3
3.3
User Avatar
Dear Hiring Manager, I can do this job efficiently and effectively Have a great day to you, I am interested to do this job and please see my elance profile link [Removed by Freelancer.com Admin], I have over 15 years experience in the field of web research, data scraping, market research, email collection, data-entry in excel, social media research, Facebook marketing and as admin/ virtual assistant. And I am a computer and web savvy, my goals are to make the employer/ customer happy and give better quality of work and I am ready to dedicate time for this project. Thank you Kind regards Heric. P. Note: I am quick, detail oriented and have high speed internet connection in my home and I look forward to hearing from you to start this job soon. Thanks
$3 USD in 40 days
4.2 (27 reviews)
3.9
3.9
User Avatar
Hello, I would like to work on this project May be my bid low compare to other but it will not affected on work. I can start work immediately and provide you within time frame. I have more than 6 yr experience in web development as well as Data processing, Thanks
$2 USD in 35 days
5.0 (3 reviews)
1.3
1.3
User Avatar
Dear Sir, We would like to take up this project right away. Please award the bid for us to provide a prompt and accurate solution. We also offer you in - depth QC process and would scale up our quality to exceed your expectation. We are back to freelancer after a pause (due to unavoidable reasons) and we have bounced back with more efficient team members. Kindly award the project to us, to serve you with better results. Regards Vater
$3 USD in 40 days
5.0 (1 review)
1.2
1.2
User Avatar
Talk with me I will do this job for you. I can do this job for you. Talk with me I will do this job for you. I can do this job for you.
$2 USD in 40 days
5.0 (1 review)
0.0
0.0
User Avatar
Hello Hiring Manager, I have expertise in Web Design,Web development,Software Development And Mobile Application.I believe that work is first and for that i give full dedication to my work and complete as per requirement. I hope that our quote is good for you.I am waiting for your valuable response to solve some question that I have. If you want to see my portfolio then tell me i will send you link of my full portfolio. Thanks & Regards, Chintan Thakar
$8 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have made many projects on excel and i m also making site including daatabase .i m interedted in this feild of devolepmnt hope you will like my work if u hire me thanks
$5 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am interested in doing this project. I have done php , cakephp, c++, html, css , jquery, ajax, wordpress and have a good knowloedge about ms office.
$2 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
HI there, I am a Bioinformatician. I guess i can do your work efficiently. I'll be available on all weekdays from 10.00 pm to 12 pm (Indian Standard Time) and for longer hours on weekends. I am good at such tasks. I'm currently working as an Intern in Accenture India. Regards
$5 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience in automation website extraction and i can give u seperate tool after finishing this project for you at affordable cost so that u can use it when ever u want to . Please let me know if you are interested in it
$11 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Aucune proposition n'a encore été fournie.
$2 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi fotso 94, My name is Lusine. I am ready to to this task and finish it on time. I can start the work immediately. Thanks, Lusine
$2 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do the work you require accurately. I am very careful with details, I take my job very seriously. I am a new freelancer on this site and I want to create a great and long time relationship with my clients. I tested the website in your project description and I managed to search and save the information as you requested. I am confident I can do the work with zero mistakes. Do not hesitate to contact me, Adrian
$3 USD in 25 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Silver Spring, United States
0.0
0
Member since Apr 10, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.