Main Content

Common Operations with Timetables for Finance

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

Use functions for common operations with timetables to clean, aggregate, and synchronize financial data.

Functions

expand all

ismissingFind missing values
rmmissingRemove missing entries
fillmissingFill missing entries
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 (Since R2021a)
convert2weeklyAggregate timetable data to weekly periodicity (Since R2021a)
convert2monthlyAggregate timetable data to monthly periodicity (Since R2021a)
convert2quarterlyAggregate timetable data to quarterly periodicity (Since R2021a)
convert2semiannualAggregate timetable data to semiannual periodicity (Since R2021a)
convert2annualAggregate timetable data to annual periodicity (Since R2021a)
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

Topics