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
| 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
| IntExt |
0 |
1 |
FALSE |
3 |
1: 91, 2: 47, 3: 34 |
Variable type: numeric
| 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 pandoc1cb010ff52f.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\RtmpYLeLkG\rmarkdown-str1cb03fcb5958.html" --mathjax --variable "mathjax-url:https://mathjax.rstudio.com/latest/MathJax.js?config=TeX-AMS-MML_HTMLorMML"
##
## Output created: report.html
