lgb.prepare_rules2.R 5.28 KB
Newer Older
James Lamb's avatar
James Lamb committed
1
2
#' Data preparator for LightGBM datasets with rules (integer)
#'
Nikita Titov's avatar
Nikita Titov committed
3
#' 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.
4
#'
James Lamb's avatar
James Lamb committed
5
6
#' @param data A data.frame or data.table to prepare.
#' @param rules A set of rules from the data preparator, if already used.
7
#'
Nikita Titov's avatar
Nikita Titov committed
8
#' @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}.
9
#'
James Lamb's avatar
James Lamb committed
10
11
12
#' @examples
#' library(lightgbm)
#' data(iris)
13
#'
James Lamb's avatar
James Lamb committed
14
#' str(iris)
15
#'
James Lamb's avatar
James Lamb committed
16
17
#' new_iris <- lgb.prepare_rules2(data = iris) # Autoconverter
#' str(new_iris$data)
18
#'
James Lamb's avatar
James Lamb committed
19
20
#' data(iris) # Erase iris dataset
#' iris$Species[1] <- "NEW FACTOR" # Introduce junk factor (NA)
21
#'
James Lamb's avatar
James Lamb committed
22
23
24
#' # Use conversion using known rules
#' # Unknown factors become 0, excellent for sparse datasets
#' newer_iris <- lgb.prepare_rules2(data = iris, rules = new_iris$rules)
25
#'
James Lamb's avatar
James Lamb committed
26
27
#' # Unknown factor is now zero, perfect for sparse datasets
#' newer_iris$data[1, ] # Species became 0 as it is an unknown factor
28
#'
James Lamb's avatar
James Lamb committed
29
#' newer_iris$data[1, 5] <- 1 # Put back real initial value
30
#'
James Lamb's avatar
James Lamb committed
31
32
#' # Is the newly created dataset equal? YES!
#' all.equal(new_iris$data, newer_iris$data)
33
#'
James Lamb's avatar
James Lamb committed
34
35
#' # Can we test our own rules?
#' data(iris) # Erase iris dataset
36
#'
James Lamb's avatar
James Lamb committed
37
38
39
40
41
42
#' # We remapped values differently
#' personal_rules <- list(Species = c("setosa" = 3L,
#'                                    "versicolor" = 2L,
#'                                    "virginica" = 1L))
#' newest_iris <- lgb.prepare_rules2(data = iris, rules = personal_rules)
#' str(newest_iris$data) # SUCCESS!
43
#'
James Lamb's avatar
James Lamb committed
44
45
46
#' @importFrom data.table set
#' @export
lgb.prepare_rules2 <- function(data, rules = NULL) {
47

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

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

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

James Lamb's avatar
James Lamb committed
57
58
        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
59

James Lamb's avatar
James Lamb committed
60
      }
61

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

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

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

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

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

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

James Lamb's avatar
James Lamb committed
80
81
82
83
84
85
86
87
          # 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
          }
88

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

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

James Lamb's avatar
James Lamb committed
97
        }
98

James Lamb's avatar
James Lamb committed
99
      }
100

James Lamb's avatar
James Lamb committed
101
102
103
    }

  } else {
104

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

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

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

James Lamb's avatar
James Lamb committed
114
      }
115

James Lamb's avatar
James Lamb committed
116
    } else {
117

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

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

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

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

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

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

James Lamb's avatar
James Lamb committed
137
138
139
140
141
142
143
144
            # 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
            }
145

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

James Lamb's avatar
James Lamb committed
151
152
            # Apply to real data column
            data[[i]] <- unname(rules[[indexed]][mini_data])
153

James Lamb's avatar
James Lamb committed
154
          }
155

James Lamb's avatar
James Lamb committed
156
        }
157

James Lamb's avatar
James Lamb committed
158
      } else {
159

James Lamb's avatar
James Lamb committed
160
161
        # What do you think you are doing here? Throw error.
        stop("lgb.prepare: you provided ", paste(class(data), collapse = " & "), " but data should have class data.frame")
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
  }
168

James Lamb's avatar
James Lamb committed
169
  return(list(data = data, rules = rules))
170

James Lamb's avatar
James Lamb committed
171
}