Comparing data

Here, we are going to learn about how to compare data in Python. We will use a pandas module for this purpose.

Pandas is an open source data analysis library that provides data structures and data analysis tools that are easy to use. It makes importing and analyzing data easier.

Before starting with the example, make sure you have pandas installed on your system. You can install pandas as follows:

pip3 install pandas     --- For Python3

or

pip install pandas       --- For python2

We will study an example of comparing data using pandas. Initially, we will create two csv files: student1.csv and student2.csv. We will compare the data of these two csv files and in output it should return the comparison. Create two csv files as follows:

Create the student1.csv file content as follows:

Id,Name,Gender,Age,Address
101,John,Male,20,New York
102,Mary,Female,18,London
103,Aditya...