How to round/remove trailing “.0” zeros in pandas column?

by

use astype(np.int64)

s = pd.Series(['', 8.00735e+09, 4.35789e+09, 6.10644e+09])
mask = pd.to_numeric(s).notnull()
s.loc[mask] = s.loc[mask].astype(np.int64)
s

0              
1    8007350000
2    4357890000
3    6106440000
dtype: object

More Related Contents:

  1. Clustered Stacked Bar in Python Pandas [closed]
  2. Python Pandas – Find difference between two data frames
  3. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  4. Rename Pandas DataFrame Index
  5. Pandas groupby cumulative sum
  6. Pandas DataFrame concat vs append
  7. Convert row to column header for Pandas DataFrame,
  8. What is the most efficient way of counting occurrences in pandas?
  9. Pandas read csv file with float values results in weird rounding and decimal digits
  10. pandas – filter dataframe by another dataframe by row elements
  11. Left justify string values in a pandas DataFrame
  12. Python Pandas: How to read only first n rows of CSV files in?
  13. Pandas – replacing column values
  14. Override global variable inside function not working with Spyder 4
  15. join or merge with overwrite in pandas
  16. Pandas get the age from a date (example: date of birth)
  17. How to create a grouped bar plot
  18. Sample each group after pandas groupby
  19. Python Pandas – Missing required dependencies [‘numpy’] 1
  20. Pandas Data Frame how to merge columns
  21. matplotlib plot window won’t appear
  22. How to display percentage above grouped bar chart
  23. How to remove rows in a Pandas dataframe if the same row exists in another dataframe?
  24. applying regex to a pandas dataframe
  25. Converting OHLC stock data into a different timeframe with python and pandas
  26. In pandas, can I deeply copy a DataFrame including its index and column?
  27. Intersection of two pandas dataframes based on column entries
  28. Python Pandas – Lookup a variable column depending on another column’s value
  29. Pandas rename index
  30. Pandas date_range to generate monthly data at beginning of the month

Leave a Comment