What is Sentimental Analysis ?

Sentiment Analysis is the method of analysis to determine whether a piece of information is positive, negative or neutral.

Step-1 Connectivity between Python and Tableau

• Install Anaconda software for your respective environment
• Open Anaconda Navigator & install Tabpy-Server & Tabpy-Client packages
• Go to respective location  where your Tabpy packages installed  For Example C:\Users\..\Anaconda3\Lib\site-packages\tabpy_server to run startup.bat file

Default port will listen on 9004

For more detail to integration between Tableau and Python . Please read blog http://www.bituskers.com/python-integration-with-tableau/

Step-2 Now Open Tableau Software and Click on Help -> Setting and Performance ->  Manage External Service Connection.

Click on “Test Connection” button to  check service between Python & Tableau. If successful message prompt then we have done connectivity successfully.

What is Vader Sentimental Analysis?

Vader is a lexicon and rule-based sentiment analysis tool that is specifically attuned to sentiments expressed in social media.

Step-3 Do install package “vaderSentiment” in Python Environment. Below is command.

pip install vaderSentiment

Step-4 Open Tableau Software and Connect respected data source. for example “Microsoft Excel”. After connected to datasource follow below step.

Step-5 Create calculation field in Tableau and give it name “Sentimental”

Create another calculation field to give it name “Color”. To check whether review is Positive, Neutral or Negative based on condition.

Step-6 Put the dimension and calculation fields in Column and Row Shelf as well in Mark shelf as per below screenshot.