Looking for a coder to clean the Data and append all the data in 1 File from multiple excel files.
Budget: ₹3,000 – ₹15,000 INR
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.
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.