Any tips to how to find out values?

[nevlindan]

Hello 😊

I am super new to python and can’t get around the below topic. Hope this is not a stupid question…

Would anybody have a tip how to do that? Or what to do? Attached please see the table.

Many thanks!

[deanhystad]

Is the screenshot showing desired output? If so, I don't know how to produce those results. "Column comparison, contents equal" is meaningless to me. Looking at the example table it looks like you scan through values left->right, top->bottom and if you run into a value you've seen before it is a match. Is that correct? What if there are multiple matches in a row? Do you report them all, or just the first?

Using the match described above I was able to make this table.

Output:
       Method 1  Method 2  Method 3  Method 4  Method 5  Method 6  Content Match  Content Value
80632       NaN       NaN       1.9       2.8       NaN       1.8          False            NaN
81393       NaN       NaN       NaN       1.9       NaN       NaN           True            1.9
86725       NaN       NaN       1.8       NaN       NaN       NaN           True            1.8
88149       NaN       NaN       NaN       NaN       1.4       1.5          False            NaN
90487       NaN       1.7       NaN       1.7       NaN       NaN           True            1.7
91193       NaN       NaN       NaN       NaN       NaN       NaN          False            NaN
91194       NaN       NaN       NaN       NaN       NaN       NaN          False            NaN
91230       NaN       NaN       NaN       1.9       NaN       NaN           True            1.9

What have you tried so far?