Convert Scientific Numbers to Numeric Values in Pandas

When you import Pandas Dataframe from a CSV file, it often displays values in scientific notation. This can be tricky to read at times.

Following two simple lines of code, you can convert the scientific numbers to numeric values.

pd.options.display.float_format = “{:,.5f}”.format
df = df.astype(float)

You can determine the number of decimal points you would like to see in the first line. Using the first line of code, you should be able to see five decimal points.