I've been starting to add my scripts onto #codeberg for processing my wildcounts biodiversity monitoring data. I've added an R script I just finished that adds the recording date and time to audio recordings made with an Apple Watch.

I needed this for a survey I had to do last month using my Apple Watch when my phone was malfunctioning. I started my GPS track (with my Garmin GPS) then spoke each of my observations into the voice recorder app on my watch, one recording per observation.

To geotag all those observations, I needed to know exactly when each recording was made, to match it with my GPS track. This was a good deal more complicated than I expected (because a lot of modern Apple software is too dumb to be really useful).

(Since my watch couldn't connect to my phone, it stored up the recordings then synced them to iCloud later. I was surprised to discover that all the file creation dates and media creation dates in the audio files were the times they synced to iCloud, not when they were recorded. That required an unexpected journey into the innards of the VoiceMemos app sqlite database using Terminal to extract the real recording times.)

Anyway, I now have an R script that automates all this.

https://codeberg.org/wildcounts/utilities/

#wildcounts #RStats #datawrangling

utilities

A collection of scripts to assist with wild counts workflows for ecological monitoring.

Codeberg.org
Say goodbye to the frustrations of copying and pasting data to and from R with Datapasta from @milesmcbain! Get the package now: https://milesmcbain.github.io/datapasta/ #DataWrangling #Rstats
R Tools for Data Copy-Pasta

RStudio addins and R functions that make copy-pasting vectors and tables to text painless.

I'm reviewing the content and computational skills taught in a Research Data Skills module.
#data #DataWrangling

Apparently my knowledge of perl is pretty outdated nowadays.
#perl #perl4datascience

But am I crazy to want to teach them to use the *nix command line, and grep, awk and sed???
#DataScience #ChangeMyMind

Sometimes you get data in less than optimal format, e.g. as a png of a figure 😭... In that case https://cran.r-project.org/web/packages/metaDigitise/vignettes/metaDigitise.html might be the rescue. #rstats #ohno #datawrangling
metaDigitise

Turns out, quick coding tasks are not actually quick but can eat up all day. Who would have thought... Not me, apparently... And why is this model so slow? #R #stats #DataWrangling

These six Pandas functions power most data wrangling: read_csv to load data, info to inspect, isnull for missing values, drop to clean, groupby to summarize, and apply to customize logic. Master these and you control your dataset.

📕 https://ebokify.com/python

#Python #Pandas #DataWrangling #DataAnalytics #MachineLearning #DataScience #CodingTips

#TIL about #querychat (https://posit-dev.github.io/querychat/), it is simply amazing to get quickly a #Shiny app that allows people to explore data using a chatbot interface. There are #Python and #RStats implementations.

#LLM #AI #Data #EDA #DataWrangling

Package Landing - Choose Your Language

Say goodbye to the frustrations of copying and pasting data to and from R with Datapasta from @milesmcbain! Get the package now: https://milesmcbain.github.io/datapasta/ #DataWrangling #Rstats
R Tools for Data Copy-Pasta

RStudio addins and R functions that make copy-pasting vectors and tables to text painless.

Sometimes you get data in less than optimal format, e.g. as a png of a figure 😭... In that case https://cran.r-project.org/web/packages/metaDigitise/vignettes/metaDigitise.html might be the rescue. #rstats #ohno #datawrangling
metaDigitise