I am reading an excel file which contains the following formats in the Price column for example.

1. £35.00
2. US$85.60
3. CAN$109.10

When I am reading the file using pd.read_excel, it changes the prices to digits like 35.00, 85.60 and 109.10. I am not doing any calculation with this column but I need to see different formats next to the Products itself.

I have tried using pd.read_excel(file_path, dtype = {‘Price’ : str} or even pd.read_excel(file_path, dtype = {‘Price’ : object}.

I have also tried changing the type of the column in dataframe as well but no use.

I am combining multiple files in a pandas dataframe with the same format so I don’t need to change anything in this Price column. The files are in xls format.