Question: Use the CSV dataset for Students Performance in this module to do the following: make plot showing the math, reading and writing scores vs. race/ethnicity.
Use the CSV dataset for Students Performance in this module to do the following:
- make plot showing the math, reading and writing scores vs. race/ethnicity. Race/ethnicity should be on the x axis, the score on the y axis and the subjects (math, reading, writing) as series in the chart. You can make any chart you like.
- make a plot showing the math, reading and writing scores vs. parental level of education. Parental level of education should be on the x axis, the score on the y axis and the subjects (math, reading, writing) as series in the chart. The chart you choose has to be a different type than the one chosen above.
- Filter the data to show only the scores of females in group A of race/ethnicity who had a test preparation course='completed' and insert the math, reading and writing scores for this subset into a table in SQL Server. The table should contain columns for gender, race/ethnicity, test preparation course, and each course score.
Each of these should be able to run independently of the other. With a jupyter notebook file this is easy, just make each one a separate code block. If you would rather these be a python script, then submit them as 3 separate files.
Again, the requirement is that each of these stands alone; one should not depend on the other.

gender female female female male male female female male male female male male female male female female male race/ethnicity parental levelofeducation lunch group B group C group B groupA group C group B group B group B group D group B group C group D group B groupA groupA group C group C ba chelor's degree some college master's degree associate's degree some college associate's degree some college some college high school high school associate's degree associate's degree high school some college master's degree some high school high school standard standard standard free/reduced standard standard standard free/reduced free/reduced free/reduced standard standard standard standard standard standard standard test preparation course math score reading score writing score none co mpleted none none none none co mpleted none co mpleted none none none none co mpleted none none none 72 69 90 47 76 71 88 40 64 38 58 40 65 78 50 69 88 72 9O 95 57 78 83 95 43 64 60 54 52 81 72 53 75 89 74 88 93 44 75 78 92 39 67 50 52 43 73 70 58 78 86
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
