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!
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?