Icon

DataPreparation-project

Data Cleaning

Data Transformation

EDA

Data Analysis

Data Analysis

runtime
Rule Engine
budget
Histogram
Statistics
revenue
Histogram
Statistics
budget_adj<=>revenue_adj
Scatter Plot
String to Number
vote_avg<=>popularity
Scatter Plot
String to Number
NBr of films per year
GroupBy
revenue_adj
Rule Engine
Nbrof films per year
Bar Chart
remplacer la fin de tagline au lieu de "." par rien
String Manipulation
remove list column
Column Filter
convert id etreleasr_year en int
Double to Integer
count nbr campanies
Row Aggregator
for outliers de runtime et vote_average
Rule Engine
release_date format
String to Date&Time
TABLE MOVIES
Column Filter
supprimer les " . " et les espaces de cast
String Manipulation
Table Transposer
Cell Splitter
runtime_<5%,budget,revenue_adj_ =>median
Missing Value
Table Genres
Column Filter
CSV Reader
Statistics View
Missing Value
I used 'id' Garantir qu’un film n’apparaît qu’une seule fois.
Duplicate Row Filter
replace 0 dans budget a " unknown " et creer un nvl colonne budget_clean
Rule Engine
same thing , with budget_adj
Rule Engine
top 10 profit
Top k Row Filter
top 10 profit moovies
Bar Chart
top 10 campanies
Top k Row Filter
0/1
One to Many
Value Counter
Table PRODUCTION_COMPANIES
Column Filter
Top k Row Filter
Ungroup
Profit
Math Formula
GroupBy
top 10 genres
Bar Chart
Table View
Cell Splitter
Profit<->revnue_adj
Scatter Plot
vote_count<->Profit
Scatter Plot
id
Number to String
One to Many
detect nbr ofmissing values
Statistics
Domain Calculator
Excel Writer
Ungroup
RowID
trim(),supprime espace en debut et fin
String Manipulation
top 10 companies
Bar Chart
same thing avec 'revenue'
Rule Engine
String to Number
Statistics
Statistics
runtime<->revenue
Scatter Plot
String to Number
CSV Writer
RowID
Statistics
CSV Writer
String to Number

Nodes

Extensions

Links