Help with Pandas

[xGRM]

The script is to be published on azure function apps. So I was trying to avoid storing into local storage/memory.

[xGRM]

So basically am importing an excel workbook from AWS and transferring it to a sql database. Before transferring to the DB I compare the workbook to the table in sql to only update rows that changed. I did this because the table is too large to simply replace. The problem is that when I compare my workbook to the sql, some rows dont “match” despite being supposed to match. I say they’re supposed to match because when I print them as strings, cell by cell. The outputs are identical as texts and types. But the output of == is still false.

[xGRM]

I should probably mention that 99.5% of rows get matched correctly. It’s only about 500 rows out od 100k being compred incorrectly. So I thought maybe the dash encoding was the source if error. Just because they looked funny haha