Challenge #455: Exploring Star Wars Survey Data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Community Members,
A solution to last week’s challenge can be found here.
This challenge was submitted by our valued Community contributor, Jifeng Qiu. @Qiu, we appreciate your continued creativity in submitting engaging challenges.
May the Force be with us once more!
You have access to a survey about Star Wars, with responses collected from fans before the release of the seventh episode in the franchise, Star Wars: The Force Awakens.
Before diving into the challenge questions, you need to complete a few steps to clean and prepare the data for analysis.
HINT: For each task, you will be required to work on a unique question, outlined as follows:
- Which of the following Star Wars films have you seen? Please select all that apply.
- Please rank the Star Wars films in order of preference with 1 being your favorite film in the franchise and 6 being your least favorite film.
- Please state whether you view the following characters favorably, unfavorably, or are unfamiliar with him/her.
However, the data is not straightforward. Each question may have multiple answers, and the fields related to the same question follow a pattern: the question itself, followed by unnamed fields that appear immediately after.
Once the data is prepared, you are ready to complete the following tasks:
- Determine which Star Wars episode among the six films was the most viewed by survey respondents.
- Create a graph to evaluate the correlation between how often films were viewed (from Task 1) and the rankings provided by respondents.
- Identify the top two favorite characters (rated "Very Favorably") and the top two most disliked characters (rated "Very Unfavorably") based on unique respondents in the survey data.
Need a refresher? Review the following lessons in Academy to gear up:
Happy solving!
Data source: https://www.kaggle.com/code/samaxtech/cleaning-analyzing-star-wars-survey-data/input
The Academy Team
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Not the same as my rankings! I like Return of the Jedi best! 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
C455
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Fun challenge. Does anyone actually like Jar Jar Binks!
Didn't like the format of questions 3 answer so left it in a nice table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator