Format / Suppress Scientific Notation from Pandas Aggregation Results

by

Granted, the answer I linked in the comments is not very helpful. You can specify your own string converter like so.

In [25]: pd.set_option('display.float_format', lambda x: '%.3f' % x)

In [28]: Series(np.random.randn(3))*1000000000
Out[28]: 
0    -757322420.605
1   -1436160588.997
2   -1235116117.064
dtype: float64

I’m not sure if that’s the preferred way to do this, but it works.

Converting numbers to strings purely for aesthetic purposes seems like a bad idea, but if you have a good reason, this is one way:

In [6]: Series(np.random.randn(3)).apply(lambda x: '%.3f' % x)
Out[6]: 
0     0.026
1    -0.482
2    -0.694
dtype: object

More Related Contents:

  1. Display a decimal in scientific notation
  2. Convert floats to ints in Pandas?
  3. Pandas read csv file with float values results in weird rounding and decimal digits
  4. Convert float to string in positional format (without scientific notation and false precision)
  5. Comparing floats in a pandas column
  6. Suppress Scientific Notation in Numpy When Creating Array From Nested List
  7. Format a number with commas to separate thousands
  8. Can you format pandas integers for display, like `pd.options.display.float_format` for floats?
  9. mean from pandas and numpy differ
  10. Pandas: Adding new column to dataframe which is a copy of the index column
  11. Change one value based on another value in pandas
  12. Sorting columns in pandas dataframe based on column name [duplicate]
  13. Pandas ‘count(distinct)’ equivalent
  14. What is the performance impact of non-unique indexes in pandas?
  15. What is the difference between using loc and using just square brackets to filter for columns in Pandas/Python?
  16. Pandas: Cast column to string does not work
  17. Python – splitting dataframe into multiple dataframes based on column values and naming them with those values [duplicate]
  18. Add multiple empty columns to pandas DataFrame
  19. No numeric types to aggregate – change in groupby() behaviour?
  20. OSError: Initializing from file failed on csv in Pandas
  21. Line plot with data points in pandas
  22. Python & Pandas: How to query if a list-type column contains something?
  23. Remove Unnamed columns in pandas dataframe [duplicate]
  24. Datetime conversion – How to extract the inferred format?
  25. Python numpy: cannot convert datetime64[ns] to datetime64[D] (to use with Numba)
  26. Slicing multiple ranges of columns in Pandas, by list of names
  27. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  28. Merging two tables with millions of rows in Python
  29. Selecting a range of columns in a dataframe
  30. Pandas data frame to dictionary of lists

Leave a Comment