{ "metadata": { "name": "" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "heading", "level": 1, "metadata": {}, "source": [ "Valuation of the HDA Process for the Production of Benzene from Toluene" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Some basic calculations." ] }, { "cell_type": "code", "collapsed": false, "input": [ "P = dict()\n", "P['Benzene'] = 1431\n", "P['Toluene'] = 1290" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 7 }, { "cell_type": "code", "collapsed": false, "input": [ "P" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 8, "text": [ "{'Benzene': 1431, 'Toluene': 1290}" ] } ], "prompt_number": 8 }, { "cell_type": "code", "collapsed": false, "input": [ "import pandas\n", "prices = pandas.read_csv('TolBenNGPrices.csv', index_col = 0)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 4 }, { "cell_type": "code", "collapsed": false, "input": [ "prices" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | Benzene | \n", "Toluene Blend | \n", "Natural Gas | \n", "
---|---|---|---|
Prices | \n", "\n", " | \n", " | \n", " |
11-Feb | \n", "4.2866 | \n", "2.9730 | \n", "5.77 | \n", "
11-Mar | \n", "4.0488 | \n", "3.3708 | \n", "5.21 | \n", "
11-Apr | \n", "4.1338 | \n", "4.2003 | \n", "5.34 | \n", "
11-May | \n", "4.1219 | \n", "3.6000 | \n", "5.21 | \n", "
11-Jun | \n", "3.7910 | \n", "3.5714 | \n", "5.21 | \n", "
11-Jul | \n", "3.9963 | \n", "4.0194 | \n", "5.05 | \n", "
11-Aug | \n", "4.0838 | \n", "3.6853 | \n", "5.21 | \n", "
11-Sep | \n", "3.7060 | \n", "3.3577 | \n", "4.84 | \n", "
11-Oct | \n", "3.1713 | \n", "3.3020 | \n", "4.71 | \n", "
11-Nov | \n", "3.1056 | \n", "3.0904 | \n", "4.64 | \n", "
11-Dec | \n", "3.3738 | \n", "3.2395 | \n", "4.59 | \n", "
12-Jan | \n", "4.0450 | \n", "3.6006 | \n", "4.59 | \n", "
12-Feb | \n", "4.1650 | \n", "3.7538 | \n", "4.19 | \n", "
12-Mar | \n", "4.1575 | \n", "3.9608 | \n", "3.71 | \n", "
12-Apr | \n", "4.1425 | \n", "4.3428 | \n", "3.21 | \n", "
12-May | \n", "4.0600 | \n", "4.2330 | \n", "3.02 | \n", "
12-Jun | \n", "4.1463 | \n", "3.9933 | \n", "3.34 | \n", "
12-Jul | \n", "4.6675 | \n", "4.2367 | \n", "3.60 | \n", "
12-Aug | \n", "4.3400 | \n", "4.2641 | \n", "3.83 | \n", "
12-Sep | \n", "4.3456 | \n", "4.3466 | \n", "3.56 | \n", "
12-Oct | \n", "4.7313 | \n", "3.8967 | \n", "3.95 | \n", "
12-Nov | \n", "4.8745 | \n", "3.1773 | \n", "4.46 | \n", "
12-Dec | \n", "5.1258 | \n", "3.2948 | \n", "4.72 | \n", "
13-Jan | \n", "4.9331 | \n", "3.8594 | \n", "4.60 | \n", "
24 rows \u00d7 3 columns
\n", "\n", " | Benzene | \n", "Natural Gas | \n", "Toluene Blend | \n", "
---|---|---|---|
Prices | \n", "\n", " | \n", " | \n", " |
11-Feb | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
11-Mar | \n", "-0.057073 | \n", "-0.102092 | \n", "0.125579 | \n", "
11-Apr | \n", "0.020777 | \n", "0.024646 | \n", "0.220006 | \n", "
11-May | \n", "-0.002883 | \n", "-0.024646 | \n", "-0.154222 | \n", "
11-Jun | \n", "-0.083684 | \n", "0.000000 | \n", "-0.007976 | \n", "
11-Jul | \n", "0.052739 | \n", "-0.031192 | \n", "0.118175 | \n", "
11-Aug | \n", "0.021659 | \n", "0.031192 | \n", "-0.086781 | \n", "
11-Sep | \n", "-0.097075 | \n", "-0.073665 | \n", "-0.093096 | \n", "
11-Oct | \n", "-0.155812 | \n", "-0.027227 | \n", "-0.016728 | \n", "
11-Nov | \n", "-0.020935 | \n", "-0.014974 | \n", "-0.066228 | \n", "
11-Dec | \n", "0.082833 | \n", "-0.010834 | \n", "0.047118 | \n", "
12-Jan | \n", "0.181442 | \n", "0.000000 | \n", "0.105682 | \n", "
12-Feb | \n", "0.029235 | \n", "-0.091179 | \n", "0.041668 | \n", "
12-Mar | \n", "-0.001802 | \n", "-0.121669 | \n", "0.053677 | \n", "
12-Apr | \n", "-0.003614 | \n", "-0.144761 | \n", "0.092073 | \n", "
12-May | \n", "-0.020116 | \n", "-0.061014 | \n", "-0.025608 | \n", "
12-Jun | \n", "0.021033 | \n", "0.100714 | \n", "-0.058293 | \n", "
12-Jul | \n", "0.118407 | \n", "0.074963 | \n", "0.059167 | \n", "
12-Aug | \n", "-0.072749 | \n", "0.061931 | \n", "0.006446 | \n", "
12-Sep | \n", "0.001289 | \n", "-0.073104 | \n", "0.019163 | \n", "
12-Oct | \n", "0.085036 | \n", "0.103955 | \n", "-0.109264 | \n", "
12-Nov | \n", "0.029818 | \n", "0.121433 | \n", "-0.204098 | \n", "
12-Dec | \n", "0.050269 | \n", "0.056660 | \n", "0.036314 | \n", "
13-Jan | \n", "-0.038319 | \n", "-0.025752 | \n", "0.158166 | \n", "
24 rows \u00d7 3 columns
\n", "