Suoritettu

Calculate Excel_Sheet in Python

Hello Master programmer,

I have some calculations in an Excel sheet that I need to translate into Python (numpy and/or Pandas)

It is a very large xlsb file and I have reached its maximum capacity. My RAM is 16GB therefore I think Python can handle it. Once calculations are done I want to store the cell results probably in a python Pandas file or a database file, I am not sure what is the best to handle the memory size problem.

Taidot: Python, Tietojärjestelmäarkkitehtuuri, Excel, Tietojenkäsittely

Näytä lisää: excel template website login password log sheet, excel macro paste fill empty previous sheet, master time sheet, judges master score sheet, master spread sheet, excel auto populate rows from another sheet, excel vba create chart in new sheet, excel vba copy range to another sheet, excel vba copy rows from one sheet to another based on criteria, excel vba copy data from one sheet to another based on cell value, excel combine multiple workbooks to one sheet, excel master formula sheet, excel auto populate cells from another sheet, python 2.7 cheat sheet, python 3.6 cheat sheet pdf, excel link to picture in another sheet, excel copy filtered data to another sheet automatically, excel advanced filter copy to another sheet, excel copy named range to another sheet, python data cleaning cheat sheet

Tietoa työnantajasta:
( 1 arvostelu ) Paris, France

Projektin tunnus: #29898437

Myönnetty käyttäjälle:

emijalkovic

Hi.I have a rich experience with python I can show you demo project I 'm sure i can get all data you need using numpy and pandas If you give a chance, I will do my best for [login to view URL] will get good result. Dear regards. Lisää

€50 EUR 1 päivässä
(10 Arvostelua)
4.3

23 freelanceria on tarjonnut keskimäärin €41 tähän työhön

(483 arvostelua)
8.4
fomersari

Hi. I had the same problem all the time in my previous work and I automated all excel related tasks with Python. 16gb ram is more than enough. Excel is extremely slow when the dataset is big. It's a nightmare. Python c Lisää

€150 EUR 7 päivässä
(13 arvostelua)
4.5
sefakemal

Hello, I am software developer more than 10 years. I have developed desktop apps with Vb.Net and MS SQL database in my first job. I have co worked with senior software developers of Microsoft. I was a member of team wh Lisää

€50 EUR 3 päivässä
(8 arvostelua)
4.0
(30 arvostelua)
4.1
(6 arvostelua)
2.2
dohungnd94

Dear Bro. I am sure that python can handle your file easily. I can help you create python with your calculations and final results will store in mysql database so you can easily get the result real quick. I am a d Lisää

€50 EUR 5 päivässä
(2 arvostelua)
2.3
chiragkadyan

Hello sir, I recently have been working on the big data migration and the risk assurance for the file with 4500000 records in the file and of 9 gb . I feel that i can do all the Excel calculation for your big data in Lisää

€34 EUR 1 päivässä
(4 arvostelua)
2.2
pelex202

hello I have reviewed you project, and I will be happy to help, I am an experienced python programmer since 2014, I can complete you job within 1 with python automation, will be happy to here from you

€34 EUR 1 päivässä
(0 arvostelua)
0.0
npprmppb

Hi I am well known to following Python Data Analysis topics--- Big Data Analysis Bayesian Optimization Principle Component Analysis Survival & Reliability Analysis Classification of High Dimensional Data Partial Least Lisää

€25 EUR 3 päivässä
(0 arvostelua)
0.0
shrutish02044

When it comes to hiring decisions, a company will choose the person that they believe will help them to solve a problem or a pain point. By clearly discussing how you will address the hiring company's most significant Lisää

€24 EUR 10 päivässä
(0 arvostelua)
0.0
derekcbr

More than 5 years of pandas and numpy experiences. Developed 3D modelling website by python and Javascript. [login to view URL] Developed some quantitative modelling jobs for option trading by pandas and numpy

€20 EUR 3 päivässä
(0 arvostelua)
0.0
jvandanak

I am very good at python and django framework. I'll suggest you that pandas fixed your memory problem.

€20 EUR 3 päivässä
(0 arvostelua)
0.0
SemihRecep

I can do it for you. I did a lot of projects including excel files and databases. a couple week ago I did a project for a company that they want their datas in excel files and and then they wanted the datas transfer to Lisää

€30 EUR 5 päivässä
(0 arvostelua)
0.0
sumitkesri

Hi, I am a Python Developer and have experience of working on pandas Package. I can complete the work. Your work can be done using pandas package of calculation of data. Let's connect and I can handle it

€30 EUR 7 päivässä
(0 arvostelua)
0.0
sayalijangam17

I am Python developer who also work on data science. Since your file is very large we will use pandas to create dataframes and will use numpy to perform complex calculations. We will save result in excel file only for Lisää

€30 EUR 3 päivässä
(0 arvostelua)
0.0
AdnanN110

I am experienced in processing, maintaining and reporting on large volume of data. Looking at your description I think you need some form of database which will perform calculations and store the results. I can help y Lisää

€40 EUR 7 päivässä
(0 arvostelua)
0.0
BAHAEELHMIMDI

i can do this task for free just to win long term relationship. let start now .hope there will be a lot of tasks for me in future

€8 EUR 1 päivässä
(0 arvostelua)
0.0
mahfoud86

Hey. I have read the description of your offer and I am very interested in. Your pro blem is so normal because of the amount of data you are trying to process using Ms excel. Python will be the solution to process thos Lisää

€29 EUR 2 päivässä
(0 arvostelua)
0.0
abomahmud7211

I can help you in your project. I can do some calculations by python and save it as csv sheet. python is good for treating with large data.

€29 EUR 2 päivässä
(0 arvostelua)
0.0
AmalMagdy2393

Hi, I read your project requirements and understood the instruction very well. I worked on similar projects such as that exist in my portfolio. My experience in this field is enhanced by completing the data analysis pr Lisää

€100 EUR 5 päivässä
(0 arvostelua)
0.0