Matt Kerlogue's Avatar

Matt Kerlogue

@mattkerlogue.bsky.social

Freelance data/numbers/pretty charts, typically in #rstats. He/him, alphabet mafia type πŸ³οΈβ€πŸŒˆ, SE London. https://github.com/mattkerlogue https://matt.kerlogue.co.uk

143 Followers  |  192 Following  |  108 Posts  |  Joined: 23.12.2024  |  2.4702

Latest posts by mattkerlogue.bsky.social on Bluesky

I revive mail and deliveries for all 4 other properties on my street. I sometimes feel like a mini post office. Though sometimes is the other people’s fault (rather than RM/delivery folk) because they accidentally select my address rather than their own.

07.10.2025 23:16 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Even more frustrating is that while I’m no 4 proper (and upstairs is 4A) there’s also three other number 4’s on my street: two β€˜Flat 4, No X/Y’ with the same post code as me, and also one No 4 β€˜XXX houses’ but with a different post code.

07.10.2025 23:16 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

I think a lot of this is due to utilities companies. I’m no 4 in the PAF, but ground floor flat with at least one utility and β€˜lower ground’ with another (even though the flat doesn’t have any space below ground level).

07.10.2025 23:16 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

People always find it weird I have my parents listed with their full names rather than just "Mum" or "Dad".

06.10.2025 16:30 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

I unsubscribed the other week after I finished SNW S3 (will resub for S4) with that film still un watched. I doubt I’ll ever watch it. The trailer didn’t make it at all appealing.

30.09.2025 23:18 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
a man and a woman are standing next to each other with the words that is brand new information written below them ALT: a man and a woman are standing next to each other with the words that is brand new information written below them
23.07.2025 00:22 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Britpop wasn’t awful

06.06.2025 21:50 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

It’s a kindness

06.06.2025 21:44 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

It’s the same with rail nationalisation, which I much more pro, but β€œGB Railways” just hurts.

06.06.2025 21:39 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

These days I’m not entirely anti-ID cards, but calling it β€œBritCard” I’m definitely against that.

06.06.2025 21:38 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0

Or more simply:

quarto head content
_head.html (stuff to include at end of <head>)
_header.html (stuff to include at start of <body>)
quarto body content
_footer.html (stuff to include at end of <body>)

Fragments should start with underscores otherwise quarto thinks they're like a proper qmd file

29.05.2025 11:47 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Approximation of how Quarto (http://quarto.org) generates HTML: quarto-generated head content, header include, before-body include, quarto-generated body content (navigation, sidebar, title, body content, pagination, margin, footer), after-body-include.

Approximation of how Quarto (http://quarto.org) generates HTML: quarto-generated head content, header include, before-body include, quarto-generated body content (navigation, sidebar, title, body content, pagination, margin, footer), after-body-include.

This image is my rough understanding of how quarto generates/structures its HTML output.

29.05.2025 11:42 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0
HTML Options – Quarto

No, this comes after `page-footer` which is part of the quarto generated content. This is one of three "includes" that prepend/append to the content. You can specify these either in the page or project YAML.

quarto.org/docs/referen...

29.05.2025 11:42 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

format:
html:
include-after-body: _footer.html

28.05.2025 20:24 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

You can supply an HTML fragment to the `include-after-body` to be appended after the content rendered by quarto.

28.05.2025 20:23 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0

Broke: "May the Fourth be with you"

Woke: "The Fourth May with you be"

Excel: "5-April"

04.05.2025 09:44 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

πŸ˜‚πŸ˜‚πŸ˜‚

23.04.2025 13:17 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
According to Google AI overview: The saying "llamas are liars" is an informal expression, typically used humorously or to highlight an individual's tendency to be deceitful. It's not a literal statement about llamas themselves, but rather a metaphor that plays on the word "llama," which is a native South American animal.

Google AI overview also provides an example: You might say, "You know, you're a real llama, always lying to me!" as a playful way of calling someone out for their deceitful behavior, but it doesn't mean you believe they literally resemble a llama.

According to Google AI overview: The saying "llamas are liars" is an informal expression, typically used humorously or to highlight an individual's tendency to be deceitful. It's not a literal statement about llamas themselves, but rather a metaphor that plays on the word "llama," which is a native South American animal. Google AI overview also provides an example: You might say, "You know, you're a real llama, always lying to me!" as a playful way of calling someone out for their deceitful behavior, but it doesn't mean you believe they literally resemble a llama.

"Llamas are liars"... ah yes, I'm always using that common retort: "You know, you're a real llama, always lying to me"

23.04.2025 12:58 β€” πŸ‘ 4    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
According to Google's AI overview: The saying "llamas can't tell the truth" is a humorous idiom, implying that llamas are known for their honesty and straightforward nature. It's not meant to be taken literally, as llamas, being animals, cannot speak or lie in the human sense. The phrase is used to describe someone who is exceptionally honest, perhaps even to a fault, similar to how llamas are perceived as being trustworthy and genuine.

According to Google's AI overview: The saying "llamas can't tell the truth" is a humorous idiom, implying that llamas are known for their honesty and straightforward nature. It's not meant to be taken literally, as llamas, being animals, cannot speak or lie in the human sense. The phrase is used to describe someone who is exceptionally honest, perhaps even to a fault, similar to how llamas are perceived as being trustworthy and genuine.

"Llamas can't tell the truth" apparently means that somebody is being "exceptionally honest"

23.04.2025 12:36 β€” πŸ‘ 7    πŸ” 2    πŸ’¬ 1    πŸ“Œ 0
According to Google's AI overview: The saying "llamas can't tell the truth" is a humorous idiom, implying that llamas are known for their honesty and straightforward nature. It's not meant to be taken literally, as llamas, being animals, cannot speak or lie in the human sense. The phrase is used to describe someone who is exceptionally honest, perhaps even to a fault, similar to how llamas are perceived as being trustworthy and genuine.

According to Google's AI overview: The saying "llamas can't tell the truth" is a humorous idiom, implying that llamas are known for their honesty and straightforward nature. It's not meant to be taken literally, as llamas, being animals, cannot speak or lie in the human sense. The phrase is used to describe someone who is exceptionally honest, perhaps even to a fault, similar to how llamas are perceived as being trustworthy and genuine.

"Llamas can't tell the truth" apparently means that somebody is being "exceptionally honest"

23.04.2025 12:36 β€” πŸ‘ 7    πŸ” 2    πŸ’¬ 1    πŸ“Œ 0

there's also tidyxl which returns a data frame whereby each row is an individual cell and provides detailed metadata about each cell, there's an associated package unpivotr which allows you to process complex/messy spreadsheet structures like multi-column/multi-row grouping labels.

20.04.2025 23:39 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

readxl is my go to for reading in a spreadsheet as a simple data frame. openxlsx2 allows more complex interactions including writing back with formatting etc and constructing a multi-sheet workbook

20.04.2025 23:39 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0

Oh, and I forgot that there's actually a recent upgrade/successor to openxlsx: openxlsx2.

20.04.2025 22:25 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Friends (other #rstats users) let friends know that packages to open Excel spreadsheets that don't rely on rJava exist (readxl, openxlsx).

20.04.2025 22:13 β€” πŸ‘ 6    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0

{clipr} works just fine, I use both x |> clipr::write_clip() and clipr::read_clip() |> x without a problem … or are you meaning like an R Studio add-in?

18.04.2025 16:08 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Great. I’ll raise an issue on GitHub. Should be a relatively trivial. Have a good break.

11.04.2025 18:02 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Follow up q. See from the code that it doesn't currently support calls like 'palmerpenguins::penguins' or calls that work on penguins_raw. Is there a plan to support either? Can submit a PR if it's of interest.

11.04.2025 17:48 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

This is fab! And well done on getting penguins into base R!! πŸŽ‰

11.04.2025 17:38 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Output of the #rstats code to summarise a data.frame with the {skimr} package and convert to markdown table format using the kable function from the {knitr} package.

Output of the #rstats code to summarise a data.frame with the {skimr} package and convert to markdown table format using the kable function from the {knitr} package.

mtcars |>
skimr::skim() |>
skimr::focus(n_missing, numeric.mean, numeric.p0, numeric.p100, numeric.hist) |>
knitr::kable(digits = 2)

08.04.2025 18:23 β€” πŸ‘ 6    πŸ” 3    πŸ’¬ 0    πŸ“Œ 0
Preview
Compact and Flexible Summaries of Data A simple to use summary function that can be used with pipes and displays nicely in the console. The default summary statistics may be modified by the user as can the default formatting. Support for d...

The {skimr} package is probably the easiest route to something similar to glimpse (i.e. variable summary per row), though you probably also need to curtail all the stats it outputs. docs.ropensci.org/skimr/index....

08.04.2025 18:23 β€” πŸ‘ 2    πŸ” 1    πŸ’¬ 1    πŸ“Œ 0

@mattkerlogue is following 20 prominent accounts