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.

Taidot: Python, Tietojen kaavinta verkosta, tietojärjestelmäarkkitehtuuri, PHP, Excel

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Leefdaal, Belgium

Projektin tunnus: #20778793

Myönnetty käyttäjälle:


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 Lisää

€150 EUR 1 päivässä
(52 Arvostelua)

49 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

€325 EUR 7 päivässä
(128 arvostelua)

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 7 päivässä
(60 arvostelua)

⭐⭐⭐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+ Lisää

€325 EUR 7 päivässä
(123 arvostelua)

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 Lisää

€150 EUR 2 päivässä
(206 arvostelua)

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 3 päivässä
(98 arvostelua)

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 Lisää

€400 EUR 7 päivässä
(124 arvostelua)

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 Lisää

€500 EUR 7 päivässä
(290 arvostelua)

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 Lisää

€350 EUR 7 päivässä
(44 arvostelua)

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 Lisää

€325 EUR 7 päivässä
(41 arvostelua)

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 7 päivässä
(10 arvostelua)

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

€325 EUR 7 päivässä
(88 arvostelua)

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 Lisää

€325 EUR 7 päivässä
(72 arvostelua)

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 Lisää

€325 EUR 7 päivässä
(43 arvostelua)

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 3 päivässä
(27 arvostelua)

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 Lisää

€325 EUR 7 päivässä
(13 arvostelua)

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 Lisää

€325 EUR 7 päivässä
(24 arvostelua)

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

€155 EUR 3 päivässä
(47 arvostelua)

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 Lisää

€300 EUR 3 päivässä
(23 arvostelua)

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 Lisää

€200 EUR 7 päivässä
(19 arvostelua)

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 Lisää

€150 EUR 1 päivässä
(9 arvostelua)