Logo by Elisa Sovrano

depigner 0.9.0

depigner 0.9.0

I’m very excited to announce the new release of {depigner} (Lanera 2022) to CRAN, now in the version 0.9.0.

Pigna [pìn’n’a] is the Italian word for pine cone. In jargon, it is used to identify a task which is boring, banal, annoying, painful, frustrating and maybe even with a not so beautiful or rewarding result, just like the obstinate act of trying to challenge yourself in extracting pine nuts from a pine cone, provided that, in the end, you will find at least one inside it.

The {depigner} aims to provide some useful functions to be used to solve small everyday problems of coding or analyzing data with R. The hope is to provide solutions to that kind of small-little problems which would be normally solved using quick-and-dirty (ugly and maybe even wrong) patches.


You can install the released version from CRAN directly calling:


If you would like to be updated with the last development version available, you can install it from it’s source on GitHub by calling:

# install.packages("remotes")

Next, you can attach it to your session as usual by:

## Welcome to depigner: we are here to un-stress you!

Provided Tools

For all the provided tools you can look at the {depigner} website, or at the previous posts here-v0.8.1, here-v0.8.3, and here-v0.8.3.

News from the previous version


  • Added a view_in_excel() new function to view/open a data frame in MS Excel even in the middle of a pipe chain, and without disturbing the execution of the chain itself. This could be critically useful if you would like to inspect intermediate results. E.g.

res <- mtcars |> 
  select(mpg, cyl) |> 
  view_in_excel() |> # this will open an Excel with the current state
  mutate(foo = paste(mpg, cyl)) |> 
  view_in_excel() # this will open (another) Excel with the final state

res # final result is returned as well

Note: view_in_excel() avoids unwanted execution (interactive session only), embed the correct extension in the temporary file, add BOM for Excel pleasure, and return the output invisibly, in case it is the last element of the chain.

  • Now the documentation for tidy_summary explicitly stated that the output is supposed to be used as input to pander

  • Added {progress}, {readxl}, and {writexl} to pkg_utils; {ggpubr} to pkg_docs; {ggeffects}, and {dlnm} to pkg_stat; {tarchetypes}, and {checkmate}, removing {fs} (included in {tarchetypes}), from pkg_devel. (Thanks @Eligallo)

Bug fixes.

  • Now all the links inside the README are working.


  • updated Roxygen Note for documentation settings to 7.2.0

So, some minor improvements, updates, and bug fixes, and a brend new function I am really looking forward to have feedback about it!


The view_in_excel() function was originated during the conversation on Twitter started here by @brodriguesco

The {depigner}’s logo was lovely designed by Elisa Sovrano.


Lanera, Corrado. 2022. Depigner: A Utility Package to Help You Deal with "Pignas".
Corrado Lanera
Research Fellow (RTD-A), data scientist, and trainer


comments powered by Disqus