How to Get Data from SQL Databases With R | Step-by-Step Tutorial

preview_player
Показать описание

🧹CLEAN UP MESSY DATA

📈 CREATE EFFECTIVE CHARTS

MORE VIDEOS

MORE CONTENT

#rstats #dataviz #ggplot #dplyr
Рекомендации по теме
Комментарии
Автор

Very nice tips and details on the use of glue and SQL query!!! Thanks for explaining them. They are a bit tricky.

It could have been quite a while until I figured out where the error is. What a nice optimized approach you used for this part of the filtering.

Great video Albert!

mignacio
Автор

What a timely video. I'm working on a project using Duck DB from R. I know that Duck DB supports enums, nested data, and pivots, but I have no idea how to use them with DBI or dplyr. I'll put examples in the replies.

rayflyers
Автор

Thank you for watching my latest video. ♥

rappa
Автор

In my first year of data science i went through pain of writing a parser, build with paste XD this would have been easier. Although some time later i found out about the dbplyr package, which literally converts tidyverse syntax into sql syntax. quite nice if the queries aren't too complex

sqwpgeh