我有一个数据框,第一行由货币名称组成,第二行由日期组成,渴望行由这些日期的历史价格组成。
如何将其转换为时间序列对象,该对象的列由不同的货币组成,行由这些日期的历史价格组成?问题是,在某些日子里,soem货币没有价格……我如何用NAs填充它们并自动将它们对齐?
发布于 2018-08-30 04:58:05
假设数据框名为crypto.market s.post.2108,收盘价为"symbol“、"dates”和"close“。
然后我会这样做:
# Creates matrix whose columns are different crypto-currencies and whose rows are different times
#---------------------------------------------------------------------------------------------------#
# N Columns
Col.coins<-unique(crypto.markets.post.2018$symbol);N.coins<-length(Col.coins) # Counts the number of coins in recent history
# N Rows
Row.coins<-seq(from=min(dates),to=max(dates),by=1);N.Rows<-length(Row.coins)
# Initialize Matrix
historical.max.min<-historical.volum<-historical.prices<-matrix(NA,nrow = N.Rows,ncol=N.coins); rownames(historical.prices)<-Row.coins; colnames(historical.prices)<-Col.coins
# Writes data-frame of closing prices
for(j.coin in 1:N.coins){
time.series.iteration<-crypto.markets.post.2018$symbol == Col.coins[j.coin]#Loads timeseries of this iteration
time.series.iteration<-crypto.markets.post.2018[time.series.iteration,]
N.NAs.needed.for.corecsion<-N.Rows-length(as.Date(time.series.iteration$date)) # Determines the difference between the data-size and the matrix's dimensions (for incomplete time-series only :D)
# Historical Prices
historical.prices[,j.coin]<-append(rep(NA,N.NAs.needed.for.corecsion),time.series.iteration$close) # Tags on the ts length
# Historical Volum
historical.volum[,j.coin]<-append(rep(NA,N.NAs.needed.for.corecsion),time.series.iteration$volume) # Tags on the ts length
# Difference between max and min
historical.max.min[,j.coin]<-append(rep(NA,N.NAs.needed.for.corecsion),((time.series.iteration$high)-(time.series.iteration$low))
) # Tags on the ts length
}
https://stackoverflow.com/questions/52085697
复制相似问题