[R] How to fix this problem

Mon Sep 25 17:54:02 CEST 2023

An update please:
Collectively we have suggested removing commas from the "E..coli" column, checking for different forms of "NA", and looking outside the dataset for e-trash (spaces, text, or other content). For removing commas, I would use global replace to ensure that all commas were removed from all columns.

Did this solve the problem?

If not can you share some early lines and end lines from the data, and how R is reading your data? Something simple like head(KD6), tail(KD6), and str(KD6).

-----Original Message-----
From: R-help <r-help-bounces using r-project.org> On Behalf Of Michael Dewey
Sent: Monday, September 25, 2023 11:09 AM
To: avi.e.gross using gmail.com; 'Parkhurst, David' <parkhurs using indiana.edu>; r-help using r-project.org
Subject: Re: [R] How to fix this problem

[External Email]

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 using 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 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]]
>
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat/
> .ethz.ch%2Fmailman%2Flistinfo%2Fr-help&data=05%7C01%7Ctebert%40ufl.edu
> %7Cab9f2511a43e4f0cc0f308dbbdd95e2f%7C0d4da0f84a314d76ace60a62331e1b84
> %7C0%7C0%7C638312513538190955%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAw
> MDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sda
> ta=kbguZQ1HLECz6FFh%2FEZI5A1mI3GweE1q7WgUGLxpjOI%3D&reserved=0
> PLEASE do read the posting guide
> http://www.r/
> -project.org%2Fposting-guide.html&data=05%7C01%7Ctebert%40ufl.edu%7Cab
> 9f2511a43e4f0cc0f308dbbdd95e2f%7C0d4da0f84a314d76ace60a62331e1b84%7C0%
> 7C0%7C638312513538190955%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiL
> CJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=By
> 82TIbEPatOL9qRBoDbZ1tojvTd1%2B2Wo3UaBkIlt70%3D&reserved=0
> and provide commented, minimal, self-contained, reproducible code.
>

--
Michael

______________________________________________
R-help using 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.