lgb.prepare_rules2.R 5.38 KB
Newer Older
1
2
3
4
5
6
7
8
#' @name lgb.prepare_rules2
#' @title Data preparator for LightGBM datasets with rules (integer)
#' @description Attempts to prepare a clean dataset to prepare to put in a \code{lgb.Dataset}.
#'              Factors and characters are converted to numeric (specifically: integer).
#'              In addition, keeps rules created so you can convert other datasets using this converter.
#'              This is useful if you have a specific need for integer dataset instead of numeric dataset.
#'              Note that there are programs which do not support integer-only input.
#'              Consider this as a half memory technique which is dangerous, especially for LightGBM.
James Lamb's avatar
James Lamb committed
9
10
#' @param data A data.frame or data.table to prepare.
#' @param rules A set of rules from the data preparator, if already used.
11
12
13
#' @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}.
14
#'
James Lamb's avatar
James Lamb committed
15
16
17
#' @examples
#' library(lightgbm)
#' data(iris)
18
#'
James Lamb's avatar
James Lamb committed
19
#' str(iris)
20
#'
James Lamb's avatar
James Lamb committed
21
22
#' new_iris <- lgb.prepare_rules2(data = iris) # Autoconverter
#' str(new_iris$data)
23
#'
James Lamb's avatar
James Lamb committed
24
#' data(iris) # Erase iris dataset
25
#' iris$Species[1L] <- "NEW FACTOR" # Introduce junk factor (NA)
26
#'
James Lamb's avatar
James Lamb committed
27
28
29
#' # Use conversion using known rules
#' # Unknown factors become 0, excellent for sparse datasets
#' newer_iris <- lgb.prepare_rules2(data = iris, rules = new_iris$rules)
30
#'
James Lamb's avatar
James Lamb committed
31
#' # Unknown factor is now zero, perfect for sparse datasets
32
#' newer_iris$data[1L, ] # Species became 0 as it is an unknown factor
33
#'
34
#' newer_iris$data[1L, 5L] <- 1.0 # Put back real initial value
35
#'
James Lamb's avatar
James Lamb committed
36
37
#' # Is the newly created dataset equal? YES!
#' all.equal(new_iris$data, newer_iris$data)
38
#'
James Lamb's avatar
James Lamb committed
39
40
#' # Can we test our own rules?
#' data(iris) # Erase iris dataset
41
#'
James Lamb's avatar
James Lamb committed
42
#' # We remapped values differently
43
44
45
46
#' personal_rules <- list(
#'   Species = c(
#'     "setosa" = 3L
#'     , "versicolor" = 2L
47
#'     , "virginica" = 1L
48
49
#'   )
#' )
James Lamb's avatar
James Lamb committed
50
51
#' newest_iris <- lgb.prepare_rules2(data = iris, rules = personal_rules)
#' str(newest_iris$data) # SUCCESS!
52
#'
James Lamb's avatar
James Lamb committed
53
54
55
#' @importFrom data.table set
#' @export
lgb.prepare_rules2 <- function(data, rules = NULL) {
56

James Lamb's avatar
James Lamb committed
57
58
  # data.table not behaving like data.frame
  if (inherits(data, "data.table")) {
59

James Lamb's avatar
James Lamb committed
60
61
    # Must use existing rules
    if (!is.null(rules)) {
62

James Lamb's avatar
James Lamb committed
63
64
      # Loop through rules
      for (i in names(rules)) {
65

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

James Lamb's avatar
James Lamb committed
69
      }
70

James Lamb's avatar
James Lamb committed
71
    } else {
72

James Lamb's avatar
James Lamb committed
73
      # Get data classes
74
      list_classes <- vapply(data, class, character(1L))
75

James Lamb's avatar
James Lamb committed
76
77
78
      # Map characters/factors
      is_fix <- which(list_classes %in% c("character", "factor"))
      rules <- list()
79

James Lamb's avatar
James Lamb committed
80
      # Need to create rules?
81
      if (length(is_fix) > 0L) {
82

James Lamb's avatar
James Lamb committed
83
84
        # Go through all characters/factors
        for (i in is_fix) {
85

James Lamb's avatar
James Lamb committed
86
87
          # Store column elsewhere
          mini_data <- data[[i]]
88

James Lamb's avatar
James Lamb committed
89
90
91
92
93
94
95
96
          # Get unique values
          if (is.factor(mini_data)) {
            mini_unique <- levels(mini_data) # Factor
            mini_numeric <- seq_along(mini_unique) # Respect ordinal if needed
          } else {
            mini_unique <- as.factor(unique(mini_data)) # Character
            mini_numeric <- as.integer(mini_unique) # No respect of ordinality
          }
97

James Lamb's avatar
James Lamb committed
98
99
100
101
          # Create rules
          indexed <- colnames(data)[i] # Index value
          rules[[indexed]] <- mini_numeric # Numeric content
          names(rules[[indexed]]) <- mini_unique # Character equivalent
102

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

James Lamb's avatar
James Lamb committed
106
        }
107

James Lamb's avatar
James Lamb committed
108
      }
109

James Lamb's avatar
James Lamb committed
110
111
112
    }

  } else {
113

James Lamb's avatar
James Lamb committed
114
115
    # Must use existing rules
    if (!is.null(rules)) {
116

James Lamb's avatar
James Lamb committed
117
118
      # Loop through rules
      for (i in names(rules)) {
119

James Lamb's avatar
James Lamb committed
120
121
        data[[i]] <- unname(rules[[i]][data[[i]]])
        data[[i]][is.na(data[[i]])] <- 0L # Overwrite NAs by 0s as integer
122

James Lamb's avatar
James Lamb committed
123
      }
124

James Lamb's avatar
James Lamb committed
125
    } else {
126

James Lamb's avatar
James Lamb committed
127
128
      # Default routine (data.frame)
      if (inherits(data, "data.frame")) {
129

James Lamb's avatar
James Lamb committed
130
        # Get data classes
131
        list_classes <- vapply(data, class, character(1L))
132

James Lamb's avatar
James Lamb committed
133
134
135
        # Map characters/factors
        is_fix <- which(list_classes %in% c("character", "factor"))
        rules <- list()
136

James Lamb's avatar
James Lamb committed
137
        # Need to create rules?
138
        if (length(is_fix) > 0L) {
139

James Lamb's avatar
James Lamb committed
140
141
          # Go through all characters/factors
          for (i in is_fix) {
142

James Lamb's avatar
James Lamb committed
143
144
            # Store column elsewhere
            mini_data <- data[[i]]
145

James Lamb's avatar
James Lamb committed
146
147
148
149
150
151
152
153
            # Get unique values
            if (is.factor(mini_data)) {
              mini_unique <- levels(mini_data) # Factor
              mini_numeric <- seq_along(mini_unique) # Respect ordinal if needed
            } else {
              mini_unique <- as.factor(unique(mini_data)) # Character
              mini_numeric <- as.integer(mini_unique) # No respect of ordinality
            }
154

James Lamb's avatar
James Lamb committed
155
156
157
158
            # Create rules
            indexed <- colnames(data)[i] # Index value
            rules[[indexed]] <- mini_numeric # Numeric content
            names(rules[[indexed]]) <- mini_unique # Character equivalent
159

James Lamb's avatar
James Lamb committed
160
161
            # Apply to real data column
            data[[i]] <- unname(rules[[indexed]][mini_data])
162

James Lamb's avatar
James Lamb committed
163
          }
164

James Lamb's avatar
James Lamb committed
165
        }
166

James Lamb's avatar
James Lamb committed
167
      } else {
168

169
        stop(
170
          "lgb.prepare_rules2: you provided "
171
172
173
          , paste(class(data), collapse = " & ")
          , " but data should have class data.frame"
        )
174

James Lamb's avatar
James Lamb committed
175
      }
176

James Lamb's avatar
James Lamb committed
177
    }
178

James Lamb's avatar
James Lamb committed
179
  }
180

James Lamb's avatar
James Lamb committed
181
  return(list(data = data, rules = rules))
182

James Lamb's avatar
James Lamb committed
183
}