How to Compare Sentiment by Entities in Text Data

This article describes how to create an entity list from open-ended text data:

and sentiment scores calculated from an open-end text variable:

And crosstab them to see sentiment scores by saved categories from an entity list:

Requirements

You will need at least two Text variables in order to perform automatic coding. Text variables are represented by a small a next to the variable and can be found in the Data Set tree:

One text variable should be suitable for creating any entity list and another text variable to calculate sentiment.

Method

Step 1 - create an entity list

1. Go to Anything > Advanced Analysis > Text Analysis > Automatic Categorization > Entity Extraction.
2. In the object inspector, under Inputs > DATA SOURCE > Text variable select the text variable you want to automatically code into an entity list.
3. From Inputs > SAVE VARIABLE(S), click Categories, and a new variable will be inserted into your Data Sets tree.

NOTE: The variables created from this using SAVE VARIABLE(S) > Categories may become invalid and need to be deleted and recreated if the output has changed, either due to the input text variable being modified or the input settings modified.

Step 2 - calculate sentiment

1. Select the text variable from the Data Sets tree.
2. Go to Anything > Advanced Analysis > Text Analysis > Sentiment.
3. A new variable with a Numeric structure will appear in your Data Sets tree that represents the sentiment score.

Step 3 - compare sentiment by entities

1. Create a crosstab by dragging the entity list categories variable from Step 1 above onto a Page.
2. Drag the sentiment score variable that was calculated in Step 2 above into the Columns of the crosstab table.

Next

How to Calculate Sentiment Scores for Open-Ended Responses

How To Automatically Code Unstructured Text Data Into an Entity List