-
I'm comparing a column of arrays called 'fingerprint,' which consists of binary arrays with a size of 30 elements each. The objective is to determine the number of matching elements between two arrays. Example 1: Example 2: Example 3 |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 3 replies
-
The function does not output the size of the intersection, it places the size of the intersection in user specified bins. Take a look at the human_readable_description or the docstring of the comparison level |
Beta Was this translation helpful? Give feedback.
Ah, I understand. Sorry am on my phone. So in your arrays position matters? The function is really designed for the case of an unordered 'bag of things ' like zip codes. I think you'd have to write a custom SQL comparison level to get the behaviour you want (or split the array into individual columns)