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": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
{
"cells": [
{
"cell_type": "code",
"execution_count": 48,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"https://s3.amazonaws.com/quandl-static-content/Documents/Quandl+-+Pandas,+SciPy,+NumPy+Cheat+Sheet.pdf\n",
"Quandl Cheat Sheet"
]
},
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Welcome to the mostly complete pandas cheatsheet of fast data manipulation methods!\n",
"Apart from aspiring to be an extensive glossary of your go-to book for fastest methods in Pandas, this is also a gentle introduction to Jupyter notebooks."
]
},
{
"cells": [
{
"cell_type": "code",
"execution_count": 53,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"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": 28,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
{
"cells": [
{
"cell_type": "code",
"execution_count": 50,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [