Icon

netflix

Data Analysis Q3. Rating Distribution Movie Gener Q2. Is Netflix has increasingly focusing onTV rather than movies in recent years. Data Preparation - Generate Countrys table Data Preparation - Generate Ratings table Data Preparation - Generate Content types table Data Preparation - Generate Actors table Netflix Exploratory data analysis Data Blending - Combine Country& Content type (pivot) talbe Data Preparation - Handling missing values Data Preparation - Generate Directors table Statistic Section Q1. Top 30 Countries - most contents TV show Gener Q4. Movie duration distribution Q5. TV Show Season distribution Q7. Top 10 contents in TV Shows Q6. Top 10 contents in Movie load dataGroup by type, data addedbuild a visualization chart(Optional) Output result(Optional) Output result(Optional) Output result(Optional) Output resultcountriesratingscontent typesactorsJoin Two colsPivot the content tableUnpivot tableRemove empty rowdirectors(Optional) Output resultHandling missing valuesRemove the columns which contain 30% missing values (director)Show which columns contain missing valuesInspect the result after handling missing valuesPie chartUsing Python to findTop 30 countries producing most contentsVisualize the resultPie chartGroup by ratingsSelect Movie rows onlyvisualize the resultSort the table descSelect Movie rows onlyGroup by ratingsSort the table descvisualize the resultVisualize the resultSelect Movie rows onlyRemove 'min' induration colsConvert duration typefrom string to numericGroup by durationSelect TV Shows rows onlyGroup by seasonvisualize the resultsort by countSelect TV Shows rows onlyvisualize the resultUsing Python to findTop 10 contents in tv shows genervisualize the resultUsing Python to findTop 10 contents in tv shows generSelect Movie rows onlywrite the pivot format table in to csv fileRemove ? colread the post-pivot table ( I used python to fill out the cells)import data into Tableau for further visualizationExport data to local DBConnect to local DB CSV Reader GroupBy Tableau Writer Excel Writer Excel Writer Excel Writer Excel Writer GenerateCountries table GenerateRatings table Generate Contenttypes table GenerateActors table Joiner Pivoting Unpivoting Row Filter Generatedirectors table Excel Writer Missing Value Missing ValueColumn Filter Statistics Statistics Pie/Donut Chart Python Script Bar Chart Pie/Donut Chart GroupBy Row Filter Bar Chart Sorter Row Filter GroupBy Sorter Bar Chart Histogram Row Filter String Manipulation String To Number GroupBy Row Filter GroupBy Bar Chart Sorter Row Filter Bar Chart Python Script Bar Chart Python Script Row Filter CSV Writer Column Filter CSV Reader Tableau Writer DB Writer MySQL Connector Data Analysis Q3. Rating Distribution Movie Gener Q2. Is Netflix has increasingly focusing onTV rather than movies in recent years. Data Preparation - Generate Countrys table Data Preparation - Generate Ratings table Data Preparation - Generate Content types table Data Preparation - Generate Actors table Netflix Exploratory data analysis Data Blending - Combine Country& Content type (pivot) talbe Data Preparation - Handling missing values Data Preparation - Generate Directors table Statistic Section Q1. Top 30 Countries - most contents TV show Gener Q4. Movie duration distribution Q5. TV Show Season distribution Q7. Top 10 contents in TV Shows Q6. Top 10 contents in Movie load dataGroup by type, data addedbuild a visualization chart(Optional) Output result(Optional) Output result(Optional) Output result(Optional) Output resultcountriesratingscontent typesactorsJoin Two colsPivot the content tableUnpivot tableRemove empty rowdirectors(Optional) Output resultHandling missing valuesRemove the columns which contain 30% missing values (director)Show which columns contain missing valuesInspect the result after handling missing valuesPie chartUsing Python to findTop 30 countries producing most contentsVisualize the resultPie chartGroup by ratingsSelect Movie rows onlyvisualize the resultSort the table descSelect Movie rows onlyGroup by ratingsSort the table descvisualize the resultVisualize the resultSelect Movie rows onlyRemove 'min' induration colsConvert duration typefrom string to numericGroup by durationSelect TV Shows rows onlyGroup by seasonvisualize the resultsort by countSelect TV Shows rows onlyvisualize the resultUsing Python to findTop 10 contents in tv shows genervisualize the resultUsing Python to findTop 10 contents in tv shows generSelect Movie rows onlywrite the pivot format table in to csv fileRemove ? colread the post-pivot table ( I used python to fill out the cells)import data into Tableau for further visualizationExport data to local DBConnect to local DB CSV Reader GroupBy Tableau Writer Excel Writer Excel Writer Excel Writer Excel Writer GenerateCountries table GenerateRatings table Generate Contenttypes table GenerateActors table Joiner Pivoting Unpivoting Row Filter Generatedirectors table Excel Writer Missing Value Missing ValueColumn Filter Statistics Statistics Pie/Donut Chart Python Script Bar Chart Pie/Donut Chart GroupBy Row Filter Bar Chart Sorter Row Filter GroupBy Sorter Bar Chart Histogram Row Filter String Manipulation String To Number GroupBy Row Filter GroupBy Bar Chart Sorter Row Filter Bar Chart Python Script Bar Chart Python Script Row Filter CSV Writer Column Filter CSV Reader Tableau Writer DB Writer MySQL Connector

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: shih-tien
Created at: 2020-12-14
On NodePit since: 2020-12-30
Last update: 2024-11-23
Created with KNIME version: v4.3.0

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

Try NodePit Runner!