Icon

JKISeason2-20_​tark

JKISeason2-20

JKISeason2-20
https://www.knime.com/just-knime-it

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.

Author: Aline Bessa

Dataset: Hotel Reviews Data in the KNIME Hub

This workflow was created with reference to the following.Learn the Elbow Method to Optimize Topic Extractionhttps://www.knime.com/blog/topic-extraction-optimizing-the-number-of-topics-with-the-elbow-method 2-gram 1-gram Node 1Extract topics fromdocumentsTopic idNode 763Node 765Node 766Node 779Node 785Node 786Node 787Node 788Topic idExtract topics fromdocumentsRatingNode 793Node 796Node 797Node 798Node 799Topic idComputeoptimal no. of topicsExtract topics fromdocumentsNode 805Node 806Node 807Node 808Node 810RatingExtract topics fromdocumentsTopic idComputeoptimal no. of topicsComputeoptimal no. of topicsComputeoptimal no. of topicsTable Reader Topic Extractor(Parallel LDA) N-grams Group Loop Start Image To Table Variable to TableColumn (deprecated) Tag Cloud Partitioning Loop End(deprecated) Loop End(deprecated) Tag Cloud Variable to TableColumn (deprecated) Image To Table Group Loop Start Topic Extractor(Parallel LDA) Group Loop Start Loop End Loop End(deprecated) Tag Cloud Variable to TableColumn (deprecated) Image To Table Group Loop Start Metanode Topic Extractor(Parallel LDA) Image To Table Variable to TableColumn (deprecated) Tag Cloud Loop End(deprecated) Loop End Group Loop Start Topic Extractor(Parallel LDA) Group Loop Start Metanode Metanode Metanode Component Component This workflow was created with reference to the following.Learn the Elbow Method to Optimize Topic Extractionhttps://www.knime.com/blog/topic-extraction-optimizing-the-number-of-topics-with-the-elbow-method 2-gram 1-gram Node 1Extract topics fromdocumentsTopic idNode 763Node 765Node 766Node 779Node 785Node 786Node 787Node 788Topic idExtract topics fromdocumentsRatingNode 793Node 796Node 797Node 798Node 799Topic idComputeoptimal no. of topicsExtract topics fromdocumentsNode 805Node 806Node 807Node 808Node 810RatingExtract topics fromdocumentsTopic idComputeoptimal no. of topicsComputeoptimal no. of topicsComputeoptimal no. of topicsTable Reader Topic Extractor(Parallel LDA) N-grams Group Loop Start Image To Table Variable to TableColumn (deprecated) Tag Cloud Partitioning Loop End(deprecated) Loop End(deprecated) Tag Cloud Variable to TableColumn (deprecated) Image To Table Group Loop Start Topic Extractor(Parallel LDA) Group Loop Start Loop End Loop End(deprecated) Tag Cloud Variable to TableColumn (deprecated) Image To Table Group Loop Start Metanode Topic Extractor(Parallel LDA) Image To Table Variable to TableColumn (deprecated) Tag Cloud Loop End(deprecated) Loop End Group Loop Start Topic Extractor(Parallel LDA) Group Loop Start Metanode Metanode Metanode Component 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: TA
Created at: 2023-08-14
On NodePit since: 2023-08-15
Last update: 2024-11-21
Created with KNIME version: v4.7.6
Tags: JKISeason2-20Just KNIME It

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

Try NodePit Runner!