Analyze some Data : restructure data set
$10-30 AUD
Paid on delivery
I have a data file that has a 'master' variable that captures a unique ID for people. That row of data then describes the quantity of target behaviors.
The problem is that each person in the 'master' variable can appear any number of times. I need the data re-structured so that each person in the 'master' only occurs once. AND all the remaining variables are then AVERAGE for that person for that variable.
To illustrate...
ORIGINAL DATE will look like this (where there are 3 people in 6 rows):
MASTER VAR1 VAR2
1234 1 3
1234 3 2
5423 1 3
3564 4 2
3564 2 4
3564 3 3
The intended OUTPUT of this project will look like this (3 people in three rows):
MASTER VAR1 VAR2
1234 2 2.5
5423 1 3
3564 3 3
The data will start with 4047 rows, and end with 2161 rows. There are 35 variables on top of the master variable.
Project ID: #8181381
About the project
Awarded to:
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. My bid includes also the macro doing the job for the case you n More
9 freelancers are bidding on average $24 for this job
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
Dear Sir/Madam, I have 12 years of experience in data processing using Excel. The task is not difficult and I can complete it within 1 hour. I'd be glad to help you with this project. Thank you!
Hi SIr, I am expert in this. I have done 32 projects regarding this. Ping me i can submit in next few hours. .....
Good day and thank you for this opportunity. I work for a professional consulting firm and data analysis is part of life for me and Excel is a great tool for that! Great that you have shared such detailed description a More
I can do this immediately and quickly. I already know exactly what to do and am just waiting on you to award me the bid. I am exceptional with excel.