Need to transfer Excel data to faster database

Slutfört Publicerat 3 år sedan Betalades vid leverans
Slutfört Betalades vid leverans

Hi! I have a large Excel dataset (>50000 rows, >300 columns) that I parse through to find rows that meet specific conditions (eg. find all rows where column N >5 and column Z <1.2). Based on the results, I then set up models to apply to real-time data in order to make predictive decisions (investments). I'm familiar with VBA and it's easy to set up a parser to search through the data to create the models. But it's very time consuming, especially as the dataset has grown. I would like to get some help either making this faster or transferring this dataset to a more efficient database. This project is for providing an update to my Excel file that shows improvements in efficiency or an alternative database with example parser code (eg. R, Python, etc).

Python Excel Databehandling Informationsutvinning (Data mining) R-programmeringsspråk

Projekt-id: #29340852

About the project

28 offerter Distansprojekt Aktivt 3 år sedan

Tilldelades:

NonikNone

Hello. My name is Ugur. If you are familiar with VBA, I can develop a software using VB.NET connected to a MS SQL Server as database. MS SQL is the fastest, milions of records can be filtered in a second. (When you cre Mer

$250 USD inom 3 dagar
(5 omdömen)
3.9

28 frilansare har lagt bud på i genomsnitt $164 för det här jobbet

schoudhary1553

Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in sam Mer

$220 USD inom 4 dagar
(659 omdömen)
8.6
saif12me

Hi I would love to help you to automate the process with VBA only. A large dataset requires efficient code to run faster. I'm well versed with Excel VBA/Macro, complex formulas, documents automation, data analysis, dat Mer

$120 USD inom 2 dagar
(91 omdömen)
6.8
writingapp

Hi. I have writen many automation database apps including Excel. Ready to write your project. Will complete within 2 days

$90 USD inom 2 dagar
(286 omdömen)
7.0
finecodervw

Hi, As I understand you are currently facing some performance issues due to which you would like to move away from VBA to Python/R. It would help if you can share the Excel sheet you have. At times the VBA code if no Mer

$100 USD inom 2 dagar
(136 omdömen)
6.7
borutflis

Hello, I am expert in pandas, which is a Python file that can manage excel files and convert them to a database. As your file is quite big I assume efficiency is one of the main issues. I can test several options to Mer

$160 USD inom 7 dagar
(49 omdömen)
6.3
rohitangira

hello , i just read task discription and it really jumped out on me , this is an easy task for me and i can deliver it perfectly . i am an python developer having 5 years of experience , although I am a new on upwork Mer

$200 USD inom 7 dagar
(61 omdömen)
5.7
Igorter

Hello, As a Python programmer, I am interesting to your project. I am good at Excel Data parsing and engineering in python and used Pandas and Numpy and developed a lot of projects like this. I'd like to discuss the de Mer

$150 USD inom 2 dagar
(23 omdömen)
5.7
ibahimakerkouch

Hi, I have worked on advanced data projects specifically data preparation similar to your project. my experience on working is based on developing a job which automates the processing to do that, also automation skip a Mer

$30 USD inom 1 dag
(80 omdömen)
5.5
bobrovpavelwork

Hello, Jeremy. How are you today? Here is a Python expert so that I can help you perfectly. I can start work right now. Thanks Pavel

$200 USD inom 2 dagar
(11 omdömen)
4.6
nurnga1218

Hi, I'm ready your job, and I have many experienced in project similar like yours. So, Why wasting time, I'm waiting you on chat. Thanks

$30 USD inom 2 dagar
(43 omdömen)
4.6
tutulsoft

Better to shift data to SQL server or MYSQL database it will perform this execution within milliseconds, i can convert all your excel data to that new database system and parsing the condition

$250 USD inom 7 dagar
(6 omdömen)
4.4
Sayed95

Hello, I can make a Python script which will process data way faster. Or I can put all the data into a MySQL database. Either way, it will be faster. Inbox me so I can help. Thanks

$140 USD inom 7 dagar
(12 omdömen)
4.2
drsixpence

After optimizing a MySQL database for someone here on Freelancer which had a table with over 5 million records adding pagination to aid performance in the process, I can tell you with 100% confidence I can develop you Mer

$220 USD inom 7 dagar
(6 omdömen)
3.4
chnsci

I can do this project right now with 100% accuracy. I understood your project description. I am an expert in Python, Excel, Data Mining, R Programming Language, and interested in your project. I work efficiently an Mer

$165 USD inom 4 dagar
(18 omdömen)
3.6
nolk

Hi there, sounds like very interesting project to me. From what I read, it should be quite easy to speed things up with simple migration to MySQL/Postgres. However, it would be interesting to see how you feed new data Mer

$230 USD inom 7 dagar
(4 omdömen)
3.1
DarisettySuneel

Hello, I have 7+ years of experience in handling python projects includes big data and data science and excel operations. I can provide you the solutions within hours or max 1 day. I can convert all your macros or loo Mer

$300 USD inom 1 dag
(1 omdöme)
3.1
sumyalmm

Dear Sir, I just read your project and very much interested to work with you. I am ready to do some sample work and also ready start work now. Please message me so that we can discuss more details. Thanks

$200 USD inom 2 dagar
(2 omdömen)
2.2
emamhossain72

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement & yes, we can do it, because we already work on Mer

$200 USD inom 3 dagar
(0 omdömen)
0.0
AshotVardanyan97

Hi! As I understand from your job description It is not a simple job. If you hire me I will give a 100% project-delivery and I am sure that you will rate me 5 stars at the end of this project. If you have 10-20 free m Mer

$140 USD inom 7 dagar
(0 omdömen)
0.0