[R] how to ignore or omit somethings while reading the data table

John Kane jrkrideau at yahoo.ca
Wed Jan 2 17:37:16 CET 2008


Why not read in the file and then change that column
from a character to a numeric? 
Simple-minded example"

aa <- c("$.50" ,"$.5", "$.25" )
bb <- gsub("\\$", "", aa)  # Drop the $ symbol
cc <- as.numeric(bb) # convert character to numeric.
cc


--- mrafi <confessin at gmail.com> wrote:

> 
> yeah...i'd have done that but it is a 20 mb csv
> file...and then there are
> other columns of data also..which could be distorted
>  by this...
> 
> r_a_mueller wrote:
> > 
> > Am Mittwoch, 2. Januar 2008 14:14 schrieb mrafi:
> >> hello respected ppl...
> >> am a engg. student...i was trying to use R in
> statistical calculations
> >> now the problem is..i imported a huge tsv file
> onto R...it has a column
> > csv?
> >> which gives cost...and it has "$" with each
> numerical value in this
> >> column...it is something like
> this..$.05,$.1,$.075...and so on..
> >> R is reading it as "character vector"...
> >> i tried using all the arguments but could only
> change it to a "factor"
> >> i want to read it as numericals...and perform
> further operations..
> >> i know it is a stupid problem but can any1 help
> me get outta this...
> >> thank you all...!!!
> > I'd like to have it simple... open your csv-file
> in a text editor, with 
> > "find/replace" replace your "$" by ""
> > 
> > -- 
> > Richard Müller - Am Spring 9 - D-58802
> Balve-Eisborn
> > www.oeko-sorpe.de
> > 
> > ______________________________________________
> > 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.
> > 
> > 
> 
> -- 
> View this message in context:
>
http://www.nabble.com/how-to-ignore-or-omit-somethings-while-reading-the-data-table-tp14578131p14578428.html
> Sent from the R help mailing list archive at
> Nabble.com.
> 
> ______________________________________________
> 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.
> 



      Looking for the perfect gift? Give the gift of Flickr!




More information about the R-help mailing list