pct_change for column value

Question

Using Pandas documentation

http://pandas.pydata.org/pandas-docs/version/0.13.1/generated/pandas.DataFrame.pct_change.html

I am trying to create this function to calculate percentage_change . I pass two paramters to it

 def PCT(df,n):
        d = df['Close'].pct_change(n)

Even rewriting the same code in different way give me same error

 P = pd.Series(df['Close'].pct_change(n), name = 'PCT_' + str(n))

dataframe
window over which I want % change

It throwing error

  File "D:\Python Scripts\TA_Liabrary.py", line 15, in PCT
    d = df['Close'].pct_change(n)
TypeError: 'NoneType' object has no attribute '__getitem__'

Can someone please help me in this

Sample data

Index   open    high    low close   volume  adj.
1/01/2014   54.97   54.97   54.97   54.97   0   49.31993
2/01/2014   55.1    55.95   54.86   55.08   216100  49.41862
3/01/2014   54.5    55  54.16   55  392600  49.34685
6/01/2014   54.82   55.47   54.62   55.14   344500  49.47245
7/01/2014   55.06   55.17   54.27   54.35   677400  48.76365
8/01/2014   54.64   54.88   53.87   54.38   587500  48.79057
9/01/2014   54.57   54.8    54.05   54.48   466800  48.88029

user_10419999 · Answer

Apply pct_change to single/multiple column(s), in a data frame can be done as below

df = pd.DataFrame({
    'open': [54.97,55.1,54.5,54.82],
    'high': [54.97,55.95,55,55.47],
    'low': [54.97,54.86,54.16,54.62],
    'close': [54.97,53.08,55,55.14]},
    index=['2014-01-01', '2014-02-01', '2014-03-01','2014-04-01'])

            open    high    low     close
2014-01-01  54.97   54.97   54.97   54.97
2014-02-01  55.10   55.95   54.86   53.08
2014-03-01  54.50   55.00   54.16   55.00
2014-04-01  54.82   55.47   54.62   55.14

apply pct_change to a single column (close)

df.close = df.close.pct_change(periods = 1)

            open    high    low     close
2014-01-01  54.97   54.97   54.97   NaN
2014-02-01  55.10   55.95   54.86   -0.034382
2014-03-01  54.50   55.00   54.16   0.036172
2014-04-01  54.82   55.47   54.62   0.002545

applying to multiple columns as below

# apply pct_change to 'open' and 'close'
df[['open','close']] = df[['open','close']].pct_change(periods = 1)

            open        high    low     close
2014-01-01  NaN         54.97   54.97   NaN
2014-02-01  0.002365    55.95   54.86   -0.034382
2014-03-01  -0.010889   55.00   54.16   0.036172
2014-04-01  0.005872    55.47   54.62   0.002545

pct_change for column value

2 Answers