Skip to content

Data check, for duplicates, missiong values, wrong values and Correlation between some variables to understand the data

Notifications You must be signed in to change notification settings

Jc-analyst/Social-Apps-Addiction

Repository files navigation

SQL Platform Focus Status License GitHub last commit

📱 Social Media Addiction & Its Effects on Mental Health 😵‍💫

📌 Overview

This project investigates the impact of excessive social media use on mental health and sleep patterns. Using MySQL, I cleaned and analyzed a dataset to uncover patterns, including a strong negative correlation between time spent on social media and well-being.

🔍 Key Findings

  • Negative correlation between app usage and mental health scores.
  • Increased screen time linked to sleep disturbances.
  • Data cleaning included handling duplicates, missing values, and correcting wrong entries.

🏗️ Project Structure

📂 Social-Apps-Addiction/

├── 📄 README.md # Project documentation / # Summary

├── 📄 Students Social Media Addiction.csv # Raw data source

├── 📄 Syntax-Data Cleaning and Correlation.sql / # Cleaning queries / # Correlation queries / # Conclusion

├── 📄 Data_Cleaned.sql/ # Processed outputs

🧹 Data Cleaning Steps

Understanding the Dataset

A Quality Checks

  • Checking for duplicates

  • How many distinct different values per Column

  • Checking for Missing Data (NULLs)

  • Checking for missing data per columns

  • Checking for wrong data (age)

B Run Summary Queries

📊 Correlation Analysis

  • Correlation daily usage vs mental health

  • Correlation daily usage vs sleep quality

📝 Conclusion

This analysis highlights the risks of social media addiction, showing measurable declines in mental well-being and sleep quality as usage increases.

About

Data check, for duplicates, missiong values, wrong values and Correlation between some variables to understand the data

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published