Tables
9
Create Tables and Assign Data to Them .......................
9-2
Add and Delete Table Rows ..................................
9-9
Add, Delete, and Rearrange Table Variables ...................
9-12
Clean Messy and Missing Data in Tables ......................
9-19
Modify Units, Descriptions, and Table Variable Names ..........
9-24
Add Custom Properties to Tables and Timetables ..............
9-27
Access Data in Tables .....................................
9-32
Summary of Table Indexing Syntaxes .......................
9-32
Tables Containing Specified Rows and Variables ...............
9-35
Extract Data Using Dot Notation and Logical Values ............
9-38
Dot Notation with Any Variable Name or Expression ............
9-40
Extract Data from Specified Rows and Variables ...............
9-42
Calculations on Tables ....................................
9-45
Split Data into Groups and Calculate Statistics ................
9-49
Split Table Data Variables and Apply Functions ................
9-52
Advantages of Using Tables ................................
9-56
Grouping Variables To Split Data ............................
9-61
Grouping Variables .....................................
9-61
Group Definition .......................................
9-61
The Split-Apply-Combine Workflow .........................
9-62
Missing Group Values ...................................
9-62
Changes to DimensionNames Property in R2016b ..............
9-64
Data Cleaning and Calculations in Tables .....................
9-66
Grouped Calculations in Tables and Timetables ................
9-86
Timetables
10
Create Timetables ........................................
10-2
Resample and Aggregate Data in Timetable ...................
10-5
Combine Timetables and Synchronize Their Data ..............
10-8
xi