Icon

JKISeason2-20_​sryu

Challenge 20: Topics in Hotel Reviews
Level: Hard

Description: You work for a travel agency and want to better understand how hotels are reviewed online. What topics are common in the reviews as a whole, and what terms are most relevant in each topic? How about when you separate the reviews per rating? A colleague has already crawled and preprocessed the reviews for you, so your job now is to identify relevant topics in the reviews, and explore their key terms. What do the reviews uncover? Hint: Topic Extraction can be very helpful in tackling this challenge. Hint 2: Coherence and perplexity are metrics that can help you pick a meaningful number of topics.

DataTag: TermSize : WeightUse row color propertyTopic IDTopicIDRating (Mean)Topic IDNode 51TopicIDNode 53Node 58RatingAnalysis view in the wholeTag: TermSize : WeightUse row color propertyTo unify the color of the same term across TopicsRatingColor managerColor managerTo unify the color of the same term across TopicsAnalysis view per ratingTable Reader Topic Extractor(Parallel LDA) Tag Cloud Group Loop Start Image To Table ConstantValue Column Loop End GroupBy Joiner Round Double Topic Extractor(Parallel LDA) Group Loop Start Image To Table ConstantValue Column Loop End Group Loop Start ConstantValue Column Loop End Component Tag Cloud Color Appender ConstantValue Column Metanode Metanode Color Appender Component DataTag: TermSize : WeightUse row color propertyTopic IDTopicIDRating (Mean)Topic IDNode 51TopicIDNode 53Node 58RatingAnalysis view in the wholeTag: TermSize : WeightUse row color propertyTo unify the color of the same term across TopicsRatingColor managerColor managerTo unify the color of the same term across TopicsAnalysis view per ratingTable Reader Topic Extractor(Parallel LDA) Tag Cloud Group Loop Start Image To Table ConstantValue Column Loop End GroupBy Joiner Round Double Topic Extractor(Parallel LDA) Group Loop Start Image To Table ConstantValue Column Loop End Group Loop Start ConstantValue Column Loop End Component Tag Cloud Color Appender ConstantValue Column Metanode Metanode Color Appender Component

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: sryus
Created at: 2023-08-11
On NodePit since: 2023-08-11
Last update: 2024-04-27
Created with KNIME version: v4.7.4
Tags: JKISeason2-20

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!