#Film column has a bunch of NaN that needs fixes, either value isn't there or dosen't apply
#If film dosen't apply then we just put ***** because that is better then NaN

#The Sky Hawk - Ralph Hammeras
data.loc[(data.Award == 'Engineering Effects') & (data.Name == 'Ralph Hammeras'), 'Film'] = 'The Sky Hawk'
#The Jazz Singer - Nugent Slaughter
data.loc[(data.Award == 'Engineering Effects') & (data.Name == 'Nugent Slaughter'), 'Film'] = 'The Jazz Singer'

#The Red Mill - Joseph Farnham
data.loc[(data.Award == 'Writing (Title Writing)') & (data.Name == 'Joseph Farnham'), 'Film'] = 'The Red Mill'
#The Magic Flame - George Marion, Jr.
data.loc[(data.Award == 'Writing (Title Writing)') & (data.Name == 'George Marion, Jr.'), 'Film'] = 'The Magic Flame'

#Honorary Award dosent alwats have a film so we just put *****
data.loc[(data.Award == 'Honorary Award') & (data['Film'].isnull()), 'Film'] = '*****'

#For 2 years for some reason there wasnt specifc movie that these studios or persons are nominated for
data.loc[(data.Award == 'Sound Recording') & (data['Film'].isnull()), 'Film'] = '*****'

#First year Assistant Director award was given few studios gave their best Assistant Director and
#the moive isn't declered so this award dosn't really make sence. ***** it is for now
data.loc[(data.Award == 'Assistant Director') & (data['Film'].isnull()), 'Film'] = '*****'

#Special award is the same as Honorary Award. So *****
data.loc[(data.Award == 'Special Award') & (data['Film'].isnull()), 'Film'] = '*****'

#Irving G. Thalberg Memorial Award is an honorary Award, so *****
data.loc[(data.Award == 'Irving G. Thalberg Memorial Award') & (data['Film'].isnull()), 'Film'] = '*****'

#Special Foreign Language Film Award is what best Foreign language Film was called before.
#Name and film are swaped later
data.loc[(data.Award == 'Special Foreign Language Film Award') & (data.Name == 'Monsieur Vincent'), 'Film'] = 'France'
data.loc[(data.Award == 'Special Foreign Language Film Award') & (data.Name == 'The Bicycle Thief'), 'Film'] = 'Italy'

#Honorary Foreign Language Film Award same as Special Foreign Language Film Award
data.loc[(data.Award == 'Honorary Foreign Language Film Award') & (data.Name == 'The Walls of Malapaga'), 'Film'] = 'France, Italy'
data.loc[(data.Award == 'Honorary Foreign Language Film Award') & (data.Name == 'Rashomon'), 'Film'] = 'Japan'
data.loc[(data.Award == 'Honorary Foreign Language Film Award') & (data.Year ==  '1952'), 'Name'] = 'Forbidden Games'
data.loc[(data.Award == 'Honorary Foreign Language Film Award') & (data.Name == 'Forbidden Games'), 'Film'] = 'France'
data.loc[(data.Award == 'Honorary Foreign Language Film Award') & (data.Name == 'Gate of Hell'), 'Film'] = 'Japan'
data.loc[(data.Award == 'Honorary Foreign Language Film Award') & (data.Name == 'Samurai, The Legend of Musashi'), 'Film'] = 'Japan'

#Jean Hersholt Humanitarian Award should be Honorary Award in our dataset
data.loc[(data.Award == 'Jean Hersholt Humanitarian Award') & (data['Film'].isnull()), 'Film'] = '*****'

#Medal of Commendation and John A. Bonner Medal of Commendation Award should just be *****
data.loc[(data.Award == 'Medal of Commendation') & (data['Film'].isnull()), 'Film'] = '*****'
data.loc[(data.Award == 'John A. Bonner Medal of Commendation') & (data['Film'].isnull()), 'Film'] = '*****'
data.loc[(data.Award == 'Award of Commendation') & (data['Film'].isnull()), 'Film'] = '*****'

#Gordon E. Sawyer Award is an honoaray award
data.loc[(data.Award == 'Gordon E. Sawyer Award') & (data['Film'].isnull()), 'Film'] = '*****'

#Sis Hopkins - The nomination was withdrawn by Republic Studios. It is thus not counted as an official
#Academy nomination and listed here for the purpose of information only. HOW TO DROP THIS???
data = data[(data['Name'] != 'Sis Hopkins')]

#Song of the Open Road wasn't nominated for Art Direction but for Music (Original Score)
data.loc[(data.Award == 'Art Direction (Black and White)') & (data.Name == 'Song of the Open Road'), 'Film'] = 'Music (Original Score)'