[R] Importing data in text file into R
    amarjit singh sethi 
    ajss_gndu at yahoo.com
       
    Sat May 24 05:40:32 CEST 2008
    
    
  
Dear all,
I am quite new to R; facing certain problems:
Say, I have a text file( named as "try"):
Year	C1	C2	C3	C4	C5	C6
Y1	3.5	13.8	9.5	6.8	0.4	24.2
Y2	3.8	13.9	9.9	7.6	0.7	12.8
Y3	4.5	14.5	14.2	9.2	0.6	14.5
Y4	5.9	16.2	24.6	12.7	0.2	24.3
Y5	7.2	20.4	40.6	18.2	0.8	28.2
Y6	5.9	18.6	37.4	14.5	0.3	36.9
Y7	8.0	16.1	88.6	24.1	0.1	34.6
Y8	13.6	21.1	56.3	19.0	0.7	33.3
I wish to import the file into R and make certain
computations, like intercorrelation matrix. I tried
the following syntax:
# Inputting the data file (saved in text format)
df="trial.txt"
idt=read.table(df,header=T, sep="\t")
idt
# To generate intercorrelatio matrix
r = cor(idt)
r=round(r, 4)
r
The seems to have been read, but further computations
not made, with the following output:
> # Inputting the data file (saved in text format)
> df="trial.txt"
> idt=read.table(df,header=T, sep="\t")
> idt
  Year   C1   C2   C3   C4  C5   C6
1   Y1  3.5 13.8  9.5  6.8 0.4 24.2
2   Y2  3.8 13.9  9.9  7.6 0.7 12.8
3   Y3  4.5 14.5 14.2  9.2 0.6 14.5
4   Y4  5.9 16.2 24.6 12.7 0.2 24.3
5   Y5  7.2 20.4 40.6 18.2 0.8 28.2
6   Y6  5.9 18.6 37.4 14.5 0.3 36.9
7   Y7  8.0 16.1 88.6 24.1 0.1 34.6
8   Y8 13.6 21.1 56.3 19.0 0.7 33.3
> # To generate intercorrelatio matrix
> r = cor(idt)
Error in cor(idt) : missing observations in cov/cor
In addition: Warning message:
In cor(idt) : NAs introduced by coercion
> r=round(r, 4)
Error: object "r" not found
> r
Error: object "r" not found
Kindly advise me as to how to get rid of the error
message.
AJSS
    
    
More information about the R-help
mailing list