{"id":2142,"date":"2020-02-20T23:52:20","date_gmt":"2020-02-20T14:52:20","guid":{"rendered":"http:\/\/141.164.34.82\/?p=2142"},"modified":"2020-02-21T00:37:29","modified_gmt":"2020-02-20T15:37:29","slug":"summarising-data-frame","status":"publish","type":"post","link":"http:\/\/ds.sumeun.org\/?p=2142","title":{"rendered":"Summarising data frame"},"content":{"rendered":"

\ub370\uc774\ud130 \ud504\ub808\uc784 \uc0b4\ud3b4\ubcf4\uae30<\/h2>\n

\ucd5c\uadfc \ud2b9\uac15\uc744 \uc900\ube44\ud558\uba74\uc11c, \ub370\uc774\ud130 \ud504\ub808\uc784 \uc804\uccb4\uc5d0 \ub300\ud574 \uc694\uc57d\/\uc815\ub9ac\ud558\ub294 \ud328\ud0a4\uc9c0\/\ud568\uc218\uac00 \uc5ec\ub7ff \uac1c\ubc1c\ub418\uc5c8\uc74c\uc744 \ud655\uc778\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 mtcars<\/code>\ub97c \ud65c\uc6a9\ud558\uc5ec \uc774\ub4e4\uc744 \uc0ac\uc6a9\ud558\ub294 \uc608\ub97c \ubcf4\uc774\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

mtcars<\/code><\/h3>\n
head(mtcars)\n<\/code><\/pre>\n
##                    mpg cyl disp  hp drat    wt  qsec vs am gear carb\n## Mazda RX4         21.0   6  160 110 3.90 2.620 16.46  0  1    4    4\n## Mazda RX4 Wag     21.0   6  160 110 3.90 2.875 17.02  0  1    4    4\n## Datsun 710        22.8   4  108  93 3.85 2.320 18.61  1  1    4    1\n## Hornet 4 Drive    21.4   6  258 110 3.08 3.215 19.44  1  0    3    1\n## Hornet Sportabout 18.7   8  360 175 3.15 3.440 17.02  0  0    3    2\n## Valiant           18.1   6  225 105 2.76 3.460 20.22  1  0    3    1\n<\/pre>\n
sapply(mtcars, class)\n<\/code><\/pre>\n
##       mpg       cyl      disp        hp      drat        wt      qsec        vs        am      gear      carb \n## "numeric" "numeric" "numeric" "numeric" "numeric" "numeric" "numeric" "numeric" "numeric" "numeric" "numeric"\n<\/pre>\n
\uc6b0\uc120 mtcars<\/code>\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uc218\uc815\ud569\ub2c8\ub2e4.<\/p>\n
library(dplyr)\nmtcars2 <- \n  mtcars %>% mutate(am = factor(ifelse(am==0, 'auto', 'manual')),\n                    vs = factor(ifelse(vs==0, 'V-shaped', 'straight')))\n\nmtcars3 <- \n  mtcars %>% mutate(cyl = ordered(cyl, levels=c(4,6,8)),\n                    gear = ordered(gear, levels=c(3,4,5)),\n                    carb = ordered(carb, levels=c(1,2,3,4,6,8)))\n\ndat <- mtcars2\ndat2 <- mtcars3\n<\/code><\/pre>\n
\uae30\ubcf8 \ud14d\uc2a4\ud2b8\ud615<\/h3>\n
    \n
  • summary()<\/code><\/li>\n
  • prettyR::freq()<\/code><\/li>\n
  • psych::describe()<\/code><\/li>\n
  • Hmisc::describe()<\/code><\/li>\n
  • pastecs::stat.desc()<\/code><\/li>\n<\/ul>\n
    summary(dat)\n<\/code><\/pre>\n
    ##       mpg             cyl             disp             hp             drat             wt             qsec      \n##  Min.   :10.40   Min.   :4.000   Min.   : 71.1   Min.   : 52.0   Min.   :2.760   Min.   :1.513   Min.   :14.50  \n##  1st Qu.:15.43   1st Qu.:4.000   1st Qu.:120.8   1st Qu.: 96.5   1st Qu.:3.080   1st Qu.:2.581   1st Qu.:16.89  \n##  Median :19.20   Median :6.000   Median :196.3   Median :123.0   Median :3.695   Median :3.325   Median :17.71  \n##  Mean   :20.09   Mean   :6.188   Mean   :230.7   Mean   :146.7   Mean   :3.597   Mean   :3.217   Mean   :17.85  \n##  3rd Qu.:22.80   3rd Qu.:8.000   3rd Qu.:326.0   3rd Qu.:180.0   3rd Qu.:3.920   3rd Qu.:3.610   3rd Qu.:18.90  \n##  Max.   :33.90   Max.   :8.000   Max.   :472.0   Max.   :335.0   Max.   :4.930   Max.   :5.424   Max.   :22.90  \n##         vs          am          gear            carb      \n##  straight:14   auto  :19   Min.   :3.000   Min.   :1.000  \n##  V-shaped:18   manual:13   1st Qu.:3.000   1st Qu.:2.000  \n##                            Median :4.000   Median :2.000  \n##                            Mean   :3.688   Mean   :2.812  \n##                            3rd Qu.:4.000   3rd Qu.:4.000  \n##                            Max.   :5.000   Max.   :8.000\n<\/pre>\n
    prettyR::freq(dat)\n<\/code><\/pre>\n
    ## \n## Frequencies for mpg \n##      10.4 15.2 19.2   21 21.4 22.8 30.4 13.3 14.3 14.7   15 15.5 15.8 16.4 17.3 17.8 18.1 18.7 19.7 21.5 24.4   26 27.3 32.4 33.9   NA\n##         2    2    2    2    2    2    2    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    0\n## %     6.2  6.2  6.2  6.2  6.2  6.2  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1    0 \n## %!NA  6.2  6.2  6.2  6.2  6.2  6.2  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1 \n## \n## \n## Frequencies for cyl \n##         8    4    6   NA\n##        14   11    7    0\n## %    43.8 34.4 21.9    0 \n## %!NA 43.8 34.4 21.9 \n## \n## \n## Frequencies for disp \n##      275.8   160 167.6   360  71.1  75.7  78.7    79  95.1   108 120.1 120.3   121 140.8   145 146.7   225   258   301   304   318   350   351   400   440   460   472    NA\n##         3    2    2    2    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    0\n## %     9.4  6.2  6.2  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1    0 \n## %!NA  9.4  6.2  6.2  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1 \n## \n## \n## Frequencies for hp \n##       110  175  180   66  123  150  245   52   62   65   91   93   95   97  105  109  113  205  215  230  264  335   NA\n##         3    3    3    2    2    2    2    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    0\n## %     9.4  9.4  9.4  6.2  6.2  6.2  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1    0 \n## %!NA  9.4  9.4  9.4  6.2  6.2  6.2  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1 \n## \n## \n## Frequencies for drat \n##      3.07 3.92 2.76 3.08 3.15  3.9 4.08 4.22 2.93    3 3.21 3.23 3.54 3.62 3.69  3.7 3.73 3.77 3.85 4.11 4.43 4.93   NA\n##         3    3    2    2    2    2    2    2    1    1    1    1    1    1    1    1    1    1    1    1    1    1    0\n## %     9.4  9.4  6.2  6.2  6.2  6.2  6.2  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1    0 \n## %!NA  9.4  9.4  6.2  6.2  6.2  6.2  6.2  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1 \n## \n## \n## Frequencies for wt \n##       3.44  3.57 1.513 1.615 1.835 1.935  2.14   2.2  2.32 2.465  2.62  2.77  2.78 2.875  3.15  3.17  3.19 3.215 3.435  3.46  3.52  3.73  3.78  3.84 3.845  4.07  5.25 5.345 5.424    NA\n##         3    2    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    0\n## %     9.4  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1    0 \n## %!NA  9.4  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1 \n## \n## \n## Frequencies for qsec \n##      17.02  18.9  14.5  14.6 15.41  15.5 15.84 16.46  16.7 16.87  16.9 17.05  17.3  17.4 17.42  17.6 17.82 17.98    18  18.3 18.52  18.6 18.61 19.44 19.47  19.9    20 20.01 20.22  22.9    NA\n##         2    2    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    1    0\n## %     6.2  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1    0 \n## %!NA  6.2  6.2  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1  3.1 \n## \n## \n## Frequencies for vs \n##      V-shaped straight       NA\n##        18   14    0\n## %    56.2 43.8    0 \n## %!NA 56.2 43.8 \n## \n## \n## Frequencies for am \n##        auto manual     NA\n##        19   13    0\n## %    59.4 40.6    0 \n## %!NA 59.4 40.6 \n## \n## \n## Frequencies for gear \n##         3    4    5   NA\n##        15   12    5    0\n## %    46.9 37.5 15.6    0 \n## %!NA 46.9 37.5 15.6 \n## \n## \n## Frequencies for carb \n##         2    4    1    3    6    8   NA\n##        10   10    7    3    1    1    0\n## %    31.2 31.2 21.9  9.4  3.1  3.1    0 \n## %!NA 31.2 31.2 21.9  9.4  3.1  3.1\n<\/pre>\n
    psych::describe(dat)\n<\/code><\/pre>\n
    ##      vars  n   mean     sd median trimmed    mad   min    max  range  skew kurtosis    se\n## mpg     1 32  20.09   6.03  19.20   19.70   5.41 10.40  33.90  23.50  0.61    -0.37  1.07\n## cyl     2 32   6.19   1.79   6.00    6.23   2.97  4.00   8.00   4.00 -0.17    -1.76  0.32\n## disp    3 32 230.72 123.94 196.30  222.52 140.48 71.10 472.00 400.90  0.38    -1.21 21.91\n## hp      4 32 146.69  68.56 123.00  141.19  77.10 52.00 335.00 283.00  0.73    -0.14 12.12\n## drat    5 32   3.60   0.53   3.70    3.58   0.70  2.76   4.93   2.17  0.27    -0.71  0.09\n## wt      6 32   3.22   0.98   3.33    3.15   0.77  1.51   5.42   3.91  0.42    -0.02  0.17\n## qsec    7 32  17.85   1.79  17.71   17.83   1.42 14.50  22.90   8.40  0.37     0.34  0.32\n## vs*     8 32   1.56   0.50   2.00    1.58   0.00  1.00   2.00   1.00 -0.24    -2.00  0.09\n## am*     9 32   1.41   0.50   1.00    1.38   0.00  1.00   2.00   1.00  0.36    -1.92  0.09\n## gear   10 32   3.69   0.74   4.00    3.62   1.48  3.00   5.00   2.00  0.53    -1.07  0.13\n## carb   11 32   2.81   1.62   2.00    2.65   1.48  1.00   8.00   7.00  1.05     1.26  0.29\n<\/pre>\n
    #Hmisc::describe(dat)\n#pastecs::stat.desc(dat)\n<\/code><\/pre>\n
    \uadf8\ub9ac\uace0 \ub610<\/h3>\n
      \n
    • skimr::skim()<\/code><\/li>\n
    • DataExplorer::create_report()<\/code><\/li>\n
    • inspectdf::inspect_types()<\/code>\n
        \n
      • inspect_mem()<\/code><\/li>\n
      • inspect_cat()<\/code><\/li>\n
      • inspect_cor()<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
        #install.packages('skimr')\nlibrary(skimr)\nskim(dat)\n<\/code><\/pre>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
        <\/th>\n<\/th>\n<\/tr>\n<\/thead>\n
        Name<\/td>\ndat<\/td>\n<\/tr>\n
        Number of rows<\/td>\n32<\/td>\n<\/tr>\n
        Number of columns<\/td>\n11<\/td>\n<\/tr>\n
        _______________________<\/td>\n<\/td>\n<\/tr>\n
        Column type frequency:<\/td>\n<\/td>\n<\/tr>\n
        factor<\/td>\n2<\/td>\n<\/tr>\n
        numeric<\/td>\n9<\/td>\n<\/tr>\n
        ________________________<\/td>\n<\/td>\n<\/tr>\n
        Group variables<\/td>\nNone<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        Variable type: factor<\/strong><\/p>\n\n\n\n\n\n\n
        skim_variable<\/th>\nn_missing<\/th>\ncomplete_rate<\/th>\nordered<\/th>\nn_unique<\/th>\ntop_counts<\/th>\n<\/tr>\n<\/thead>\n
        vs<\/td>\n0<\/td>\n1<\/td>\nFALSE<\/td>\n2<\/td>\nV-s: 18, str: 14<\/td>\n<\/tr>\n
        am<\/td>\n0<\/td>\n1<\/td>\nFALSE<\/td>\n2<\/td>\naut: 19, man: 13<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        Variable type: numeric<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
        skim_variable<\/th>\nn_missing<\/th>\ncomplete_rate<\/th>\nmean<\/th>\nsd<\/th>\np0<\/th>\np25<\/th>\np50<\/th>\np75<\/th>\np100<\/th>\nhist<\/th>\n<\/tr>\n<\/thead>\n
        mpg<\/td>\n0<\/td>\n1<\/td>\n20.09<\/td>\n6.03<\/td>\n10.40<\/td>\n15.43<\/td>\n19.20<\/td>\n22.80<\/td>\n33.90<\/td>\n\u2583\u2587\u2585\u2581\u2582<\/td>\n<\/tr>\n
        cyl<\/td>\n0<\/td>\n1<\/td>\n6.19<\/td>\n1.79<\/td>\n4.00<\/td>\n4.00<\/td>\n6.00<\/td>\n8.00<\/td>\n8.00<\/td>\n\u2586\u2581\u2583\u2581\u2587<\/td>\n<\/tr>\n
        disp<\/td>\n0<\/td>\n1<\/td>\n230.72<\/td>\n123.94<\/td>\n71.10<\/td>\n120.83<\/td>\n196.30<\/td>\n326.00<\/td>\n472.00<\/td>\n\u2587\u2583\u2583\u2583\u2582<\/td>\n<\/tr>\n
        hp<\/td>\n0<\/td>\n1<\/td>\n146.69<\/td>\n68.56<\/td>\n52.00<\/td>\n96.50<\/td>\n123.00<\/td>\n180.00<\/td>\n335.00<\/td>\n\u2587\u2587\u2586\u2583\u2581<\/td>\n<\/tr>\n
        drat<\/td>\n0<\/td>\n1<\/td>\n3.60<\/td>\n0.53<\/td>\n2.76<\/td>\n3.08<\/td>\n3.70<\/td>\n3.92<\/td>\n4.93<\/td>\n\u2587\u2583\u2587\u2585\u2581<\/td>\n<\/tr>\n
        wt<\/td>\n0<\/td>\n1<\/td>\n3.22<\/td>\n0.98<\/td>\n1.51<\/td>\n2.58<\/td>\n3.33<\/td>\n3.61<\/td>\n5.42<\/td>\n\u2583\u2583\u2587\u2581\u2582<\/td>\n<\/tr>\n
        qsec<\/td>\n0<\/td>\n1<\/td>\n17.85<\/td>\n1.79<\/td>\n14.50<\/td>\n16.89<\/td>\n17.71<\/td>\n18.90<\/td>\n22.90<\/td>\n\u2583\u2587\u2587\u2582\u2581<\/td>\n<\/tr>\n
        gear<\/td>\n0<\/td>\n1<\/td>\n3.69<\/td>\n0.74<\/td>\n3.00<\/td>\n3.00<\/td>\n4.00<\/td>\n4.00<\/td>\n5.00<\/td>\n\u2587\u2581\u2586\u2581\u2582<\/td>\n<\/tr>\n
        carb<\/td>\n0<\/td>\n1<\/td>\n2.81<\/td>\n1.62<\/td>\n1.00<\/td>\n2.00<\/td>\n2.00<\/td>\n4.00<\/td>\n8.00<\/td>\n\u2587\u2582\u2585\u2581\u2581<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        #install.packages('inspectdf')\nlibrary(inspectdf)\n#inspect_types(dat2) %>% show_plot()\n#inspect_types(dat2, dat) %>% show_plot()\n#inspect_mem(dat2) %>% show_plot()\n#inspect_na(dat2) %>% show_plot()\n#inspect_num(dat2) %>% show_plot()\n#inspect_imb(dat2) %>% show_plot()\n#inspect_cat(dat2) %>% show_plot()\n#inspect_cor(dat2) %>% show_plot()\n<\/code><\/pre>\n
        GGally::ggpairs()<\/code><\/h2>\n
        R\uc758 \uae30\ubcf8 \uadf8\ub798\ud53d \ud568\uc218 pairs()<\/code>\ub098 GGally::ggpairs()<\/code> \uc5ed\uc2dc \uc694\uae34\ud558\ub2e4!<\/p>\n
        pairs(dat2)\nGGally::ggpairs(dat2)\n<\/code><\/pre>\n
        \"plot\"plot<\/p>\n
        P.S<\/h3>\n
        \ub9c8\uc9c0\ub9c9\uc73c\ub85c create_report(dat)<\/code>\uc758 \uacb0\uacfc\ub294 …<\/p>\n
        #install.packages('DataExplorer')\nlibrary(DataExplorer)\ncreate_report(dat)\n<\/code><\/pre>\n
        \"\"\/<\/p>\n","protected":false},"excerpt":{"rendered":"
        \ub370\uc774\ud130 \ud504\ub808\uc784 \uc0b4\ud3b4\ubcf4\uae30 \ucd5c\uadfc \ud2b9\uac15\uc744 \uc900\ube44\ud558\uba74\uc11c, \ub370\uc774\ud130 \ud504\ub808\uc784 \uc804\uccb4\uc5d0 \ub300\ud574 \uc694\uc57d\/\uc815\ub9ac\ud558\ub294 \ud328\ud0a4\uc9c0\/\ud568\uc218\uac00 \uc5ec\ub7ff \uac1c\ubc1c\ub418\uc5c8\uc74c\uc744 \ud655\uc778\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 mtcars\ub97c \ud65c\uc6a9\ud558\uc5ec \uc774\ub4e4\uc744 \uc0ac\uc6a9\ud558\ub294 \uc608\ub97c \ubcf4\uc774\uaca0\uc2b5\ub2c8\ub2e4. mtcars head(mtcars) ## mpg cyl disp hp drat wt qsec vs am gear carb ## Mazda RX4 21.0 6 160 110 3.90 2.620 16.46 0 1 4 4 ## Mazda RX4 Wag 21.0 […]<\/p>\n","protected":false},"author":1,"featured_media":2145,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[371],"tags":[442,441],"jetpack_featured_media_url":"http:\/\/ds.sumeun.org\/wp-content\/uploads\/2020\/02\/summarising.png","_links":{"self":[{"href":"http:\/\/ds.sumeun.org\/index.php?rest_route=\/wp\/v2\/posts\/2142"}],"collection":[{"href":"http:\/\/ds.sumeun.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/ds.sumeun.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/ds.sumeun.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/ds.sumeun.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2142"}],"version-history":[{"count":3,"href":"http:\/\/ds.sumeun.org\/index.php?rest_route=\/wp\/v2\/posts\/2142\/revisions"}],"predecessor-version":[{"id":2146,"href":"http:\/\/ds.sumeun.org\/index.php?rest_route=\/wp\/v2\/posts\/2142\/revisions\/2146"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/ds.sumeun.org\/index.php?rest_route=\/wp\/v2\/media\/2145"}],"wp:attachment":[{"href":"http:\/\/ds.sumeun.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/ds.sumeun.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2142"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/ds.sumeun.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}