I have a dataset in following format:
Movie ID | Actors | Director | language | ReleaseYear | Genre
1 | Anil Kapoor;Manisha Koirala;Jackie Shroff;Anupam Kher;Danny Denzongpa;Pran | Vidhu Vinod Chopra | hin | 1994 | Drama;Romance;Patriotic
As you can see the columns Actors and Genre has multiple values. I need to perform cluster analysis on this dataset. I don't know what would the best way to deal with such data. I am thinking of two possible solution(don't know if it is a correct approach for this type of problem)--
- Split the column, say, 'Actors' into multiple columns e.g. Actors 1, Actor2,..., and then perform the cluster anylysis.
- Row split i.e. convert a single row of data into multiple rows each row for one value of columns like 'Actors' and 'Genre'.
Please suggest me the best way to deal with such data for cluster analysis.