Functions for creating new columns or modifying existing columns in a data
frame. These are SciViews::R versions of tidyverse functions with standard
evaluation and formula-based non-standard evaluation (ending with underscore
_). They work with data.frame, data.table, and tibbles.
Functions:
mutate_()- Add new columns or modify existing onestransmute_()- Create new columns and drop all others
mutate_(
.data = (.),
...,
.by = NULL,
.keep = "all",
.before = NULL,
.after = NULL,
.cols = NULL
)
transmute_(.data, ...)Arguments
- .data
A data frame (data.frame, data.table, or tibble)
- ...
Name-value pairs specifying new columns or modifications. Names are column names; values are expressions to compute. Use formulas for non-standard evaluation (e.g.,
new_col = ~mean(old_col)), or provide character names and expressions for standard evaluation. New columns can refer to columns just created. Within formulas, you can provide column names use like this:'new_col_name' ~ median(old_col). You can also use the name of an object that contains the column name. For instance,col_names <- c("new_col1", "new_col2"), then inmutate_(), usecol_name[1] ~ median(old_col).- .by
Optional grouping variables for per-group computations. Provide as formulas (e.g.,
~group_col) or character names. Groups are temporary and not preserved in the output. Cannot be used with grouped data frames.- .keep
Control which columns to keep in the output:
"all"(default) - Keep all existing columns plus new ones"used"- Keep columns used to make new columns, and new columns"unused"- Keep columns not used to make new columns, and new columns. This is useful if you do not need the columns that are used to create the new ones."none"- Keep only new columns (same astransmute_())
- .before
Optional column name or position to place new columns before. Not yet implemented - use dplyr::mutate() instead.
- .after
Optional column name or position to place new columns after. Not yet implemented - use dplyr::mutate() instead.
- .cols
Optional character vector of column names to operate on. If provided, only these columns are modified or created.
Value
A data frame of the same type as .data with modified or new columns.
mutate_()returns all columns (by default), including new/modified onestransmute_()returns only the newly created columns
See also
Examples
library(svTidy)
data(mtcars)
# Create new columns using formulas
mtcars |> mutate_(hp_per_cyl = ~hp/cyl)
#> mpg cyl disp hp drat wt qsec vs am gear carb
#> Mazda RX4 21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4
#> Mazda RX4 Wag 21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4
#> Datsun 710 22.8 4 108.0 93 3.85 2.320 18.61 1 1 4 1
#> Hornet 4 Drive 21.4 6 258.0 110 3.08 3.215 19.44 1 0 3 1
#> Hornet Sportabout 18.7 8 360.0 175 3.15 3.440 17.02 0 0 3 2
#> Valiant 18.1 6 225.0 105 2.76 3.460 20.22 1 0 3 1
#> Duster 360 14.3 8 360.0 245 3.21 3.570 15.84 0 0 3 4
#> Merc 240D 24.4 4 146.7 62 3.69 3.190 20.00 1 0 4 2
#> Merc 230 22.8 4 140.8 95 3.92 3.150 22.90 1 0 4 2
#> Merc 280 19.2 6 167.6 123 3.92 3.440 18.30 1 0 4 4
#> Merc 280C 17.8 6 167.6 123 3.92 3.440 18.90 1 0 4 4
#> Merc 450SE 16.4 8 275.8 180 3.07 4.070 17.40 0 0 3 3
#> Merc 450SL 17.3 8 275.8 180 3.07 3.730 17.60 0 0 3 3
#> Merc 450SLC 15.2 8 275.8 180 3.07 3.780 18.00 0 0 3 3
#> Cadillac Fleetwood 10.4 8 472.0 205 2.93 5.250 17.98 0 0 3 4
#> Lincoln Continental 10.4 8 460.0 215 3.00 5.424 17.82 0 0 3 4
#> Chrysler Imperial 14.7 8 440.0 230 3.23 5.345 17.42 0 0 3 4
#> Fiat 128 32.4 4 78.7 66 4.08 2.200 19.47 1 1 4 1
#> Honda Civic 30.4 4 75.7 52 4.93 1.615 18.52 1 1 4 2
#> Toyota Corolla 33.9 4 71.1 65 4.22 1.835 19.90 1 1 4 1
#> Toyota Corona 21.5 4 120.1 97 3.70 2.465 20.01 1 0 3 1
#> Dodge Challenger 15.5 8 318.0 150 2.76 3.520 16.87 0 0 3 2
#> AMC Javelin 15.2 8 304.0 150 3.15 3.435 17.30 0 0 3 2
#> Camaro Z28 13.3 8 350.0 245 3.73 3.840 15.41 0 0 3 4
#> Pontiac Firebird 19.2 8 400.0 175 3.08 3.845 17.05 0 0 3 2
#> Fiat X1-9 27.3 4 79.0 66 4.08 1.935 18.90 1 1 4 1
#> Porsche 914-2 26.0 4 120.3 91 4.43 2.140 16.70 0 1 5 2
#> Lotus Europa 30.4 4 95.1 113 3.77 1.513 16.90 1 1 5 2
#> Ford Pantera L 15.8 8 351.0 264 4.22 3.170 14.50 0 1 5 4
#> Ferrari Dino 19.7 6 145.0 175 3.62 2.770 15.50 0 1 5 6
#> Maserati Bora 15.0 8 301.0 335 3.54 3.570 14.60 0 1 5 8
#> Volvo 142E 21.4 4 121.0 109 4.11 2.780 18.60 1 1 4 2
#> hp_per_cyl
#> Mazda RX4 18.33333
#> Mazda RX4 Wag 18.33333
#> Datsun 710 23.25000
#> Hornet 4 Drive 18.33333
#> Hornet Sportabout 21.87500
#> Valiant 17.50000
#> Duster 360 30.62500
#> Merc 240D 15.50000
#> Merc 230 23.75000
#> Merc 280 20.50000
#> Merc 280C 20.50000
#> Merc 450SE 22.50000
#> Merc 450SL 22.50000
#> Merc 450SLC 22.50000
#> Cadillac Fleetwood 25.62500
#> Lincoln Continental 26.87500
#> Chrysler Imperial 28.75000
#> Fiat 128 16.50000
#> Honda Civic 13.00000
#> Toyota Corolla 16.25000
#> Toyota Corona 24.25000
#> Dodge Challenger 18.75000
#> AMC Javelin 18.75000
#> Camaro Z28 30.62500
#> Pontiac Firebird 21.87500
#> Fiat X1-9 16.50000
#> Porsche 914-2 22.75000
#> Lotus Europa 28.25000
#> Ford Pantera L 33.00000
#> Ferrari Dino 29.16667
#> Maserati Bora 41.87500
#> Volvo 142E 27.25000
# Multiple new columns
mtcars |>
mutate_(
hp_per_cyl = ~hp/cyl,
wt_kg = ~wt * 453.592
)
#> mpg cyl disp hp drat wt qsec vs am gear carb
#> Mazda RX4 21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4
#> Mazda RX4 Wag 21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4
#> Datsun 710 22.8 4 108.0 93 3.85 2.320 18.61 1 1 4 1
#> Hornet 4 Drive 21.4 6 258.0 110 3.08 3.215 19.44 1 0 3 1
#> Hornet Sportabout 18.7 8 360.0 175 3.15 3.440 17.02 0 0 3 2
#> Valiant 18.1 6 225.0 105 2.76 3.460 20.22 1 0 3 1
#> Duster 360 14.3 8 360.0 245 3.21 3.570 15.84 0 0 3 4
#> Merc 240D 24.4 4 146.7 62 3.69 3.190 20.00 1 0 4 2
#> Merc 230 22.8 4 140.8 95 3.92 3.150 22.90 1 0 4 2
#> Merc 280 19.2 6 167.6 123 3.92 3.440 18.30 1 0 4 4
#> Merc 280C 17.8 6 167.6 123 3.92 3.440 18.90 1 0 4 4
#> Merc 450SE 16.4 8 275.8 180 3.07 4.070 17.40 0 0 3 3
#> Merc 450SL 17.3 8 275.8 180 3.07 3.730 17.60 0 0 3 3
#> Merc 450SLC 15.2 8 275.8 180 3.07 3.780 18.00 0 0 3 3
#> Cadillac Fleetwood 10.4 8 472.0 205 2.93 5.250 17.98 0 0 3 4
#> Lincoln Continental 10.4 8 460.0 215 3.00 5.424 17.82 0 0 3 4
#> Chrysler Imperial 14.7 8 440.0 230 3.23 5.345 17.42 0 0 3 4
#> Fiat 128 32.4 4 78.7 66 4.08 2.200 19.47 1 1 4 1
#> Honda Civic 30.4 4 75.7 52 4.93 1.615 18.52 1 1 4 2
#> Toyota Corolla 33.9 4 71.1 65 4.22 1.835 19.90 1 1 4 1
#> Toyota Corona 21.5 4 120.1 97 3.70 2.465 20.01 1 0 3 1
#> Dodge Challenger 15.5 8 318.0 150 2.76 3.520 16.87 0 0 3 2
#> AMC Javelin 15.2 8 304.0 150 3.15 3.435 17.30 0 0 3 2
#> Camaro Z28 13.3 8 350.0 245 3.73 3.840 15.41 0 0 3 4
#> Pontiac Firebird 19.2 8 400.0 175 3.08 3.845 17.05 0 0 3 2
#> Fiat X1-9 27.3 4 79.0 66 4.08 1.935 18.90 1 1 4 1
#> Porsche 914-2 26.0 4 120.3 91 4.43 2.140 16.70 0 1 5 2
#> Lotus Europa 30.4 4 95.1 113 3.77 1.513 16.90 1 1 5 2
#> Ford Pantera L 15.8 8 351.0 264 4.22 3.170 14.50 0 1 5 4
#> Ferrari Dino 19.7 6 145.0 175 3.62 2.770 15.50 0 1 5 6
#> Maserati Bora 15.0 8 301.0 335 3.54 3.570 14.60 0 1 5 8
#> Volvo 142E 21.4 4 121.0 109 4.11 2.780 18.60 1 1 4 2
#> hp_per_cyl wt_kg
#> Mazda RX4 18.33333 1188.4110
#> Mazda RX4 Wag 18.33333 1304.0770
#> Datsun 710 23.25000 1052.3334
#> Hornet 4 Drive 18.33333 1458.2983
#> Hornet Sportabout 21.87500 1560.3565
#> Valiant 17.50000 1569.4283
#> Duster 360 30.62500 1619.3234
#> Merc 240D 15.50000 1446.9585
#> Merc 230 23.75000 1428.8148
#> Merc 280 20.50000 1560.3565
#> Merc 280C 20.50000 1560.3565
#> Merc 450SE 22.50000 1846.1194
#> Merc 450SL 22.50000 1691.8982
#> Merc 450SLC 22.50000 1714.5778
#> Cadillac Fleetwood 25.62500 2381.3580
#> Lincoln Continental 26.87500 2460.2830
#> Chrysler Imperial 28.75000 2424.4492
#> Fiat 128 16.50000 997.9024
#> Honda Civic 13.00000 732.5511
#> Toyota Corolla 16.25000 832.3413
#> Toyota Corona 24.25000 1118.1043
#> Dodge Challenger 18.75000 1596.6438
#> AMC Javelin 18.75000 1558.0885
#> Camaro Z28 30.62500 1741.7933
#> Pontiac Firebird 21.87500 1744.0612
#> Fiat X1-9 16.50000 877.7005
#> Porsche 914-2 22.75000 970.6869
#> Lotus Europa 28.25000 686.2847
#> Ford Pantera L 33.00000 1437.8866
#> Ferrari Dino 29.16667 1256.4498
#> Maserati Bora 41.87500 1619.3234
#> Volvo 142E 27.25000 1260.9858
# Modify existing column
mtcars |> mutate_(mpg = ~mpg * 1.5)
#> mpg cyl disp hp drat wt qsec vs am gear carb
#> Mazda RX4 31.50 6 160.0 110 3.90 2.620 16.46 0 1 4 4
#> Mazda RX4 Wag 31.50 6 160.0 110 3.90 2.875 17.02 0 1 4 4
#> Datsun 710 34.20 4 108.0 93 3.85 2.320 18.61 1 1 4 1
#> Hornet 4 Drive 32.10 6 258.0 110 3.08 3.215 19.44 1 0 3 1
#> Hornet Sportabout 28.05 8 360.0 175 3.15 3.440 17.02 0 0 3 2
#> Valiant 27.15 6 225.0 105 2.76 3.460 20.22 1 0 3 1
#> Duster 360 21.45 8 360.0 245 3.21 3.570 15.84 0 0 3 4
#> Merc 240D 36.60 4 146.7 62 3.69 3.190 20.00 1 0 4 2
#> Merc 230 34.20 4 140.8 95 3.92 3.150 22.90 1 0 4 2
#> Merc 280 28.80 6 167.6 123 3.92 3.440 18.30 1 0 4 4
#> Merc 280C 26.70 6 167.6 123 3.92 3.440 18.90 1 0 4 4
#> Merc 450SE 24.60 8 275.8 180 3.07 4.070 17.40 0 0 3 3
#> Merc 450SL 25.95 8 275.8 180 3.07 3.730 17.60 0 0 3 3
#> Merc 450SLC 22.80 8 275.8 180 3.07 3.780 18.00 0 0 3 3
#> Cadillac Fleetwood 15.60 8 472.0 205 2.93 5.250 17.98 0 0 3 4
#> Lincoln Continental 15.60 8 460.0 215 3.00 5.424 17.82 0 0 3 4
#> Chrysler Imperial 22.05 8 440.0 230 3.23 5.345 17.42 0 0 3 4
#> Fiat 128 48.60 4 78.7 66 4.08 2.200 19.47 1 1 4 1
#> Honda Civic 45.60 4 75.7 52 4.93 1.615 18.52 1 1 4 2
#> Toyota Corolla 50.85 4 71.1 65 4.22 1.835 19.90 1 1 4 1
#> Toyota Corona 32.25 4 120.1 97 3.70 2.465 20.01 1 0 3 1
#> Dodge Challenger 23.25 8 318.0 150 2.76 3.520 16.87 0 0 3 2
#> AMC Javelin 22.80 8 304.0 150 3.15 3.435 17.30 0 0 3 2
#> Camaro Z28 19.95 8 350.0 245 3.73 3.840 15.41 0 0 3 4
#> Pontiac Firebird 28.80 8 400.0 175 3.08 3.845 17.05 0 0 3 2
#> Fiat X1-9 40.95 4 79.0 66 4.08 1.935 18.90 1 1 4 1
#> Porsche 914-2 39.00 4 120.3 91 4.43 2.140 16.70 0 1 5 2
#> Lotus Europa 45.60 4 95.1 113 3.77 1.513 16.90 1 1 5 2
#> Ford Pantera L 23.70 8 351.0 264 4.22 3.170 14.50 0 1 5 4
#> Ferrari Dino 29.55 6 145.0 175 3.62 2.770 15.50 0 1 5 6
#> Maserati Bora 22.50 8 301.0 335 3.54 3.570 14.60 0 1 5 8
#> Volvo 142E 32.10 4 121.0 109 4.11 2.780 18.60 1 1 4 2
# Reference newly created columns
mtcars |>
mutate_(
hp_per_cyl = ~hp/cyl,
hp_per_cyl_scaled = ~hp_per_cyl * 100
)
#> mpg cyl disp hp drat wt qsec vs am gear carb
#> Mazda RX4 21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4
#> Mazda RX4 Wag 21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4
#> Datsun 710 22.8 4 108.0 93 3.85 2.320 18.61 1 1 4 1
#> Hornet 4 Drive 21.4 6 258.0 110 3.08 3.215 19.44 1 0 3 1
#> Hornet Sportabout 18.7 8 360.0 175 3.15 3.440 17.02 0 0 3 2
#> Valiant 18.1 6 225.0 105 2.76 3.460 20.22 1 0 3 1
#> Duster 360 14.3 8 360.0 245 3.21 3.570 15.84 0 0 3 4
#> Merc 240D 24.4 4 146.7 62 3.69 3.190 20.00 1 0 4 2
#> Merc 230 22.8 4 140.8 95 3.92 3.150 22.90 1 0 4 2
#> Merc 280 19.2 6 167.6 123 3.92 3.440 18.30 1 0 4 4
#> Merc 280C 17.8 6 167.6 123 3.92 3.440 18.90 1 0 4 4
#> Merc 450SE 16.4 8 275.8 180 3.07 4.070 17.40 0 0 3 3
#> Merc 450SL 17.3 8 275.8 180 3.07 3.730 17.60 0 0 3 3
#> Merc 450SLC 15.2 8 275.8 180 3.07 3.780 18.00 0 0 3 3
#> Cadillac Fleetwood 10.4 8 472.0 205 2.93 5.250 17.98 0 0 3 4
#> Lincoln Continental 10.4 8 460.0 215 3.00 5.424 17.82 0 0 3 4
#> Chrysler Imperial 14.7 8 440.0 230 3.23 5.345 17.42 0 0 3 4
#> Fiat 128 32.4 4 78.7 66 4.08 2.200 19.47 1 1 4 1
#> Honda Civic 30.4 4 75.7 52 4.93 1.615 18.52 1 1 4 2
#> Toyota Corolla 33.9 4 71.1 65 4.22 1.835 19.90 1 1 4 1
#> Toyota Corona 21.5 4 120.1 97 3.70 2.465 20.01 1 0 3 1
#> Dodge Challenger 15.5 8 318.0 150 2.76 3.520 16.87 0 0 3 2
#> AMC Javelin 15.2 8 304.0 150 3.15 3.435 17.30 0 0 3 2
#> Camaro Z28 13.3 8 350.0 245 3.73 3.840 15.41 0 0 3 4
#> Pontiac Firebird 19.2 8 400.0 175 3.08 3.845 17.05 0 0 3 2
#> Fiat X1-9 27.3 4 79.0 66 4.08 1.935 18.90 1 1 4 1
#> Porsche 914-2 26.0 4 120.3 91 4.43 2.140 16.70 0 1 5 2
#> Lotus Europa 30.4 4 95.1 113 3.77 1.513 16.90 1 1 5 2
#> Ford Pantera L 15.8 8 351.0 264 4.22 3.170 14.50 0 1 5 4
#> Ferrari Dino 19.7 6 145.0 175 3.62 2.770 15.50 0 1 5 6
#> Maserati Bora 15.0 8 301.0 335 3.54 3.570 14.60 0 1 5 8
#> Volvo 142E 21.4 4 121.0 109 4.11 2.780 18.60 1 1 4 2
#> hp_per_cyl hp_per_cyl_scaled
#> Mazda RX4 18.33333 1833.333
#> Mazda RX4 Wag 18.33333 1833.333
#> Datsun 710 23.25000 2325.000
#> Hornet 4 Drive 18.33333 1833.333
#> Hornet Sportabout 21.87500 2187.500
#> Valiant 17.50000 1750.000
#> Duster 360 30.62500 3062.500
#> Merc 240D 15.50000 1550.000
#> Merc 230 23.75000 2375.000
#> Merc 280 20.50000 2050.000
#> Merc 280C 20.50000 2050.000
#> Merc 450SE 22.50000 2250.000
#> Merc 450SL 22.50000 2250.000
#> Merc 450SLC 22.50000 2250.000
#> Cadillac Fleetwood 25.62500 2562.500
#> Lincoln Continental 26.87500 2687.500
#> Chrysler Imperial 28.75000 2875.000
#> Fiat 128 16.50000 1650.000
#> Honda Civic 13.00000 1300.000
#> Toyota Corolla 16.25000 1625.000
#> Toyota Corona 24.25000 2425.000
#> Dodge Challenger 18.75000 1875.000
#> AMC Javelin 18.75000 1875.000
#> Camaro Z28 30.62500 3062.500
#> Pontiac Firebird 21.87500 2187.500
#> Fiat X1-9 16.50000 1650.000
#> Porsche 914-2 22.75000 2275.000
#> Lotus Europa 28.25000 2825.000
#> Ford Pantera L 33.00000 3300.000
#> Ferrari Dino 29.16667 2916.667
#> Maserati Bora 41.87500 4187.500
#> Volvo 142E 27.25000 2725.000
# Use column name in a variable
col_name <- "power_ratio"
mtcars |> mutate_(col_name ~ hp/wt)
#> mpg cyl disp hp drat wt qsec vs am gear carb
#> Mazda RX4 21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4
#> Mazda RX4 Wag 21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4
#> Datsun 710 22.8 4 108.0 93 3.85 2.320 18.61 1 1 4 1
#> Hornet 4 Drive 21.4 6 258.0 110 3.08 3.215 19.44 1 0 3 1
#> Hornet Sportabout 18.7 8 360.0 175 3.15 3.440 17.02 0 0 3 2
#> Valiant 18.1 6 225.0 105 2.76 3.460 20.22 1 0 3 1
#> Duster 360 14.3 8 360.0 245 3.21 3.570 15.84 0 0 3 4
#> Merc 240D 24.4 4 146.7 62 3.69 3.190 20.00 1 0 4 2
#> Merc 230 22.8 4 140.8 95 3.92 3.150 22.90 1 0 4 2
#> Merc 280 19.2 6 167.6 123 3.92 3.440 18.30 1 0 4 4
#> Merc 280C 17.8 6 167.6 123 3.92 3.440 18.90 1 0 4 4
#> Merc 450SE 16.4 8 275.8 180 3.07 4.070 17.40 0 0 3 3
#> Merc 450SL 17.3 8 275.8 180 3.07 3.730 17.60 0 0 3 3
#> Merc 450SLC 15.2 8 275.8 180 3.07 3.780 18.00 0 0 3 3
#> Cadillac Fleetwood 10.4 8 472.0 205 2.93 5.250 17.98 0 0 3 4
#> Lincoln Continental 10.4 8 460.0 215 3.00 5.424 17.82 0 0 3 4
#> Chrysler Imperial 14.7 8 440.0 230 3.23 5.345 17.42 0 0 3 4
#> Fiat 128 32.4 4 78.7 66 4.08 2.200 19.47 1 1 4 1
#> Honda Civic 30.4 4 75.7 52 4.93 1.615 18.52 1 1 4 2
#> Toyota Corolla 33.9 4 71.1 65 4.22 1.835 19.90 1 1 4 1
#> Toyota Corona 21.5 4 120.1 97 3.70 2.465 20.01 1 0 3 1
#> Dodge Challenger 15.5 8 318.0 150 2.76 3.520 16.87 0 0 3 2
#> AMC Javelin 15.2 8 304.0 150 3.15 3.435 17.30 0 0 3 2
#> Camaro Z28 13.3 8 350.0 245 3.73 3.840 15.41 0 0 3 4
#> Pontiac Firebird 19.2 8 400.0 175 3.08 3.845 17.05 0 0 3 2
#> Fiat X1-9 27.3 4 79.0 66 4.08 1.935 18.90 1 1 4 1
#> Porsche 914-2 26.0 4 120.3 91 4.43 2.140 16.70 0 1 5 2
#> Lotus Europa 30.4 4 95.1 113 3.77 1.513 16.90 1 1 5 2
#> Ford Pantera L 15.8 8 351.0 264 4.22 3.170 14.50 0 1 5 4
#> Ferrari Dino 19.7 6 145.0 175 3.62 2.770 15.50 0 1 5 6
#> Maserati Bora 15.0 8 301.0 335 3.54 3.570 14.60 0 1 5 8
#> Volvo 142E 21.4 4 121.0 109 4.11 2.780 18.60 1 1 4 2
#> power_ratio
#> Mazda RX4 41.98473
#> Mazda RX4 Wag 38.26087
#> Datsun 710 40.08621
#> Hornet 4 Drive 34.21462
#> Hornet Sportabout 50.87209
#> Valiant 30.34682
#> Duster 360 68.62745
#> Merc 240D 19.43574
#> Merc 230 30.15873
#> Merc 280 35.75581
#> Merc 280C 35.75581
#> Merc 450SE 44.22604
#> Merc 450SL 48.25737
#> Merc 450SLC 47.61905
#> Cadillac Fleetwood 39.04762
#> Lincoln Continental 39.63864
#> Chrysler Imperial 43.03087
#> Fiat 128 30.00000
#> Honda Civic 32.19814
#> Toyota Corolla 35.42234
#> Toyota Corona 39.35091
#> Dodge Challenger 42.61364
#> AMC Javelin 43.66812
#> Camaro Z28 63.80208
#> Pontiac Firebird 45.51365
#> Fiat X1-9 34.10853
#> Porsche 914-2 42.52336
#> Lotus Europa 74.68605
#> Ford Pantera L 83.28076
#> Ferrari Dino 63.17690
#> Maserati Bora 93.83754
#> Volvo 142E 39.20863
# Group-wise computations with .by
mtcars |>
mutate_(
mpg_centered = ~mpg - mean(mpg),
.by = 'cyl'
)
#> mpg cyl disp hp drat wt qsec vs am gear carb
#> Mazda RX4 21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4
#> Mazda RX4 Wag 21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4
#> Datsun 710 22.8 4 108.0 93 3.85 2.320 18.61 1 1 4 1
#> Hornet 4 Drive 21.4 6 258.0 110 3.08 3.215 19.44 1 0 3 1
#> Hornet Sportabout 18.7 8 360.0 175 3.15 3.440 17.02 0 0 3 2
#> Valiant 18.1 6 225.0 105 2.76 3.460 20.22 1 0 3 1
#> Duster 360 14.3 8 360.0 245 3.21 3.570 15.84 0 0 3 4
#> Merc 240D 24.4 4 146.7 62 3.69 3.190 20.00 1 0 4 2
#> Merc 230 22.8 4 140.8 95 3.92 3.150 22.90 1 0 4 2
#> Merc 280 19.2 6 167.6 123 3.92 3.440 18.30 1 0 4 4
#> Merc 280C 17.8 6 167.6 123 3.92 3.440 18.90 1 0 4 4
#> Merc 450SE 16.4 8 275.8 180 3.07 4.070 17.40 0 0 3 3
#> Merc 450SL 17.3 8 275.8 180 3.07 3.730 17.60 0 0 3 3
#> Merc 450SLC 15.2 8 275.8 180 3.07 3.780 18.00 0 0 3 3
#> Cadillac Fleetwood 10.4 8 472.0 205 2.93 5.250 17.98 0 0 3 4
#> Lincoln Continental 10.4 8 460.0 215 3.00 5.424 17.82 0 0 3 4
#> Chrysler Imperial 14.7 8 440.0 230 3.23 5.345 17.42 0 0 3 4
#> Fiat 128 32.4 4 78.7 66 4.08 2.200 19.47 1 1 4 1
#> Honda Civic 30.4 4 75.7 52 4.93 1.615 18.52 1 1 4 2
#> Toyota Corolla 33.9 4 71.1 65 4.22 1.835 19.90 1 1 4 1
#> Toyota Corona 21.5 4 120.1 97 3.70 2.465 20.01 1 0 3 1
#> Dodge Challenger 15.5 8 318.0 150 2.76 3.520 16.87 0 0 3 2
#> AMC Javelin 15.2 8 304.0 150 3.15 3.435 17.30 0 0 3 2
#> Camaro Z28 13.3 8 350.0 245 3.73 3.840 15.41 0 0 3 4
#> Pontiac Firebird 19.2 8 400.0 175 3.08 3.845 17.05 0 0 3 2
#> Fiat X1-9 27.3 4 79.0 66 4.08 1.935 18.90 1 1 4 1
#> Porsche 914-2 26.0 4 120.3 91 4.43 2.140 16.70 0 1 5 2
#> Lotus Europa 30.4 4 95.1 113 3.77 1.513 16.90 1 1 5 2
#> Ford Pantera L 15.8 8 351.0 264 4.22 3.170 14.50 0 1 5 4
#> Ferrari Dino 19.7 6 145.0 175 3.62 2.770 15.50 0 1 5 6
#> Maserati Bora 15.0 8 301.0 335 3.54 3.570 14.60 0 1 5 8
#> Volvo 142E 21.4 4 121.0 109 4.11 2.780 18.60 1 1 4 2
#> mpg_centered
#> Mazda RX4 1.25714286
#> Mazda RX4 Wag 1.25714286
#> Datsun 710 -3.86363636
#> Hornet 4 Drive 1.65714286
#> Hornet Sportabout 3.60000000
#> Valiant -1.64285714
#> Duster 360 -0.80000000
#> Merc 240D -2.26363636
#> Merc 230 -3.86363636
#> Merc 280 -0.54285714
#> Merc 280C -1.94285714
#> Merc 450SE 1.30000000
#> Merc 450SL 2.20000000
#> Merc 450SLC 0.10000000
#> Cadillac Fleetwood -4.70000000
#> Lincoln Continental -4.70000000
#> Chrysler Imperial -0.40000000
#> Fiat 128 5.73636364
#> Honda Civic 3.73636364
#> Toyota Corolla 7.23636364
#> Toyota Corona -5.16363636
#> Dodge Challenger 0.40000000
#> AMC Javelin 0.10000000
#> Camaro Z28 -1.80000000
#> Pontiac Firebird 4.10000000
#> Fiat X1-9 0.63636364
#> Porsche 914-2 -0.66363636
#> Lotus Europa 3.73636364
#> Ford Pantera L 0.70000000
#> Ferrari Dino -0.04285714
#> Maserati Bora -0.10000000
#> Volvo 142E -5.26363636
# Multiple grouping variables
mtcars |>
mutate_(
hp_rank = ~rank(hp),
.by = c('cyl', 'gear')
)
#> mpg cyl disp hp drat wt qsec vs am gear carb hp_rank
#> Mazda RX4 21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4 1.5
#> Mazda RX4 Wag 21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4 1.5
#> Datsun 710 22.8 4 108.0 93 3.85 2.320 18.61 1 1 4 1 6.0
#> Hornet 4 Drive 21.4 6 258.0 110 3.08 3.215 19.44 1 0 3 1 2.0
#> Hornet Sportabout 18.7 8 360.0 175 3.15 3.440 17.02 0 0 3 2 3.5
#> Valiant 18.1 6 225.0 105 2.76 3.460 20.22 1 0 3 1 1.0
#> Duster 360 14.3 8 360.0 245 3.21 3.570 15.84 0 0 3 4 11.5
#> Merc 240D 24.4 4 146.7 62 3.69 3.190 20.00 1 0 4 2 2.0
#> Merc 230 22.8 4 140.8 95 3.92 3.150 22.90 1 0 4 2 7.0
#> Merc 280 19.2 6 167.6 123 3.92 3.440 18.30 1 0 4 4 3.5
#> Merc 280C 17.8 6 167.6 123 3.92 3.440 18.90 1 0 4 4 3.5
#> Merc 450SE 16.4 8 275.8 180 3.07 4.070 17.40 0 0 3 3 6.0
#> Merc 450SL 17.3 8 275.8 180 3.07 3.730 17.60 0 0 3 3 6.0
#> Merc 450SLC 15.2 8 275.8 180 3.07 3.780 18.00 0 0 3 3 6.0
#> Cadillac Fleetwood 10.4 8 472.0 205 2.93 5.250 17.98 0 0 3 4 8.0
#> Lincoln Continental 10.4 8 460.0 215 3.00 5.424 17.82 0 0 3 4 9.0
#> Chrysler Imperial 14.7 8 440.0 230 3.23 5.345 17.42 0 0 3 4 10.0
#> Fiat 128 32.4 4 78.7 66 4.08 2.200 19.47 1 1 4 1 4.5
#> Honda Civic 30.4 4 75.7 52 4.93 1.615 18.52 1 1 4 2 1.0
#> Toyota Corolla 33.9 4 71.1 65 4.22 1.835 19.90 1 1 4 1 3.0
#> Toyota Corona 21.5 4 120.1 97 3.70 2.465 20.01 1 0 3 1 1.0
#> Dodge Challenger 15.5 8 318.0 150 2.76 3.520 16.87 0 0 3 2 1.5
#> AMC Javelin 15.2 8 304.0 150 3.15 3.435 17.30 0 0 3 2 1.5
#> Camaro Z28 13.3 8 350.0 245 3.73 3.840 15.41 0 0 3 4 11.5
#> Pontiac Firebird 19.2 8 400.0 175 3.08 3.845 17.05 0 0 3 2 3.5
#> Fiat X1-9 27.3 4 79.0 66 4.08 1.935 18.90 1 1 4 1 4.5
#> Porsche 914-2 26.0 4 120.3 91 4.43 2.140 16.70 0 1 5 2 1.0
#> Lotus Europa 30.4 4 95.1 113 3.77 1.513 16.90 1 1 5 2 2.0
#> Ford Pantera L 15.8 8 351.0 264 4.22 3.170 14.50 0 1 5 4 1.0
#> Ferrari Dino 19.7 6 145.0 175 3.62 2.770 15.50 0 1 5 6 1.0
#> Maserati Bora 15.0 8 301.0 335 3.54 3.570 14.60 0 1 5 8 2.0
#> Volvo 142E 21.4 4 121.0 109 4.11 2.780 18.60 1 1 4 2 8.0
# Control which columns to keep
mtcars |>
mutate_(
hp_per_cyl = ~hp/cyl,
.keep = "used"
)
#> cyl hp hp_per_cyl
#> Mazda RX4 6 110 18.33333
#> Mazda RX4 Wag 6 110 18.33333
#> Datsun 710 4 93 23.25000
#> Hornet 4 Drive 6 110 18.33333
#> Hornet Sportabout 8 175 21.87500
#> Valiant 6 105 17.50000
#> Duster 360 8 245 30.62500
#> Merc 240D 4 62 15.50000
#> Merc 230 4 95 23.75000
#> Merc 280 6 123 20.50000
#> Merc 280C 6 123 20.50000
#> Merc 450SE 8 180 22.50000
#> Merc 450SL 8 180 22.50000
#> Merc 450SLC 8 180 22.50000
#> Cadillac Fleetwood 8 205 25.62500
#> Lincoln Continental 8 215 26.87500
#> Chrysler Imperial 8 230 28.75000
#> Fiat 128 4 66 16.50000
#> Honda Civic 4 52 13.00000
#> Toyota Corolla 4 65 16.25000
#> Toyota Corona 4 97 24.25000
#> Dodge Challenger 8 150 18.75000
#> AMC Javelin 8 150 18.75000
#> Camaro Z28 8 245 30.62500
#> Pontiac Firebird 8 175 21.87500
#> Fiat X1-9 4 66 16.50000
#> Porsche 914-2 4 91 22.75000
#> Lotus Europa 4 113 28.25000
#> Ford Pantera L 8 264 33.00000
#> Ferrari Dino 6 175 29.16667
#> Maserati Bora 8 335 41.87500
#> Volvo 142E 4 109 27.25000
mtcars |>
mutate_(
efficiency = ~mpg/hp,
.keep = "unused"
)
#> cyl disp drat wt qsec vs am gear carb efficiency
#> Mazda RX4 6 160.0 3.90 2.620 16.46 0 1 4 4 0.19090909
#> Mazda RX4 Wag 6 160.0 3.90 2.875 17.02 0 1 4 4 0.19090909
#> Datsun 710 4 108.0 3.85 2.320 18.61 1 1 4 1 0.24516129
#> Hornet 4 Drive 6 258.0 3.08 3.215 19.44 1 0 3 1 0.19454545
#> Hornet Sportabout 8 360.0 3.15 3.440 17.02 0 0 3 2 0.10685714
#> Valiant 6 225.0 2.76 3.460 20.22 1 0 3 1 0.17238095
#> Duster 360 8 360.0 3.21 3.570 15.84 0 0 3 4 0.05836735
#> Merc 240D 4 146.7 3.69 3.190 20.00 1 0 4 2 0.39354839
#> Merc 230 4 140.8 3.92 3.150 22.90 1 0 4 2 0.24000000
#> Merc 280 6 167.6 3.92 3.440 18.30 1 0 4 4 0.15609756
#> Merc 280C 6 167.6 3.92 3.440 18.90 1 0 4 4 0.14471545
#> Merc 450SE 8 275.8 3.07 4.070 17.40 0 0 3 3 0.09111111
#> Merc 450SL 8 275.8 3.07 3.730 17.60 0 0 3 3 0.09611111
#> Merc 450SLC 8 275.8 3.07 3.780 18.00 0 0 3 3 0.08444444
#> Cadillac Fleetwood 8 472.0 2.93 5.250 17.98 0 0 3 4 0.05073171
#> Lincoln Continental 8 460.0 3.00 5.424 17.82 0 0 3 4 0.04837209
#> Chrysler Imperial 8 440.0 3.23 5.345 17.42 0 0 3 4 0.06391304
#> Fiat 128 4 78.7 4.08 2.200 19.47 1 1 4 1 0.49090909
#> Honda Civic 4 75.7 4.93 1.615 18.52 1 1 4 2 0.58461538
#> Toyota Corolla 4 71.1 4.22 1.835 19.90 1 1 4 1 0.52153846
#> Toyota Corona 4 120.1 3.70 2.465 20.01 1 0 3 1 0.22164948
#> Dodge Challenger 8 318.0 2.76 3.520 16.87 0 0 3 2 0.10333333
#> AMC Javelin 8 304.0 3.15 3.435 17.30 0 0 3 2 0.10133333
#> Camaro Z28 8 350.0 3.73 3.840 15.41 0 0 3 4 0.05428571
#> Pontiac Firebird 8 400.0 3.08 3.845 17.05 0 0 3 2 0.10971429
#> Fiat X1-9 4 79.0 4.08 1.935 18.90 1 1 4 1 0.41363636
#> Porsche 914-2 4 120.3 4.43 2.140 16.70 0 1 5 2 0.28571429
#> Lotus Europa 4 95.1 3.77 1.513 16.90 1 1 5 2 0.26902655
#> Ford Pantera L 8 351.0 4.22 3.170 14.50 0 1 5 4 0.05984848
#> Ferrari Dino 6 145.0 3.62 2.770 15.50 0 1 5 6 0.11257143
#> Maserati Bora 8 301.0 3.54 3.570 14.60 0 1 5 8 0.04477612
#> Volvo 142E 4 121.0 4.11 2.780 18.60 1 1 4 2 0.19633028
# transmute_() keeps only new columns
mtcars |>
transmute_(
car = ~rownames(mtcars),
hp_per_cyl = ~hp/cyl,
efficiency = ~mpg/wt
)
#> car hp_per_cyl efficiency
#> Mazda RX4 Mazda RX4 18.33333 8.015267
#> Mazda RX4 Wag Mazda RX4 Wag 18.33333 7.304348
#> Datsun 710 Datsun 710 23.25000 9.827586
#> Hornet 4 Drive Hornet 4 Drive 18.33333 6.656299
#> Hornet Sportabout Hornet Sportabout 21.87500 5.436047
#> Valiant Valiant 17.50000 5.231214
#> Duster 360 Duster 360 30.62500 4.005602
#> Merc 240D Merc 240D 15.50000 7.648903
#> Merc 230 Merc 230 23.75000 7.238095
#> Merc 280 Merc 280 20.50000 5.581395
#> Merc 280C Merc 280C 20.50000 5.174419
#> Merc 450SE Merc 450SE 22.50000 4.029484
#> Merc 450SL Merc 450SL 22.50000 4.638070
#> Merc 450SLC Merc 450SLC 22.50000 4.021164
#> Cadillac Fleetwood Cadillac Fleetwood 25.62500 1.980952
#> Lincoln Continental Lincoln Continental 26.87500 1.917404
#> Chrysler Imperial Chrysler Imperial 28.75000 2.750234
#> Fiat 128 Fiat 128 16.50000 14.727273
#> Honda Civic Honda Civic 13.00000 18.823529
#> Toyota Corolla Toyota Corolla 16.25000 18.474114
#> Toyota Corona Toyota Corona 24.25000 8.722110
#> Dodge Challenger Dodge Challenger 18.75000 4.403409
#> AMC Javelin AMC Javelin 18.75000 4.425036
#> Camaro Z28 Camaro Z28 30.62500 3.463542
#> Pontiac Firebird Pontiac Firebird 21.87500 4.993498
#> Fiat X1-9 Fiat X1-9 16.50000 14.108527
#> Porsche 914-2 Porsche 914-2 22.75000 12.149533
#> Lotus Europa Lotus Europa 28.25000 20.092531
#> Ford Pantera L Ford Pantera L 33.00000 4.984227
#> Ferrari Dino Ferrari Dino 29.16667 7.111913
#> Maserati Bora Maserati Bora 41.87500 4.201681
#> Volvo 142E Volvo 142E 27.25000 7.697842
# Conditional mutations
mtcars |>
mutate_(
performance = ~ifelse(hp > 150, "high", "normal")
)
#> mpg cyl disp hp drat wt qsec vs am gear carb
#> Mazda RX4 21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4
#> Mazda RX4 Wag 21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4
#> Datsun 710 22.8 4 108.0 93 3.85 2.320 18.61 1 1 4 1
#> Hornet 4 Drive 21.4 6 258.0 110 3.08 3.215 19.44 1 0 3 1
#> Hornet Sportabout 18.7 8 360.0 175 3.15 3.440 17.02 0 0 3 2
#> Valiant 18.1 6 225.0 105 2.76 3.460 20.22 1 0 3 1
#> Duster 360 14.3 8 360.0 245 3.21 3.570 15.84 0 0 3 4
#> Merc 240D 24.4 4 146.7 62 3.69 3.190 20.00 1 0 4 2
#> Merc 230 22.8 4 140.8 95 3.92 3.150 22.90 1 0 4 2
#> Merc 280 19.2 6 167.6 123 3.92 3.440 18.30 1 0 4 4
#> Merc 280C 17.8 6 167.6 123 3.92 3.440 18.90 1 0 4 4
#> Merc 450SE 16.4 8 275.8 180 3.07 4.070 17.40 0 0 3 3
#> Merc 450SL 17.3 8 275.8 180 3.07 3.730 17.60 0 0 3 3
#> Merc 450SLC 15.2 8 275.8 180 3.07 3.780 18.00 0 0 3 3
#> Cadillac Fleetwood 10.4 8 472.0 205 2.93 5.250 17.98 0 0 3 4
#> Lincoln Continental 10.4 8 460.0 215 3.00 5.424 17.82 0 0 3 4
#> Chrysler Imperial 14.7 8 440.0 230 3.23 5.345 17.42 0 0 3 4
#> Fiat 128 32.4 4 78.7 66 4.08 2.200 19.47 1 1 4 1
#> Honda Civic 30.4 4 75.7 52 4.93 1.615 18.52 1 1 4 2
#> Toyota Corolla 33.9 4 71.1 65 4.22 1.835 19.90 1 1 4 1
#> Toyota Corona 21.5 4 120.1 97 3.70 2.465 20.01 1 0 3 1
#> Dodge Challenger 15.5 8 318.0 150 2.76 3.520 16.87 0 0 3 2
#> AMC Javelin 15.2 8 304.0 150 3.15 3.435 17.30 0 0 3 2
#> Camaro Z28 13.3 8 350.0 245 3.73 3.840 15.41 0 0 3 4
#> Pontiac Firebird 19.2 8 400.0 175 3.08 3.845 17.05 0 0 3 2
#> Fiat X1-9 27.3 4 79.0 66 4.08 1.935 18.90 1 1 4 1
#> Porsche 914-2 26.0 4 120.3 91 4.43 2.140 16.70 0 1 5 2
#> Lotus Europa 30.4 4 95.1 113 3.77 1.513 16.90 1 1 5 2
#> Ford Pantera L 15.8 8 351.0 264 4.22 3.170 14.50 0 1 5 4
#> Ferrari Dino 19.7 6 145.0 175 3.62 2.770 15.50 0 1 5 6
#> Maserati Bora 15.0 8 301.0 335 3.54 3.570 14.60 0 1 5 8
#> Volvo 142E 21.4 4 121.0 109 4.11 2.780 18.60 1 1 4 2
#> performance
#> Mazda RX4 normal
#> Mazda RX4 Wag normal
#> Datsun 710 normal
#> Hornet 4 Drive normal
#> Hornet Sportabout high
#> Valiant normal
#> Duster 360 high
#> Merc 240D normal
#> Merc 230 normal
#> Merc 280 normal
#> Merc 280C normal
#> Merc 450SE high
#> Merc 450SL high
#> Merc 450SLC high
#> Cadillac Fleetwood high
#> Lincoln Continental high
#> Chrysler Imperial high
#> Fiat 128 normal
#> Honda Civic normal
#> Toyota Corolla normal
#> Toyota Corona normal
#> Dodge Challenger normal
#> AMC Javelin normal
#> Camaro Z28 high
#> Pontiac Firebird high
#> Fiat X1-9 normal
#> Porsche 914-2 normal
#> Lotus Europa normal
#> Ford Pantera L high
#> Ferrari Dino high
#> Maserati Bora high
#> Volvo 142E normal
# Use with grouped data
mtcars |>
group_by_(~cyl) |>
mutate_(mpg_ratio = ~mpg/mean(mpg))
#> mpg cyl disp hp drat wt qsec vs am gear carb
#> Mazda RX4 21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4
#> Mazda RX4 Wag 21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4
#> Datsun 710 22.8 4 108.0 93 3.85 2.320 18.61 1 1 4 1
#> Hornet 4 Drive 21.4 6 258.0 110 3.08 3.215 19.44 1 0 3 1
#> Hornet Sportabout 18.7 8 360.0 175 3.15 3.440 17.02 0 0 3 2
#> Valiant 18.1 6 225.0 105 2.76 3.460 20.22 1 0 3 1
#> Duster 360 14.3 8 360.0 245 3.21 3.570 15.84 0 0 3 4
#> Merc 240D 24.4 4 146.7 62 3.69 3.190 20.00 1 0 4 2
#> Merc 230 22.8 4 140.8 95 3.92 3.150 22.90 1 0 4 2
#> Merc 280 19.2 6 167.6 123 3.92 3.440 18.30 1 0 4 4
#> Merc 280C 17.8 6 167.6 123 3.92 3.440 18.90 1 0 4 4
#> Merc 450SE 16.4 8 275.8 180 3.07 4.070 17.40 0 0 3 3
#> Merc 450SL 17.3 8 275.8 180 3.07 3.730 17.60 0 0 3 3
#> Merc 450SLC 15.2 8 275.8 180 3.07 3.780 18.00 0 0 3 3
#> Cadillac Fleetwood 10.4 8 472.0 205 2.93 5.250 17.98 0 0 3 4
#> Lincoln Continental 10.4 8 460.0 215 3.00 5.424 17.82 0 0 3 4
#> Chrysler Imperial 14.7 8 440.0 230 3.23 5.345 17.42 0 0 3 4
#> Fiat 128 32.4 4 78.7 66 4.08 2.200 19.47 1 1 4 1
#> Honda Civic 30.4 4 75.7 52 4.93 1.615 18.52 1 1 4 2
#> Toyota Corolla 33.9 4 71.1 65 4.22 1.835 19.90 1 1 4 1
#> Toyota Corona 21.5 4 120.1 97 3.70 2.465 20.01 1 0 3 1
#> Dodge Challenger 15.5 8 318.0 150 2.76 3.520 16.87 0 0 3 2
#> AMC Javelin 15.2 8 304.0 150 3.15 3.435 17.30 0 0 3 2
#> Camaro Z28 13.3 8 350.0 245 3.73 3.840 15.41 0 0 3 4
#> Pontiac Firebird 19.2 8 400.0 175 3.08 3.845 17.05 0 0 3 2
#> Fiat X1-9 27.3 4 79.0 66 4.08 1.935 18.90 1 1 4 1
#> Porsche 914-2 26.0 4 120.3 91 4.43 2.140 16.70 0 1 5 2
#> Lotus Europa 30.4 4 95.1 113 3.77 1.513 16.90 1 1 5 2
#> Ford Pantera L 15.8 8 351.0 264 4.22 3.170 14.50 0 1 5 4
#> Ferrari Dino 19.7 6 145.0 175 3.62 2.770 15.50 0 1 5 6
#> Maserati Bora 15.0 8 301.0 335 3.54 3.570 14.60 0 1 5 8
#> Volvo 142E 21.4 4 121.0 109 4.11 2.780 18.60 1 1 4 2
#> mpg_ratio
#> Mazda RX4 1.0636758
#> Mazda RX4 Wag 1.0636758
#> Datsun 710 0.8550972
#> Hornet 4 Drive 1.0839363
#> Hornet Sportabout 1.2384106
#> Valiant 0.9167873
#> Duster 360 0.9470199
#> Merc 240D 0.9151040
#> Merc 230 0.8550972
#> Merc 280 0.9725036
#> Merc 280C 0.9015919
#> Merc 450SE 1.0860927
#> Merc 450SL 1.1456954
#> Merc 450SLC 1.0066225
#> Cadillac Fleetwood 0.6887417
#> Lincoln Continental 0.6887417
#> Chrysler Imperial 0.9735099
#> Fiat 128 1.2151381
#> Honda Civic 1.1401296
#> Toyota Corolla 1.2713945
#> Toyota Corona 0.8063416
#> Dodge Challenger 1.0264901
#> AMC Javelin 1.0066225
#> Camaro Z28 0.8807947
#> Pontiac Firebird 1.2715232
#> Fiat X1-9 1.0238663
#> Porsche 914-2 0.9751108
#> Lotus Europa 1.1401296
#> Ford Pantera L 1.0463576
#> Ferrari Dino 0.9978292
#> Maserati Bora 0.9933775
#> Volvo 142E 0.8025912
#>
#> Grouped by: cyl [3 | 11 (3.5) 7-14]
# Complex transformations
mtcars |>
mutate_(
log_hp = ~log(hp),
sqrt_wt = ~sqrt(wt),
hp_wt_interaction = ~hp * wt
)
#> mpg cyl disp hp drat wt qsec vs am gear carb
#> Mazda RX4 21.0 6 160.0 110 3.90 2.620 16.46 0 1 4 4
#> Mazda RX4 Wag 21.0 6 160.0 110 3.90 2.875 17.02 0 1 4 4
#> Datsun 710 22.8 4 108.0 93 3.85 2.320 18.61 1 1 4 1
#> Hornet 4 Drive 21.4 6 258.0 110 3.08 3.215 19.44 1 0 3 1
#> Hornet Sportabout 18.7 8 360.0 175 3.15 3.440 17.02 0 0 3 2
#> Valiant 18.1 6 225.0 105 2.76 3.460 20.22 1 0 3 1
#> Duster 360 14.3 8 360.0 245 3.21 3.570 15.84 0 0 3 4
#> Merc 240D 24.4 4 146.7 62 3.69 3.190 20.00 1 0 4 2
#> Merc 230 22.8 4 140.8 95 3.92 3.150 22.90 1 0 4 2
#> Merc 280 19.2 6 167.6 123 3.92 3.440 18.30 1 0 4 4
#> Merc 280C 17.8 6 167.6 123 3.92 3.440 18.90 1 0 4 4
#> Merc 450SE 16.4 8 275.8 180 3.07 4.070 17.40 0 0 3 3
#> Merc 450SL 17.3 8 275.8 180 3.07 3.730 17.60 0 0 3 3
#> Merc 450SLC 15.2 8 275.8 180 3.07 3.780 18.00 0 0 3 3
#> Cadillac Fleetwood 10.4 8 472.0 205 2.93 5.250 17.98 0 0 3 4
#> Lincoln Continental 10.4 8 460.0 215 3.00 5.424 17.82 0 0 3 4
#> Chrysler Imperial 14.7 8 440.0 230 3.23 5.345 17.42 0 0 3 4
#> Fiat 128 32.4 4 78.7 66 4.08 2.200 19.47 1 1 4 1
#> Honda Civic 30.4 4 75.7 52 4.93 1.615 18.52 1 1 4 2
#> Toyota Corolla 33.9 4 71.1 65 4.22 1.835 19.90 1 1 4 1
#> Toyota Corona 21.5 4 120.1 97 3.70 2.465 20.01 1 0 3 1
#> Dodge Challenger 15.5 8 318.0 150 2.76 3.520 16.87 0 0 3 2
#> AMC Javelin 15.2 8 304.0 150 3.15 3.435 17.30 0 0 3 2
#> Camaro Z28 13.3 8 350.0 245 3.73 3.840 15.41 0 0 3 4
#> Pontiac Firebird 19.2 8 400.0 175 3.08 3.845 17.05 0 0 3 2
#> Fiat X1-9 27.3 4 79.0 66 4.08 1.935 18.90 1 1 4 1
#> Porsche 914-2 26.0 4 120.3 91 4.43 2.140 16.70 0 1 5 2
#> Lotus Europa 30.4 4 95.1 113 3.77 1.513 16.90 1 1 5 2
#> Ford Pantera L 15.8 8 351.0 264 4.22 3.170 14.50 0 1 5 4
#> Ferrari Dino 19.7 6 145.0 175 3.62 2.770 15.50 0 1 5 6
#> Maserati Bora 15.0 8 301.0 335 3.54 3.570 14.60 0 1 5 8
#> Volvo 142E 21.4 4 121.0 109 4.11 2.780 18.60 1 1 4 2
#> log_hp sqrt_wt hp_wt_interaction
#> Mazda RX4 4.700480 1.618641 288.200
#> Mazda RX4 Wag 4.700480 1.695582 316.250
#> Datsun 710 4.532599 1.523155 215.760
#> Hornet 4 Drive 4.700480 1.793042 353.650
#> Hornet Sportabout 5.164786 1.854724 602.000
#> Valiant 4.653960 1.860108 363.300
#> Duster 360 5.501258 1.889444 874.650
#> Merc 240D 4.127134 1.786057 197.780
#> Merc 230 4.553877 1.774824 299.250
#> Merc 280 4.812184 1.854724 423.120
#> Merc 280C 4.812184 1.854724 423.120
#> Merc 450SE 5.192957 2.017424 732.600
#> Merc 450SL 5.192957 1.931321 671.400
#> Merc 450SLC 5.192957 1.944222 680.400
#> Cadillac Fleetwood 5.323010 2.291288 1076.250
#> Lincoln Continental 5.370638 2.328948 1166.160
#> Chrysler Imperial 5.438079 2.311926 1229.350
#> Fiat 128 4.189655 1.483240 145.200
#> Honda Civic 3.951244 1.270827 83.980
#> Toyota Corolla 4.174387 1.354622 119.275
#> Toyota Corona 4.574711 1.570032 239.105
#> Dodge Challenger 5.010635 1.876166 528.000
#> AMC Javelin 5.010635 1.853375 515.250
#> Camaro Z28 5.501258 1.959592 940.800
#> Pontiac Firebird 5.164786 1.960867 672.875
#> Fiat X1-9 4.189655 1.391043 127.710
#> Porsche 914-2 4.510860 1.462874 194.740
#> Lotus Europa 4.727388 1.230041 170.969
#> Ford Pantera L 5.575949 1.780449 836.880
#> Ferrari Dino 5.164786 1.664332 484.750
#> Maserati Bora 5.814131 1.889444 1195.950
#> Volvo 142E 4.691348 1.667333 303.020