Hi, I’m trying to filter missing values from an excel spreadsheet that I’ve imported. Initially the missing value was a period (.) and then I changed it to a “na” in the spreadsheet. I’ve tried to DeleteCases with the command DeleteCases[data,“na”] but this had no effect. I’ve tried various other approaches based on what I’ve read on missing value options in documentation. Any suggestions would be much appreaciated. Best, Pat
Try DeleteCases[data,“na”,Infinity] .
Since you know what the “missing” value is going to be beforehand (na), you could also use SemanticImport with a replacement rule in your import options. There’s an example in the documentation.