Manipulate R data frames using SQL in RStudio

提供方
在此指导项目中,您将:
2 hours
中级
无需下载
分屏视频
英语(English)
仅限桌面

Have you ever wondered how SQL queries work in R? Have you ever thought about whether it is possible to use or write SQL queries in R? Then, you are in the right place. This project-based course Manipulate R data frames using SQL in RStudio is for people who are learning R and who may be well-versed in SQL or even for experienced R programmers who seek useful ways for data manipulation in R. It is for people who are interested in advancing their knowledge and skills in using SQL in R. In this project, we will write very nice queries to manipulate the gapminder and UCBAdmissions R data frames using the sqldf package in RStudio. This project is extremely important for you as an R and SQL user. You will understand how the SQL SELECT statement works to interact with R to get the desired result. We will start this hands-on project by installing and importing the required packages and data sets for this project. Be rest assured that you will learn a ton of good work here. By the end of this 2-hour-long project, you will be able to use SELECT statements together with the WHERE clause to set conditions on data retrieved from R data frames. Also, you will understand how to use the WHERE clause together with other SQL operators like AND, OR, IN, NOT IN, BETWEEN- AND, NOT BETWEEN- AND, and other comparison operators to retrieve data from the data frames. Going forward, we will consider how to use wildcard characters with the LIKE and NOT LIKE operators for pattern matching. By extension, we will learn how to create data summaries or aggregates using SQL aggregate functions. In this project, we will move systematically by first introducing the SELECT statements using simple examples. Then, we will write slightly complex queries to solve some SQL challenges. Therefore, to complete this project, it is required that you have prior experience with using SQL and R. I recommend that you should complete the projects titled: “Getting Started with R” and “Querying Databases using SQL SELECT statements” before you take this current project. These introductory projects in using SQL and R will provide every necessary foundation to complete this current project. However, if you are comfortable writing queries in SQL, please join me on this wonderful ride! Let’s get our hands dirty!

您要培养的技能

  • Data Manipulation

  • R Programming

  • data querying

  • SQL Operators

  • SQL

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题