Screen Link: https://app.dataquest.io/m/201/guided-project%3A-star-wars-survey/5/cleaning-the-ranking-columns
My Code:
star_wars[star_wars.columns[9:15]] = star_wars[star_wars.columns[9:15]].astype(float)
episodes = ['episode_'+ str(i) for i in range(1, 7)]
ep_dict = {}
cols_to_change = star_wars.columns[9:15]
for i in range(6):
key = cols_to_change[i]
value = episodes[i]
ep_dict[key] = value
star_wars.rename(columns=ep_dict)
print(star_wars.columns[9:15])
What I expected to happen:
Column names to be ‘episode_1’, ‘episode_2’…, ‘episode_6’.
What actually happened:
Column names are unchanged.
There was no output error.