How to remove decimal points in pandas

by

You have a few options…

1) convert everything to integers.

df.astype(int)
          <=35  >35
Cut-off            
Calcium      0    1
Copper       1    0
Helium       0    8
Hydrogen     0    1

2) Use round:

>>> df.round()
          <=35  >35
Cut-off            
Calcium      0    1
Copper       1    0
Helium       0    8
Hydrogen     0    1

but not always great…

>>> (df - .2).round()
          <=35  >35
Cut-off            
Calcium     -0    1
Copper       1   -0
Helium      -0    8
Hydrogen    -0    1

3) Change your display precision option in Pandas.

pd.set_option('precision', 0)

>>> df
          <=35  >35
Cut-off            
Calcium      0    1
Copper       1    0
Helium       0    8
Hydrogen     0    1

More Related Contents:

  1. How to iterate over rows in a DataFrame in Pandas
  2. Selecting with complex criteria from pandas.DataFrame
  3. Combine two pandas Data Frames (join on a common column)
  4. Restart cumsum and get index if cumsum more than value
  5. Remove non-numeric rows in one column with pandas
  6. How to deal with multi-level column names downloaded with yfinance
  7. Replace all occurrences of a string in a pandas dataframe (Python)
  8. Running get_dummies on several DataFrame columns?
  9. ValueError: numpy.dtype has the wrong size, try recompiling
  10. Get business days between start and end date using pandas
  11. How to change the datetime tick label frequency for matplotlib plots
  12. Pandas DataFrame aggregate function using multiple columns
  13. Pandas get the most frequent values of a column
  14. Subtract two columns in dataframe
  15. Python Pandas: Is Order Preserved When Using groupby() and agg()?
  16. Pass percentiles to pandas agg function
  17. How to calculate time difference by group using pandas?
  18. Capitalize first letter of each word in a dataframe column
  19. Compute the running (cumulative) maximum for a series in pandas
  20. Get total of Pandas column
  21. Sorting columns and selecting top n rows in each group pandas dataframe
  22. Python Pandas replace NaN in one column with value from corresponding row of second column
  23. how to concat two data frames with different column names in pandas? – python
  24. Pandas – Interleave / Zip two DataFrames by row
  25. Python Pandas – Read csv file containing multiple tables
  26. Changing certain values in multiple columns of a pandas DataFrame at once
  27. Round float columns in pandas dataframe
  28. Converting PANDAS dataframe from monthly to daily
  29. Pandas datetimes with different formats in the same column
  30. Get max value from row of a dataframe in python [duplicate]

Leave a Comment