students-habits-performance-analysis-using-mysql-in-python

Date:May02 -2025

Student habits performance analysis using mysql to stored data then connect with python to retrive data

• Data collection: Student habits performance dataset (1000 data) collected from kaggle.

• Data handle: Pandas to read the dataset and checked null values.

• Data store: Mysqlconnetor to connect with python then create database,create tables.

• Dataset detalis: student_id,age ,gender,study_hours_per_day,social_media_hours,netflix_hours,part_time_job,attendance_percentage ,sleep_hours diet_quality,exercise_frequency,parental_education_level,internet_quality,mental_health_rating,extracurricular_participation,exam_score
  insert data to mysql.

• Data retrive: streamlit UI for web based SQL query to retrive data.

• Streamlit:

Bar chart:

Students who are more then spend in their studies they are got 100% exam score and mostly female got exam score 100%.