Main Content

Common Operations with Timetables for Finance

Clean data, resample and aggregate data, combine timetables and synchronize dates

Functions

expand all

ismissingFind missing values
rmmissingRemove missing entries
fillmissingFill missing values
sortrowsSort rows of matrix or table
retimeResample or aggregate data in timetable, and resolve duplicate or irregular times
retimeResample or aggregate data in timetable, and resolve duplicate or irregular times
convert2dailyAggregate timetable data to daily periodicity
convert2weeklyAggregate timetable data to weekly periodicity
convert2monthlyAggregate timetable data to monthly periodicity
convert2quarterlyAggregate timetable data to quarterly periodicity
convert2semiannualAggregate timetable data to semiannual periodicity
convert2annualAggregate timetable data to annual periodicity
synchronizeSynchronize timetables to common time vector, and resample or aggregate data from input timetables
horzcatConcatenate arrays horizontally
vertcatConcatenate arrays vertically
summaryPrint summary of table, timetable, or categorical array
timerangeTime range for timetable row subscripting
vartypeSubscript into table or timetable by variable type
withtolTime tolerance for timetable row subscripting
rowfunApply function to table or timetable rows
splitapplySplit data into groups and apply function
findgroupsFind groups and return group numbers

Examples and How To

Concepts