[R] How to fix this problem

[@vi@e@gross m@iii@g oii gm@ii@com]

David,

This may just be the same as your earlier problem. When the type of a column is guessed by looking at the early entries, any non-numeric entry forces the entire column to be character.

Suggestion: fix your original EXCEL FILE or edit your CSV to remove the last entries that look just lie commas.


-----Original Message-----
From: R-help <r-help-bounces using r-project.org> On Behalf Of Parkhurst, David
Sent: Sunday, September 24, 2023 2:06 PM
To: r-help using r-project.org
Subject: [R] How to fix this problem

I have a matrix, KD6, and I�m trying to get a correlation matrix from it.  When I enter cor(KD6), I get the message �Error in cor(KD6) : 'x' must be numeric�.
Here are some early lines from KD6:
        Flow  E..coli        TN    SRP     TP    TSS
1      38.8    2,420    1.65300 0.0270 0.0630  66.80
2     133.0    2,420    1.39400 0.0670 0.1360   6.80
3      86.2       10    1.73400 0.0700 0.1720  97.30
4       4.8    5,390    0.40400 0.0060 0.0280   8.50
5       0.3    2,490    0.45800 0.0050 0.0430  19.75
6       0.0      186    0.51200 0.0040 0.0470  12.00
7      11.1    9,835    1.25500 0.0660 0.1450  12.20

Why are these not numeric?
There are some NAs later in the matrix, but I get this same error if I ask for cor(KD6[1:39,]) to leave out the lines with NAs.  Are they a problem anyway?

	[[alternative HTML version deleted]]