Cleaning and manipulating data with the tidyverse: dplyr, readr, and stringr in action (CC121)

[@Riffomonas]

What part of working with regular expressions do you find the most frustrating?

[@getachewaga7734]

HI Pat, great presentation. I love your tutorials. Many thanks for your generous gift.

Great example of real use for manipulating data. Thanks!

[@Riffomonas]

Thanks Victor! 🤓

[@timmytesla9655]

I learnt about rename_all() for the first time. Thank you.

[@Riffomonas]

Wonderful! So glad you learned something new. I mainly use tolower, but you can use any function with rename_all

[@haraldurkarlsson1147]

Clear and purpose-driven!

[@m.shihamadam4682]

I am loving it - just found about the channel!

[@marialeticiabonatelli5768]

So happy, it worked! And I had a completely different raw data - from dada2!

[@mocabeentrill]

Thanks Pat. Really great tutorial.

[@mikodine]

Hi Pat, great tutorial! Thanks a lot for this :)

[@davidjackson7675]

Nice job.

[@EMlSHI]

Could you introduce how to clean up and manipulate taxnomy data output from qiime2?

[@Riffomonas]

Hah! I likely have a conflict of interest, but I’d strongly encourage you to work with your data in mothur instead

[@ahmed007Jaber]

Hi Pat, thank you for this. Is there a way to specify in the regular expression if you don't find this regex, look for 2nd form, 3rd form etc???

[@Riffomonas]

Tha is for watching! Sorry. Not that I’m aware of other than setting up multiple separate searches

[@ahmed007Jaber]

@@Riffomonas i see. what I am thinking of and facing is that i have some entries like a code D alphabit d digits DDD-ddd-DDD this patter could repeat fully or partially e.g. DD-dd-DDD-ddd-dddd DDD-ddd-DDD-DDD-ddd-DDD the delimiter is always there

[@Riffomonas]

@@ahmed007Jaber Ah, maybe try using the separate function. If you look back through past episodes I have one in there on how to use it. Basically, it lets you separate a column by a delimeter into new columns

[@ahmed007Jaber]

@@Riffomonas thank you; will check it

[@ahmed007Jaber]

@@Riffomonas HI Pat, thank you for the effort you put in replying and sharing knowledge. your comments clicked with me. did look quickly at the aforementioned video and tried the following in regex to match another pattern str_extract(x, pattern= "(........) | (......)") it worked like a charm

[@shrez28]

Will machine learning methods such as performing random forest on compositional data (as we have relative abundances for the genera) require any type of data transformation?

[@Riffomonas]

We’ll do some transformations but not for compositionality. Depending on your application that may be something to experiment with

[@shrez28]

@@Riffomonas Thanks, will wait for the tutorials. Your videos are really helpful :)

[@wapsyed]

You look and sound like a smart version of Seth Rogen haha

[@richardbennett4365]

The presenter appears to know R; however he doesn't seem to know that parentheSIS is the singular for parentheSES. 😮

[@Riffomonas]

Sorry for my midwestern drawl that tends to mangle some words. At least I know that “data” is plural though. #amirite?

[@richardbennett4365]

It's all good. No problem.