Find Jobs
Hire Freelancers

Python 3 to update Excel values

$10-30 USD

Closed
Posted about 5 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 19149038

About the project

13 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
13 freelancers are bidding on average $24 USD for this job
User Avatar
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 functionality. Only python standard library and third party lib for reading/writing Excel files Please send me a message so we can talk about this in detail. Thank you and regards!
$50 USD in 1 day
4.8 (4 reviews)
5.5
5.5
User Avatar
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 wait your response. Best Regards. Thanks.
$50 USD in 1 day
5.0 (22 reviews)
4.9
4.9
User Avatar
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.
$15 USD in 1 day
5.0 (21 reviews)
3.9
3.9
User Avatar
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.
$14 USD in 1 day
5.0 (19 reviews)
3.9
3.9
User Avatar
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 .
$25 USD in 1 day
4.7 (15 reviews)
3.5
3.5
User Avatar
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.
$20 USD in 3 days
5.0 (3 reviews)
2.0
2.0
User Avatar
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. Contact me because I have a lot of questions to ask. I can complete this job within 1 hour in sha Allah.
$10 USD in 1 day
5.0 (1 review)
1.5
1.5
User Avatar
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. :)
$15 USD in 1 day
5.0 (2 reviews)
1.3
1.3
User Avatar
Currently I working as team leader in bpo sectors for backoffice but not satisfied with salary.
$28 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hello,My name is zoro I have finished the example successfully using pandas and socket. Regards Zororo Mariga
$28 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Lyndhurst, United States
5.0
213
Payment method verified
Member since Sep 14, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.