In [1]:

    

import pandas as pd


    

In [12]:

    

from Clean-Energy-Outlook import datacleaning


    

    




  File "<ipython-input-12-ffd321176672>", line 1
    from Clean-Energy-Outlook import datacleaning
              ^
SyntaxError: invalid syntax

In [15]:

    

from folder import datacleaning


    

    




---------------------------------------------------------------------------
ImportError                               Traceback (most recent call last)
<ipython-input-15-b854010aa55e> in <module>()
----> 1 from folder import datacleaning

ImportError: No module named 'folder'

In [11]:

    

import datacleaning


    

    




---------------------------------------------------------------------------
ImportError                               Traceback (most recent call last)
<ipython-input-11-4a60696a312e> in <module>()
----> 1 import datacleaning

ImportError: No module named 'datacleaning'

In [2]:

    

df = pd.read_excel("Data/Original Data/State Energy Data System.xlsx",sheetname=3)


    

In [2]:

    

statelist=["AK","AL","AR","AZ","CA","CO","CT","DC","DE","FL","GA","HI","IA","ID","IL","IN","KS","KY","LA","MA","MD","ME","MI","MN","MO","MS","MT","NC","ND","NE","NH","NJ","NM","NV","NY","OH","OK","OR","PA","RI","SC","SD","TN","TX","US","UT","VA","VT","WA","WI","WV","WY"]


    

In [4]:

    

dc.data_extract_all(df,statelist,["HYTCP","WYTCP","SOEGP","NUETP"])


    

In [5]:

    

dc.add_clprb(statelist)


    

    




C:\Users\rahul\Desktop\Clean-Energy-Outlook\Clean-Energy-Outlook\datacleaning.py:35: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
  dftemp['CLPRB'][i-1] = table.row_values(i)[3] # columns 4

In [6]:

    

dc.add_msn(statelist,'EMFDB')


    

In [7]:

    

dc.add_msn(statelist,'ENPRP')


    

In [8]:

    

dc.add_msn(statelist,'NGMPB')


    

In [9]:

    

dc.add_msn(statelist,'PAPRB')


    

In [8]:

    

climate_data = pd.read_csv('..Data/Original Data/Climate Data/climate_annual.txt',sep = ' ',encoding = 'utf-8')


    

    




---------------------------------------------------------------------------
FileNotFoundError                         Traceback (most recent call last)
<ipython-input-8-85b1f256791e> in <module>()
----> 1 climate_data = pd.read_csv('..Data/Original Data/Climate Data/climate_annual.txt',sep = ' ',encoding = 'utf-8')

C:\Users\rahul\Miniconda3\lib\site-packages\pandas\io\parsers.py in parser_f(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, escapechar, comment, encoding, dialect, tupleize_cols, error_bad_lines, warn_bad_lines, skipfooter, skip_footer, doublequote, delim_whitespace, as_recarray, compact_ints, use_unsigned, low_memory, buffer_lines, memory_map, float_precision)
    644                     skip_blank_lines=skip_blank_lines)
    645 
--> 646         return _read(filepath_or_buffer, kwds)
    647 
    648     parser_f.__name__ = name

C:\Users\rahul\Miniconda3\lib\site-packages\pandas\io\parsers.py in _read(filepath_or_buffer, kwds)
    387 
    388     # Create the parser.
--> 389     parser = TextFileReader(filepath_or_buffer, **kwds)
    390 
    391     if (nrows is not None) and (chunksize is not None):

C:\Users\rahul\Miniconda3\lib\site-packages\pandas\io\parsers.py in __init__(self, f, engine, **kwds)
    728             self.options['has_index_names'] = kwds['has_index_names']
    729 
--> 730         self._make_engine(self.engine)
    731 
    732     def close(self):

C:\Users\rahul\Miniconda3\lib\site-packages\pandas\io\parsers.py in _make_engine(self, engine)
    921     def _make_engine(self, engine='c'):
    922         if engine == 'c':
--> 923             self._engine = CParserWrapper(self.f, **self.options)
    924         else:
    925             if engine == 'python':

C:\Users\rahul\Miniconda3\lib\site-packages\pandas\io\parsers.py in __init__(self, src, **kwds)
   1388         kwds['allow_leading_cols'] = self.index_col is not False
   1389 
-> 1390         self._reader = _parser.TextReader(src, **kwds)
   1391 
   1392         # XXX

pandas\parser.pyx in pandas.parser.TextReader.__cinit__ (pandas\parser.c:4184)()

pandas\parser.pyx in pandas.parser.TextReader._setup_parser_source (pandas\parser.c:8449)()

FileNotFoundError: File b'..Data/Original Data/Climate Data/climate_annual.txt' does not exist

In [ ]:

    

dc.climate(climate_data,'PCP',statelist)
dc.climate(climate_data,'ZNDX',statelist)


    

In [10]:

    

oil = pd.read_excel("../Data/Original Data/State Energy Data System.xlsx",sheetname=3)


    

    




---------------------------------------------------------------------------
FileNotFoundError                         Traceback (most recent call last)
<ipython-input-10-ea7fa6988e2d> in <module>()
----> 1 oil = pd.read_excel("../Data/Original Data/State Energy Data System.xlsx",sheetname=3)

C:\Users\rahul\Miniconda3\lib\site-packages\pandas\io\excel.py in read_excel(io, sheetname, header, skiprows, skip_footer, index_col, names, parse_cols, parse_dates, date_parser, na_values, thousands, convert_float, has_index_names, converters, true_values, false_values, engine, squeeze, **kwds)
    189 
    190     if not isinstance(io, ExcelFile):
--> 191         io = ExcelFile(io, engine=engine)
    192 
    193     return io._parse_excel(

C:\Users\rahul\Miniconda3\lib\site-packages\pandas\io\excel.py in __init__(self, io, **kwds)
    247             self.book = xlrd.open_workbook(file_contents=data)
    248         elif isinstance(io, compat.string_types):
--> 249             self.book = xlrd.open_workbook(io)
    250         else:
    251             raise ValueError('Must explicitly set engine if not passing in'

C:\Users\rahul\Miniconda3\lib\site-packages\xlrd\__init__.py in open_workbook(filename, logfile, verbosity, use_mmap, file_contents, encoding_override, formatting_info, on_demand, ragged_rows)
    393         peek = file_contents[:peeksz]
    394     else:
--> 395         with open(filename, "rb") as f:
    396             peek = f.read(peeksz)
    397     if peek == b"PK\x03\x04": # a ZIP file

FileNotFoundError: [Errno 2] No such file or directory: '../Data/Original Data/State Energy Data System.xlsx'

In [ ]:

    

dc.oil_price(oil,statelist)