Import your data
data(flights)
data("airports")
flights %>% skimr::skim()
Data summary
Name |
Piped data |
Number of rows |
336776 |
Number of columns |
19 |
_______________________ |
|
Column type frequency: |
|
character |
4 |
numeric |
14 |
POSIXct |
1 |
________________________ |
|
Group variables |
None |
Variable type: character
carrier |
0 |
1.00 |
2 |
2 |
0 |
16 |
0 |
tailnum |
2512 |
0.99 |
5 |
6 |
0 |
4043 |
0 |
origin |
0 |
1.00 |
3 |
3 |
0 |
3 |
0 |
dest |
0 |
1.00 |
3 |
3 |
0 |
105 |
0 |
Variable type: numeric
year |
0 |
1.00 |
2013.00 |
0.00 |
2013 |
2013 |
2013 |
2013 |
2013 |
▁▁▇▁▁ |
month |
0 |
1.00 |
6.55 |
3.41 |
1 |
4 |
7 |
10 |
12 |
▇▆▆▆▇ |
day |
0 |
1.00 |
15.71 |
8.77 |
1 |
8 |
16 |
23 |
31 |
▇▇▇▇▆ |
dep_time |
8255 |
0.98 |
1349.11 |
488.28 |
1 |
907 |
1401 |
1744 |
2400 |
▁▇▆▇▃ |
sched_dep_time |
0 |
1.00 |
1344.25 |
467.34 |
106 |
906 |
1359 |
1729 |
2359 |
▁▇▇▇▃ |
dep_delay |
8255 |
0.98 |
12.64 |
40.21 |
-43 |
-5 |
-2 |
11 |
1301 |
▇▁▁▁▁ |
arr_time |
8713 |
0.97 |
1502.05 |
533.26 |
1 |
1104 |
1535 |
1940 |
2400 |
▁▃▇▇▇ |
sched_arr_time |
0 |
1.00 |
1536.38 |
497.46 |
1 |
1124 |
1556 |
1945 |
2359 |
▁▃▇▇▇ |
arr_delay |
9430 |
0.97 |
6.90 |
44.63 |
-86 |
-17 |
-5 |
14 |
1272 |
▇▁▁▁▁ |
flight |
0 |
1.00 |
1971.92 |
1632.47 |
1 |
553 |
1496 |
3465 |
8500 |
▇▃▃▁▁ |
air_time |
9430 |
0.97 |
150.69 |
93.69 |
20 |
82 |
129 |
192 |
695 |
▇▂▂▁▁ |
distance |
0 |
1.00 |
1039.91 |
733.23 |
17 |
502 |
872 |
1389 |
4983 |
▇▃▂▁▁ |
hour |
0 |
1.00 |
13.18 |
4.66 |
1 |
9 |
13 |
17 |
23 |
▁▇▇▇▅ |
minute |
0 |
1.00 |
26.23 |
19.30 |
0 |
8 |
29 |
44 |
59 |
▇▃▆▃▅ |
Variable type: POSIXct
time_hour |
0 |
1 |
2013-01-01 05:00:00 |
2013-12-31 23:00:00 |
2013-07-03 10:00:00 |
6936 |
airports %>% skimr::skim()
Data summary
Name |
Piped data |
Number of rows |
1458 |
Number of columns |
8 |
_______________________ |
|
Column type frequency: |
|
character |
4 |
numeric |
4 |
________________________ |
|
Group variables |
None |
Variable type: character
faa |
0 |
1 |
3 |
3 |
0 |
1458 |
0 |
name |
0 |
1 |
4 |
51 |
0 |
1440 |
0 |
dst |
0 |
1 |
1 |
1 |
0 |
3 |
0 |
tzone |
3 |
1 |
14 |
19 |
0 |
9 |
0 |
Variable type: numeric
lat |
0 |
1 |
41.65 |
10.45 |
19.72 |
34.26 |
40.09 |
45.07 |
72.27 |
▂▇▆▂▁ |
lon |
0 |
1 |
-103.39 |
29.84 |
-176.65 |
-119.19 |
-94.66 |
-82.52 |
174.11 |
▅▇▁▁▁ |
alt |
0 |
1 |
1001.42 |
1523.63 |
-54.00 |
70.25 |
473.00 |
1062.50 |
9078.00 |
▇▁▁▁▁ |
tz |
0 |
1 |
-6.52 |
1.62 |
-10.00 |
-8.00 |
-6.00 |
-5.00 |
8.00 |
▆▇▁▁▁ |
Create Data frame functions
Example 1: count columns
code snippets
ncol_num <- flights %>%
# Select a type of variables
select(where(is.numeric)) %>%
# Count columns
ncol()
ncol_num
## [1] 14
Turn them into a function
count_ncol_numeric <- function(.data) {
ncol_num <- .data %>%
# Select a type of variables
select(where(is.numeric)) %>%
# Count columns
ncol()
# return the new variable
return(ncol_num)
}
flights %>% count_ncol_numeric()
## [1] 14
flights %>% .[1:10, -1:-13] %>% count_ncol_numeric()
## [1] 4
Adding arguments for details of operation
count_ncol_type <- function(.data, type_data = "numeric") {
# if statement for type of variables
if(type_data == "numeric") {
# body
ncol_type <- .data %>%
# Select a type of variables
select(where(is.numeric)) %>%
# Count columns
ncol()
} else if (type_data == "character") {
# body
ncol_type <- .data %>%
# Select a type of variables
select(where(is.numeric)) %>%
# Count columns
ncol()
}
# return the new variable
return(ncol_num)
}
flights %>% count_ncol_type()
## [1] 14
flights %>% count_ncol_type(type_data = "character")
## [1] 14
flights %>% .[1:10, 1:5] %>% count_ncol_type(type_data = "character")
## [1] 14
Example 2: count rows
code snippets
nrow_num <- flights %>%
# filter rows that meet a condition
filter(carrier == "DL") %>%
# Count rows
nrow()
nrow_num
## [1] 48110
Turn them into a function
count_num_flights_by_carrier <- function(.data, carrier_name) {
# body
nrow_num <- .data %>%
# filter rows that meet a condition
filter(carrier == carrier_name) %>%
# Count rows
nrow()
# return the new variable
return(nrow_num)
}
flights %>% .[1:10, "carrier"] %>% count_num_flights_by_carrier(carrier_name = "UA")
## [1] 3
Example 3: count rows
ncol_num <- airports %>%
# Select a type of variables
select(where(is.numeric)) %>%
# Count columns
ncol()
ncol_num
## [1] 4
code snippets
count_ncol_numeric <- function(.data) {
ncol_num <- .data %>%
# Select a type of variables
select(where(is.numeric)) %>%
# Count columns
ncol()
# return the new variable
return(ncol_num)
}
airports %>% count_ncol_numeric()
## [1] 4
airports %>% .[1:10, 1:5] %>% count_ncol_numeric()
## [1] 3
Turn them into a function
count_ncol_type <- function(.data, type_data = "numeric") {
# if statement for type of variables
if(type_data == "numeric") {
# body
ncol_type <- .data %>%
# Select a type of variables
select(where(is.numeric)) %>%
# Count columns
ncol()
} else if (type_data == "character") {
# body
ncol_type <- .data %>%
# Select a type of variables
select(where(is.numeric)) %>%
# Count columns
ncol()
}
# return the new variable
return(ncol_num)
}
airports %>% count_ncol_type()
## [1] 4
airports %>% count_ncol_type(type_data = "character")
## [1] 4
airports %>% .[1:10, 1:5] %>% count_ncol_type(type_data = "character")
## [1] 4