Add explanation of how to connect to MySQL / Postgres

jvns · jvns · commit afea4ded1bba · 2014-02-21T10:16:56.000-08:00
diff --git a/cookbook/Chapter 4 - Find out on which weekday people bike the most with groupby and aggregate.ipynb b/cookbook/Chapter 4 - Find out on which weekday people bike the most with groupby and aggregate.ipynb
@@ -590,7 +590,7 @@
      "source": [
       "Let's put all that together, to prove how easy it is. 6 lines of magical pandas!\n",
       "\n",
-      "If you want to play around, try changing `sum` to `max`, `np.median`, or any other function you like."
+      "If you want to play around, try changing `sum` to `max`, `numpy.median`, or any other function you like."
      ]
     },
     {
diff --git a/cookbook/Chapter 9 - Loading data from SQL databases.ipynb b/cookbook/Chapter 9 - Loading data from SQL databases.ipynb
@@ -456,6 +456,49 @@
       "`pd.read_sql(\"SELECT whatever from your_table\", con)`"
      ]
     },
+    {
+     "cell_type": "markdown",
+     "metadata": {},
+     "source": [
+      "# 9.3 Connecting to other kinds of database"
+     ]
+    },
+    {
+     "cell_type": "markdown",
+     "metadata": {},
+     "source": [
+      "To connect to a MySQL database:"
+     ]
+    },
+    {
+     "cell_type": "code",
+     "collapsed": false,
+     "input": [
+      "import MySQLdb\n",
+      "con = MySQLdb.connect(host=\"localhost\", db=\"test\")"
+     ],
+     "language": "python",
+     "metadata": {},
+     "outputs": []
+    },
+    {
+     "cell_type": "markdown",
+     "metadata": {},
+     "source": [
+      "To connect to a PostgreSQL database:"
+     ]
+    },
+    {
+     "cell_type": "code",
+     "collapsed": false,
+     "input": [
+      "import psycopg2\n",
+      "con = psycopg2.connect(host=\"localhost\")"
+     ],
+     "language": "python",
+     "metadata": {},
+     "outputs": []
+    },
     {
      "cell_type": "markdown",
      "metadata": {},

Original file line number	Diff line number	Diff line change
`@@ -590,7 +590,7 @@`
`590`	`590`	`"source": [`
`591`	`591`	`"Let's put all that together, to prove how easy it is. 6 lines of magical pandas!\n",`
`592`	`592`	`"\n",`
`593`		- "If you want to play around, try changing `sum` to `max`, `np.median`, or any other function you like."
	`593`	+ "If you want to play around, try changing `sum` to `max`, `numpy.median`, or any other function you like."
`594`	`594`	`]`
`595`	`595`	`},`
`596`	`596`	`{`