In Python how to do Correlation between Multiple Columns more than 2 variables?

Question

I have a Pandas Dataframe like so:

id    cat1    cat2    cat3    num1    num2
1     0       WN      29      2003    98
2     1       TX      12      755     76
3     0       WY      11      845     32
4     1       IL      19      935     46

I want to find out the correlation between cat1 and column cat3, num1 and num2 or between cat1 and num1 and num2 or between cat2 and cat1, cat3, num1, num2

When I use df.corr() it gives Correlation between all the columns in the dataframe, but I want to see Correlation between just these selective columns detailed above.

How do I do that in Python pandas?

A Thousand thanks in advance for your answers.

df[['Cat1','cat3']].corr(), etc.

DYZ
– DYZ

2017-02-09 05:11:35 +00:00
Commented Feb 9, 2017 at 5:11 — DYZ
– DYZ, Commented Feb 9, 2017 at 5:11

Emmanuel Murairi · Accepted Answer · 2023-04-24 13:24:50Z

11

I tried the following and it worked :

features1=['cat1','cat2','cat3']
features2=['Cat1', 'Cat2','num1','num2']

df[features1].corr()
df[features2].corr()

A good way to select the columns based on the need when you have a very high number of variables in your dataset.

edited Apr 24, 2023 at 13:24

Emmanuel Murairi

4134 silver badges16 bronze badges

answered Feb 9, 2017 at 5:50

gather bar

4741 gold badge9 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3064538 Over a year ago

You don't need to call list, your argument is already a list.

Collectives™ on Stack Overflow

In Python how to do Correlation between Multiple Columns more than 2 variables?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related