Remote

Chris Newton

@cd_newton@hachyderm.io

mastodon 4.7.3

#RStats #Python #QGIS #RSpatial #SQL 🌐💻📊🐕| Environment and climate🌦🌿🦔|
Veganism 🌱🐾| Music, film, books, cycling. All views my own.

0 Followers

0 Following

8 Posts

Joined April 26, 2025

Location:

Stroud/Bristol, UK

GitHub (largely inactive…):

https://github.com/ChrisDNewton

Bandcamp:

https://bandcamp.com/critical_newt

Bookwyrm:

https://bookwyrm.social/user/Chris_Newton

Chris Newton @cd_newton@hachyderm.io

· 5mo ago

Replying to

@jimgar@hachyderm.io @keyboardpipette@genomic.social Trainline seconded. I find it much more reliable than the “official” app of my (for now) operator. @jimgar@hachyderm.io great point re. turnarounds - I’ve had to wait a long time at Swindon more than once due to minor delays meaning I missed my connection…

Chris Newton @cd_newton@hachyderm.io

· 5mo ago

Replying to

@defuneste@fosstodon.org @LeafyEricScott@hachyderm.io *EDIT* sorry I missed that someone already suggested this! I know “regular” DuckDB has the “Union by name” argument in read_csv() which might work, I’m not sure the R package version of read_csv() lets you use this, but presumably you could use the SQL syntax within dbGetQuery() and that might work? 🤔 https://duckdb.org/docs/current/data/multiple_files/combining_schemas

DuckDB

Combining Schemas

Examples Read a set of CSV files combining columns by position: SELECT * FROM read_csv('flights*.csv'); Read a set of CSV files combining columns by name: SELECT * FROM read_csv('flights*.csv', union_by_name = true); Combining Schemas When reading from multiple files, we have to combine schemas from those files. That is because each file has its own schema that can differ from the other files. DuckDB offers two ways of unifying schemas of multiple files: by column position and by column name. By

Chris Newton @cd_newton@hachyderm.io

· 6mo ago

@ced@mapstodon.space @duringju@rstats.me @GillesColling@fosstodon.org I’m pretty sure dplyr::left_join() warns you if a one-to-many join occurs even if you _haven’t_ specified an expected relationship?

Chris Newton @cd_newton@hachyderm.io

· 7mo ago

@ike@pkm.social @fringemagnet@sunny.garden Similar! I played it when it came out but weirdly have been thinking about it more recently despite being completely out of the loop with gaming nowadays. I only played VI to X; VIII definitely has something haunting about it. Great soundtrack too.

Chris Newton @cd_newton@hachyderm.io

· 6mo ago

Debate in parliament about activating the break clause for the FDP/ Palantir coming up on April 16th. If you’d like to email your MP to share your thoughts/urge they attend, Foxglove have a template/sending service here:

https://www.foxglove.org.uk/campaigns/palantir-nhs-debate-april-16/

foxglove.org.uk

Chris Newton @cd_newton@hachyderm.io

· 6mo ago

Does anyone know of any good solicitors in/around #Bristol (UK) for dealing with #probate / #conveyancing ? Sadly, I have a need for one and any recommendations would be very welcome.

hachyderm.io

Chris Newton @cd_newton@hachyderm.io

· 6mo ago

Replying to

@KathyReid Happens to the best of us.

Chris Newton @cd_newton@hachyderm.io

· 8mo ago

Replying to

@ecosimon Used to make this one a lot, it’s a good recipe!