# Carregar pacotes
library(readxl)
## Warning: package 'readxl' was built under R version 4.3.2
library(openxlsx)
## Warning: package 'openxlsx' was built under R version 4.3.2
library(knitr)
## Warning: package 'knitr' was built under R version 4.3.2
# Set the path to your Excel file
file_path <- "C:/Users/Eduar/Downloads/SuicMort.xlsx"
# Read the Excel file into a data frame
SuicMort <- read_excel(file_path)
## New names:
## • `` -> `...2`
## • `` -> `...3`
## • `` -> `...4`
## • `` -> `...5`
## • `` -> `...6`
## • `` -> `...7`
## • `` -> `...8`
## • `` -> `...9`
## • `` -> `...10`
## • `` -> `...11`
## • `` -> `...12`
## • `` -> `...13`
## • `` -> `...14`
## • `` -> `...15`
## • `` -> `...16`
## • `` -> `...17`
## • `` -> `...18`
## • `` -> `...19`
## • `` -> `...20`
## • `` -> `...21`
## • `` -> `...22`
## • `` -> `...23`
## • `` -> `...24`
## • `` -> `...25`
## • `` -> `...26`
## • `` -> `...27`
## • `` -> `...28`
## • `` -> `...29`
## • `` -> `...30`
## • `` -> `...31`
## • `` -> `...32`
## • `` -> `...33`
## • `` -> `...34`
## • `` -> `...35`
## • `` -> `...36`
## • `` -> `...37`
## • `` -> `...38`
## • `` -> `...39`
## • `` -> `...40`
## • `` -> `...41`
## • `` -> `...42`
## • `` -> `...43`
## • `` -> `...44`
## • `` -> `...45`
## • `` -> `...46`
# Remover as 4 primeiras linhas do dataset
your_dataset2 <- SuicMort[-(1:3), ]
# Imprimir as 10 primeiras linhas do dataset em forma de tabela
kable(head(your_dataset2, 10), format = "html", row.names = TRUE )
|
|
Table SuicMort. Suicide rates, by sex, race, Hispanic origin, and age:
United States, selected years 1950–2019
|
…2
|
…3
|
…4
|
…5
|
…6
|
…7
|
…8
|
…9
|
…10
|
…11
|
…12
|
…13
|
…14
|
…15
|
…16
|
…17
|
…18
|
…19
|
…20
|
…21
|
…22
|
…23
|
…24
|
…25
|
…26
|
…27
|
…28
|
…29
|
…30
|
…31
|
…32
|
…33
|
…34
|
…35
|
…36
|
…37
|
…38
|
…39
|
…40
|
…41
|
…42
|
…43
|
…44
|
…45
|
…46
|
|
1
|
All people
|
Deaths per 100,000 resident population
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
2
|
All ages, age adjusted\4
|
13.2
|
12.5
|
13.1
|
12.2
|
12.3
|
12.5
|
12.4
|
12.6
|
12.5
|
13
|
12.8
|
12.5
|
12.3
|
12.5
|
12.3
|
12
|
12.1
|
11.9
|
11.8
|
11.5
|
11.2
|
11.1
|
10.5
|
10.4
|
10.7
|
10.9
|
10.8
|
11
|
10.9
|
11
|
11.3
|
11.6
|
11.8
|
12.1
|
12.3
|
12.6
|
12.6
|
13
|
13.3
|
13.5
|
14
|
|
14.2
|
|
13.9
|
|
3
|
All ages, crude
|
11.4
|
10.6
|
11.6
|
11.9
|
12
|
12.2
|
12.1
|
12.4
|
12.4
|
12.9
|
12.7
|
12.4
|
12.2
|
12.4
|
12.2
|
11.9
|
12
|
11.8
|
11.7
|
11.5
|
11.2
|
11.1
|
10.5
|
10.4
|
10.7
|
11
|
10.9
|
11.1
|
11
|
11.2
|
11.5
|
11.8
|
12
|
12.4
|
12.7
|
12.9
|
13
|
13.4
|
13.7
|
13.9
|
14.5
|
|
14.8
|
|
14.5
|
|
4
|
10–14 years
|
0.3
|
0.5
|
0.6
|
0.8
|
0.9
|
1.1000000000000001
|
1.1000000000000001
|
1.3
|
1.6
|
1.5
|
1.5
|
1.4
|
1.4
|
1.5
|
1.5
|
1.7
|
1.7
|
1.7
|
1.7
|
1.5
|
1.5
|
1.6
|
1.2
|
1.5
|
1.3
|
1.2
|
1.1000000000000001
|
1.3
|
1.3
|
1
|
0.9
|
1
|
1.3
|
1.3
|
1.4
|
1.5
|
1.9
|
2.1
|
2
|
2.1
|
2.5
|
|
2.9
|
|
2.6
|
|
5
|
15–24 years
|
4.5
|
5.2
|
8.8000000000000007
|
12.3
|
12.2
|
12.1
|
11.8
|
12.4
|
12.8
|
12.9
|
12.7
|
12.9
|
13
|
13.2
|
13
|
12.9
|
13.3
|
13.6
|
13
|
11.8
|
11.2
|
10.9
|
10.1
|
10.199999999999999
|
9.9
|
9.8000000000000007
|
9.6
|
10.3
|
9.9
|
9.8000000000000007
|
9.6
|
9.9
|
10
|
10.5
|
11
|
11.1
|
11.1
|
11.6
|
12.5
|
13.2
|
14.5
|
|
14.5
|
|
13.9
|
|
6
|
15–19 years
|
2.7
|
3.6
|
5.9
|
8.5
|
8.6
|
8.6999999999999993
|
8.6
|
8.9
|
9.9
|
10.1
|
10.199999999999999
|
11.1
|
11.1
|
11.1
|
11
|
10.7
|
10.8
|
10.9
|
10.3
|
9.6
|
9.3000000000000007
|
8.8000000000000007
|
8
|
8
|
7.9
|
7.3
|
7.2
|
8.1
|
7.5
|
7.1
|
6.7
|
7.2
|
7.5
|
7.5
|
8.3000000000000007
|
8.3000000000000007
|
8.3000000000000007
|
8.6999999999999993
|
9.8000000000000007
|
10
|
11.8
|
|
11.4
|
|
10.5
|
|
7
|
20–24 years
|
6.2
|
7.1
|
12.2
|
16.100000000000001
|
15.7
|
15.2
|
14.6
|
15.5
|
15.4
|
15.5
|
15
|
14.6
|
14.9
|
15.1
|
14.8
|
14.8
|
15.6
|
16.100000000000001
|
15.8
|
14.2
|
13.3
|
13.2
|
12.3
|
12.5
|
11.9
|
12.3
|
12.1
|
12.5
|
12.4
|
12.5
|
12.6
|
12.7
|
12.6
|
13.6
|
13.6
|
13.7
|
13.7
|
14.2
|
15.1
|
16.100000000000001
|
17
|
|
17.399999999999999
|
|
17.3
|
|
8
|
25–44 years
|
11.6
|
12.2
|
15.4
|
15.6
|
16.2
|
15.8
|
15.3
|
15.4
|
15
|
15.6
|
15.3
|
15.2
|
14.9
|
15.2
|
14.9
|
14.7
|
14.9
|
15.1
|
15.1
|
14.8
|
14.5
|
14.3
|
13.6
|
13.4
|
13.8
|
14.2
|
14
|
14.1
|
13.9
|
14
|
14.5
|
14.6
|
14.6
|
15
|
15.4
|
15.7
|
15.5
|
15.8
|
16.399999999999999
|
16.899999999999999
|
17.7
|
|
17.899999999999999
|
|
17.8
|
|
9
|
25–34 years
|
9.1
|
10
|
14.1
|
16
|
16.3
|
16
|
15.8
|
15.6
|
15.3
|
15.8
|
15.5
|
15.6
|
15.2
|
15.2
|
15.1
|
14.4
|
14.8
|
15
|
15
|
14
|
13.7
|
13.2
|
12.7
|
12
|
12.8
|
12.8
|
12.9
|
12.9
|
12.7
|
12.7
|
13.3
|
13.2
|
13.1
|
14
|
14.6
|
14.7
|
14.8
|
15.1
|
15.7
|
16.5
|
17.5
|
|
17.600000000000001
|
|
17.5
|
|
10
|
35–44 years
|
14.3
|
14.2
|
16.899999999999999
|
15.4
|
15.9
|
15.4
|
14.7
|
15.1
|
14.6
|
15.2
|
15
|
14.8
|
14.6
|
15.3
|
14.7
|
15
|
15.1
|
15.2
|
15.1
|
15.5
|
15.2
|
15.3
|
14.3
|
14.5
|
14.7
|
15.3
|
15
|
15.2
|
15.1
|
15.2
|
15.7
|
15.9
|
16.100000000000001
|
16
|
16.2
|
16.7
|
16.2
|
16.600000000000001
|
17.100000000000001
|
17.399999999999999
|
17.899999999999999
|
|
18.2
|
|
18.100000000000001
|