Fermé

Python 3 to update Excel values

Need a Python 3 script that will open an Excel Spreadsheet and by looking at a sheet called “By Environment” get the "server" in column E and by using “ping” find the IP Address and upgrade the value to the right in column F with the “correct” IP address?

Probably will work with Pandas library but I will yield and be interested in your simple solution that I can work with, adjust and confidently understand and interpret.

Please see the attached Excel that is a template of what is to be updated, the actual real sheet is 300 rows, please use the 6 rows in the attached “[login to view URL]

General Details

Please only BID if you know how to do this and are certain you can do this? Expecting this is something easy for about $10 or so and will be something person on this topic would know and understand. Please note there is hope we can mutually complete this task; we can leave each other nice comments and 5 stars for each?

Can you work on this and finish now? Need this basically in 2 hours, possible?

Will need to work on Desktop Sharing?

After done; can we test on Hangouts?

After done; can we test on Skype?

After done; can we test on Team viewer?

After done; can we test on Anydesk?

Is $10 ok?

(If not how much?) (Please note I am out of work and have a small budget)

(Did I miss something?) (Sorry I am broke, but that is about my budget)

Is this something you can work on now? If not now, please share how soon?

We can work on Google Hangouts/Skype/Team viewer/Anydesk or any desktop sharing you may have?

Please share your thoughts? If you have questions please confirm you read all of this, before reaching to me. My first question to you will be; did you read the project details?

Please only BID if you know how to do this and are certain you can do this? Expecting this is something easy for about $10 or so and will be something person on this topic would know and understand. Please note there is hope we can mutually complete this task; we can leave each other nice comments and 5 stars for each?

Please keep this a positive experience; and agree to do both our parts to ensure that.

Please note I need this in 2 hours, if you can not do that, please speak to me, don’t bid or cancel your acceptance of the project.

Please just don’t ask me to give you the root password; that will tell me you have not read even anything on these requirements.

There is hope you will read this all and ask a question; rather than tell me more about this, as I have exhausted every detail I know right now, and hope you will ask something that will lead this down a positive direction.

Compétences : Traitement de Données, Excel, Python, Scripting, Architecture Logicielle

En voir plus : vbscript update excel odbc connection, visual basic update excel data, update excel data, how to export data from python to excel, python for excel users, python open excel file, python read excel file xlsx, python write to existing excel file, python excel, how to append data in excel using python, python read xls, update excel data php, google finance stock update excel, macro update excel, auto directory update excel, update excel google finance, bombay stock exchange automatic update excel sheet, database update excel php, update excel sheet vb6, php mysql update multiple values

Concernant l'employeur :
( 213 commentaires ) Lyndhurst, United States

Nº du projet : #19149038

13 freelances font une offre moyenne de 24 $ pour ce travail

elym81

With the proposed budget and timeline, will create script that reads domain name from excel file and updates the same with the IP address associated with the domain. FYI: Pandas is not needed for this simple functiona Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
5.5
marianakuzmich

Hello, dear... How are you? I just read your requirements. I feel very confident in your project because I am talented Python developer with 6+ years. If you give me a chance, i'm going to work perfectly. I'll wai Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(22 Commentaires)
4.9
Prakhark19

Hello there, Myself Prakhar, i am working in python for last 3 years. I have read your description thoroughly and i am confident that i can do this easily. Let's discuss further in personal chat. Regards Prakhar.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(21 Commentaires)
3.9
bytebolt

Hi there, Well yes, pandas is the way to go. I can surely finish this off in two hours and this is not an automated bid. I have actually seen the excel and I am dying to give and take 5 stars.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(19 Commentaires)
3.9
uzairnaseer920

i will do in it cheap rate. i am expert in these programming language if you have doubt to my skill inbox me. you work will be 100 % . you will not disappointed to my work .

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(15 Commentaires)
3.5
swaminath35

Hi There, i can work on this project as per the requirement. let me know whether it is csv or xls sheet. For csv we can use default module. waiting for your reply if you are ok with me. regards Swaminathan T.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
2.0
abuakar21

Hi, I'm an expert python programmer with 2+ years experience in automation. From your Job posting, I noticed you wanted the job done at a very low price. Though the price is too low but I can help you complete this job Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.5
anupampathi9

Hi , I have lot of experience in python scripting and i do know which libraries to import for reading/writing excel and getting system commands and will submit in less than 2 hrs. Hope to have talk with you soon. :)

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
1.3
poojamol

Currently I working as team leader in bpo sectors for backoffice but not satisfied with salary.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
ksylbd786

Simple transparent image for watermark is very good project. i want to do the work , if i get the job i will do it appropriately.thanks.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
nitinsingh1993

With Your Requirements , I have already ready with the script . Need your confirmation on this. Im New to freelancing hereby i'm ready to work on small project for minimal wages.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
lathaamberkhout

Hello, I've managed to complete the example using panda and socket. Should be able to scale easily to the full 300 rows. The python script is also easy to understand.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
zoromariga

hello,My name is zoro I have finished the example successfully using pandas and socket. Regards Zororo Mariga

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0