Can an alcoholic be good in studies?

When it is all about the usage...

Content:

  • How the data is correlated?
  • How previous grade affects the upcoming one
  • How Weekly alcohol consumption is distributed
  • How the grade and walc related(basic level)
  • How the parenting and walc affects the grade

List of attributes:

1. school - student's school (binary: 'GP' - Gabriel Pereira or 'MS' - Mousinho da Silveira)
2. sex - student's sex (binary: 'F' - female or 'M' - male)
3. age - student's age (numeric: from 15 to 22)
4. address - student's home address type (binary: 'U' - urban or 'R' - rural)
5. famsize - family size (binary: 'LE3' - less or equal to 3 or 'GT3' - greater than 3)
6. Pstatus - parent's cohabitation status (binary: 'T' - living together or 'A' - apart)
7. Medu - mother's education (numeric: 0 - none, 1 - primary education (4th grade), 2 – 5th to 9th grade, 3 – secondary education or 4 – higher education)
8. Fedu - father's education (numeric: 0 - none, 1 - primary education (4th grade), 2 – 5th to 9th grade, 3 – secondary education or 4 – higher education)
9. Mjob - mother's job (nominal: 'teacher', 'health' care related, civil 'services' (e.g. administrative or police), 'at_home' or 'other')
10. Fjob - father's job (nominal: 'teacher', 'health' care related, civil 'services' (e.g. administrative or police), 'at_home' or 'other')
11. reason - reason to choose this school (nominal: close to 'home', school 'reputation', 'course' preference or 'other')
12. guardian - student's guardian (nominal: 'mother', 'father' or 'other')
13. traveltime - home to school travel time (numeric: 1 - 1 hour)
14. studytime - weekly study time (numeric: 1 - 10 hours)
15. failures - number of past class failures (numeric: n if 1<=n<3, else 4)
16. schoolsup - extra educational support (binary: yes or no)
17. famsup - family educational support (binary: yes or no)
18. paid - extra paid classes within the course subject (Math or Portuguese) (binary: yes or no)
19. activities -extra-curricular activities (binary: yes or no)
20. nursery - attended nursery school (binary: yes or no)
21. higher - wants to take higher education (binary: yes or no)
22. internet - Internet access at home(binary: yes or no)
23. romantic - with a romantic relationship (binary: yes or no)
24. famrel - quality offamily relationships (numeric: from 1 - very bad to 5 - excellent)
25. freetime - free time after school(numeric: from 1 - very low to 5 - very high)
26. goout - going out with friends (numeric: from 1 - very lowto 5 - very high)
27. Dalc - workday alcohol consumption (numeric: from 1 - very low to 5 - very high)
28. Walc - weekend alcohol consumption (numeric: from 1 - very low to 5 - very high)
29. health - current health status (numeric: from 1 - very bad to 5 - very good)
30. absences - number of school absences (numeric: from 0 to 93)
These grades are related with the course subject, Math or Portuguese:

  • G1 - first period grade(numeric: from 0 to 20)
  • G2 - second period grade (numeric: from 0 to 20)
  • G3 - final grade (numeric: from 0 to 20, output target)

    • The data is about the amount of alcohol consumption of students. The project aim is to see whether using alcohol inside school can affect grades. By analyzing and visualizing, the results has been concluded:

  • Using alcohol specifically has an enormous effect on students. The severity is based on the frequency of use. By analyzing, the result is that students who consume alcohol more than average in a week can have bad performance in school, and therefore tend to have lower grades than others who do not use alcohol frequently.
  • Parents can be a perfect guide for students. Students with caring parents can also achieve high scores with high frequent alcohol consumption.