Analyze some Data : restructure data set

완료 등록 시간: Jul 31, 2015 착불

$10-30 AUD

착불

완료 착불

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.

데이터 처리 엑셀

프로젝트 ID: #8181381

프로젝트 소개

9 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: Jul 31, 2015

돈을 벌기 원하시나요?

Freelancer 서비스를 이용한 입찰 시의 장점

예산 한도 및 기간의 설정

작업 결과에 대한 급여 수급

제안서의 개요 작성

회원 가입과 입찰 참여는 무료

수상자:

nagybatonyi

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 기타

$25 AUD (1일 이내)

(55건의 리뷰)

5.6

이 일자리에 대한 프리랜서 9 명의 평균 입찰가: $24

pakee

Consider its DONE with 100% ACCURACY within 1 DAY .. i Can restructure your data set very FAST and Accurately.. I understand exactly what output you need.. Lets talk to me and i can send you sample work .. Ready to st 기타

$40 AUD (0일 이내)

(65 리뷰)

5.8

khushh07

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

$25 AUD (0일 이내)

(68 리뷰)

5.8

watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

$19 AUD (0일 이내)

(42 리뷰)

4.6

dviruki

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!

$15 AUD (0일 이내)

(38 리뷰)

4.8

devi222

Hi SIr, I am expert in this. I have done 32 projects regarding this. Ping me i can submit in next few hours. .....

$22 AUD (0일 이내)

(25 리뷰)

4.1

rongreat

Hi Sir, can you tell me more the details of this project? I'm really good with excel, excel Macro and math. I have done similar projects before this. Your Result is guaranteed because I provide free after sales 기타

$30 AUD (1일 이내)

(4 리뷰)

2.6

armindiemer

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 기타

$19 AUD (1일 이내)

(1 리뷰)

0.4

jimconingsby

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.

$20 AUD (1일 이내)

(0 리뷰)

0.0

이와 유사한 프로젝트 등록