{ "metadata": { "name": "" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "from datetime import datetime\n", "import pandas as pd\n", "import pandas.io.data\n", "import numpy as np\n", "import scipy as sp\n", "import matplotlib.pyplot as plt\n", "pd.set_option('max_columns', 50)\n", "%matplotlib inline" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 1 }, { "cell_type": "code", "collapsed": false, "input": [ "run_console = False\n", "if run_console:\n", " %qtconsole" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 2 }, { "cell_type": "code", "collapsed": false, "input": [ "update_from_web = False\n", "if update_from_web:\n", " today = datetime.now()\n", " # http://research.stlouisfed.org/fred2/series/DJIA/downloaddata\n", " # http://measuringworth.com/DJA/\n", " # http://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=RWTC&f=D\n", " # http://www.eia.gov/dnav/pet/pet_pri_spt_s1_d.htm" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 3 }, { "cell_type": "code", "collapsed": false, "input": [ "# From http://measuringworth.com/DJA/\n", "dow = pd.read_csv('DJA.csv', skiprows=3, index_col='Date', parse_dates=True, usecols=['Date','DJIA'])\n", "# From http://research.stlouisfed.org/fred2/series/DJIA/downloaddata\n", "# dow1 = pd.read_excel('DJIA.xls', 'DJIA', skiprows=23, index_col='DATE', parse_dates=True, usecols=['DATE','VALUE'])" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 4 }, { "cell_type": "code", "collapsed": false, "input": [ "# dow['5/4/1970':].plot(figsize=(10, 10))" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 5 }, { "cell_type": "code", "collapsed": false, "input": [ "dow[np.isnan(dow['DJIA'])]" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | DJIA | \n", "
---|---|
Date | \n", "\n", " |
NaN | \n", "NaN | \n", "
Citation: Samuel H. Williamson, 'Daily Closing Value of the Dow Jones Average, 1885 to Present,' MeasuringWorth, 2012. | \n", "NaN | \n", "
2 rows \u00d7 1 columns
\n", "\n", " | DJIA | \n", "
---|---|
Date | \n", "\n", " |
2/28/2014 | \n", "16321.71 | \n", "
3/3/2014 | \n", "16168.03 | \n", "
3/4/2014 | \n", "16395.88 | \n", "
3/5/2014 | \n", "16360.18 | \n", "
3/6/2014 | \n", "16421.89 | \n", "
5 rows \u00d7 1 columns
\n", "