Pandas Cookbook

How to do it...

1. Read in the movie dataset, and make the index meaningful by setting it as the movie title:

>>> movie = pd.read_csv('data/movie.csv', index_col='movie_title')

2. The rename DataFrame method accepts dictionaries that map the old value to the new value. Let's create one for the rows and another for the columns:

>>> idx_rename = {'Avatar':'Ratava', 'Spectre': 'Ertceps'} >>> col_rename = {'director_name':'Director Name',                   'num_critic_for_reviews': 'Critical Reviews'} 

3. Pass the dictionaries to the rename method, and assign the result to a new variable:

>>> movie_renamed = movie.rename(index=idx_rename,                                  columns=col_rename)>>> movie_renamed.head()