Pandas excel import truncating long string

Question

I have an excel file with the below cell content

\\pathxx01\xxx project\71 XXXX XXXXXXX Team\Landlord Billing/

However, when importing the excel into a pandas dataframe with pd.read_excel method, the string is truncated to

\\pathxx01\xxx project\71 XXXX XXXXXXX Team\Lan...

Is there any way to avoid this truncation and keep the original string?

Answer 1

As determined from the comments, it's not actually being truncated. Pandas is just displaying it truncated because there is little screenspace where you're displaying it.

You can use this to force Pandas to display the full columns without truncating them:

pd.set_option('display.max_colwidth', None)