Completed

Need to transfer Excel data to faster database

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).

Skills: Python, Excel, Data Processing, Data Mining, R Programming Language

See more: excel data access database, macro move data cell database excel, input excel data access database, upload excel data mysql database, send excel data access database, transfer excel data power point, sqlyog append excel data mysql database, import excel data sql database, import excel data sql database within sql, import excel data mssql database, insert excel data mysql database table file jsp hibernate, transfer excel data joomla, excel data mysql database, need transfer data entry excel file, excel data online database, convert excel data access database, jsp program insert excel data mysql database, automatically search for excel data display and print using vba, how to import excel data into database using java

About the Employer:
( 16 reviews ) Manchester, Canada

Project ID: #29340852

Awarded to:

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 More

$250 USD in 3 days
(4 Reviews)
3.3

32 freelancers are bidding on average $170 for this job

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 More

$220 USD in 4 days
(472 Reviews)
8.4
(191 Reviews)
6.7
(196 Reviews)
6.9
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 More

$120 USD in 2 days
(41 Reviews)
6.2
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 More

$100 USD in 2 days
(74 Reviews)
6.1
Sercho56

Hi, I am an Australian software developer with 20 years experience in developing customised data handling/processing algorithms. I specialise in handling large datasets and will easily be able to improve the speed of y More

$100 USD in 2 days
(41 Reviews)
6.2
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 More

$200 USD in 7 days
(50 Reviews)
5.6
steven6

Hi, I can do this in less than a day. Would you mind sending a truncated version of your xls? Please send me a message if you're interested. Thanks.

$250 USD in 1 day
(4 Reviews)
5.8
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 More

$150 USD in 2 days
(23 Reviews)
5.7
writingapp

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

$90 USD in 2 days
(111 Reviews)
5.9
(78 Reviews)
5.5
(64 Reviews)
5.7
RushService

Feel fee to contact me for transfer Excel data to faster database .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] pay More

$150 USD in 7 days
(38 Reviews)
5.4
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 in 2 days
(43 Reviews)
4.7
(17 Reviews)
4.8
(11 Reviews)
4.6
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 in 2 days
(6 Reviews)
4.2
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 in 7 days
(3 Reviews)
4.4
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 More

$160 USD in 7 days
(12 Reviews)
4.3
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 in 7 days
(11 Reviews)
4.1