Hi community,
I was wondering if anyone can give any advice on this:
> Chr = c("NC1", "NC2", "NC3")
> Pos = c(150, 165, 190)
> Seq = c("GATCGATGAC", "GATG", "ACGTAG")
> df = data.frame(Chr, Pos, Seq)
> df
Chr Pos Seq
1 NC1 150 GATCGATGAC
2 NC2 165 GATG
3 NC3 190 ACGTAG
I want to count the characters of every row for the "Seq" Column and create a 4th column (let's call it NoCh) reporting the number of characters. First row GATCGATGAC is 10 characters. Second row GATG is 4 Third row ACGTAG is 6
Practically I want to do this:
> df
Chr Pos Seq NoCh
1 NC1 150 GATCGATGAC 10
2 NC2 165 GATG 4
3 NC3 190 ACGTAG 6
Any help would be much appreciated
Ioannis
2 answers
> df = data.frame(Chr, Pos, Seq, stringsAsFactors = FALSE)
> df$noChar <- nchar(df$Seq)
> df
Chr Pos Seq noChar
1 NC1 150 GATCGATGAC 10
2 NC2 165 GATG 4
3 NC3 190 ACGTAG 6
When I can, I give code so that people see how it's done properly (or invite critique by other experts who will examine why my solution is not appropriate). I've learnt so much by reading other people's code (especially after futile attempts of my own) so I try to pass that on, especially if it's tiny snippets that won't cost me much of my own time. Just a different perspective
Log in to answer this question.
-
Creating sample groups from a combination of genes for survival analysis
written by 1769mkc
-
Add pvalues to multiple ggboxplots
written by lupitariveratorruco •
-
Tutorial: data.frames in R: How vectorization can save you time and heartache
written by rpolicastro
-
problem changing color for annotations
written by Maria •
-
Tutorial: Long versus wide data for plotting genomics data in R.
written by rpolicastro
-
Dataframe accumulative cell addition into new column
written by tiriyon •
-
Extract gnomad AF for specific position and REF/ALT allele with R
written by Nicolas Rosewick
-
Complexheatmap annotation legend
written by Prakash
-
Question about mapping motif binding sites to genome location
written by kanwarjag
-
Gviz : fill and line arrow color issues
written by Nicolas Rosewick
Unless you're sure you want factors, create dataframes using
data.frame(...,stringsAsFactors=FALSE). That, or usetidyverseand create atibble.Yes I will import my files into R using
this will do the job. Thanks a lot Ram.