excessmort (version 0.8.2)

compute_counts: Compute counts

Description

Compute counts for groups from individual records

Usage

compute_counts(
  dat,
  by = NULL,
  demo = NULL,
  date = "date",
  age = "age",
  agegroup = "agegroup",
  breaks = NULL
)

Value

A data frame with counts for each group for each date with population sizes, if demo was provided.

Arguments

dat

The data frame with the individual records

by

A character vector with the column names the define the groups for which we will compute counts

demo

A data frame with population sizes for each time point for each of the groups for which we will compute counts

date

The column name of the column that contains dates

age

The column name of the column that contains age

agegroup

The column name of the column that contains agegroup

breaks

The ages that define the agegroups

Details

This is helper function that helps convert individual records data, in which each death is a row, to a count data frame where each row is a date. It is particulalry helpful for defining agegroups. If you provide the `breaks` argument it will automaticall divided the data and provide the counts for each age strata. You can also select variables to group by using the `by` argument. One can provide a data frame with demogrpahic inform through the `demo` argument. This tabe must have the population size for each group for each data.

Examples

library(lubridate)
data("cook_records")
the_breaks <- c(0, 20, 40, 60, 75, Inf)

## take subset for example
cook_records_subset <- cook_records[year(cook_records$date)==2021, ]
cook_demographics_subset <- cook_demographics[year(cook_demographics$date)==2021, ]

cook_counts <- compute_counts(cook_records_subset, 
                       demo = cook_demographics_subset, 
                       by = c("agegroup", "race", "sex"), 
                       breaks = the_breaks)