Completed

I need several modifications done to an existing Python script which works with excel. -- 2

I have four files ([login to view URL], [login to view URL], [login to view URL], [login to view URL]). The Python script ([login to view URL]) does the following:

Step 1: The Python script copies cells A4:A29 from data.xlsx.

Step 2: The Python script pastes them into A1:A26 of excel2.xlsx. [[login to view URL] has a few formulas already there, which instantly parse the data within the sheet, resulting in new values that appear in cells X1:AK2].

Step 3: The Python script then takes the data from cells X1:AK2 (from [login to view URL]) and create a .csv file with it (named [login to view URL]). The (X1:AK2) range is pasted into the range (A1:N2) in the [login to view URL] file.

The [login to view URL] works well but it needs debugging. Here is the problem which shouldn't be occurring:

- For sheet [login to view URL], cells Y1:AK1 contains a list of terms. However, the last term (for cell AK1) is missing, as is the term for AK2. The current script line that deals with this is (I think) : [login to view URL](0, y_index+indx,l[indx] ). This is causing AK1 and AK2 to be blank, which shouldn't be the case.

Since this is a small project, preference will be given to bids under $15.

Skills: Python, Excel

See more: how to read data from excel file in python, openpyxl formula, openpyxl github, best python excel library, python write to existing excel file, python loop through excel sheets, openpyxl conditional formatting, how to automate excel reports using python, need help write python script operate telit module, python script shapefile excel, need modifications open source script, python script convert excel json, python script copy paste text files, python script update excel, i have an existing php/mysql script that i need customized with additional functions, i have an existing phpmysql script that i need customized with additional functions, i need a php/html script mp3, i need a sash designer script like pride pageant, i will provide names address phone email etc etc on a pdf file i need the information put in an excel spread sheet under company, i need someone to set up some excel sheets for me johanesburg

About the Employer:
( 11 reviews ) South Ozone Park, United States

Project ID: #24577233

Awarded to:

zoranzdravkovic2

-------- Senior Python/ Excel Expert! -------- Hi,dear Your project is very attracting my mind because I'm very mastered in these branches and also, have rich experiences and high skills on this project. I have been c More

$10 USD in 2 days
(4 Reviews)
2.4

11 freelancers are bidding on average $31 for this job

hbxfnzwpf

I am very proficient in c and c++. I have 18 years c++ developing experience now, and have worked for more than 7 years. My work is online game developing, and mainly focus on server side, using c++ under Linux environ More

$135 USD in 3 days
(19 Reviews)
5.3
IshaqKN

Hi there, Yeah sure. I may solve it. Just reach out to me. But I'm wondering why your job title says "I need several modifications...". Best regards, Ishaq

$15 USD in 1 day
(24 Reviews)
4.5
science64

Hey, I can optimize your python script Avinash. As you know I am good at the data manipulation with python. Thanks Best

$20 USD in 7 days
(12 Reviews)
3.6
arassolenko

Hello Dear, I am senior Sorftware Developer with full experience of 5 years. I have done many web scraping projects using Excel, Data Mining and Python. If you want, I can provide examples. I will wait for your reply. More

$15 USD in 1 day
(3 Reviews)
2.5
vamshigoud2031

As a student i know the work to be done in the given time without any fault in the work. i have a better good experience in data entry

$20 USD in 7 days
(0 Reviews)
0.0
DeveloperAlam

Hi there! I’m a python expert and Microsoft certified "Microsoft Office Specialist". I’ve completed a lot of python courses on Coursera. I'm new to this platform so support me by assigning this project. You can visit m More

$15 USD in 1 day
(0 Reviews)
0.0
geekin27

hey, shoot me a message when you see this. I'm an experienced Python Developer, and have dealt with similar projects in the past. Can get this done quickly. looking forward to your reply

$15 USD in 1 day
(1 Review)
0.0
amanverma78660

I have a good experience, your work will be done very quickly and well Relevant Skills and Experience I am best work on data entry .I will do you a great job, whose quality will make you happy

$25 USD in 2 days
(0 Reviews)
0.0
expertsol3

Hi Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements. We h More

$55 USD in 1 day
(0 Reviews)
0.0
odinmx1

I have worked on a similar Python program and I feel like I can take over this project. And I am familiar with the pandas library.

$14 USD in 7 days
(0 Reviews)
0.0