search

ropensci / rfishbase

R interface to the fishbase.org database
https://docs.ropensci.org/rfishbase
111 stars 40 forks source link

Estimate() function returning incomplete table #263

Closed bryanpgalligan closed 1 year ago

bryanpgalligan commented 1 year ago

Hi! I'm having trouble with the estimate() function. When I specify a species, the table includes a species column, but when I don't (i.e., I want the entire table), there is no species column included. This was not happening a few weeks ago. What is happening here?

estimate() gives me this (no column for species):

Screenshot 2023-03-07 at 2 25 52 PM

But when I include a species, estimate("Oreochromis niloticus") I get a species column

Screenshot 2023-03-07 at 2 28 29 PM
Session Info ```r devtools::session_info() ─ Session info ───────────────────────────────────────────────────────────────────────────────── setting value version R version 4.2.2 (2022-10-31) os macOS Ventura 13.2.1 system aarch64, darwin20 ui RStudio language (EN) collate en_US.UTF-8 ctype en_US.UTF-8 tz Africa/Nairobi date 2023-03-07 rstudio 2022.12.0+353 Elsbeth Geranium (desktop) pandoc NA ─ Packages ───────────────────────────────────────────────────────────────────────────────────── package * version date (UTC) lib source abind 1.4-5 2016-07-21 [1] CRAN (R 4.2.0) ape 5.7 2023-02-16 [1] CRAN (R 4.2.0) askpass 1.1 2019-01-13 [1] CRAN (R 4.2.0) backports 1.4.1 2021-12-13 [1] CRAN (R 4.2.0) bit 4.0.5 2022-11-15 [1] CRAN (R 4.2.0) bit64 4.0.5 2020-08-30 [1] CRAN (R 4.2.0) bold 1.2.0 2021-05-11 [1] CRAN (R 4.2.0) boot 1.3-28.1 2022-11-22 [1] CRAN (R 4.2.0) broom 1.0.3 2023-01-25 [1] CRAN (R 4.2.0) cachem 1.0.7 2023-02-24 [1] CRAN (R 4.2.0) callr 3.7.3 2022-11-02 [1] CRAN (R 4.2.0) car 3.1-1 2022-10-19 [1] CRAN (R 4.2.0) carData 3.0-5 2022-01-06 [1] CRAN (R 4.2.0) cellranger 1.1.0 2016-07-27 [1] CRAN (R 4.2.0) class 7.3-21 2023-01-23 [1] CRAN (R 4.2.0) classInt 0.4-8 2022-09-29 [1] CRAN (R 4.2.0) cli 3.6.0 2023-01-09 [1] CRAN (R 4.2.0) coda 0.19-4 2020-09-30 [1] CRAN (R 4.2.0) codetools 0.2-19 2023-02-01 [1] CRAN (R 4.2.0) colorspace 2.1-0 2023-01-23 [1] CRAN (R 4.2.0) conditionz 0.1.0 2019-04-24 [1] CRAN (R 4.2.0) contentid 0.0.16 2022-12-07 [1] CRAN (R 4.2.0) crayon 1.5.2 2022-09-29 [1] CRAN (R 4.2.0) crul 1.3 2022-09-03 [1] CRAN (R 4.2.0) curl 5.0.0 2023-01-12 [1] CRAN (R 4.2.0) data.table 1.14.8 2023-02-17 [1] CRAN (R 4.2.0) DBI 1.1.3 2022-06-18 [1] CRAN (R 4.2.0) dbplyr 2.3.1 2023-02-24 [1] CRAN (R 4.2.0) devtools 2.4.5 2022-10-11 [1] CRAN (R 4.2.0) digest 0.6.31 2022-12-11 [1] CRAN (R 4.2.0) dplyr * 1.1.0 2023-01-29 [1] CRAN (R 4.2.0) duckdb 0.7.1-1 2023-03-01 [1] CRAN (R 4.2.0) e1071 1.7-13 2023-02-01 [1] CRAN (R 4.2.0) ellipsis 0.3.2 2021-04-29 [1] CRAN (R 4.2.0) emmeans 1.8.4-1 2023-01-17 [1] CRAN (R 4.2.0) estimability 1.4.1 2022-08-05 [1] CRAN (R 4.2.0) fansi 1.0.4 2023-01-22 [1] CRAN (R 4.2.0) fastmap 1.1.1 2023-02-24 [1] CRAN (R 4.2.0) foreach 1.5.2 2022-02-02 [1] CRAN (R 4.2.0) fs 1.6.1 2023-02-06 [1] CRAN (R 4.2.0) generics 0.1.3 2022-07-05 [1] CRAN (R 4.2.0) ggeffects * 1.1.5 2023-01-25 [1] CRAN (R 4.2.0) ggplot2 * 3.4.1 2023-02-10 [1] CRAN (R 4.2.0) ggpubr * 0.6.0 2023-02-10 [1] CRAN (R 4.2.0) ggsignif 0.6.4 2022-10-13 [1] CRAN (R 4.2.0) glmmTMB * 1.1.5 2022-11-16 [1] CRAN (R 4.2.1) glue 1.6.2 2022-02-24 [1] CRAN (R 4.2.0) gtable 0.3.1 2022-09-01 [1] CRAN (R 4.2.1) hms 1.1.2 2022-08-19 [1] CRAN (R 4.2.0) htmltools 0.5.4 2022-12-07 [1] CRAN (R 4.2.0) htmlwidgets 1.6.1 2023-01-07 [1] CRAN (R 4.2.0) httpcode 0.3.0 2020-04-10 [1] CRAN (R 4.2.0) httpuv 1.6.9 2023-02-14 [1] CRAN (R 4.2.0) httr 1.4.5 2023-02-24 [1] CRAN (R 4.2.0) iterators 1.0.14 2022-02-05 [1] CRAN (R 4.2.0) jsonlite 1.8.4 2022-12-06 [1] CRAN (R 4.2.0) KernSmooth 2.23-20 2021-05-03 [1] CRAN (R 4.2.2) later 1.3.0 2021-08-18 [1] CRAN (R 4.2.0) lattice 0.20-45 2021-09-22 [1] CRAN (R 4.2.2) lifecycle 1.0.3 2022-10-07 [1] CRAN (R 4.2.0) lme4 1.1-31 2022-11-01 [1] CRAN (R 4.2.0) magrittr 2.0.3 2022-03-30 [1] CRAN (R 4.2.0) MASS 7.3-58.2 2023-01-23 [1] CRAN (R 4.2.0) Matrix 1.5-3 2022-11-11 [1] CRAN (R 4.2.0) memoise 2.0.1 2021-11-26 [1] CRAN (R 4.2.0) mime 0.12 2021-09-28 [1] CRAN (R 4.2.0) miniUI 0.1.1.1 2018-05-18 [1] CRAN (R 4.2.0) minqa 1.2.5 2022-10-19 [1] CRAN (R 4.2.0) munsell 0.5.0 2018-06-12 [1] CRAN (R 4.2.0) mvtnorm 1.1-3 2021-10-08 [1] CRAN (R 4.2.0) nlme 3.1-162 2023-01-31 [1] CRAN (R 4.2.0) nloptr 2.0.3 2022-05-26 [1] CRAN (R 4.2.0) numDeriv 2016.8-1.1 2019-06-06 [1] CRAN (R 4.2.0) openssl 2.0.5 2022-12-06 [1] CRAN (R 4.2.0) pillar 1.8.1 2022-08-19 [1] CRAN (R 4.2.0) pkgbuild 1.4.0 2022-11-27 [1] CRAN (R 4.2.1) pkgconfig 2.0.3 2019-09-22 [1] CRAN (R 4.2.0) pkgload 1.3.2 2022-11-16 [1] CRAN (R 4.2.0) plyr 1.8.8 2022-11-11 [1] CRAN (R 4.2.0) prettyunits 1.1.1 2020-01-24 [1] CRAN (R 4.2.0) processx 3.8.0 2022-10-26 [1] CRAN (R 4.2.0) profvis 0.3.7 2020-11-02 [1] CRAN (R 4.2.0) progress 1.2.2 2019-05-16 [1] CRAN (R 4.2.0) promises 1.2.0.1 2021-02-11 [1] CRAN (R 4.2.0) proxy 0.4-27 2022-06-09 [1] CRAN (R 4.2.0) ps 1.7.2 2022-10-26 [1] CRAN (R 4.2.0) purrr 1.0.1 2023-01-10 [1] CRAN (R 4.2.0) R6 2.5.1 2021-08-19 [1] CRAN (R 4.2.0) Rcpp 1.0.10 2023-01-22 [1] CRAN (R 4.2.0) readr * 2.1.4 2023-02-10 [1] CRAN (R 4.2.0) readxl * 1.4.2 2023-02-09 [1] CRAN (R 4.2.0) remotes 2.4.2 2021-11-30 [1] CRAN (R 4.2.0) reshape 0.8.9 2022-04-12 [1] CRAN (R 4.2.0) rfishbase * 4.1.1 2023-03-07 [1] Github (ropensci/rfishbase@bb74ae4) rlang 1.0.6 2022-09-24 [1] CRAN (R 4.2.0) rnaturalearth * 0.3.2 2023-01-23 [1] CRAN (R 4.2.0) rnaturalearthdata * 0.1.0 2017-02-21 [1] CRAN (R 4.2.0) rstatix 0.7.2 2023-02-01 [1] CRAN (R 4.2.0) rstudioapi 0.14 2022-08-22 [1] CRAN (R 4.2.0) scales * 1.2.1 2022-08-20 [1] CRAN (R 4.2.0) sessioninfo 1.2.2 2021-12-06 [1] CRAN (R 4.2.0) sf * 1.0-9 2022-11-08 [1] CRAN (R 4.2.0) shiny 1.7.4 2022-12-15 [1] CRAN (R 4.2.1) sp 1.6-0 2023-01-19 [1] CRAN (R 4.2.0) stringdist * 0.9.10 2022-11-07 [1] CRAN (R 4.2.0) stringi 1.7.12 2023-01-11 [1] CRAN (R 4.2.0) stringr * 1.5.0 2022-12-02 [1] CRAN (R 4.2.0) taxize * 0.9.100 2022-04-22 [1] CRAN (R 4.2.0) tibble 3.1.8 2022-07-22 [1] CRAN (R 4.2.0) tidyr * 1.3.0 2023-01-24 [1] CRAN (R 4.2.0) tidyselect 1.2.0 2022-10-10 [1] CRAN (R 4.2.0) TMB 1.9.2 2023-01-23 [1] CRAN (R 4.2.0) tzdb 0.3.0 2022-03-28 [1] CRAN (R 4.2.0) units 0.8-1 2022-12-10 [1] CRAN (R 4.2.0) urlchecker 1.0.1 2021-11-30 [1] CRAN (R 4.2.0) usethis 2.1.6 2022-05-25 [1] CRAN (R 4.2.0) utf8 1.2.3 2023-01-31 [1] CRAN (R 4.2.0) uuid 1.1-0 2022-04-19 [1] CRAN (R 4.2.0) vctrs 0.5.2 2023-01-23 [1] CRAN (R 4.2.0) vroom 1.6.1 2023-01-22 [1] CRAN (R 4.2.0) withr 2.5.0 2022-03-03 [1] CRAN (R 4.2.0) worrms * 0.4.2 2020-07-08 [1] CRAN (R 4.2.0) xml2 1.3.3 2021-11-30 [1] CRAN (R 4.2.0) xtable 1.8-4 2019-04-21 [1] CRAN (R 4.2.0) zoo 1.8-11 2022-09-17 [1] CRAN (R 4.2.0) [1] /Library/Frameworks/R.framework/Versions/4.2-arm64/Resources/library ```
cboettig commented 1 year ago

SpecCode specifies the species in question, so simply join it to the species table:

library(dplyr)
library(rfishbase)

left_join(estimate(), species(), by="SpecCode")

and select() the columns of interest

bryanpgalligan commented 1 year ago

Thank you!