Skip to content
Prev 388015 / 398502 Next

Finding strings in a dataset

Thank you everyone, for the very helpful suggestions. I understand that my
question is not altogether clear. So let me share an example.
The below is a part of a dataset, there are around 40000 rows.
LI(PPM) SC(PPM) TI(PPM) V(PPM)
3.1/0.5 ? ? ?
? ? 0.2/0.3
?
? 2.8/0.75 ? >0.2
0.0389 108.6591 0.0214 85.18818
0.0688 146.1739 0.0117 108.0221
0.0265 121.3268 0.00749 85.34932
0.139901 125.3066 0.00984 97.23175

Now the 0.2/0.3, >0.2 these are treated as strings. When I am using the
spec(Dataset) function in R, it shows me which columns contain strings.
Like it will tell me that LI (PPM), SC(PPM) etc. contain strings. But, I
would like to know if there is someway where I can learn exactly where the
string values are, like for LI(PPM) in the top row. As this is a huge
dataset, it is difficult to go through all the rows manually.
Thank you again and in anticipation.
Tuhin



On Sun, May 16, 2021 at 4:25 AM Avi Gross via R-help <r-help at r-project.org>
wrote: