Unit 8 · Lesson 6
Build the idea
Start with the concept and its key vocabulary.
A 2D array is a table addressed with two indices. The first chooses a row and the second chooses a column. OCR writes table[row,column], while Python uses table[row][column]. Rows can represent records and columns fields. Use a nested loop to visit every cell: the outer loop selects each row and the inner loop selects each column. If every array value is stored as text, cast numeric fields before calculating.
An array of arrays arranged like a table with rows and columns.
A horizontal group in a table; it can represent one record.
A vertical group in a table; it can represent one field.
A group of related field values describing one entity.
One category of data within a record.