Awesome follow up, Pat! Loved the inclusion of the parentheses and taking it apart piece by piece, and also the inclusion of the separate function. On to lookaheads/behinds!
The `tidyr::extract()` function would combine the `str_replace` and `separate()` commands for you. For example: dist_tbl %>% tidyr::extract(samples, into=c("sex", "animal", "day"), regex="^(([FM])\\d+)D(\\d+)$", remove=FALSE, convert=TRUE). That way you don't have to bother with the intermediate string concatenation.
Love this Pat! keep it up! would love to see more of such content. I actually do such things most of the time. For a long time been doing this in excel and now trying to shift that in R. My challenge is that I use it in Arabic text.
@@Riffomonas lool; I am leveraging R even in Arabic now, though, it just takes some time what is the best way to reach you out? I have been using pivot tables for a bit and they are time saving at times. I have a database of projects their budgets and costs. I know that I can create custom subtotals and custom calculated columns, but was wondering if i could add a line underneath a subtotal to do a calculation e.g. i have one budget for the whole project but several categories of expenses. So I need to show the breakdown of expenses and at the end sum of it and then a new line showing the value of surplus or deficit. Another thing I just noticed, if I added it to a data model to create a measure and check the variance, I am not able to choose custom subtotals I would prefer to do it without VBA, but if it is a must, why not Sth like the one on the far right in a nut shell; i need to do a report on projects each will have its own budget and obviously different types of expenses which will be listed. after this there will be one line showing deficit or surplus for that project. I will need to find a way to do this and then export it to word. how would u approach it?
Hi, Thanks a lot. I need your help. I teach econometrics in my University and I really need something econometrics plugins to R commander or any GUI like radiant package which can help students learn econometrics very easily. Like STATA, drag and drop option for time series and panel data. Just like the BI tools. Can you please help me? I will be ever grateful to you. I subscribe to your community and I really need your advice...can you help me.....Thanks in advance
I was aware of the () but didn’t quite grok it. This is the best explanation I have seen
Wonderful! I forgot to point out that this is also why if you want to match a ( you need to use \\(
I am from Brazil and your explanation is so good that I can understand all your class. Thank you very much.
Wonderful - my pleasure!
Thanks again for make R learning easy!
My pleasure! Glad you enjoyed it 😊
This is really useful! Thanks!
My pleasure!
Awesome follow up, Pat! Loved the inclusion of the parentheses and taking it apart piece by piece, and also the inclusion of the separate function. On to lookaheads/behinds!
Even I have to use the cheat sheet to figure that stuff out 😂
The `tidyr::extract()` function would combine the `str_replace` and `separate()` commands for you. For example: dist_tbl %>%
tidyr::extract(samples, into=c("sex", "animal", "day"), regex="^(([FM])\\d+)D(\\d+)$", remove=FALSE, convert=TRUE). That way you don't have to bother with the intermediate string concatenation.
Didn't know that yet. Always combine str_replace and unite() or separate()! ty
Thanks- so many options!
Awesome, I always learn a lot from your videos
Thanks Andrea!
An amazing instructive video. Thank you for sharing it🙌.
Wonderful- glad you enjoyed it!
Excelent video!
Thanks for watching! 🤓
Love this Pat! keep it up!
would love to see more of such content. I actually do such things most of the time. For a long time been doing this in excel and now trying to shift that in R. My challenge is that I use it in Arabic text.
Hi Ahmad - I know I’d have a very hard time doing anything in Arabic text 😂
@@Riffomonas lool; I am leveraging R even in Arabic now, though, it just takes some time
what is the best way to reach you out?
I have been using pivot tables for a bit and they are time saving at times.
I have a database of projects their budgets and costs. I know that I can create custom subtotals and custom calculated columns, but was wondering if i could add a line underneath a subtotal to do a calculation e.g. i have one budget for the whole project but several categories of expenses. So I need to show the breakdown of expenses and at the end sum of it and then a new line showing the value of surplus or deficit.
Another thing I just noticed, if I added it to a data model to create a measure and check the variance, I am not able to choose custom subtotals
I would prefer to do it without VBA, but if it is a must, why not
Sth like the one on the far right
in a nut shell; i need to do a report on projects each will have its own budget and obviously different types of expenses which will be listed. after this there will be one line showing deficit or surplus for that project.
I will need to find a way to do this and then export it to word.
how would u approach it?
@11:47 btw love the series
Thanks Pat. Regex is so difficult.
My pleasure- it’s a different way of thinking but so so powerful once you get the hang of it
What’s the shortcut key to make the parentheses? I see him highlight and then press some key to make parentheses.
Hi, Thanks a lot. I need your help. I teach econometrics in my University and I really need something econometrics plugins to R commander or any GUI like radiant package which can help students learn econometrics very easily. Like STATA, drag and drop option for time series and panel data. Just like the BI tools. Can you please help me? I will be ever grateful to you. I subscribe to your community and I really need your advice...can you help me.....Thanks in advance
Sorry I only teach what I use. I prefer R because it is so much more reproducible than gui based tools