Mastering Python Scripting for System Administrators

DataFrames

In this section, we are going to learn about pandas DataFrames. DataFrames are two-dimensional labeled data structures that have columns and may be of different data types. DataFrames are similar to SQL tables or a spreadsheet. They are the most common object when working with pandas.

Now, we are going to look at an example of reading data from a csv file into a DataFrame. For that, you must have a csv file present in your system. If you don't have a csv file in your system, create a file named employee.csv, as follows:

Id, Name, Department, Country101, John, Finance, US102, Mary, HR, Australia103, Geeta, IT, India104, Rahul, Marketing, India105, Tom, Sales, Russia

Now, we are going to read this csv file into a DataFrame. For ...