Importing and Manipulating Data

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
This course covers loading data into Microsoft R from various data sources, including Hadoop, ODBC, SAS, SPSS, and SQL Server. It also covers data manipulation techniques, including data sorting, merging, cleaning, and filtering.

Target Audience
All individuals who wish to understand key concepts in big data analysis and Microsoft R features including scientists, analysts, and statisticians

Prerequisites
None

Expected Duration (hours)
1.1

Lesson Objectives

Importing and Manipulating Data

start the course

recognize key topics regarding importing in Microsoft R

identify important arguments for the rxImport function

recognize how to import text data into Microsoft R and modify data during the import

recognize how to import multiple files into Microsoft R

identify how to import SAS and SPSS data into Microsoft R

recognize how to connect to a SQL Server using Microsoft R

recognize important steps in importing data from Hadoop

identify important considerations for importing ODBC data into Microsoft R

practice importing data into Microsoft R

recognize what data manipulation is

list key functions used to sort data in Microsoft R

identify important functions used to merge data in Microsoft R

list key functions that are used to subset data in Microsoft R

identify functions that are used for sorting and merging data

Course Number:
df_abdr_a04_it_enus

Expertise Level
Expert