Download datasets and/or code needed to complete the project, available in the resource section of this project.

For your capstone project, just perform the following tasks:

A. Import "student grades.xlsx"

B. In the "Global Environment", mark how many cases has the dataframes "students" and grades"

C. Join students and grades dataframes and filter the observations of "Amos Clarke" and "Jaime Woods". Then select only, first name, last name, course_id, course_name and grade (not student_id).

D. Combine columns first_name and last_name Then select fullName, course_name, grade in this order.

Post in your project gallery a text file with the code you wrote to complete steps C and D, along with the number of observations/cases of both datasets.

Explore More Data Analysis Classes on Skillshare

Getting Started with RStudio: Learn the 10 most important things that 99% of R programmers should know about the RStudio IDE Interface.

Importing data with RStudio: Learn how to import rectangular data, excel files, data from SPSS and other statistical software, and learn how to use R with databases.

Programming Basics: Fundamentals for Data Analysis: learn how structured programming, programming concepts, such as variables, data types, arrays, algorithms, if-then statements, loops,functions, databases, and operating systems

Luc Muhindo Danny

--

2