[R] Missing Values

Yves Magliulo ym at climpact.com
Mon Dec 6 17:15:52 CET 2004

about the way you import your data in R : 
if you have a large data set in EXCEL, you should rather save it
directly in EXCEL in csv format with tab or ";" separator for instance, 
leting your missing value blank or empty cells.

->then with ?read.table or ?read.csv, you should not have trouble to
import your data (see option in help pages).
na.string option will convert for you your missing value in NA.

you could also do it directly from excel to R :
cran.r-project.org/doc/manuals/R-data.pdf for more info

yves Magliulo, PARIS

Le lun 06/12/2004 à 16:26, nhy303 at abdn.ac.uk a écrit :
> I have just started using R for my PhD.  I am importing my data from Excel
> via notepad into Word.  Unfortunately, my data has many missing values.  I
> have put '.' and this allowed me to import the data into R.  However, I
> now want to interpolate these missing values.  Please can someone give me
> some pointers as to the method/code I could use?
> Thankyou,
> Lillian.
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

More information about the R-help mailing list