am_pivot_wider {africamonitor} | R Documentation |
Reshape Long API Data to Column-Based Format
Description
This function automatically reshapes long (stacked) raw data from the API (am_data(..., wide = FALSE)
) to a wide format where each variable has its own column.
It can also be used as a general purpose reshaping command - with an additional capability to handle variable labels.
Usage
am_pivot_wider(
data,
id_cols = intersect(c("ISO3", .AMT), names(data)),
names_from = "Series",
values_from = "Value",
labels_from = if (any(names(data) == "Label")) "Label" else NULL,
expand.date = FALSE,
...
)
Arguments
data |
raw data from the API: A long format data frame where all values are stacked in a value column. |
id_cols |
character. Temporal identifiers of the data. By default all variables in |
names_from |
character. The column containing the series codes. These will become the names of the new columns in the wider data format. |
values_from |
character. The column containing the data values. |
labels_from |
character. The column containing the labels describing the series. |
expand.date |
logical. |
... |
further arguments passed to |
Value
A data.table
with the reshaped data.
See Also
am_pivot_longer
, africamonitor
Examples
# Return all indicators for Kenya and Nigeria from the year 2000 onwards
am_pivot_wider(am_data(c("KEN", "NGA"), from = 2000, wide = FALSE))