Round float columns in pandas dataframe

by

You can now, use round on dataframe

Option 1

In [661]: df.round({'Y': 2, 'X': 2})
Out[661]:
       Y     X  id WP_NER
0  35.97 -2.73   1  WP_01
1  35.59 -2.90   2  WP_02
2  35.33 -3.39   3  WP_03
3  35.39 -3.93   4  WP_04
4  35.58 -3.94   5  WP_05
5  35.52 -3.41   6  WP_06
6  35.76 -3.08   7  WP_07

Option 2

In [662]: cols = ['Y', 'X']

In [663]: df[cols] = df[cols].round(2)

In [664]: df
Out[664]:
       Y     X  id WP_NER
0  35.97 -2.73   1  WP_01
1  35.59 -2.90   2  WP_02
2  35.33 -3.39   3  WP_03
3  35.39 -3.93   4  WP_04
4  35.58 -3.94   5  WP_05
5  35.52 -3.41   6  WP_06
6  35.76 -3.08   7  WP_07

More Related Contents:

  1. Extract the data and modify an existing excel with openpyxl
  2. How to drop rows of Pandas DataFrame whose value in a certain column is NaN
  3. How can I filter lines on load in Pandas read_csv function?
  4. Reconstruct a categorical variable from dummies in pandas
  5. Pandas Groupby Range of Values
  6. Drop rows containing empty cells from a pandas DataFrame
  7. Remove duplicate rows from Pandas dataframe where only some columns have the same value
  8. Pandas selecting by label sometimes return Series, sometimes returns DataFrame
  9. Rename result columns from Pandas aggregation (“FutureWarning: using a dict with renaming is deprecated”)
  10. How to switch columns rows in a pandas dataframe
  11. Quickest way to make a get_dummies type dataframe from a column with a multiple of strings
  12. Pandas: resample timeseries with groupby
  13. Pandas groupby.size vs series.value_counts vs collections.Counter with multiple series
  14. Using numpy.genfromtxt to read a csv file with strings containing commas
  15. Plot correlation matrix using pandas
  16. Insert a Pandas Dataframe into mongodb using PyMongo
  17. Pandas unstack problems: ValueError: Index contains duplicate entries, cannot reshape
  18. Copy pandas dataframe to excel using openpyxl
  19. pandas – find first occurrence
  20. Create new dataframe in pandas with dynamic names also add new column
  21. How to convert a dataframe to a dictionary
  22. Read CSV into a dataFrame with varying row lengths using Pandas
  23. Filling missing values using forward and backward fill in pandas dataframe (ffill and bfill)
  24. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  25. Vectorizing or Speeding up Fuzzywuzzy String Matching on PANDAS Column
  26. Count occurrences of items in Series in each row of a DataFrame
  27. Efficiently select rows that match one of several values in Pandas DataFrame [duplicate]
  28. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  29. how to parallelize many (fuzzy) string comparisons using apply in Pandas?
  30. How to convert DataFrame.append() to pandas.concat()?

Leave a Comment