Need to transfer Excel data to faster database
$30-250 USD
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).
Projekt-id: #29340852
About the project
28 frilansare har lagt bud på i genomsnitt $164 för det här jobbet
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
Hi. I have writen many automation database apps including Excel. Ready to write your project. Will complete within 2 days
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
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
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
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
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
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
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
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
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
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
"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
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