Netflix Data: Cleaning, Analysis And Visualization

Cleaning and Visualization with Pgsql and Tableau

@kaggle.ariyoomotade_netflix_data_cleaning_analysis_and_visualization

Table List

1 table(359.19 KB)

Netflix1

@kaggle.ariyoomotade_netflix_data_cleaning_analysis_and_visualization.netflix1

359.19 KB
8790 rows
10 columns

show_id Show Id	type Type	title Title	director Director	country Country	date_added Date Added	release_year Release Year	rating Rating	duration Duration	listed_in Listed In
s1	Movie	Dick Johnson Is Dead	Kirsten Johnson	United States	Sat Sep 25 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	PG-13	90 min	Documentaries
s3	TV Show	Ganglands	Julien Leclercq	France	Fri Sep 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	TV-MA	1 Season	Crime TV Shows, International TV Shows, TV Action & Adventure
s6	TV Show	Midnight Mass	Mike Flanagan	United States	Fri Sep 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	TV-MA	1 Season	TV Dramas, TV Horror, TV Mysteries
s14	Movie	Confessions of an Invisible Girl	Bruno Garotti	Brazil	Wed Sep 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	TV-PG	91 min	Children & Family Movies, Comedies
s8	Movie	Sankofa	Haile Gerima	United States	Fri Sep 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1993	TV-MA	125 min	Dramas, Independent Movies, International Movies
s9	TV Show	The Great British Baking Show	Andy Devonshire	United Kingdom	Fri Sep 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	TV-14	9 Seasons	British TV Shows, Reality TV
s10	Movie	The Starling	Theodore Melfi	United States	Fri Sep 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	PG-13	104 min	Comedies, Dramas
s939	Movie	Motu Patlu in the Game of Zones	Suhas Kadav	India	Sat May 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2019	TV-Y7	87 min	Children & Family Movies, Comedies, Music & Musicals
s13	Movie	Je Suis Karl	Christian Schwochow	Germany	Thu Sep 23 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	TV-MA	127 min	Dramas, International Movies
s940	Movie	Motu Patlu in Wonderland	Suhas Kadav	India	Sat May 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2013	TV-Y7	76 min	Children & Family Movies, Music & Musicals


CREATE TABLE netflix1 (
  "show_id" VARCHAR,
  "type" VARCHAR,
  "title" VARCHAR,
  "director" VARCHAR,
  "country" VARCHAR,
  "date_added" TIMESTAMP,
  "release_year" BIGINT,
  "rating" VARCHAR,
  "duration" VARCHAR,
  "listed_in" VARCHAR
);