imdb movie analysis

For the data cleaning process for the project imdb movie analysis. How to derive value for missing data in budget , also how to clean the director name as some of the data have name containing special characters like %$#.