Find Jobs
Hire Freelancers

large database combine and organize.

$30-250 AUD

In Progress
Posted over 5 years ago

$30-250 AUD

Paid on delivery
I have USA 2 databases. 1 with 42m records (206 csv files) and one with 21m (21 csv files) records. I would like them to be combined then split into US states (csv format) I would also like unnecessary columns removed.. There will also be rows to remove which contain keywords from a supplied list (16 keywords) I have attached samples.... there is 206 files of one type with 200k records each and 21 of the other type with 1mil each.. it dont need all of the fields .. I just need first name , last name , company, city, state, email, business desc.(the other data can be discarded)..... it needs to be all combined then split into separate csv files for each state. Please provide price and delivery time. I require this in 3 days Generic responses will be ignored. I will only look at bids which confirm that they have read the brief and looked at the files
Project ID: 17712204

About the project

26 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi There, I have understood your requirements and seen the attached files. I will combine (206 + 21 ) CSV files into one file and then I will split them by USA states and remove the unnecessary columns as per your instruction. I just have a query you said you need to split them by states so that means they again need to be separated into many CSV's? Waiting for your response! Thanks & Regards, Ujjwal
$100 AUD in 1 day
4.9 (90 reviews)
7.4
7.4
26 freelancers are bidding on average $156 AUD for this job
User Avatar
the problem is excel does not support more then 1m in one sheet, and you said u want us to combine all files, whcih is not possible, the cleaning process and filteration needs to be done manually. thanks
$250 AUD in 1 day
5.0 (1481 reviews)
9.2
9.2
User Avatar
Hello, Hope you are doing well. I can help with your project large database combine and organize.. I can assure you the quality job. I have good experience in Data Entry, Data Processing, Excel. We have worked on several similar projects before! Please have a look at my portfolio below: https://www.freelancer.com/u/schoudhary1553 We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$200 AUD in 3 days
4.9 (391 reviews)
8.1
8.1
User Avatar
Greetings! Dear sir,I am highly proficient in online contact list generation, web researching, data entry, and email marketing. You'll notice in my reviews that I am dependable, punctual, and meet client deadlines. I have a keen eye and pay close attention to details. We can arrange the data as first name , last name , company, city, state, email, business desc as per your needs. Additionally, I am familiar with Microsoft Word, Google sheets, Google documents and Microsoft Excel. I can work 5-6 days per week, 8-12 hours per day. so once you reply then we can share our data for samples to quality check. Thanks, Andy
$55 AUD in 1 day
4.7 (432 reviews)
7.9
7.9
User Avatar
Hi! I'm interested on working on your project. I've read your instructions and checked both of your sample files. I have experience working on data entry and excel and I'm available to start immediatly. I can meet your 3 day deadline without trouble. I hope I get the opportunity to work with you. Regards. Shyrley.
$180 AUD in 3 days
5.0 (126 reviews)
7.1
7.1
User Avatar
Hi We've to import csv files in MySQL for combining files then we can remove unnecessary data and split them in states In excel it's not possible because excel never support more than 1.048 million rows Any how we've already did this and combine and split 13m records As far as removing rows having keywords, we'll also remove them I am looking your response Thanks
$150 AUD in 3 days
4.9 (362 reviews)
7.4
7.4
User Avatar
Hi there, I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and combine all those files and do all manipulation needed . Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$222 AUD in 2 days
4.9 (164 reviews)
7.6
7.6
User Avatar
I’m ready to complete this task large database combine and organize for you ASAP. Please contact me for farther discussion I hope I’ll hear a good from you. I can provide in 3 days
$98 AUD in 3 days
4.9 (92 reviews)
6.1
6.1
User Avatar
Sir, I am very able to combine, organise and sort accordingly as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$144 AUD in 3 days
4.6 (102 reviews)
6.2
6.2
User Avatar
Hi sir i have understood your project description i will do this task easily and will complete it asap please message me so that we can discuss more i am waiting for response Thanks
$250 AUD in 3 days
5.0 (38 reviews)
5.4
5.4
User Avatar
Dear Sir/Madam, I am uzzal hossain from Dhaka, Bangladesh. I have a team and I can do this urgently if you needed. I want to do your job perfectly. Thanks. Regards Uzzal Hossain
$200 AUD in 3 days
4.7 (29 reviews)
5.3
5.3
User Avatar
I can do it. I will create a loop to open the files sequentially, one after another, removing unnecessary columns and rows and then create one (or as many as needed) file per state. Aeronautical engineer and MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
$240 AUD in 2 days
5.0 (41 reviews)
5.2
5.2
User Avatar
My team member Six Person. We are always Active. If you give me a chance and give direction for the job, I will do this. Regards Subroto Kumar Biswas (Shuvo) Blood Freelancer Team CFO & Co-Founder Professional Lead Generation Expert
$35 AUD in 3 days
5.0 (6 reviews)
3.5
3.5
User Avatar
read description i can do it for u
$66 AUD in 3 days
4.3 (20 reviews)
4.1
4.1
User Avatar
Hi I have Read your job description .please contact me for more detail so tht we could discuss more about your project to start work. Thsnk you
$111 AUD in 3 days
5.0 (23 reviews)
3.3
3.3
User Avatar
Hello! I have previous experience handling, parsing and filtering large databases because I work with them regularly. For doing that i use mainly awk, sed and grep in bash scripts. If you message me I can prepare to you some example from your sample files before you decide to hire someone! Bye!
$70 AUD in 0 day
5.0 (2 reviews)
3.4
3.4
User Avatar
Hi, I'm a software developer with over 5 years of experience developing and deploying various data-centric applications using different tools and technologies. I have a decent experience and expertise carrying out similar tasks before where the huge volume of data was involved. I'm suitable for this task and would ensure the on-time delivery with perfection. Kindly take a look at my profile and let's discuss it further. Best Regards, Tofii
$155 AUD in 3 days
5.0 (5 reviews)
3.3
3.3
User Avatar
Hello, I just checked the files and I can help you. I have a lot of experience working as a Virtual Assistant and completing data entry tasks.
$175 AUD in 3 days
4.9 (11 reviews)
3.3
3.3
User Avatar
Immediate availability to work (1 - 12 hours per day). Efficiency, quality of work. Agility and precision in fingering and transcription (100%) Suitable for work under pressure, good performance and commitment to deadlines. Good level of spelling and grammar Microsoft office management. Web queries and data entry (Excel, Word) Download and upload files. Conversion of files PDF to Word PDF to Excel Data collection Processing of data Translate English - Spanish, Spanish - English
$100 AUD in 3 days
5.0 (4 reviews)
2.8
2.8
User Avatar
I can do: Formulas, Buttons Drop-down lists, form Export &import from/to CSV,PRN,TXT,XLS,XML,XLSX,XLSM PDF to Excel vise-verse Stock Management. Removing duplicates. and Much More I'm Good at Data Entry, Data Processing, Excel Aerialdarren, Please Send Me a message so that we can discuss more about this project
$200 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, Hope you must be doing wonderful. Quick Question regarding your project: Let start Below are some of the details of our work Expertise: • Ghostwriting, • Data Entry, Complex Projects • Academic Writing, • Creative Writing, • Branding ( Stationary , T-shirts, Mugs, Boxes ) • Power Point Presentation • Articles and Blog Writing, • Graphics Design, • Website Design and Development, • App Development • Logo design • Sales and Marketing, • Lead Generation • Social media Marketing/Advertising • Flyer or Boucher Design We are a team of experts having more than 10 years of experience and we have gone through your given details and we’re able to complete this task without any problem. We would also like to discuss more about your project so please do contact us for better understanding. Feel free to hire us and well get you the best services you have ever received. Your Satisfaction is our Utmost priority. Thanks. Virtue Consulting
$100 AUD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
beaconsfield, Australia
4.8
15
Payment method verified
Member since Jan 28, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.