R中的错误：分配的数据必须与现有数据兼容

Question

数据表。

dt <- data.table(currency = c("EUR","EUR","EUR","USD","USD","USD", "RON","RON","RON","RON","RON","EUR","EUR","USD","USD","USD", "RON","RON","RON","RON","RON"), date = c("2019-02-25","2019-02-25","2019-02-25","2019-02-25","2019-02-25","2019-02-25", "2019-02-25","2019-02-25","2019-02-25","2019-02-25","2019-02-25","2019-03-01","2019-03-01","2019-03-01","2019-03-01","2019-03-01", "2019-03-01","2019-03-01","2019-03-01","2019-03-01","2019-03-01"), y = c("0,1","0,2","0,2","0,1","0,1","0,15","0,1","0,2","0,3","0,1","0,1","0,15","0,1","0,1","0,25","0,3","0,1","0,1","0,15","0,1","0,2")
dt

有一个

dt <- dt|>
  group_by(currency, date)  |>
  mutate(N = row_number())  |>
  ungroup()  |>
  complete(currency, date, N) |>
  arrange(date, currency, N)
dt

我 值。为此，我使用了代码：

#a table with selected columns
m <- dt[,c("currency","date","N","y")]

#add column x to the table
m$x <- na.approx(m$y)

然后我会遇到一个错误：

Error: Assigned data `na.approx(zero_rates_hist$zero_rate)` must be compatible with existing data.
x Existing data has 1654800 rows.
x Assigned data has 1654653 rows.
ℹ Only vectors of size 1 are recycled.

请帮助我！谢谢。

Answer 1

我决定用以下一个替换代码替换代码，现在一切都起作用了！

#add column x to the table
m <- m %>%
  mutate(x = na.approx(y, na.rm="FALSE"))