Skip to content

This data analysis project focused on extracting insights from survey responses. It involves data cleaning, merging, and transformation using iPython (Pandas,OS) and SQL. The goal is to identify trends and patterns in survey data for better decision-making.

Notifications You must be signed in to change notification settings

rohitblaze10/Survey_Monkey_Analysis--using-IPYTHON

Repository files navigation

SurveyMonkey Data Analysis

Overview

This project analyzes survey data collected via SurveyMonkey to extract key insights and trends. The dataset is processed using Python, and visualizations are created to present meaningful findings. The final results are compiled into a presentation.

Project Structure

  • Data - Survey Monkey Output.xlsx: Raw survey data exported from SurveyMonkey.
  • Script1-Data_manipulation.ipynb: Jupyter notebook for data cleaning and analysis.
  • Final_Presentation.xlsx: Summary of key insights and visualizations.

Getting Started

Prerequisites

Ensure you have the following installed:

  • Python 3.x
  • Jupyter Notebook
  • Pandas
  • Matplotlib / Seaborn (for visualization)

Installation

  1. Clone this repository:
    git clone https://github.com/rohitblaze10/survey-analysis.git
    cd survey-analysis
  2. Install the required Python libraries:
    pip install pandas matplotlib seaborn jupyter

Usage

  1. Open Jupyter Notebook:
    jupyter notebook
  2. Run Script1-Data_manipulation.ipynb to process and analyze the data.
  3. View results in Final_Presentation.xlsx.

Key Findings

  • Top 3 Divisions Represented:
    • Infrastructure (48 respondents)
    • Finance (44 respondents)
    • Information Technology (26 respondents)
  • Position Levels:
    • Staff (116 respondents)
    • Managers (46 respondents)
    • Department Leads (28 respondents)
  • Generational Breakdown:
    • Generation X (75 respondents, born 1965-1980)
    • Millennials (66 respondents, born 1981-2000)
    • Baby Boomers (39 respondents, born 1946-1964)
  • Gender Distribution:
    • Female (96 respondents)
    • Male (86 respondents)
    • Non-Binary (1 respondent)
    • Prefer not to answer (13 respondents)
  • Employment Type:
    • Nearly all respondents (198) are full-time employees.

Future Improvements

  • Enhance data cleaning steps.
  • Add more visualizations for better insights.
  • Automate report generation.

Contributing

Feel free to fork this repository and make improvements. Pull requests are welcome!

License

[Specify a license, e.g., MIT, Apache 2.0] .

About

This data analysis project focused on extracting insights from survey responses. It involves data cleaning, merging, and transformation using iPython (Pandas,OS) and SQL. The goal is to identify trends and patterns in survey data for better decision-making.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published