Skip to content

Instantly share code, notes, and snippets.

View decisionstats's full-sized avatar

Ajay Ohri decisionstats

  • Decisionstats.com
  • Internet
View GitHub Profile
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#to be continued"
]
},
{
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Stackoverflow data dump analysis\n",
"\n",
"The goal of this case study is to demonstrate how Postgres, a relational database and Python be used for efficient data analysis. We will be getting our hands dirty with some Postgres syntax (just enough to make our SQL queries efficient and quick) and a couple of Python libraries - `psycopg2` and `sqlalchemy`."
]
{
"cells": [
{
"cell_type": "code",
"execution_count": 258,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
{
"cells": [
{
"cell_type": "code",
"execution_count": 37,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
{
"cells": [
{
"cell_type": "code",
"execution_count": 50,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
{
"cells": [
{
"cell_type": "code",
"execution_count": 28,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Stackoverflow data dump analysis\n",
"\n",
"The goal of this case study is to demonstrate how Postgres, a relational database and Python be used for efficient data analysis. We will be getting our hands dirty with some Postgres syntax (just enough to make our SQL queries efficient and quick) and a couple of Python libraries - `psycopg2` and `sqlalchemy`."
]
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [