Student Alcoholism and Academic Performance Dataset

Overview

This dataset provides comprehensive insights into the socioeducational factors influencing student behavior, with a focus on alcohol consumption and academic performance in high school. Collected through a survey conducted among high school students, the dataset includes various social and gender-related information, as well as grades in the Portuguese Language discipline.

Source

The data was gathered by P. Cortez and A. Silva for the study “Using Data Mining to Predict High School Student Performance,” presented at the 5th Future Business Technology Conference (FUBUTEC, 2008) in Porto, Portugal.

Use Cases

This dataset is valuable for exploring the complex interplay between social and educational factors on student behavior, focusing on alcohol consumption patterns and academic performance. Researchers, educators, and data enthusiasts can leverage this dataset for various analyses and predictive modeling.

Citation

Please cite the original source if you use or refer to this dataset:

P. Cortez e A. Silva. Usando a Mineração de Dados para Prever o Desempenho do Aluno do Ensino Médio. Em A. Brito e J. Teixeira Eds., Proceedings of 5th FUture BUsiness TEChnology Conference (FUBUTEC 2008) pp. 5-12, Porto, Portugal, abril de 2008, EUROSIS, ISBN 978-9077381-39-7.

Or if you can't find the author, you can cite this dataset by the DOI present in it

Features

school: Student's school (binary: GP (Gabriel Pereira) or MS (Mousinho da Silveira))
sex: Student's sex (binary: 'F' - female or 'M' - male)
age: Student age (numeric: 15 to 22)
address: Type of student's residential address (binary: 'U' - urban or 'R' - rural)
famsize: Family size (binary: 'LE3' - less than or equal to 3 or 'GT3' - greater than 3)
Pstatus: Parents' cohabitation status (binary: 'T' - living together or 'A' - separated)
Medu: Mother's education level (0 - none, 1 - Elementary School 1, 2 - Elementary School 2, 3 - High School or 4 - Higher Education)
Fedu: Father's education level (0 - none, 1 - Elementary School 1, 2 - Elementary School 2, 3 - High School or 4 - Higher Education)
Mjob: Mother's job (nominal: teacher, health, services, at_home or Other)
Fjob: Father's job (nominal: teacher, health, services, at_home or Other)
reason: Reason for choosing this school (nominal: home, reputation, course or other)
guardian: Student's guardian (nominal: mother, father or other)
traveltime: Travel time from home to school (time intervals: 1 - <15 min., 2 - 15 to 30 min., 3 - 30 min. to 1 hour or 4 - >1 hour )
studytime: Weekly study time (time intervals: 1 - <2 hours, 2 - 2 to 5 hours, 3 - 5 to 10 hours or 4 - >10 hours)
schoolsup: Extra educational support (binary: yes or no)
famsup: Family educational support (binary: yes or no)
paid: Private classes on subjects related to the course (binary: yes or no)
activities: Performs extracurricular activities (binary: yes or no)
nursery: Attended daycare (binary: yes or no)
higher: Desire to pursue a degree (binary: yes or no)
internet: Internet access at home (binary: yes or no)
romantic: Are you in a romantic relationship (binary: yes or no)
famrel: Quality of family relationships (categorical: from 1 - very bad to 5 - excellent)
freetime: Free time after school (categorical: from 1 - very low to 5 - very high)
goout: Time with friends (categorical: from 1 - very low to 5 - very high)
Dalc: Alcohol consumption on the work day (categorical: from 1 - very low to 5 - very high)
Walc: Alcohol consumption on the weekend (categorical: from 1 - very low to 5 - very high)
health: Current health status (categorical: from 1 - very bad to 5 - very good)
absences: Number of school absences (numeric: from 0 to 93)
G1: First semester grade (numeric: from 0 to 20)
G2: Second semester grade (numeric: from 0 to 20)

explorer = pd.read_csv('https://raw.githubusercontent.com/gabrielluizone/FirstCode/main/ipor_explorer.csv')
classification = pd.read_csv('https://raw.githubusercontent.com/gabrielluizone/FirstCode/main/ipor_classification.csv')

Tables

Lpor Classification

@kaggle.gabrielluizone_high_school_alcoholism_and_academic_performance.lpor_classification

28.86 KB
649 rows
31 columns


CREATE TABLE lpor_classification (
  "escola" BIGINT,
  "sexo" BIGINT,
  "idade" BIGINT,
  "tp_moradia" BIGINT,
  "tamanho_familia" BIGINT,
  "situacao_pais" BIGINT,
  "educacao_mae" BIGINT,
  "educacao_pai" BIGINT,
  "trabalho_mae" BIGINT,
  "trabalho_pai" BIGINT,
  "motivo_escolha_escolar" BIGINT,
  "responsavel_legal" BIGINT,
  "tempo_ida_escola" BIGINT,
  "tempo_estudo_semanal" BIGINT,
  "apoio_educacao_extra" BIGINT,
  "apoio_educacao_pais" BIGINT,
  "aulas_particulares" BIGINT,
  "ativ_extracurricular" BIGINT,
  "frequentou_creche" BIGINT,
  "quer_fazer_graduacao" BIGINT,
  "tem_internet" BIGINT,
  "esta_namorando" BIGINT,
  "boa_convivencia_familia" BIGINT,
  "tempo_livre_apos_escola" BIGINT,
  "tempo_com_amigos" BIGINT,
  "alcool_dia_util" BIGINT,
  "alcool_fim_semana" BIGINT,
  "estado_saude" BIGINT,
  "falta_escolar" BIGINT,
  "nota_1semestre" BIGINT,
  "nota_2semestre" BIGINT
);

Lpor Explorer

@kaggle.gabrielluizone_high_school_alcoholism_and_academic_performance.lpor_explorer

27.53 KB
649 rows
31 columns


CREATE TABLE lpor_explorer (
  "escola" VARCHAR,
  "sexo" VARCHAR,
  "idade" BIGINT,
  "tp_moradia" VARCHAR,
  "tamanho_familia" VARCHAR,
  "situacao_pais" VARCHAR,
  "educacao_mae" VARCHAR,
  "educacao_pai" VARCHAR,
  "trabalho_mae" VARCHAR,
  "trabalho_pai" VARCHAR,
  "motivo_escolha_escolar" VARCHAR,
  "responsavel_legal" VARCHAR,
  "tempo_ida_escola" VARCHAR,
  "tempo_estudo_semanal" VARCHAR,
  "apoio_educacao_extra" VARCHAR,
  "apoio_educacao_pais" VARCHAR,
  "aulas_particulares" VARCHAR,
  "ativ_extracurricular" VARCHAR,
  "frequentou_creche" VARCHAR,
  "quer_fazer_graduacao" VARCHAR,
  "tem_internet" VARCHAR,
  "esta_namorando" VARCHAR,
  "boa_convivencia_familia" VARCHAR,
  "tempo_livre_apos_escola" VARCHAR,
  "tempo_com_amigos" VARCHAR,
  "alcool_dia_util" VARCHAR,
  "alcool_fim_semana" VARCHAR,
  "estado_saude" VARCHAR,
  "falta_escolar" BIGINT,
  "nota_1semestre" BIGINT,
  "nota_2semestre" BIGINT
);

Student Lpor

@kaggle.gabrielluizone_high_school_alcoholism_and_academic_performance.student_lpor

25 KB
649 rows
31 columns


CREATE TABLE student_lpor (
  "school" VARCHAR,
  "sex" VARCHAR,
  "age" BIGINT,
  "address" VARCHAR,
  "famsize" VARCHAR,
  "pstatus" VARCHAR,
  "medu" BIGINT,
  "fedu" BIGINT,
  "mjob" VARCHAR,
  "fjob" VARCHAR,
  "reason" VARCHAR,
  "guardian" VARCHAR,
  "traveltime" BIGINT,
  "studytime" BIGINT,
  "schoolsup" VARCHAR,
  "famsup" VARCHAR,
  "paid" VARCHAR,
  "activities" VARCHAR,
  "nursery" VARCHAR,
  "higher" VARCHAR,
  "internet" VARCHAR,
  "romantic" VARCHAR,
  "famrel" BIGINT,
  "freetime" BIGINT,
  "goout" BIGINT,
  "dalc" BIGINT,
  "walc" BIGINT,
  "health" BIGINT,
  "absences" BIGINT,
  "g1" BIGINT,
  "g2" BIGINT
);