-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
35 lines (32 loc) · 42.8 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<!DOCTYPE html>
<html lang="en" dir="ltr">
<head>
<meta
name="viewport"
content="width=device-width, initial-scale=1.0, minimum-scale=1.0"
/>
<title>IS-445 DATA VISUALIZATION</title>
<meta property="og:title" content="IS-445 DATA VISUALIZATION" />
<meta charset="utf-8" />
<meta property="og:type" content="article" />
<meta property="og:description" content="FINAL PROJECT PART - 3" />
<meta property="description" content="FINAL PROJECT PART - 3" />
<link rel="stylesheet" href="static/idyll_styles.css" />
</head>
<body>
<div id="idyll-mount"><div data-reactroot=""><div class="idyll-root"><div class=" idyll-text-container"></div><div class="article-header" style="background:#222222;color:#ffffff"><h1 class="hed">IS-445 Data Visualization Final Project Part-3</h1><h2 class="dek">Students' Performance in Exams</h2><div class="byline">By: <a target="_blank" href="https://www.linkedin.com/in/purujoshi/" style="color:#ffffff">Puru Joshi & Sai Anurag Kasula</a></div><div class="idyll-pub-date">Wed May 04 2022</div></div><div class="idyll-stepper" style="position:relative;height:500px"><div class="idyll-step-graphic"><div class="idyll-graphic"><img src="static/images/0.jpg" idyll="[object Object]"/></div></div><div class="idyll-step-content"></div><div class="idyll-stepper-control"><div class="idyll-stepper-control-button idyll-stepper-control-button-previous">←</div><div class="idyll-stepper-control-button idyll-stepper-control-button-next">→</div></div></div><div class=" idyll-text-container"><h2 id="aim">AIM</h2><p style="text-align:justify" idyll="[object Object]">To examine the impact of economic, personal, and social elements on a student’s performance.</p><div style="background-color:white;padding:20px" idyll="[object Object]"></div><h2 id="exploratory-data-analysis">EXPLORATORY DATA ANALYSIS</h2><h3 id="about-the-data">About the data</h3><p style="text-align:justify" idyll="[object Object]">The data is generated on the fly. Hence, we downloaded the dataset multiple times to increase the number of observations. Post this, we merged all the datasets together into one.</p><h4 id="1.-merging-five-datasets-into-one">1<!-- -->. Merging five datasets into one</h4><pre><code># reading the csv file into a dataframe and taking a quick glance at the data
student_data_df1 = pd.read_csv("D:/Anti Study/UIUC/Sem II/Data Viz/Group Project Part-1/exams.csv")
student_data_df2 = pd.read_csv("D:/Anti Study/UIUC/Sem II/Data Viz/Group Project Part-1/exams1.csv")
student_data_df3 = pd.read_csv("D:/Anti Study/UIUC/Sem II/Data Viz/Group Project Part-1/exams2.csv")
student_data_df4 = pd.read_csv("D:/Anti Study/UIUC/Sem II/Data Viz/Group Project Part-1/exams3.csv")
student_data_df5 = pd.read_csv("D:/Anti Study/UIUC/Sem II/Data Viz/Group Project Part-1/exams4.csv")
# merging the datasets
frames = [student_data_df1, student_data_df2, student_data_df3, student_data_df4, student_data_df5]
student_data_df = pd.concat(frames)
student_data_df</code></pre><h4 id="2.-evaluating-the-pass/fail-status-for-each-student-for-each-subject">2<!-- -->. Evaluating the Pass<!-- -->/Fail status for each student for each subject</h4><pre><code>#setting the threshold for pass/fail for the three exams - introducing the grade as a new column
student_data_df['math_pass_fail'] = np.where(student_data_df['math score']<pass_threshold, 'F', 'P')
student_data_df['reading_pass_fail'] = np.where(student_data_df['reading score']<pass_threshold, 'F', 'P')
student_data_df['writing_pass_fail'] = np.where(student_data_df['writing score']<pass_threshold, 'F', 'P')</code></pre><h3 id="final-data-set">Final Data Set</h3></div><div class="table-container"><div><div class="table "><table role="table" style="margin-bottom:0"><thead style="display:flex;flex-direction:column;width:100%;min-width:1200px"><tr role="row" style="display:inline-flex;flex-grow:1"><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Gender</th><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Lunch</th><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Math Pass Fail</th><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Parental Level Of Education</th><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Race/Ethnicity</th><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Reading Pass Fail</th><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Test Preparation Course</th><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Writing Pass Fail</th><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Math Score</th><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Reading Score</th><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Test Preparation Percentage</th><th colSpan="1" role="columnheader" style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;cursor:pointer">Writing Score</th></tr></thead><tbody role="rowgroup" style="display:flex;flex-direction:column;width:100%;min-width:1200px"><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">female</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">bachelor's degree</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group B</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">72</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">72</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">74</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">female</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">some college</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group C</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">completed</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">69</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">90</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">88</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">female</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">master's degree</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group B</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">90</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">95</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">93</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">male</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">free/reduced</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">associate's degree</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group A</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">47</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">57</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">44</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">male</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">some college</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group C</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">76</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">78</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">75</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">female</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">associate's degree</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group B</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">71</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">83</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">78</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">female</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">some college</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group B</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">completed</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">88</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">95</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">92</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">male</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">free/reduced</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">some college</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group B</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">40</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">43</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">39</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">male</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">free/reduced</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">high school</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group D</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">completed</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">64</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">64</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">67</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">female</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">free/reduced</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">F</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">high school</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group B</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">38</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">60</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">50</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">male</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">associate's degree</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group C</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">58</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">54</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">52</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">male</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">associate's degree</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group D</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">40</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">52</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">43</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">female</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">high school</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group B</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">65</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">81</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">73</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">male</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">some college</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group A</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">completed</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">78</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">72</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">70</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">female</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">master's degree</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group A</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">50</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">53</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">58</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">female</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">some high school</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group C</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">69</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">75</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">78</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">male</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">standard</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">high school</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group C</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">88</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">89</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">86</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">female</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">free/reduced</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">F</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">some high school</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group B</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">F</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">F</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">18</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">32</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">28</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">male</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">free/reduced</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">master's degree</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group C</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">completed</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">46</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">42</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">46</td></tr><tr role="row" style="display:inline-flex;flex-grow:1"><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">female</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">free/reduced</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">associate's degree</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">group C</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">none</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">P</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">54</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">58</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">1</td><td style="flex:1;width:100px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" role="cell">61</td></tr></tbody></table></div><div class="table-pagination" style="display:flex;align-items:stretch;justify-content:space-between;flex-wrap:wrap;padding:3px;box-sizing:border-box;box-shadow:0 0 15px 0 rgb(0 0 0 / 10%);border-top:2px solid rgba(0,0,0,0.1)"><div class="table-pagination-previous" style="display:flex;flex:1;text-align:center"><button disabled="" style="box-sizing:border-box;margin:0;border:0;border-radius:3px;padding:6px;font-size:1em;color:rgba(0, 0, 0, 0.6);background:rgba(0, 0, 0, 0.1);cursor:default;width:100%;opacity:0.5">Previous</button></div><div class="table-pagination-center" style="display:flex;flex:1.5;flex-wrap:wrap;align-items:center;justify-content:space-around"><span style="display:flex;align-items:baseline">Page<!-- --> <!-- -->1<!-- --> <!-- -->of <!-- -->250</span></div><div class="table-pagination-next" style="display:flex;flex:1;text-align:center"><button style="box-sizing:border-box;margin:0;border:0;border-radius:3px;padding:6px;font-size:1em;color:rgba(0, 0, 0, 0.6);background:rgba(0, 0, 0, 0.1);cursor:pointer;width:100%">Next</button></div></div></div></div><div class=" idyll-text-container"><h3 id="what-does-the-data-represent?">What does the Data Represent?</h3><p style="text-align:justify" idyll="[object Object]">The impact of different factors such as parents’ backgrounds, exam preparation, etc. on the performance of the student Looking at the columns and their unique values, we see that the dataset contains:</p><ul><li>gender of the student - ‘female’, ‘male’</li><li>race<!-- -->/ethnicity - ‘group A’, ‘group B’, ‘group C’, ‘group D’, ‘group E’</li><li>level of education of a student’s parents - ‘bachelor’s degree’, ‘some college’, ‘master’s degree’, ‘associate’s degree’, ‘high school’, ‘some high school’</li><li>type of lunch a student has - ‘standard’, ’free<!-- -->/reduced’</li><li>has the student prepared for the test - ‘none’, ‘completed’</li><li>test scores for the three exams - Math, Reading, Writing</li><li>Math<!-- -->/Reading<!-- -->/Writing Pass Fail - P, F</li></ul><p style="text-align:justify" idyll="[object Object]">There are three measures (numeric values) which are the scores for the three exams.</p><div style="background-color:white;padding:20px" idyll="[object Object]"></div><h2 id="visualizations">VISUALIZATIONS</h2><h3 id="taking-a-deeper-dive-into-the-data">Taking a deeper dive into the data</h3><p style="text-align:justify" idyll="[object Object]">All of the below dashbaords are interactive.</p><h4 id="dashboard-1">Dashboard-<!-- -->1</h4><iframe src="https://public.tableau.com/views/DataVizFinalProjectPart3-GendervsExamAvg_Scores/GendervsExamAvg_Scores?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link:showVizHome=no&:embed=true" width="200%" height="800"></iframe><p style="text-align:justify" idyll="[object Object]">The above dashboard depicts the ratio of male:female students in the dataset, in the form of a pie-chart. The dashboard also entails the avg. scores in each exam, for male as well as for female students.</p><p style="text-align:justify" idyll="[object Object]">One can click on the partitions of the pie-chart to take a closer look at the avg. scores for different exams for the selected gender. For going back to the default view, one must select both the partitions together with the help of a drag-and-select motion across the pie-chart.</p><p style="text-align:justify" idyll="[object Object]">We see that the male to female ratio is almost 1:1. The males have performed better in the Math exam as compared to the females, whereas the performance of the females is better in the others, i.e., Reading and Writing exams.</p><div style="background-color:white;padding:20px" idyll="[object Object]"></div><h4 id="dashboard-2">Dashboard-<!-- -->2</h4><iframe src="https://public.tableau.com/views/DataVizFinalProjectPart3-EffectsofParentalLevelofEducationonStudentsPerformance/Dashboard-StatsDetailsonParentalLevelofEducation?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link:showVizHome=no&:embed=true" width="200%" height="800"></iframe><p style="text-align:justify" idyll="[object Object]"> The first plot of the dashboard shows the avg. scores(for all exams) of students with respect to their parent’s education level. The second plot shows the pass:fail ratio of the students for different levels of parental education.</p><p style="text-align:justify" idyll="[object Object]"> There are two levels of interactivity for the above dashboard:</p><ol><li>If one wants to view the pass:fail ratio with respect to a certain parental education level, they would need to click on either of the three exam score bars, in that particular education level. For instance, if one wants to view the pass:fail ratio for a master’s degree (parental education level), they would click on either Math, Reading, or Writing score bar under the master’s degree section, in the first plot. Please note that in our dataset, it happens to be that if one student has passed in say, the Math exam, they have also passed in the other two. This is why it doesn’t make a difference if one clicks on either of the three score bars.</li><li>On the other hand, if one wants to take a closer look at the respective avg. exam scores for a certain parental education level, they would click on the stacked bar pertaining to that education level. Please note that if one wants to go back to the default view, they’d need to reload the page.</li></ol><p style="text-align:justify" idyll="[object Object]">One interesting thing to note here is that the least number of students who have failed have parents with a bachelor’s or a master’s degree. Whereas, the number of students who have failed seems to be more for either a high school or some high school level of parental education.</p><div style="background-color:white;padding:20px" idyll="[object Object]"></div><h4 id="dashboard-3">Dashboard-<!-- -->3</h4><iframe src="https://public.tableau.com/views/DataVizFinalProjectPart3-EffectsofTestPreparationonExamAvg_ScoresfordifferentRaceEthnicityGroups/Dashboard-StatsDetailsonEthnicity?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link:showVizHome=no&:embed=true" width="200%" height="800"></iframe><p style="text-align:justify" idyll="[object Object]">The plot on the left-top corner shows the distribution of students’ race/ethnicity in the form of a pie-chart. The plot on the right-top corner shows the ratio of test preparation done by the student (completed vs. none), with respect to the individual ethnicity groups. The plot at the bottom shows the avg. exam scores for all the exams with respect to their respective ethnic groups.</p><p style="text-align:justify" idyll="[object Object]">Hovering over a particular section in the pie-chart gives us the details of the ethnic group and the count of the students in that group. Say, if one clicks on the pie-chart section for ethnicity group A, they’d only see the test-preparation ratio for group A in plot-2 and the respective avg. exam scores in plot-3. Note that, similar to Dashboard-2, there are 3 levels of interactivity in Dashboard-3 and if at some point one wants to return to the default view, they could do so by refreshing the page.</p><p style="text-align:justify" idyll="[object Object]">Upon closely observing each of the plots, we see that even though the count of the students belonging to each of the five ethnicity groups is different, the test preparation ratio (completed vs. none) is still very similar across the groups.</p><p style="text-align:justify" idyll="[object Object]">Group E is the second smallest group (in terms of the number of students), however, they seem to have performed comparatively better than the other in all the three exams. One can verify this by taking a look at the avg. score bars for Group E in the third plot.</p><div style="background-color:white;padding:20px" idyll="[object Object]"></div><h2 id="more-findings---contextual-visualizations">MORE FINDINGS - CONTEXTUAL VISUALIZATIONS</h2><h3 id="plot-1">Plot-<!-- -->1</h3><img src="static/images/11.png" idyll="[object Object]"/><p style="text-align:justify" idyll="[object Object]">While exploring the domain, we came across a different study where the authors examined the relation between exam scores and the factor of listening to music. They observed that the students who listened to music while studying clearly performed better in the exams.</p><h3 id="plot-2">Plot-<!-- -->2</h3><img src="static/images/22.png" idyll="[object Object]"/><p style="text-align:justify" idyll="[object Object]">In the same study, the author also examined the correlation between avg. scores and age, sleeping hours, and, gaming hours. The authors concluded, “all fours elements have moderate correlation with student’s result. In other words, these can be seen as reasons that influencing students’s rank in school.”.</p><h2 id="references-&-citations">REFERENCES & CITATIONS</h2><h4 id="1.-dataset:">1<!-- -->. Dataset:</h4><p><a text="http://roycekimmons.com/tools/generated_data/exams" url="http://roycekimmons.com/tools/generated_data/exams" target="_blank" href="http://roycekimmons.com/tools/generated_data/exams">http://roycekimmons.com/tools/generated_data/exams</a> </p><h4 id="2.-contextual-visualizations:">2<!-- -->. Contextual Visualizations:</h4><a text="http://rstudio-pubs-static.s3.amazonaws.com/173363_00e7fd1b73ad4aa98624140f2385750e.html" url="http://rstudio-pubs-static.s3.amazonaws.com/173363_00e7fd1b73ad4aa98624140f2385750e.html" target="_blank" href="http://rstudio-pubs-static.s3.amazonaws.com/173363_00e7fd1b73ad4aa98624140f2385750e.html">http://rstudio-pubs-static.s3.amazonaws.com/173363_00e7fd1b73ad4aa98624140f2385750e.html</a></div></div></div></div>
<script src="static/idyll_index.js"></script>
</body>
</html>