Import data from an Excel worksheet into R - all you need to know

Importing data from an Excel worksheet into R can be easily achieved with a couple of lines of code.

In this tutorial I'll show the readxl-package and its functionality to import data from .xlsx and .xls files into an R data frame. I'll also show how to only import a certain sheet and within only a certain range of data as well as other helpful arguments like deleting whitespace, setting NA values and so forth.

⏰ Timestamps:
==============
0:00 Introduction and readxl-package installation
0:13 Setting the working directory
0:27 Defining a data frame and setting the source
1:05 Additional arguments - I) select a sheet
1:32 Additional arguments - II) define NA values
1:40 Additional arguments - III) select a range within the sheet
1:56 Additional arguments - IV) skip rows
2:06 Additional arguments - V) remove whitespace
2:22 Additional arguments - VI) define variable names

#useR #statorials

Support channel? 🙌🏼
===================