demo.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from varclushi import VarClusHi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<varclushi.varclushi.VarClusHi at 0x15f96e35e10>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "demo1_df = pd.read_csv('https://archive.ics.uci.edu/ml/machine-learning-databases/wine-quality/winequality-red.csv', sep=';')\n",
    "demo1_df.drop('quality',axis=1,inplace=True)\n",
    "demo1_vc = VarClusHi(demo1_df)\n",
    "demo1_vc.varclus()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "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>Cluster</th>\n",
       "      <th>N_Vars</th>\n",
       "      <th>Eigval1</th>\n",
       "      <th>Eigval2</th>\n",
       "      <th>VarProp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.141357</td>\n",
       "      <td>0.658413</td>\n",
       "      <td>0.713786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1.766885</td>\n",
       "      <td>0.900991</td>\n",
       "      <td>0.588962</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.371260</td>\n",
       "      <td>0.628740</td>\n",
       "      <td>0.685630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.552496</td>\n",
       "      <td>0.447504</td>\n",
       "      <td>0.776248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Cluster N_Vars   Eigval1   Eigval2   VarProp\n",
       "0       0      3  2.141357  0.658413  0.713786\n",
       "1       1      3  1.766885  0.900991  0.588962\n",
       "2       2      2  1.371260  0.628740  0.685630\n",
       "3       3      2  1.552496  0.447504  0.776248\n",
       "4       4      1  1.000000  0.000000  1.000000"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "demo1_vc.info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Cluster</th>\n",
       "      <th>Variable</th>\n",
       "      <th>RS_Own</th>\n",
       "      <th>RS_NC</th>\n",
       "      <th>RS_Ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>fixed acidity</td>\n",
       "      <td>0.882210</td>\n",
       "      <td>0.277256</td>\n",
       "      <td>0.162976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>density</td>\n",
       "      <td>0.622070</td>\n",
       "      <td>0.246194</td>\n",
       "      <td>0.501362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>pH</td>\n",
       "      <td>0.637076</td>\n",
       "      <td>0.194359</td>\n",
       "      <td>0.450478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>free sulfur dioxide</td>\n",
       "      <td>0.777796</td>\n",
       "      <td>0.010358</td>\n",
       "      <td>0.224530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>total sulfur dioxide</td>\n",
       "      <td>0.786660</td>\n",
       "      <td>0.042294</td>\n",
       "      <td>0.222761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>residual sugar</td>\n",
       "      <td>0.202428</td>\n",
       "      <td>0.045424</td>\n",
       "      <td>0.835525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2</td>\n",
       "      <td>sulphates</td>\n",
       "      <td>0.685630</td>\n",
       "      <td>0.106022</td>\n",
       "      <td>0.351653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>chlorides</td>\n",
       "      <td>0.685630</td>\n",
       "      <td>0.048903</td>\n",
       "      <td>0.330534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3</td>\n",
       "      <td>citric acid</td>\n",
       "      <td>0.776248</td>\n",
       "      <td>0.398208</td>\n",
       "      <td>0.371810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3</td>\n",
       "      <td>volatile acidity</td>\n",
       "      <td>0.776248</td>\n",
       "      <td>0.040920</td>\n",
       "      <td>0.233299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>4</td>\n",
       "      <td>alcohol</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.082055</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Cluster              Variable    RS_Own     RS_NC  RS_Ratio\n",
       "0        0         fixed acidity  0.882210  0.277256  0.162976\n",
       "1        0               density  0.622070  0.246194  0.501362\n",
       "2        0                    pH  0.637076  0.194359  0.450478\n",
       "3        1   free sulfur dioxide  0.777796  0.010358  0.224530\n",
       "4        1  total sulfur dioxide  0.786660  0.042294  0.222761\n",
       "5        1        residual sugar  0.202428  0.045424  0.835525\n",
       "6        2             sulphates  0.685630  0.106022  0.351653\n",
       "7        2             chlorides  0.685630  0.048903  0.330534\n",
       "8        3           citric acid  0.776248  0.398208  0.371810\n",
       "9        3      volatile acidity  0.776248  0.040920  0.233299\n",
       "10       4               alcohol  1.000000  0.082055  0.000000"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "demo1_vc.rsquare"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<varclushi.varclushi.VarClusHi at 0x15f920cd7b8>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "demo2_df = pd.read_excel('jobrate.xlsx')\n",
    "demo2_df.drop('Overall_Rating',axis=1,inplace=True)\n",
    "demo2_vc = VarClusHi(demo2_df,maxeigval2=0,maxclus=3)\n",
    "demo2_vc.varclus()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>Cluster</th>\n",
       "      <th>N_Vars</th>\n",
       "      <th>Eigval1</th>\n",
       "      <th>Eigval2</th>\n",
       "      <th>VarProp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>4.663086</td>\n",
       "      <td>0.715184</td>\n",
       "      <td>0.582886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>3.039960</td>\n",
       "      <td>0.456049</td>\n",
       "      <td>0.759990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Cluster N_Vars   Eigval1   Eigval2   VarProp\n",
       "0       0      8  4.663086  0.715184  0.582886\n",
       "1       1      4  3.039960  0.456049  0.759990\n",
       "2       2      1  1.000000  0.000000  1.000000"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "demo2_vc.info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Cluster</th>\n",
       "      <th>Variable</th>\n",
       "      <th>RS_Own</th>\n",
       "      <th>RS_NC</th>\n",
       "      <th>RS_Ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Communication_Skills</td>\n",
       "      <td>0.633771</td>\n",
       "      <td>0.326972</td>\n",
       "      <td>0.544151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>Problem_Solving</td>\n",
       "      <td>0.507940</td>\n",
       "      <td>0.273017</td>\n",
       "      <td>0.676852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>Learning_Ability</td>\n",
       "      <td>0.612599</td>\n",
       "      <td>0.126570</td>\n",
       "      <td>0.443540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>Observational_Skills</td>\n",
       "      <td>0.657120</td>\n",
       "      <td>0.182641</td>\n",
       "      <td>0.419498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>Willingness_to_Confront_Problems</td>\n",
       "      <td>0.620156</td>\n",
       "      <td>0.237397</td>\n",
       "      <td>0.498089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>Desire_for_Self_Improvement</td>\n",
       "      <td>0.604388</td>\n",
       "      <td>0.296961</td>\n",
       "      <td>0.562717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>Appearance</td>\n",
       "      <td>0.441876</td>\n",
       "      <td>0.145928</td>\n",
       "      <td>0.653485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>Dependability</td>\n",
       "      <td>0.585235</td>\n",
       "      <td>0.453685</td>\n",
       "      <td>0.759205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>Judgement_under_Pressure</td>\n",
       "      <td>0.640120</td>\n",
       "      <td>0.367677</td>\n",
       "      <td>0.569139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>Interest_in_People</td>\n",
       "      <td>0.838905</td>\n",
       "      <td>0.233862</td>\n",
       "      <td>0.210268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>Interpersonal_Sensitivity</td>\n",
       "      <td>0.804705</td>\n",
       "      <td>0.178482</td>\n",
       "      <td>0.237724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1</td>\n",
       "      <td>Integrity</td>\n",
       "      <td>0.756230</td>\n",
       "      <td>0.338525</td>\n",
       "      <td>0.368525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2</td>\n",
       "      <td>Physical_Ability</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.222030</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Cluster                          Variable    RS_Own     RS_NC  RS_Ratio\n",
       "0        0              Communication_Skills  0.633771  0.326972  0.544151\n",
       "1        0                   Problem_Solving  0.507940  0.273017  0.676852\n",
       "2        0                  Learning_Ability  0.612599  0.126570  0.443540\n",
       "3        0              Observational_Skills  0.657120  0.182641  0.419498\n",
       "4        0  Willingness_to_Confront_Problems  0.620156  0.237397  0.498089\n",
       "5        0       Desire_for_Self_Improvement  0.604388  0.296961  0.562717\n",
       "6        0                        Appearance  0.441876  0.145928  0.653485\n",
       "7        0                     Dependability  0.585235  0.453685  0.759205\n",
       "8        1          Judgement_under_Pressure  0.640120  0.367677  0.569139\n",
       "9        1                Interest_in_People  0.838905  0.233862  0.210268\n",
       "10       1         Interpersonal_Sensitivity  0.804705  0.178482  0.237724\n",
       "11       1                         Integrity  0.756230  0.338525  0.368525\n",
       "12       2                  Physical_Ability  1.000000  0.222030  0.000000"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "demo2_vc.rsquare"
   ]
  }
 ],
 "metadata": {
  "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}