expenditures: Providing expenditures of sold products

View source: R/f_data_processing.R

expendituresR Documentation

Providing expenditures of sold products

Description

The function returns expenditures of sold products with given IDs.

Usage

expenditures(data, period, set = c(), ID = FALSE)

Arguments

data

The user's data frame. It must contain columns: time (as Date in format: year-month-day, e.g. '2020-12-01'), quantities (as positive numeric) and prodID (as numeric, factor or character) with unique product IDs.

period

The time period (as character) limited to the year and month, e.g. "2019-03".

set

The set of unique product IDs to be used for determining expenditures of sold products (see also data_matching). If the set is empty, the function returns quantities of all products being available in period.

ID

A logical parameter indicating whether a data frame with prodIDs and quantities should be returned.

Value

The function analyzes the user's data frame and returns expenditures of products with given ID and being sold in the time period indicated by the period parameter. Please note that the function returns the expenditure values for sorted prodIDs and in the absence of a given prodID in the data set, the function returns nothing (it does not return zero). If the ID parameter is set to TRUE then the function returns a data frame with columns: by (IDs of products) and expend (expenditures of products).

Examples

expenditures(milk, period="2019-06")
expenditures(milk, period="2019-12", set=c(400032, 82919), ID=TRUE)

PriceIndices documentation built on July 9, 2023, 6:20 p.m.