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:
( 1 review ) 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
(58 Reviews)
6.2

40 freelancers are bidding on average €284 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
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
(131 Reviews)
7.3
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
(72 Reviews)
7.4
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
(214 Reviews)
7.1
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
(105 Reviews)
6.7
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
(315 Reviews)
7.0
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
(163 Reviews)
7.1
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
(64 Reviews)
6.4
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
(47 Reviews)
6.7
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
(43 Reviews)
6.6
MohsanEijaz

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

€325 EUR in 7 days
(91 Reviews)
6.3
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
unix515

Hello! Do you know about scraping. I think scraping is a good method for your project. I am a web developer. I have checked your project description carefully. I can build it If you hire me, I am gonna do my best. More

€500 EUR in 9 days
(37 Reviews)
5.5
yoyopriyam

Hello, I am an experienced python developer.. I have read your description .. I can write a program to get url from excel file and scrape the INVESTIGATORS...and save them in a excel file. Inbox me and lets discuss det More

€150 EUR in 1 day
(26 Reviews)
5.4
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
(15 Reviews)
5.3
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
(28 Reviews)
5.3
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
(36 Reviews)
5.4
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
(28 Reviews)
5.0
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
(50 Reviews)
5.1
rajorshi1001

Hi, I am a python developer and I can write a python script to fetch the Investigator(s)/sub Investigators from the given url and store them in the excel file. I can complete this task within a couple of days. Looking More

€150 EUR in 2 days
(31 Reviews)
5.1