How can I find the relationship between a categorical variable (zip codes) and the number of occurrence of another variable?

Asked Jan 23 '21 at 22:51

Active Jan 24 '21 at 00:40

Viewed 92 times

I have the following data frames: and I want to find the correlation between zip codes and number of violations per zip code. What is best way to calculate/quantify the relationship in Python?

    VIOLATION CODE  Zip Codes
0                F049    25426.0
1                F042    25426.0
2                F037    25426.0
3                F015    25426.0
4                F006    25426.0

Data frame sample

The data types of the variables

edited Jan 24 '21 at 00:40

asked Jan 23 '21 at 22:51

Zizo

Are you just trying to count the number of violations per zip code? Could you do a groupby? – luthervespers Jan 23 '21 at 22:58
Yes, but I want to quantitative the relationship, how could I do that? – Zizo Jan 23 '21 at 23:21

How can I find the relationship between a categorical variable (zip codes) and the number of occurrence of another variable?

0 Answers0