Moving average in Pandas

Question

I have a csv file with 3 columns and I want to get the moving average of 1 column. I want to create a new column with the moving average.

import pandas as pd

df= pd.read_csv('csv',usecols=['speed','col2', 'col3'])
df['MA'] = df.rolling( window=5, on='speed').mean
print(df)

It doesnt show me any column anymore. Only the Index and ... .

1   ...
2   ...
3   ...
3   ...
4   ...

[4 rows x 4 columns]

If I change to:

df= df.rolling(window=5, on='speed').mean
print(df)

It only returns me this:

<bound method Rolling.mean of Rolling [window=5,center=False,axis=0,on=speed]>

Process finished with exit code 0

Missing `()` like `df['MA'] = df.rolling( window=5, on='speed').mean()` — jezrael, Jul 02 '18 at 13:31
I get an error now: ValueError: Wrong number of items passed 2, placement implies 1 — Michelle, Jul 02 '18 at 13:43
It depends on the used columns. If I cahnge usecols to 'speed' only it works fine. — Michelle, Jul 02 '18 at 13:49

score 6 · Answer 1 · answered Jul 03 '18 at 09:40

6

Posting one more way.

     df['MA'] = df['speed'].rolling(window=5).mean()

answered Jul 03 '18 at 09:40

Sreekiran A R

1 Answers1