An error when parsing a string to double in Java

Question

I'm trying to read a csv file and convert its String values to double.

public void trq() throws IOException, ParseException {
    Test4 obj = new Test4();
    String path = "transposedData1.csv";
    BufferedReader readerBuffer = new BufferedReader(new FileReader(path));
    String line;
    List<Double> results = new ArrayList<Double>();
    while ((line = readerBuffer.readLine()) != null) {
        if(!line.contains("NA")) {
            ArrayList<String> data_per_class = convertCSVtoArrayList11(line);

            List<Double> doubleList = data_per_class.stream()
                    .map(Double::parseDouble)
                    .collect(Collectors.toList()); // the error here

            // do other things
        }
    }
}

public static ArrayList<String> convertCSVtoArrayList11(String pathCSV) {
    ArrayList<String> result = new ArrayList<String>();

    if (pathCSV != null) {
        String[] splitData = pathCSV.split("\\s*,\\s*");
        for (int i = 0; i < splitData.length; i++) {
            if (!(splitData[i] == null) || !(splitData[i].length() == 0)) {
                result.add(splitData[i].trim());
            }
        }
    }

    return result;
}

The CSV file looks like:

1.0  8.0  4.0  6.0
3.0  2.0  1.0  5.0
7.0  1.0  8.0  1.0
1.0  2.0  1.0  4.0

Note that there is no header. The file starts with values with no headers. The error I am getting is:

Exception in thread "main" java.lang.NumberFormatException: For input string: ""1.0""
    at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043)
    at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110)
    at java.lang.Double.parseDouble(Double.java:538)
    at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
    at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
    at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482)
    at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472)
    at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
    at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
    at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:566)
    at Test4.trq(Test4.java:1063) \\ I mentioned that in the code above

Do you have any idea how to solve this?

Looks like the file potentially contains a section with double quotes. Is the file content you provided the actual file content this output is from? — Jason
– Jason, Commented Apr 5, 2020 at 17:46
@Jason Yes, it is the actual file. I checked whether there are double quotes but I couldn't find. — Adam Amin
– Adam Amin, Commented Apr 5, 2020 at 17:48
Debugger time. Look at the value when the exception is thrown. — Thorbjørn Ravn Andersen
– Thorbjørn Ravn Andersen, Commented Apr 5, 2020 at 17:57

Arvind Kumar Avinash · Accepted Answer · 2020-04-05 17:49:13Z

2

Replace

pathCSV.split("\\s*,\\s*");

with

pathCSV.split("\\s+");

So that the numbers are split on spaces. Currently, they are getting stored into result with extra " e.g. ""1.0"" which should be stored as "1.0".

answered Apr 5, 2020 at 17:49

Arvind Kumar Avinash

81k10 gold badges98 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Jason Over a year ago

Proper solution, +1.

PM 77-1 Over a year ago

Why does it split at all? Pattern will never match.

Arvind Kumar Avinash Over a year ago

@PM77-1 - I didn't understand what you mean. The output of

String pathCSV = "1.0  8.0  4.0  6.0"; 		String[] splitData = pathCSV.split("\\s+"); 		System.out.println(Arrays.toString(splitData));

will be [1.0, 8.0, 4.0, 6.0].

PM 77-1 Over a year ago

@ArvindKumarAvinash - Sorry I was not clear. I have no problems with your solution. I was referring to your analysis of the original problem. I still do not understand where extra quotes come from.

cegredev · Accepted Answer · 2020-04-05 17:47:57Z

0

Based on the error message you can see, that the number is actually aurrounded by a pair of quotation marks, which probably causes the call to fail.

A quick fix would be to use asString = substring(1, asString.length() - 2);, with asString being the string that you want to parse to a double.

answered Apr 5, 2020 at 17:47

cegredev

1,5892 gold badges14 silver badges28 bronze badges

Comments

Himanshu · Accepted Answer · 2020-04-05 17:49:24Z

0

Use result.add(splitData[i].trim(). replaceAll("/"","") ) before returning

answered Apr 5, 2020 at 17:49

Himanshu

3,9802 gold badges16 silver badges34 bronze badges

Collectives™ on Stack Overflow

An error when parsing a string to double in Java

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related