parse_multiple_session_databases: Load multiple FFP session databases

In caldwellst/fightr: Tools for Fight for Peace Data

Description

parse_multiple_session_databases() loads in multiple Excel files containing data exported from the FFP session database and combines them together. This can be used to combine databases from different country offices or even from different years. Where there are overlapping attendee_id rows from multiple databases (such as data from multiple years), the data are automatically combined. Total columns are summed, first session is the earliest, latest session the latest, and other columns take the observation from the last database provided in the paths variable.

Usage

parse_multiple_session_databases(paths)

Arguments

paths

File paths to FFP databases

Value

List with three named components:

sessions: data frame of session information
attendance: data frame of attendee and session attended
attendees: data frame of attendee details

caldwellst/fightr documentation built on July 4, 2021, 8:50 a.m.