I am comparing 2 excel files one of them is a basic table and one is a complex one , and i want to convert it into a table with name of the columns in the headers (the file is not static each time i compare files from specific folders )
Here is an example of the file i want to convertexcel file
i tried doing it with pandas but it doesn’t read properly all the rows
New contributor
Yessin Toumi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1