How to align a string by maximum value in Pandas?

Question

Python

Good afternoon. Colleagues, please tell me how to align a string by the maximum content value in Pandas.DataFrame? There are 2 excel files. I compare them in a certain way, remove duplicates and so on. At the moment, everything seems to be done, the script works. The data is in a DataFrame which I save using the .to_exel method to an Excel file. But the final conclusion is not at all encouraging. The generated file is "worse than nuclear war" (Auto.xlsx). I tried to experiment with pd.set_option and pd.option_context, but as I understand it, they only affect the output of data from the monitor directly to the IDE. How to make the alignment of the column according to the maximum content of the cell automatically. And also color the lines according to the condition? How to eat Auto.png and how I want it to turn out Auto (Ideal).png
Link to files " https://drive.google.com/open?id=1cgtsq1itii3xwYRh... ">