Find Jobs
Hire Freelancers

Looking for a coder to clean the Data and append all the data in 1 File from multiple excel files.

₹3000-15000 INR

Completed
Posted almost 2 years ago

₹3000-15000 INR

Paid on delivery
This Project needs multiple tasks . Basically it has two Phases ( Please do not miss " THE BEST PART") Phase -1 Normalize Data ( ALL DATA CONSIST OF DATES, TEXTS AND NUMBERS ONLY). 1)The data is scattered in multiple excel and csv files, 2) Few data needs to be converted from Rows to columns 3) Few data needs to add additional rows and copy them between dates. 4) Append all data one after another Ultimately I need all the data in one file in a tale format. 5) Please note, there can be more then 10 Million rows. Phase - 2 Analyzing data. 6) I need to analyze them further using different mathematical and statistical functions. 7) There can be 1000s of queries, so you need to read twice " THE BEST PART OF THE PROJECT" Few Notes: 1) You can use Excel, Access, Power Query, MySQL, Eggs, Ginger, Lemon or any software or anything in which you are conversant with. 2) Once again I am emphasizing this , I need the data to further analyze them with different queries. 3) Person has to be well experienced for handling large data (Total data size < 2 gb but scattered in more then 25,000 files) Hence not so big data so no need to worry. 4) After reading my 3rd note, this note no 4 is for those experts who think that this is a peanut project for us so lets jump right away on this, they need not to apply for this project as you are very much expert so you will have many projects on hand and when the time you will reach " THE BEST PART OF THE PROJECT" in that phase you will get bored and think the amount is not justified. 5) Those experts who thinks that they are EXPERTS and can do this, but they haven't done it before need not apply too, as in any ways you will NOT be able to deliver my project in time and will Transform my project from days to weeks and sometimes months. Finally " THE BEST PART OF THE PROJECT" I do not know how to operate MS Access neither I have never seen in my life MySQL ( As I don't know how much its Mine), so you need to take effort to teach me how to generate and run queries to analyze data further. I know there are few experts who will guide me that why to take such big effort in converting the downloaded data and go through all the hassle, instead why not to simplify them by redownloading into structured manner the way I want using Python or Snake or Scorpion. They are welcome too. If Interested please offer me the best price and time in which you can complete the task.
Project ID: 34130127

About the project

29 proposals
Remote project
Active 2 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, I'm an experienced data scientist with over 7 years of active development experience building Machine learning and AI systems using multiple tools and technologies including R, Python and PySpark. I hold a Masters degree in Data Science from Trinity College Dublin as well as a Bachelors degree in Computer Science. I have worked extensively on big data and machine learning. Currently, I have been working with one of the largest banking and financial firm here in Dublin, Ireland. I'm looking forward to working with you. Feel free to check out my profile reviews. Cheers!
₹20,000 INR in 15 days
5.0 (72 reviews)
6.2
6.2
29 freelancers are bidding on average ₹17,430 INR for this job
User Avatar
Hi there, I have read all the parts of the project and I can help you with this. Please ping me back to discuss about the deadlines. Looking forward to hearing from you soon. Regards Pooja Bohra
₹15,000 INR in 7 days
4.9 (91 reviews)
6.2
6.2
User Avatar
Hello Sir , Iam excel expert level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need this finished? I understand how annoying it is and can get this fixed for you quickly! Please see the sample I fixed. I look forward to working on this project with you. Regards ILYAS
₹11,456 INR in 3 days
4.9 (150 reviews)
5.8
5.8
User Avatar
Greetings. I checked your Software Designing project requirements. Your work is one of the tasks that can be done very perfectly by us. I am good in Python, Django, Flask, ORM,Jinja 2, Mako , All datamining , Data Analytics , Web Economics, Statistics work. We are Professionals. So we complete your within a time with perfect work with 100% accuracy. So don’t worry about anything.
₹3,000 INR in 2 days
4.7 (33 reviews)
5.6
5.6
User Avatar
Greetings, I can design and deliver a program that would take any number of input files in csv format then combine them into one unified database. As all data would be stored in one unified database it would be possible to then query the database for any combination of data entries in any order required. In addition I would deliver a simple API that would allow for access to this database. Once a query is designed and implemented the program would then generate a output file in the specified format, either csv or other requested. In conclusion, the program to be delivered would take any number of input files in the specified location and join them into one unified database. Once a query is run an output file in the csv format would be stored in the requested location. As a result the only knowledge for the end user to employ this program would be to know how to create a well thought out query and how to run in through the program, information which would be provided.
₹15,000 INR in 7 days
5.0 (1 review)
3.4
3.4
User Avatar
hello sir we from sveltose team of experts which love to work 24hr ready to work for you anytime on ANDROID,FLUTTER,REACT JS,NODEJS,REACTJS,WORDPRESS,PHP,CI,WEB DESIGN so far we done many startup and give our support to them we have 7 experience in this industry and run many client server, crm,web,apps and digital marketing and can work properly for you thanks
₹9,000 INR in 7 days
5.0 (1 review)
2.4
2.4
User Avatar
I can start immediately My name is Manpreet Singh’’’’’’’ I have read your job I am very familiar & specialized in Python Data Processing Excel Microsoft Access MySQL, I am very excited to see your job posting as I am confident that I am a perfect fit for what you are looking for I have checked out all your requirements regarding application development and we can help you. AM highly interested in your project, as I have worked on many similar projects. Apart from this i have make good use of APIs and web services. I have integrated API and web services. If you award me the project I'd be very happy to discuss this further and get started for you as soon as possible. You can see an example of one of those projects in my portfolio here: https://www.freelancer.in/u/mrsingh1994
₹15,000 INR in 7 days
5.0 (1 review)
1.7
1.7
User Avatar
Hello.., My availability: 40+ hours/week. Ready to start work immediately. I read your project post of Python Developer. I am fullstack Python developer having skillsets in Python Django/Flask, Machine Learning, Data Science. I have a strength to offer 24/7 support including weekend and night time and excellent software quality work and provide the best support on your project. Please message me to start discussion. Thanks
₹9,000 INR in 7 days
5.0 (1 review)
1.3
1.3
User Avatar
Greetings sir, I am Irfan currently, working as a Mathematics Instructor at a University and a Data Analyst at a US-based Edtech company. I have eight years of experience in teaching mathematics and one year as a data analyst/ data scientist. Moreover, I am working on my blogging site, mostly focused on data science and analytics. I went through your project. You need help with the data analysis task. I am working as a business analyst/data scientist at a US-based Ad-tech company where I have to work with a large amount of data to analyze and manipulate it. I used to clean, do exploratory data analysis via visualizations and other techniques, develop machine learning models, and investigate KPIs and reports on a daily/weekly basis. So I guess it would not be a big deal for me as I am familiar with the techniques and the abilities you are currently looking for. I am really looking forward to hearing from you. Have a good day. Regards, Irfan
₹15,000 INR in 7 days
5.0 (2 reviews)
1.4
1.4
User Avatar
Hi, I'm Catherine C. Nolasco. I was interested with your job posting and I wanted to send my bid for this project. I am a licensed professional teacher in the Philippines and I can assure you that I will finish such project professionally and with 100 % accuracy. I hope that we can work together and I am looking forward working for you soon.
₹9,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have more than 3 years of experience working with python. I am going to merge files using pandas and also I am familiar with MySql as a database service. Let's start code !!! Waiting for your reply.
₹18,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We are experts in data processing in Excel, just we do by trying with complete potential and enthusiasm. Thank you
₹10,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
With an experience of 6+ years as Content Specialist in a Ed-tech Company, with the passion of learning new technologies, I was able to complete some of the certification courses on SQL and other technical languages. I am a certified Data Analyst from IBM.
₹11,000 INR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Can do this work soon and give the apportunity to work for the data and will do this clearly and efficiently give the work i have very well understanding your work
₹9,000 INR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
So, try to be as specific as possible to make it easier for your client to understand what you do. No,
₹9,000 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I carry 3 years Experience in python, C# and Devops tools. Have a post graduate diploma in data science and AI
₹9,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do the first part of the project. Regarding the Best Part, I can teach you how to do the needed statistical analysis in R or Python (but not if you need it to be sql).
₹18,000 INR in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good day, Ma'am/Sir! I was thrilled when I learned that you need someone that has mastery on spreadsheet or excel. As an effective communicator who pays close attention to accuracy and details when entering data, I have mastered the art of working under strict deadlines. My professional acumen makes me a competitive candidate for the position. My previous jobs have prepared me to enter accurate data into more than different databases while maintaining the complete integrity and confidentiality of the information with which I have been entrusted. My time management system allows me to multi-task as I handle multiple responsibilities at one time. As a fluent English speaker, I'm able to enter and analyze data at a rapid rate. I believe that ambition and drive are the most efficient motivators. I'm a self-starter who's not satisfied until I've maximized my efficiency and production rate to the greatest extent possible. I can say that I have mastered several data entry and spreadsheet programs such as Microsoft Excel. When problems arise, I take a leadership role, analyze the problem and organize the implementation of the relevant solutions. Even so, I remain open to learning new strategies when needed. Thank you very much for considering my application. I stand at the ready to assist your company to the best of my abilities. I await an opportunity to discuss my qualifications with you in further detail. I appreciate your consideration. Sincerely Yours, Jocelyn R. Angeles
₹10,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I m work proper in time . No complaints for my work . Good quality work but 50% payment changed in advance and 50% payment in after work ??
₹9,000 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I have previously worked on tools used for segregating, transforming and dumping data into downstream systems . I have vast experience of MS SQL and also know how to organize the data (even used SSIS so if required will use it ). To clarify on my approach i will analyze the data in sheets , transform it if required, dump into data base and execute queries in order to fetch the results .I am also well about many features of Excel and CSV files so i will be able to complete this task with precision .
₹12,000 INR in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Dar es Salaam, India
5.0
4
Payment method verified
Member since Nov 24, 2017

Client Verification

Other jobs from this client

Web scrapping
₹1500-12500 INR
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.