lgb.prepare_rules.R 5.22 KB
Newer Older
1
2
3
4
5
#' @name lgb.prepare_rules
#' @title Data preparator for LightGBM datasets with rules (numeric)
#' @description Attempts to prepare a clean dataset to prepare to put in a \code{lgb.Dataset}.
#'              Factors and characters are converted to numeric. In addition, keeps rules created
#'              so you can convert other datasets using this converter.
James Lamb's avatar
James Lamb committed
6
7
#' @param data A data.frame or data.table to prepare.
#' @param rules A set of rules from the data preparator, if already used.
8
9
10
#' @return A list with the cleaned dataset (\code{data}) and the rules (\code{rules}).
#'         The data must be converted to a matrix format (\code{as.matrix}) for input
#'         in \code{lgb.Dataset}.
11
#'
James Lamb's avatar
James Lamb committed
12
13
#' @examples
#' data(iris)
14
#'
James Lamb's avatar
James Lamb committed
15
#' str(iris)
16
#'
James Lamb's avatar
James Lamb committed
17
18
#' new_iris <- lgb.prepare_rules(data = iris) # Autoconverter
#' str(new_iris$data)
19
#'
James Lamb's avatar
James Lamb committed
20
#' data(iris) # Erase iris dataset
21
#' iris$Species[1L] <- "NEW FACTOR" # Introduce junk factor (NA)
22
#'
James Lamb's avatar
James Lamb committed
23
24
25
#' # Use conversion using known rules
#' # Unknown factors become 0, excellent for sparse datasets
#' newer_iris <- lgb.prepare_rules(data = iris, rules = new_iris$rules)
26
#'
James Lamb's avatar
James Lamb committed
27
#' # Unknown factor is now zero, perfect for sparse datasets
28
#' newer_iris$data[1L, ] # Species became 0 as it is an unknown factor
29
#'
30
#' newer_iris$data[1L, 5L] <- 1.0 # Put back real initial value
31
#'
James Lamb's avatar
James Lamb committed
32
33
#' # Is the newly created dataset equal? YES!
#' all.equal(new_iris$data, newer_iris$data)
34
#'
James Lamb's avatar
James Lamb committed
35
36
#' # Can we test our own rules?
#' data(iris) # Erase iris dataset
37
#'
James Lamb's avatar
James Lamb committed
38
#' # We remapped values differently
39
40
41
#' personal_rules <- list(Species = c("setosa" = 3L,
#'                                    "versicolor" = 2L,
#'                                    "virginica" = 1L))
James Lamb's avatar
James Lamb committed
42
43
#' newest_iris <- lgb.prepare_rules(data = iris, rules = personal_rules)
#' str(newest_iris$data) # SUCCESS!
44
#'
James Lamb's avatar
James Lamb committed
45
46
47
#' @importFrom data.table set
#' @export
lgb.prepare_rules <- function(data, rules = NULL) {
48

James Lamb's avatar
James Lamb committed
49
50
  # data.table not behaving like data.frame
  if (inherits(data, "data.table")) {
51

James Lamb's avatar
James Lamb committed
52
53
    # Must use existing rules
    if (!is.null(rules)) {
54

James Lamb's avatar
James Lamb committed
55
56
      # Loop through rules
      for (i in names(rules)) {
57

James Lamb's avatar
James Lamb committed
58
        data.table::set(data, j = i, value = unname(rules[[i]][data[[i]]]))
59
        data[[i]][is.na(data[[i]])] <- 0L # Overwrite NAs by 0s
60

James Lamb's avatar
James Lamb committed
61
      }
62

James Lamb's avatar
James Lamb committed
63
    } else {
64

James Lamb's avatar
James Lamb committed
65
      # Get data classes
66
      list_classes <- vapply(data, class, character(1L))
67

James Lamb's avatar
James Lamb committed
68
69
70
      # Map characters/factors
      is_fix <- which(list_classes %in% c("character", "factor"))
      rules <- list()
71

James Lamb's avatar
James Lamb committed
72
      # Need to create rules?
73
      if (length(is_fix) > 0L) {
74

James Lamb's avatar
James Lamb committed
75
76
        # Go through all characters/factors
        for (i in is_fix) {
77

James Lamb's avatar
James Lamb committed
78
79
          # Store column elsewhere
          mini_data <- data[[i]]
80

James Lamb's avatar
James Lamb committed
81
82
83
84
85
86
87
88
89
          # Get unique values
          if (is.factor(mini_data)) {
            mini_unique <- levels(mini_data) # Factor
            mini_numeric <- numeric(length(mini_unique))
            mini_numeric[seq_along(mini_unique)] <- seq_along(mini_unique) # Respect ordinal if needed
          } else {
            mini_unique <- as.factor(unique(mini_data)) # Character
            mini_numeric <- as.numeric(mini_unique) # No respect of ordinality
          }
90

James Lamb's avatar
James Lamb committed
91
92
93
94
          # Create rules
          indexed <- colnames(data)[i] # Index value
          rules[[indexed]] <- mini_numeric # Numeric content
          names(rules[[indexed]]) <- mini_unique # Character equivalent
95

James Lamb's avatar
James Lamb committed
96
97
          # Apply to real data column
          data.table::set(data, j = i, value = unname(rules[[indexed]][mini_data]))
98

James Lamb's avatar
James Lamb committed
99
        }
100

James Lamb's avatar
James Lamb committed
101
      }
102

James Lamb's avatar
James Lamb committed
103
    }
104

James Lamb's avatar
James Lamb committed
105
  } else {
106

James Lamb's avatar
James Lamb committed
107
108
    # Must use existing rules
    if (!is.null(rules)) {
109

James Lamb's avatar
James Lamb committed
110
111
      # Loop through rules
      for (i in names(rules)) {
112

James Lamb's avatar
James Lamb committed
113
        data[[i]] <- unname(rules[[i]][data[[i]]])
114
        data[[i]][is.na(data[[i]])] <- 0L # Overwrite NAs by 0s
115

James Lamb's avatar
James Lamb committed
116
      }
117

James Lamb's avatar
James Lamb committed
118
    } else {
119

James Lamb's avatar
James Lamb committed
120
121
      # Default routine (data.frame)
      if (inherits(data, "data.frame")) {
122

James Lamb's avatar
James Lamb committed
123
        # Get data classes
124
        list_classes <- vapply(data, class, character(1L))
125

James Lamb's avatar
James Lamb committed
126
127
128
        # Map characters/factors
        is_fix <- which(list_classes %in% c("character", "factor"))
        rules <- list()
129

James Lamb's avatar
James Lamb committed
130
        # Need to create rules?
131
        if (length(is_fix) > 0L) {
132

James Lamb's avatar
James Lamb committed
133
134
          # Go through all characters/factors
          for (i in is_fix) {
135

James Lamb's avatar
James Lamb committed
136
137
            # Store column elsewhere
            mini_data <- data[[i]]
138

James Lamb's avatar
James Lamb committed
139
140
141
142
143
144
145
146
147
            # Get unique values
            if (is.factor(mini_data)) {
              mini_unique <- levels(mini_data) # Factor
              mini_numeric <- numeric(length(mini_unique))
              mini_numeric[seq_along(mini_unique)] <- seq_along(mini_unique) # Respect ordinal if needed
            } else {
              mini_unique <- as.factor(unique(mini_data)) # Character
              mini_numeric <- as.numeric(mini_unique) # No respect of ordinality
            }
148

James Lamb's avatar
James Lamb committed
149
150
151
152
            # Create rules
            indexed <- colnames(data)[i] # Index value
            rules[[indexed]] <- mini_numeric # Numeric content
            names(rules[[indexed]]) <- mini_unique # Character equivalent
153

James Lamb's avatar
James Lamb committed
154
155
            # Apply to real data column
            data[[i]] <- unname(rules[[indexed]][mini_data])
156

James Lamb's avatar
James Lamb committed
157
          }
158

James Lamb's avatar
James Lamb committed
159
        }
160

James Lamb's avatar
James Lamb committed
161
      } else {
162

163
        stop(
164
          "lgb.prepare_rules: you provided "
165
166
167
          , paste(class(data), collapse = " & ")
          , " but data should have class data.frame"
        )
168

James Lamb's avatar
James Lamb committed
169
      }
170

James Lamb's avatar
James Lamb committed
171
    }
172

James Lamb's avatar
James Lamb committed
173
  }
174

James Lamb's avatar
James Lamb committed
175
  return(list(data = data, rules = rules))
176

James Lamb's avatar
James Lamb committed
177
}