Hi!
I have just started learning R and today only I have joined this group. This is
my first mail and I wish to thank all of you for allowing me to be part of this
group.
I have following problem. I have an input.csv file such that
corp_id date investment_id rate
corp1 17-Feb 1 65
corp1 16-Feb 1 70
corp1 15-Feb 1 69
corp1 14-Feb 1 89
corp1 13-Feb 1 88
corp2 17-Feb 1 95
corp2 16-Feb 1 135
corp2 15-Feb 1 140
corp3 17-Feb 2 86
corp3 16-Feb 2 73
corp5 17-Feb 3 24
corp6 17-Feb 4 44
corp11 17-Feb 1 30
corp13 17-Feb 1 16
corp21 15-Feb 3 21
I have filtered them based on investment id as
invest_data = read.csv('input.csv')
investment_id = invest_data$investment_id
filtered1 <- subset(invest_data,investment_id==1)
filtered2 <- subset(invest_data,investment_id==2)
filtered3 <- subset(invest_data,investment_id==3)
filtered4 <- subset(invest_data,investment_id==4)
so filtered1 will give me
> filtered1
corp_id date investment_id stock_rate
1 corp1 17-Feb 1 65
2 corp1 16-Feb 1 70
3 corp1 15-Feb 1 69
4 corp1 14-Feb 1 89
5 corp1 13-Feb 1 88
6 corp2 17-Feb 1 95
7 corp2 16-Feb 1 135
8 corp2 15-Feb 1 140
13 corp11 17-Feb 1 30
14 corp17 17-Feb 1 16
My objective is to rearrange filtered1 as
date corp1 corp2 corp11 corp17
17-Feb 65 95 30 16
16-Feb 70 135
15-Feb 69 140
14-Feb 89
13-Feb 88
#(The above figures represent the corp-wise and date-wise rates for
investment_id = 1.)
Please guide me how the filtered1 can be rearranged?
Thanking you
Anna Carter
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
[[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.
