Issues with groupby



有人知道为什么我一直没有定义Growby吗?[错误消息][1][1] :https://i.stack.imgur.com/cLmGl.png

rename!(df_🔥,Symbol("climate change") => :🔥)
rename!(df_🔥,:Month => :date)
df_🔥[!,:Δ🔥] = [missing;log.(df_🔥.🔥[2:end]) - log.(df_🔥.🔥[1:end-1])]
df_🔥 = df_🔥[completecases(df_🔥),:]
first(df_🔥,6)
df_sp[!,:r] = [missing;df_sp[2:end,:closeadj]./df_sp[1:end-1,:closeadj].-1]
firstobs = [true;df_sp.ticker[2:end] .!= df_sp.ticker[1:end-1]]
df_sp = df_sp[.!firstobs,:]
df_sp = df_sp[completecases(df_sp),:]
df_m[!,:rₘ] = [missing;df_m[2:end,:closeadj]./df_m[1:end-1,:closeadj].-1]
df_m = df_m[completecases(df_m),:]
df_sp = leftjoin(df_sp,df_m[:,[:date,:rₘ]];on=:date)
df_sp = leftjoin(df_sp,df_🔥[:,[:date,:Δ🔥]];on=:date)
first(df_sp,6)
gdat = grouby(df_sp,:ticker)

这是一个简单的打字错误-您需要groupby,而不是grouby(注意p(

此外,您还可以使用ShiftedArrays软件包将日志返回计算为

log.(df.close) .- lag(log.(df.close))

您也可以在groupby调用中这样做,这样您就不必手动识别每个安全性的第一个观察。

最新更新