python - Compare multiple columns of excel with one column having different length and index

Question

how do I compare the excel using python pandas?

For eg.

  A    B    C  D  E  F
1     3,4   
2     1,2
3     4,4
4     5,5
5
6     TBC1  TBC2  TBC3
7     1, 4  3,4   2, 1
8     1,1   1, 3  1, 2
9     3,1   4,4   4,2
10    2,4   5,5   5,1
11   
12    TBC4  TBC5  TBC6
13    1, 4  3,4   3, 4
14    1,1   1, 2  1, 2
15    1, 3  3,2   4,4
16    2,3   1, 4  5,5
17

TBC- To be compare

How do i compare B1-4 to eat set for eg B7 to B10

Please advise

question from:https://stackoverflow.com/questions/65914350/compare-multiple-columns-of-excel-with-one-column-having-different-length-and-in

Answer 1

Waitting for answers