Hello I have a very confusing problem for me that I am really struggling with
Here is the problem:
I have a database which includes 1500 cities. Each city has 3 type of characteristic and a value.
My intention is to group cities together which have very similar values (around +-50), and to see the patterns behind values based on 3 characteristics. As you see, we can search for 7 possibilities (2&3, 1&2, 1, 1&2&3...)
I want to infer something like this: "The cities which have very similar values (around +-50), show us that characteristic-2 and characteristic-3 of those cities are the same"
What should I do?