Course Details

Previous Page


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
    Intermediate