R code required :How to bring column data in Rows uniquely

Asked Apr 29 '17 at 15:20

Active Apr 29 '17 at 15:25

Viewed 26 times

I have the following data:

SAMPLE DATA

id       client number year-month revenue
2        748 2014-12  92.25
3        748 2015-01  84.00
4        748 2015-06 751.89
5        749 2015-07 913.35
6        749 2015-08 334.96

I want the output as

EXPECTED OUTPUT

client number  2014-12 2014-01 2015-06 2015-07 2015-08
748              92.25    84.00  751.89  0      0
749                0       0      0      913.35  334.96

I want to do this in R

edited Apr 29 '17 at 15:25

Jaap

81,064
34
182
193

asked Apr 29 '17 at 15:20

Can you please reformat your expected input and output, it's tough to interpret it at the moment. – Satyadev Apr 29 '17 at 15:23
Click on the sample data and expected output – Apr 29 '17 at 15:56

R code required :How to bring column data in Rows uniquely

0 Answers0