| dateRefill.fromFileToExcel {tigerhitteR} | R Documentation |
Complete the hollow dataset
Description
Take time series dataset and fields, then refill the missing date records and other fields.
Usage
dateRefill.fromFileToExcel(inPath, sheet, dateCol.index, outPath,
fixedCol.index, uninterpolatedCol.index, uninterpolatedCol.newValue)
Arguments
inPath |
A path which is the location of uncompleted dataset which must be xlsx file |
sheet |
A worksheet name of the dataset |
dateCol.index |
Date column |
outPath |
A path where the location of xlsx file of completed dataset should be |
fixedCol.index |
A row of column number which should be kept same values with the original |
uninterpolatedCol.index |
The column number which should be changed to different value into new record. |
uninterpolatedCol.newValue |
The value of a specific column which should be put into the new record. |
Details
Real time series sales dataset could be not continuous in 'date' field. e.g., monthly sales data is continuous, but discrete in daily data.
This hollow dataset is not complete for time series analysis. Function dateRefill.fromFile is a transformation which tranforms uncomplete dataset into complete dataset.
Author(s)
Will Kuan
Examples
# Please refer to the examples of function dateRefill.fromData