"Duplicated indices" error when filtering by the key column

[x1o]

Filtering by the key column raises a "Duplicated indices" error. The resulting tsibble is correct since every observation is uniquely defined by the key and the index---can't really understand why the error is thrown. Should the index be somehow reset?

X <- tsibble::tsibble(
    i = rep(1:5, 2),
    k = c(rep('a', 5), rep('b', 5)),
    x = c(rnorm(5), rpois(5, 1)),
    key = k,
    index = i
)
#> Registered S3 method overwritten by 'tsibble':
#>   method               from 
#>   as_tibble.grouped_df dplyr

X
#> # A tsibble: 10 x 3 [1]
#> # Key:       k [2]
#>        i k          x
#>    <int> <chr>  <dbl>
#>  1     1 a      0.157
#>  2     2 a     -1.15 
#>  3     3 a      1.45 
#>  4     4 a      0.872
#>  5     5 a     -0.212
#>  6     1 b      2    
#>  7     2 b      2    
#>  8     3 b      4    
#>  9     4 b      0    
#> 10     5 b      0

X |> dplyr::filter(k == 'a')
#> Error in `FUN()`:
#> ! Duplicated indices: 1, 2, 3, 4, 5, 1, 2, 3, 4, 5

^{Created on 2025-05-20 with reprex v2.1.0}

Session info

sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#>  setting  value
#>  version  R version 4.4.2 (2024-10-31)
#>  os       macOS Sequoia 15.4.1
#>  system   x86_64, darwin20
#>  ui       X11
#>  language (EN)
#>  collate  en_US.UTF-8
#>  ctype    en_US.UTF-8
#>  tz       Europe/Berlin
#>  date     2025-05-20
#>  pandoc   3.6.4 @ /usr/local/bin/ (via rmarkdown)
#> 
#> ─ Packages ───────────────────────────────────────────────────────────────────
#>  package     * version  date (UTC) lib source
#>  anytime       0.3.9    2020-08-27 [1] CRAN (R 4.4.0)
#>  cli           3.6.3    2024-06-21 [1] CRAN (R 4.4.0)
#>  digest        0.6.36   2024-06-23 [1] CRAN (R 4.4.0)
#>  dplyr         1.1.4    2023-11-17 [1] CRAN (R 4.4.0)
#>  ellipsis      0.3.2    2021-04-29 [1] CRAN (R 4.4.0)
#>  evaluate      0.24.0   2024-06-10 [1] CRAN (R 4.4.0)
#>  fansi         1.0.6    2023-12-08 [1] CRAN (R 4.4.0)
#>  fastmap       1.2.0    2024-05-15 [1] CRAN (R 4.4.0)
#>  fs            1.6.4    2024-04-25 [1] CRAN (R 4.4.0)
#>  generics      0.1.3    2022-07-05 [1] CRAN (R 4.4.0)
#>  glue          1.8.0    2024-09-30 [1] CRAN (R 4.4.1)
#>  htmltools     0.5.8.1  2024-04-04 [1] CRAN (R 4.4.0)
#>  knitr         1.47     2024-05-29 [1] CRAN (R 4.4.0)
#>  lifecycle     1.0.4    2023-11-07 [1] CRAN (R 4.4.0)
#>  lubridate     1.9.3    2023-09-27 [1] CRAN (R 4.4.0)
#>  magrittr      2.0.3    2022-03-30 [1] CRAN (R 4.4.0)
#>  pillar        1.9.0    2023-03-22 [1] CRAN (R 4.4.0)
#>  pkgconfig     2.0.3    2019-09-22 [1] CRAN (R 4.4.0)
#>  R6            2.5.1    2021-08-19 [1] CRAN (R 4.4.0)
#>  Rcpp          1.0.13-1 2024-11-02 [1] CRAN (R 4.4.1)
#>  reprex        2.1.0    2024-01-11 [1] CRAN (R 4.4.0)
#>  rlang         1.1.4    2024-06-04 [1] CRAN (R 4.4.0)
#>  rmarkdown     2.27     2024-05-17 [1] CRAN (R 4.4.0)
#>  rstudioapi    0.17.1   2024-10-22 [1] CRAN (R 4.4.1)
#>  sessioninfo   1.2.2    2021-12-06 [1] CRAN (R 4.4.0)
#>  tibble        3.2.1    2023-03-20 [1] CRAN (R 4.4.0)
#>  tidyselect    1.2.1    2024-03-11 [1] CRAN (R 4.4.0)
#>  timechange    0.3.0    2024-01-18 [1] CRAN (R 4.4.0)
#>  tsibble       1.1.6    2025-01-30 [1] CRAN (R 4.4.1)
#>  utf8          1.2.4    2023-10-22 [1] CRAN (R 4.4.0)
#>  vctrs         0.6.5    2023-12-01 [1] CRAN (R 4.4.0)
#>  withr         3.0.2    2024-10-28 [1] CRAN (R 4.4.1)
#>  xfun          0.45     2024-06-16 [1] CRAN (R 4.4.0)
#>  yaml          2.3.10   2024-07-26 [1] CRAN (R 4.4.0)
#> 
#>  [1] /Users/xxx/.local/lib/R/library/4.4
#>  [2] /Library/Frameworks/R.framework/Versions/4.4-x86_64/Resources/library
#> 
#> ──────────────────────────────────────────────────────────────────────────────

[mitchelloharawild]

Thanks! This is now fixed.

The issue was that internally summarise() used i from the environment which was masked by this dataset that has the column name i. I've updated the method to explicitly use i from the environment with the .env$i pronoun.

Until the next CRAN release, I suggest that you avoid using i as a variable name in a tsibble if possible.

[x1o]

Awesome, thank you.