Completed

Python script to manipulate data in Excel files

Dear Software Developers,

My company needs a Python script that can manipulate various types of data in Excel files (read and write in Excel sheets according to simple rules).

It needs to be able to open web pages and parse the text for keywords.

The input would be an Excel sheet, with a column containing links to clinicaltrials.gov. The script would need to read each webpage and look for the keyword "*investigator: " and retrieve (copy paste) the string of characters that follows it until the line return character, in a pre-defined column in the same Excel sheet (or a copy of it). Principal and sub-investigators need to be added to different columns to differentiate them.

Here are some examples :

- with only 1 principal investigator : [login to view URL]

- with several principal investigators : [login to view URL]

- with sub-investigators as well : [login to view URL]

The aim is to be able to list all the investigators of some specific clinical studies, and we will provide the script with an excel sheet with direct links to all the studies we are interested in.

If this project is successful, we have another project that is not more complex but will be very useful for us and is also data manipulation in Excel files (even simpler than this, in fact, but this is more urgent). We will have a lot of returning business for you!

Thanks in advance for your help !

Kind regards.

Skills: Python, Web Scraping, Software Architecture, PHP, Excel

See more: fetch data excel files, perl script retrieve data excel, python script text files, sample perl script read data excel, excel macro script insert data spreadsheet, python script extract data web page, python script crape data, python script extract data, python script read data text file, python script extract data website, python script rs232 data, python script read data form, python script read data serial port, python script retrieve data website, python script scrape data, python script automate data entry website, python script extract data emails, python script copy paste text files, python script automate data download website, python script download data url site

About the Employer:
( 0 reviews ) Leefdaal, Belgium

Project ID: #20778793

Awarded to:

novepi

Hi there, The requirements are quite clear and straightforward to implement so no questions really. The script will fetch the investigators of a certain study. The link to study will be retrieved from the excel file a More

€150 EUR in 1 day
(55 Reviews)
6.1

48 freelancers are bidding on average €297 for this job

KashirinA

⭐⭐⭐Full stack web scraper⭐⭐⭐ Dear client I read your job description carefully I m sure about your project and I can finish before deadline. I have good skills about python using selenium I have experienced about 6+ More

€325 EUR in 7 days
(124 Reviews)
7.4
DevStar925

Hello How are you? I read your description carefully. I have a good experience in web scraping with python and C#. So I can finish quickly. I would like to discuss in detail via chat. Thanks

€500 EUR in 7 days
(64 Reviews)
7.2
bestit4u

Hi. I am very interested in your project, because I have much experience in such projects. I have good skills with the program language including C/C++, C#, java, php, asp.net, python, VB.NET. So I have expert and smar More

€325 EUR in 7 days
(128 Reviews)
7.3
devi222

Hi Sir, I can make a script for this. Im a Python Programmer. I have created many Bots to scrape the websites like Google, Alibaba(suppliers data), Linkedin, Facebook, Trulia(real estate, homes), [login to view URL], Amazon(us More

€150 EUR in 2 days
(210 Reviews)
7.0
logos104

Hi. I am professional software developer with experience in Python, C++, C#, Scala and other languages. I can the web scraping and Excel file reading/writing.

€300 EUR in 3 days
(98 Reviews)
6.6
urmate

Hi There I've excellent programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Programming and Computer project according to 100% accuracy and requ More

€500 EUR in 7 days
(290 Reviews)
6.9
Mickelson

Hi Nice to meet you. I have enough experience in python script. Below the libraries are I used in past project. selenium, pandas, matplotlib, lxml, beautifulsoup, scipy, and other useful libraries. I have written some More

€400 EUR in 7 days
(131 Reviews)
6.9
adeelpirzada

Hi, Allow Me to Introduce Myself i have done scrapping almost on Half of Worldwide web including eCommerce giants (Amazon, eBay, craigslist) News Feed, Social media websites, API's. I develop my own scrapers an More

€350 EUR in 7 days
(44 Reviews)
6.6
alexwmsoft

100% Completion Rate and 5 Stars Dear, employer. My name is Lee, I am an experienced web developer, and web scraping expert. I have good experiences in web scraping using PHP, Python, Java and so on. I read your job More

€325 EUR in 7 days
(42 Reviews)
6.5
MohsanEijaz

I am interested in your project because I have complete such a projects. lets start it. Mohsan

€325 EUR in 7 days
(89 Reviews)
6.3
YuriyStepanovich

Hi. I'm good python developer, I have much experienced in Python and Excel so I can do your project perfectly. I hope to interview with you soon. Thanks

€325 EUR in 7 days
(10 Reviews)
6.2
xinglong717

Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Lookin More

€325 EUR in 7 days
(72 Reviews)
5.9
susanna2018

hi! Dear , my Client! i am very pleasure the opportunity to discuss this job with you. i am a full time freelancer with skills and experience on python, laravel,codeigniter,wordpress and angular.js, vue.js, react.js no More

€325 EUR in 7 days
(45 Reviews)
5.8
albertpopov46

Hi Dear I read your requirements carefully. I have rich experience with Python Django, Flask, selenium, Web Scrapy, software architecture and so on. You can see my good reviews for python projects. Please touch me. I w More

€325 EUR in 7 days
(29 Reviews)
5.2
RaulBlanko

Hello. I am a Python developer. I have enough experience in both things you need: web scraping and Excel data processing. You can find the reviews of my past similar tasks on my profile page. Best regards, Pavlo

€299 EUR in 3 days
(27 Reviews)
5.3
BlackEagle86

Hi, High talented CopyWriting, Article writer, Data Entry, VBA, Access, Microsoft Office, Java, Python and R, C#, C++, QT expert is here! I have read your proposal very carefully and I have come to learn to that job i More

€325 EUR in 7 days
(13 Reviews)
5.3
urstealth

Hii, I have lots of python excel sheet manipulation experience. As well as regex experience. Let's discuss more

€155 EUR in 3 days
(47 Reviews)
5.0
shiyusun180409

Hello.. I have read your post very carefully and I have understood what you want. I am a 100% completion Developer. I have experience of develoapment like this. As an experienced web developer, I am sure I can handle y More

€300 EUR in 3 days
(23 Reviews)
4.7
arundutt83

Dear Sir, Please correct me if i understood wrong. Basically, you want to parse data based on some params and copy into excel. * This is the mail principle of this utility. I am having one question. Do you want it t More

€200 EUR in 7 days
(19 Reviews)
3.9
amuratagic

Hello, I have read your description carefully and I understand that you need this done urgently. Because I have 2 years of experience working with Python I can complete your project very quickly. In your description yo More

€150 EUR in 1 day
(9 Reviews)
3.8