I need to transpose the following input dataset into an output dataset like
below
Input
Date
TICKER
Price
11/10/2010
A
0.991642
11/10/2010
B
0.475023
11/10/2010
C
0.218642
11/10/2010
D
0.365135
12/10/2010
A
0.687873
12/10/2010
B
0.47006
12/10/2010
C
0.533542
12/10/2010
D
0.812439
13/10/2010
A
0.210848
13/10/2010
B
0.699799
13/10/2010
C
0.546003
13/10/2010
D
0.152316
Output needed
Date
A
B
C
D
11/10/2010
0.991642
0.475023
0.218642
0.365135
12/10/2010
0.687873
0.47006
0.533542
0.812439
13/10/2010
0.210848
0.699799
0.546003
0.152316
I tried using the aggregate function but not quite getting the method.
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
