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のプロフィール写真
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のプロフィール写真
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のプロフィール写真
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のプロフィール写真
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のプロフィール写真
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のプロフィール写真
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のプロフィール写真
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のプロフィール写真
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のプロフィール写真
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
このようなプロジェクトを投稿する