How sansk552/my_data_analysis_project_1 works
This is a heart-disease exploratory analysis and prediction project. Its two documented analysis tracks are eight MySQL queries over the heart-failure table and an R workflow that loads the dataset, summarizes and visualizes it, and fits logistic regression. SQL query-to-file assignments follow the numbered scripts and README query order. The README does not document detailed runtime calls or the contents of the saved RData and CSV result files, so those are not modeled as connected components.
Main entry points: My_R.R Load and summarize data · sql_1.sql Cholesterol by gender · sql_2.sql Cases by chest pain · sql_3.sql Age-group case counts
Components 18
SQL analysis
- Cholesterol by gender
sql_1.sql - Cases by chest pain
sql_2.sql - Age-group case counts
sql_3.sql - High BP and cholesterol
sql_4.sql - MaxHR by angina
sql_5.sql - Age by disease status
sql_6.sql - Highest cholesterol cases
sql_7.sql - Cases by ST slope
sql_8.sql
R exploration
- Load and summarize data
My_R.R - Disease frequency by sex
My_R.R - Cholesterol boxplot
My_R.R - Feature correlations
My_R.R - Chest pain frequency plot
My_R.R - MaxHR density by sex
My_R.R
Predictive modeling
- Logistic regression
My_R.R
Other components
- Analyst
- Heart failure table
- Heart failure dataset
Connections 24
- Analyst → Cholesterol by gender: runs query
README.md - Analyst → Cases by chest pain: runs query
README.md - Analyst → Age-group case counts: runs query
README.md - Analyst → High BP and cholesterol: runs query
README.md - Analyst → MaxHR by angina: runs query
README.md - Analyst → Age by disease status: runs query
README.md - Analyst → Highest cholesterol cases: runs query
README.md - Analyst → Cases by ST slope: runs query
README.md - Cholesterol by gender → Heart failure table: queries
README.md - Cases by chest pain → Heart failure table: queries
README.md - Age-group case counts → Heart failure table: queries
README.md - High BP and cholesterol → Heart failure table: queries
README.md - MaxHR by angina → Heart failure table: queries
README.md - Age by disease status → Heart failure table: queries
README.md - Highest cholesterol cases → Heart failure table: queries
README.md - Cases by ST slope → Heart failure table: queries
README.md - Analyst → Load and summarize data: runs analysis
README.md - Load and summarize data → Heart failure dataset: loads
README.md - Load and summarize data → Disease frequency by sex: analyzes
README.md - Load and summarize data → Cholesterol boxplot: plots
README.md - Load and summarize data → Feature correlations: calculates
README.md - Load and summarize data → Chest pain frequency plot: plots
README.md - Load and summarize data → MaxHR density by sex: plots
README.md - Load and summarize data → Logistic regression: fits model
README.md