{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Kernel Density Estimation. Plotly plot of the joint pdf and marginal pdf estimations" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Read data from an Excel file:" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Index([u'multiannual', u'bachelor-th'], dtype='object')" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "xl = pd.ExcelFile(\"CSCEng.xls\")\n", "dfc = xl.parse(\"Sheet1\")\n", "dfc.columns" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | multiannual | \n", "bachelor-th | \n", "
---|---|---|
0 | \n", "8.01 | \n", "7.95 | \n", "
1 | \n", "8.63 | \n", "8.63 | \n", "
2 | \n", "7.03 | \n", "8.37 | \n", "
3 | \n", "8.53 | \n", "8.05 | \n", "
4 | \n", "8.41 | \n", "9.53 | \n", "