Each student is to prepare a written analysis using Python. The student will use the datasets to perform their analysis, import the data into Python and use the tool to explore that data and find...

This Is Your Title: It Should Be Descriptive but Succinct
Your Name
Department of ABC, University of Wisconsin – Whitewater
ABC 101: Course Name
Professor (or Dr.) Firstname Lastname
Date
Introduction
In this project we will do the data analysis using python on our data set i.e Student alcohol consumption. We will use Jupyter notebook tool for this project. In our dataset there are two csv files one is ‘student-mat.csv’ and ‘student-por.csv’ both files contains the data obtained from survey of the students of math and portuguese language courses in seconder school. We will use both of this dataset for the Exploratory data analysis using python language.
About the Dataset
Both of the dataset contains having total 33 attributes. Details of each attributes is as following
    Attribute
    Details
    Remarks
    school
    student's school
    'GP' - Gabriel Pereira or 'MS' - Mousinho da Silveira
    sex
    student's sex
    'F' - female or 'M' - male
    age
    student's age
    from 15 to 22
    address
    student's home address
    'U' - urban or 'R' - rural
    famsize
    family size
    'LE3' - less or equal to 3 or 'GT3' - greater than 3
    Pstatus
    parent's cohabitation status
    'T' - living together or 'A' - apart
    Medu
    mother's education
    0 - none, 1 - primary education (4th grade), 2 – 5th to 9th grade, 3 – secondary education or 4 – higher education
    Fedu
    father's education
    0 - none, 1 - primary education (4th grade), 2 – 5th to 9th grade, 3 – secondary education or 4 – higher education
    Mjob
    mother's job
    'teacher', 'health' care related, civil 'services' (e.g. administrative or police), 'at home' or 'other'
    Fjob
    father's job
    'teacher', 'health' care related, civil 'services' (e.g. administrative or police), 'at_home' or 'other'
    reason
    reason to choose this school
    close to 'home', school 'reputation', 'course' preference or 'other'
    guardian
    student's guardian
    'mother', 'father' or 'other'
    traveltime
    home to school travel time
    1 - <15 min., 2 - 15 to 30 min., 3 - 30 min. to 1 hour, or 4 - >1 hour
    studytime
    weekly study time
    1 - <2 hours, 2 - 2 to 5 hours, 3 - 5 to 10 hours, or 4 - >10 hours
    failures
    number of past class failures
    n if 1<=n<3, else 4
    schoolsup
    extra educational support
    yes or no
    famsup
    family educational support
    yes or no
    paid
    extra paid classes within the course subject
    yes or no
    activities
    extra-curricular activities
    yes or no
    nursery
    attended nursery school
    yes or no
    higher
    wants to take higher education
    yes or no
    interne
    Internet access at home
    yes or no
    romantic
    with a romantic relation
    yes or no
    famrel
    quality of family relationships
    from 1 - very bad to 5 – excellent
    freetime
    free time after school
    from 1 - very low to 5 - very high
    goout
    going out with friends
    from 1 - very low to 5 - very high
    Walc
    weekend alcohol consumption
    from 1 - very low to 5 - very high
    health
    current health status
    from 1 - very bad to 5 - very good
    absences
    number of school absences
    from 0 to 93
Data Analysis
For our data analysis we have loaded of dataset into the python pandas dataframe.
Loading of Data into...