•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why some entries not read if e.g 4a compared to 4, problem loading to R
Our take
Have you ever encountered issues with data entries being misread in R, especially when dealing with variations like 4a and 4b? This common challenge often arises from how certain data formats are interpreted, leading to unexpected NA values. The alignment of your entries can signal to R that these variations are not valid numbers. Fortunately, there are straightforward strategies to ensure that R accurately recognizes these fields.
I'm working with a datasheet and the column is field id. So they're 1,2,3 etc, but field 4 is separated into 4a and 4b. When the numbers are entered they align to the right hand side, but sometimes for 4a and 4b they are on the left for some reason. I didn't take notice until I load it as a csv into R, and R can't read some of the 4a and 4b rows, marking them as NA instead.
What went wrong and how do I make R read those rows as field 4a and 4b instead of putting NA in their place?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience