All basic table functions

[apjanke]

This is a list of all the functions/methods we need to implement for basic Matlab-compatible table functionality.

I'll give these a check mark when the “basic” functionality is implemented, even if not all options are supported. At that point, the options for that function should get its own issue to track it.

Construction/Conversion

• table
• array2table
• cell2table
• struct2table
• table2array – N-dimensional non-matrix variable value support #21
• table2cell
• table2struct
• table2timetable – timetable class #7, datetime support #27
• timetable2table – timetable class #7, datetime support #27

I/O - #49

Split out to other ticket #49 Table file I/O.

• readtable – datetime support #27, Table file I/O #49
• writetable – datetime support #27, Table file I/O #49
• detectImportOptions – Table file I/O #49
• getvaropts – Table file I/O #49
• setvaropts – Table file I/O #49
• setvartype – datetime support #27, Table file I/O #49

Summary Info

• head
• tail
• summary – Summary data display #26, datetime support #27
• height
• width
• istable
• stackedplot

Sort/Rearrange

Sort

• sortrows – sortrows harmonization with Octave negative-index inputs #12
• unique
• issortedrows
• topkrows

Rearrange

• addvars
• movevars
• removevars
• convertvars
• splitvars – Nested table support #22
• mergevars – Nested table support #22
• vartype – vartype #25

Reshape

• rows2vars
• stack
• unstack
• inner2outer

Relational

• join – Basic/default behavior is done, but no options supported, and there are a lot of significant options here.
• innerjoin – What's the difference between Matlab table’s join() and innerjoin()? #16
• outerjoin – This is going to be a hard one, because we have to determine fill values for arbitrary types in a polymorphic manner.
• union
• intersect
• ismember
• setdiff
• setxor

Relational (Octave/Janke extensions)

• realjoin – Degenerate natural realjoin should be Cartesian product #14
• semijoin – Degenerate natural semijoin and antijoin should produce output instead of error #13
• semidiff aka antijoin – Degenerate natural semijoin and antijoin should produce output instead of error #13, Maybe remove semidiff #29
• cartesian

Missing values - #17

• ismissing – “missing” value indicator semantics #17
• standardizeMissing – “missing” value indicator semantics #17
• rmmissing – “missing” value indicator semantics #17
• fillmissing

Function application

• varfun – Group detection logic #19
• rowfun –Group detection logic #19
• findgroups
• splitapply – Group detection logic #19
• groupsummary – Group detection logic #19
• grpstats

Customize

• addprop
• rmprop

Function application (Octave/Janke extensions)

• evalWithVars
• restrict (with eval string input support)
• groupby – Janke's preferred interface for doing group & aggregate operations.

[apjanke]

I removed the checkboxes for the Table I/O stuff so they don't show up in the "m/n tasks complete" for this ticket, because that's being handled under separate ticket #49.