Rolling Mean on pandas on a specific column

by

To assign a column, you can create a rolling object based on your Series:

df['new_col'] = data['column'].rolling(5).mean()

The answer posted by ac2001 is not the most performant way of doing this. He is calculating a rolling mean on every column in the dataframe, then he is assigning the “ma” column using the “pop” column. The first method of the following is much more efficient:

%timeit df['ma'] = data['pop'].rolling(5).mean()
%timeit df['ma_2'] = data.rolling(5).mean()['pop']

1000 loops, best of 3: 497 µs per loop
100 loops, best of 3: 2.6 ms per loop

I would not recommend using the second method unless you need to store computed rolling means on all other columns.

More Related Contents:

  1. How to change column names from numbers to names [closed]
  2. How to provide a reproducible copy of your DataFrame with to_clipboard()
  3. How to replace NaNs by preceding or next values in pandas DataFrame?
  4. Find column whose name contains a specific string
  5. Calculate average of every x rows in a table and create new table
  6. Conditionally fill column values based on another columns value in pandas
  7. How to deal with multi-level column names downloaded with yfinance
  8. Pandas deleting row with df.drop doesn’t work
  9. Count number of words per row
  10. What is the fastest and most efficient way to append rows to a DataFrame?
  11. Updating a value in a pandas dataframe in an iterrows loop
  12. append dictionary to data frame
  13. Python pandas: how to remove nan and -inf values
  14. Check if rows in one dataframe exist in another dataframe
  15. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  16. Python Pandas – Lookup a variable column depending on another column’s value
  17. Confusion about pandas copy of slice of dataframe warning
  18. How to iterate over rows in a DataFrame in Pandas
  19. Difference between map, applymap and apply methods in Pandas
  20. How to replace text in a string column of a Pandas dataframe?
  21. Combine two pandas Data Frames (join on a common column)
  22. Pandas dataframe get first row of each group
  23. pandas .at versus .loc
  24. ‘DataFrame’ object has no attribute ‘sort’
  25. python pandas – creating a column which keeps a running count of consecutive values
  26. Turn Pandas Multi-Index into column
  27. Creating an empty Pandas DataFrame, and then filling it
  28. Pandas – Interleave / Zip two DataFrames by row
  29. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  30. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns

Leave a Comment