Write a script (probably Python using pandas) to modify an Excel or Open Document file

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

I have a spreadsheet file with one column that contains a checksum column. I want to merge columns with the same checksum. If there are two columns with the same checksum and different names then after merge one of the names will go into a new column called "Alternate name".

The second function is to take one column which is currently specified in bytes e.g. 16384 and convert to Kbytes e.g. 16. I want to make sure it does not happen twice. So if its less than 1024 then don't divide by 1024. I imagine an experienced python pandas programmer could do this within an hour.

Python

Project ID: #26192993

About the project

32 proposals Remote project Active 3 years ago

Awarded to:

Fazeennazar

★★★ Python Pandas , Excel Spreadsheet ★★★ Thank you for your attention. I have checked your project description in detail. Python Programming is my very interesting subject to help customers. I like to work with the b More

$30 USD in 1 day
(98 Reviews)
6.0

32 freelancers are bidding on average $31 for this job

Igorter

Greetings. I will complete it perfectly. I have rich experiences with python pandas excel data processing. Feel free to contact me anytime.

$40 USD in 1 day
(21 Reviews)
5.7
ThinkAndCo

Hi, We are a team of professional software developers. We have expertise in Python and Pandas. We can readily work on your requirements. We have successfully delivered multiple Python/Pandas projects which included a More

$50 USD in 1 day
(59 Reviews)
5.6
mahmoudkhayrall8

hi sir, I have read the whole description and I'm ready to finish the job today I am an experienced software developer with wide experience on python and pandas I'm ready to merge columns with the same checksum (addin More

$25 USD in 1 day
(4 Reviews)
4.8
tanujajain01

Hello, I have developed a few applications using python that uses excel sheet. I can help you with your requirements. Please ping me Thank You

$30 USD in 7 days
(11 Reviews)
4.6
mayureshmaradkar

I can give the results to you within half hour..I am good in pandas and numpy and have done several projects of such type..I certainly can do this work with least bid price

$20 USD in 1 day
(12 Reviews)
4.0
patshubham00

Hi, hopefully this proposal finds you in good health. I have a great experience working with pandas and Dataframes. I've also used xlsxwriter which integrates Python and Excel Also, I have a good hand over Computer V More

$30 USD in 1 day
(5 Reviews)
2.9
starsudtaryan

Hey, how you doing? I have gone through your work. I have prior experience making scripts using numpy and pandas. I an data science enthusiast so i have a lot of experience in feature engineering with these libraries. More

$15 USD in 1 day
(7 Reviews)
2.6
faizan2700

Your project description pretty simple. If it is just as you said I can do this in about half an hour after you give me the file. Select my proposal.

$40 USD in 1 day
(3 Reviews)
1.9
rrgindore

dear sir I am python expert work on many packages like numpy, scipy, pandas and web frameworks like flask a) Data Scientist b) Development of machine Learning Algorithms c) Sentimental Analytics of social media d) web More

$50 USD in 2 days
(1 Review)
1.3
bindeveloper

Thank you for this job posting. I am a senior full-stack web developer and I have much experience in web development using various kinds of frameworks and languages, such as Python/Django, React.js, Node.js, Magento, F More

$30 USD in 1 day
(0 Reviews)
0.0
BatmanInMoon

Python pandas expert, Excel expert, VBA, macros, advanced Excel and formulae Relevant Skills and Experience Python pandas expert, Excel expert, VBA, macros, advanced Excel and formulae

$45 USD in 2 days
(0 Reviews)
0.0
ammarqureshi5999

Dear Sir, I have MPhil in statistics (PhD Continue) and have vast experience in SPSS, R programming, and python. I can better able to manage your task and assure you to deliver quality work. Please inbox me for more More

$30 USD in 3 days
(0 Reviews)
0.0
carlacomasccg

Buenos días, soy Carla y trabajo para CaixaBank BI tocando python a diario desde hace 5 años. Puedo ayudar con esto y con otras cosas del estilo. Encantada Relevant Skills and Experience Paython

$36 USD in 5 days
(0 Reviews)
0.0
devikarani26

Hello Sir , I have written similar program to merge two sheets in excel using pandas . Looking forward to working on this Thank you Devika

$35 USD in 2 days
(0 Reviews)
0.0
gopinathjgec

I can do this for you. I have more than 9 years of experience working with industry. You may contact me.

$20 USD in 1 day
(0 Reviews)
0.0
rahmat998

Hello i can complete the task you, please give me the detail description of your task and i will complete the task as soon as possible with low budget , now i am robotic programmer with python language in my institut More

$30 USD in 1 day
(0 Reviews)
0.0
rardan

I can make it using Python - I've more than 10 years of experience, including data transformation. Some clarification will be needed: if columns should be merged, second name will go into (perhaps) a new row, not colum More

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

Hi, I can do this work. Since I'm a new freelancer, I'm offering lower rates in the beginning. I hope you consider me. Thanks

$10 USD in 1 day
(0 Reviews)
0.0
MariosKeri

Hi, I have analysed your description and I have come out with a python script solution that I can deliver within an hour. I am an python expert in data fields with 9+ years experience. My daily job includes but not lim More

$26 USD in 7 days
(0 Reviews)
0.0
tanyabysaha

Hello, I would be glad to help you with that as I really love to play with data and pandas. Please send an example of input and output files

$50 USD in 2 days
(0 Reviews)
0.0