Student Alcohol Consumption
Social, gender and study data from secondary school students
@kaggle.uciml_student_alcohol_consumption
Social, gender and study data from secondary school students
@kaggle.uciml_student_alcohol_consumption
The data were obtained in a survey of students math and portuguese language courses in secondary school. It contains a lot of interesting social, gender and study information about students. You can use it for some EDA or try to predict students final grade.
Attributes for both student-mat.csv (Math course) and student-por.csv (Portuguese language course) datasets:
These grades are related with the course subject, Math or Portuguese:
Additional note: there are several (382) students that belong to both datasets .
These students can be identified by searching for identical attributes
that characterize each student, as shown in the annexed R file.
P. Cortez and A. Silva. Using Data Mining to Predict Secondary School Student Performance. In A. Brito and J. Teixeira Eds., Proceedings of 5th FUture BUsiness TEChnology Conference (FUBUTEC 2008) pp. 5-12, Porto, Portugal, April, 2008, EUROSIS, ISBN 978-9077381-39-7.
Fabio Pagnotta, Hossain Mohammad Amran.
Email:fabio.pagnotta@studenti.unicam.it, mohammadamra.hossain '@' studenti.unicam.it
University Of Camerino
https://archive.ics.uci.edu/ml/datasets/STUDENT+ALCOHOL+CONSUMPTION
CREATE TABLE student_mat (
"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,
"failures" 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,
"g3" BIGINT
);CREATE TABLE student_por (
"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,
"failures" 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,
"g3" BIGINT
);Anyone who has the link will be able to view this.