Stacking multiple groups of variables simultaneously

Some datasets contain multiple groups of variables as column names that need to be stacked simultaneously into their own columns. An example involving the movie dataset can help clarify this. Let's begin by selecting all columns containing the actor names and their corresponding Facebook likes:

>>> movie = pd.read_csv('data/movie.csv')
>>> actor = movie[['movie_title', 'actor_1_name',
...                'actor_2_name', 'actor_3_name',
...                'actor_1_facebook_likes',
...                'actor_2_facebook_likes',
...                'actor_3_facebook_likes']]
>>> actor.head()
                                  movie_title  ...
0                                      Avatar  ...
1    Pirates of the Caribbean: At World's End  ...
2                                     Spectre  ...
3                       The...