analysis_template.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "colab_type": "text",
    "id": "RarNoE4PSXyr"
   },
   "source": [
    "# Marketing Case Study Analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "colab": {},
    "colab_type": "code",
    "id": "Xj5WSaLYSXys",
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "#read data\n",
    "data = pd.read_csv('dataset-students.csv', sep=',')  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Alter</th>\n",
       "      <th>Beruf</th>\n",
       "      <th>Familienstand</th>\n",
       "      <th>Bildung</th>\n",
       "      <th>Kreditverpflichtung</th>\n",
       "      <th>Wohnsituation</th>\n",
       "      <th>Kredit</th>\n",
       "      <th>Kontakt</th>\n",
       "      <th>Monat</th>\n",
       "      <th>Wochentag</th>\n",
       "      <th>...</th>\n",
       "      <th>Kampagne</th>\n",
       "      <th>Kontaktversuche</th>\n",
       "      <th>Vorherige Kontaktanzahl</th>\n",
       "      <th>Vorheriges Ergebnis</th>\n",
       "      <th>Arbeitslosenquote</th>\n",
       "      <th>Verbraucherpreisindex</th>\n",
       "      <th>Verbraucher-Konfidenzindex</th>\n",
       "      <th>Euribor 3M</th>\n",
       "      <th>Arbeitnehmerquote</th>\n",
       "      <th>y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>56</td>\n",
       "      <td>Service</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Hauptschule</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>Telefon</td>\n",
       "      <td>Mai</td>\n",
       "      <td>Montag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>57</td>\n",
       "      <td>Dienstleistungen</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Hochschulreife</td>\n",
       "      <td>unbekannt</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>Telefon</td>\n",
       "      <td>Mai</td>\n",
       "      <td>Montag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>37</td>\n",
       "      <td>Dienstleistungen</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Hochschulreife</td>\n",
       "      <td>nein</td>\n",
       "      <td>ja</td>\n",
       "      <td>nein</td>\n",
       "      <td>Telefon</td>\n",
       "      <td>Mai</td>\n",
       "      <td>Montag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40</td>\n",
       "      <td>Verwaltung</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Realschule</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>Telefon</td>\n",
       "      <td>Mai</td>\n",
       "      <td>Montag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>56</td>\n",
       "      <td>Dienstleistungen</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Hochschulreife</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>ja</td>\n",
       "      <td>Telefon</td>\n",
       "      <td>Mai</td>\n",
       "      <td>Montag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Alter             Beruf Familienstand         Bildung Kreditverpflichtung  \\\n",
       "0     56           Service   Verheiratet     Hauptschule                nein   \n",
       "1     57  Dienstleistungen   Verheiratet  Hochschulreife           unbekannt   \n",
       "2     37  Dienstleistungen   Verheiratet  Hochschulreife                nein   \n",
       "3     40        Verwaltung   Verheiratet      Realschule                nein   \n",
       "4     56  Dienstleistungen   Verheiratet  Hochschulreife                nein   \n",
       "\n",
       "  Wohnsituation Kredit  Kontakt Monat Wochentag  ...  Kampagne  \\\n",
       "0          nein   nein  Telefon   Mai    Montag  ...         1   \n",
       "1          nein   nein  Telefon   Mai    Montag  ...         1   \n",
       "2            ja   nein  Telefon   Mai    Montag  ...         1   \n",
       "3          nein   nein  Telefon   Mai    Montag  ...         1   \n",
       "4          nein     ja  Telefon   Mai    Montag  ...         1   \n",
       "\n",
       "   Kontaktversuche  Vorherige Kontaktanzahl  Vorheriges Ergebnis  \\\n",
       "0              999                        0      Nicht vorhanden   \n",
       "1              999                        0      Nicht vorhanden   \n",
       "2              999                        0      Nicht vorhanden   \n",
       "3              999                        0      Nicht vorhanden   \n",
       "4              999                        0      Nicht vorhanden   \n",
       "\n",
       "  Arbeitslosenquote  Verbraucherpreisindex  Verbraucher-Konfidenzindex  \\\n",
       "0               1.1                 93.994                       -36.4   \n",
       "1               1.1                 93.994                       -36.4   \n",
       "2               1.1                 93.994                       -36.4   \n",
       "3               1.1                 93.994                       -36.4   \n",
       "4               1.1                 93.994                       -36.4   \n",
       "\n",
       "   Euribor 3M  Arbeitnehmerquote     y  \n",
       "0       4.857             5191.0  nein  \n",
       "1       4.857             5191.0  nein  \n",
       "2       4.857             5191.0  nein  \n",
       "3       4.857             5191.0  nein  \n",
       "4       4.857             5191.0  nein  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Alter</th>\n",
       "      <th>Dauer</th>\n",
       "      <th>Kampagne</th>\n",
       "      <th>Kontaktversuche</th>\n",
       "      <th>Vorherige Kontaktanzahl</th>\n",
       "      <th>Arbeitslosenquote</th>\n",
       "      <th>Verbraucherpreisindex</th>\n",
       "      <th>Verbraucher-Konfidenzindex</th>\n",
       "      <th>Euribor 3M</th>\n",
       "      <th>Arbeitnehmerquote</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>41188.00000</td>\n",
       "      <td>41188.000000</td>\n",
       "      <td>41188.000000</td>\n",
       "      <td>41188.000000</td>\n",
       "      <td>41188.000000</td>\n",
       "      <td>41188.000000</td>\n",
       "      <td>41188.000000</td>\n",
       "      <td>41188.000000</td>\n",
       "      <td>41188.000000</td>\n",
       "      <td>41188.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>40.02406</td>\n",
       "      <td>258.285010</td>\n",
       "      <td>2.567593</td>\n",
       "      <td>962.475454</td>\n",
       "      <td>0.172963</td>\n",
       "      <td>0.081886</td>\n",
       "      <td>93.575664</td>\n",
       "      <td>-40.502600</td>\n",
       "      <td>3.621291</td>\n",
       "      <td>5167.035911</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>10.42125</td>\n",
       "      <td>259.279249</td>\n",
       "      <td>2.770014</td>\n",
       "      <td>186.910907</td>\n",
       "      <td>0.494901</td>\n",
       "      <td>1.570960</td>\n",
       "      <td>0.578840</td>\n",
       "      <td>4.628198</td>\n",
       "      <td>1.734447</td>\n",
       "      <td>72.251528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>17.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-3.400000</td>\n",
       "      <td>92.201000</td>\n",
       "      <td>-50.800000</td>\n",
       "      <td>0.634000</td>\n",
       "      <td>4963.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>32.00000</td>\n",
       "      <td>102.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>999.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-1.800000</td>\n",
       "      <td>93.075000</td>\n",
       "      <td>-42.700000</td>\n",
       "      <td>1.344000</td>\n",
       "      <td>5099.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>38.00000</td>\n",
       "      <td>180.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>999.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.100000</td>\n",
       "      <td>93.749000</td>\n",
       "      <td>-41.800000</td>\n",
       "      <td>4.857000</td>\n",
       "      <td>5191.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>47.00000</td>\n",
       "      <td>319.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>999.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>93.994000</td>\n",
       "      <td>-36.400000</td>\n",
       "      <td>4.961000</td>\n",
       "      <td>5228.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>98.00000</td>\n",
       "      <td>4918.000000</td>\n",
       "      <td>56.000000</td>\n",
       "      <td>999.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>1.400000</td>\n",
       "      <td>94.767000</td>\n",
       "      <td>-26.900000</td>\n",
       "      <td>5.045000</td>\n",
       "      <td>5228.100000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Alter         Dauer      Kampagne  Kontaktversuche  \\\n",
       "count  41188.00000  41188.000000  41188.000000     41188.000000   \n",
       "mean      40.02406    258.285010      2.567593       962.475454   \n",
       "std       10.42125    259.279249      2.770014       186.910907   \n",
       "min       17.00000      0.000000      1.000000         0.000000   \n",
       "25%       32.00000    102.000000      1.000000       999.000000   \n",
       "50%       38.00000    180.000000      2.000000       999.000000   \n",
       "75%       47.00000    319.000000      3.000000       999.000000   \n",
       "max       98.00000   4918.000000     56.000000       999.000000   \n",
       "\n",
       "       Vorherige Kontaktanzahl  Arbeitslosenquote  Verbraucherpreisindex  \\\n",
       "count             41188.000000       41188.000000           41188.000000   \n",
       "mean                  0.172963           0.081886              93.575664   \n",
       "std                   0.494901           1.570960               0.578840   \n",
       "min                   0.000000          -3.400000              92.201000   \n",
       "25%                   0.000000          -1.800000              93.075000   \n",
       "50%                   0.000000           1.100000              93.749000   \n",
       "75%                   0.000000           1.400000              93.994000   \n",
       "max                   7.000000           1.400000              94.767000   \n",
       "\n",
       "       Verbraucher-Konfidenzindex    Euribor 3M  Arbeitnehmerquote  \n",
       "count                41188.000000  41188.000000       41188.000000  \n",
       "mean                   -40.502600      3.621291        5167.035911  \n",
       "std                      4.628198      1.734447          72.251528  \n",
       "min                    -50.800000      0.634000        4963.600000  \n",
       "25%                    -42.700000      1.344000        5099.100000  \n",
       "50%                    -41.800000      4.857000        5191.000000  \n",
       "75%                    -36.400000      4.961000        5228.100000  \n",
       "max                    -26.900000      5.045000        5228.100000  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "display(data.head())\n",
    "data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Alter</th>\n",
       "      <th>Beruf</th>\n",
       "      <th>Familienstand</th>\n",
       "      <th>Bildung</th>\n",
       "      <th>Kreditverpflichtung</th>\n",
       "      <th>Wohnsituation</th>\n",
       "      <th>Kredit</th>\n",
       "      <th>Kontakt</th>\n",
       "      <th>Monat</th>\n",
       "      <th>Wochentag</th>\n",
       "      <th>...</th>\n",
       "      <th>Kampagne</th>\n",
       "      <th>Kontaktversuche</th>\n",
       "      <th>Vorherige Kontaktanzahl</th>\n",
       "      <th>Vorheriges Ergebnis</th>\n",
       "      <th>Arbeitslosenquote</th>\n",
       "      <th>Verbraucherpreisindex</th>\n",
       "      <th>Verbraucher-Konfidenzindex</th>\n",
       "      <th>Euribor 3M</th>\n",
       "      <th>Arbeitnehmerquote</th>\n",
       "      <th>y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>56</td>\n",
       "      <td>Service</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Hauptschule</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>Telefon</td>\n",
       "      <td>Mai</td>\n",
       "      <td>Montag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>57</td>\n",
       "      <td>Dienstleistungen</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Hochschulreife</td>\n",
       "      <td>unbekannt</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>Telefon</td>\n",
       "      <td>Mai</td>\n",
       "      <td>Montag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>37</td>\n",
       "      <td>Dienstleistungen</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Hochschulreife</td>\n",
       "      <td>nein</td>\n",
       "      <td>ja</td>\n",
       "      <td>nein</td>\n",
       "      <td>Telefon</td>\n",
       "      <td>Mai</td>\n",
       "      <td>Montag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40</td>\n",
       "      <td>Verwaltung</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Realschule</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>Telefon</td>\n",
       "      <td>Mai</td>\n",
       "      <td>Montag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>56</td>\n",
       "      <td>Dienstleistungen</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Hochschulreife</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>ja</td>\n",
       "      <td>Telefon</td>\n",
       "      <td>Mai</td>\n",
       "      <td>Montag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>1.1</td>\n",
       "      <td>93.994</td>\n",
       "      <td>-36.4</td>\n",
       "      <td>4.857</td>\n",
       "      <td>5191.0</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41183</th>\n",
       "      <td>73</td>\n",
       "      <td>Rentne</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Berufliche Weiterbildung</td>\n",
       "      <td>nein</td>\n",
       "      <td>ja</td>\n",
       "      <td>nein</td>\n",
       "      <td>Online</td>\n",
       "      <td>November</td>\n",
       "      <td>Freitag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>-1.1</td>\n",
       "      <td>94.767</td>\n",
       "      <td>-50.8</td>\n",
       "      <td>1.028</td>\n",
       "      <td>4963.6</td>\n",
       "      <td>ja</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41184</th>\n",
       "      <td>46</td>\n",
       "      <td>Industrie</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Berufliche Weiterbildung</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>Online</td>\n",
       "      <td>November</td>\n",
       "      <td>Freitag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>-1.1</td>\n",
       "      <td>94.767</td>\n",
       "      <td>-50.8</td>\n",
       "      <td>1.028</td>\n",
       "      <td>4963.6</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41185</th>\n",
       "      <td>56</td>\n",
       "      <td>Rentne</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Universitätsabschluss</td>\n",
       "      <td>nein</td>\n",
       "      <td>ja</td>\n",
       "      <td>nein</td>\n",
       "      <td>Online</td>\n",
       "      <td>November</td>\n",
       "      <td>Freitag</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>-1.1</td>\n",
       "      <td>94.767</td>\n",
       "      <td>-50.8</td>\n",
       "      <td>1.028</td>\n",
       "      <td>4963.6</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41186</th>\n",
       "      <td>44</td>\n",
       "      <td>Technik</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Berufliche Weiterbildung</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>nein</td>\n",
       "      <td>Online</td>\n",
       "      <td>November</td>\n",
       "      <td>Freitag</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>999</td>\n",
       "      <td>0</td>\n",
       "      <td>Nicht vorhanden</td>\n",
       "      <td>-1.1</td>\n",
       "      <td>94.767</td>\n",
       "      <td>-50.8</td>\n",
       "      <td>1.028</td>\n",
       "      <td>4963.6</td>\n",
       "      <td>ja</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41187</th>\n",
       "      <td>74</td>\n",
       "      <td>Rentne</td>\n",
       "      <td>Verheiratet</td>\n",
       "      <td>Berufliche Weiterbildung</td>\n",
       "      <td>nein</td>\n",
       "      <td>ja</td>\n",
       "      <td>nein</td>\n",
       "      <td>Online</td>\n",
       "      <td>November</td>\n",
       "      <td>Freitag</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>999</td>\n",
       "      <td>1</td>\n",
       "      <td>Fehlschlag</td>\n",
       "      <td>-1.1</td>\n",
       "      <td>94.767</td>\n",
       "      <td>-50.8</td>\n",
       "      <td>1.028</td>\n",
       "      <td>4963.6</td>\n",
       "      <td>nein</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>41188 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Alter             Beruf Familienstand                   Bildung  \\\n",
       "0         56           Service   Verheiratet               Hauptschule   \n",
       "1         57  Dienstleistungen   Verheiratet            Hochschulreife   \n",
       "2         37  Dienstleistungen   Verheiratet            Hochschulreife   \n",
       "3         40        Verwaltung   Verheiratet                Realschule   \n",
       "4         56  Dienstleistungen   Verheiratet            Hochschulreife   \n",
       "...      ...               ...           ...                       ...   \n",
       "41183     73            Rentne   Verheiratet  Berufliche Weiterbildung   \n",
       "41184     46         Industrie   Verheiratet  Berufliche Weiterbildung   \n",
       "41185     56            Rentne   Verheiratet     Universitätsabschluss   \n",
       "41186     44           Technik   Verheiratet  Berufliche Weiterbildung   \n",
       "41187     74            Rentne   Verheiratet  Berufliche Weiterbildung   \n",
       "\n",
       "      Kreditverpflichtung Wohnsituation Kredit  Kontakt     Monat Wochentag  \\\n",
       "0                    nein          nein   nein  Telefon       Mai    Montag   \n",
       "1               unbekannt          nein   nein  Telefon       Mai    Montag   \n",
       "2                    nein            ja   nein  Telefon       Mai    Montag   \n",
       "3                    nein          nein   nein  Telefon       Mai    Montag   \n",
       "4                    nein          nein     ja  Telefon       Mai    Montag   \n",
       "...                   ...           ...    ...      ...       ...       ...   \n",
       "41183                nein            ja   nein   Online  November   Freitag   \n",
       "41184                nein          nein   nein   Online  November   Freitag   \n",
       "41185                nein            ja   nein   Online  November   Freitag   \n",
       "41186                nein          nein   nein   Online  November   Freitag   \n",
       "41187                nein            ja   nein   Online  November   Freitag   \n",
       "\n",
       "       ...  Kampagne  Kontaktversuche  Vorherige Kontaktanzahl  \\\n",
       "0      ...         1              999                        0   \n",
       "1      ...         1              999                        0   \n",
       "2      ...         1              999                        0   \n",
       "3      ...         1              999                        0   \n",
       "4      ...         1              999                        0   \n",
       "...    ...       ...              ...                      ...   \n",
       "41183  ...         1              999                        0   \n",
       "41184  ...         1              999                        0   \n",
       "41185  ...         2              999                        0   \n",
       "41186  ...         1              999                        0   \n",
       "41187  ...         3              999                        1   \n",
       "\n",
       "       Vorheriges Ergebnis Arbeitslosenquote  Verbraucherpreisindex  \\\n",
       "0          Nicht vorhanden               1.1                 93.994   \n",
       "1          Nicht vorhanden               1.1                 93.994   \n",
       "2          Nicht vorhanden               1.1                 93.994   \n",
       "3          Nicht vorhanden               1.1                 93.994   \n",
       "4          Nicht vorhanden               1.1                 93.994   \n",
       "...                    ...               ...                    ...   \n",
       "41183      Nicht vorhanden              -1.1                 94.767   \n",
       "41184      Nicht vorhanden              -1.1                 94.767   \n",
       "41185      Nicht vorhanden              -1.1                 94.767   \n",
       "41186      Nicht vorhanden              -1.1                 94.767   \n",
       "41187           Fehlschlag              -1.1                 94.767   \n",
       "\n",
       "       Verbraucher-Konfidenzindex  Euribor 3M  Arbeitnehmerquote     y  \n",
       "0                           -36.4       4.857             5191.0  nein  \n",
       "1                           -36.4       4.857             5191.0  nein  \n",
       "2                           -36.4       4.857             5191.0  nein  \n",
       "3                           -36.4       4.857             5191.0  nein  \n",
       "4                           -36.4       4.857             5191.0  nein  \n",
       "...                           ...         ...                ...   ...  \n",
       "41183                       -50.8       1.028             4963.6    ja  \n",
       "41184                       -50.8       1.028             4963.6  nein  \n",
       "41185                       -50.8       1.028             4963.6  nein  \n",
       "41186                       -50.8       1.028             4963.6    ja  \n",
       "41187                       -50.8       1.028             4963.6  nein  \n",
       "\n",
       "[41188 rows x 21 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# From here you can do whatever you want with the data\n",
    "# For example:\n",
    "# Use a random forest classifier from the scikit-learn library\n",
    "# Or use imbalanced-learn to deal with the class imbalance of the target variable"
   ]
  }
 ],
 "metadata": {
  "colab": {
   "collapsed_sections": [],
   "name": "Bank-Marketing-Template.ipynb",
   "provenance": []
  },
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}