Creating A Predictive Model Using Python - Assignment Solution

In this assignment you need to write your narrative, including screenshots as required. You must specifically address the following questions in your narrative:

• Establish a baseline using the merged data set that you created in Project One. Include a screenshot to show your baseline.
• Select and create the appropriate features for your predictive model. Include screenshots of your engineering of features.
• Apply two predictive models to the data to show variation in predictability of the results. Include screenshots of your models.
• Explain how accurately you can predict outcomes based on the data.

Presentation

Present your results to an executive-level audience including visualizations and conclusions. Specifically address the following in your presentation:

• Use a visualization technique appropriate for your audience and objective.
• How does your visualization tell the story you want to tell?
• Using PowerPoint, deliver the data for an executive-level audience, drawing specific conclusions and offering opportunities to address the original questions.

To complete this project, you must submit the following:

1. Part 1: Submit a 2- to 4-page Word document with the results from your exploratory data analysis, including screenshots and predictive models, as well as your explanatory narrative.  Cite sources according to APA style.
2. Part 2: Submit a 3- to 5-slide finished executive presentation in PowerPoint that includes your visualizations and storyline explanation conveying observations and opportunities.

Free Assignment Solution -  Creating A Predictive Model Using Python 

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-26T17:03:57.588868Z",
     "start_time": "2019-02-26T17:03:55.460102Z"
    }
   },
   "outputs": [],
   "source": [
    "# importing libraries for data handling and analysis\n",
    "import pandas as pd\n",
    "from pandas.plotting import scatter_matrix\n",
    "from pandas import ExcelWriter\n",
    "from pandas import ExcelFile\n",
    "from openpyxl import load_workbook\n",
    "import numpy as np\n",
    "from scipy.stats import norm, skew\n",
    "from scipy import stats\n",
    "import statsmodels.api as sm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-26T17:03:58.509004Z",
     "start_time": "2019-02-26T17:03:57.735796Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": 
       "* plotly.js v1.44.3\n",
       "* Copyright 2012-2019, Plotly, Inc.\n",
       "* All rights reserved.\n",
       "* Licensed under the MIT license\n",
       "*/\n",

 "import re\n",
    "import sys\n",
    "import timeit\n",
    "import string\n",
    "from datetime import datetime\n",
    "from time import time\n",
    "from dateutil.parser import parse\n",
    "# ip = get_ipython()\n",
    "# ip.register_magics(jupyternotify.JupyterNotifyMagics)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-26T17:04:13.722057Z",
     "start_time": "2019-02-26T17:04:13.190727Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape of dataframe is: (1470, 35)\n"
     "end_time": "2019-02-26T17:04:17.560239Z",
     "start_time": "2019-02-26T17:04:17.496713Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "