Mastering Python Scripting for System Administrators

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 Python3orpip 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 ...