I was following a tutorial from this guy and I was writing the exact same code to VS code except that Quandl is not written in uppercase anymore. I will leave a ss of the code here for who don't want to watch video. reference code
https://www.youtube.com/watch?v=lN5jesocJjk&list=PLQVvvaa0QuDfKTOs3Keq_kaG2P55YRn5v&index=3
Here is the code I wrote -exact copy of the code above but it does not work idk why:
import pandas as pd
import quandl
import math
#quandl.ApiConfig.api_key = "it is not necessary in the video but I have API key here because I signed in to Quandl site"
df = quandl.get('WIKI/GOOGL')
df = df[['Adj. Open','Adj. High','Adj. Low','Adj. Close', 'Adj. Volume']]
df["HL_PCT"] = (df["Adj. High"] - df["Adj. Close"]) / df["Adj. Close"] * 100.0
df["PCT_change"] = (df["Adj. Close"] - df["Adj. Open"]) / df["Adj. Open"] * 100.0
df = df[['Adj. Close','HL_PCT','PCT_change','Adj. Volume']]
forecast_col = 'Adj. Close'
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.tail())
Here is the terminal when I tried to run : terminal
ps : Code was working without any problem until I added forecast_out line, so API line does not effect the code.