a davis
Independent Assignment: Analyzing Community Wellbeing with Python
Platform: Google Colab Dataset: community_wellbeing_survey.csv Suggested time: 3–5 hours Total points: 100
Assignment Overview
In this assignment, you will act as a data analyst investigating a fictional community wellbeing survey. You will use Python and the pandas, Matplotlib, and Seaborn libraries to examine survey data, clean missing or inconsistent values, calculate descriptive statistics, create visualizations, and investigate relationships between variables.
Your goal is to use data to answer meaningful questions about community participation, access to local resources, exercise, and wellbeing. You must explain your findings in plain language, as if presenting them to a community organization that wants to understand the results.
No previous Python programming experience is required. You may use the examples provided in class as a starting point, but you must complete your own analysis and explain your own findings.
Part 1: Load and Explore the Data (10 points)
1. Open Google Colab and create a new notebook.
2. Import pandas, NumPy, Matplotlib, and Seaborn.
3. Upload and load the CSV file into a pandas DataFrame.
4. Display the first ten rows.
5. Determine the number of rows and columns.
6. Identify the data types of the columns.
7. Calculate how many unique neighborhoods are represented.
8. Identify three questions you would like to investigate using this dataset.
Part 2: Clean the Data (15 points)
1. Check the dataset for missing values in each column.
2. Count the missing values in each column.
3. Identify inconsistent entries, such as blank neighborhood names or the value unknown in the transportation column.
4. Decide how to handle missing numerical values. You may use the median or another justified method.
5. Decide how to handle missing categorical values. You may use an Unknown category or another justified method.
6. Standardize inconsistent text entries where appropriate.
7. Check whether any duplicate respondent IDs exist.
8. Confirm that the cleaned dataset has the expected number of rows and that your changes make sense.
Part 3: Descriptive Statistics (15 points)
Use pandas to calculate and interpret descriptive statistics.
1. Calculate the mean, median, minimum, maximum, and standard deviation of weekly exercise hours.
2. Calculate the mean and median life satisfaction scores.
3. Determine the most common employment status.
4. Count the number of respondents in each neighborhood.
5. Calculate the average life satisfaction score for each neighborhood.
6. Calculate the average weekly exercise hours for each age group.
7. Identify the neighborhood with the highest average life satisfaction score.
Part 4: Data Visualization (15 points)
Create at least four visualizations using Matplotlib or Seaborn.
1. Bar chart: Number of respondents in each neighborhood.
2. Histogram: Distribution of weekly exercise hours.
3. Bar chart: Average life satisfaction by neighborhood.
4. Scatter plot: Weekly exercise hours versus life satisfaction.
Part 5: Statistical Analysis (20 points)
Investigate at least two relationships in the data.
Calculate the correlation between weekly exercise hours and life satisfaction.
Explain:
· Whether the relationship is positive or negative.
· Whether the relationship appears weak, moderate, or strong.
· Why correlation does not prove causation.
Part 6: Interpretation and Recommendations (15 points)
Write a short report of approximately 400–600 words addressing the following:
1. What are the three most important findings from your analysis?
2. What did you learn about community participation, access to resources, or wellbeing?
3. What recommendations might you offer a community organization based on the results?
4. What limitations should be considered before using these findings to make decisions?
5. What additional information would you collect in a future survey?
Your recommendations must be supported by your analysis. Avoid claiming that one variable causes another when the data only show an association.
Remember that the dataset is synthetic and does not represent actual residents or establish real-world community conditions.
Part 7: Submission and Reproducibility (10 points)
Submit the following:
· Your completed Google Colab notebook (.ipynb).
· A PDF or Word report containing your findings and visualizations.
· A brief summary of your data-cleaning decisions.
· A conclusion identifying one important limitation of the analysis.