Finding patterns in a database

Screenshot_1.jpg


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?

What should I do?

Post a sample sheet as described in the yellow banner?

Your sample file is the same as the picture. What patterns do you see in the 9 sample cities you have provided? How did you detect them? I can see that Helsinki (X, A, 1, 210) might be similar to Berlin (Y, A, 1, 213) because they are essentially the same in 3 of 4 columns, but I cannot say if that is the kind of pattern you are looking for.