I freaking love this!!! Honestly old me used SQL scripts into R to avoid complexity, but now I can see dplyr makes it even simpleR. Thanks Yury. Greetings from Colombia
I too think that 'dplyr' walks all over SQL. When I've told databases SQL guys who don't know R, they look at me like I'm crazy. The only limitation is the memory limitation of R.
Hi Sir, (Out of context). How can I carry out a cross tabulation by setting some exclusion of values. For instance, variables under observation are x and y where x variable has zero values and should be excluded during plotting of the table.
@@yuzaR-Data-Scienceone more thing, I find Miniforge3 or micromamba, not Anaconda, to be the best way to manage python projects with their various packages and dependencies. Anaconda just installs way too much stuff. I'm also finding that LFortran can be installed as a kernel in Jupyter, so that's nice, too. And yes, one more thing, DataSpell can manage both R and python.
I freaking love this!!! Honestly old me used SQL scripts into R to avoid complexity, but now I can see dplyr makes it even simpleR. Thanks Yury. Greetings from Colombia
Glad you liked it! Yeah, since I know dplyr, I stopped using SQL too
Thank you so much !
Welcome!
I love all your work, and I'm a big fan of your channel. Excellent tutorial as usual.
Please, keep up the great work and thanks for everything.
❤❤❤❤❤
Thank you very much, Muhammed! That means a lot to me! I will produce more content.
I too think that 'dplyr' walks all over SQL. When I've told databases SQL guys who don't know R, they look at me like I'm crazy. The only limitation is the memory limitation of R.
Exactly! I new SQL before R. But since I learned all I need for SQL in dplyr, I never touched SQL again ;)
yeah, the memory limitation is a problem, I got a new PC with tons of RAM and can't complain so far
Hi Sir, (Out of context).
How can I carry out a cross tabulation by setting some exclusion of values. For instance, variables under observation are x and y where x variable has zero values and should be excluded during plotting of the table.
I don't think so, but i you need to exclude them anyway, why not just use dplyr to exclude them from x first, and then execute a join on x-table?
Duckdb with Ibis.
It’s similar, but it’s python, right?
Yes.
as I needed to use python, I found a couple of R similar packages our of laziness, but it worked well :)
@@yuzaR-Data-Scienceby the way, I like your presentations. The animations and graphics are top-notch, clear, and easy to understand.
@@yuzaR-Data-Scienceone more thing, I find Miniforge3 or micromamba, not Anaconda, to be the best way to manage python projects with their various packages and dependencies. Anaconda just installs way too much stuff.
I'm also finding that LFortran can be installed as a kernel in Jupyter, so that's nice, too. And yes, one more thing, DataSpell can manage both R and python.