An efficient way to transpose data frames(data.frame/data.table/tibble).

t_dt(.data)

Arguments

.data

A data.frame/data.table/tibble

Value

A transposed data.frame

Details

This function would return the original data.frame structure, keeping all the row names and column names. If the row names are not available or, "V1,V2..." will be provided.

Examples

t_dt(iris)
#> V1 V2 V3 V4 V5 V6 V7 V8 V9 #> Sepal.Length 5.1 4.9 4.7 4.6 5 5.4 4.6 5 4.4 #> Sepal.Width 3.5 3 3.2 3.1 3.6 3.9 3.4 3.4 2.9 #> Petal.Length 1.4 1.4 1.3 1.5 1.4 1.7 1.4 1.5 1.4 #> Petal.Width 0.2 0.2 0.2 0.2 0.2 0.4 0.3 0.2 0.2 #> Species setosa setosa setosa setosa setosa setosa setosa setosa setosa #> V10 V11 V12 V13 V14 V15 V16 V17 V18 #> Sepal.Length 4.9 5.4 4.8 4.8 4.3 5.8 5.7 5.4 5.1 #> Sepal.Width 3.1 3.7 3.4 3 3 4 4.4 3.9 3.5 #> Petal.Length 1.5 1.5 1.6 1.4 1.1 1.2 1.5 1.3 1.4 #> Petal.Width 0.1 0.2 0.2 0.1 0.1 0.2 0.4 0.4 0.3 #> Species setosa setosa setosa setosa setosa setosa setosa setosa setosa #> V19 V20 V21 V22 V23 V24 V25 V26 V27 #> Sepal.Length 5.7 5.1 5.4 5.1 4.6 5.1 4.8 5 5 #> Sepal.Width 3.8 3.8 3.4 3.7 3.6 3.3 3.4 3 3.4 #> Petal.Length 1.7 1.5 1.7 1.5 1 1.7 1.9 1.6 1.6 #> Petal.Width 0.3 0.3 0.2 0.4 0.2 0.5 0.2 0.2 0.4 #> Species setosa setosa setosa setosa setosa setosa setosa setosa setosa #> V28 V29 V30 V31 V32 V33 V34 V35 V36 #> Sepal.Length 5.2 5.2 4.7 4.8 5.4 5.2 5.5 4.9 5 #> Sepal.Width 3.5 3.4 3.2 3.1 3.4 4.1 4.2 3.1 3.2 #> Petal.Length 1.5 1.4 1.6 1.6 1.5 1.5 1.4 1.5 1.2 #> Petal.Width 0.2 0.2 0.2 0.2 0.4 0.1 0.2 0.2 0.2 #> Species setosa setosa setosa setosa setosa setosa setosa setosa setosa #> V37 V38 V39 V40 V41 V42 V43 V44 V45 #> Sepal.Length 5.5 4.9 4.4 5.1 5 4.5 4.4 5 5.1 #> Sepal.Width 3.5 3.6 3 3.4 3.5 2.3 3.2 3.5 3.8 #> Petal.Length 1.3 1.4 1.3 1.5 1.3 1.3 1.3 1.6 1.9 #> Petal.Width 0.2 0.1 0.2 0.2 0.3 0.3 0.2 0.6 0.4 #> Species setosa setosa setosa setosa setosa setosa setosa setosa setosa #> V46 V47 V48 V49 V50 V51 V52 #> Sepal.Length 4.8 5.1 4.6 5.3 5 7 6.4 #> Sepal.Width 3 3.8 3.2 3.7 3.3 3.2 3.2 #> Petal.Length 1.4 1.6 1.4 1.5 1.4 4.7 4.5 #> Petal.Width 0.3 0.2 0.2 0.2 0.2 1.4 1.5 #> Species setosa setosa setosa setosa setosa versicolor versicolor #> V53 V54 V55 V56 V57 V58 #> Sepal.Length 6.9 5.5 6.5 5.7 6.3 4.9 #> Sepal.Width 3.1 2.3 2.8 2.8 3.3 2.4 #> Petal.Length 4.9 4 4.6 4.5 4.7 3.3 #> Petal.Width 1.5 1.3 1.5 1.3 1.6 1 #> Species versicolor versicolor versicolor versicolor versicolor versicolor #> V59 V60 V61 V62 V63 V64 #> Sepal.Length 6.6 5.2 5 5.9 6 6.1 #> Sepal.Width 2.9 2.7 2 3 2.2 2.9 #> Petal.Length 4.6 3.9 3.5 4.2 4 4.7 #> Petal.Width 1.3 1.4 1 1.5 1 1.4 #> Species versicolor versicolor versicolor versicolor versicolor versicolor #> V65 V66 V67 V68 V69 V70 #> Sepal.Length 5.6 6.7 5.6 5.8 6.2 5.6 #> Sepal.Width 2.9 3.1 3 2.7 2.2 2.5 #> Petal.Length 3.6 4.4 4.5 4.1 4.5 3.9 #> Petal.Width 1.3 1.4 1.5 1 1.5 1.1 #> Species versicolor versicolor versicolor versicolor versicolor versicolor #> V71 V72 V73 V74 V75 V76 #> Sepal.Length 5.9 6.1 6.3 6.1 6.4 6.6 #> Sepal.Width 3.2 2.8 2.5 2.8 2.9 3 #> Petal.Length 4.8 4 4.9 4.7 4.3 4.4 #> Petal.Width 1.8 1.3 1.5 1.2 1.3 1.4 #> Species versicolor versicolor versicolor versicolor versicolor versicolor #> V77 V78 V79 V80 V81 V82 #> Sepal.Length 6.8 6.7 6 5.7 5.5 5.5 #> Sepal.Width 2.8 3 2.9 2.6 2.4 2.4 #> Petal.Length 4.8 5 4.5 3.5 3.8 3.7 #> Petal.Width 1.4 1.7 1.5 1 1.1 1 #> Species versicolor versicolor versicolor versicolor versicolor versicolor #> V83 V84 V85 V86 V87 V88 #> Sepal.Length 5.8 6 5.4 6 6.7 6.3 #> Sepal.Width 2.7 2.7 3 3.4 3.1 2.3 #> Petal.Length 3.9 5.1 4.5 4.5 4.7 4.4 #> Petal.Width 1.2 1.6 1.5 1.6 1.5 1.3 #> Species versicolor versicolor versicolor versicolor versicolor versicolor #> V89 V90 V91 V92 V93 V94 #> Sepal.Length 5.6 5.5 5.5 6.1 5.8 5 #> Sepal.Width 3 2.5 2.6 3 2.6 2.3 #> Petal.Length 4.1 4 4.4 4.6 4 3.3 #> Petal.Width 1.3 1.3 1.2 1.4 1.2 1 #> Species versicolor versicolor versicolor versicolor versicolor versicolor #> V95 V96 V97 V98 V99 V100 #> Sepal.Length 5.6 5.7 5.7 6.2 5.1 5.7 #> Sepal.Width 2.7 3 2.9 2.9 2.5 2.8 #> Petal.Length 4.2 4.2 4.2 4.3 3 4.1 #> Petal.Width 1.3 1.2 1.3 1.3 1.1 1.3 #> Species versicolor versicolor versicolor versicolor versicolor versicolor #> V101 V102 V103 V104 V105 V106 #> Sepal.Length 6.3 5.8 7.1 6.3 6.5 7.6 #> Sepal.Width 3.3 2.7 3 2.9 3 3 #> Petal.Length 6 5.1 5.9 5.6 5.8 6.6 #> Petal.Width 2.5 1.9 2.1 1.8 2.2 2.1 #> Species virginica virginica virginica virginica virginica virginica #> V107 V108 V109 V110 V111 V112 #> Sepal.Length 4.9 7.3 6.7 7.2 6.5 6.4 #> Sepal.Width 2.5 2.9 2.5 3.6 3.2 2.7 #> Petal.Length 4.5 6.3 5.8 6.1 5.1 5.3 #> Petal.Width 1.7 1.8 1.8 2.5 2 1.9 #> Species virginica virginica virginica virginica virginica virginica #> V113 V114 V115 V116 V117 V118 #> Sepal.Length 6.8 5.7 5.8 6.4 6.5 7.7 #> Sepal.Width 3 2.5 2.8 3.2 3 3.8 #> Petal.Length 5.5 5 5.1 5.3 5.5 6.7 #> Petal.Width 2.1 2 2.4 2.3 1.8 2.2 #> Species virginica virginica virginica virginica virginica virginica #> V119 V120 V121 V122 V123 V124 #> Sepal.Length 7.7 6 6.9 5.6 7.7 6.3 #> Sepal.Width 2.6 2.2 3.2 2.8 2.8 2.7 #> Petal.Length 6.9 5 5.7 4.9 6.7 4.9 #> Petal.Width 2.3 1.5 2.3 2 2 1.8 #> Species virginica virginica virginica virginica virginica virginica #> V125 V126 V127 V128 V129 V130 #> Sepal.Length 6.7 7.2 6.2 6.1 6.4 7.2 #> Sepal.Width 3.3 3.2 2.8 3 2.8 3 #> Petal.Length 5.7 6 4.8 4.9 5.6 5.8 #> Petal.Width 2.1 1.8 1.8 1.8 2.1 1.6 #> Species virginica virginica virginica virginica virginica virginica #> V131 V132 V133 V134 V135 V136 #> Sepal.Length 7.4 7.9 6.4 6.3 6.1 7.7 #> Sepal.Width 2.8 3.8 2.8 2.8 2.6 3 #> Petal.Length 6.1 6.4 5.6 5.1 5.6 6.1 #> Petal.Width 1.9 2 2.2 1.5 1.4 2.3 #> Species virginica virginica virginica virginica virginica virginica #> V137 V138 V139 V140 V141 V142 #> Sepal.Length 6.3 6.4 6 6.9 6.7 6.9 #> Sepal.Width 3.4 3.1 3 3.1 3.1 3.1 #> Petal.Length 5.6 5.5 4.8 5.4 5.6 5.1 #> Petal.Width 2.4 1.8 1.8 2.1 2.4 2.3 #> Species virginica virginica virginica virginica virginica virginica #> V143 V144 V145 V146 V147 V148 #> Sepal.Length 5.8 6.8 6.7 6.7 6.3 6.5 #> Sepal.Width 2.7 3.2 3.3 3 2.5 3 #> Petal.Length 5.1 5.9 5.7 5.2 5 5.2 #> Petal.Width 1.9 2.3 2.5 2.3 1.9 2 #> Species virginica virginica virginica virginica virginica virginica #> V149 V150 #> Sepal.Length 6.2 5.9 #> Sepal.Width 3.4 3 #> Petal.Length 5.4 5.1 #> Petal.Width 2.3 1.8 #> Species virginica virginica
t_dt(mtcars)
#> Mazda RX4 Mazda RX4 Wag Datsun 710 Hornet 4 Drive Hornet Sportabout #> mpg 21.00 21.000 22.80 21.400 18.70 #> cyl 6.00 6.000 4.00 6.000 8.00 #> disp 160.00 160.000 108.00 258.000 360.00 #> hp 110.00 110.000 93.00 110.000 175.00 #> drat 3.90 3.900 3.85 3.080 3.15 #> wt 2.62 2.875 2.32 3.215 3.44 #> qsec 16.46 17.020 18.61 19.440 17.02 #> vs 0.00 0.000 1.00 1.000 0.00 #> am 1.00 1.000 1.00 0.000 0.00 #> gear 4.00 4.000 4.00 3.000 3.00 #> carb 4.00 4.000 1.00 1.000 2.00 #> Valiant Duster 360 Merc 240D Merc 230 Merc 280 Merc 280C Merc 450SE #> mpg 18.10 14.30 24.40 22.80 19.20 17.80 16.40 #> cyl 6.00 8.00 4.00 4.00 6.00 6.00 8.00 #> disp 225.00 360.00 146.70 140.80 167.60 167.60 275.80 #> hp 105.00 245.00 62.00 95.00 123.00 123.00 180.00 #> drat 2.76 3.21 3.69 3.92 3.92 3.92 3.07 #> wt 3.46 3.57 3.19 3.15 3.44 3.44 4.07 #> qsec 20.22 15.84 20.00 22.90 18.30 18.90 17.40 #> vs 1.00 0.00 1.00 1.00 1.00 1.00 0.00 #> am 0.00 0.00 0.00 0.00 0.00 0.00 0.00 #> gear 3.00 3.00 4.00 4.00 4.00 4.00 3.00 #> carb 1.00 4.00 2.00 2.00 4.00 4.00 3.00 #> Merc 450SL Merc 450SLC Cadillac Fleetwood Lincoln Continental #> mpg 17.30 15.20 10.40 10.400 #> cyl 8.00 8.00 8.00 8.000 #> disp 275.80 275.80 472.00 460.000 #> hp 180.00 180.00 205.00 215.000 #> drat 3.07 3.07 2.93 3.000 #> wt 3.73 3.78 5.25 5.424 #> qsec 17.60 18.00 17.98 17.820 #> vs 0.00 0.00 0.00 0.000 #> am 0.00 0.00 0.00 0.000 #> gear 3.00 3.00 3.00 3.000 #> carb 3.00 3.00 4.00 4.000 #> Chrysler Imperial Fiat 128 Honda Civic Toyota Corolla Toyota Corona #> mpg 14.700 32.40 30.400 33.900 21.500 #> cyl 8.000 4.00 4.000 4.000 4.000 #> disp 440.000 78.70 75.700 71.100 120.100 #> hp 230.000 66.00 52.000 65.000 97.000 #> drat 3.230 4.08 4.930 4.220 3.700 #> wt 5.345 2.20 1.615 1.835 2.465 #> qsec 17.420 19.47 18.520 19.900 20.010 #> vs 0.000 1.00 1.000 1.000 1.000 #> am 0.000 1.00 1.000 1.000 0.000 #> gear 3.000 4.00 4.000 4.000 3.000 #> carb 4.000 1.00 2.000 1.000 1.000 #> Dodge Challenger AMC Javelin Camaro Z28 Pontiac Firebird Fiat X1-9 #> mpg 15.50 15.200 13.30 19.200 27.300 #> cyl 8.00 8.000 8.00 8.000 4.000 #> disp 318.00 304.000 350.00 400.000 79.000 #> hp 150.00 150.000 245.00 175.000 66.000 #> drat 2.76 3.150 3.73 3.080 4.080 #> wt 3.52 3.435 3.84 3.845 1.935 #> qsec 16.87 17.300 15.41 17.050 18.900 #> vs 0.00 0.000 0.00 0.000 1.000 #> am 0.00 0.000 0.00 0.000 1.000 #> gear 3.00 3.000 3.00 3.000 4.000 #> carb 2.00 2.000 4.00 2.000 1.000 #> Porsche 914-2 Lotus Europa Ford Pantera L Ferrari Dino Maserati Bora #> mpg 26.00 30.400 15.80 19.70 15.00 #> cyl 4.00 4.000 8.00 6.00 8.00 #> disp 120.30 95.100 351.00 145.00 301.00 #> hp 91.00 113.000 264.00 175.00 335.00 #> drat 4.43 3.770 4.22 3.62 3.54 #> wt 2.14 1.513 3.17 2.77 3.57 #> qsec 16.70 16.900 14.50 15.50 14.60 #> vs 0.00 1.000 0.00 0.00 0.00 #> am 1.00 1.000 1.00 1.00 1.00 #> gear 5.00 5.000 5.00 5.00 5.00 #> carb 2.00 2.000 4.00 6.00 8.00 #> Volvo 142E #> mpg 21.40 #> cyl 4.00 #> disp 121.00 #> hp 109.00 #> drat 4.11 #> wt 2.78 #> qsec 18.60 #> vs 1.00 #> am 1.00 #> gear 4.00 #> carb 2.00