進行中

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.

スキル: パイソン, ウェブ記事のスクラップ, ソフトウェアアーキテクチャ, PHP, エクセル

さらに表示: 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

採用者について:
( 0件のレビュー ) Leefdaal, Belgium

プロジェクトID: #20778793

アワード:

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 もっと

€150 EUR 1日以内
(52レビュー)
6.1

49人のフリーランサーが、このジョブに平均€294で入札しています

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 もっと

€325 EUR 7日以内
(128件のレビュー)
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 7日以内
(60件のレビュー)
7.2
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+ もっと

€325 EUR 7日以内
(123件のレビュー)
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 もっと

€150 EUR 2日以内
(206件のレビュー)
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 3日以内
(98件のレビュー)
6.6
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 もっと

€400 EUR 7日以内
(124件のレビュー)
6.8
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 もっと

€500 EUR 7日以内
(290件のレビュー)
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 もっと

€350 EUR 7日以内
(44件のレビュー)
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 もっと

€325 EUR 7日以内
(41件のレビュー)
6.5
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 7日以内
(10件のレビュー)
6.2
MohsanEijaz

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

€325 EUR 7日以内
(88件のレビュー)
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 もっと

€325 EUR 7日以内
(72件のレビュー)
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 もっと

€325 EUR 7日以内
(43件のレビュー)
5.8
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 3日以内
(27件のレビュー)
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 もっと

€325 EUR 7日以内
(13件のレビュー)
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 もっと

€325 EUR 7日以内
(24件のレビュー)
5.0
urstealth

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

€155 EUR 3日以内
(47件のレビュー)
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 もっと

€300 EUR 3日以内
(23件のレビュー)
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 もっと

€200 EUR 7日以内
(19件のレビュー)
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 もっと

€150 EUR 1日以内
(9件のレビュー)
3.8