•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#R
#datasheet
#4a
#4b
#field id
#csv
#column
#data
#NA
#read
#alignment
#entries
#separated
#rows