Dataframe structure & Vocabulary

Structure: Comlumns, rows and properties

     Key       Column      Column
      ↓           ↓           ↓
+-----------+----------+--------------+
| RecordKey | Composer | Nationality  |
+-----------+----------+--------------+
|     0     | property |   property   | ← Record
+-----------+----------+--------------+
|     1     | property |   property   | ← Record
+-----------+----------+--------------+

• A Record is similar to a row in a spreadsheet.

  • A Record can contain from none (empty record) to several Columns.
  • The default behavior of API is to return no entry for non-existent columns in the Record. But options allow you to virtually return a NULL value if necessary.
  • Each record has a unique key. Generated on the Woolly side (more specifically by the data-driver used). Currently only integer are supported. The default driver (PhpArray) index key from 0.
  • Each record property contain a value if exist for the record, each property match an existing Column.

• A Column represents properties common to several records, and is similar to a column in a spreadsheet.

  • Columns can be added manually or dynamically (a new Record can contains a new column) at any time.
  • Columns are represented to the user by case-sensitive string names.