Code-Document Table

You can use the Code-Document Table for within and across documents or group comparisons by relating codes or code groups and documents or document groups to each other.

The table cells contain:

  • frequency count of the number of codings. This can be different from the number of quotations, if a quotation is coded by multiple codes. Counted is each link between a code and a quotation.

  • word count of the quotations coded by the selected code or code group.

Running an Analysis in the Code-Document Table

From the main menu select Analysis > Code-Document Table.

Select codes or code groups for the table rows. The selected codes / code groups are added to the table.

Select documents or document groups for the table columns. The selected documents / document groups are added to the table.

How to make selections: To select an item, you need to click the check-box in front of it. It is also possible to select multiple items via the standard selection techniques using the Ctrl/Cmd or Shift-key. After highlighting multiple items, push the space bar to activate the checkboxes of all selected items, or right click and chose Check Selected.

Example Code-Document Table

How to read the table

By default, the codes / code groups are displayed in the left column, and the documents / document groups in the top row.

Left column

  • Next to each code, the number indicates how often the code is applied in the entire project.

  • Next to a code group, you see two numbers: The first one tells you how many codes are in the group, the second numbers gives you the number of codings. This is different from the number of quotations, as multiple codes from the same code group could be linked to the same quotation.

Top row

  • Below a document, you see the total number of quotations in each document.

  • Below a document group, you see two numbers: the first one tells you how many documents are in the document group, and the second number gives you the number of quotations for all documents in the group.

The additional information you get for each selected row or column item allows you to better evaluate the numbers inside the table cells. If the value in the table cell is 10, but the code overall was applied 100 times, this leads to a different interpretation as if the code was only applied 12 times in the entire project.

Table cells

  • The results in the table cells show how often each selected code was (or the codes of a code group were) applied in each document or document group. Counted are the number of codings, unless you select to count words (see options).

  • If you click on a cell in the table, the quotation content is shown in the Quotation Reader on the left-hand side.

  • Below the table a Sankey Diagram is shown. You can see both at the same time, or view either the table or the Sankey Diagram. See below.

Code-Document Table Toolbar

Code Document Table - Toolbar

Compress: This is a quick way to remove all rows or columns that only show empty cells. This is the same as manually deactivating codes or documents that yield no results. Thus, you cannot decompress a table.

Options: See below.

Export: You can export the table as Excel spreadsheet, and the Sankey diagram as image in png format.

Code Document Table - Export

Code-Document Table Options

Click on the options button to open the option pane.

Code-Document Table options

Headers: You can hide the additional information about number of quotations per code or document / number of members in a group you see in the table headers.

Include: Display/hide the row or column totals.

Show frequencies: You can display absolute frequencies, row / column / or table relative frequencies.

Absolute Frequencies: The table cells show the number of codings. This is the number of times a code is linked to a quotation. For single codes the number of codings is the same as the number of quotations, but for code groups it can differ if codes that are in the same code group have been applied to the same quotation.

Relative Frequencies:

  • Column Rel.-Frequencies: The table cells show relative frequencies based on the column cells. The total of each column will add up to 100%.

  • Row Rel.-Frequencies: The table cells show relative frequencies based on the row cells. The total of each row will add up to 100%.

  • Table Rel.-Frequencies: Display relative frequencies based on all codes used in the table. The totals of all row and column codes will add up to 100%.

  • Count: You can select to count the number of codings, or the number of words of the quotations.

  • Count Codings: Count the number of times a code has been applied to a quotation. Please note, the number of codings can be higher than the number of quotations if code groups are used as you can apply multiple codes to one quotation.

  • Count Words: Count the words of the quotations coded by the selected code, or the codes of the selected code group.

Normalize: If documents are of unequal length, or document groups of unequal size, the absolute frequencies might be misleading as a measure of comparison. Indicative are the total number of quotations in a document or document group (see top row).

If you normalize the data the number of codings are adjusted. As benchmark, the document / document group column or row with the highest total is used. For example, if you compare two documents, and the total number of codings for the first document is 100 and for the second document it is 50, then all codings of the second document are multiplied by 100/50 = 2. See Normalizing Data.

Binarize Table: This option reduces all cell values to 0 and 1. It shows whether a code, or codes of a code group, occur or do not occur in a document, or a document group. If they occur a black dot is shown; if not, the cell is empty. This makes it easier to identify a pattern in the data.

When you export the table to Excel, the dots are turned into 1s and the empty cells into 0s. This allows, for example, a discriminant analysis to be carried out in a statistical program. See Binarize Table.

Orientation: Change rows and columns.

Code-Document Table Layout Options

Code Document Table - Sankey Diagram View

If you need more space on your screen, you can hide the two lists on the right- and left-hand side (scope and quotations).

If you want more room for the visualizations, you can hide the table.

The table visualization is available as Sankey diagram or barchart. Below you see an example of a Sankey diagram in dark mode.

Code Document Table - Sankey Diagram View