Message-ID: <CANz9Z_K6nZ20scNwmb6tmaeex56+RpjymROQU6iAkSZwjU68yA@mail.gmail.com>
Date: 2011-07-04T18:45:23Z
From: Joshua Wiley
Subject: How to merge two files
In-Reply-To: <CAN2R2TW88a1f9Mc9Z6qhkfEoBgzS8_1b-48UyNCeRFVRwdEBbQ@mail.gmail.com>
Dear Albert,
Here is one way:
tmp.scores <- readLines("~/scores.txt")
tmp.seq <- readLines("~/seq.txt")
tmp.seq <- strsplit(gsub("N", "", tmp.seq), "")[[1]]
genedat <- data.frame(Sequence = tmp.seq, Scores = as.numeric(tmp.scores))
## Yields
> genedat
Sequence Scores
1 A 0.80
2 T 0.70
3 T 0.30
4 A 0.50
5 A 0.60
6 A 0.50
7 G 0.01
8 G 0.90
9 G 0.30
10 C 0.80
Hope this helps,
Josh
2011/7/4 albert coster <albertcoster2010 at gmail.com>:
> Dear all,
>
> I have two files :
>
> seq.txt: NNNNNNNNNNATTAAAGGGC
>
> scores.txt :
>
> 0.8
> 0.7
> 0.3
> 0.5
> 0.6
> 0.5
> 0.01
> 0.9
> 0.3
> 0.8
>
> I want output as following
>
> A 0.8
> T 0.7
> T 0.3
> A 0.5
> A 0.6
> A 0.5
> G 0.01
> G 0.9
> G 0.3
> C 0.8
>
> Where N are deleted and only A/T/G/C are appearing in a column.
>
> Thanks
>
> Albert
>
> ______________________________________________
> R-help at 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.
>
>
--
Joshua Wiley
Ph.D. Student, Health Psychology
University of California, Los Angeles
http://www.joshuawiley.com/