Published
Edited
Mar 18, 2021
file = FileAttachment('Netflix_movies_new.csv')
movies = file.text()
moviesArray = d3.csvParse(movies, d3.autoType)
min_Duration = d3.min(moviesArray, d => d.duration)
max_Duration = d3.max(moviesArray, d => d.duration)
oldest_production_year = d3.min(moviesArray, d => d.year)
newest_production_year = d3.max(moviesArray, d => d.year)
min_Rating = d3.min(moviesArray, d => d.rating)
max_Rating = d3.max(moviesArray, d => d.rating)
oldest_enter_in_netflix = d3.min(moviesArray, d => d.enter_in_netflix)
newest_enter_in_netflix = d3.max(moviesArray, d => d.enter_in_netflix)
sum_Duration = d3.sum(moviesArray, d => d.duration)
sum_Rating = d3.sum(moviesArray, d => d.rating)
vegalite({
"data": {
"values": moviesArray
},
"mark": "bar",
"width": "600",
"encoding": {
"x": {
"bin": {"maxbins": 40},
"field": "duration",
"type": "quantitative"
},
"y": {
"aggregate": "count",
"type": "quantitative"
}
}
})
average_Duration = d3.median(moviesArray, d => d.duration)
vegalite({
"data": {
"values": moviesArray
},
"mark": "bar",
"width": "600",
"encoding": {
"x": {
"bin": {"maxbins": 20},
"field": "year",
"type": "ordinal"
},
"y": {
"aggregate": "count",
"type": "quantitative"
}
}
})
average_YearofProduction = d3.median(moviesArray, d => d.year)
vegalite({
"data": {
"values": moviesArray
},
"mark": "bar",
"width": "600",
"encoding": {
"x": {
"bin": {"maxbins": 20},
"field": "rating",
"type": "quantitative"
},
"y": {
"aggregate": "count",
"type": "quantitative"
}
}
})
average_Rating = d3.median(moviesArray, d => d.rating)
duration_less_than_100min = moviesArray.filter(d => (d.duration < 100)).length
year_before_2020 = moviesArray.filter(d => (d.year >= 2015)).length
genre_Dramas = moviesArray.filter(d => (d.genre01 == "Dramas")).length + moviesArray.filter(d => (d.genre02 == "Dramas")).length
director_Marcus_Raboy = moviesArray.filter(d => (d.director == "Marcus Raboy")).length
country_Canada = moviesArray.filter(d => (d.country == "Canada")).length
rating_higher_than_7 = moviesArray.filter(d => (d.rating > 7.0)).length
d3 = require('d3@6')
vegalite = require("vega-embed@6")
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
