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` 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 OCTOBER 2019 ## INBO coding club <!-- Adjust the room number and name --> Herman Teirlinck<br> 01.71 - Frans Breziers --- class: center, left  --- class: center, middle <!-- Create a new badge using Inkscape based on the assets/images/coding_club_badges.svg file -->  --- class: center, middle ## Strings?  --- class: center, middle ## No! Strings...  --- class: center, middle  [Download pdf 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: center, middle  --- 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/K_ba-lfbTmuuC1iYt5HT4A?both <iframe src="https://hackmd.io/K_ba-lfbTmuuC1iYt5HT4A?both" height="400px" width="800px"></iframe> --- class: left, middle ### Install the package suite Run `install.packages("tidyverse")` ### Load the package suite Run `library(tidyverse)` --- background-image: url(/assets/images/background_challenge_1.png) class: left, middle # Challenge 1 - Click [`20191024/20191024_species.csv`](https://github.com/inbo/coding-club/blob/master/data/20191024/20191024_species.csv) and download* data file to `/data` folder. - Click [`20191024/20191024_challenges.R`](https://github.com/inbo/coding-club/blob/master/src/20191024/20191024_challenges.R) and download* script in `/src` folder. <br>After reading data.frame `species_df`: - Set columns `species_id` and `taxa` lowercase - Make a vector of labels from column `species_id` and sort it alphabetically - Extract `species_id` labels longer than 2 letters <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_2.png) class: left, middle # Challenge 2 - Add a new column called `canonicalName` made of `Genus` + `species` separated by a space. - Column `taxa` contains not only taxonomic information. A census label, `not censused`, is present sometimes, e.g. `"rodent-not censused"`. Remove every census label from column `taxa` (output example: `"rodent"`). --- class: left, middle ## Intermezzo: <b>reg</b><small>ular</small> <b>ex</b><small>pressions</small> How to detect/remove/extract: - any kind of digit? - anything but letters `a `, `b` and `e`? - all full stops (`.`)? - any extra full stop (`.`)?  <br>Try yourself some of these rules before moving to challenge 3. .footnote[Also check out [regex101](https://regex101.com)] --- class: left, middle background-image: url(/assets/images/background_challenge_3.png) # Challenge 3 Column `authorship` is quite dirty: vertical pipes (`|`), `NA`, tabs, white spaces and punctuations (, ; .) occur at the end. Make a new column to store the cleaned version of it. --- class: left, middle # Bonus challenge - Click [`20191024/20191024_bird_observations.csv`](https://github.com/inbo/coding-club/blob/master/data/20191024/20191024_bird_observations.csv)* and download data file to `/data` folder. - We want to aggregate information about location from three different columns as follows: `PlaatsGemeente,PlaatsToponym:PlaatsToponymDetail`. - Try to do the same with file [20191024/20191024_bird_observations_with_na.csv](https://github.com/inbo/coding-club/blob/master/data/20191024/20191024_bird_observations_with_na.csv) where the three fields are not always filled. <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> --- class: center, middle  <!-- Adjust the room and date --> Room: Herman Teirlinck - 01.16 - Rik Wouters<br> Date: __26/11/2019__, van 10:00 tot 12:00<br> Title: ggplot (part 1)<br> (registration announced via DG_useR@inbo.be)