{ "metadata": { "name": "TOU_pricing_my_usage" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "#%reset\n", "import pandas as pd\n", "import TOU_pricing\n", "import numpy as np\n", "#reload(TOU_pricing)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 70 }, { "cell_type": "code", "collapsed": false, "input": [ "gray_light = '#bbbbbb'\n", "gray_med = '#737373'\n", "red_orange = '#ff3700'" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 71 }, { "cell_type": "code", "collapsed": false, "input": [ "my_demand_new = pd.read_csv('raw_data/new_apt_demand_thru_july2014.csv',index_col='timestamp',parse_dates=True)\n", "my_demand_old = pd.read_csv('raw_data/old_apt_demand.csv',index_col='timestamp',parse_dates=True)\n", "\n", "green_button_sample = pd.read_csv('raw_data/Green_Button_Sample_Inland_SingleFamily.csv',index_col='timestamp',parse_dates=True)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 72 }, { "cell_type": "code", "collapsed": false, "input": [ "my_demand = my_demand_old.append(my_demand_new)\n", "\n", "my_demand_cost = TOU_pricing.BGE_elec_cost(my_demand)\n", "green_button_sample_cost = TOU_pricing.BGE_elec_cost(green_button_sample)\n", "\n", "my_demand_cost['BGE-R_cost'] = my_demand_cost['USAGE'] * my_demand_cost['BGE-R_cost_perkWh']\n", "my_demand_cost['BGE-RL_cost'] = my_demand_cost['USAGE'] * my_demand_cost['BGE-RL_cost_perkWh']\n", "my_demand_cost['BGE-EV_cost'] = my_demand_cost['USAGE'] * my_demand_cost['BGE-EV_cost_perkWh']\n", "\n", "green_button_sample_cost['BGE-R_cost'] = green_button_sample_cost['USAGE'] * green_button_sample_cost['BGE-R_cost_perkWh']\n", "green_button_sample_cost['BGE-RL_cost'] = green_button_sample_cost['USAGE'] * green_button_sample_cost['BGE-RL_cost_perkWh']\n", "green_button_sample_cost['BGE-EV_cost'] = green_button_sample_cost['USAGE'] * green_button_sample_cost['BGE-EV_cost_perkWh']\n", "\n" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 73 }, { "cell_type": "code", "collapsed": false, "input": [ "month = 'jul-2014'\n", "\n", "print 'Total usage:', round(sum(my_demand_cost['USAGE'].ix[month]),2),'kWh \\n'\n", "print 'R total: $', round(sum(my_demand_cost['USAGE'].ix[month] * my_demand_cost['BGE-R_cost_perkWh'].ix[month]),2)\n", "print 'RL total: $', round(sum(my_demand_cost['USAGE'].ix[month] * my_demand_cost['BGE-RL_cost_perkWh'].ix[month]),2)\n", "print 'EV total: $', round(sum(my_demand_cost['USAGE'].ix[month] * my_demand_cost['BGE-EV_cost_perkWh'].ix[month]),2)\n", "\n", "\n" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "Total usage: 671.6 kWh \n", "\n", "R total: $ 57.87\n", "RL total: $ 54.38\n", "EV total: $ 47.31\n" ] } ], "prompt_number": 87 }, { "cell_type": "code", "collapsed": false, "input": [ "jul_elec_bill = 93.49\n", "print round(sum(my_demand_cost['USAGE'].ix['jul-2014'] * my_demand_cost['BGE-R_cost_perkWh'].ix['jul-2014']),2)/jul_elec_bill" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "0.618996684137\n" ] } ], "prompt_number": 75 }, { "cell_type": "code", "collapsed": false, "input": [ "\n", "my_monthly_diffs = pd.DataFrame(np.zeros((7,3)),columns=['R-RL','R-EV','USAGE'],index=[1,2,3,4,5,6,7])\n", "my_monthly_diffs['R-RL'] = my_demand_cost['BGE-R_cost'].groupby(my_demand_cost.index.month).sum()-my_demand_cost['BGE-RL_cost'].groupby(my_demand_cost.index.month).sum()\n", "my_monthly_diffs['R-EV'] = my_demand_cost['BGE-R_cost'].groupby(my_demand_cost.index.month).sum()-my_demand_cost['BGE-EV_cost'].groupby(my_demand_cost.index.month).sum()\n", "my_monthly_diffs['USAGE'] = my_demand_cost['USAGE'].groupby(my_demand_cost.index.month).sum()\n", "my_monthly_diffs.index = ['Jan','Feb','Mar','Apr','May','Jun','Jul']\n", "my_monthly_diffs = my_monthly_diffs.drop(['May'])\n", "my_monthly_diffs[:10]" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | R-RL | \n", "R-EV | \n", "USAGE | \n", "
---|---|---|---|
Jan | \n", "1.216777 | \n", "1.456228 | \n", "787.34 | \n", "
Feb | \n", "1.812211 | \n", "2.080608 | \n", "1086.16 | \n", "
Mar | \n", "0.972739 | \n", "1.036178 | \n", "641.49 | \n", "
Apr | \n", "0.047755 | \n", "-0.440503 | \n", "195.86 | \n", "
Jun | \n", "2.626015 | \n", "8.097076 | \n", "636.66 | \n", "
Jul | \n", "3.481570 | \n", "10.552970 | \n", "671.60 | \n", "