Q:

How to get plot correlation matrix using Pandas?

belongs to collection: Python Pandas Programs

mahmoud2506
Save to bookmark
|
2022-05-25
|
  165 
0

Pandas is a special tool that allows us to perform complex manipulations of data effectively and efficiently. Inside pandas, we mostly deal with a dataset in the form of DataFrame. DataFrames are 2-dimensional data structures in pandas. DataFrames consist of rows, columns, and the data.

There is always some kind of similarity/difference between all the values of all the columns in pandas DataFrame. This similarity or difference is known as the correlation of values in a DataFrame. To find the correlation in pandas, we use pandas.DataFrame.corr() method in pandas.

pandas.DataFrame.corr() Method

This method is used to find the pair-wise correlation (similarities/differences) of the column values. An important point is if there is any null value present in any column, pandas.DataFrame.corr() automatically excludes it and also the non-numeric data is ignored.

Syntax:

DataFrame.corr(method='pearson', min_periods=1)

To work with pandas, we need to import pandas package first, below is the syntax:

import pandas as pd
Python programming, examples, Python programming examples,
login and add your own answer to this question

All Answers

mahmoud2506
2022-05-25
need an explanation for this answer? contact us directly to get an explanation for this answer

Let us understand with the help of an example.

# Importing pandas package
import pandas as pd

# Importing seaborn package
import seaborn as sn

# Import matplotlib package
import matplotlib.pyplot as plt

# Create a DataFrame
df = pd.DataFrame({
    'A':[39,40,32,45,89,102293],
    'B':[40,39,22,54,22,0],
    'C':[42,44,20,49,30,110]}
    )

# Display original DataFrame
print("Original DataFrame:\n",df,"\n")

# Finding correlation
result = df.corr(method ='pearson')

# Display result
print("Correlation in DataFrame is:\n",result,"\n")

Output:

Example 1: Get plot correlation matrix

For visualising the correlation matrix, use the following code:

# Visualising Correlation
sn.heatmap(result, annot=True)

print(plt.show())

Output:

Example 2: Get plot correlation matrix

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Python Pandas Programs
This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now
How to merge multiple DataFrames on columns?... >>
<< Why should we make a copy of a DataFrame in Pandas...