[12/15] madlib-site git commit: jupyter notebooks for 1.14 release
http://git-wip-us.apache.org/repos/asf/madlib-site/blob/418f361c/community-artifacts/Encoding-categorical-variables-1dot10-v1.ipynb
--
diff --git a/community-artifacts/Encoding-categorical-variables-1dot10-v1.ipynb
b/community-artifacts/Encoding-categorical-variables-1dot10-v1.ipynb
deleted file mode 100644
index 409de20..000
--- a/community-artifacts/Encoding-categorical-variables-1dot10-v1.ipynb
+++ /dev/null
@@ -1,2748 +0,0 @@
-{
- "cells": [
- {
- "cell_type": "markdown",
- "metadata": {},
- "source": [
-"# Encoding categorical variables (MADlib v1.10+)\n",
-"This is the new module that replaces create_indicator_variables() which
has been deprecated as of MADlib v1.10"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 44,
- "metadata": {
-"collapsed": false
- },
- "outputs": [
-{
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "The sql extension is already loaded. To reload it, use:\n",
- " %reload_ext sql\n"
- ]
-}
- ],
- "source": [
-"%load_ext sql"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 45,
- "metadata": {
-"collapsed": false
- },
- "outputs": [
-{
- "data": {
- "text/plain": [
- "u'Connected: gpdbchina@madlib'"
- ]
- },
- "execution_count": 45,
- "metadata": {},
- "output_type": "execute_result"
-}
- ],
- "source": [
-"%sql postgresql://gpdbchina@10.194.10.68:55000/madlib\n",
-"#%sql postgresql://fmcquillan@localhost:5432/madlib\n",
-"#%sql postgresql://gpadmin@54.197.30.46:10432/gpadmin"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 46,
- "metadata": {
-"collapsed": false
- },
- "outputs": [
-{
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "1 rows affected.\n"
- ]
-},
-{
- "data": {
- "text/html": [
- "\n",
- "\n",
- "version\n",
- "\n",
- "\n",
- "MADlib version: 1.10.0-dev, git revision:
rel/v1.9.1-47-g2d5a5ed, cmake configuration time: Tue Feb 7 19:45:19 UTC 2017,
build type: Release, build system: Linux-2.6.18-238.27.1.el5.hotfix.bz516490, C
compiler: gcc 4.4.0, C++ compiler: g++ 4.4.0\n",
- "\n",
- ""
- ],
- "text/plain": [
- "[(u'MADlib version: 1.10.0-dev, git revision: rel/v1.9.1-47-g2d5a5ed,
cmake configuration time: Tue Feb 7 19:45:19 UTC 2017, build type: Release,
build system: Linux-2.6.18-238.27.1.el5.hotfix.bz516490, C compiler: gcc 4.4.0,
C++ compiler: g++ 4.4.0',)]"
- ]
- },
- "execution_count": 46,
- "metadata": {},
- "output_type": "execute_result"
-}
- ],
- "source": [
-"%sql select madlib.version();\n",
-"#%sql select version();"
- ]
- },
- {
- "cell_type": "markdown",
- "metadata": {},
- "source": [
-"## 1. Load data set\n",
-"Use a subset of the abalone dataset:"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 47,
- "metadata": {
-"collapsed": false
- },
- "outputs": [
-{
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "Done.\n",
- "Done.\n",
- "20 rows affected.\n",
- "20 rows affected.\n"
- ]
-},
-{
- "data": {
- "text/html": [
- "\n",
- "\n",
- "id\n",
- "sex\n",
- "length\n",
- "diameter\n",
- "height\n",
- "rings\n",
- "\n",
- "\n",
- "1\n",
- "M\n",
- "0.455\n",
- "0.365\n",
- "0.095\n",
- "15\n",
- "\n",
- "\n",
- "2\n",
- "M\n",
- "0.35\n",
- "0.265\n",
- "0.09\n",
- "7\n",
- "\n",
- "\n",
- "3\n",
- "F\n",
- "0.53\n",
- "0.42\n",
- "0.135\n",
- "9\n",
- "\n",
- "\n",
- "4\n",
- "M\n",
- "0.44\n",
- "0.365\n",
- "0.125\n",
- "10\n",
- "\n",
- "\n",
- "5\n",
- "I\n",
- "0.33\n",
- "0.255\n",
- "0.08\n",
- "7\n",
- "\n",
- "\n",
- "6\n",
- "I\n",
- "0.425\n",
- "0.3\n",
- "0.095\n",
- "8\n",
- "\n",
- "\n",
- "7\n",
- "F\n",
- "0.53\n",
- "0.415\n",
- "0.15\n",
- "20\n",
- "\n",
- "\n",
- "8\n",
- "F\n",
- "
[12/15] madlib-site git commit: jupyter notebooks for 1.14 release
http://git-wip-us.apache.org/repos/asf/madlib-site/blob/3f849b9e/community-artifacts/Encoding-categorical-variables-1dot10-v1.ipynb
--
diff --git a/community-artifacts/Encoding-categorical-variables-1dot10-v1.ipynb
b/community-artifacts/Encoding-categorical-variables-1dot10-v1.ipynb
deleted file mode 100644
index 409de20..000
--- a/community-artifacts/Encoding-categorical-variables-1dot10-v1.ipynb
+++ /dev/null
@@ -1,2748 +0,0 @@
-{
- "cells": [
- {
- "cell_type": "markdown",
- "metadata": {},
- "source": [
-"# Encoding categorical variables (MADlib v1.10+)\n",
-"This is the new module that replaces create_indicator_variables() which
has been deprecated as of MADlib v1.10"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 44,
- "metadata": {
-"collapsed": false
- },
- "outputs": [
-{
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "The sql extension is already loaded. To reload it, use:\n",
- " %reload_ext sql\n"
- ]
-}
- ],
- "source": [
-"%load_ext sql"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 45,
- "metadata": {
-"collapsed": false
- },
- "outputs": [
-{
- "data": {
- "text/plain": [
- "u'Connected: gpdbchina@madlib'"
- ]
- },
- "execution_count": 45,
- "metadata": {},
- "output_type": "execute_result"
-}
- ],
- "source": [
-"%sql postgresql://gpdbchina@10.194.10.68:55000/madlib\n",
-"#%sql postgresql://fmcquillan@localhost:5432/madlib\n",
-"#%sql postgresql://gpadmin@54.197.30.46:10432/gpadmin"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 46,
- "metadata": {
-"collapsed": false
- },
- "outputs": [
-{
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "1 rows affected.\n"
- ]
-},
-{
- "data": {
- "text/html": [
- "\n",
- "\n",
- "version\n",
- "\n",
- "\n",
- "MADlib version: 1.10.0-dev, git revision:
rel/v1.9.1-47-g2d5a5ed, cmake configuration time: Tue Feb 7 19:45:19 UTC 2017,
build type: Release, build system: Linux-2.6.18-238.27.1.el5.hotfix.bz516490, C
compiler: gcc 4.4.0, C++ compiler: g++ 4.4.0\n",
- "\n",
- ""
- ],
- "text/plain": [
- "[(u'MADlib version: 1.10.0-dev, git revision: rel/v1.9.1-47-g2d5a5ed,
cmake configuration time: Tue Feb 7 19:45:19 UTC 2017, build type: Release,
build system: Linux-2.6.18-238.27.1.el5.hotfix.bz516490, C compiler: gcc 4.4.0,
C++ compiler: g++ 4.4.0',)]"
- ]
- },
- "execution_count": 46,
- "metadata": {},
- "output_type": "execute_result"
-}
- ],
- "source": [
-"%sql select madlib.version();\n",
-"#%sql select version();"
- ]
- },
- {
- "cell_type": "markdown",
- "metadata": {},
- "source": [
-"## 1. Load data set\n",
-"Use a subset of the abalone dataset:"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 47,
- "metadata": {
-"collapsed": false
- },
- "outputs": [
-{
- "name": "stdout",
- "output_type": "stream",
- "text": [
- "Done.\n",
- "Done.\n",
- "20 rows affected.\n",
- "20 rows affected.\n"
- ]
-},
-{
- "data": {
- "text/html": [
- "\n",
- "\n",
- "id\n",
- "sex\n",
- "length\n",
- "diameter\n",
- "height\n",
- "rings\n",
- "\n",
- "\n",
- "1\n",
- "M\n",
- "0.455\n",
- "0.365\n",
- "0.095\n",
- "15\n",
- "\n",
- "\n",
- "2\n",
- "M\n",
- "0.35\n",
- "0.265\n",
- "0.09\n",
- "7\n",
- "\n",
- "\n",
- "3\n",
- "F\n",
- "0.53\n",
- "0.42\n",
- "0.135\n",
- "9\n",
- "\n",
- "\n",
- "4\n",
- "M\n",
- "0.44\n",
- "0.365\n",
- "0.125\n",
- "10\n",
- "\n",
- "\n",
- "5\n",
- "I\n",
- "0.33\n",
- "0.255\n",
- "0.08\n",
- "7\n",
- "\n",
- "\n",
- "6\n",
- "I\n",
- "0.425\n",
- "0.3\n",
- "0.095\n",
- "8\n",
- "\n",
- "\n",
- "7\n",
- "F\n",
- "0.53\n",
- "0.415\n",
- "0.15\n",
- "20\n",
- "\n",
- "\n",
- "8\n",
- "F\n",
- "
