# 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