In this Python Pandas tutorial, you will learn the basics of Pandas by code examples written in Python. If you have zero knowledge of Python, please read this article first.
Pandas Tutorial: What is Pandas?
Pandas is an open source library for Python containing data structures and data analysis tools.
Constructing a DataFrame
The DataFrame is the main data structure used in Pandas. Personally, I think of it as a database on which I can execute queries. A DataFrame is constructed as follows:
There are a few things worth mentioning. Often, Pandas is abbreviated as pd (like Numpy which is often abbreviated as np). If you look at other code, you will see that DataFrames are often abbreviated by df. Here, the DataFrame is constructed using data from a list of lists. The columns argument specifies the keys of the data. The result is the following DataFrame:
Instead of construction by lists, we could have initialized the DataFrame by using a dictionary. This is more convenient for most people:
However, it becomes a tedious task to keep track of all the keys. The convenience here is that you do not need to specify the column names during the DataFrame construction.
Query the Data
It is easy to select data from a single column:
Selecting multiple columns is also easy:
Selecting some rows is also not hard:
Plot The Data
It is fairly easy to make plots of the data using the DataFrame object. For example, it is straightforward to make a histogram out of the ages:
This is created by the following code (which is a piece of a cookie):
Pandas is an absolute must-have library for any data science related project. In this tutorial, only the very basic steps of Pandas are covered. Are you interested in more Pandas and do you want to learn advanced Pandas operations? Or do you want to setup your data pipelines in Pandas? Then please check out our new Pandas course!
Get updates in your inbox
Join over 8,000 data science learners.