How to Make a Lookup Table in R (Example Code)
This article demonstrates how to create a lookup table in the R programming language.
Creation of Example Data
data(iris) # Example data head(iris) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa |
data(iris) # Example data head(iris) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa
iris_select <- c("setosa", "virginica") # Example vector iris_select # [1] "setosa" "virginica" |
iris_select <- c("setosa", "virginica") # Example vector iris_select # [1] "setosa" "virginica"
Example: Return Lookup Table Using %in% Operator
iris[iris$Species %in% iris_select, ] # Lookup # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa # 7 4.6 3.4 1.4 0.3 setosa # 8 5.0 3.4 1.5 0.2 setosa # 9 4.4 2.9 1.4 0.2 setosa # 10 4.9 3.1 1.5 0.1 setosa # 11 5.4 3.7 1.5 0.2 setosa # 12 4.8 3.4 1.6 0.2 setosa # 13 4.8 3.0 1.4 0.1 setosa # 14 4.3 3.0 1.1 0.1 setosa # 15 5.8 4.0 1.2 0.2 setosa # 16 5.7 4.4 1.5 0.4 setosa # 17 5.4 3.9 1.3 0.4 setosa # 18 5.1 3.5 1.4 0.3 setosa # 19 5.7 3.8 1.7 0.3 setosa # 20 5.1 3.8 1.5 0.3 setosa # 21 5.4 3.4 1.7 0.2 setosa # 22 5.1 3.7 1.5 0.4 setosa # 23 4.6 3.6 1.0 0.2 setosa # 24 5.1 3.3 1.7 0.5 setosa # 25 4.8 3.4 1.9 0.2 setosa # 26 5.0 3.0 1.6 0.2 setosa # 27 5.0 3.4 1.6 0.4 setosa # 28 5.2 3.5 1.5 0.2 setosa # 29 5.2 3.4 1.4 0.2 setosa # 30 4.7 3.2 1.6 0.2 setosa # 31 4.8 3.1 1.6 0.2 setosa # 32 5.4 3.4 1.5 0.4 setosa # 33 5.2 4.1 1.5 0.1 setosa # 34 5.5 4.2 1.4 0.2 setosa # 35 4.9 3.1 1.5 0.2 setosa # 36 5.0 3.2 1.2 0.2 setosa # 37 5.5 3.5 1.3 0.2 setosa # 38 4.9 3.6 1.4 0.1 setosa # 39 4.4 3.0 1.3 0.2 setosa # 40 5.1 3.4 1.5 0.2 setosa # 41 5.0 3.5 1.3 0.3 setosa # 42 4.5 2.3 1.3 0.3 setosa # 43 4.4 3.2 1.3 0.2 setosa # 44 5.0 3.5 1.6 0.6 setosa # 45 5.1 3.8 1.9 0.4 setosa # 46 4.8 3.0 1.4 0.3 setosa # 47 5.1 3.8 1.6 0.2 setosa # 48 4.6 3.2 1.4 0.2 setosa # 49 5.3 3.7 1.5 0.2 setosa # 50 5.0 3.3 1.4 0.2 setosa # 101 6.3 3.3 6.0 2.5 virginica # 102 5.8 2.7 5.1 1.9 virginica # 103 7.1 3.0 5.9 2.1 virginica # 104 6.3 2.9 5.6 1.8 virginica # 105 6.5 3.0 5.8 2.2 virginica # 106 7.6 3.0 6.6 2.1 virginica # 107 4.9 2.5 4.5 1.7 virginica # 108 7.3 2.9 6.3 1.8 virginica # 109 6.7 2.5 5.8 1.8 virginica # 110 7.2 3.6 6.1 2.5 virginica # 111 6.5 3.2 5.1 2.0 virginica # 112 6.4 2.7 5.3 1.9 virginica # 113 6.8 3.0 5.5 2.1 virginica # 114 5.7 2.5 5.0 2.0 virginica # 115 5.8 2.8 5.1 2.4 virginica # 116 6.4 3.2 5.3 2.3 virginica # 117 6.5 3.0 5.5 1.8 virginica # 118 7.7 3.8 6.7 2.2 virginica # 119 7.7 2.6 6.9 2.3 virginica # 120 6.0 2.2 5.0 1.5 virginica # 121 6.9 3.2 5.7 2.3 virginica # 122 5.6 2.8 4.9 2.0 virginica # 123 7.7 2.8 6.7 2.0 virginica # 124 6.3 2.7 4.9 1.8 virginica # 125 6.7 3.3 5.7 2.1 virginica # 126 7.2 3.2 6.0 1.8 virginica # 127 6.2 2.8 4.8 1.8 virginica # 128 6.1 3.0 4.9 1.8 virginica # 129 6.4 2.8 5.6 2.1 virginica # 130 7.2 3.0 5.8 1.6 virginica # 131 7.4 2.8 6.1 1.9 virginica # 132 7.9 3.8 6.4 2.0 virginica # 133 6.4 2.8 5.6 2.2 virginica # 134 6.3 2.8 5.1 1.5 virginica # 135 6.1 2.6 5.6 1.4 virginica # 136 7.7 3.0 6.1 2.3 virginica # 137 6.3 3.4 5.6 2.4 virginica # 138 6.4 3.1 5.5 1.8 virginica # 139 6.0 3.0 4.8 1.8 virginica # 140 6.9 3.1 5.4 2.1 virginica # 141 6.7 3.1 5.6 2.4 virginica # 142 6.9 3.1 5.1 2.3 virginica # 143 5.8 2.7 5.1 1.9 virginica # 144 6.8 3.2 5.9 2.3 virginica # 145 6.7 3.3 5.7 2.5 virginica # 146 6.7 3.0 5.2 2.3 virginica # 147 6.3 2.5 5.0 1.9 virginica # 148 6.5 3.0 5.2 2.0 virginica # 149 6.2 3.4 5.4 2.3 virginica # 150 5.9 3.0 5.1 1.8 virginica |
iris[iris$Species %in% iris_select, ] # Lookup # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa # 7 4.6 3.4 1.4 0.3 setosa # 8 5.0 3.4 1.5 0.2 setosa # 9 4.4 2.9 1.4 0.2 setosa # 10 4.9 3.1 1.5 0.1 setosa # 11 5.4 3.7 1.5 0.2 setosa # 12 4.8 3.4 1.6 0.2 setosa # 13 4.8 3.0 1.4 0.1 setosa # 14 4.3 3.0 1.1 0.1 setosa # 15 5.8 4.0 1.2 0.2 setosa # 16 5.7 4.4 1.5 0.4 setosa # 17 5.4 3.9 1.3 0.4 setosa # 18 5.1 3.5 1.4 0.3 setosa # 19 5.7 3.8 1.7 0.3 setosa # 20 5.1 3.8 1.5 0.3 setosa # 21 5.4 3.4 1.7 0.2 setosa # 22 5.1 3.7 1.5 0.4 setosa # 23 4.6 3.6 1.0 0.2 setosa # 24 5.1 3.3 1.7 0.5 setosa # 25 4.8 3.4 1.9 0.2 setosa # 26 5.0 3.0 1.6 0.2 setosa # 27 5.0 3.4 1.6 0.4 setosa # 28 5.2 3.5 1.5 0.2 setosa # 29 5.2 3.4 1.4 0.2 setosa # 30 4.7 3.2 1.6 0.2 setosa # 31 4.8 3.1 1.6 0.2 setosa # 32 5.4 3.4 1.5 0.4 setosa # 33 5.2 4.1 1.5 0.1 setosa # 34 5.5 4.2 1.4 0.2 setosa # 35 4.9 3.1 1.5 0.2 setosa # 36 5.0 3.2 1.2 0.2 setosa # 37 5.5 3.5 1.3 0.2 setosa # 38 4.9 3.6 1.4 0.1 setosa # 39 4.4 3.0 1.3 0.2 setosa # 40 5.1 3.4 1.5 0.2 setosa # 41 5.0 3.5 1.3 0.3 setosa # 42 4.5 2.3 1.3 0.3 setosa # 43 4.4 3.2 1.3 0.2 setosa # 44 5.0 3.5 1.6 0.6 setosa # 45 5.1 3.8 1.9 0.4 setosa # 46 4.8 3.0 1.4 0.3 setosa # 47 5.1 3.8 1.6 0.2 setosa # 48 4.6 3.2 1.4 0.2 setosa # 49 5.3 3.7 1.5 0.2 setosa # 50 5.0 3.3 1.4 0.2 setosa # 101 6.3 3.3 6.0 2.5 virginica # 102 5.8 2.7 5.1 1.9 virginica # 103 7.1 3.0 5.9 2.1 virginica # 104 6.3 2.9 5.6 1.8 virginica # 105 6.5 3.0 5.8 2.2 virginica # 106 7.6 3.0 6.6 2.1 virginica # 107 4.9 2.5 4.5 1.7 virginica # 108 7.3 2.9 6.3 1.8 virginica # 109 6.7 2.5 5.8 1.8 virginica # 110 7.2 3.6 6.1 2.5 virginica # 111 6.5 3.2 5.1 2.0 virginica # 112 6.4 2.7 5.3 1.9 virginica # 113 6.8 3.0 5.5 2.1 virginica # 114 5.7 2.5 5.0 2.0 virginica # 115 5.8 2.8 5.1 2.4 virginica # 116 6.4 3.2 5.3 2.3 virginica # 117 6.5 3.0 5.5 1.8 virginica # 118 7.7 3.8 6.7 2.2 virginica # 119 7.7 2.6 6.9 2.3 virginica # 120 6.0 2.2 5.0 1.5 virginica # 121 6.9 3.2 5.7 2.3 virginica # 122 5.6 2.8 4.9 2.0 virginica # 123 7.7 2.8 6.7 2.0 virginica # 124 6.3 2.7 4.9 1.8 virginica # 125 6.7 3.3 5.7 2.1 virginica # 126 7.2 3.2 6.0 1.8 virginica # 127 6.2 2.8 4.8 1.8 virginica # 128 6.1 3.0 4.9 1.8 virginica # 129 6.4 2.8 5.6 2.1 virginica # 130 7.2 3.0 5.8 1.6 virginica # 131 7.4 2.8 6.1 1.9 virginica # 132 7.9 3.8 6.4 2.0 virginica # 133 6.4 2.8 5.6 2.2 virginica # 134 6.3 2.8 5.1 1.5 virginica # 135 6.1 2.6 5.6 1.4 virginica # 136 7.7 3.0 6.1 2.3 virginica # 137 6.3 3.4 5.6 2.4 virginica # 138 6.4 3.1 5.5 1.8 virginica # 139 6.0 3.0 4.8 1.8 virginica # 140 6.9 3.1 5.4 2.1 virginica # 141 6.7 3.1 5.6 2.4 virginica # 142 6.9 3.1 5.1 2.3 virginica # 143 5.8 2.7 5.1 1.9 virginica # 144 6.8 3.2 5.9 2.3 virginica # 145 6.7 3.3 5.7 2.5 virginica # 146 6.7 3.0 5.2 2.3 virginica # 147 6.3 2.5 5.0 1.9 virginica # 148 6.5 3.0 5.2 2.0 virginica # 149 6.2 3.4 5.4 2.3 virginica # 150 5.9 3.0 5.1 1.8 virginica