Icon

TV_​Series_​Analytics_​Q3&4

Access Questions: English US/UK/AU/CA Series Only1) How many seasons is too many?2) What are the most important factors in a show's (series) success?3) How long are viewers willing to wait between seasons? <- run clustering to find similarshows (exclude time)4) What is the relation between the number of directors and the success of a show (series)?(hypothesis test) (is correlation significant? 95% confidence) (verify assumption that there is nocorrelation between popular actors and # of directors via logistic regression model)5) Most popular series actor (based on appearances and ratings)6) WHERE DO WE START???? Cleaning Transforming Question 3 Question 4 PeopleRegionGeneral InfoDirectors & WritersAll staffRating & PopularityFilter RegionsFilter TypeEnglish TV Series w/o Series DataSeries & EpisodesEnglish TV Series w/ Series DataNode 17Series w/ 2+ seasonsNode 19Node 20Node 21Node 23Node 25Node 27Node 28Node 29Node 30Node 31Node 32Node 33Node 34English TV Series w/ Director Data# Directors & RatingsEnglish TV Series w/ Director Data & RatingsNode 39Node 40Linear Regression ResultsCorr MeasureCorr MatrixNode 44Drop > 10 DirectorsNode 47Node 48Node 49Director(s) by Ratings CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader Row Filter Row Filter Joiner CSV Reader Joiner GroupBy Row Filter Joiner Cell Splitter One to Many k-Means Scatter Plot Joiner Math Formula String to Number Linear RegressionLearner Line Plot Linear Correlation Line Plot Linear Correlation Joiner String Manipulation Joiner Linear RegressionLearner Linear Correlation Data toReport (BIRT) Data toReport (BIRT) Data toReport (BIRT) Statistics View Row Filter Column Filter GroupBy Sorter Data toReport (BIRT) Access Questions: English US/UK/AU/CA Series Only1) How many seasons is too many?2) What are the most important factors in a show's (series) success?3) How long are viewers willing to wait between seasons? <- run clustering to find similarshows (exclude time)4) What is the relation between the number of directors and the success of a show (series)?(hypothesis test) (is correlation significant? 95% confidence) (verify assumption that there is nocorrelation between popular actors and # of directors via logistic regression model)5) Most popular series actor (based on appearances and ratings)6) WHERE DO WE START???? Cleaning Transforming Question 3 Question 4 PeopleRegionGeneral InfoDirectors & WritersAll staffRating & PopularityFilter RegionsFilter TypeEnglish TV Series w/o Series DataSeries & EpisodesEnglish TV Series w/ Series DataNode 17Series w/ 2+ seasonsNode 19Node 20Node 21Node 23Node 25Node 27Node 28Node 29Node 30Node 31Node 32Node 33Node 34English TV Series w/ Director Data# Directors & RatingsEnglish TV Series w/ Director Data & RatingsNode 39Node 40Linear Regression ResultsCorr MeasureCorr MatrixNode 44Drop > 10 DirectorsNode 47Node 48Node 49Director(s) by RatingsCSV Reader CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader Row Filter Row Filter Joiner CSV Reader Joiner GroupBy Row Filter Joiner Cell Splitter One to Many k-Means Scatter Plot Joiner Math Formula String to Number Linear RegressionLearner Line Plot Linear Correlation Line Plot Linear Correlation Joiner String Manipulation Joiner Linear RegressionLearner Linear Correlation Data toReport (BIRT) Data toReport (BIRT) Data toReport (BIRT) Statistics View Row Filter Column Filter GroupBy Sorter Data toReport (BIRT)

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: tyler
Created at: 2024-10-23
On NodePit since: 2024-12-04
Last update: 2024-12-17
Created with KNIME version: v5.3.3

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

Try NodePit Runner!