I have an excel sheet with Buying amount and selling amount. When I read this data in python using pd.read_excel("file.xlsx") buying amount column is displayed in scientific notation. How to change it to the format which is displayed in selling amount column or as it is read from excel and display as it is there in excel
pd.read_excel("file.xlsx")
Expected: Name Buying amount Selling amount ABC 3424663 12200000.00
Actual: Name Buying amount Selling amount ABC 3.424663e+06 12200000.00
Datatype for both Buying amount and selling amount float64