project 5 task 1

in project 5 of imdb i seperated all genre and calculated count of movies and when to comes calculate the mean for each genre using average if then in some row there is this error "div/0 !" because of blanks in between genres which i seperated genre by delimeter "|" , so when i hide all the gaps it affects other column which contains unique genre through removing some genres and in the end i'm left out only 2 types of genre to calculate mean of .