This is somehow exactly what I needed to wrap my mind around this. Thanks, dude.
@VmaryJ
4 жыл бұрын
Awesome video, I learned a lot! Thank you and please keep it going!
@Mr_nn23
4 жыл бұрын
Please more videos about SQL and perhaps Excel interacting with R!
@AndrewCouch
4 жыл бұрын
Definitely will make a video on using Excel and R together!
@Mr_nn23
4 жыл бұрын
Andrew Couch Thank you!
@ajiboyeabeeb3207
Жыл бұрын
Great video thanks. I managed to connect my db to R and creating my report using the rmarkdown. But my where clause isn't working with the markdown. PS. I used my db directly with R. Not like Im working with CSV file like you did in your video. Can you help point me in right direction?
@romulodamasceno2427
3 жыл бұрын
Thank you so much for the video. I wonder, though, if it makes sense to use SQL code inside R since it's main function is to query databases from the SQL format to one that is readable in R (correct me if I'm wrong please). Isn't it better to use tidyverse's dplyr when your database is already in R? Thanks again, amazing video!
@AndrewCouch
3 жыл бұрын
I think among R users it makes the most sense to use dplyr when querying a database. However, if you are showing results to other data scientists, analysts, etc. who are not familiar with R, it might be better to write it in SQL. Additionally, when querying databases at work, I am often given a basic query to use so in that case it is easier to paste in the SQL and adjust the script to my needs. Thanks for watching! -Andrew
@haraldurkarlsson1147
Жыл бұрын
It would be nice if this could be updated by adding duckdb (local database) and arrow.
@haraldurkarlsson1147
Жыл бұрын
The Elo rating system comes from the chess world, It takes it's name from the creator, Arpad Elo.
@r_rabbitrabbit1699
4 жыл бұрын
Thanks, man! Could I use these codes that you've made with PostgreSql?
@AndrewCouch
4 жыл бұрын
Yes, however, you will need to download a PostgreSQL driver for your odbc and enter the appropriate information. Here's a good resource for setting up PostgreSQL in R Studio. db.rstudio.com/databases/postgresql/ -Andrew
Пікірлер: 13