Effects Of Alcohol On Student Performance.

A Study of Stellenbosch University Students.

@kaggle.joshuanaude_effects_of_alcohol_on_student_performance

Table List

1 table(22.59 KB)

Stats Survey

@kaggle.joshuanaude_effects_of_alcohol_on_student_performance.stats_survey

22.59 KB
406 rows
17 columns

timestamp Timestamp	your_sex Your Sex?	your_matric_grade_12_average_gpa_in Your Matric (grade 12) Average/ GPA (in %)	what_year_were_you_in_last_year_2023 What Year Were You In Last Year (2023) ?	what_faculty_does_your_degree_fall_under What Faculty Does Your Degree Fall Under?	your_2023_academic_year_average_gpa_in_ignore_if_you_a_4a5cfe68 Your 2023 Academic Year Average/GPA In % (Ignore If You Are 2024–1st Year Student)	your_accommodation_status_last_year_2023 Your Accommodation Status Last Year (2023)	monthly_allowance_in_2023 Monthly Allowance In 2023	were_you_on_scholarship_bursary_in_2023 Were You On Scholarship/bursary In 2023?	additional_amount_of_studying_in_hrs_per_week Additional Amount Of Studying (in Hrs) Per Week	how_often_do_you_go_out_partying_socialising_during_the_week How Often Do You Go Out Partying/socialising During The Week?	on_a_night_out_how_many_alcoholic_drinks_do_you_consume On A Night Out, How Many Alcoholic Drinks Do You Consume?	how_many_classes_do_you_miss_per_week_due_to_alcohol_r_9c6ad762 How Many Classes Do You Miss Per Week Due To Alcohol Reasons, (i.e: Being Hungover Or Too Tired?)	how_many_modules_have_you_failed_thus_far_into_your_studies How Many Modules Have You Failed Thus Far Into Your Studies?	are_you_currently_in_a_romantic_relationship Are You Currently In A Romantic Relationship?	do_your_parents_approve_alcohol_consumption Do Your Parents Approve Alcohol Consumption?	how_strong_is_your_relationship_with_your_parent_s How Strong Is Your Relationship With Your Parent/s?
2024/03/07 5:12:01 pm EET	Female	76	2nd Year	Arts & Social Sciences	72	Private accommodation/ stay with family/friends	R 4001- R 5000	No	8+	Only weekends	8+	3	0	Yes	Yes	Very close
2024/03/07 5:12:08 pm EET	Male	89	2nd Year	Economic & Management Sciences	75	Private accommodation/ stay with family/friends	R 7001 - R 8000	Yes (NSFAS, etc...)	8+	Only weekends	3-5	4+	0	No	Yes	Very close
2024/03/07 5:12:25 pm EET	Male	76	1st Year	AgriSciences	55	Private accommodation/ stay with family/friends	R 4001- R 5000	No	3-5	2	8+	3	0	No	Yes	Very close
2024/03/07 5:12:28 pm EET	Male	89	2nd Year	Engineering	84	Private accommodation/ stay with family/friends	R 6001 - R 7000	No	3-5	3	8+	2	0	Yes	Yes	Very close
2024/03/07 5:13:00 pm EET	Female	74	2nd Year	Arts & Social Sciences	52	Private accommodation/ stay with family/friends	R 4001- R 5000	No	3-5	Only weekends	5-8	1	3	No	Yes	Fair
2024/03/07 5:13:18 pm EET	Male	83	nan	Engineering		Private accommodation/ stay with family/friends	R 6001 - R 7000	No	8+	4+	3-5	3	1	Yes	Yes	Very close
2024/03/07 5:13:22 pm EET	Male	80	2nd Year	Economic & Management Sciences	54	Private accommodation/ stay with family/friends	R 5001 - R 6000	No	8+	2	5-8	1	0	No	Yes	Very close
2024/03/07 5:13:26 pm EET	Female	85	2nd Year	Arts & Social Sciences	75	Private accommodation/ stay with family/friends	R 5001 - R 6000	No	3-5	3	3-5	2	0	Yes	Yes	Very close
2024/03/07 5:13:28 pm EET	Male	89	nan	Engineering		nan	R 5001 - R 6000	No	8+	Only weekends	3-5	0	nan	No	Yes	Very close
2024/03/07 5:13:35 pm EET	Male	83	nan	Science		nan	R 6001 - R 7000	No	3-5	3	5-8	4+	0	No	Yes	Close


CREATE TABLE stats_survey (
  "timestamp" VARCHAR,
  "your_sex" VARCHAR,
  "your_matric_grade_12_average_gpa_in" DOUBLE,
  "what_year_were_you_in_last_year_2023" VARCHAR,
  "what_faculty_does_your_degree_fall_under" VARCHAR,
  "your_2023_academic_year_average_gpa_in_ignore_if_you_a_4a5cfe68" DOUBLE,
  "your_accommodation_status_last_year_2023" VARCHAR,
  "monthly_allowance_in_2023" VARCHAR,
  "were_you_on_scholarship_bursary_in_2023" VARCHAR,
  "additional_amount_of_studying_in_hrs_per_week" VARCHAR,
  "how_often_do_you_go_out_partying_socialising_during_the_week" VARCHAR,
  "on_a_night_out_how_many_alcoholic_drinks_do_you_consume" VARCHAR,
  "how_many_classes_do_you_miss_per_week_due_to_alcohol_r_9c6ad762" VARCHAR,
  "how_many_modules_have_you_failed_thus_far_into_your_studies" VARCHAR,
  "are_you_currently_in_a_romantic_relationship" VARCHAR,
  "do_your_parents_approve_alcohol_consumption" VARCHAR,
  "how_strong_is_your_relationship_with_your_parent_s" VARCHAR
);