Data Visualisation

Data Transformation

Data Transformation With data manipulation

Data Cleaning

Data Dictionary and

Number of Rows & columns

Exploratory Data Analysis

Converting Revenue/Revenues_adj and Budget/Budget_adj < 1000 to null value and after Null value to median for the analysis

Data transformation with no data manipulation

Data Loading

I have decided to keep the homepage column for now, even though it’s full of missing values. Usually, we just delete a column with that many missing values, but since the dataset isn't huge, it’s not hurting anything to keep it. I used the Missing Value node to swap the blanks for 'N/A' so the data stays clean. The reason is that if we ever do an AI project later, we could actually use those links for web scraping to grab more info. If it turns out we don't need it for the AI down the road, we can just drop it then.

For the String values, I converted the missing data into 'N/A' and 'Unknown'

NoData Manipulation

TMDB Movies Data Analysis