Mid terms are November 3rd 2026. Go register voters.
@usrbinr.bsky.social
oh the winner here went above and beyond -- tons of goodies using httr2(), gt() and other tools
github.com/rich-iannone...
github.com/rich-iannone...
November 11, 2025 at 1:26 PM
oh the winner here went above and beyond -- tons of goodies using httr2(), gt() and other tools
github.com/rich-iannone...
github.com/rich-iannone...
janitor's greatest function that is irreplaceable when you really need it.
convert excel date formats into date formats with excel_numeric_to_date()
#rstats
sfirke.github.io/janitor/refe...
convert excel date formats into date formats with excel_numeric_to_date()
#rstats
sfirke.github.io/janitor/refe...
Convert dates encoded as serial numbers to Date class. — excel_numeric_to_date
Converts numbers like 42370 into date values like 2016-01-01.
Defaults to the modern Excel date encoding system. However, Excel for Mac
2008 and earlier Mac versions of Excel used a different date sys...
sfirke.github.io
November 11, 2025 at 1:14 PM
janitor's greatest function that is irreplaceable when you really need it.
convert excel date formats into date formats with excel_numeric_to_date()
#rstats
sfirke.github.io/janitor/refe...
convert excel date formats into date formats with excel_numeric_to_date()
#rstats
sfirke.github.io/janitor/refe...
Really enjoying the mayocoba bean soup from @ranchogordo.bsky.social
November 11, 2025 at 2:33 AM
Really enjoying the mayocoba bean soup from @ranchogordo.bsky.social
Reposted by Mid terms are November 3rd 2026. Go register voters.
{sqltargets} 0.3.0 just hit CRAN, now includes the ability to pass 'dbi' parameters into queries. Turns out using SQL with #rstats {targets} is pretty fun!
github.com/daranzolin/s...
github.com/daranzolin/s...
November 10, 2025 at 10:39 PM
{sqltargets} 0.3.0 just hit CRAN, now includes the ability to pass 'dbi' parameters into queries. Turns out using SQL with #rstats {targets} is pretty fun!
github.com/daranzolin/s...
github.com/daranzolin/s...
@quarto.org and {pkgdown} experts,
Can I not just render my quarto vignettes in their full glory locally and move the html file only to the docs section so that website renders the code annotations / call outs but locally it will still show minimal html version?
#rstats
Can I not just render my quarto vignettes in their full glory locally and move the html file only to the docs section so that website renders the code annotations / call outs but locally it will still show minimal html version?
#rstats
November 10, 2025 at 6:54 PM
@quarto.org and {pkgdown} experts,
Can I not just render my quarto vignettes in their full glory locally and move the html file only to the docs section so that website renders the code annotations / call outs but locally it will still show minimal html version?
#rstats
Can I not just render my quarto vignettes in their full glory locally and move the html file only to the docs section so that website renders the code annotations / call outs but locally it will still show minimal html version?
#rstats
If you want to load excel files directly to @duckdb.org in #rstats, you can use the md::read_excel() function in the motherduck package
simply pipe your excel file into read_excel() and you will load your data directly to your database by passing your local memory
usrbinr.github.io/md/reference...
simply pipe your excel file into read_excel() and you will load your data directly to your database by passing your local memory
usrbinr.github.io/md/reference...
Read an Excel file into a DuckDB/MotherDuck table — read_excel
Loads the DuckDB excel extension and creates a table from an Excel file
using the read_xlsx() table function. The destination is fully qualified
as <database>.<schema>.<table>. Only ...
usrbinr.github.io
November 10, 2025 at 1:14 PM
If you want to load excel files directly to @duckdb.org in #rstats, you can use the md::read_excel() function in the motherduck package
simply pipe your excel file into read_excel() and you will load your data directly to your database by passing your local memory
usrbinr.github.io/md/reference...
simply pipe your excel file into read_excel() and you will load your data directly to your database by passing your local memory
usrbinr.github.io/md/reference...
part 2 completed -- now with new logo.
Having trouble with the website so taking a breaking now -- will finis it off later this week.
#rstats
usrbinr.github.io/md/index.html
Having trouble with the website so taking a breaking now -- will finis it off later this week.
#rstats
usrbinr.github.io/md/index.html
November 10, 2025 at 2:09 AM
part 2 completed -- now with new logo.
Having trouble with the website so taking a breaking now -- will finis it off later this week.
#rstats
usrbinr.github.io/md/index.html
Having trouble with the website so taking a breaking now -- will finis it off later this week.
#rstats
usrbinr.github.io/md/index.html
part one completed
November 9, 2025 at 9:13 PM
part one completed
# to do list
- create unit tests
- update @quarto.org website documentation
- create new repo with CRAN friendly name
- submit package!
- create unit tests
- update @quarto.org website documentation
- create new repo with CRAN friendly name
- submit package!
November 9, 2025 at 2:14 PM
# to do list
- create unit tests
- update @quarto.org website documentation
- create new repo with CRAN friendly name
- submit package!
- create unit tests
- update @quarto.org website documentation
- create new repo with CRAN friendly name
- submit package!
nice thread on this topic which continues to vex me.
#rstats
#rstats
Hey #rstats,
Are there any good tricks for deciding on sensible dimensions for a plot when saving it?
Or does everyone just tweak the dimensions in ggsave() until it looks right?
Are there any good tricks for deciding on sensible dimensions for a plot when saving it?
Or does everyone just tweak the dimensions in ggsave() until it looks right?
November 9, 2025 at 2:03 PM
nice thread on this topic which continues to vex me.
#rstats
#rstats
finding out "md" already exists as a package in CRAN and now I need a new name for my @motherduck.com package
#rstats
#rstats
a close up of a cat taking a selfie with its mouth open
ALT: a close up of a cat taking a selfie with its mouth open
media.tenor.com
November 8, 2025 at 11:01 PM
finding out "md" already exists as a package in CRAN and now I need a new name for my @motherduck.com package
#rstats
#rstats
Add new `launch_ui()` function to the {contoso} package so that you can quickly launch a @duckdb.org application in your browser to visualize and manage the contoso database tables
#rstats
usrbinr.github.io/contoso/refe...
#rstats
usrbinr.github.io/contoso/refe...
Dataset of the Contoso Company
A collection of synthetic datasets simulating sales transactions from a fictional company. The dataset includes various related tables that contain essential business and operational data, useful for ...
usrbinr.github.io
November 8, 2025 at 8:45 PM
Add new `launch_ui()` function to the {contoso} package so that you can quickly launch a @duckdb.org application in your browser to visualize and manage the contoso database tables
#rstats
usrbinr.github.io/contoso/refe...
#rstats
usrbinr.github.io/contoso/refe...
today I learnt about "CALL start_ui()" in @duckdb.org which is superhelpful in to visualize and organize your local database!
November 8, 2025 at 5:11 AM
today I learnt about "CALL start_ui()" in @duckdb.org which is superhelpful in to visualize and organize your local database!
#rstats package developers -- what is the recommended swag we should put on our packages github site?
by swag I mean all those badges that say if package is failing or if its on cran, its lifecycle, etc
by swag I mean all those badges that say if package is failing or if its on cran, its lifecycle, etc
November 8, 2025 at 4:49 AM
#rstats package developers -- what is the recommended swag we should put on our packages github site?
by swag I mean all those badges that say if package is failing or if its on cran, its lifecycle, etc
by swag I mean all those badges that say if package is failing or if its on cran, its lifecycle, etc
Reposted by Mid terms are November 3rd 2026. Go register voters.
I am vibe-coding a little R package for work, as an experiment.
This is a first for me, and I can already see how this habit would turn me into a dumber mofo in weeks.
I cannot imagine a faster shortcut to irrelevance...
This is a first for me, and I can already see how this habit would turn me into a dumber mofo in weeks.
I cannot imagine a faster shortcut to irrelevance...
November 7, 2025 at 1:49 PM
I am vibe-coding a little R package for work, as an experiment.
This is a first for me, and I can already see how this habit would turn me into a dumber mofo in weeks.
I cannot imagine a faster shortcut to irrelevance...
This is a first for me, and I can already see how this habit would turn me into a dumber mofo in weeks.
I cannot imagine a faster shortcut to irrelevance...
honestly - this should be the gold standard for unit tests
using describe() and it() makes understanding and documenting your unit tests so much better
#rstats
testthat.r-lib.org/reference/de...
using describe() and it() makes understanding and documenting your unit tests so much better
#rstats
testthat.r-lib.org/reference/de...
describe: a BDD testing language — describe
A simple behavior-driven development (BDD)
domain-specific language
for writing tests. The language is similar to RSpec
for Ruby or Mocha for JavaScript. BDD tests read
like sentences and it should th...
testthat.r-lib.org
November 7, 2025 at 1:42 PM
honestly - this should be the gold standard for unit tests
using describe() and it() makes understanding and documenting your unit tests so much better
#rstats
testthat.r-lib.org/reference/de...
using describe() and it() makes understanding and documenting your unit tests so much better
#rstats
testthat.r-lib.org/reference/de...
New logo released for the contoso package
If you're looking to practice analysis on business transaction data then, consider the {contoso} package
It also gives you the ability to generate from 10k to 100M rows of data with @duckdb.org
usrbinr.github.io/contoso/
If you're looking to practice analysis on business transaction data then, consider the {contoso} package
It also gives you the ability to generate from 10k to 100M rows of data with @duckdb.org
usrbinr.github.io/contoso/
November 7, 2025 at 12:43 PM
New logo released for the contoso package
If you're looking to practice analysis on business transaction data then, consider the {contoso} package
It also gives you the ability to generate from 10k to 100M rows of data with @duckdb.org
usrbinr.github.io/contoso/
If you're looking to practice analysis on business transaction data then, consider the {contoso} package
It also gives you the ability to generate from 10k to 100M rows of data with @duckdb.org
usrbinr.github.io/contoso/
I labeled the function data() and now I stuck in namespace conflict hell between utils and my package
Do I need to rename my function? I don't see how i can pass the devtools::checks()
#rstats
Do I need to rename my function? I don't see how i can pass the devtools::checks()
#rstats
do not name functions after base or utils functions
November 7, 2025 at 2:38 AM
I labeled the function data() and now I stuck in namespace conflict hell between utils and my package
Do I need to rename my function? I don't see how i can pass the devtools::checks()
#rstats
Do I need to rename my function? I don't see how i can pass the devtools::checks()
#rstats
do not name functions after base or utils functions
November 7, 2025 at 2:29 AM
do not name functions after base or utils functions
Instead of rice, my work is serving spaghetti for my taco bowl.
This feels criminal.
This feels criminal.
November 6, 2025 at 5:32 PM
Instead of rice, my work is serving spaghetti for my taco bowl.
This feels criminal.
This feels criminal.
okay, got the package to the review stage -- lets see how it goes from here
@nrennie.bsky.social
@nrennie.bsky.social
November 6, 2025 at 12:56 PM
okay, got the package to the review stage -- lets see how it goes from here
@nrennie.bsky.social
@nrennie.bsky.social
Reposted by Mid terms are November 3rd 2026. Go register voters.
I’ve been writing R since 2008 and somehow NEVER noticed that functions can literally call themselves in some sort of evil self-recursion.
I don't remember ever seeing this thing in the wild!
#rstats
I don't remember ever seeing this thing in the wild!
#rstats
November 6, 2025 at 11:36 AM
I’ve been writing R since 2008 and somehow NEVER noticed that functions can literally call themselves in some sort of evil self-recursion.
I don't remember ever seeing this thing in the wild!
#rstats
I don't remember ever seeing this thing in the wild!
#rstats
today I learnt about the .Rbuildignore file
November 6, 2025 at 12:03 PM
today I learnt about the .Rbuildignore file
is there acceptable waiting period before you double email CRAN on your package status? is this like dating where if you show too much interest, they get the ick?
#rstats
#rstats
November 6, 2025 at 12:46 AM
is there acceptable waiting period before you double email CRAN on your package status? is this like dating where if you show too much interest, they get the ick?
#rstats
#rstats