Question #$2--$ Inspect & Clean reponses.csv

Use pandas to load and inspect the responses.csv data and ensure the responses fit the five point Likert scale.

Label

Description

$1$

strongly disagree

$2$

disagree

$3$

neutral

$4$

agree

$5$

strongly disagree

Since this file was generated by the automated software, you do not expect any significant issues, but better be safe than sorry. Let's double check to make sure.

$($a$)$ Are any responses outside the expected range?

$-$ If so$,$ what should you do about it$?$

$-$ Apply the fix you described above if necessary.

$($b$)$ Do you observe any partial survey completions?

$-$ If so$,$ what should you do about it$?$

$-$ Apply the fix you described above if necessary.

$($c$)$ Do you notice anything unexpected with any of the responses?

$-$ If so$,$ what should you do about it$?$

$-$ Apply the fix you described above if necessary.

$($d$)$ Let's assume an equal distance between each label so that we can translate individual scores to a percentage. This results in the following scores and add a column called $```$score$```$ to you dataframe and place the computed score for each answer:

Label

Description

Score

$1$

strongly disagree

$0\mathrm{.}20$

$2$

disagree

$0\mathrm{.}40$

$3$

neutral

$0\mathrm{.}60$

$4$

agree

$0\mathrm{.}80$

$5$

strongly disagree

$1\mathrm{.}00$

$($e$)$ Save a clean version of the file once you have fixed issues. Use the name: responses$\_$clean.csv

What to Submit