How to compare data of two CSV files in java (row by row)

I am working on a java project where i have to compare two CSV files. First program should read the data form every column and compare it with all other column's.

CSVFILE1 has 3 column's

name , organization , preference

CSVFILE2 has 3 column's

name , organization , preference .

If both file has same values in all the 3 of the column's then program should return true . If not I have to check in 3rd column and make changes to CSVFILE2 .

Presently I have made method where I can read CSVFILE'S and assign to an array. Below is my code.

import java.awt.List;

import java.io.File;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.Scanner;



public class Hospetal {

    static String file1Path1 = "C:\\Users\\DANGER\\Desktop\\New folder\\Diva.csv";



    public static void main(String args) throws IOException {

        ReadFirstFile();



    }



    //Reading file form csv

    public static void ReadFirstFile() throws FileNotFoundException {

        String token1 = "";

        Scanner inFile1 = new Scanner(new File(file1Path1)).useDelimiter(",\s*");

        ArrayList<String> temps = new ArrayList<String>();



        // while loop

        while (inFile1.hasNext()) {

            // find next line

            token1 = inFile1.next();

            temps.add(token1);

        }



        inFile1.close();



        String tempsArray = temps.toArray(new String[0]);



        for (String s : tempsArray) {

            System.out.println(s);

        }

    }

}

edited Nov 20 '18 at 11:53

deHaar

2,39431628

asked Nov 20 '18 at 11:10

Divakar R

2416

this is probably what you are looking for poi.apache.org/components/spreadsheet You can basically read and compare two different excels. I used this library before to read one excel and process row by row

– quartaela
Nov 20 '18 at 11:26

Thanks for the resource. i will try the solution and let you know.

– Divakar R
Nov 20 '18 at 11:37

what is the change you need to do if they don't match?

– Ruwanka Madhushan
Nov 20 '18 at 11:40

will consider the preference column (preference column start with 1 and increments if not match on first pref) . if the preference is not 1 then will increment and search for 2 (this should meet the criteria where name and organisation should be same ) .

– Divakar R
Nov 20 '18 at 11:45

If you are still intent upon doing this yourself instead of using third party arrays you could put the data into a 2 dimensional arrays where the outer arrays are the rows and the inner arrays are the columns in each row. Then you could iterate over them and do what you need to if something is different

– Katie.Sun
Nov 20 '18 at 13:51

add a comment |

I am working on a java project where i have to compare two CSV files. First program should read the data form every column and compare it with all other column's.

CSVFILE1 has 3 column's

name , organization , preference

CSVFILE2 has 3 column's

name , organization , preference .

If both file has same values in all the 3 of the column's then program should return true . If not I have to check in 3rd column and make changes to CSVFILE2 .

Presently I have made method where I can read CSVFILE'S and assign to an array. Below is my code.

import java.awt.List;

import java.io.File;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.Scanner;



public class Hospetal {

    static String file1Path1 = "C:\\Users\\DANGER\\Desktop\\New folder\\Diva.csv";



    public static void main(String args) throws IOException {

        ReadFirstFile();



    }



    //Reading file form csv

    public static void ReadFirstFile() throws FileNotFoundException {

        String token1 = "";

        Scanner inFile1 = new Scanner(new File(file1Path1)).useDelimiter(",\s*");

        ArrayList<String> temps = new ArrayList<String>();



        // while loop

        while (inFile1.hasNext()) {

            // find next line

            token1 = inFile1.next();

            temps.add(token1);

        }



        inFile1.close();



        String tempsArray = temps.toArray(new String[0]);



        for (String s : tempsArray) {

            System.out.println(s);

        }

    }

}

edited Nov 20 '18 at 11:53

deHaar

2,39431628

asked Nov 20 '18 at 11:10

Divakar R

2416

this is probably what you are looking for poi.apache.org/components/spreadsheet You can basically read and compare two different excels. I used this library before to read one excel and process row by row

– quartaela
Nov 20 '18 at 11:26

Thanks for the resource. i will try the solution and let you know.

– Divakar R
Nov 20 '18 at 11:37

what is the change you need to do if they don't match?

– Ruwanka Madhushan
Nov 20 '18 at 11:40

will consider the preference column (preference column start with 1 and increments if not match on first pref) . if the preference is not 1 then will increment and search for 2 (this should meet the criteria where name and organisation should be same ) .

– Divakar R
Nov 20 '18 at 11:45

If you are still intent upon doing this yourself instead of using third party arrays you could put the data into a 2 dimensional arrays where the outer arrays are the rows and the inner arrays are the columns in each row. Then you could iterate over them and do what you need to if something is different

– Katie.Sun
Nov 20 '18 at 13:51

add a comment |

I am working on a java project where i have to compare two CSV files. First program should read the data form every column and compare it with all other column's.

CSVFILE1 has 3 column's

name , organization , preference

CSVFILE2 has 3 column's

name , organization , preference .

If both file has same values in all the 3 of the column's then program should return true . If not I have to check in 3rd column and make changes to CSVFILE2 .

Presently I have made method where I can read CSVFILE'S and assign to an array. Below is my code.

import java.awt.List;

import java.io.File;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.Scanner;



public class Hospetal {

    static String file1Path1 = "C:\\Users\\DANGER\\Desktop\\New folder\\Diva.csv";



    public static void main(String args) throws IOException {

        ReadFirstFile();



    }



    //Reading file form csv

    public static void ReadFirstFile() throws FileNotFoundException {

        String token1 = "";

        Scanner inFile1 = new Scanner(new File(file1Path1)).useDelimiter(",\s*");

        ArrayList<String> temps = new ArrayList<String>();



        // while loop

        while (inFile1.hasNext()) {

            // find next line

            token1 = inFile1.next();

            temps.add(token1);

        }



        inFile1.close();



        String tempsArray = temps.toArray(new String[0]);



        for (String s : tempsArray) {

            System.out.println(s);

        }

    }

}

edited Nov 20 '18 at 11:53

deHaar

2,39431628

asked Nov 20 '18 at 11:10

Divakar R

2416

I am working on a java project where i have to compare two CSV files. First program should read the data form every column and compare it with all other column's.

CSVFILE1 has 3 column's

name , organization , preference

CSVFILE2 has 3 column's

name , organization , preference .

If both file has same values in all the 3 of the column's then program should return true . If not I have to check in 3rd column and make changes to CSVFILE2 .

Presently I have made method where I can read CSVFILE'S and assign to an array. Below is my code.

import java.awt.List;

import java.io.File;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.Scanner;



public class Hospetal {

    static String file1Path1 = "C:\\Users\\DANGER\\Desktop\\New folder\\Diva.csv";



    public static void main(String args) throws IOException {

        ReadFirstFile();



    }



    //Reading file form csv

    public static void ReadFirstFile() throws FileNotFoundException {

        String token1 = "";

        Scanner inFile1 = new Scanner(new File(file1Path1)).useDelimiter(",\s*");

        ArrayList<String> temps = new ArrayList<String>();



        // while loop

        while (inFile1.hasNext()) {

            // find next line

            token1 = inFile1.next();

            temps.add(token1);

        }



        inFile1.close();



        String tempsArray = temps.toArray(new String[0]);



        for (String s : tempsArray) {

            System.out.println(s);

        }

    }

}

java

edited Nov 20 '18 at 11:53

deHaar

2,39431628

asked Nov 20 '18 at 11:10

Divakar R

2416

edited Nov 20 '18 at 11:53

deHaar

2,39431628

asked Nov 20 '18 at 11:10

Divakar R

2416

edited Nov 20 '18 at 11:53

deHaar

2,39431628

edited Nov 20 '18 at 11:53

deHaar

2,39431628

edited Nov 20 '18 at 11:53

deHaar

2,39431628

asked Nov 20 '18 at 11:10

Divakar R

2416

asked Nov 20 '18 at 11:10

Divakar R

2416

asked Nov 20 '18 at 11:10

Divakar R

2416

this is probably what you are looking for poi.apache.org/components/spreadsheet You can basically read and compare two different excels. I used this library before to read one excel and process row by row

– quartaela
Nov 20 '18 at 11:26

Thanks for the resource. i will try the solution and let you know.

– Divakar R
Nov 20 '18 at 11:37

what is the change you need to do if they don't match?

– Ruwanka Madhushan
Nov 20 '18 at 11:40

will consider the preference column (preference column start with 1 and increments if not match on first pref) . if the preference is not 1 then will increment and search for 2 (this should meet the criteria where name and organisation should be same ) .

– Divakar R
Nov 20 '18 at 11:45

If you are still intent upon doing this yourself instead of using third party arrays you could put the data into a 2 dimensional arrays where the outer arrays are the rows and the inner arrays are the columns in each row. Then you could iterate over them and do what you need to if something is different

– Katie.Sun
Nov 20 '18 at 13:51

add a comment |

this is probably what you are looking for poi.apache.org/components/spreadsheet You can basically read and compare two different excels. I used this library before to read one excel and process row by row

– quartaela
Nov 20 '18 at 11:26

Thanks for the resource. i will try the solution and let you know.

– Divakar R
Nov 20 '18 at 11:37

what is the change you need to do if they don't match?

– Ruwanka Madhushan
Nov 20 '18 at 11:40

will consider the preference column (preference column start with 1 and increments if not match on first pref) . if the preference is not 1 then will increment and search for 2 (this should meet the criteria where name and organisation should be same ) .

– Divakar R
Nov 20 '18 at 11:45

If you are still intent upon doing this yourself instead of using third party arrays you could put the data into a 2 dimensional arrays where the outer arrays are the rows and the inner arrays are the columns in each row. Then you could iterate over them and do what you need to if something is different

– Katie.Sun
Nov 20 '18 at 13:51

this is probably what you are looking for poi.apache.org/components/spreadsheet You can basically read and compare two different excels. I used this library before to read one excel and process row by row

– quartaela
Nov 20 '18 at 11:26

Thanks for the resource. i will try the solution and let you know.

– Divakar R
Nov 20 '18 at 11:37

what is the change you need to do if they don't match?

– Ruwanka Madhushan
Nov 20 '18 at 11:40

will consider the preference column (preference column start with 1 and increments if not match on first pref) . if the preference is not 1 then will increment and search for 2 (this should meet the criteria where name and organisation should be same ) .

– Divakar R
Nov 20 '18 at 11:45

If you are still intent upon doing this yourself instead of using third party arrays you could put the data into a 2 dimensional arrays where the outer arrays are the rows and the inner arrays are the columns in each row. Then you could iterate over them and do what you need to if something is different

– Katie.Sun
Nov 20 '18 at 13:51

add a comment |

1 Answer
1

active

oldest

votes

i suggest you take a look at the apache commons-csv library which makes it very easy to read and parse csv records.
then you can easily parse both files resulting in two lists of CSVRecords which then can be easily compared and in case in case of an a record not being the same in file 2 as in file 1 you can then make changes to it.

edit: https://commons.apache.org/proper/commons-csv/

answered Nov 20 '18 at 11:38

meaningqo

is there way where i can solve the problem without any 3rd party libraries?

– Divakar R
Nov 20 '18 at 11:52

sure there is. you could always read each file line by line or column by colum into a list and compare them using a comparator and then make changes to the second file where it is required. however why do all the nasty work that someone else has already done and offers it to use for free.

– meaningqo
Nov 20 '18 at 12:29

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53391710%2fhow-to-compare-data-of-two-csv-files-in-java-row-by-row%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

edit: https://commons.apache.org/proper/commons-csv/

answered Nov 20 '18 at 11:38

meaningqo

is there way where i can solve the problem without any 3rd party libraries?

– Divakar R
Nov 20 '18 at 11:52

sure there is. you could always read each file line by line or column by colum into a list and compare them using a comparator and then make changes to the second file where it is required. however why do all the nasty work that someone else has already done and offers it to use for free.

– meaningqo
Nov 20 '18 at 12:29

add a comment |

edit: https://commons.apache.org/proper/commons-csv/

answered Nov 20 '18 at 11:38

meaningqo

is there way where i can solve the problem without any 3rd party libraries?

– Divakar R
Nov 20 '18 at 11:52

sure there is. you could always read each file line by line or column by colum into a list and compare them using a comparator and then make changes to the second file where it is required. however why do all the nasty work that someone else has already done and offers it to use for free.

– meaningqo
Nov 20 '18 at 12:29

add a comment |

edit: https://commons.apache.org/proper/commons-csv/

answered Nov 20 '18 at 11:38

meaningqo

edit: https://commons.apache.org/proper/commons-csv/

answered Nov 20 '18 at 11:38

meaningqo

answered Nov 20 '18 at 11:38

meaningqo

answered Nov 20 '18 at 11:38

meaningqo

answered Nov 20 '18 at 11:38

meaningqo

is there way where i can solve the problem without any 3rd party libraries?

– Divakar R
Nov 20 '18 at 11:52

sure there is. you could always read each file line by line or column by colum into a list and compare them using a comparator and then make changes to the second file where it is required. however why do all the nasty work that someone else has already done and offers it to use for free.

– meaningqo
Nov 20 '18 at 12:29

add a comment |

is there way where i can solve the problem without any 3rd party libraries?

– Divakar R
Nov 20 '18 at 11:52

sure there is. you could always read each file line by line or column by colum into a list and compare them using a comparator and then make changes to the second file where it is required. however why do all the nasty work that someone else has already done and offers it to use for free.

– meaningqo
Nov 20 '18 at 12:29

is there way where i can solve the problem without any 3rd party libraries?

– Divakar R
Nov 20 '18 at 11:52

sure there is. you could always read each file line by line or column by colum into a list and compare them using a comparator and then make changes to the second file where it is required. however why do all the nasty work that someone else has already done and offers it to use for free.

– meaningqo
Nov 20 '18 at 12:29

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu