Icon

FINALPROJECT11

Data Import/Exploration

EDA before cleaning the data

DATA CLEANING/FILTERING

DATA TRANSFORMATION

Data Analysis : Exploratory analysis that will helps us understand the behavior of variables and to detect any anomalies

Data Visualization

Importing the tmdb movie data file
CSV Reader
Filtering out unwanted columns like homepage
Column Filter
Movie and its revenue
Bar Chart
Handling the missing values, Integer with mean, String with removing the row, Float with mean, long integer with float, Date with removing the whole row
Missing Value
Changing date which was in string to the date format
String to Date&Time
3. Histogram view: to know whether it’s a normal curve or not
Histogram
Filtering out all the unwanted rows
Duplicate Row Filter
converting string to number
String to Number
Categorizing movies into Great / Good / Not Bad ones
Rule Engine
Original_title and director
Heatmap
Statistics view of the table for exploratory data analysis, to also view histogram and find out whether there is a normal curve or not
Statistics
Calculated profit (Revenue - Budget) New column = profit
Math Formula
Statistics view for the data analysis after data cleaning and transformation, adding of new columns
Statistics
Variable like budget contain zero , can suggest absence of value , created a new column called budget_append
Rule Engine
Histogram analysis for different columns
Histogram
Bar chart view which shows profit on the y axis and original title on the x axis
Bar Chart
EDA
Statistics
Calculated profit_adj (revenue_adj - budget_adj) New column = profit_adj
Math Formula
filtering out unwanted columns like keywords
Column Filter
Grouping profit and original_title for further visualization
GroupBy

Nodes

Extensions

Links