Challenge #455: Exploring Star Wars Survey Data

[AYXAcademy]

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:

1. Determine which Star Wars episode among the six films was the most viewed by survey respondents.
2. Create a graph to evaluate the correlation between how often films were viewed (from Task 1) and the rankings provided by respondents.
3. 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:

• Changing Data Layouts
• Summarizing Data

Happy solving!

Data source: https://www.kaggle.com/code/samaxtech/cleaning-analyzing-star-wars-survey-data/input

The Academy Team

[ggruccio]

Not the same as my rankings!  I like Return of the Jedi best!  🙂

Spoiler

Not as difficult as I was thinking originally.  I just used the first row of data as headers and transposed where needed.  Also sorted my responses by ranking for the chart to easier view the correlation.

[mmontgomery]

C455

Spoiler

[balajilolla2]

Spoiler

Solution Attached

[alacoume]

My solution: 

Spoiler

[griffinwelsh]

My solution

[Tofel]

Spoiler

In Task 2 I have reversed the scoring scale (higher the better), so correlation between rating and popularity can be seen more clearly.

 

[Bobbyt23]

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.

Spoiler

[binuacs]

Spoiler

[RolandSchubert]

Spoiler