How to Create and Manipulate Lists and Data frames in R

Lists and Data frames in R A List is an “object” in R that consist of a collection of other objects known as components. Lists can have components of the same type or mode, or components of different types or modes. They can hence combine different components (numeric, logical…) in a single object. A Data frame is simply a List of a specified class called “data.frame”, but the components of the list must be vectors (numeric, character, logical), factors, matrices (numeric), lists, or even other data frames. Other restrictions include the fact that the contents of a data frame must have the same length (vectors), or be of the same row size (matrices). A data frame can be considered as a simple matrix containing rows and columns, having potentially different modes and attributes. We encourage you to find more information on Lists and Data frames in the following link: https://cran.r-project.org/doc/manuals/r-release/R-intro.html Let’s see together in this step how Lists and Data frames can be created and manipulated.

How to create and manipulate Lists

Step 1. We recommend you to work in the same working sub-directory that you created previously, using one of the following options Before launching R   After launching R     Step 2. Let’s create a simple List called L. We need to assign elements to this List.     This will create a list called L with 4 elements.     Step 3. The function “length()” can allow you to easily retrieve the number of top level components of this List.     Step 4. Please note that components of a list are always numbered by default. If L is the list with 4 components we just created, then L[[1]] will be its first component, etc. We can also refer to the first entry of Component 4 independently, as L[[4]] is a vector itself and L[[4]][[1]] will refer to its first entry.     Step 5. More conveniently, we could also refer to the Component of a List by its name, instead of using its position number between double brackets. When using this option, you will need to provide the Component name by using the “$” symbol. As an example, you can use L$dairy or L[[1]] to refer to the first component of a List equally     Step 6. Different Lists can be combined using the concatenation function that we used before, c(). This will result in an object of mode List also, because we gave this function arguments of the mode List.     Note. Please note that there are many more options to use the Lists. We only covered those that might be relevant to understand for the rest of the course. We encourage you to find more information on lists in the link given to you in the introductory part of this Step.  

How to create and manipulate Data frames

  Step 1. Now that we know how Variables, Vectors, and Lists can be created and manipulated, let’s use this knowledge to create sequentially a data frame called df.     Step 2. Once created, the data frame can be called directly by simply typing its name.     Step 3. Additional information can be added to an existing data frame. We can create a new data frame containing the same names, to be able to make the correspondence (used as a primary key) and then combine both data frames using cbind(), a function used to combine objects (vectors, data frames,…) by columns.     Step 4. The information added can be in the form of Factors that can be used to represent categorical data, and can help you using plotting functions later on. Let’s create again a new data frame (df.add.fact) with the information in the Sex vector added as a Factor, and combine both in a new data frame (df.all.fact)     Note 1. Note that we coerced the content of “Sex” to be a Factor by as.factor(). Factors are categorical data that can only take certain values such as “M” and “F”, which is the case of the field “Sex”. These distinct values are predefined and will be called Levels. This can be checked using the functions class() and levels()     Note 2. At this stage, you will notice no difference. But using levels() you will be able to see how factors can now be recognised as such.     To query the type of levels we can use “levels()” and to query the number of levels, you can use “nlevels()”     Step 5. Let’s see a set of useful functions to explore and manipulate a data frame    

1. 1. How many rows and columns are in the data frame df.all.fact ? you can use dim() to set or get the dimension of the data frame (rows, columns), or more specifically nrow() for the number of columns and ncol() for the number of columns.

      2. What is the class of data in each column? Use sapply() which will output the result of a certain function to an object (here will output the classes in the data frame) or str() to display the structure of an object in R or all basic structures of a data frame (one line for each)     3. It is possible to subset or filter a data frame, as simply as we did it for Lists. For instance, let’s see here how to select one column or one row.   To select a column: [1] is column 1, [,1] is column 1 displayed as a vector   To select a row: [1,] is row 1     4. This is how to select a group of elements.   To select the element in column 1 and row 1: [1,1]   To select elements 1 to 3 in column 3     5. To re-order data in a data frame, there are different options. We can use “order()”. Let’s try to re-order here based on the Height column     6. To filter the data, functions such as “unique()” and “sort()” can be used. This should remind you of the sort and uniq functions that can be used in Unix.   To obtain unique values of the column Age: unique(df.all.fact$Age)   To obtain sorted unique values of the column age: sort(unique(df.all.fact$Age))   Note. There are different types of data that can be considered, and treated differently according to their nature.