It looks here as though the E coli column has commas in it so will be
treated as character.
Michael
On 25/09/2023 15:45, avi.e.gross at gmail.com wrote:> 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 at r-project.org> On Behalf Of
Parkhurst, David
> Sent: Sunday, September 24, 2023 2:06 PM
> To: r-help at 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]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
>
--
Michael