Install the relevant packages and library

library(ROCR)
library(tidyverse)
## -- Attaching packages --------------------------------------- tidyverse 1.3.1 --
## v ggplot2 3.3.5     v purrr   0.3.4
## v tibble  3.1.6     v dplyr   1.0.7
## v tidyr   1.1.4     v stringr 1.4.0
## v readr   2.1.1     v forcats 0.5.1
## -- Conflicts ------------------------------------------ tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x dplyr::lag()    masks stats::lag()
library(dplyr)
library(caret)
## Loading required package: lattice
## 
## Attaching package: 'caret'
## The following object is masked from 'package:purrr':
## 
##     lift
library(mlbench)
library(readr)
library(skimr)
library(DataExplorer)
library(funModeling) 
## Loading required package: Hmisc
## Loading required package: survival
## 
## Attaching package: 'survival'
## The following object is masked from 'package:caret':
## 
##     cluster
## Loading required package: Formula
## 
## Attaching package: 'Hmisc'
## The following objects are masked from 'package:dplyr':
## 
##     src, summarize
## The following objects are masked from 'package:base':
## 
##     format.pval, units
## funModeling v.1.9.4 :)
## Examples and tutorials at livebook.datascienceheroes.com
##  / Now in Spanish: librovivodecienciadedatos.ai
library(Hmisc)

Load the dataset

dfold <- read.csv("D:/01a Prog DS (Thursday)/02 AA 8 Jan 2022/dfnew.csv")

4 Ways of getting inital understanding

# HEAD / TAIL / CLASS
# It allows us to see the first 6 rows by default. We are going to override the default and ask to preview the first 10 rows and last 10 rows
head(dfold, 10)
##    ID Gender Grade Horoscope Subject     IntExt    OptPest ScreenTime Sleep
## 1   1   male     4   Scorpio    Math  Extravert   Optimist          1     7
## 2   2 female     4 Capricorn     Gym  Extravert   Optimist          1     8
## 3   3   male     4    Taurus    Math  Introvert   Optimist          4     9
## 4   4   male     4  Aquarius    Math Don't Know Don't Know          3     9
## 5   5   male     4   Scorpio     Gym Don't Know Don't Know          1     9
## 6   6   male     4    Pisces     Gym  Extravert   Optimist          2     9
## 7   7   male     3   Scorpio     Art  Introvert   Optimist          1    11
## 8   8   male     6    Taurus    Math  Extravert   Optimist          4     9
## 9   9   male     6     Aries     Gym  Introvert  Pessimist          6     8
## 10 10   male     6    Pisces    Math  Introvert Don't Know          3     9
##    PhysActive HrsHomework      SpendTime1           SpendTime2       Self1
## 1          10          10        baseball             relaxing      active
## 2           5           0 playing outside             swimming        kind
## 3          22           1     video games               soccer      active
## 4           9           1     video games               sports      active
## 5          10           1         reading          hanging out intellegent
## 6          20           2          sports playing with friends       funny
## 7           4          14     watching TV              reading      joyful
## 8          12          21     video games      playing outside         fun
## 9           4           6     video games               biking         sad
## 10         12           3     video games dungeons and dragons       smart
##          Self2                       Career                   Superpower
## 1  competitive professional baseball player                  sonic speed
## 2       active                      Teacher        power to grant wishes
## 3     creative   professional soccer player                powerful kick
## 4  responsible   professional hockey player                 teleportaion
## 5       strong                     engineer power to answer any question
## 6       active   professional hockey player                          fly
## 7         lazy                       artist                  telekinesis
## 8    confident                       banker                teleportation
## 9         calm           computer scientist         materialize anything
## 10       tired                      Teacher         manipulating physics
tail(dfold, 10)
##      ID Gender Grade   Horoscope Subject    IntExt   OptPest ScreenTime Sleep
## 176 176   male     6       Aries    Math Extravert Pessimist          1     9
## 177 177 female     6       Virgo Science Extravert Pessimist          8     7
## 178 178   male     6       Aries    Math Extravert  Optimist          2     8
## 179 179 female     6    Aquarius     Gym Extravert Pessimist          6     8
## 180 180   male     6   Capricorn    Math Extravert  Optimist          2     9
## 181 181 female     6       Aries     Gym Extravert Pessimist          5     6
## 182 182   male     6 Sagittarius    Math Extravert  Optimist          1    11
## 183 183   male     6      Cancer     Gym Extravert  Optimist          3     9
## 184 184 female     6       Aries     Gym Extravert  Optimist          2     9
## 185 185 female     6      Gemini     Art Introvert Pessimist          5     9
##     PhysActive HrsHomework       SpendTime1           SpendTime2     Self1
## 176         22           7       basketball          video games       fun
## 177          1           1           eating          video games      lazy
## 178         10           9   playing sports playing with friends    sporty
## 179          7           0 watching youtube             sleeping      load
## 180         10           1          nothing              nothing       fun
## 181          7           0 playing with dog          volley ball agressive
## 182         13           6   playing sports              reading      nice
## 183         11           5      video games playing with friends       fun
## 184          7           0          playing playing with animals     hyper
## 185          7           9 watching youtube              drawing     tired
##         Self2      Career     Superpower
## 176      cool      doctor    super speed
## 177     funky horse rider  teleportation
## 178     smart     surgeon    super speed
## 179 energitic      lawyer   mind reading
## 180 energetic    inventor shape shifting
## 181   anoying  movue star  teleportation
## 182     smart    enginere   invisibility
## 183 energetic   zoologist    super speed
## 184    flimsy       happy    super speed
## 185     smart      artist           <NA>
class(dfold)
## [1] "data.frame"
# DIM 
# Displays the dimensions of the table. The output takes the form of row, column.
dim(dfold)
## [1] 185  17
### GLIMPSE
# Displays the type and a preview of all columns as a row so that it's very easy to take in.
# This will display a vertical preview of the dataset. 
# It allows us to easily preview the data type and sample data.
glimpse(dfold)
## Rows: 185
## Columns: 17
## $ ID          <int> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17,~
## $ Gender      <chr> "male", "female", "male", "male", "male", "male", "male", ~
## $ Grade       <int> 4, 4, 4, 4, 4, 4, 3, 6, 6, 6, 4, 4, 4, 7, 8, 8, 8, 8, 8, 8~
## $ Horoscope   <chr> "Scorpio", "Capricorn", "Taurus", "Aquarius", "Scorpio", "~
## $ Subject     <chr> "Math", "Gym", "Math", "Math", "Gym", "Gym", "Art", "Math"~
## $ IntExt      <chr> "Extravert", "Extravert", "Introvert", "Don't Know", "Don'~
## $ OptPest     <chr> "Optimist", "Optimist", "Optimist", "Don't Know", "Don't K~
## $ ScreenTime  <dbl> 1, 1, 4, 3, 1, 2, 1, 4, 6, 3, 1, 1, 0, 5, 6, 5, 8, 4, 2, 3~
## $ Sleep       <dbl> 7, 8, 9, 9, 9, 9, 11, 9, 8, 9, 10, 10, 9, 8, 9, 7, 7, 8, 9~
## $ PhysActive  <int> 10, 5, 22, 9, 10, 20, 4, 12, 4, 12, 5, 5, 5, 14, 25, 6, 2,~
## $ HrsHomework <dbl> 10, 0, 1, 1, 1, 2, 14, 21, 6, 3, 0, 0, 0, 4, 2, 3, 0, 0, 3~
## $ SpendTime1  <chr> "baseball", "playing outside", "video games", "video games~
## $ SpendTime2  <chr> "relaxing", "swimming", "soccer", "sports", "hanging out",~
## $ Self1       <chr> "active", "kind", "active", "active", "intellegent", "funn~
## $ Self2       <chr> "competitive", "active", "creative", "responsible", "stron~
## $ Career      <chr> "professional baseball player", "Teacher", "professional s~
## $ Superpower  <chr> "sonic speed", "power to grant wishes", "powerful kick", "~
# STRUCTURE 
str(dfold)
## 'data.frame':    185 obs. of  17 variables:
##  $ ID         : int  1 2 3 4 5 6 7 8 9 10 ...
##  $ Gender     : chr  "male" "female" "male" "male" ...
##  $ Grade      : int  4 4 4 4 4 4 3 6 6 6 ...
##  $ Horoscope  : chr  "Scorpio" "Capricorn" "Taurus" "Aquarius" ...
##  $ Subject    : chr  "Math" "Gym" "Math" "Math" ...
##  $ IntExt     : chr  "Extravert" "Extravert" "Introvert" "Don't Know" ...
##  $ OptPest    : chr  "Optimist" "Optimist" "Optimist" "Don't Know" ...
##  $ ScreenTime : num  1 1 4 3 1 2 1 4 6 3 ...
##  $ Sleep      : num  7 8 9 9 9 9 11 9 8 9 ...
##  $ PhysActive : int  10 5 22 9 10 20 4 12 4 12 ...
##  $ HrsHomework: num  10 0 1 1 1 2 14 21 6 3 ...
##  $ SpendTime1 : chr  "baseball" "playing outside" "video games" "video games" ...
##  $ SpendTime2 : chr  "relaxing" "swimming" "soccer" "sports" ...
##  $ Self1      : chr  "active" "kind" "active" "active" ...
##  $ Self2      : chr  "competitive" "active" "creative" "responsible" ...
##  $ Career     : chr  "professional baseball player" "Teacher" "professional soccer player" "professional hockey player" ...
##  $ Superpower : chr  "sonic speed" "power to grant wishes" "powerful kick" "teleportaion" ...
# STATUS
status(dfold)
##                variable q_zeros     p_zeros q_na        p_na q_inf p_inf
## ID                   ID       0 0.000000000    0 0.000000000     0     0
## Gender           Gender       0 0.000000000    0 0.000000000     0     0
## Grade             Grade       0 0.000000000    0 0.000000000     0     0
## Horoscope     Horoscope       0 0.000000000    0 0.000000000     0     0
## Subject         Subject       0 0.000000000    1 0.005405405     0     0
## IntExt           IntExt       0 0.000000000    0 0.000000000     0     0
## OptPest         OptPest       0 0.000000000    0 0.000000000     0     0
## ScreenTime   ScreenTime       3 0.016216216    0 0.000000000     0     0
## Sleep             Sleep       0 0.000000000    0 0.000000000     0     0
## PhysActive   PhysActive       1 0.005405405    1 0.005405405     0     0
## HrsHomework HrsHomework      26 0.140540541    0 0.000000000     0     0
## SpendTime1   SpendTime1       0 0.000000000    0 0.000000000     0     0
## SpendTime2   SpendTime2       0 0.000000000    0 0.000000000     0     0
## Self1             Self1       0 0.000000000    2 0.010810811     0     0
## Self2             Self2       0 0.000000000    1 0.005405405     0     0
## Career           Career       0 0.000000000    2 0.010810811     0     0
## Superpower   Superpower       0 0.000000000    8 0.043243243     0     0
##                  type unique
## ID            integer    185
## Gender      character      3
## Grade         integer      6
## Horoscope   character     12
## Subject     character      5
## IntExt      character      3
## OptPest     character      3
## ScreenTime    numeric     13
## Sleep         numeric     12
## PhysActive    integer     33
## HrsHomework   numeric     18
## SpendTime1  character     95
## SpendTime2  character    107
## Self1       character    103
## Self2       character    101
## Career      character    106
## Superpower  character    100

4 Ways of Sub-setting

# select variables Grade, Subject, OptPest
getvar1 <- dfold[c('Grade', 'Subject', 'OptPest')]
getvar1
##     Grade Subject    OptPest
## 1       4    Math   Optimist
## 2       4     Gym   Optimist
## 3       4    Math   Optimist
## 4       4    Math Don't Know
## 5       4     Gym Don't Know
## 6       4     Gym   Optimist
## 7       3     Art   Optimist
## 8       6    Math   Optimist
## 9       6     Gym  Pessimist
## 10      6    Math Don't Know
## 11      4     Gym   Optimist
## 12      4    Math   Optimist
## 13      4     Art   Optimist
## 14      7     Gym Don't Know
## 15      8     Gym   Optimist
## 16      8     Gym   Optimist
## 17      8 Science   Optimist
## 18      8     Gym   Optimist
## 19      8    Math   Optimist
## 20      8     Art  Pessimist
## 21      5     Art   Optimist
## 22      6 Science Don't Know
## 23      5     Art   Optimist
## 24      6     Art   Optimist
## 25      6 Science   Optimist
## 26      6     Art  Pessimist
## 27      6     Gym  Pessimist
## 28      6 Science Don't Know
## 29      6    Math  Pessimist
## 30      6 Science   Optimist
## 31      8 Science   Optimist
## 32      8 Science Don't Know
## 33      8 Science Don't Know
## 34      7     Art  Pessimist
## 35      7     Gym   Optimist
## 36      8     Art   Optimist
## 37      8 History Don't Know
## 38      7    Math  Pessimist
## 39      8    Math   Optimist
## 40      8     Gym  Pessimist
## 41      5    Math  Pessimist
## 42      5     Gym Don't Know
## 43      5     Gym  Pessimist
## 44      5     Gym  Pessimist
## 45      5 Science   Optimist
## 46      5     Gym  Pessimist
## 47      5     Gym   Optimist
## 48      5     Art   Optimist
## 49      5    Math   Optimist
## 50      5     Art Don't Know
## 51      5     Art   Optimist
## 52      6     Gym   Optimist
## 53      6 History   Optimist
## 54      5     Gym   Optimist
## 55      5     Gym   Optimist
## 56      4     Gym   Optimist
## 57      4 History   Optimist
## 58      4     Gym   Optimist
## 59      6    Math   Optimist
## 60      6    Math Don't Know
## 61      6     Gym Don't Know
## 62      6     Art Don't Know
## 63      6    Math Don't Know
## 64      6    Math Don't Know
## 65      6     Gym   Optimist
## 66      6     Gym   Optimist
## 67      6     Gym   Optimist
## 68      6     Gym   Optimist
## 69      4    Math  Pessimist
## 70      4    Math  Pessimist
## 71      6     Gym   Optimist
## 72      6 Science   Optimist
## 73      6     Gym   Optimist
## 74      4     Art   Optimist
## 75      4     Art  Pessimist
## 76      4     Art   Optimist
## 77      4    Math   Optimist
## 78      4     Gym   Optimist
## 79      4 Science  Pessimist
## 80      4 Science  Pessimist
## 81      4     Art  Pessimist
## 82      4    Math  Pessimist
## 83      4     Art Don't Know
## 84      4     Gym   Optimist
## 85      4     Gym   Optimist
## 86      4     Gym   Optimist
## 87      4     Gym   Optimist
## 88      4     Art   Optimist
## 89      4     Art   Optimist
## 90      5 Science   Optimist
## 91      5     Gym  Pessimist
## 92      5    Math Don't Know
## 93      5     Gym Don't Know
## 94      6    Math  Pessimist
## 95      3    <NA> Don't Know
## 96      4     Art Don't Know
## 97      5     Gym   Optimist
## 98      5 Science  Pessimist
## 99      5    Math  Pessimist
## 100     5    Math  Pessimist
## 101     5    Math   Optimist
## 102     6     Art  Pessimist
## 103     6     Gym Don't Know
## 104     7     Art   Optimist
## 105     7     Gym   Optimist
## 106     7     Gym   Optimist
## 107     7 History   Optimist
## 108     7     Art  Pessimist
## 109     7    Math   Optimist
## 110     7    Math   Optimist
## 111     7    Math   Optimist
## 112     7     Gym  Pessimist
## 113     7     Gym   Optimist
## 114     8    Math   Optimist
## 115     8     Art   Optimist
## 116     8     Gym Don't Know
## 117     8     Art Don't Know
## 118     8     Art Don't Know
## 119     8     Art   Optimist
## 120     8     Gym   Optimist
## 121     8     Art   Optimist
## 122     8 Science Don't Know
## 123     8 History   Optimist
## 124     6    Math  Pessimist
## 125     6    Math  Pessimist
## 126     6     Gym  Pessimist
## 127     6     Gym  Pessimist
## 128     6 Science  Pessimist
## 129     6     Gym  Pessimist
## 130     6    Math Don't Know
## 131     6    Math   Optimist
## 132     6 Science   Optimist
## 133     6    Math   Optimist
## 134     8 Science  Pessimist
## 135     8 Science   Optimist
## 136     8     Gym   Optimist
## 137     8     Art  Pessimist
## 138     8     Art   Optimist
## 139     8     Gym  Pessimist
## 140     8 Science   Optimist
## 141     8     Art  Pessimist
## 142     8     Gym   Optimist
## 143     8     Art   Optimist
## 144     5     Gym   Optimist
## 145     4     Gym Don't Know
## 146     4     Art   Optimist
## 147     4     Gym   Optimist
## 148     5 History  Pessimist
## 149     5    Math   Optimist
## 150     6     Art  Pessimist
## 151     6     Gym Don't Know
## 152     5    Math   Optimist
## 153     5     Gym  Pessimist
## 154     5     Gym   Optimist
## 155     5 Science  Pessimist
## 156     5     Art   Optimist
## 157     5 Science  Pessimist
## 158     5    Math Don't Know
## 159     5     Gym   Optimist
## 160     5     Gym Don't Know
## 161     5     Gym Don't Know
## 162     5     Gym   Optimist
## 163     5 Science  Pessimist
## 164     6     Gym  Pessimist
## 165     6 History  Pessimist
## 166     6     Gym   Optimist
## 167     6     Gym   Optimist
## 168     4 Science   Optimist
## 169     4     Gym  Pessimist
## 170     4     Art Don't Know
## 171     4     Gym   Optimist
## 172     4    Math   Optimist
## 173     4 Science  Pessimist
## 174     4 History  Pessimist
## 175     4 Science Don't Know
## 176     6    Math  Pessimist
## 177     6 Science  Pessimist
## 178     6    Math   Optimist
## 179     6     Gym  Pessimist
## 180     6    Math   Optimist
## 181     6     Gym  Pessimist
## 182     6    Math   Optimist
## 183     6     Gym   Optimist
## 184     6     Gym   Optimist
## 185     6     Art  Pessimist
# select all rows for columns 'Grade', 'Subject' and 'OptPest'
dfold[ , c('Grade', 'Subject', 'OptPest')]
##     Grade Subject    OptPest
## 1       4    Math   Optimist
## 2       4     Gym   Optimist
## 3       4    Math   Optimist
## 4       4    Math Don't Know
## 5       4     Gym Don't Know
## 6       4     Gym   Optimist
## 7       3     Art   Optimist
## 8       6    Math   Optimist
## 9       6     Gym  Pessimist
## 10      6    Math Don't Know
## 11      4     Gym   Optimist
## 12      4    Math   Optimist
## 13      4     Art   Optimist
## 14      7     Gym Don't Know
## 15      8     Gym   Optimist
## 16      8     Gym   Optimist
## 17      8 Science   Optimist
## 18      8     Gym   Optimist
## 19      8    Math   Optimist
## 20      8     Art  Pessimist
## 21      5     Art   Optimist
## 22      6 Science Don't Know
## 23      5     Art   Optimist
## 24      6     Art   Optimist
## 25      6 Science   Optimist
## 26      6     Art  Pessimist
## 27      6     Gym  Pessimist
## 28      6 Science Don't Know
## 29      6    Math  Pessimist
## 30      6 Science   Optimist
## 31      8 Science   Optimist
## 32      8 Science Don't Know
## 33      8 Science Don't Know
## 34      7     Art  Pessimist
## 35      7     Gym   Optimist
## 36      8     Art   Optimist
## 37      8 History Don't Know
## 38      7    Math  Pessimist
## 39      8    Math   Optimist
## 40      8     Gym  Pessimist
## 41      5    Math  Pessimist
## 42      5     Gym Don't Know
## 43      5     Gym  Pessimist
## 44      5     Gym  Pessimist
## 45      5 Science   Optimist
## 46      5     Gym  Pessimist
## 47      5     Gym   Optimist
## 48      5     Art   Optimist
## 49      5    Math   Optimist
## 50      5     Art Don't Know
## 51      5     Art   Optimist
## 52      6     Gym   Optimist
## 53      6 History   Optimist
## 54      5     Gym   Optimist
## 55      5     Gym   Optimist
## 56      4     Gym   Optimist
## 57      4 History   Optimist
## 58      4     Gym   Optimist
## 59      6    Math   Optimist
## 60      6    Math Don't Know
## 61      6     Gym Don't Know
## 62      6     Art Don't Know
## 63      6    Math Don't Know
## 64      6    Math Don't Know
## 65      6     Gym   Optimist
## 66      6     Gym   Optimist
## 67      6     Gym   Optimist
## 68      6     Gym   Optimist
## 69      4    Math  Pessimist
## 70      4    Math  Pessimist
## 71      6     Gym   Optimist
## 72      6 Science   Optimist
## 73      6     Gym   Optimist
## 74      4     Art   Optimist
## 75      4     Art  Pessimist
## 76      4     Art   Optimist
## 77      4    Math   Optimist
## 78      4     Gym   Optimist
## 79      4 Science  Pessimist
## 80      4 Science  Pessimist
## 81      4     Art  Pessimist
## 82      4    Math  Pessimist
## 83      4     Art Don't Know
## 84      4     Gym   Optimist
## 85      4     Gym   Optimist
## 86      4     Gym   Optimist
## 87      4     Gym   Optimist
## 88      4     Art   Optimist
## 89      4     Art   Optimist
## 90      5 Science   Optimist
## 91      5     Gym  Pessimist
## 92      5    Math Don't Know
## 93      5     Gym Don't Know
## 94      6    Math  Pessimist
## 95      3    <NA> Don't Know
## 96      4     Art Don't Know
## 97      5     Gym   Optimist
## 98      5 Science  Pessimist
## 99      5    Math  Pessimist
## 100     5    Math  Pessimist
## 101     5    Math   Optimist
## 102     6     Art  Pessimist
## 103     6     Gym Don't Know
## 104     7     Art   Optimist
## 105     7     Gym   Optimist
## 106     7     Gym   Optimist
## 107     7 History   Optimist
## 108     7     Art  Pessimist
## 109     7    Math   Optimist
## 110     7    Math   Optimist
## 111     7    Math   Optimist
## 112     7     Gym  Pessimist
## 113     7     Gym   Optimist
## 114     8    Math   Optimist
## 115     8     Art   Optimist
## 116     8     Gym Don't Know
## 117     8     Art Don't Know
## 118     8     Art Don't Know
## 119     8     Art   Optimist
## 120     8     Gym   Optimist
## 121     8     Art   Optimist
## 122     8 Science Don't Know
## 123     8 History   Optimist
## 124     6    Math  Pessimist
## 125     6    Math  Pessimist
## 126     6     Gym  Pessimist
## 127     6     Gym  Pessimist
## 128     6 Science  Pessimist
## 129     6     Gym  Pessimist
## 130     6    Math Don't Know
## 131     6    Math   Optimist
## 132     6 Science   Optimist
## 133     6    Math   Optimist
## 134     8 Science  Pessimist
## 135     8 Science   Optimist
## 136     8     Gym   Optimist
## 137     8     Art  Pessimist
## 138     8     Art   Optimist
## 139     8     Gym  Pessimist
## 140     8 Science   Optimist
## 141     8     Art  Pessimist
## 142     8     Gym   Optimist
## 143     8     Art   Optimist
## 144     5     Gym   Optimist
## 145     4     Gym Don't Know
## 146     4     Art   Optimist
## 147     4     Gym   Optimist
## 148     5 History  Pessimist
## 149     5    Math   Optimist
## 150     6     Art  Pessimist
## 151     6     Gym Don't Know
## 152     5    Math   Optimist
## 153     5     Gym  Pessimist
## 154     5     Gym   Optimist
## 155     5 Science  Pessimist
## 156     5     Art   Optimist
## 157     5 Science  Pessimist
## 158     5    Math Don't Know
## 159     5     Gym   Optimist
## 160     5     Gym Don't Know
## 161     5     Gym Don't Know
## 162     5     Gym   Optimist
## 163     5 Science  Pessimist
## 164     6     Gym  Pessimist
## 165     6 History  Pessimist
## 166     6     Gym   Optimist
## 167     6     Gym   Optimist
## 168     4 Science   Optimist
## 169     4     Gym  Pessimist
## 170     4     Art Don't Know
## 171     4     Gym   Optimist
## 172     4    Math   Optimist
## 173     4 Science  Pessimist
## 174     4 History  Pessimist
## 175     4 Science Don't Know
## 176     6    Math  Pessimist
## 177     6 Science  Pessimist
## 178     6    Math   Optimist
## 179     6     Gym  Pessimist
## 180     6    Math   Optimist
## 181     6     Gym  Pessimist
## 182     6    Math   Optimist
## 183     6     Gym   Optimist
## 184     6     Gym   Optimist
## 185     6     Art  Pessimist
# select 1st and 5th thru 10th variables
getvar2 <- dfold[c(1,5:10)]
getvar2
##      ID Subject     IntExt    OptPest ScreenTime Sleep PhysActive
## 1     1    Math  Extravert   Optimist        1.0   7.0         10
## 2     2     Gym  Extravert   Optimist        1.0   8.0          5
## 3     3    Math  Introvert   Optimist        4.0   9.0         22
## 4     4    Math Don't Know Don't Know        3.0   9.0          9
## 5     5     Gym Don't Know Don't Know        1.0   9.0         10
## 6     6     Gym  Extravert   Optimist        2.0   9.0         20
## 7     7     Art  Introvert   Optimist        1.0  11.0          4
## 8     8    Math  Extravert   Optimist        4.0   9.0         12
## 9     9     Gym  Introvert  Pessimist        6.0   8.0          4
## 10   10    Math  Introvert Don't Know        3.0   9.0         12
## 11   11     Gym Don't Know   Optimist        1.0  10.0          5
## 12   12    Math Don't Know   Optimist        1.0  10.0          5
## 13   13     Art  Extravert   Optimist        0.0   9.0          5
## 14   14     Gym  Extravert Don't Know        5.0   8.0         14
## 15   15     Gym Don't Know   Optimist        6.0   9.0         25
## 16   16     Gym  Introvert   Optimist        5.0   7.0          6
## 17   17 Science  Introvert   Optimist        8.0   7.0          2
## 18   18     Gym  Introvert   Optimist        4.0   8.0         10
## 19   19    Math  Introvert   Optimist        2.0   9.0         10
## 20   20     Art  Extravert  Pessimist        3.0   8.0         10
## 21   21     Art  Introvert   Optimist        2.0   9.0          2
## 22   22 Science  Introvert Don't Know        1.0   8.0          5
## 23   23     Art  Extravert   Optimist        1.0   9.0          1
## 24   24     Art  Introvert   Optimist        4.0   9.0          6
## 25   25 Science  Extravert   Optimist        1.0   8.0          7
## 26   26     Art  Introvert  Pessimist        3.0   6.0         14
## 27   27     Gym  Extravert  Pessimist        1.0  10.0          5
## 28   28 Science  Introvert Don't Know        3.0  10.0          5
## 29   29    Math Don't Know  Pessimist        4.0   9.0         14
## 30   30 Science  Extravert   Optimist        4.0   9.0          9
## 31   31 Science  Extravert   Optimist        9.0   8.0          8
## 32   32 Science Don't Know Don't Know       10.0   5.0          5
## 33   33 Science  Extravert Don't Know       10.0   3.0          7
## 34   34     Art  Introvert  Pessimist        3.0   9.0          3
## 35   35     Gym Don't Know   Optimist        3.0   8.0          7
## 36   36     Art Don't Know   Optimist        4.0   8.0          7
## 37   37 History Don't Know Don't Know        5.0  10.0          7
## 38   38    Math  Introvert  Pessimist        2.0   9.0         14
## 39   39    Math  Extravert   Optimist        2.0   9.0         10
## 40   40     Gym  Extravert  Pessimist        2.0   9.0          9
## 41   41    Math Don't Know  Pessimist        1.0   9.0          9
## 42   42     Gym  Extravert Don't Know        6.0   8.0         11
## 43   43     Gym  Extravert  Pessimist        4.0   8.0         14
## 44   44     Gym  Extravert  Pessimist        1.0   9.0         12
## 45   45 Science Don't Know   Optimist        3.0   8.0          7
## 46   46     Gym  Extravert  Pessimist        1.0  11.0          5
## 47   47     Gym  Extravert   Optimist        2.0  10.0         11
## 48   48     Art  Extravert   Optimist        1.0   7.0          5
## 49   49    Math  Introvert   Optimist        2.0  10.0          6
## 50   50     Art  Introvert Don't Know        2.0   8.0          8
## 51   51     Art  Extravert   Optimist        5.0   9.0          8
## 52   52     Gym  Extravert   Optimist        1.0  10.0         10
## 53   53 History  Extravert   Optimist        3.0   9.0          6
## 54   54     Gym  Extravert   Optimist        2.0   7.0          2
## 55   55     Gym  Extravert   Optimist        4.0   9.0         12
## 56   56     Gym  Extravert   Optimist        3.0  10.0          5
## 57   57 History  Introvert   Optimist        1.0   8.0         82
## 58   58     Gym  Introvert   Optimist        1.0  10.0          3
## 59   59    Math  Extravert   Optimist        1.0   9.0          5
## 60   60    Math  Introvert Don't Know        1.0  10.0          4
## 61   61     Gym  Introvert Don't Know        3.0   8.0         10
## 62   62     Art Don't Know Don't Know        4.0  12.0          3
## 63   63    Math  Extravert Don't Know        3.0   9.0          8
## 64   64    Math Don't Know Don't Know        1.0   9.0          2
## 65   65     Gym  Introvert   Optimist        1.0   8.0         10
## 66   66     Gym  Introvert   Optimist        3.0  10.0         15
## 67   67     Gym  Extravert   Optimist        5.0   9.0         10
## 68   68     Gym  Extravert   Optimist        1.0  10.0         12
## 69   69    Math  Introvert  Pessimist        1.0  10.0         70
## 70   70    Math  Extravert  Pessimist        3.0   8.0         50
## 71   71     Gym  Extravert   Optimist        1.0   9.0         14
## 72   72 Science  Introvert   Optimist        2.0   9.0          7
## 73   73     Gym  Introvert   Optimist        1.0   9.0         21
## 74   74     Art  Introvert   Optimist        2.0  10.0         20
## 75   75     Art Don't Know  Pessimist        3.0   9.0          7
## 76   76     Art Don't Know   Optimist        2.0  11.0         10
## 77   77    Math  Extravert   Optimist        1.0   9.0         36
## 78   78     Gym Don't Know   Optimist        1.0   9.0          8
## 79   79 Science  Extravert  Pessimist        1.0   8.0         72
## 80   80 Science  Extravert  Pessimist        2.0   8.0          9
## 81   81     Art Don't Know  Pessimist        1.0  12.0          2
## 82   82    Math  Extravert  Pessimist        1.0  11.0         12
## 83   83     Art Don't Know Don't Know        0.0  10.0          2
## 84   84     Gym Don't Know   Optimist        1.0  10.0         28
## 85   85     Gym  Extravert   Optimist        2.0   9.0         30
## 86   86     Gym  Extravert   Optimist        1.0   8.0         10
## 87   87     Gym Don't Know   Optimist        2.0   9.0         16
## 88   88     Art  Extravert   Optimist        2.0  10.0         20
## 89   89     Art  Introvert   Optimist        1.0   9.0         19
## 90   90 Science  Extravert   Optimist        3.0  10.0         10
## 91   91     Gym  Extravert  Pessimist        4.0   9.0          6
## 92   92    Math  Introvert Don't Know        4.0   9.0         12
## 93   93     Gym  Extravert Don't Know        5.0   8.0          5
## 94   94    Math Don't Know  Pessimist        7.0   8.0          8
## 95   95    <NA> Don't Know Don't Know        1.0  10.0         10
## 96   96     Art Don't Know Don't Know        1.0  10.0         15
## 97   97     Gym Don't Know   Optimist        1.0  10.0          5
## 98   98 Science  Extravert  Pessimist        3.0  10.0         11
## 99   99    Math Don't Know  Pessimist        3.0   9.0          8
## 100 100    Math  Introvert  Pessimist        6.0   8.0          5
## 101 101    Math  Introvert   Optimist        4.0   9.0         11
## 102 102     Art  Introvert  Pessimist        3.0   8.0         10
## 103 103     Gym  Extravert Don't Know        3.0  10.0         10
## 104 104     Art Don't Know   Optimist        1.0   9.0          2
## 105 105     Gym  Extravert   Optimist        4.0   9.0         26
## 106 106     Gym  Extravert   Optimist        4.0   7.0         10
## 107 107 History  Extravert   Optimist        2.0   8.0         15
## 108 108     Art  Introvert  Pessimist        4.0   7.0          4
## 109 109    Math  Introvert   Optimist        0.5   9.0         14
## 110 110    Math  Extravert   Optimist        2.0   8.0          4
## 111 111    Math  Introvert   Optimist        2.0   9.5          4
## 112 112     Gym Don't Know  Pessimist        4.0   9.0         28
## 113 113     Gym Don't Know   Optimist        5.0   9.0         10
## 114 114    Math  Extravert   Optimist       18.0   6.0          0
## 115 115     Art  Extravert   Optimist        4.0   8.0         12
## 116 116     Gym  Extravert Don't Know        5.0   8.0         10
## 117 117     Art  Introvert Don't Know        3.0  10.0         10
## 118 118     Art  Extravert Don't Know        4.0   8.0          4
## 119 119     Art  Extravert   Optimist        5.0   8.0         15
## 120 120     Gym  Extravert   Optimist        5.0   8.0          8
## 121 121     Art Don't Know   Optimist        3.0   8.0          3
## 122 122 Science  Introvert Don't Know        5.0   7.0          6
## 123 123 History Don't Know   Optimist        1.0   9.0          6
## 124 124    Math Don't Know  Pessimist        4.0   9.0          6
## 125 125    Math  Introvert  Pessimist        3.0   5.0          8
## 126 126     Gym  Extravert  Pessimist        7.0   6.0          7
## 127 127     Gym  Introvert  Pessimist        6.0   8.0         12
## 128 128 Science  Introvert  Pessimist        1.0   9.0         10
## 129 129     Gym  Introvert  Pessimist        6.0   7.0          7
## 130 130    Math  Introvert Don't Know        3.0   9.0         14
## 131 131    Math  Extravert   Optimist        4.0   7.0         24
## 132 132 Science  Introvert   Optimist        1.0   9.0         12
## 133 133    Math  Introvert   Optimist        0.0   5.0         40
## 134 134 Science  Extravert  Pessimist        2.0  10.0          7
## 135 135 Science  Extravert   Optimist        2.0  10.0          5
## 136 136     Gym  Extravert   Optimist        2.0  10.0         14
## 137 137     Art  Extravert  Pessimist        3.0   8.0         20
## 138 138     Art  Extravert   Optimist        8.0   7.0          8
## 139 139     Gym  Introvert  Pessimist        1.0   6.0          1
## 140 140 Science  Extravert   Optimist        2.0   7.0         21
## 141 141     Art  Extravert  Pessimist        3.0   8.0          3
## 142 142     Gym Don't Know   Optimist        5.0   7.0         14
## 143 143     Art  Extravert   Optimist        4.0   8.0         18
## 144 144     Gym Don't Know   Optimist        2.0   8.0          5
## 145 145     Gym  Extravert Don't Know        1.0  10.0          7
## 146 146     Art  Extravert   Optimist        2.0  11.0         NA
## 147 147     Gym  Extravert   Optimist        2.0  10.0          7
## 148 148 History  Extravert  Pessimist        3.0  10.0          5
## 149 149    Math  Extravert   Optimist        3.0   9.0         10
## 150 150     Art  Extravert  Pessimist       10.0   2.0         13
## 151 151     Gym  Extravert Don't Know        5.0   4.0          8
## 152 152    Math  Extravert   Optimist        2.0  10.0          6
## 153 153     Gym Don't Know  Pessimist        4.0   4.0          9
## 154 154     Gym  Extravert   Optimist        1.0  10.0         40
## 155 155 Science Don't Know  Pessimist        4.0   9.0         15
## 156 156     Art  Extravert   Optimist        3.0   8.0          7
## 157 157 Science Don't Know  Pessimist        7.0   8.0         10
## 158 158    Math  Extravert Don't Know        4.0  10.0          7
## 159 159     Gym  Extravert   Optimist        1.0   8.0         16
## 160 160     Gym  Extravert Don't Know        2.0   9.0         11
## 161 161     Gym  Extravert Don't Know        2.0   8.0         16
## 162 162     Gym  Extravert   Optimist        5.0   3.0          5
## 163 163 Science Don't Know  Pessimist        6.0  11.0          7
## 164 164     Gym  Extravert  Pessimist        1.0  10.0          7
## 165 165 History  Introvert  Pessimist        1.0   8.0          7
## 166 166     Gym  Extravert   Optimist        3.0   9.0         12
## 167 167     Gym  Extravert   Optimist        5.0  10.0         15
## 168 168 Science  Extravert   Optimist        1.0  10.0         70
## 169 169     Gym  Introvert  Pessimist        1.0   8.0          3
## 170 170     Art  Extravert Don't Know        5.0  10.0          1
## 171 171     Gym Don't Know   Optimist        1.0  10.0          8
## 172 172    Math  Introvert   Optimist        1.0  11.0          7
## 173 173 Science  Introvert  Pessimist        1.0   8.0          9
## 174 174 History  Extravert  Pessimist        1.0  11.0          2
## 175 175 Science Don't Know Don't Know        1.0  10.0          9
## 176 176    Math  Extravert  Pessimist        1.0   9.0         22
## 177 177 Science  Extravert  Pessimist        8.0   7.0          1
## 178 178    Math  Extravert   Optimist        2.0   8.0         10
## 179 179     Gym  Extravert  Pessimist        6.0   8.0          7
## 180 180    Math  Extravert   Optimist        2.0   9.0         10
## 181 181     Gym  Extravert  Pessimist        5.0   6.0          7
## 182 182    Math  Extravert   Optimist        1.0  11.0         13
## 183 183     Gym  Extravert   Optimist        3.0   9.0         11
## 184 184     Gym  Extravert   Optimist        2.0   9.0          7
## 185 185     Art  Introvert  Pessimist        5.0   9.0          7
# Select first 50 observations
getrow3 <- dfold[1:49,]
getrow3
##    ID Gender Grade   Horoscope Subject     IntExt    OptPest ScreenTime Sleep
## 1   1   male     4     Scorpio    Math  Extravert   Optimist          1     7
## 2   2 female     4   Capricorn     Gym  Extravert   Optimist          1     8
## 3   3   male     4      Taurus    Math  Introvert   Optimist          4     9
## 4   4   male     4    Aquarius    Math Don't Know Don't Know          3     9
## 5   5   male     4     Scorpio     Gym Don't Know Don't Know          1     9
## 6   6   male     4      Pisces     Gym  Extravert   Optimist          2     9
## 7   7   male     3     Scorpio     Art  Introvert   Optimist          1    11
## 8   8   male     6      Taurus    Math  Extravert   Optimist          4     9
## 9   9   male     6       Aries     Gym  Introvert  Pessimist          6     8
## 10 10   male     6      Pisces    Math  Introvert Don't Know          3     9
## 11 11 female     4         Leo     Gym Don't Know   Optimist          1    10
## 12 12 female     4     Scorpio    Math Don't Know   Optimist          1    10
## 13 13 female     4      Taurus     Art  Extravert   Optimist          0     9
## 14 14   male     7         Leo     Gym  Extravert Don't Know          5     8
## 15 15   male     8 Sagittarius     Gym Don't Know   Optimist          6     9
## 16 16 female     8      Cancer     Gym  Introvert   Optimist          5     7
## 17 17   male     8         Leo Science  Introvert   Optimist          8     7
## 18 18   male     8     Scorpio     Gym  Introvert   Optimist          4     8
## 19 19   male     8      Cancer    Math  Introvert   Optimist          2     9
## 20 20 female     8   Capricorn     Art  Extravert  Pessimist          3     8
## 21 21 female     5      Cancer     Art  Introvert   Optimist          2     9
## 22 22 female     6       Virgo Science  Introvert Don't Know          1     8
## 23 23 female     5      Pisces     Art  Extravert   Optimist          1     9
## 24 24 female     6      Taurus     Art  Introvert   Optimist          4     9
## 25 25 female     6      Pisces Science  Extravert   Optimist          1     8
## 26 26 female     6      Gemini     Art  Introvert  Pessimist          3     6
## 27 27   male     6       Libra     Gym  Extravert  Pessimist          1    10
## 28 28   male     6     Scorpio Science  Introvert Don't Know          3    10
## 29 29 female     6       Virgo    Math Don't Know  Pessimist          4     9
## 30 30   male     6      Gemini Science  Extravert   Optimist          4     9
## 31 31 female     8      Cancer Science  Extravert   Optimist          9     8
## 32 32 female     8      Gemini Science Don't Know Don't Know         10     5
## 33 33 female     8     Scorpio Science  Extravert Don't Know         10     3
## 34 34 female     7      Cancer     Art  Introvert  Pessimist          3     9
## 35 35 female     7      Gemini     Gym Don't Know   Optimist          3     8
## 36 36   male     8    Aquarius     Art Don't Know   Optimist          4     8
## 37 37   male     8      Taurus History Don't Know Don't Know          5    10
## 38 38   male     7       Virgo    Math  Introvert  Pessimist          2     9
## 39 39   male     8      Taurus    Math  Extravert   Optimist          2     9
## 40 40   male     8    Aquarius     Gym  Extravert  Pessimist          2     9
## 41 41   male     5      Pisces    Math Don't Know  Pessimist          1     9
## 42 42   male     5   Capricorn     Gym  Extravert Don't Know          6     8
## 43 43   male     5   Capricorn     Gym  Extravert  Pessimist          4     8
## 44 44   male     5      Taurus     Gym  Extravert  Pessimist          1     9
## 45 45 female     5       Libra Science Don't Know   Optimist          3     8
## 46 46   male     5       Libra     Gym  Extravert  Pessimist          1    11
## 47 47   male     5      Gemini     Gym  Extravert   Optimist          2    10
## 48 48 female     5      Taurus     Art  Extravert   Optimist          1     7
## 49 49 female     5         Leo    Math  Introvert   Optimist          2    10
##    PhysActive HrsHomework                 SpendTime1           SpendTime2
## 1          10          10                   baseball             relaxing
## 2           5           0            playing outside             swimming
## 3          22           1                video games               soccer
## 4           9           1                video games               sports
## 5          10           1                    reading          hanging out
## 6          20           2                     sports playing with friends
## 7           4          14                watching TV              reading
## 8          12          21                video games      playing outside
## 9           4           6                video games               biking
## 10         12           3                video games dungeons and dragons
## 11          5           0                   reading               drawing
## 12          5           0                         tv                 lego
## 13          5           0                    reading              outside
## 14         14           4                     sports                  idk
## 15         25           2                     sports                   tv
## 16          6           3                       read                watch
## 17          2           0                      house                  idk
## 18         10           0                     soccer                  ps4
## 19         10           3                     soccer                  ps4
## 20         10           5                      phone                   tv
## 21          2           1                       bike               soccer
## 22          5           2                     sports                phone
## 23          1           8                       read                 bike
## 24          6           4                    drawing           ranbowloom
## 25          7           4                     sports                 talk
## 26         14           3                       read                 play
## 27          5           2                       read                 play
## 28          5           5                video games                 talk
## 29         14          14                       read                 play
## 30          9          10                       play                   tv
## 31          8          35                    reading        playing games
## 32          5          20                    netflix      texting talking
## 33          7          20                    netflix               eating
## 34          3           2                    reading        playing games
## 35          7           5                     sports              reading
## 36          7           6                    reading              youtube
## 37          7           8                    reading        playing games
## 38         14           4                rubix cubes                piano
## 39         10           3                     sports          video games
## 40          9           3                     sports        summer school
## 41          9           4 staring blankly into space   looking at nothing
## 42         11          18                         18               sporty
## 43         14           5                ball hockey         being myself
## 44         12           1                   baseball             sleeping
## 45          7           2                   crafting        making things
## 46          5           1                watching tv               sports
## 47         11           2                     sports  playing video games
## 48          5           1                    reading             swimming
## 49          6           6           watching pokemon              reading
##          Self1               Self2                       Career
## 1       active         competitive professional baseball player
## 2         kind              active                      Teacher
## 3       active            creative   professional soccer player
## 4       active         responsible   professional hockey player
## 5  intellegent              strong                     engineer
## 6        funny              active   professional hockey player
## 7       joyful                lazy                       artist
## 8          fun           confident                       banker
## 9          sad                calm           computer scientist
## 10       smart               tired                      Teacher
## 11       funny            athletic                      swimmer
## 12      caring         responsible                          idk
## 13        kind              active                       doctor
## 14      living            annoying               sports analyst
## 15    athletic           energetic                      athlete
## 16         idk                 idk                    architect
## 17         idk                 idk                    scientist
## 18     awesome             amazing                         rich
## 19      funny                smart                soccer player
## 20       smart               happy                       doctor
## 21       quite              pretty                          vet
## 22      sporty               smart                    scientist
## 23        nice                kind                       auther
## 24        nice               happy                    dessinger
## 25         fun                kind                      teacher
## 26       wierd             awkward                     rich man
## 27       rebel               small                    dessinger
## 28       funny                loud                    dont know
## 29     anoying                 fun                     engenier
## 30        talk              awsome                      teacher
## 31    childish            annoying                          vet
## 32       moody             intense                       doctor
## 33        loud       unpredictable                          idk
## 34         shy             curious                          idk
## 35    creative             curious                     arcitect
## 36       quiet          expressive                   geneticist
## 37     curious            friendly                   landscaper
## 38         shy          persistent                    physisist
## 39        tall               asian                       lawyer
## 40       funny           energitic                      sergent
## 41      simple                 n/a                     mechanic
## 42      strong                 vet            controlling minds
## 43   talkative beyond not annoying                          n/a
## 44         n/a                 n/a                          n/a
## 45    creative              caring                    scientist
## 46   talkative              caring                      athlete
## 47  empathetic                kind            sports journalist
## 48  optimistic           extravert                       doctor
## 49        nice            outgoing                       lawyer
##                      Superpower
## 1                   sonic speed
## 2         power to grant wishes
## 3                 powerful kick
## 4                  teleportaion
## 5  power to answer any question
## 6                           fly
## 7                   telekinesis
## 8                 teleportation
## 9          materialize anything
## 10         manipulating physics
## 11                       flying
## 12                teleportation
## 13                 invisibility
## 14                  time travel
## 15                     strength
## 16                teleportation
## 17                 invisibility
## 18                 regeneration
## 19                reading minds
## 20                teleportation
## 21                    invisable
## 22                  shape shift
## 23                          fly
## 24                    invisible
## 25                     telaport
## 26                     telaport
## 27                  shape shift
## 28                  shape shift
## 29                         fire
## 30                         <NA>
## 31                          fly
## 32           change probability
## 33                   read minds
## 34                  time travel
## 35                          fly
## 36                     teleport
## 37              have everything
## 38                     teleport
## 39              munipulate time
## 40                   invincible
## 41                 invisibility
## 42                         <NA>
## 43                       wishes
## 44                        speed
## 45                       wishes
## 46                reading minds
## 47                 invisibility
## 48                       wishes
## 49                          fly
# Using subset function to select data
# Select Extrovert with ScreenTime > 5
getvar4 <- subset(dfold, IntExt=="Extravert" & ScreenTime > 5,
                  select=Gender:Self2)
getvar4
##     Gender Grade Horoscope Subject    IntExt    OptPest ScreenTime Sleep
## 31  female     8    Cancer Science Extravert   Optimist          9     8
## 33  female     8   Scorpio Science Extravert Don't Know         10     3
## 42    male     5 Capricorn     Gym Extravert Don't Know          6     8
## 114 female     8     Libra    Math Extravert   Optimist         18     6
## 126 female     6    Pisces     Gym Extravert  Pessimist          7     6
## 138 female     8     Aries     Art Extravert   Optimist          8     7
## 150 female     6     Aries     Art Extravert  Pessimist         10     2
## 177 female     6     Virgo Science Extravert  Pessimist          8     7
## 179 female     6  Aquarius     Gym Extravert  Pessimist          6     8
##     PhysActive HrsHomework       SpendTime1        SpendTime2       Self1
## 31           8          35          reading     playing games    childish
## 33           7          20          netflix            eating        loud
## 42          11          18               18            sporty      strong
## 114          0           4          friends            family       sassy
## 126          7           5         Watch TV Play with Friends       Chill
## 138          8           2          Netflix           friends adventurous
## 150         13           1          netflix             chill    positive
## 177          1           1           eating       video games        lazy
## 179          7           0 watching youtube          sleeping        load
##             Self2
## 31       annoying
## 33  unpredictable
## 42            vet
## 114         happy
## 126          Dude
## 138           n/a
## 150          lazy
## 177         funky
## 179     energitic

4 Ways of Pre-Processing

# 1- The section below checks for missing values, remove the respective rows and check the dataset again
# Check Missing Value
sapply(dfold, function(x) sum(is.na(x)))
##          ID      Gender       Grade   Horoscope     Subject      IntExt 
##           0           0           0           0           1           0 
##     OptPest  ScreenTime       Sleep  PhysActive HrsHomework  SpendTime1 
##           0           0           0           1           0           0 
##  SpendTime2       Self1       Self2      Career  Superpower 
##           0           2           1           2           8
# Remove rows with missing data
df <- na.omit(dfold)

# Check the dataset again for missing value
sapply(df, function(x) sum(is.na(x)))
##          ID      Gender       Grade   Horoscope     Subject      IntExt 
##           0           0           0           0           0           0 
##     OptPest  ScreenTime       Sleep  PhysActive HrsHomework  SpendTime1 
##           0           0           0           0           0           0 
##  SpendTime2       Self1       Self2      Career  Superpower 
##           0           0           0           0           0
# 2- Dealing With Categorical Data
# Categorical variables represent types of data which may be divided into groups. 
# Examples of categorical variables are race, sex, age group, educational level etc.
# There are a few categorical features in this dataset. 
# Here, the factor method can be used to convert texts into numerical codes.

df$IntExt = factor(df$IntExt, levels = c("Extravert","Introvert","Don't Know"), labels = c(1,2,3))
print(df$IntExt)
##   [1] 1 1 2 3 3 1 2 1 2 2 3 3 1 1 3 2 2 2 2 1 2 2 1 2 1 2 1 2 3 1 3 1 2 3 3 3 2
##  [38] 1 1 3 1 1 3 1 1 1 2 2 1 1 1 1 1 1 2 2 1 2 3 1 3 2 2 1 1 2 1 1 2 2 2 3 3 1
##  [75] 3 1 1 3 1 3 3 1 1 3 1 2 1 1 2 1 3 3 1 3 2 2 1 3 1 1 1 2 2 1 2 3 1 1 1 2 1
## [112] 1 1 3 2 3 2 1 2 2 2 2 1 2 2 1 1 1 1 1 2 1 1 3 1 3 1 1 1 1 1 1 1 3 1 3 1 1
## [149] 1 1 1 1 2 1 1 1 2 1 3 2 2 1 3 1 1 1 1 1 1 1 1 1
## Levels: 1 2 3
# 3- Feature Scaling
# Common ones are Standardization & Normalization
# Standardization- each feature is standardized by the mean / standard deviation.
# Normalization- subtract each observation feature x by the minimum value of all feature values and divide it by the # # difference between the maximum of your feature values and the minimum of your feature values.
# Use: in-built scale function in R.

dfold[, c(8:11)] = scale(dfold[, c(8:11)])
dfold
##      ID         Gender Grade   Horoscope Subject     IntExt    OptPest
## 1     1           male     4     Scorpio    Math  Extravert   Optimist
## 2     2         female     4   Capricorn     Gym  Extravert   Optimist
## 3     3           male     4      Taurus    Math  Introvert   Optimist
## 4     4           male     4    Aquarius    Math Don't Know Don't Know
## 5     5           male     4     Scorpio     Gym Don't Know Don't Know
## 6     6           male     4      Pisces     Gym  Extravert   Optimist
## 7     7           male     3     Scorpio     Art  Introvert   Optimist
## 8     8           male     6      Taurus    Math  Extravert   Optimist
## 9     9           male     6       Aries     Gym  Introvert  Pessimist
## 10   10           male     6      Pisces    Math  Introvert Don't Know
## 11   11         female     4         Leo     Gym Don't Know   Optimist
## 12   12         female     4     Scorpio    Math Don't Know   Optimist
## 13   13         female     4      Taurus     Art  Extravert   Optimist
## 14   14           male     7         Leo     Gym  Extravert Don't Know
## 15   15           male     8 Sagittarius     Gym Don't Know   Optimist
## 16   16         female     8      Cancer     Gym  Introvert   Optimist
## 17   17           male     8         Leo Science  Introvert   Optimist
## 18   18           male     8     Scorpio     Gym  Introvert   Optimist
## 19   19           male     8      Cancer    Math  Introvert   Optimist
## 20   20         female     8   Capricorn     Art  Extravert  Pessimist
## 21   21         female     5      Cancer     Art  Introvert   Optimist
## 22   22         female     6       Virgo Science  Introvert Don't Know
## 23   23         female     5      Pisces     Art  Extravert   Optimist
## 24   24         female     6      Taurus     Art  Introvert   Optimist
## 25   25         female     6      Pisces Science  Extravert   Optimist
## 26   26         female     6      Gemini     Art  Introvert  Pessimist
## 27   27           male     6       Libra     Gym  Extravert  Pessimist
## 28   28           male     6     Scorpio Science  Introvert Don't Know
## 29   29         female     6       Virgo    Math Don't Know  Pessimist
## 30   30           male     6      Gemini Science  Extravert   Optimist
## 31   31         female     8      Cancer Science  Extravert   Optimist
## 32   32         female     8      Gemini Science Don't Know Don't Know
## 33   33         female     8     Scorpio Science  Extravert Don't Know
## 34   34         female     7      Cancer     Art  Introvert  Pessimist
## 35   35         female     7      Gemini     Gym Don't Know   Optimist
## 36   36           male     8    Aquarius     Art Don't Know   Optimist
## 37   37           male     8      Taurus History Don't Know Don't Know
## 38   38           male     7       Virgo    Math  Introvert  Pessimist
## 39   39           male     8      Taurus    Math  Extravert   Optimist
## 40   40           male     8    Aquarius     Gym  Extravert  Pessimist
## 41   41           male     5      Pisces    Math Don't Know  Pessimist
## 42   42           male     5   Capricorn     Gym  Extravert Don't Know
## 43   43           male     5   Capricorn     Gym  Extravert  Pessimist
## 44   44           male     5      Taurus     Gym  Extravert  Pessimist
## 45   45         female     5       Libra Science Don't Know   Optimist
## 46   46           male     5       Libra     Gym  Extravert  Pessimist
## 47   47           male     5      Gemini     Gym  Extravert   Optimist
## 48   48         female     5      Taurus     Art  Extravert   Optimist
## 49   49         female     5         Leo    Math  Introvert   Optimist
## 50   50         female     5 Sagittarius     Art  Introvert Don't Know
## 51   51         female     5         Leo     Art  Extravert   Optimist
## 52   52         female     6      Taurus     Gym  Extravert   Optimist
## 53   53         female     6       Aries History  Extravert   Optimist
## 54   54           male     5     Scorpio     Gym  Extravert   Optimist
## 55   55           male     5      Gemini     Gym  Extravert   Optimist
## 56   56           male     4     Scorpio     Gym  Extravert   Optimist
## 57   57           male     4      Cancer History  Introvert   Optimist
## 58   58         female     4      Pisces     Gym  Introvert   Optimist
## 59   59         female     6      Pisces    Math  Extravert   Optimist
## 60   60         female     6      Taurus    Math  Introvert Don't Know
## 61   61           male     6    Aquarius     Gym  Introvert Don't Know
## 62   62 Don't Identify     6       Libra     Art Don't Know Don't Know
## 63   63           male     6      Gemini    Math  Extravert Don't Know
## 64   64         female     6         Leo    Math Don't Know Don't Know
## 65   65         female     6         Leo     Gym  Introvert   Optimist
## 66   66         female     6       Aries     Gym  Introvert   Optimist
## 67   67           male     6   Capricorn     Gym  Extravert   Optimist
## 68   68           male     6      Cancer     Gym  Extravert   Optimist
## 69   69           male     4       Aries    Math  Introvert  Pessimist
## 70   70           male     4 Sagittarius    Math  Extravert  Pessimist
## 71   71         female     6      Cancer     Gym  Extravert   Optimist
## 72   72         female     6         Leo Science  Introvert   Optimist
## 73   73           male     6      Cancer     Gym  Introvert   Optimist
## 74   74         female     4      Cancer     Art  Introvert   Optimist
## 75   75           male     4         Leo     Art Don't Know  Pessimist
## 76   76         female     4      Pisces     Art Don't Know   Optimist
## 77   77         female     4      Cancer    Math  Extravert   Optimist
## 78   78         female     4         Leo     Gym Don't Know   Optimist
## 79   79           male     4      Pisces Science  Extravert  Pessimist
## 80   80           male     4    Aquarius Science  Extravert  Pessimist
## 81   81         female     4     Scorpio     Art Don't Know  Pessimist
## 82   82           male     4      Taurus    Math  Extravert  Pessimist
## 83   83         female     4     Scorpio     Art Don't Know Don't Know
## 84   84           male     4      Pisces     Gym Don't Know   Optimist
## 85   85           male     4       Virgo     Gym  Extravert   Optimist
## 86   86           male     4     Scorpio     Gym  Extravert   Optimist
## 87   87           male     4      Gemini     Gym Don't Know   Optimist
## 88   88           male     4       Virgo     Art  Extravert   Optimist
## 89   89         female     4     Scorpio     Art  Introvert   Optimist
## 90   90           male     5     Scorpio Science  Extravert   Optimist
## 91   91           male     5     Scorpio     Gym  Extravert  Pessimist
## 92   92           male     5       Libra    Math  Introvert Don't Know
## 93   93           male     5       Virgo     Gym  Extravert Don't Know
## 94   94         female     6     Scorpio    Math Don't Know  Pessimist
## 95   95           male     3   Capricorn    <NA> Don't Know Don't Know
## 96   96         female     4      Taurus     Art Don't Know Don't Know
## 97   97           male     5       Libra     Gym Don't Know   Optimist
## 98   98         female     5 Sagittarius Science  Extravert  Pessimist
## 99   99         female     5       Libra    Math Don't Know  Pessimist
## 100 100         female     5 Sagittarius    Math  Introvert  Pessimist
## 101 101         female     5         Leo    Math  Introvert   Optimist
## 102 102           male     6       Aries     Art  Introvert  Pessimist
## 103 103         female     6     Scorpio     Gym  Extravert Don't Know
## 104 104         female     7         Leo     Art Don't Know   Optimist
## 105 105           male     7    Aquarius     Gym  Extravert   Optimist
## 106 106         female     7      Cancer     Gym  Extravert   Optimist
## 107 107           male     7      Gemini History  Extravert   Optimist
## 108 108         female     7      Cancer     Art  Introvert  Pessimist
## 109 109         female     7 Sagittarius    Math  Introvert   Optimist
## 110 110         female     7      Gemini    Math  Extravert   Optimist
## 111 111         female     7       Libra    Math  Introvert   Optimist
## 112 112           male     7      Taurus     Gym Don't Know  Pessimist
## 113 113           male     7      Cancer     Gym Don't Know   Optimist
## 114 114         female     8       Libra    Math  Extravert   Optimist
## 115 115         female     8       Libra     Art  Extravert   Optimist
## 116 116         female     8    Aquarius     Gym  Extravert Don't Know
## 117 117           male     8   Capricorn     Art  Introvert Don't Know
## 118 118         female     8       Aries     Art  Extravert Don't Know
## 119 119           male     8         Leo     Art  Extravert   Optimist
## 120 120         female     8      Taurus     Gym  Extravert   Optimist
## 121 121         female     8      Pisces     Art Don't Know   Optimist
## 122 122           male     8      Gemini Science  Introvert Don't Know
## 123 123           male     8       Virgo History Don't Know   Optimist
## 124 124         female     6       Virgo    Math Don't Know  Pessimist
## 125 125           male     6      Gemini    Math  Introvert  Pessimist
## 126 126         female     6      Pisces     Gym  Extravert  Pessimist
## 127 127           male     6       Aries     Gym  Introvert  Pessimist
## 128 128           male     6      Pisces Science  Introvert  Pessimist
## 129 129           male     6      Cancer     Gym  Introvert  Pessimist
## 130 130           male     6 Sagittarius    Math  Introvert Don't Know
## 131 131           male     6      Taurus    Math  Extravert   Optimist
## 132 132         female     6      Cancer Science  Introvert   Optimist
## 133 133           male     6       Virgo    Math  Introvert   Optimist
## 134 134           male     8       Aries Science  Extravert  Pessimist
## 135 135         female     8 Sagittarius Science  Extravert   Optimist
## 136 136           male     8       Aries     Gym  Extravert   Optimist
## 137 137           male     8         Leo     Art  Extravert  Pessimist
## 138 138         female     8       Aries     Art  Extravert   Optimist
## 139 139         female     8   Capricorn     Gym  Introvert  Pessimist
## 140 140         female     8      Gemini Science  Extravert   Optimist
## 141 141           male     8       Libra     Art  Extravert  Pessimist
## 142 142         female     8   Capricorn     Gym Don't Know   Optimist
## 143 143           male     8    Aquarius     Art  Extravert   Optimist
## 144 144         female     5 Sagittarius     Gym Don't Know   Optimist
## 145 145         female     4      Pisces     Gym  Extravert Don't Know
## 146 146         female     4      Cancer     Art  Extravert   Optimist
## 147 147         female     4      Cancer     Gym  Extravert   Optimist
## 148 148 Don't Identify     5       Aries History  Extravert  Pessimist
## 149 149           male     5       Aries    Math  Extravert   Optimist
## 150 150         female     6       Aries     Art  Extravert  Pessimist
## 151 151         female     6      Cancer     Gym  Extravert Don't Know
## 152 152         female     5      Pisces    Math  Extravert   Optimist
## 153 153         female     5 Sagittarius     Gym Don't Know  Pessimist
## 154 154           male     5      Gemini     Gym  Extravert   Optimist
## 155 155         female     5 Sagittarius Science Don't Know  Pessimist
## 156 156         female     5   Capricorn     Art  Extravert   Optimist
## 157 157           male     5       Aries Science Don't Know  Pessimist
## 158 158         female     5   Capricorn    Math  Extravert Don't Know
## 159 159           male     5   Capricorn     Gym  Extravert   Optimist
## 160 160           male     5   Capricorn     Gym  Extravert Don't Know
## 161 161         female     5      Gemini     Gym  Extravert Don't Know
## 162 162           male     5   Capricorn     Gym  Extravert   Optimist
## 163 163         female     5     Scorpio Science Don't Know  Pessimist
## 164 164           male     6       Virgo     Gym  Extravert  Pessimist
## 165 165         female     6         Leo History  Introvert  Pessimist
## 166 166           male     6      Cancer     Gym  Extravert   Optimist
## 167 167           male     6       Libra     Gym  Extravert   Optimist
## 168 168         female     4       Virgo Science  Extravert   Optimist
## 169 169         female     4       Virgo     Gym  Introvert  Pessimist
## 170 170           male     4    Aquarius     Art  Extravert Don't Know
## 171 171         female     4       Aries     Gym Don't Know   Optimist
## 172 172         female     4       Aries    Math  Introvert   Optimist
## 173 173           male     4       Aries Science  Introvert  Pessimist
## 174 174         female     4       Virgo History  Extravert  Pessimist
## 175 175         female     4         Leo Science Don't Know Don't Know
## 176 176           male     6       Aries    Math  Extravert  Pessimist
## 177 177         female     6       Virgo Science  Extravert  Pessimist
## 178 178           male     6       Aries    Math  Extravert   Optimist
## 179 179         female     6    Aquarius     Gym  Extravert  Pessimist
## 180 180           male     6   Capricorn    Math  Extravert   Optimist
## 181 181         female     6       Aries     Gym  Extravert  Pessimist
## 182 182           male     6 Sagittarius    Math  Extravert   Optimist
## 183 183           male     6      Cancer     Gym  Extravert   Optimist
## 184 184         female     6       Aries     Gym  Extravert   Optimist
## 185 185         female     6      Gemini     Art  Introvert  Pessimist
##       ScreenTime      Sleep  PhysActive HrsHomework                 SpendTime1
## 1   -0.862697253 -1.0641022 -0.12884219  1.21588633                   baseball
## 2   -0.862697253 -0.4154732 -0.55218081 -0.86977868            playing outside
## 3    0.433099704  0.2331558  0.88717051 -0.66121218                video games
## 4    0.001167385  0.2331558 -0.21350991 -0.66121218                video games
## 5   -0.862697253  0.2331558 -0.12884219 -0.66121218                    reading
## 6   -0.430764934  0.2331558  0.71783506 -0.45264568                     sports
## 7   -0.862697253  1.5304138 -0.63684854  2.05015233                watching TV
## 8    0.433099704  0.2331558  0.04049326  3.51011784                video games
## 9    1.296964341 -0.4154732 -0.63684854  0.38162033                video games
## 10   0.001167385  0.2331558  0.04049326 -0.24407918                video games
## 11  -0.862697253  0.8817848 -0.55218081 -0.86977868                   reading 
## 12  -0.862697253  0.8817848 -0.55218081 -0.86977868                         tv
## 13  -1.294629572  0.2331558 -0.55218081 -0.86977868                    reading
## 14   0.865032022 -0.4154732  0.20982871 -0.03551267                     sports
## 15   1.296964341  0.2331558  1.14117368 -0.45264568                     sports
## 16   0.865032022 -1.0641022 -0.46751309 -0.24407918                       read
## 17   2.160828979 -1.0641022 -0.80618399 -0.86977868                      house
## 18   0.433099704 -0.4154732 -0.12884219 -0.86977868                     soccer
## 19  -0.430764934  0.2331558 -0.12884219 -0.24407918                     soccer
## 20   0.001167385 -0.4154732 -0.12884219  0.17305383                      phone
## 21  -0.430764934  0.2331558 -0.80618399 -0.66121218                       bike
## 22  -0.862697253 -0.4154732 -0.55218081 -0.45264568                     sports
## 23  -0.862697253  0.2331558 -0.89085171  0.79875333                       read
## 24   0.433099704  0.2331558 -0.46751309 -0.03551267                    drawing
## 25  -0.862697253 -0.4154732 -0.38284536 -0.03551267                     sports
## 26   0.001167385 -1.7127312  0.20982871 -0.24407918                       read
## 27  -0.862697253  0.8817848 -0.55218081 -0.45264568                       read
## 28   0.001167385  0.8817848 -0.55218081  0.17305383                video games
## 29   0.433099704  0.2331558  0.20982871  2.05015233                       read
## 30   0.433099704  0.2331558 -0.21350991  1.21588633                       play
## 31   2.592761298 -0.4154732 -0.29817764  6.43004885                    reading
## 32   3.024693617 -2.3613602 -0.55218081  3.30155134                    netflix
## 33   3.024693617 -3.6586181 -0.38284536  3.30155134                    netflix
## 34   0.001167385  0.2331558 -0.72151626 -0.45264568                    reading
## 35   0.001167385 -0.4154732 -0.38284536  0.17305383                     sports
## 36   0.433099704 -0.4154732 -0.38284536  0.38162033                    reading
## 37   0.865032022  0.8817848 -0.38284536  0.79875333                    reading
## 38  -0.430764934  0.2331558  0.20982871 -0.03551267                rubix cubes
## 39  -0.430764934  0.2331558 -0.12884219 -0.24407918                     sports
## 40  -0.430764934  0.2331558 -0.21350991 -0.24407918                     sports
## 41  -0.862697253  0.2331558 -0.21350991 -0.03551267 staring blankly into space
## 42   1.296964341 -0.4154732 -0.04417447  2.88441834                         18
## 43   0.433099704 -0.4154732  0.20982871  0.17305383                ball hockey
## 44  -0.862697253  0.2331558  0.04049326 -0.66121218                   baseball
## 45   0.001167385 -0.4154732 -0.38284536 -0.45264568                   crafting
## 46  -0.862697253  1.5304138 -0.55218081 -0.66121218                watching tv
## 47  -0.430764934  0.8817848 -0.04417447 -0.45264568                     sports
## 48  -0.862697253 -1.0641022 -0.55218081 -0.66121218                    reading
## 49  -0.430764934  0.8817848 -0.46751309  0.38162033           watching pokemon
## 50  -0.430764934 -0.4154732 -0.29817764 -0.66121218                    reading
## 51   0.865032022  0.2331558 -0.29817764 -0.66121218                        run
## 52  -0.862697253  0.8817848 -0.12884219 -0.66121218                     soccer
## 53   0.001167385  0.2331558 -0.46751309 -0.03551267                    netflix
## 54  -0.430764934 -1.0641022 -0.80618399 -0.66121218                     family
## 55   0.433099704  0.2331558  0.04049326 -0.86977868                video games
## 56   0.001167385  0.8817848 -0.55218081 -0.24407918                       xbox
## 57  -0.862697253 -0.4154732  5.96723399  0.79875333                 activeitys
## 58  -0.862697253  0.8817848 -0.72151626 -0.86977868                    outside
## 59  -0.862697253  0.2331558 -0.55218081 -0.66121218               with friends
## 60  -0.862697253  0.8817848 -0.63684854 -0.86977868               with friends
## 61   0.001167385 -0.4154732 -0.12884219  2.05015233                Video Games
## 62   0.433099704  2.1790428 -0.72151626  0.38162033                       Pets
## 63   0.001167385  0.2331558 -0.29817764 -0.24407918                Video Games
## 64  -0.862697253  0.2331558 -0.80618399 -0.66121218                    Reading
## 65  -0.862697253 -0.4154732 -0.12884219 -0.24407918                    Friends
## 66   0.001167385  0.8817848  0.29449643 -0.24407918                     Baking
## 67   0.865032022  0.2331558 -0.12884219 -0.24407918                    Outside
## 68  -0.862697253  0.8817848  0.04049326 -0.24407918                     Sports
## 69  -0.862697253  0.8817848  4.95122129  3.51011784                     Active
## 70   0.001167385 -0.4154732  3.25786680 -0.86977868                      Games
## 71  -0.862697253  0.2331558  0.20982871 -0.66121218                     Hockey
## 72  -0.430764934  0.2331558 -0.38284536 -0.66121218                       Draw
## 73  -0.862697253  0.2331558  0.80250278 -0.66121218                     Soccer
## 74  -0.430764934  0.8817848  0.71783506  0.38162033                    running
## 75   0.001167385  0.2331558 -0.38284536  1.21588633                video games
## 76  -0.430764934  1.5304138 -0.12884219 -0.66121218           playing with dog
## 77  -0.862697253  0.2331558  2.07251865  0.59018683                      dance
## 78  -0.862697253  0.2331558 -0.29817764 -0.03551267            play w/ friends
## 79  -0.862697253 -0.4154732  5.12055674 -0.24407918                       read
## 80  -0.430764934 -0.4154732 -0.21350991 -0.03551267                     soccer
## 81  -0.862697253  2.1790428 -0.80618399 -0.66121218                       draw
## 82  -0.862697253  1.5304138  0.04049326 -0.45264568                       read
## 83  -1.294629572  0.8817848 -0.80618399 -0.66121218             computer games
## 84  -0.862697253  0.8817848  1.39517685 -0.86977868                     Sports
## 85  -0.430764934  0.2331558  1.56451230 -0.66121218                 Videogames
## 86  -0.862697253 -0.4154732 -0.12884219 -0.45264568                     Sports
## 87  -0.430764934  0.2331558  0.37916416 -0.24407918                 Videogames
## 88  -0.430764934  0.8817848  0.71783506  0.59018683                      Guild
## 89  -0.862697253  0.2331558  0.63316733  0.59018683                        Art
## 90   0.001167385  0.8817848 -0.12884219  0.38162033                       Play
## 91   0.433099704  0.2331558 -0.46751309  0.59018683                 Skateboard
## 92   0.433099704  0.2331558  0.04049326  0.17305383                    Youtube
## 93   0.865032022 -0.4154732 -0.55218081  0.59018683                         Tv
## 94   1.728896660 -0.4154732 -0.29817764 -0.86977868                    youtube
## 95  -0.862697253  0.8817848 -0.12884219 -0.86977868                video games
## 96  -0.862697253  0.8817848  0.29449643 -0.03551267                video games
## 97  -0.862697253  0.8817848 -0.55218081 -0.66121218              play with cat
## 98   0.001167385  0.8817848 -0.04417447  0.38162033                   fortnite
## 99   0.001167385  0.2331558 -0.29817764  0.38162033                 gymnastics
## 100  1.296964341 -0.4154732 -0.55218081  0.59018683                video games
## 101  0.433099704  0.2331558 -0.04417447  0.79875333                     sports
## 102  0.001167385 -0.4154732 -0.12884219 -0.24407918          talk with friends
## 103  0.001167385  0.8817848 -0.12884219  0.17305383                video games
## 104 -0.862697253  0.2331558 -0.80618399 -0.76549543                        IDK
## 105  0.433099704  0.2331558  1.22584141 -0.66121218                     Sports
## 106  0.433099704 -1.0641022 -0.12884219 -0.86977868               Being active
## 107 -0.430764934 -0.4154732  0.29449643 -0.45264568                    Dancing
## 108  0.433099704 -1.0641022 -0.63684854  1.63301933           watching netflix
## 109 -1.078663413  0.2331558  0.20982871  1.63301933          going to the park
## 110 -0.430764934 -0.4154732 -0.63684854  0.59018683             playing sports
## 111 -0.430764934  0.5574703 -0.63684854  0.79875333                   sleeping
## 112  0.433099704  0.2331558  1.39517685  0.59018683             playing soccer
## 113  0.865032022  0.2331558 -0.12884219  0.38162033             playing hockey
## 114  6.480152168 -1.7127312 -0.97551944 -0.03551267                    friends
## 115  0.433099704 -0.4154732  0.04049326 -0.86977868                    singing
## 116  0.865032022 -0.4154732 -0.12884219 -0.86977868                    friends
## 117  0.001167385  0.8817848 -0.12884219 -0.86977868                   sleeping
## 118  0.433099704 -0.4154732 -0.63684854 -0.66121218                    friends
## 119  0.865032022 -0.4154732  0.29449643 -0.86977868                   fortnite
## 120  0.865032022 -0.4154732 -0.29817764 -0.86977868                    friends
## 121  0.001167385 -0.4154732 -0.72151626 -0.66121218                   drawing 
## 122  0.865032022 -1.0641022 -0.46751309 -0.86977868                      games
## 123 -0.862697253  0.2331558 -0.46751309  0.17305383                     soccer
## 124  0.433099704  0.2331558 -0.46751309  2.05015233                       Read
## 125  0.001167385 -2.3613602 -0.29817764 -0.45264568                       Read
## 126  1.728896660 -1.7127312 -0.38284536  0.17305383                   Watch TV
## 127  1.296964341 -0.4154732  0.04049326 -0.03551267                       Code
## 128 -0.862697253  0.2331558 -0.12884219  0.59018683                       Read
## 129  1.296964341 -1.0641022 -0.38284536 -0.24407918                   Watch TV
## 130  0.001167385  0.2331558  0.20982871 -0.03551267                        D&D
## 131  0.433099704 -1.0641022  1.05650596  0.17305383             Go to the Park
## 132 -0.862697253  0.2331558  0.04049326  0.17305383                       Read
## 133 -1.294629572 -2.3613602  2.41118955 -0.66121218                     Sports
## 134 -0.430764934  0.8817848 -0.38284536  0.59018683                     soccer
## 135 -0.430764934  0.8817848 -0.55218081  0.59018683                    reading
## 136 -0.430764934  0.8817848  0.20982871  0.38162033                video games
## 137  0.001167385 -0.4154732  0.71783506 -0.45264568                  instagram
## 138  2.160828979 -1.0641022 -0.29817764 -0.45264568                    Netflix
## 139 -0.862697253 -1.7127312 -0.89085171 -0.66121218                    reading
## 140 -0.430764934 -1.0641022  0.80250278  0.17305383                    Netflix
## 141  0.001167385 -0.4154732 -0.72151626  0.59018683                    friends
## 142  0.865032022 -1.0641022  0.20982871  0.17305383                   relaxing
## 143  0.433099704 -0.4154732  0.54849961  0.59018683                    friends
## 144 -0.430764934 -0.4154732 -0.55218081  1.00731983                     family
## 145 -0.862697253  0.8817848 -0.38284536 -0.86977868                     hockey
## 146 -0.430764934  1.5304138          NA -0.66121218                video games
## 147 -0.430764934  0.8817848 -0.38284536 -0.86977868                     hockey
## 148  0.001167385  0.8817848 -0.55218081 -0.03551267                     soccer
## 149  0.001167385  0.2331558 -0.12884219  0.59018683                video games
## 150  3.024693617 -4.3072471  0.12516098 -0.66121218                    netflix
## 151  0.865032022 -3.0099891 -0.29817764 -0.66121218                    netflix
## 152 -0.430764934  0.8817848 -0.46751309 -0.45264568                pet project
## 153  0.433099704 -3.0099891 -0.21350991 -0.66121218                video games
## 154 -0.862697253  0.8817848  2.41118955  2.05015233                video games
## 155  0.433099704  0.2331558  0.29449643 -0.66121218                         tv
## 156  0.001167385 -0.4154732 -0.38284536  0.38162033                    reading
## 157  1.728896660 -0.4154732 -0.12884219 -0.86977868                         tv
## 158  0.433099704  0.8817848 -0.38284536 -0.24407918                 trampoline
## 159 -0.862697253 -0.4154732  0.37916416  0.17305383                     soccer
## 160 -0.430764934  0.2331558 -0.04417447 -0.03551267                     sports
## 161 -0.430764934 -0.4154732  0.37916416  0.38162033                 gymnastics
## 162  0.865032022 -3.6586181 -0.55218081 -0.66121218                    origami
## 163  1.296964341  1.5304138 -0.38284536 -0.66121218                     screen
## 164 -0.862697253  0.8817848 -0.38284536 -0.66121218                video games
## 165 -0.862697253 -0.4154732 -0.38284536 -0.45264568                   reading 
## 166  0.001167385  0.2331558  0.04049326 -0.24407918                    eating 
## 167  0.865032022  0.8817848  0.29449643 -0.45264568                    friends
## 168 -0.862697253  0.8817848  4.95122129 -0.66121218                road hockey
## 169 -0.862697253 -0.4154732 -0.72151626 -0.66121218        playing on computer
## 170  0.865032022  0.8817848 -0.89085171  0.38162033                video games
## 171 -0.862697253  0.8817848 -0.29817764 -0.66121218                    soccer 
## 172 -0.862697253  1.5304138 -0.38284536 -0.66121218                   reading 
## 173 -0.862697253 -0.4154732 -0.21350991 -0.66121218                   reading 
## 174 -0.862697253  1.5304138 -0.80618399 -0.66121218                video games
## 175 -0.862697253  0.8817848 -0.21350991 -0.45264568                 gymnastics
## 176 -0.862697253  0.2331558  0.88717051  0.59018683                 basketball
## 177  2.160828979 -1.0641022 -0.89085171 -0.66121218                     eating
## 178 -0.430764934 -0.4154732 -0.12884219  1.00731983             playing sports
## 179  1.296964341 -0.4154732 -0.38284536 -0.86977868           watching youtube
## 180 -0.430764934  0.2331558 -0.12884219 -0.66121218                    nothing
## 181  0.865032022 -1.7127312 -0.38284536 -0.86977868           playing with dog
## 182 -0.862697253  1.5304138  0.12516098  0.38162033             playing sports
## 183  0.001167385  0.2331558 -0.04417447  0.17305383                video games
## 184 -0.430764934  0.2331558 -0.38284536 -0.86977868                    playing
## 185  0.865032022  0.2331558 -0.38284536  1.00731983           watching youtube
##                 SpendTime2            Self1               Self2
## 1                 relaxing           active         competitive
## 2                 swimming             kind              active
## 3                   soccer           active            creative
## 4                   sports           active         responsible
## 5              hanging out      intellegent              strong
## 6     playing with friends            funny              active
## 7                  reading           joyful                lazy
## 8          playing outside              fun           confident
## 9                   biking              sad                calm
## 10    dungeons and dragons            smart               tired
## 11                 drawing            funny            athletic
## 12                    lego           caring         responsible
## 13                 outside             kind              active
## 14                     idk           living            annoying
## 15                      tv         athletic           energetic
## 16                   watch              idk                 idk
## 17                     idk              idk                 idk
## 18                     ps4          awesome             amazing
## 19                     ps4           funny                smart
## 20                      tv            smart               happy
## 21                  soccer            quite              pretty
## 22                   phone           sporty               smart
## 23                    bike             nice                kind
## 24              ranbowloom             nice               happy
## 25                    talk              fun                kind
## 26                    play            wierd             awkward
## 27                    play            rebel               small
## 28                    talk            funny                loud
## 29                    play          anoying                 fun
## 30                      tv             talk              awsome
## 31           playing games         childish            annoying
## 32         texting talking            moody             intense
## 33                  eating             loud       unpredictable
## 34           playing games              shy             curious
## 35                 reading         creative             curious
## 36                 youtube            quiet          expressive
## 37           playing games          curious            friendly
## 38                   piano              shy          persistent
## 39             video games             tall               asian
## 40           summer school            funny           energitic
## 41      looking at nothing           simple                 n/a
## 42                  sporty           strong                 vet
## 43            being myself        talkative beyond not annoying
## 44                sleeping              n/a                 n/a
## 45           making things         creative              caring
## 46                  sports        talkative              caring
## 47     playing video games       empathetic                kind
## 48                swimming       optimistic           extravert
## 49                 reading             nice            outgoing
## 50         watching videos         athletic             fidgety
## 51                     dog              Fun               Sweet
## 52                    read           pretty              sporty
## 53                 youtube            happy                kind
## 54                 helpful         greatful             awesome
## 55                 outside             cool             awesome
## 56                 reading             cool              active
## 57             basket ball        generouse                kind
## 58             video games             nice                nice
## 59                  sports            funny                kind
## 60                    read             nice               funny
## 61                 Reading         Childish                Lazy
## 62             Video Games        Sarcastic               Sassy
## 63                   Piano        Energetic             Curious
## 64                Writitng            Quiet              Boring
## 65                 Drawing            Weird              Active
## 66                Shopping            Funny                 Shy
## 67                 Friends            Chill                Tall
## 68                 Friends           Active                Cool
## 69                Sleeping      Intelligent            Athletic
## 70                 Eating          Annoying             Awesome
## 71                 Friends         Athletic             Amazing
## 72                     Dog              Shy          Embarassed
## 73       Playing w/ sister           Active            Athletic
## 74                     art       thoughtful            friendly
## 75                 drawing            weird                 odd
## 76                   dance            funny             awesome
## 77                  sports           active                 fun
## 78                    read            funny               small
## 79              play games         negative              sneaky
## 80         sing on a couch         friendly            creative
## 81                  crafts            funny                nice
## 82             video games            angry             awesome
## 83                 friends              art                cats
## 84              Videogames           Active               Smart
## 85                 Playing             Kind               Happy
## 86                   Relax            Happy              Active
## 87                  Sports      Competetive                Kind
## 88                    Play            Gamer              Sporty
## 89                    Work            Smart               Sweet
## 90              Videogames           Active               Smart
## 91              Videogames            Gamer               Smart
## 92                   Relax           Active               Smart
## 93                  Guitar            Gamer            Annoying
## 94                 dancing            sassy               funny
## 95                 reading             <NA>                <NA>
## 96                    lego            loyal            artistic
## 97                 reading         athletic              social
## 98                 shoping            funny                rude
## 99                 youtube            funny            athletic
## 100               internet             jerk           dishonest
## 101                netflix           funny             athletic
## 102                youtube        agressive                calm
## 103                netflix            small               funny
## 104                    IDK            Human              Person
## 105         Beating friend        Annoying              stuburn
## 106                talking            funny            confused
## 107   Hanging with friends            funny            outgoing
## 108   Hanging with friends        Hilarious             awesome
## 109           staying home      Fashionable             awesome
## 110                cooking            smart              active
## 111         playing sports            smart              active
## 112       playing fortnite         athletic               smart
## 113    playing video games         athletic               smart
## 114                 family            sassy               happy
## 115                friends              fun               happy
## 116                netflix         athletic              thiccc
## 117                reading            funny            annoying
## 118                     TV            smart              blonde
## 119                friends              the                goat
## 120                netflix            smart                nice
## 121                  games             calm               happy
## 122                 eating overly energetic           impatient
## 123                 tennis            funny            athletic
## 124                  Sleep         Bookworm            Annoying
## 125               Fortnite            Wierd               Crazy
## 126      Play with Friends            Chill                Dude
## 127                   Bike            Witty        Condesending
## 128               Fortnite            Smart              Sporty
## 129               Fortnite             Lazy              Gifted
## 130               Fortnite            Smart    Video Game Lover
## 131               Fortnite            Smart         Extreverted
## 132          Watch my Fish         Friendly                 Shy
## 133      Play with Friends              Fun         Extreverted
## 134                 hockey         athletic         intelligent
## 135               swimming            weird                cool
## 136                reading         cheerful          optimistic
## 137               sleeping            petty               basic
## 138                friends      adventurous                 n/a
## 139               sleeping         peculiar               sassy
## 140                friends             cool                 cat
## 141                Netflix            small               blond
## 142                friends            funny            athletic
## 143                  music        laid back           setericle
## 144                reading              shy              active
## 145                 soccer           active              sporty
## 146                 hockey        different              hungry
## 147            video games             <NA>               weird
## 148            video games           hungry            friendly
## 149                   lego            smart               smart
## 150                  chill         positive                lazy
## 151                   swim             lazy              pretty
## 152               out side           unsure               smart
## 153                playing              shy                 fun
## 154               outdoors       empathetic           observant
## 155               you tube         clueless               funny
## 156                 eating       determined              caring
## 157             basketball        talkative               witty
## 158                 baking            happy            annoying
## 159                     tv            funny               loyal
## 160            video games              fun              caring
## 161                talking      extraverted               sassy
## 162            video games    free spirited            creative
## 163                  sleep            happy                good
## 164            being happy            weird              korean
## 165               running             happy                 shy
## 166               play ps4            lazy            energetic
## 167                 sports          active                 tall
## 168                friends            short              active
## 169 playing with her birds              shy               quiet
## 170               tree tag       emotional                 kind
## 171   playing with brother          active                 tall
## 172                drawing          active                happy
## 173             technology             calm               funny
## 174                reading         friendly               funny
## 175                reading       indecisive              active
## 176            video games              fun                cool
## 177            video games             lazy               funky
## 178   playing with friends           sporty               smart
## 179               sleeping             load           energitic
## 180                nothing              fun           energetic
## 181            volley ball        agressive             anoying
## 182                reading             nice               smart
## 183   playing with friends              fun           energetic
## 184   playing with animals            hyper              flimsy
## 185                drawing            tired               smart
##                           Career                     Superpower
## 1   professional baseball player                    sonic speed
## 2                        Teacher          power to grant wishes
## 3     professional soccer player                  powerful kick
## 4     professional hockey player                   teleportaion
## 5                       engineer   power to answer any question
## 6     professional hockey player                            fly
## 7                         artist                    telekinesis
## 8                         banker                  teleportation
## 9             computer scientist           materialize anything
## 10                       Teacher           manipulating physics
## 11                       swimmer                         flying
## 12                           idk                  teleportation
## 13                        doctor                   invisibility
## 14                sports analyst                    time travel
## 15                       athlete                       strength
## 16                     architect                  teleportation
## 17                     scientist                   invisibility
## 18                          rich                   regeneration
## 19                 soccer player                  reading minds
## 20                        doctor                  teleportation
## 21                           vet                      invisable
## 22                     scientist                    shape shift
## 23                        auther                            fly
## 24                     dessinger                      invisible
## 25                       teacher                       telaport
## 26                      rich man                       telaport
## 27                     dessinger                    shape shift
## 28                     dont know                    shape shift
## 29                      engenier                           fire
## 30                       teacher                           <NA>
## 31                           vet                            fly
## 32                        doctor             change probability
## 33                           idk                     read minds
## 34                           idk                    time travel
## 35                      arcitect                            fly
## 36                    geneticist                       teleport
## 37                    landscaper                have everything
## 38                     physisist                       teleport
## 39                        lawyer                munipulate time
## 40                       sergent                     invincible
## 41                      mechanic                   invisibility
## 42             controlling minds                           <NA>
## 43                           n/a                         wishes
## 44                           n/a                          speed
## 45                     scientist                         wishes
## 46                       athlete                  reading minds
## 47             sports journalist                   invisibility
## 48                        doctor                         wishes
## 49                        lawyer                            fly
## 50                      engineer                      telepathy
## 51                     Scientist                      Telepathy
## 52                  entrepreneur                          speed
## 53                         baker                            fly
## 54                      inventer                          speed
## 55                    basketball                    shape shift
## 56                        lawyer                  mind controle
## 57                           cop                     invincable
## 58                 hockey player                     lazer eyes
## 59                        Docter                            fly
## 60                        lawyer                           <NA>
## 61                           N/A                            All
## 62                        Artist         Time and space control
## 63                           N/A                        Conjure
## 64                        Doctor                   Invisibility
## 65                           Vet                     Read Minds
## 66                        Lawyer                    Time Travel
## 67                     Architect                 Control Nature
## 68                       Athlete                         Flying
## 69                       Athlete                           Fire
## 70                       Athlete             Speak Any Language
## 71                        Lawyer                     Read Minds
## 72              Speech Therapist                 Shape Shifting
## 73                  Soccer Plyer          Amazing At Everything
## 74                paleontologist                      invisible
## 75             Investment banker                  make anything
## 76                        lawyer                       teleport
## 77                           idk            everything (little)
## 78                           idk                      invisible
## 79                        author                       teleport
## 80                        author                      invisible
## 81                         pilot                            fly
## 82                        lawyer                       teleport
## 83                           idk                            fly
## 84                  I don't know                   Invisibility
## 85                    Programmer                     Fire Power
## 86               Baseball Player                          Speed
## 87                    NHL Player                   invisibility
## 88                        Doctor                   invisibility
## 89                        Doctor                            Fly
## 90                     Scientist                  Teleportation
## 91                    Programmer                     All Powers
## 92                     Scientist                  Teleportation
## 93                       Soldier                     All Powers
## 94                          chef                infinity stones
## 95               pokemon trainer                       teleport
## 96                    programmer            remember everything
## 97                          <NA>                     all powers
## 98                  pediatrician                    shape shift
## 99                      engineer                         phycic
## 100                         <NA>              take other powers
## 101            software designer                    never tired
## 102            computer designer                         E.S.P.
## 103                     designer                  shape shifter
## 104                  Nerosurgeon                            Fly
## 105              baseball player                            Fly
## 106                      surgeon                     Read minds
## 107                          vet                        physich
## 108                       doctor                      Invisible
## 109                      surgeon                    Fire powers
## 110                       doctor                       teleport
## 111                      sergeon                     Read minds
## 112                       soccer                          speed
## 113                      Wealthy                           <NA>
## 114                       lawyer   making money out of thin air
## 115                       doctor                      death ray
## 116                 proffesional                         flight
## 117                window washer             infinite knowledge
## 118                       lawyer                    time travel
## 119                       lawyer                   mind reading
## 120                      actress              control over time
## 121                     animator         molecular manipulation
## 122                 neurosurgeon                        flight 
## 123                soccer player                           <NA>
## 124                 I don't Know                           Fire
## 125                         Rich               Rearanging Atoms
## 126                         Rich                   Mind Reading
## 127           Computer Scientist                      Cunjuring
## 128                    IT Worker                      Conjuring
## 129                      Teacher            Infinite everything
## 130                      Teacher Manipulate the Laws of Phisycs
## 131            Investment Banker            Infinite everything
## 132                  Vetranerian                    Shape-Shift
## 133                     Athelete                         Flight
## 134                     engineer                      invisible
## 135                          n/a                         flight
## 136                          n/a                    time powers
## 137             fashion designer                       teleport
## 138                        loyer                  teleportation
## 139                        model                   mind control
## 140                        model                  teleportation
## 141                  actor/model           reality manipulation
## 142                       doctor                     pause time
## 143               music industry                          speed
## 144                       Doctor             to know everything
## 145                       doctor                            fly
## 146              buisness person                          water
## 147                         cook                     all powers
## 148                      teacher                     telephathy
## 149                     engineer                           fast
## 150                 brain surgen                        vampire
## 151                       lawyer                        vampire
## 152                          vet                           fly 
## 153                     animater                           <NA>
## 154                       doctor                         plasma
## 155                     engineer                         flying
## 156                      actress                         flying
## 157                    biologist                    time travel
## 158                       doctor                   mind reading
## 159                       author                  teleportation
## 160                     engineer                   invisibility
## 161                       lawyer                   mind bending
## 162           computer scientist                   mind reading
## 163                         rich                           <NA>
## 164                  millionaire                         flying
## 165                       lawyer                         flying
## 166                   NFL player                 super strength
## 167                hockey player             good at everything
## 168                hockey player                   invisibility
## 169            interior designer                   bend reality
## 170              baseball player                     everything
## 171            interior designer                    super speed
## 172                         chef                         flying
## 173                robot creator              anything he wants
## 174                     designer                         flying
## 175                      gymnast                         flying
## 176                       doctor                    super speed
## 177                  horse rider                  teleportation
## 178                      surgeon                    super speed
## 179                       lawyer                   mind reading
## 180                     inventor                 shape shifting
## 181                   movue star                  teleportation
## 182                     enginere                   invisibility
## 183                    zoologist                    super speed
## 184                        happy                    super speed
## 185                       artist                           <NA>
# Remove Duplicates

data_cleaned2 <- distinct(df)
data_cleaned2
##      ID         Gender Grade   Horoscope Subject IntExt    OptPest ScreenTime
## 1     1           male     4     Scorpio    Math      1   Optimist        1.0
## 2     2         female     4   Capricorn     Gym      1   Optimist        1.0
## 3     3           male     4      Taurus    Math      2   Optimist        4.0
## 4     4           male     4    Aquarius    Math      3 Don't Know        3.0
## 5     5           male     4     Scorpio     Gym      3 Don't Know        1.0
## 6     6           male     4      Pisces     Gym      1   Optimist        2.0
## 7     7           male     3     Scorpio     Art      2   Optimist        1.0
## 8     8           male     6      Taurus    Math      1   Optimist        4.0
## 9     9           male     6       Aries     Gym      2  Pessimist        6.0
## 10   10           male     6      Pisces    Math      2 Don't Know        3.0
## 11   11         female     4         Leo     Gym      3   Optimist        1.0
## 12   12         female     4     Scorpio    Math      3   Optimist        1.0
## 13   13         female     4      Taurus     Art      1   Optimist        0.0
## 14   14           male     7         Leo     Gym      1 Don't Know        5.0
## 15   15           male     8 Sagittarius     Gym      3   Optimist        6.0
## 16   16         female     8      Cancer     Gym      2   Optimist        5.0
## 17   17           male     8         Leo Science      2   Optimist        8.0
## 18   18           male     8     Scorpio     Gym      2   Optimist        4.0
## 19   19           male     8      Cancer    Math      2   Optimist        2.0
## 20   20         female     8   Capricorn     Art      1  Pessimist        3.0
## 21   21         female     5      Cancer     Art      2   Optimist        2.0
## 22   22         female     6       Virgo Science      2 Don't Know        1.0
## 23   23         female     5      Pisces     Art      1   Optimist        1.0
## 24   24         female     6      Taurus     Art      2   Optimist        4.0
## 25   25         female     6      Pisces Science      1   Optimist        1.0
## 26   26         female     6      Gemini     Art      2  Pessimist        3.0
## 27   27           male     6       Libra     Gym      1  Pessimist        1.0
## 28   28           male     6     Scorpio Science      2 Don't Know        3.0
## 29   29         female     6       Virgo    Math      3  Pessimist        4.0
## 30   31         female     8      Cancer Science      1   Optimist        9.0
## 31   32         female     8      Gemini Science      3 Don't Know       10.0
## 32   33         female     8     Scorpio Science      1 Don't Know       10.0
## 33   34         female     7      Cancer     Art      2  Pessimist        3.0
## 34   35         female     7      Gemini     Gym      3   Optimist        3.0
## 35   36           male     8    Aquarius     Art      3   Optimist        4.0
## 36   37           male     8      Taurus History      3 Don't Know        5.0
## 37   38           male     7       Virgo    Math      2  Pessimist        2.0
## 38   39           male     8      Taurus    Math      1   Optimist        2.0
## 39   40           male     8    Aquarius     Gym      1  Pessimist        2.0
## 40   41           male     5      Pisces    Math      3  Pessimist        1.0
## 41   43           male     5   Capricorn     Gym      1  Pessimist        4.0
## 42   44           male     5      Taurus     Gym      1  Pessimist        1.0
## 43   45         female     5       Libra Science      3   Optimist        3.0
## 44   46           male     5       Libra     Gym      1  Pessimist        1.0
## 45   47           male     5      Gemini     Gym      1   Optimist        2.0
## 46   48         female     5      Taurus     Art      1   Optimist        1.0
## 47   49         female     5         Leo    Math      2   Optimist        2.0
## 48   50         female     5 Sagittarius     Art      2 Don't Know        2.0
## 49   51         female     5         Leo     Art      1   Optimist        5.0
## 50   52         female     6      Taurus     Gym      1   Optimist        1.0
## 51   53         female     6       Aries History      1   Optimist        3.0
## 52   54           male     5     Scorpio     Gym      1   Optimist        2.0
## 53   55           male     5      Gemini     Gym      1   Optimist        4.0
## 54   56           male     4     Scorpio     Gym      1   Optimist        3.0
## 55   57           male     4      Cancer History      2   Optimist        1.0
## 56   58         female     4      Pisces     Gym      2   Optimist        1.0
## 57   59         female     6      Pisces    Math      1   Optimist        1.0
## 58   61           male     6    Aquarius     Gym      2 Don't Know        3.0
## 59   62 Don't Identify     6       Libra     Art      3 Don't Know        4.0
## 60   63           male     6      Gemini    Math      1 Don't Know        3.0
## 61   64         female     6         Leo    Math      3 Don't Know        1.0
## 62   65         female     6         Leo     Gym      2   Optimist        1.0
## 63   66         female     6       Aries     Gym      2   Optimist        3.0
## 64   67           male     6   Capricorn     Gym      1   Optimist        5.0
## 65   68           male     6      Cancer     Gym      1   Optimist        1.0
## 66   69           male     4       Aries    Math      2  Pessimist        1.0
## 67   70           male     4 Sagittarius    Math      1  Pessimist        3.0
## 68   71         female     6      Cancer     Gym      1   Optimist        1.0
## 69   72         female     6         Leo Science      2   Optimist        2.0
## 70   73           male     6      Cancer     Gym      2   Optimist        1.0
## 71   74         female     4      Cancer     Art      2   Optimist        2.0
## 72   75           male     4         Leo     Art      3  Pessimist        3.0
## 73   76         female     4      Pisces     Art      3   Optimist        2.0
## 74   77         female     4      Cancer    Math      1   Optimist        1.0
## 75   78         female     4         Leo     Gym      3   Optimist        1.0
## 76   79           male     4      Pisces Science      1  Pessimist        1.0
## 77   80           male     4    Aquarius Science      1  Pessimist        2.0
## 78   81         female     4     Scorpio     Art      3  Pessimist        1.0
## 79   82           male     4      Taurus    Math      1  Pessimist        1.0
## 80   83         female     4     Scorpio     Art      3 Don't Know        0.0
## 81   84           male     4      Pisces     Gym      3   Optimist        1.0
## 82   85           male     4       Virgo     Gym      1   Optimist        2.0
## 83   86           male     4     Scorpio     Gym      1   Optimist        1.0
## 84   87           male     4      Gemini     Gym      3   Optimist        2.0
## 85   88           male     4       Virgo     Art      1   Optimist        2.0
## 86   89         female     4     Scorpio     Art      2   Optimist        1.0
## 87   90           male     5     Scorpio Science      1   Optimist        3.0
## 88   91           male     5     Scorpio     Gym      1  Pessimist        4.0
## 89   92           male     5       Libra    Math      2 Don't Know        4.0
## 90   93           male     5       Virgo     Gym      1 Don't Know        5.0
## 91   94         female     6     Scorpio    Math      3  Pessimist        7.0
## 92   96         female     4      Taurus     Art      3 Don't Know        1.0
## 93   98         female     5 Sagittarius Science      1  Pessimist        3.0
## 94   99         female     5       Libra    Math      3  Pessimist        3.0
## 95  101         female     5         Leo    Math      2   Optimist        4.0
## 96  102           male     6       Aries     Art      2  Pessimist        3.0
## 97  103         female     6     Scorpio     Gym      1 Don't Know        3.0
## 98  104         female     7         Leo     Art      3   Optimist        1.0
## 99  105           male     7    Aquarius     Gym      1   Optimist        4.0
## 100 106         female     7      Cancer     Gym      1   Optimist        4.0
## 101 107           male     7      Gemini History      1   Optimist        2.0
## 102 108         female     7      Cancer     Art      2  Pessimist        4.0
## 103 109         female     7 Sagittarius    Math      2   Optimist        0.5
## 104 110         female     7      Gemini    Math      1   Optimist        2.0
## 105 111         female     7       Libra    Math      2   Optimist        2.0
## 106 112           male     7      Taurus     Gym      3  Pessimist        4.0
## 107 114         female     8       Libra    Math      1   Optimist       18.0
## 108 115         female     8       Libra     Art      1   Optimist        4.0
## 109 116         female     8    Aquarius     Gym      1 Don't Know        5.0
## 110 117           male     8   Capricorn     Art      2 Don't Know        3.0
## 111 118         female     8       Aries     Art      1 Don't Know        4.0
## 112 119           male     8         Leo     Art      1   Optimist        5.0
## 113 120         female     8      Taurus     Gym      1   Optimist        5.0
## 114 121         female     8      Pisces     Art      3   Optimist        3.0
## 115 122           male     8      Gemini Science      2 Don't Know        5.0
## 116 124         female     6       Virgo    Math      3  Pessimist        4.0
## 117 125           male     6      Gemini    Math      2  Pessimist        3.0
## 118 126         female     6      Pisces     Gym      1  Pessimist        7.0
## 119 127           male     6       Aries     Gym      2  Pessimist        6.0
## 120 128           male     6      Pisces Science      2  Pessimist        1.0
## 121 129           male     6      Cancer     Gym      2  Pessimist        6.0
## 122 130           male     6 Sagittarius    Math      2 Don't Know        3.0
## 123 131           male     6      Taurus    Math      1   Optimist        4.0
## 124 132         female     6      Cancer Science      2   Optimist        1.0
## 125 133           male     6       Virgo    Math      2   Optimist        0.0
## 126 134           male     8       Aries Science      1  Pessimist        2.0
## 127 135         female     8 Sagittarius Science      1   Optimist        2.0
## 128 136           male     8       Aries     Gym      1   Optimist        2.0
## 129 137           male     8         Leo     Art      1  Pessimist        3.0
## 130 138         female     8       Aries     Art      1   Optimist        8.0
## 131 139         female     8   Capricorn     Gym      2  Pessimist        1.0
## 132 140         female     8      Gemini Science      1   Optimist        2.0
## 133 141           male     8       Libra     Art      1  Pessimist        3.0
## 134 142         female     8   Capricorn     Gym      3   Optimist        5.0
## 135 143           male     8    Aquarius     Art      1   Optimist        4.0
## 136 144         female     5 Sagittarius     Gym      3   Optimist        2.0
## 137 145         female     4      Pisces     Gym      1 Don't Know        1.0
## 138 148 Don't Identify     5       Aries History      1  Pessimist        3.0
## 139 149           male     5       Aries    Math      1   Optimist        3.0
## 140 150         female     6       Aries     Art      1  Pessimist       10.0
## 141 151         female     6      Cancer     Gym      1 Don't Know        5.0
## 142 152         female     5      Pisces    Math      1   Optimist        2.0
## 143 154           male     5      Gemini     Gym      1   Optimist        1.0
## 144 155         female     5 Sagittarius Science      3  Pessimist        4.0
## 145 156         female     5   Capricorn     Art      1   Optimist        3.0
## 146 157           male     5       Aries Science      3  Pessimist        7.0
## 147 158         female     5   Capricorn    Math      1 Don't Know        4.0
## 148 159           male     5   Capricorn     Gym      1   Optimist        1.0
## 149 160           male     5   Capricorn     Gym      1 Don't Know        2.0
## 150 161         female     5      Gemini     Gym      1 Don't Know        2.0
## 151 162           male     5   Capricorn     Gym      1   Optimist        5.0
## 152 164           male     6       Virgo     Gym      1  Pessimist        1.0
## 153 165         female     6         Leo History      2  Pessimist        1.0
## 154 166           male     6      Cancer     Gym      1   Optimist        3.0
## 155 167           male     6       Libra     Gym      1   Optimist        5.0
## 156 168         female     4       Virgo Science      1   Optimist        1.0
## 157 169         female     4       Virgo     Gym      2  Pessimist        1.0
## 158 170           male     4    Aquarius     Art      1 Don't Know        5.0
## 159 171         female     4       Aries     Gym      3   Optimist        1.0
## 160 172         female     4       Aries    Math      2   Optimist        1.0
## 161 173           male     4       Aries Science      2  Pessimist        1.0
## 162 174         female     4       Virgo History      1  Pessimist        1.0
## 163 175         female     4         Leo Science      3 Don't Know        1.0
## 164 176           male     6       Aries    Math      1  Pessimist        1.0
## 165 177         female     6       Virgo Science      1  Pessimist        8.0
## 166 178           male     6       Aries    Math      1   Optimist        2.0
## 167 179         female     6    Aquarius     Gym      1  Pessimist        6.0
## 168 180           male     6   Capricorn    Math      1   Optimist        2.0
## 169 181         female     6       Aries     Gym      1  Pessimist        5.0
## 170 182           male     6 Sagittarius    Math      1   Optimist        1.0
## 171 183           male     6      Cancer     Gym      1   Optimist        3.0
## 172 184         female     6       Aries     Gym      1   Optimist        2.0
##     Sleep PhysActive HrsHomework                 SpendTime1
## 1     7.0         10        10.0                   baseball
## 2     8.0          5         0.0            playing outside
## 3     9.0         22         1.0                video games
## 4     9.0          9         1.0                video games
## 5     9.0         10         1.0                    reading
## 6     9.0         20         2.0                     sports
## 7    11.0          4        14.0                watching TV
## 8     9.0         12        21.0                video games
## 9     8.0          4         6.0                video games
## 10    9.0         12         3.0                video games
## 11   10.0          5         0.0                   reading 
## 12   10.0          5         0.0                         tv
## 13    9.0          5         0.0                    reading
## 14    8.0         14         4.0                     sports
## 15    9.0         25         2.0                     sports
## 16    7.0          6         3.0                       read
## 17    7.0          2         0.0                      house
## 18    8.0         10         0.0                     soccer
## 19    9.0         10         3.0                     soccer
## 20    8.0         10         5.0                      phone
## 21    9.0          2         1.0                       bike
## 22    8.0          5         2.0                     sports
## 23    9.0          1         8.0                       read
## 24    9.0          6         4.0                    drawing
## 25    8.0          7         4.0                     sports
## 26    6.0         14         3.0                       read
## 27   10.0          5         2.0                       read
## 28   10.0          5         5.0                video games
## 29    9.0         14        14.0                       read
## 30    8.0          8        35.0                    reading
## 31    5.0          5        20.0                    netflix
## 32    3.0          7        20.0                    netflix
## 33    9.0          3         2.0                    reading
## 34    8.0          7         5.0                     sports
## 35    8.0          7         6.0                    reading
## 36   10.0          7         8.0                    reading
## 37    9.0         14         4.0                rubix cubes
## 38    9.0         10         3.0                     sports
## 39    9.0          9         3.0                     sports
## 40    9.0          9         4.0 staring blankly into space
## 41    8.0         14         5.0                ball hockey
## 42    9.0         12         1.0                   baseball
## 43    8.0          7         2.0                   crafting
## 44   11.0          5         1.0                watching tv
## 45   10.0         11         2.0                     sports
## 46    7.0          5         1.0                    reading
## 47   10.0          6         6.0           watching pokemon
## 48    8.0          8         1.0                    reading
## 49    9.0          8         1.0                        run
## 50   10.0         10         1.0                     soccer
## 51    9.0          6         4.0                    netflix
## 52    7.0          2         1.0                     family
## 53    9.0         12         0.0                video games
## 54   10.0          5         3.0                       xbox
## 55    8.0         82         8.0                 activeitys
## 56   10.0          3         0.0                    outside
## 57    9.0          5         1.0               with friends
## 58    8.0         10        14.0                Video Games
## 59   12.0          3         6.0                       Pets
## 60    9.0          8         3.0                Video Games
## 61    9.0          2         1.0                    Reading
## 62    8.0         10         3.0                    Friends
## 63   10.0         15         3.0                     Baking
## 64    9.0         10         3.0                    Outside
## 65   10.0         12         3.0                     Sports
## 66   10.0         70        21.0                     Active
## 67    8.0         50         0.0                      Games
## 68    9.0         14         1.0                     Hockey
## 69    9.0          7         1.0                       Draw
## 70    9.0         21         1.0                     Soccer
## 71   10.0         20         6.0                    running
## 72    9.0          7        10.0                video games
## 73   11.0         10         1.0           playing with dog
## 74    9.0         36         7.0                      dance
## 75    9.0          8         4.0            play w/ friends
## 76    8.0         72         3.0                       read
## 77    8.0          9         4.0                     soccer
## 78   12.0          2         1.0                       draw
## 79   11.0         12         2.0                       read
## 80   10.0          2         1.0             computer games
## 81   10.0         28         0.0                     Sports
## 82    9.0         30         1.0                 Videogames
## 83    8.0         10         2.0                     Sports
## 84    9.0         16         3.0                 Videogames
## 85   10.0         20         7.0                      Guild
## 86    9.0         19         7.0                        Art
## 87   10.0         10         6.0                       Play
## 88    9.0          6         7.0                 Skateboard
## 89    9.0         12         5.0                    Youtube
## 90    8.0          5         7.0                         Tv
## 91    8.0          8         0.0                    youtube
## 92   10.0         15         4.0                video games
## 93   10.0         11         6.0                   fortnite
## 94    9.0          8         6.0                 gymnastics
## 95    9.0         11         8.0                     sports
## 96    8.0         10         3.0          talk with friends
## 97   10.0         10         5.0                video games
## 98    9.0          2         0.5                        IDK
## 99    9.0         26         1.0                     Sports
## 100   7.0         10         0.0               Being active
## 101   8.0         15         2.0                    Dancing
## 102   7.0          4        12.0           watching netflix
## 103   9.0         14        12.0          going to the park
## 104   8.0          4         7.0             playing sports
## 105   9.5          4         8.0                   sleeping
## 106   9.0         28         7.0             playing soccer
## 107   6.0          0         4.0                    friends
## 108   8.0         12         0.0                    singing
## 109   8.0         10         0.0                    friends
## 110  10.0         10         0.0                   sleeping
## 111   8.0          4         1.0                    friends
## 112   8.0         15         0.0                   fortnite
## 113   8.0          8         0.0                    friends
## 114   8.0          3         1.0                   drawing 
## 115   7.0          6         0.0                      games
## 116   9.0          6        14.0                       Read
## 117   5.0          8         2.0                       Read
## 118   6.0          7         5.0                   Watch TV
## 119   8.0         12         4.0                       Code
## 120   9.0         10         7.0                       Read
## 121   7.0          7         3.0                   Watch TV
## 122   9.0         14         4.0                        D&D
## 123   7.0         24         5.0             Go to the Park
## 124   9.0         12         5.0                       Read
## 125   5.0         40         1.0                     Sports
## 126  10.0          7         7.0                     soccer
## 127  10.0          5         7.0                    reading
## 128  10.0         14         6.0                video games
## 129   8.0         20         2.0                  instagram
## 130   7.0          8         2.0                    Netflix
## 131   6.0          1         1.0                    reading
## 132   7.0         21         5.0                    Netflix
## 133   8.0          3         7.0                    friends
## 134   7.0         14         5.0                   relaxing
## 135   8.0         18         7.0                    friends
## 136   8.0          5         9.0                     family
## 137  10.0          7         0.0                     hockey
## 138  10.0          5         4.0                     soccer
## 139   9.0         10         7.0                video games
## 140   2.0         13         1.0                    netflix
## 141   4.0          8         1.0                    netflix
## 142  10.0          6         2.0                pet project
## 143  10.0         40        14.0                video games
## 144   9.0         15         1.0                         tv
## 145   8.0          7         6.0                    reading
## 146   8.0         10         0.0                         tv
## 147  10.0          7         3.0                 trampoline
## 148   8.0         16         5.0                     soccer
## 149   9.0         11         4.0                     sports
## 150   8.0         16         6.0                 gymnastics
## 151   3.0          5         1.0                    origami
## 152  10.0          7         1.0                video games
## 153   8.0          7         2.0                   reading 
## 154   9.0         12         3.0                    eating 
## 155  10.0         15         2.0                    friends
## 156  10.0         70         1.0                road hockey
## 157   8.0          3         1.0        playing on computer
## 158  10.0          1         6.0                video games
## 159  10.0          8         1.0                    soccer 
## 160  11.0          7         1.0                   reading 
## 161   8.0          9         1.0                   reading 
## 162  11.0          2         1.0                video games
## 163  10.0          9         2.0                 gymnastics
## 164   9.0         22         7.0                 basketball
## 165   7.0          1         1.0                     eating
## 166   8.0         10         9.0             playing sports
## 167   8.0          7         0.0           watching youtube
## 168   9.0         10         1.0                    nothing
## 169   6.0          7         0.0           playing with dog
## 170  11.0         13         6.0             playing sports
## 171   9.0         11         5.0                video games
## 172   9.0          7         0.0                    playing
##                 SpendTime2            Self1               Self2
## 1                 relaxing           active         competitive
## 2                 swimming             kind              active
## 3                   soccer           active            creative
## 4                   sports           active         responsible
## 5              hanging out      intellegent              strong
## 6     playing with friends            funny              active
## 7                  reading           joyful                lazy
## 8          playing outside              fun           confident
## 9                   biking              sad                calm
## 10    dungeons and dragons            smart               tired
## 11                 drawing            funny            athletic
## 12                    lego           caring         responsible
## 13                 outside             kind              active
## 14                     idk           living            annoying
## 15                      tv         athletic           energetic
## 16                   watch              idk                 idk
## 17                     idk              idk                 idk
## 18                     ps4          awesome             amazing
## 19                     ps4           funny                smart
## 20                      tv            smart               happy
## 21                  soccer            quite              pretty
## 22                   phone           sporty               smart
## 23                    bike             nice                kind
## 24              ranbowloom             nice               happy
## 25                    talk              fun                kind
## 26                    play            wierd             awkward
## 27                    play            rebel               small
## 28                    talk            funny                loud
## 29                    play          anoying                 fun
## 30           playing games         childish            annoying
## 31         texting talking            moody             intense
## 32                  eating             loud       unpredictable
## 33           playing games              shy             curious
## 34                 reading         creative             curious
## 35                 youtube            quiet          expressive
## 36           playing games          curious            friendly
## 37                   piano              shy          persistent
## 38             video games             tall               asian
## 39           summer school            funny           energitic
## 40      looking at nothing           simple                 n/a
## 41            being myself        talkative beyond not annoying
## 42                sleeping              n/a                 n/a
## 43           making things         creative              caring
## 44                  sports        talkative              caring
## 45     playing video games       empathetic                kind
## 46                swimming       optimistic           extravert
## 47                 reading             nice            outgoing
## 48         watching videos         athletic             fidgety
## 49                     dog              Fun               Sweet
## 50                    read           pretty              sporty
## 51                 youtube            happy                kind
## 52                 helpful         greatful             awesome
## 53                 outside             cool             awesome
## 54                 reading             cool              active
## 55             basket ball        generouse                kind
## 56             video games             nice                nice
## 57                  sports            funny                kind
## 58                 Reading         Childish                Lazy
## 59             Video Games        Sarcastic               Sassy
## 60                   Piano        Energetic             Curious
## 61                Writitng            Quiet              Boring
## 62                 Drawing            Weird              Active
## 63                Shopping            Funny                 Shy
## 64                 Friends            Chill                Tall
## 65                 Friends           Active                Cool
## 66                Sleeping      Intelligent            Athletic
## 67                 Eating          Annoying             Awesome
## 68                 Friends         Athletic             Amazing
## 69                     Dog              Shy          Embarassed
## 70       Playing w/ sister           Active            Athletic
## 71                     art       thoughtful            friendly
## 72                 drawing            weird                 odd
## 73                   dance            funny             awesome
## 74                  sports           active                 fun
## 75                    read            funny               small
## 76              play games         negative              sneaky
## 77         sing on a couch         friendly            creative
## 78                  crafts            funny                nice
## 79             video games            angry             awesome
## 80                 friends              art                cats
## 81              Videogames           Active               Smart
## 82                 Playing             Kind               Happy
## 83                   Relax            Happy              Active
## 84                  Sports      Competetive                Kind
## 85                    Play            Gamer              Sporty
## 86                    Work            Smart               Sweet
## 87              Videogames           Active               Smart
## 88              Videogames            Gamer               Smart
## 89                   Relax           Active               Smart
## 90                  Guitar            Gamer            Annoying
## 91                 dancing            sassy               funny
## 92                    lego            loyal            artistic
## 93                 shoping            funny                rude
## 94                 youtube            funny            athletic
## 95                 netflix           funny             athletic
## 96                 youtube        agressive                calm
## 97                 netflix            small               funny
## 98                     IDK            Human              Person
## 99          Beating friend        Annoying              stuburn
## 100                talking            funny            confused
## 101   Hanging with friends            funny            outgoing
## 102   Hanging with friends        Hilarious             awesome
## 103           staying home      Fashionable             awesome
## 104                cooking            smart              active
## 105         playing sports            smart              active
## 106       playing fortnite         athletic               smart
## 107                 family            sassy               happy
## 108                friends              fun               happy
## 109                netflix         athletic              thiccc
## 110                reading            funny            annoying
## 111                     TV            smart              blonde
## 112                friends              the                goat
## 113                netflix            smart                nice
## 114                  games             calm               happy
## 115                 eating overly energetic           impatient
## 116                  Sleep         Bookworm            Annoying
## 117               Fortnite            Wierd               Crazy
## 118      Play with Friends            Chill                Dude
## 119                   Bike            Witty        Condesending
## 120               Fortnite            Smart              Sporty
## 121               Fortnite             Lazy              Gifted
## 122               Fortnite            Smart    Video Game Lover
## 123               Fortnite            Smart         Extreverted
## 124          Watch my Fish         Friendly                 Shy
## 125      Play with Friends              Fun         Extreverted
## 126                 hockey         athletic         intelligent
## 127               swimming            weird                cool
## 128                reading         cheerful          optimistic
## 129               sleeping            petty               basic
## 130                friends      adventurous                 n/a
## 131               sleeping         peculiar               sassy
## 132                friends             cool                 cat
## 133                Netflix            small               blond
## 134                friends            funny            athletic
## 135                  music        laid back           setericle
## 136                reading              shy              active
## 137                 soccer           active              sporty
## 138            video games           hungry            friendly
## 139                   lego            smart               smart
## 140                  chill         positive                lazy
## 141                   swim             lazy              pretty
## 142               out side           unsure               smart
## 143               outdoors       empathetic           observant
## 144               you tube         clueless               funny
## 145                 eating       determined              caring
## 146             basketball        talkative               witty
## 147                 baking            happy            annoying
## 148                     tv            funny               loyal
## 149            video games              fun              caring
## 150                talking      extraverted               sassy
## 151            video games    free spirited            creative
## 152            being happy            weird              korean
## 153               running             happy                 shy
## 154               play ps4            lazy            energetic
## 155                 sports          active                 tall
## 156                friends            short              active
## 157 playing with her birds              shy               quiet
## 158               tree tag       emotional                 kind
## 159   playing with brother          active                 tall
## 160                drawing          active                happy
## 161             technology             calm               funny
## 162                reading         friendly               funny
## 163                reading       indecisive              active
## 164            video games              fun                cool
## 165            video games             lazy               funky
## 166   playing with friends           sporty               smart
## 167               sleeping             load           energitic
## 168                nothing              fun           energetic
## 169            volley ball        agressive             anoying
## 170                reading             nice               smart
## 171   playing with friends              fun           energetic
## 172   playing with animals            hyper              flimsy
##                           Career                     Superpower
## 1   professional baseball player                    sonic speed
## 2                        Teacher          power to grant wishes
## 3     professional soccer player                  powerful kick
## 4     professional hockey player                   teleportaion
## 5                       engineer   power to answer any question
## 6     professional hockey player                            fly
## 7                         artist                    telekinesis
## 8                         banker                  teleportation
## 9             computer scientist           materialize anything
## 10                       Teacher           manipulating physics
## 11                       swimmer                         flying
## 12                           idk                  teleportation
## 13                        doctor                   invisibility
## 14                sports analyst                    time travel
## 15                       athlete                       strength
## 16                     architect                  teleportation
## 17                     scientist                   invisibility
## 18                          rich                   regeneration
## 19                 soccer player                  reading minds
## 20                        doctor                  teleportation
## 21                           vet                      invisable
## 22                     scientist                    shape shift
## 23                        auther                            fly
## 24                     dessinger                      invisible
## 25                       teacher                       telaport
## 26                      rich man                       telaport
## 27                     dessinger                    shape shift
## 28                     dont know                    shape shift
## 29                      engenier                           fire
## 30                           vet                            fly
## 31                        doctor             change probability
## 32                           idk                     read minds
## 33                           idk                    time travel
## 34                      arcitect                            fly
## 35                    geneticist                       teleport
## 36                    landscaper                have everything
## 37                     physisist                       teleport
## 38                        lawyer                munipulate time
## 39                       sergent                     invincible
## 40                      mechanic                   invisibility
## 41                           n/a                         wishes
## 42                           n/a                          speed
## 43                     scientist                         wishes
## 44                       athlete                  reading minds
## 45             sports journalist                   invisibility
## 46                        doctor                         wishes
## 47                        lawyer                            fly
## 48                      engineer                      telepathy
## 49                     Scientist                      Telepathy
## 50                  entrepreneur                          speed
## 51                         baker                            fly
## 52                      inventer                          speed
## 53                    basketball                    shape shift
## 54                        lawyer                  mind controle
## 55                           cop                     invincable
## 56                 hockey player                     lazer eyes
## 57                        Docter                            fly
## 58                           N/A                            All
## 59                        Artist         Time and space control
## 60                           N/A                        Conjure
## 61                        Doctor                   Invisibility
## 62                           Vet                     Read Minds
## 63                        Lawyer                    Time Travel
## 64                     Architect                 Control Nature
## 65                       Athlete                         Flying
## 66                       Athlete                           Fire
## 67                       Athlete             Speak Any Language
## 68                        Lawyer                     Read Minds
## 69              Speech Therapist                 Shape Shifting
## 70                  Soccer Plyer          Amazing At Everything
## 71                paleontologist                      invisible
## 72             Investment banker                  make anything
## 73                        lawyer                       teleport
## 74                           idk            everything (little)
## 75                           idk                      invisible
## 76                        author                       teleport
## 77                        author                      invisible
## 78                         pilot                            fly
## 79                        lawyer                       teleport
## 80                           idk                            fly
## 81                  I don't know                   Invisibility
## 82                    Programmer                     Fire Power
## 83               Baseball Player                          Speed
## 84                    NHL Player                   invisibility
## 85                        Doctor                   invisibility
## 86                        Doctor                            Fly
## 87                     Scientist                  Teleportation
## 88                    Programmer                     All Powers
## 89                     Scientist                  Teleportation
## 90                       Soldier                     All Powers
## 91                          chef                infinity stones
## 92                    programmer            remember everything
## 93                  pediatrician                    shape shift
## 94                      engineer                         phycic
## 95             software designer                    never tired
## 96             computer designer                         E.S.P.
## 97                      designer                  shape shifter
## 98                   Nerosurgeon                            Fly
## 99               baseball player                            Fly
## 100                      surgeon                     Read minds
## 101                          vet                        physich
## 102                       doctor                      Invisible
## 103                      surgeon                    Fire powers
## 104                       doctor                       teleport
## 105                      sergeon                     Read minds
## 106                       soccer                          speed
## 107                       lawyer   making money out of thin air
## 108                       doctor                      death ray
## 109                 proffesional                         flight
## 110                window washer             infinite knowledge
## 111                       lawyer                    time travel
## 112                       lawyer                   mind reading
## 113                      actress              control over time
## 114                     animator         molecular manipulation
## 115                 neurosurgeon                        flight 
## 116                 I don't Know                           Fire
## 117                         Rich               Rearanging Atoms
## 118                         Rich                   Mind Reading
## 119           Computer Scientist                      Cunjuring
## 120                    IT Worker                      Conjuring
## 121                      Teacher            Infinite everything
## 122                      Teacher Manipulate the Laws of Phisycs
## 123            Investment Banker            Infinite everything
## 124                  Vetranerian                    Shape-Shift
## 125                     Athelete                         Flight
## 126                     engineer                      invisible
## 127                          n/a                         flight
## 128                          n/a                    time powers
## 129             fashion designer                       teleport
## 130                        loyer                  teleportation
## 131                        model                   mind control
## 132                        model                  teleportation
## 133                  actor/model           reality manipulation
## 134                       doctor                     pause time
## 135               music industry                          speed
## 136                       Doctor             to know everything
## 137                       doctor                            fly
## 138                      teacher                     telephathy
## 139                     engineer                           fast
## 140                 brain surgen                        vampire
## 141                       lawyer                        vampire
## 142                          vet                           fly 
## 143                       doctor                         plasma
## 144                     engineer                         flying
## 145                      actress                         flying
## 146                    biologist                    time travel
## 147                       doctor                   mind reading
## 148                       author                  teleportation
## 149                     engineer                   invisibility
## 150                       lawyer                   mind bending
## 151           computer scientist                   mind reading
## 152                  millionaire                         flying
## 153                       lawyer                         flying
## 154                   NFL player                 super strength
## 155                hockey player             good at everything
## 156                hockey player                   invisibility
## 157            interior designer                   bend reality
## 158              baseball player                     everything
## 159            interior designer                    super speed
## 160                         chef                         flying
## 161                robot creator              anything he wants
## 162                     designer                         flying
## 163                      gymnast                         flying
## 164                       doctor                    super speed
## 165                  horse rider                  teleportation
## 166                      surgeon                    super speed
## 167                       lawyer                   mind reading
## 168                     inventor                 shape shifting
## 169                   movue star                  teleportation
## 170                     enginere                   invisibility
## 171                    zoologist                    super speed
## 172                        happy                    super speed

1 Function

# Check unique values of each column
sapply(df, function(x) length(unique(x)))
##          ID      Gender       Grade   Horoscope     Subject      IntExt 
##         172           3           6          12           5           3 
##     OptPest  ScreenTime       Sleep  PhysActive HrsHomework  SpendTime1 
##           3          13          12          33          17          90 
##  SpendTime2       Self1       Self2      Career  Superpower 
##         102          98          94         100          97

Statistical Info / EDA / Reporting

# Summary function 
# to show each column, it’s data type and a few other attributes which are especially useful 
# for numeric attributes. 
# We can see that for all the numeric attributes, it also displays min, 1st quartile, median, mean, 
# 3rd quartile and max values.
summary(df)
##        ID            Gender              Grade        Horoscope        
##  Min.   :  1.00   Length:172         Min.   :3.000   Length:172        
##  1st Qu.: 45.75   Class :character   1st Qu.:5.000   Class :character  
##  Median : 89.50   Mode  :character   Median :6.000   Mode  :character  
##  Mean   : 91.58                      Mean   :5.767                     
##  3rd Qu.:137.25                      3rd Qu.:7.000                     
##  Max.   :184.00                      Max.   :8.000                     
##    Subject          IntExt   OptPest            ScreenTime         Sleep       
##  Length:172         1:91   Length:172         Min.   : 0.000   Min.   : 2.000  
##  Class :character   2:47   Class :character   1st Qu.: 1.000   1st Qu.: 8.000  
##  Mode  :character   3:34   Mode  :character   Median : 2.500   Median : 9.000  
##                                               Mean   : 2.968   Mean   : 8.608  
##                                               3rd Qu.: 4.000   3rd Qu.:10.000  
##                                               Max.   :18.000   Max.   :12.000  
##    PhysActive     HrsHomework      SpendTime1         SpendTime2       
##  Min.   : 0.00   Min.   : 0.000   Length:172         Length:172        
##  1st Qu.: 6.00   1st Qu.: 1.000   Class :character   Class :character  
##  Median : 9.00   Median : 3.000   Mode  :character   Mode  :character  
##  Mean   :11.80   Mean   : 4.142                                        
##  3rd Qu.:13.25   3rd Qu.: 6.000                                        
##  Max.   :82.00   Max.   :35.000                                        
##     Self1              Self2              Career           Superpower       
##  Length:172         Length:172         Length:172         Length:172        
##  Class :character   Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character   Mode  :character  
##                                                                             
##                                                                             
## 
# Skim
# This function is a good addition to the summary function. 
# It displays most of the numerical attributes from summary, but it also 
# displays missing values, more quantile information and an inline histogram for each variable
skim(df)
Data summary
Name df
Number of rows 172
Number of columns 17
_______________________
Column type frequency:
character 10
factor 1
numeric 6
________________________
Group variables None

Variable type: character

skim_variable n_missing complete_rate min max empty n_unique whitespace
Gender 0 1 4 14 0 3 0
Horoscope 0 1 3 11 0 12 0
Subject 0 1 3 7 0 5 0
OptPest 0 1 8 10 0 3 0
SpendTime1 0 1 2 26 0 90 0
SpendTime2 0 1 2 22 0 102 0
Self1 0 1 3 16 0 98 0
Self2 0 1 3 19 0 94 0
Career 0 1 3 28 0 100 0
Superpower 0 1 3 30 0 97 0

Variable type: factor

skim_variable n_missing complete_rate ordered n_unique top_counts
IntExt 0 1 FALSE 3 1: 91, 2: 47, 3: 34

Variable type: numeric

skim_variable n_missing complete_rate mean sd p0 p25 p50 p75 p100 hist
ID 0 1 91.58 53.83 1 45.75 89.5 137.25 184 ▇▇▇▇▇
Grade 0 1 5.77 1.40 3 5.00 6.0 7.00 8 ▆▅▇▂▅
ScreenTime 0 1 2.97 2.33 0 1.00 2.5 4.00 18 ▇▃▁▁▁
Sleep 0 1 8.61 1.52 2 8.00 9.0 10.00 12 ▁▁▅▇▁
PhysActive 0 1 11.80 12.15 0 6.00 9.0 13.25 82 ▇▁▁▁▁
HrsHomework 0 1 4.14 4.76 0 1.00 3.0 6.00 35 ▇▁▁▁▁
# Analyzing categorical variables
# freq function runs for all factor or character variables automatically:
freq(df)
## Warning: `guides(<scale> = FALSE)` is deprecated. Please use `guides(<scale> =
## "none")` instead.
##           Gender frequency percentage cumulative_perc
## 1         female        85      49.42           49.42
## 2           male        85      49.42           98.84
## 3 Don't Identify         2       1.16          100.00
## Warning: `guides(<scale> = FALSE)` is deprecated. Please use `guides(<scale> =
## "none")` instead.

##      Horoscope frequency percentage cumulative_perc
## 1        Aries        21      12.21           12.21
## 2       Cancer        18      10.47           22.68
## 3      Scorpio        17       9.88           32.56
## 4          Leo        16       9.30           41.86
## 5       Pisces        15       8.72           50.58
## 6       Gemini        14       8.14           58.72
## 7       Taurus        14       8.14           66.86
## 8    Capricorn        13       7.56           74.42
## 9        Virgo        13       7.56           81.98
## 10       Libra        11       6.40           88.38
## 11    Aquarius        10       5.81           94.19
## 12 Sagittarius        10       5.81          100.00
## Warning: `guides(<scale> = FALSE)` is deprecated. Please use `guides(<scale> =
## "none")` instead.

##   Subject frequency percentage cumulative_perc
## 1     Gym        64      37.21           37.21
## 2    Math        40      23.26           60.47
## 3     Art        36      20.93           81.40
## 4 Science        25      14.53           95.93
## 5 History         7       4.07          100.00
## Warning: `guides(<scale> = FALSE)` is deprecated. Please use `guides(<scale> =
## "none")` instead.

##   IntExt frequency percentage cumulative_perc
## 1      1        91      52.91           52.91
## 2      2        47      27.33           80.24
## 3      3        34      19.77          100.00
## Warning: `guides(<scale> = FALSE)` is deprecated. Please use `guides(<scale> =
## "none")` instead.

##      OptPest frequency percentage cumulative_perc
## 1   Optimist        92      53.49           53.49
## 2  Pessimist        49      28.49           81.98
## 3 Don't Know        31      18.02          100.00
## Warning: `guides(<scale> = FALSE)` is deprecated. Please use `guides(<scale> =
## "none")` instead.

##                    SpendTime1 frequency percentage cumulative_perc
## 1                 video games        17       9.88            9.88
## 2                     reading        11       6.40           16.28
## 3                      sports        11       6.40           22.68
## 4                     friends         7       4.07           26.75
## 5                        read         7       4.07           30.82
## 6                      soccer         7       4.07           34.89
## 7                     netflix         5       2.91           37.80
## 8                      Sports         5       2.91           40.71
## 9                        Read         4       2.33           43.04
## 10                 gymnastics         3       1.74           44.78
## 11             playing sports         3       1.74           46.52
## 12                   reading          3       1.74           48.26
## 13                         tv         3       1.74           50.00
## 14                   baseball         2       1.16           51.16
## 15                     family         2       1.16           52.32
## 16                   fortnite         2       1.16           53.48
## 17                    Netflix         2       1.16           54.64
## 18           playing with dog         2       1.16           55.80
## 19                   sleeping         2       1.16           56.96
## 20                Video Games         2       1.16           58.12
## 21                 Videogames         2       1.16           59.28
## 22                   Watch TV         2       1.16           60.44
## 23                   reading          1       0.58           61.02
## 24                     Active         1       0.58           61.60
## 25                 activeitys         1       0.58           62.18
## 26                        Art         1       0.58           62.76
## 27                     Baking         1       0.58           63.34
## 28                ball hockey         1       0.58           63.92
## 29                 basketball         1       0.58           64.50
## 30               Being active         1       0.58           65.08
## 31                       bike         1       0.58           65.66
## 32                       Code         1       0.58           66.24
## 33             computer games         1       0.58           66.82
## 34                   crafting         1       0.58           67.40
## 35                        D&D         1       0.58           67.98
## 36                      dance         1       0.58           68.56
## 37                    Dancing         1       0.58           69.14
## 38                       draw         1       0.58           69.72
## 39                       Draw         1       0.58           70.30
## 40                    drawing         1       0.58           70.88
## 41                   drawing          1       0.58           71.46
## 42                     eating         1       0.58           72.04
## 43                    eating          1       0.58           72.62
## 44                    Friends         1       0.58           73.20
## 45                      games         1       0.58           73.78
## 46                      Games         1       0.58           74.36
## 47             Go to the Park         1       0.58           74.94
## 48          going to the park         1       0.58           75.52
## 49                      Guild         1       0.58           76.10
## 50                     hockey         1       0.58           76.68
## 51                     Hockey         1       0.58           77.26
## 52                      house         1       0.58           77.84
## 53                        IDK         1       0.58           78.42
## 54                  instagram         1       0.58           79.00
## 55                    nothing         1       0.58           79.58
## 56                    origami         1       0.58           80.16
## 57                    outside         1       0.58           80.74
## 58                    Outside         1       0.58           81.32
## 59                pet project         1       0.58           81.90
## 60                       Pets         1       0.58           82.48
## 61                      phone         1       0.58           83.06
## 62                       Play         1       0.58           83.64
## 63            play w/ friends         1       0.58           84.22
## 64                    playing         1       0.58           84.80
## 65        playing on computer         1       0.58           85.38
## 66            playing outside         1       0.58           85.96
## 67             playing soccer         1       0.58           86.54
## 68                    Reading         1       0.58           87.12
## 69                   relaxing         1       0.58           87.70
## 70                road hockey         1       0.58           88.28
## 71                rubix cubes         1       0.58           88.86
## 72                        run         1       0.58           89.44
## 73                    running         1       0.58           90.02
## 74                    singing         1       0.58           90.60
## 75                 Skateboard         1       0.58           91.18
## 76                     Soccer         1       0.58           91.76
## 77                    soccer          1       0.58           92.34
## 78 staring blankly into space         1       0.58           92.92
## 79          talk with friends         1       0.58           93.50
## 80                 trampoline         1       0.58           94.08
## 81                         Tv         1       0.58           94.66
## 82           watching netflix         1       0.58           95.24
## 83           watching pokemon         1       0.58           95.82
## 84                watching tv         1       0.58           96.40
## 85                watching TV         1       0.58           96.98
## 86           watching youtube         1       0.58           97.56
## 87               with friends         1       0.58           98.14
## 88                       xbox         1       0.58           98.72
## 89                    youtube         1       0.58           99.30
## 90                    Youtube         1       0.58          100.00
## Warning in freq_logic(data = data, input = input[i], plot, na.rm, path_out =
## path_out): Skipping plot for variable 'SpendTime2' (more than 100 categories)
##                 SpendTime2 frequency percentage cumulative_perc
## 1                  reading        10       5.81            5.81
## 2              video games         8       4.65           10.46
## 3                  friends         7       4.07           14.53
## 4                 Fortnite         5       2.91           17.44
## 5                   sports         5       2.91           20.35
## 6                  netflix         4       2.33           22.68
## 7                 sleeping         4       2.33           25.01
## 8                  youtube         4       2.33           27.34
## 9                  drawing         3       1.74           29.08
## 10                  eating         3       1.74           30.82
## 11                 Friends         3       1.74           32.56
## 12                    lego         3       1.74           34.30
## 13                    play         3       1.74           36.04
## 14           playing games         3       1.74           37.78
## 15    playing with friends         3       1.74           39.52
## 16                  soccer         3       1.74           41.26
## 17                swimming         3       1.74           43.00
## 18                      tv         3       1.74           44.74
## 19              Videogames         3       1.74           46.48
## 20    Hanging with friends         2       1.16           47.64
## 21                     idk         2       1.16           48.80
## 22                 outside         2       1.16           49.96
## 23       Play with Friends         2       1.16           51.12
## 24                     ps4         2       1.16           52.28
## 25                    read         2       1.16           53.44
## 26                   Relax         2       1.16           54.60
## 27                    talk         2       1.16           55.76
## 28                 talking         2       1.16           56.92
## 29                     art         1       0.58           57.50
## 30                  baking         1       0.58           58.08
## 31             basket ball         1       0.58           58.66
## 32              basketball         1       0.58           59.24
## 33          Beating friend         1       0.58           59.82
## 34             being happy         1       0.58           60.40
## 35            being myself         1       0.58           60.98
## 36                    bike         1       0.58           61.56
## 37                    Bike         1       0.58           62.14
## 38                  biking         1       0.58           62.72
## 39                   chill         1       0.58           63.30
## 40                 cooking         1       0.58           63.88
## 41                  crafts         1       0.58           64.46
## 42                   dance         1       0.58           65.04
## 43                 dancing         1       0.58           65.62
## 44                     dog         1       0.58           66.20
## 45                     Dog         1       0.58           66.78
## 46                 Drawing         1       0.58           67.36
## 47    dungeons and dragons         1       0.58           67.94
## 48                 Eating          1       0.58           68.52
## 49                  family         1       0.58           69.10
## 50                   games         1       0.58           69.68
## 51                  Guitar         1       0.58           70.26
## 52             hanging out         1       0.58           70.84
## 53                 helpful         1       0.58           71.42
## 54                  hockey         1       0.58           72.00
## 55                     IDK         1       0.58           72.58
## 56      looking at nothing         1       0.58           73.16
## 57           making things         1       0.58           73.74
## 58                   music         1       0.58           74.32
## 59                 Netflix         1       0.58           74.90
## 60                 nothing         1       0.58           75.48
## 61                out side         1       0.58           76.06
## 62                outdoors         1       0.58           76.64
## 63                   phone         1       0.58           77.22
## 64                   piano         1       0.58           77.80
## 65                   Piano         1       0.58           78.38
## 66                    Play         1       0.58           78.96
## 67              play games         1       0.58           79.54
## 68                play ps4         1       0.58           80.12
## 69                 Playing         1       0.58           80.70
## 70        playing fortnite         1       0.58           81.28
## 71         playing outside         1       0.58           81.86
## 72          playing sports         1       0.58           82.44
## 73     playing video games         1       0.58           83.02
## 74       Playing w/ sister         1       0.58           83.60
## 75    playing with animals         1       0.58           84.18
## 76    playing with brother         1       0.58           84.76
## 77  playing with her birds         1       0.58           85.34
## 78              ranbowloom         1       0.58           85.92
## 79                 Reading         1       0.58           86.50
## 80                relaxing         1       0.58           87.08
## 81                running          1       0.58           87.66
## 82                 shoping         1       0.58           88.24
## 83                Shopping         1       0.58           88.82
## 84         sing on a couch         1       0.58           89.40
## 85                   Sleep         1       0.58           89.98
## 86                Sleeping         1       0.58           90.56
## 87                  Sports         1       0.58           91.14
## 88            staying home         1       0.58           91.72
## 89           summer school         1       0.58           92.30
## 90                    swim         1       0.58           92.88
## 91              technology         1       0.58           93.46
## 92         texting talking         1       0.58           94.04
## 93                tree tag         1       0.58           94.62
## 94                      TV         1       0.58           95.20
## 95             Video Games         1       0.58           95.78
## 96             volley ball         1       0.58           96.36
## 97                   watch         1       0.58           96.94
## 98           Watch my Fish         1       0.58           97.52
## 99         watching videos         1       0.58           98.10
## 100                   Work         1       0.58           98.68
## 101               Writitng         1       0.58           99.26
## 102               you tube         1       0.58          100.00
## Warning: `guides(<scale> = FALSE)` is deprecated. Please use `guides(<scale> =
## "none")` instead.

##               Self1 frequency percentage cumulative_perc
## 1             funny        15       8.72            8.72
## 2               fun         7       4.07           12.79
## 3             smart         7       4.07           16.86
## 4            active         5       2.91           19.77
## 5            Active         5       2.91           22.68
## 6          athletic         5       2.91           25.59
## 7              nice         5       2.91           28.50
## 8               shy         4       2.33           30.83
## 9             Smart         4       2.33           33.16
## 10          active          3       1.74           34.90
## 11             cool         3       1.74           36.64
## 12            Gamer         3       1.74           38.38
## 13            happy         3       1.74           40.12
## 14        talkative         3       1.74           41.86
## 15            weird         3       1.74           43.60
## 16        agressive         2       1.16           44.76
## 17             calm         2       1.16           45.92
## 18            Chill         2       1.16           47.08
## 19         creative         2       1.16           48.24
## 20       empathetic         2       1.16           49.40
## 21         friendly         2       1.16           50.56
## 22              Fun         2       1.16           51.72
## 23           funny          2       1.16           52.88
## 24              idk         2       1.16           54.04
## 25             kind         2       1.16           55.20
## 26             lazy         2       1.16           56.36
## 27            sassy         2       1.16           57.52
## 28            small         2       1.16           58.68
## 29           sporty         2       1.16           59.84
## 30      adventurous         1       0.58           60.42
## 31            angry         1       0.58           61.00
## 32         Annoying         1       0.58           61.58
## 33        Annoying          1       0.58           62.16
## 34          anoying         1       0.58           62.74
## 35              art         1       0.58           63.32
## 36         Athletic         1       0.58           63.90
## 37          awesome         1       0.58           64.48
## 38         Bookworm         1       0.58           65.06
## 39           caring         1       0.58           65.64
## 40         cheerful         1       0.58           66.22
## 41         childish         1       0.58           66.80
## 42         Childish         1       0.58           67.38
## 43         clueless         1       0.58           67.96
## 44      Competetive         1       0.58           68.54
## 45          curious         1       0.58           69.12
## 46       determined         1       0.58           69.70
## 47       emotional          1       0.58           70.28
## 48        Energetic         1       0.58           70.86
## 49      extraverted         1       0.58           71.44
## 50      Fashionable         1       0.58           72.02
## 51    free spirited         1       0.58           72.60
## 52         Friendly         1       0.58           73.18
## 53            Funny         1       0.58           73.76
## 54        generouse         1       0.58           74.34
## 55         greatful         1       0.58           74.92
## 56            Happy         1       0.58           75.50
## 57        Hilarious         1       0.58           76.08
## 58            Human         1       0.58           76.66
## 59           hungry         1       0.58           77.24
## 60            hyper         1       0.58           77.82
## 61       indecisive         1       0.58           78.40
## 62      intellegent         1       0.58           78.98
## 63      Intelligent         1       0.58           79.56
## 64           joyful         1       0.58           80.14
## 65             Kind         1       0.58           80.72
## 66        laid back         1       0.58           81.30
## 67             Lazy         1       0.58           81.88
## 68            lazy          1       0.58           82.46
## 69           living         1       0.58           83.04
## 70             load         1       0.58           83.62
## 71             loud         1       0.58           84.20
## 72            loyal         1       0.58           84.78
## 73            moody         1       0.58           85.36
## 74              n/a         1       0.58           85.94
## 75         negative         1       0.58           86.52
## 76       optimistic         1       0.58           87.10
## 77 overly energetic         1       0.58           87.68
## 78         peculiar         1       0.58           88.26
## 79            petty         1       0.58           88.84
## 80         positive         1       0.58           89.42
## 81           pretty         1       0.58           90.00
## 82            quiet         1       0.58           90.58
## 83            Quiet         1       0.58           91.16
## 84            quite         1       0.58           91.74
## 85            rebel         1       0.58           92.32
## 86              sad         1       0.58           92.90
## 87        Sarcastic         1       0.58           93.48
## 88            short         1       0.58           94.06
## 89              Shy         1       0.58           94.64
## 90           simple         1       0.58           95.22
## 91             tall         1       0.58           95.80
## 92              the         1       0.58           96.38
## 93       thoughtful         1       0.58           96.96
## 94           unsure         1       0.58           97.54
## 95            Weird         1       0.58           98.12
## 96            wierd         1       0.58           98.70
## 97            Wierd         1       0.58           99.28
## 98            Witty         1       0.58          100.00
## Warning: `guides(<scale> = FALSE)` is deprecated. Please use `guides(<scale> =
## "none")` instead.

##                  Self2 frequency percentage cumulative_perc
## 1               active         9       5.23            5.23
## 2                 kind         7       4.07            9.30
## 3                smart         7       4.07           13.37
## 4              awesome         6       3.49           16.86
## 5                happy         6       3.49           20.35
## 6                funny         5       2.91           23.26
## 7             annoying         4       2.33           25.59
## 8             athletic         4       2.33           27.92
## 9               caring         4       2.33           30.25
## 10           energetic         4       2.33           32.58
## 11               Smart         4       2.33           34.91
## 12            creative         3       1.74           36.65
## 13            friendly         3       1.74           38.39
## 14                 n/a         3       1.74           40.13
## 15                nice         3       1.74           41.87
## 16              Active         2       1.16           43.03
## 17            Annoying         2       1.16           44.19
## 18            Athletic         2       1.16           45.35
## 19                calm         2       1.16           46.51
## 20                cool         2       1.16           47.67
## 21             curious         2       1.16           48.83
## 22           energitic         2       1.16           49.99
## 23         Extreverted         2       1.16           51.15
## 24                 fun         2       1.16           52.31
## 25                 idk         2       1.16           53.47
## 26                lazy         2       1.16           54.63
## 27            outgoing         2       1.16           55.79
## 28              pretty         2       1.16           56.95
## 29         responsible         2       1.16           58.11
## 30               sassy         2       1.16           59.27
## 31                 Shy         2       1.16           60.43
## 32               small         2       1.16           61.59
## 33              sporty         2       1.16           62.75
## 34              Sporty         2       1.16           63.91
## 35               Sweet         2       1.16           65.07
## 36                tall         2       1.16           66.23
## 37             amazing         1       0.58           66.81
## 38             Amazing         1       0.58           67.39
## 39             anoying         1       0.58           67.97
## 40            artistic         1       0.58           68.55
## 41               asian         1       0.58           69.13
## 42             Awesome         1       0.58           69.71
## 43             awkward         1       0.58           70.29
## 44               basic         1       0.58           70.87
## 45 beyond not annoying         1       0.58           71.45
## 46               blond         1       0.58           72.03
## 47              blonde         1       0.58           72.61
## 48              Boring         1       0.58           73.19
## 49                 cat         1       0.58           73.77
## 50                cats         1       0.58           74.35
## 51         competitive         1       0.58           74.93
## 52        Condesending         1       0.58           75.51
## 53           confident         1       0.58           76.09
## 54            confused         1       0.58           76.67
## 55                Cool         1       0.58           77.25
## 56               Crazy         1       0.58           77.83
## 57             Curious         1       0.58           78.41
## 58                Dude         1       0.58           78.99
## 59          Embarassed         1       0.58           79.57
## 60          expressive         1       0.58           80.15
## 61           extravert         1       0.58           80.73
## 62             fidgety         1       0.58           81.31
## 63              flimsy         1       0.58           81.89
## 64               funky         1       0.58           82.47
## 65              Gifted         1       0.58           83.05
## 66                goat         1       0.58           83.63
## 67               Happy         1       0.58           84.21
## 68           impatient         1       0.58           84.79
## 69         intelligent         1       0.58           85.37
## 70             intense         1       0.58           85.95
## 71                Kind         1       0.58           86.53
## 72              korean         1       0.58           87.11
## 73                Lazy         1       0.58           87.69
## 74                loud         1       0.58           88.27
## 75               loyal         1       0.58           88.85
## 76           observant         1       0.58           89.43
## 77                 odd         1       0.58           90.01
## 78          optimistic         1       0.58           90.59
## 79          persistent         1       0.58           91.17
## 80              Person         1       0.58           91.75
## 81               quiet         1       0.58           92.33
## 82                rude         1       0.58           92.91
## 83               Sassy         1       0.58           93.49
## 84           setericle         1       0.58           94.07
## 85                 shy         1       0.58           94.65
## 86              sneaky         1       0.58           95.23
## 87              strong         1       0.58           95.81
## 88             stuburn         1       0.58           96.39
## 89                Tall         1       0.58           96.97
## 90              thiccc         1       0.58           97.55
## 91               tired         1       0.58           98.13
## 92       unpredictable         1       0.58           98.71
## 93    Video Game Lover         1       0.58           99.29
## 94               witty         1       0.58          100.00
## Warning in freq_logic(data = data, input = input[i], plot, na.rm, path_out =
## path_out): Skipping plot for variable 'Career' (more than 100 categories)
##                           Career frequency percentage cumulative_perc
## 1                         doctor        12       6.98            6.98
## 2                         lawyer        12       6.98           13.96
## 3                       engineer         7       4.07           18.03
## 4                            idk         6       3.49           21.52
## 5                         Doctor         4       2.33           23.85
## 6                            n/a         4       2.33           26.18
## 7                        Teacher         4       2.33           28.51
## 8                            vet         4       2.33           30.84
## 9                        Athlete         3       1.74           32.58
## 10                        author         3       1.74           34.32
## 11                 hockey player         3       1.74           36.06
## 12                     scientist         3       1.74           37.80
## 13                     Scientist         3       1.74           39.54
## 14                       surgeon         3       1.74           41.28
## 15                       actress         2       1.16           42.44
## 16                       athlete         2       1.16           43.60
## 17               baseball player         2       1.16           44.76
## 18                          chef         2       1.16           45.92
## 19            computer scientist         2       1.16           47.08
## 20                      designer         2       1.16           48.24
## 21                     dessinger         2       1.16           49.40
## 22             interior designer         2       1.16           50.56
## 23                        Lawyer         2       1.16           51.72
## 24                         model         2       1.16           52.88
## 25                           N/A         2       1.16           54.04
## 26    professional hockey player         2       1.16           55.20
## 27                    Programmer         2       1.16           56.36
## 28                          Rich         2       1.16           57.52
## 29                       teacher         2       1.16           58.68
## 30                   actor/model         1       0.58           59.26
## 31                      animator         1       0.58           59.84
## 32                     architect         1       0.58           60.42
## 33                     Architect         1       0.58           61.00
## 34                      arcitect         1       0.58           61.58
## 35                        artist         1       0.58           62.16
## 36                        Artist         1       0.58           62.74
## 37                      Athelete         1       0.58           63.32
## 38                        auther         1       0.58           63.90
## 39                         baker         1       0.58           64.48
## 40                        banker         1       0.58           65.06
## 41               Baseball Player         1       0.58           65.64
## 42                    basketball         1       0.58           66.22
## 43                     biologist         1       0.58           66.80
## 44                  brain surgen         1       0.58           67.38
## 45             computer designer         1       0.58           67.96
## 46            Computer Scientist         1       0.58           68.54
## 47                           cop         1       0.58           69.12
## 48                        Docter         1       0.58           69.70
## 49                     dont know         1       0.58           70.28
## 50                      engenier         1       0.58           70.86
## 51                      enginere         1       0.58           71.44
## 52                  entrepreneur         1       0.58           72.02
## 53              fashion designer         1       0.58           72.60
## 54                    geneticist         1       0.58           73.18
## 55                       gymnast         1       0.58           73.76
## 56                         happy         1       0.58           74.34
## 57                   horse rider         1       0.58           74.92
## 58                  I don't know         1       0.58           75.50
## 59                  I don't Know         1       0.58           76.08
## 60                      inventer         1       0.58           76.66
## 61                      inventor         1       0.58           77.24
## 62             Investment banker         1       0.58           77.82
## 63             Investment Banker         1       0.58           78.40
## 64                     IT Worker         1       0.58           78.98
## 65                    landscaper         1       0.58           79.56
## 66                         loyer         1       0.58           80.14
## 67                      mechanic         1       0.58           80.72
## 68                   millionaire         1       0.58           81.30
## 69                    movue star         1       0.58           81.88
## 70                music industry         1       0.58           82.46
## 71                   Nerosurgeon         1       0.58           83.04
## 72                  neurosurgeon         1       0.58           83.62
## 73                    NFL player         1       0.58           84.20
## 74                    NHL Player         1       0.58           84.78
## 75                paleontologist         1       0.58           85.36
## 76                  pediatrician         1       0.58           85.94
## 77                     physisist         1       0.58           86.52
## 78                         pilot         1       0.58           87.10
## 79  professional baseball player         1       0.58           87.68
## 80    professional soccer player         1       0.58           88.26
## 81                  proffesional         1       0.58           88.84
## 82                    programmer         1       0.58           89.42
## 83                          rich         1       0.58           90.00
## 84                      rich man         1       0.58           90.58
## 85                 robot creator         1       0.58           91.16
## 86                       sergent         1       0.58           91.74
## 87                       sergeon         1       0.58           92.32
## 88                        soccer         1       0.58           92.90
## 89                 soccer player         1       0.58           93.48
## 90                  Soccer Plyer         1       0.58           94.06
## 91             software designer         1       0.58           94.64
## 92                       Soldier         1       0.58           95.22
## 93              Speech Therapist         1       0.58           95.80
## 94                sports analyst         1       0.58           96.38
## 95             sports journalist         1       0.58           96.96
## 96                       swimmer         1       0.58           97.54
## 97                           Vet         1       0.58           98.12
## 98                   Vetranerian         1       0.58           98.70
## 99                 window washer         1       0.58           99.28
## 100                    zoologist         1       0.58          100.00
## Warning: `guides(<scale> = FALSE)` is deprecated. Please use `guides(<scale> =
## "none")` instead.

##                        Superpower frequency percentage cumulative_perc
## 1                             fly        10       5.81            5.81
## 2                    invisibility         9       5.23           11.04
## 3                   teleportation         9       5.23           16.27
## 4                          flying         8       4.65           20.92
## 5                        teleport         7       4.07           24.99
## 6                       invisible         5       2.91           27.90
## 7                     shape shift         5       2.91           30.81
## 8                           speed         5       2.91           33.72
## 9                     super speed         5       2.91           36.63
## 10                   mind reading         4       2.33           38.96
## 11                    time travel         4       2.33           41.29
## 12                            Fly         3       1.74           43.03
## 13                         wishes         3       1.74           44.77
## 14                     All Powers         2       1.16           45.93
## 15                           Fire         2       1.16           47.09
## 16                         flight         2       1.16           48.25
## 17            Infinite everything         2       1.16           49.41
## 18                   Invisibility         2       1.16           50.57
## 19                     Read minds         2       1.16           51.73
## 20                     Read Minds         2       1.16           52.89
## 21                  reading minds         2       1.16           54.05
## 22                       telaport         2       1.16           55.21
## 23                  Teleportation         2       1.16           56.37
## 24                        vampire         2       1.16           57.53
## 25                            All         1       0.58           58.11
## 26          Amazing At Everything         1       0.58           58.69
## 27              anything he wants         1       0.58           59.27
## 28                   bend reality         1       0.58           59.85
## 29             change probability         1       0.58           60.43
## 30                        Conjure         1       0.58           61.01
## 31                      Conjuring         1       0.58           61.59
## 32                 Control Nature         1       0.58           62.17
## 33              control over time         1       0.58           62.75
## 34                      Cunjuring         1       0.58           63.33
## 35                      death ray         1       0.58           63.91
## 36                         E.S.P.         1       0.58           64.49
## 37                     everything         1       0.58           65.07
## 38            everything (little)         1       0.58           65.65
## 39                           fast         1       0.58           66.23
## 40                           fire         1       0.58           66.81
## 41                     Fire Power         1       0.58           67.39
## 42                    Fire powers         1       0.58           67.97
## 43                         Flight         1       0.58           68.55
## 44                        flight          1       0.58           69.13
## 45                           fly          1       0.58           69.71
## 46                         Flying         1       0.58           70.29
## 47             good at everything         1       0.58           70.87
## 48                have everything         1       0.58           71.45
## 49             infinite knowledge         1       0.58           72.03
## 50                infinity stones         1       0.58           72.61
## 51                     invincable         1       0.58           73.19
## 52                     invincible         1       0.58           73.77
## 53                      invisable         1       0.58           74.35
## 54                      Invisible         1       0.58           74.93
## 55                     lazer eyes         1       0.58           75.51
## 56                  make anything         1       0.58           76.09
## 57   making money out of thin air         1       0.58           76.67
## 58 Manipulate the Laws of Phisycs         1       0.58           77.25
## 59           manipulating physics         1       0.58           77.83
## 60           materialize anything         1       0.58           78.41
## 61                   mind bending         1       0.58           78.99
## 62                   mind control         1       0.58           79.57
## 63                  mind controle         1       0.58           80.15
## 64                   Mind Reading         1       0.58           80.73
## 65         molecular manipulation         1       0.58           81.31
## 66                munipulate time         1       0.58           81.89
## 67                    never tired         1       0.58           82.47
## 68                     pause time         1       0.58           83.05
## 69                         phycic         1       0.58           83.63
## 70                        physich         1       0.58           84.21
## 71                         plasma         1       0.58           84.79
## 72   power to answer any question         1       0.58           85.37
## 73          power to grant wishes         1       0.58           85.95
## 74                  powerful kick         1       0.58           86.53
## 75                     read minds         1       0.58           87.11
## 76           reality manipulation         1       0.58           87.69
## 77               Rearanging Atoms         1       0.58           88.27
## 78                   regeneration         1       0.58           88.85
## 79            remember everything         1       0.58           89.43
## 80                    Shape-Shift         1       0.58           90.01
## 81                  shape shifter         1       0.58           90.59
## 82                 shape shifting         1       0.58           91.17
## 83                 Shape Shifting         1       0.58           91.75
## 84                    sonic speed         1       0.58           92.33
## 85             Speak Any Language         1       0.58           92.91
## 86                          Speed         1       0.58           93.49
## 87                       strength         1       0.58           94.07
## 88                 super strength         1       0.58           94.65
## 89                    telekinesis         1       0.58           95.23
## 90                      telepathy         1       0.58           95.81
## 91                      Telepathy         1       0.58           96.39
## 92                     telephathy         1       0.58           96.97
## 93                   teleportaion         1       0.58           97.55
## 94         Time and space control         1       0.58           98.13
## 95                    time powers         1       0.58           98.71
## 96                    Time Travel         1       0.58           99.29
## 97             to know everything         1       0.58          100.00
## [1] "Variables processed: Gender, Horoscope, Subject, IntExt, OptPest, SpendTime1, SpendTime2, Self1, Self2, Career, Superpower"
# Analyzing numerical variables
# Quantitatively
# profiling_num runs for all numerical/integer variables automatically:
profiling_num(df)
##      variable      mean   std_dev variation_coef p_01 p_05  p_25 p_50   p_75
## 1          ID 91.575581 53.832859      0.5878517 2.71 9.55 45.75 89.5 137.25
## 2       Grade  5.767442  1.399034      0.2425745 4.00 4.00  5.00  6.0   7.00
## 3  ScreenTime  2.968023  2.333426      0.7861887 0.00 1.00  1.00  2.5   4.00
## 4       Sleep  8.607558  1.521311      0.1767413 3.00 6.00  8.00  9.0  10.00
## 5  PhysActive 11.802326 12.154772      1.0298624 1.00 2.00  6.00  9.0  13.25
## 6 HrsHomework  4.142442  4.761419      1.1494233 0.00 0.00  1.00  3.0   6.00
##     p_95   p_99    skewness  kurtosis   iqr       range_98      range_80
## 1 175.45 182.29  0.03223066  1.791384 91.50 [2.71, 182.29] [18.1, 166.9]
## 2   8.00   8.00  0.26488738  1.974428  2.00         [4, 8]        [4, 8]
## 3   7.00  10.00  2.32044189 12.741248  3.00        [0, 10]        [1, 5]
## 4  10.45  11.29 -1.26855474  6.374616  2.00     [3, 11.29]       [7, 10]
## 5  28.90  70.58  3.49578996 17.452114  7.25     [1, 70.58]     [3, 20.9]
## 6  14.00  21.00  2.76976881 14.490731  5.00        [0, 21]        [0, 8]
# Graphically
# Plot_num and profiling_num. Both run automatically for all numerical/integer variables:
plot_num(df)
## Warning: `guides(<scale> = FALSE)` is deprecated. Please use `guides(<scale> =
## "none")` instead.
# Describe from Hmisc Package
# Analyzing numerical and categorical at the same time
describe(df)
## df 
## 
##  17  Variables      172  Observations
## --------------------------------------------------------------------------------
## ID 
##        n  missing distinct     Info     Mean      Gmd      .05      .10 
##      172        0      172        1    91.58    62.33     9.55    18.10 
##      .25      .50      .75      .90      .95 
##    45.75    89.50   137.25   166.90   175.45 
## 
## lowest :   1   2   3   4   5, highest: 180 181 182 183 184
## --------------------------------------------------------------------------------
## Gender 
##        n  missing distinct 
##      172        0        3 
##                                                        
## Value      Don't Identify         female           male
## Frequency               2             85             85
## Proportion          0.012          0.494          0.494
## --------------------------------------------------------------------------------
## Grade 
##        n  missing distinct     Info     Mean      Gmd 
##      172        0        6    0.945    5.767    1.565 
## 
## lowest : 3 4 5 6 7, highest: 4 5 6 7 8
##                                               
## Value          3     4     5     6     7     8
## Frequency      1    40    34    52    13    32
## Proportion 0.006 0.233 0.198 0.302 0.076 0.186
## --------------------------------------------------------------------------------
## Horoscope 
##        n  missing distinct 
##      172        0       12 
## 
## lowest : Aquarius    Aries       Cancer      Capricorn   Gemini     
## highest: Pisces      Sagittarius Scorpio     Taurus      Virgo      
## 
## Aquarius (10, 0.058), Aries (21, 0.122), Cancer (18, 0.105), Capricorn (13,
## 0.076), Gemini (14, 0.081), Leo (16, 0.093), Libra (11, 0.064), Pisces (15,
## 0.087), Sagittarius (10, 0.058), Scorpio (17, 0.099), Taurus (14, 0.081), Virgo
## (13, 0.076)
## --------------------------------------------------------------------------------
## Subject 
##        n  missing distinct 
##      172        0        5 
## 
## lowest : Art     Gym     History Math    Science
## highest: Art     Gym     History Math    Science
##                                                   
## Value          Art     Gym History    Math Science
## Frequency       36      64       7      40      25
## Proportion   0.209   0.372   0.041   0.233   0.145
## --------------------------------------------------------------------------------
## IntExt 
##        n  missing distinct 
##      172        0        3 
##                             
## Value          1     2     3
## Frequency     91    47    34
## Proportion 0.529 0.273 0.198
## --------------------------------------------------------------------------------
## OptPest 
##        n  missing distinct 
##      172        0        3 
##                                            
## Value      Don't Know   Optimist  Pessimist
## Frequency          31         92         49
## Proportion      0.180      0.535      0.285
## --------------------------------------------------------------------------------
## ScreenTime 
##        n  missing distinct     Info     Mean      Gmd      .05      .10 
##      172        0       13    0.959    2.968    2.298      1.0      1.0 
##      .25      .50      .75      .90      .95 
##      1.0      2.5      4.0      5.0      7.0 
## 
## lowest :  0.0  0.5  1.0  2.0  3.0, highest:  7.0  8.0  9.0 10.0 18.0
##                                                                             
## Value        0.0   0.5   1.0   2.0   3.0   4.0   5.0   6.0   7.0   8.0   9.0
## Frequency      3     1    51    31    31    23    16     5     3     3     1
## Proportion 0.017 0.006 0.297 0.180 0.180 0.134 0.093 0.029 0.017 0.017 0.006
##                       
## Value       10.0  18.0
## Frequency      3     1
## Proportion 0.017 0.006
## --------------------------------------------------------------------------------
## Sleep 
##        n  missing distinct     Info     Mean      Gmd      .05      .10 
##      172        0       12     0.94    8.608    1.561     6.00     7.00 
##      .25      .50      .75      .90      .95 
##     8.00     9.00    10.00    10.00    10.45 
## 
## lowest :  2.0  3.0  4.0  5.0  6.0, highest:  9.0  9.5 10.0 11.0 12.0
##                                                                             
## Value        2.0   3.0   4.0   5.0   6.0   7.0   8.0   9.0   9.5  10.0  11.0
## Frequency      1     2     1     3     5    14    45    55     1    36     7
## Proportion 0.006 0.012 0.006 0.017 0.029 0.081 0.262 0.320 0.006 0.209 0.041
##                 
## Value       12.0
## Frequency      2
## Proportion 0.012
## --------------------------------------------------------------------------------
## PhysActive 
##        n  missing distinct     Info     Mean      Gmd      .05      .10 
##      172        0       33    0.994     11.8    9.983     2.00     3.00 
##      .25      .50      .75      .90      .95 
##     6.00     9.00    13.25    20.90    28.90 
## 
## lowest :  0  1  2  3  4, highest: 40 50 70 72 82
## --------------------------------------------------------------------------------
## HrsHomework 
##        n  missing distinct     Info     Mean      Gmd      .05      .10 
##      172        0       17    0.983    4.142    4.442        0        0 
##      .25      .50      .75      .90      .95 
##        1        3        6        8       14 
## 
## lowest :  0.0  0.5  1.0  2.0  3.0, highest: 12.0 14.0 20.0 21.0 35.0
##                                                                             
## Value        0.0   0.5   1.0   2.0   3.0   4.0   5.0   6.0   7.0   8.0   9.0
## Frequency     23     1    38    17    18    14    13    13    14     5     2
## Proportion 0.134 0.006 0.221 0.099 0.105 0.081 0.076 0.076 0.081 0.029 0.012
##                                               
## Value       10.0  12.0  14.0  20.0  21.0  35.0
## Frequency      2     2     5     2     2     1
## Proportion 0.012 0.012 0.029 0.012 0.012 0.006
## --------------------------------------------------------------------------------
## SpendTime1 
##        n  missing distinct 
##      172        0       90 
## 
## lowest :  reading         Active           activeitys       Art              Baking          
## highest: watching youtube with friends     xbox             youtube          Youtube         
## --------------------------------------------------------------------------------
## SpendTime2 
##        n  missing distinct 
##      172        0      102 
## 
## lowest : art             baking          basket ball     basketball      Beating friend 
## highest: watching videos Work            Writitng        you tube        youtube        
## --------------------------------------------------------------------------------
## Self1 
##        n  missing distinct 
##      172        0       98 
## 
## lowest : active      Active      active      adventurous agressive  
## highest: weird       Weird       wierd       Wierd       Witty      
## --------------------------------------------------------------------------------
## Self2 
##        n  missing distinct 
##      172        0       94 
## 
## lowest : active           Active           amazing          Amazing          annoying        
## highest: thiccc           tired            unpredictable    Video Game Lover witty           
## --------------------------------------------------------------------------------
## Career 
##        n  missing distinct 
##      172        0      100 
## 
## lowest : actor/model   actress       animator      architect     Architect    
## highest: vet           Vet           Vetranerian   window washer zoologist    
## --------------------------------------------------------------------------------
## Superpower 
##        n  missing distinct 
##      172        0       97 
## 
## lowest : All                   All Powers            Amazing At Everything anything he wants     bend reality         
## highest: time travel           Time Travel           to know everything    vampire               wishes               
## --------------------------------------------------------------------------------
# Reporting
# Create_report in DataExplorer
# Pull a full data profile of your data frame. 
# It will produce an html file with the basic statistics, structure, missing data, 
# distribution visualizations, correlation matrix and principal component analysis for your data frame

DataExplorer::create_report(df)
## 
## 
## processing file: report.rmd
## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |..                                                                    |   2%
##    inline R code fragments
## 
## 
  |                                                                            
  |...                                                                   |   5%
## label: global_options (with options) 
## List of 1
##  $ include: logi FALSE
## 
## 
  |                                                                            
  |.....                                                                 |   7%
##   ordinary text without R code
## 
## 
  |                                                                            
  |.......                                                               |  10%
## label: introduce
## 
  |                                                                            
  |........                                                              |  12%
##   ordinary text without R code
## 
## 
  |                                                                            
  |..........                                                            |  14%
## label: plot_intro
## 
  |                                                                            
  |............                                                          |  17%
##   ordinary text without R code
## 
## 
  |                                                                            
  |.............                                                         |  19%
## label: data_structure
## 
  |                                                                            
  |...............                                                       |  21%
##   ordinary text without R code
## 
## 
  |                                                                            
  |.................                                                     |  24%
## label: missing_profile
## 
  |                                                                            
  |..................                                                    |  26%
##   ordinary text without R code
## 
## 
  |                                                                            
  |....................                                                  |  29%
## label: univariate_distribution_header
## 
  |                                                                            
  |......................                                                |  31%
##   ordinary text without R code
## 
## 
  |                                                                            
  |.......................                                               |  33%
## label: plot_histogram
## 
  |                                                                            
  |.........................                                             |  36%
##   ordinary text without R code
## 
## 
  |                                                                            
  |...........................                                           |  38%
## label: plot_density
## 
  |                                                                            
  |............................                                          |  40%
##   ordinary text without R code
## 
## 
  |                                                                            
  |..............................                                        |  43%
## label: plot_frequency_bar
## 
  |                                                                            
  |................................                                      |  45%
##   ordinary text without R code
## 
## 
  |                                                                            
  |.................................                                     |  48%
## label: plot_response_bar
## 
  |                                                                            
  |...................................                                   |  50%
##   ordinary text without R code
## 
## 
  |                                                                            
  |.....................................                                 |  52%
## label: plot_with_bar
## 
  |                                                                            
  |......................................                                |  55%
##   ordinary text without R code
## 
## 
  |                                                                            
  |........................................                              |  57%
## label: plot_normal_qq
## 
  |                                                                            
  |..........................................                            |  60%
##   ordinary text without R code
## 
## 
  |                                                                            
  |...........................................                           |  62%
## label: plot_response_qq
## 
  |                                                                            
  |.............................................                         |  64%
##   ordinary text without R code
## 
## 
  |                                                                            
  |...............................................                       |  67%
## label: plot_by_qq
## 
  |                                                                            
  |................................................                      |  69%
##   ordinary text without R code
## 
## 
  |                                                                            
  |..................................................                    |  71%
## label: correlation_analysis
## 
  |                                                                            
  |....................................................                  |  74%
##   ordinary text without R code
## 
## 
  |                                                                            
  |.....................................................                 |  76%
## label: principal_component_analysis
## 
  |                                                                            
  |.......................................................               |  79%
##   ordinary text without R code
## 
## 
  |                                                                            
  |.........................................................             |  81%
## label: bivariate_distribution_header
## 
  |                                                                            
  |..........................................................            |  83%
##   ordinary text without R code
## 
## 
  |                                                                            
  |............................................................          |  86%
## label: plot_response_boxplot
## 
  |                                                                            
  |..............................................................        |  88%
##   ordinary text without R code
## 
## 
  |                                                                            
  |...............................................................       |  90%
## label: plot_by_boxplot
## 
  |                                                                            
  |.................................................................     |  93%
##   ordinary text without R code
## 
## 
  |                                                                            
  |...................................................................   |  95%
## label: plot_response_scatterplot
## 
  |                                                                            
  |....................................................................  |  98%
##   ordinary text without R code
## 
## 
  |                                                                            
  |......................................................................| 100%
## label: plot_by_scatterplot
## output file: D:/01a Prog DS (Thursday)/02 AA 8 Jan 2022/report.knit.md
## "C:/Program Files/RStudio/bin/pandoc/pandoc" +RTS -K512m -RTS "D:/01a Prog DS (Thursday)/02 AA 8 Jan 2022/report.knit.md" --to html4 --from markdown+autolink_bare_uris+tex_math_single_backslash --output pandoc40ec138111fe.html --lua-filter "C:\Users\Valli\Documents\R\win-library\4.1\rmarkdown\rmarkdown\lua\pagebreak.lua" --lua-filter "C:\Users\Valli\Documents\R\win-library\4.1\rmarkdown\rmarkdown\lua\latex-div.lua" --self-contained --variable bs3=TRUE --standalone --section-divs --table-of-contents --toc-depth 6 --template "C:\Users\Valli\Documents\R\win-library\4.1\rmarkdown\rmd\h\default.html" --no-highlight --variable highlightjs=1 --variable theme=yeti --include-in-header "C:\Users\Valli\AppData\Local\Temp\RtmpQH9KJ6\rmarkdown-str40ec4fcb75a.html" --mathjax --variable "mathjax-url:https://mathjax.rstudio.com/latest/MathJax.js?config=TeX-AMS-MML_HTMLorMML"
## 
## Output created: report.html