round a single column in pandas

by

You are very close.
You applied the round to the series of values given by df.value1.
The return type is thus a Series.
You need to assign that series back to the dataframe (or another dataframe with the same Index).

Also, there is a pandas.Series.round method which is basically a short hand for pandas.Series.apply(np.round).

>>> df.value1 = df.value1.round()
>>> print df
  item  value1  value2
0    a       1     1.3
1    a       2     2.5
2    a       0     0.0
3    b       3    -1.0
4    b       5    -1.0

More Related Contents:

  1. Apply multiple functions to multiple groupby columns
  2. Pandas percentage of total with groupby
  3. Scatter plots in Pandas/Pyplot: How to plot by category [duplicate]
  4. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  5. How to add pandas data to an existing csv file?
  6. How to explode a list inside a Dataframe cell into separate rows
  7. How do I operate on a DataFrame with a Series for every column?
  8. Improve subplot size/spacing with many subplots in matplotlib
  9. Pandas split column into multiple columns by comma
  10. Repeat rows in a pandas DataFrame based on column value
  11. Accessing every 1st element of Pandas DataFrame column containing lists
  12. How to use groupby to concatenate strings in python pandas?
  13. Horizontal stacked bar plot and add labels to each section
  14. How to flatten a nested JSON recursively, with flatten_json
  15. Python – How to convert JSON File to Dataframe
  16. How to invoke pandas.rolling.apply with parameters from multiple column?
  17. How to remove timezone from a Timestamp column in a pandas dataframe
  18. Pandas lookup from one of multiple columns, based on value
  19. How to add a suffix (or prefix) to each column name?
  20. dropping rows from dataframe based on a “not in” condition [duplicate]
  21. How to delete multiple pandas (python) dataframes from memory to save RAM?
  22. Adding two Series with NaNs
  23. Resampling Within a Pandas MultiIndex
  24. Find date range overlap in python
  25. How do I delete a column that contains only zeros in Pandas?
  26. Normalize DataFrame by group
  27. Color a scatter plot by Column Values
  28. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  29. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  30. Pandas: Selecting rows based on value counts of a particular column

Leave a Comment