Dear Sir,
Thanks for your guidance and sinecerly apologize for late reply from my end.
Regards
Amelia
On Wednesday, 3 June 2015 10:38 PM, Rui Barradas <ruipbarra...@sapo.pt> wrote:
Hello,
Try the following.
tmp <- strsplit(as.character(my_dat$instrument), "_")
tmp <- t(as.data.frame(tmp))
tmp <- data.frame(instrument = tmp[,1], sr_no = as.integer(tmp[, 2]),
my_dat$mtm_value)
result <- tmp[order(tmp[, 1], tmp[, 2]), ]
rm(tmp)
rownames(result) <- NULL
result
Hope this helps,
Rui Barradas
Em 03-06-2015 10:09, Amelia Marsh escreveu:
> Dear R forum
>
> I have a data (actually its a big data and I am only giving part of my
> interest) as
>
> my_dat = data.frame(instrument = c("EQ_0", "EQ_1", "EQ_10", "EQ_100", "EQ_2",
> "EQ_20", "IRS_0", "IRS_1", "IRS_10", "IRS_100", "IRS_2", "IRS_20"), mtm_value
> = c(23, 63, 8, 44, 68, 11, 83, 56, 73, 92, 14, 7))
>
>> my_dat
> instrument mtm_value
> 1 EQ_0 23
> 2 EQ_1 63
> 3 EQ_10 8
> 4 EQ_100 44
> 5 EQ_2 68
> 6 EQ_20 11
> 7 IRS_0 83
> 8 IRS_1 56
> 9 IRS_10 73
> 10 IRS_100 92
> 11 IRS_2 14
> 12 IRS_20 7
>
> I need to split the first column and arrange the output in the ascending
> order as shown below :
>
> instrument sr_no mtm_value
>
> 1 EQ 0 23
> 2 EQ 1 63
> 3 EQ 2 68
> 4 EQ 10 8
> 5 EQ 20 11
> 6 EQ 100 44
> 7 IRS 0 83
> 8 IRS 1 56
> 9 IRS 2 14
> 10 IRS 10 73
> 11 IRS 20 7
> 12 IRS 100 92
>
> I tried to use gsub, strsplit but doesn't give me the required output.
>
> Kindly guide
>
> Regards
>
> Amelia
>
> ______________________________________________
> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
>
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.
