I got a question regarding reading data from a file. A pseudo question - what could be a good way to handle reading not-compatible data? The thing is I'll be reading 100+ x 400k+ tables for cluster analysis and there will be cells without a value, or a "?". It will be an excel file, so correct me if I'm wrong, I'll be needing a library for reading the file. If there is no value, I will add the average one after the whole file is loaded. Will the Java Excel library be a good choice?
One last question, if I read a line (String), cut it to pieces with a separator, then start parsing the parts to double, if it's not possible, an exception is thrown and caught, the index is saved in a list, which afterwards is used to place the average values?