Course Description

Importing or reading data is one of the most basic and crucial stages of data analysis. In this introductory course, you will learn to read data into R from different sources and in multiple formats. You will examine the challenges in reading data and use appropriate methods to address them.

What will I learn?

After completing this course, you should be able to:

  • list sheets in an excel file
  • read data from excel spreadsheets
  • read data from a range of cells
  • read specific rows/columns of data


Self Paced Online Courses


Our online self paced courses are designed to allow participants to learn at their convenience. Learning outcomes are clearly defined and enhanced by the use of byte sized videos, PPTs, assignments, quizzes, suggested reading and case studies. Participants can take advantage of the discussion forum to discuss with their peers and the instructors to enhance their learning experience.


Course Features


Course Requirements
  • Access to a computer with an internet connection

  • Ability and permissions to download files & install software

  • Basic knowledge of English (Course is delivered in English language)


Who is this course for?


We expect the students to have some prior experience with R and RStudio. If you have never used R before, our Introduction to R course will help you prepare for this course.



If I do not meet the requirements to enroll, what should I do?

We have a number of free courses that can help you prepare including:

  • Introduction to R

How will I execute the practical's?


You will use RStudio for the practical's. All the R scripts used in the examples, assignments and case study are available for download from the Learning Management System. For those of you who face issues installing RStudio on your system, we have created a RStudio cloud project where you can practice without installing any software or downloading files.


Do I need to apply? What are the admission criteria?

No. This course is open to enrolment for all and accepts students regardless of experience and background.

Course curriculum

  • 1

    Course Materials

    • Slides

    • R Script

    • Data

    • Blog Post

  • 2

    Introduction

    • Course Agenda

    • Learn to read data from an excel sheet

  • 3

    Read Data

    • Learn to read a range of cells - Part 1

    • Learn to read a range of cells - Part 2

    • Learn to read a range of cells - Part 3

    • Learn to read specific rows or columns

  • 4

    RStudio IDE

    • Learn to read data using RStudio IDE

Recommended Courses