Python pandas tutorial with example

Python Pandas tutorial for beginners, learn how to install python pandas in windows and use this tool for analyzing and learning from data.

Install Python Pandas on Windows

You need to install pandas in your local development environment, run command pip install pandas

If you are using visual studio code as editor, then go to terminal and run the command.

Why to use python pandas?

Python panda is a data-management tool, this toll is for data cleaning, transforming, and analyzing, very similar to SQL SSIS.

We can work with data RDBMS or CSV file using Python Pandas.

There are many in-built functionalities in python pandas, which helps finding average, max, or min of any column, correlation among columns etc.

It also has function like sorting, filtering rows or columns with any specified criteria

Python pandas also helps in visualizing data with help from Matplotlib charting like Plot bars, lines, histograms, bubbles etc.

Loading data from excel file using python pandas

Loading data from excel file in python is just two lines code, Super easy!

url =path+ "\\testdata\\world_cup_results.xlsx"
df = pd.read_excel(url)

Here is an example of how to load data from excel file and show matrix using python. Pandas tool is really useful for data visualization.

import pandas as pd
import os
from pandas.plotting import scatter_matrix
from matplotlib import pyplot

path=os.getcwd()
url =path+ "\\testdata\\world_cup_results.xlsx"
df = pd.read_excel(url)
print (df)

df.hist()
pyplot.show()

scatter_matrix(df)
pyplot.show()

Here are some graphical representation of excel data, notice, how the method pyplot.show() is used for creating a pop window.

python pandas scatter example

So whenever you think of developing analytics in python application, python pandas can be very useful.

You may be interested to learn more about Data Analytics skills, Courses etc.

 
Python pandas library
pandas example
Python programming examples | Join Python Course