Python Forum

Hi

The code is:

import pandas as pd
import quandl
import math

df = quandl.get('FINRA/FORF_TLLTD')

df['PCT']= df['ShortVolume']/df['TotalVolume']*100
df = df[['ShortVolume','TotalVolume', 'PCT']]
forecast_col = 'ShortVolume'
df.fillna(-99999, inplace= True)
forecast_out = int(math.ceil(0.01*len(df)))
df['label'] = df[forecast_col].shift[-forecast_out]
df.dropna(inplace=True)
print(df.head())

And the error i am getting is

Error:
Traceback (most recent call last):
  File "C:/Program Files/PycharmProjects/code examples/code practice.py", line 28, in <module>
    df['label'] = df[forecast_col].shift[-forecast_out]
TypeError: 'method' object is not subscriptable

---

Solved

i use [] instead () here .shift[-forecast_out]

Hi, thanks for sharing the solution you found!