class: center, middle  <!-- Do not forget to adapt the presentation title in the header! --> <!-- Adjust the presentation to the session. Focus on the challenges, this is not a coding tutorial. Note, to include figures, store the image in the `/docs/assets/images/yyyymmdd/` folder and use the jekyll base.url reference as done in this template or see https://jekyllrb.com/docs/liquid/tags/#links. using the scale attribute , you can adjust the image size. --> <!-- Adjust the day, month --> # 24 SEPTEMBER 2020 ## INBO coding club <!-- Adjust the room number and name --> Somewhere over the rainbow --- class: center, middle  <small> Source: [stats-illustrations](https://github.com/allisonhorst/stats-illustrations) of [Allison Horst](https://github.com/allisonhorst/) </small> --- class: center, middle <!-- Create a new badge using Inkscape or other programs based on the assets/images/coding_club_badges.svg file -->  --- class: center, middle  <p> No string theory today! </p> --- class: center, middle  <p> We will focus on the tidyverse package `stringr` </p> --- class: center, middle  [Download cheatsheet here](https://github.com/inbo/coding-club/blob/master/cheat_sheets/20180426_cheat_sheet_stringr.pdf) --- class: center, middle ### How to get started? Check the [Each session setup](https://inbo.github.io/coding-club/gettingstarted.html#each-session-setup) to get started. ### First time coding club? Check the [First time setup](https://inbo.github.io/coding-club/gettingstarted.html#first-time-setup) section to setup. --- class: left, middle  <br> No yellow sticky notes online :-( We use hackmd (see next slide) but basic principle doesn't change. --- class: center, middle ### Share your code during the coding session! <!-- Create a new hackmd file and replace this link (twice!) --> Go to https://hackmd.io/3YGdtGAsQ1G9ahAg4YODRQ?both <iframe src="https://hackmd.io/3YGdtGAsQ1G9ahAg4YODRQ?both" height="400px" width="800px"></iframe> --- class: left, middle # Download data and code Today instead of downloading the files manually, we will test a new inborutils function called `setup_codingclub_session()`. Restart your R session and update the inborutils package by running: ```r if (!"remotes" %in% rownames(installed.packages())) { install.packages("remotes") } remotes::install_github("inbo/inborutils") ``` To download the coding club material of today, just run `setup_codingclub_session()`. For a past date, use the "YYYYMMDD" format, e.g. `setup_codingclub_session("20200825")` to download the coding club material of last session on August, 25. For all options, check the [documentation online](https://inbo.github.io/inborutils/reference/setup_codingclub_session.html). You can of course download [data](https://github.com/inbo/coding-club/blob/master/data/20200924/20200924_bird_rings.tsv) and [scripts](https://github.com/inbo/coding-club/blob/master/src/20200924/20200924_challenges.R) manually* still as we always did! <small>* __Note__: check the getting started instructions on [how to download a single file](https://inbo.github.io/coding-club/gettingstarted.html#each-session-setup)</small> --- background-image: url(/assets/images/background_challenge_1.png) class: left, middle # Challenge 1 1. Find birds with a 6 characters long metal ring (column `metal_ring`) and a color ring (column `color_ring`) starting with a C and ending with a R 2. All color rings should be uppercase. Find anomalies 3. Solve all anomalies found in (2) by setting all color rings uppercase --- background-image: url(/assets/images/background_challenge_2.png) class: left, middle # Challenge 2 1. Create a new column called `color_ring_complete` containing color ring information in this format: `background_color`+`inscription_color`+`"("`+`color_ring`+`")"`, e.g. RW(FJAC) 2. We have to extract all color rings (column `color_ring`) with a **4-letter only** long inscription where the third letter is an A. --- class: center, middle ## Intermezzo: the power of regex *regex* what?? REGular EXpresssions ``` example_string <- "I. love. the. 2019(!!) INBO. Coding. Club! Session. of. 24/09/2020...." ``` Go to page 2 of the cheat sheet  --- background-image: url(/assets/images/background_challenge_3.png) class: left, middle # Challenge 3 1. The dots in color rings (column `color_ring_dots`), e.g. `KRO.C`, `KZ.AC`, are used for improving readibility. Apart from that, the values in column `color_ring_dots` should be exactly the same as the ones in column `color_ring`. Find anomalies. 2. Some metal rings (column `metal_ring`) start with one or more asterisks. Remove the asterisks. 3. Find color rings (column `color_ring`) containing two consecutive vowels --- class: left, middle # Bonus challenge 1. Now that you removed the asteriks from metal rings, you can map metal rings following the [EURING Exchange Code 2000+ standard](https://euring.org/files/documents/EURING2000%2BCodev112.pdf). A ring number should consist of up to ten alphanumeric characters. At page 7 we read: > *Where the ring number consist of fewer than ten numbers/letters, the number is padded with dots. These dots are always inserted to the left of the rightmost row of numbers.* <br>Examples: `H146416` → `H...146416`, `H67169` → `H....67169` 2. As we are all speaking about vaccines: https://dodona.ugent.be/en/activities/303251929/ ([Dutch version available](https://dodona.ugent.be/nl/activities/303251929/)). Use `variable <- readline()` to read a line from the terminal and assign it to `variable`. --- class: left, middle ## Resources - Solutions are available in R file: [`src/20200924/20200924_challenges_commented_solutions.R`](https://github.com/inbo/coding-club/blob/master/src/20200924/20200924_challenges_commented_solutions.R) - Video recording of the coding club session is available on [INBO's vimeo channel](https://vimeo.com/463832080) - R specific regex tester: https://spannbaueradam.shinyapps.io/r_regex_tester/ (e.g. "\\\\." for finding dots) - general regext tester: https://regex101.com/ (but pay attention: "\\" instead of R typic double backslash "\\\\") - Did you know you can analyse text with R? Take a look at: [tidy text mining](https://www.tidytextmining.com/) --- class: center, middle  <!-- Adjust the room and date --> Room: online <br> Date: __27/10/2020__, van 10:00 tot 12:00<br> Subject: Dates in R (registration announced via DG_useR@inbo.be)