In [1]:
import sys
if sys.version_info[0] < 3: 
    from StringIO import StringIO
else:
    from io import StringIO
import datetime
import pandas as pd
from DictHelper import DictIni
from RequestHelper import UrlHelper, MacroTrend

t = DictIni.load_ini("MacroTrend.ini")
t = DictIni.load_ini("QuotePedia.ini")
t = DictIni.to_Dict(t)
quote = UrlHelper.parse_request('quote',t)

def lastTenYears(df) :
    now = datetime.datetime.utcnow()
    d = now - datetime.timedelta(days=365*10)
    #format = '%Y %m %d'
    #d = datetime.datetime.strptime(d,format)
    #print d
    if 'date' in df :
        df.loc[d:]
    return df

In [2]:
stocks_keys = ['AAA','AAPL']
stocks_values = map(lambda s : UrlHelper.transform_request(quote,s), stocks_keys)
stocks_values = map(lambda s : UrlHelper.open(**s), stocks_values)
for d in stocks_values : print d[:12]


�PNG

*HDR���iIDATx��]PU��y��'_|��'|�ɇ�8Ӊ�����m���j�m4tJ-jGE
c�))L��R�UC@�	����|��{���{��^8��5�;����k����c�8fȐE��;C�42�0d`a����!C��4,",�m���#jlS�S� �L�Z,\#�	���֗�|�md�t����+�w` �$�y���	����ܣ��gBa��'$6��w�J��0*T�í�x��X:�nm_�S��L,A�-X��T���gp���.��-ƿE�Sx�r�ɂ��6nz�qj��E������95s=�tH����1?u��B�!��7����4e��I\���4��x�QC��
���E.j�Mp�Ȝ XL� �x1��+���=΅��W$�����W$�rB��t}�&�_�?�<Ͻ�p�=�ۂ	����5���Z.���Jη+~A�W7�D��a�E�/�Bbv���^��-�v{R>5Υ	��y�	���`��]�����7~�H��f
�����tSګo����WW��t�A�?����nۊ.ϓcyc�e�#bQ#.�T��w�l�H�K)O��f�����~Dp������~B�ˤ:����T;;;涶6eݨ�(�(z���ۥ3%%%‘`�E�;	�j��`���:b�[DCu� nC`����4�J���(1[�V�e��a��ښ�~���D�}���Y�CXwٖt�1O�q�tF1�x�:	��T�	�����e��ŖtҎ,6��PC�3<|��1�����?��UUU��r(333KJJv�ޭco,fϞ-=~��2��߮N?�͛7�����7�HTSS�'�o�)'��ٳ�-�mݺU��\���������d%-66V`�9�r�#;�V�����&�X`0�A@:y�r����������T�7rz��1f��Q�}���������x@�n�c����J~�����)��["<���g�A@������=B`X ߀c�ъd�b.�$��f�oQY�z}���%��I��/
6��&k�a$�,���U���U�*�@�6�^���F���[舤��]A�֢��������aI9�IGHD^[{�lp`�yIM�v���.��"/���EX��:3HZ�[��>�앤X$�.��{���#������+�������k��Xpv���IZ"8s�a�R`H[�<yr̰���B�$�Q���O��4�H-�(�����˕2�g�\#~��ùs�^�Y�� 2���s4��@��@W��w$��-�GB�!��tH2��ae8��G8$��HV���Q�0"c�D|a����[�P�7D���w\�� �/����@�H��l�<DY�<s0���+Xx<���.�L��{.n�Dp���AӾ�d@*����e�#�E����U�x��S��(��|ī�>�dR�|�%�f��7��Tr�	o�B"��B���,�pu�X�ނS�[p��g�ƯΫx,��V�k�K%
�� wS$�����DJKK�N
���F��[@�v��> ^����#��-A�T@��.Փ��5���p�%3p�i,�*(Ymr�H�ApA��[�,0ـJQ�
t����C��P����$��/��67�#(��{���
b|a�%�خ,1FNN���-�����19�8�Un~~�M��6�1�|��v��qI�^_�d�`A'[�A�U"�l2�J�'��S�l��)�H��!���ϿRw_B�[��D���r�?>p��p��A�������x	I+p�Hʉ��E[j0��{�FL����Z�A-B�m^�߉P5`p����ɅtQQ�-�(������ܾ};P8{�����������Ă�f���B�؁��� ��@/H������"R�ӧO���II-����򚛛m�D���U]�̇LMǚN���;m���l�>��<�iE�V����+_2An���b5Vy	3&y�p��G�R�(�|�6?Vf�`��L�40J$�O��5$�Wkn�Ae��BۭW|�
��=x�����@���Ƥ��-�Ou�X$���h��p�X���_b(g�p655���p�Q�K6���CxH�e�nX$>~֎X%�~�@��e�aA���BAnH�y��e%�	:H9�β6��+QF�#Ð�S�(�a�
��&qɴ�Nu1a�9ĩ={�Y
�|'�AN�ȑ`�E Ƞ�v�i�6����7���n‚�~F�r�sƾ�Y,�͕�^l���n?Y!���Xe�Ν��Q,p0�V���#1���e�INN�=�8I2y�.`��p�����n�żM$�/l�t�-bv��nr��_v\�K+	,�c�4v�\�3��hbid!���Мu��P���~��D����(Ѐn,!��OMh0�����%�"�X8�������Њ�LA?�I�S=#}z~��A?G.ޘ��O�F-�`����'��9i�S�A�}uM��6J�|��/��
�ba����Zq]0N��"VJ!d7E���7G$���	����N��R�����9�pf�%O��$l��O14���?C�,X2�0d`a�����)C�l�?;��M���cIEND�B`�
�PNG

*HDR���iIDATx��]PU��y��'_|��'|�ɇ�8Ӊ�����m���j�m4tJ-jGE
c�))L��R�UC@�	����|��{���{��^8��5�;����k����c�8fȐE��;C�42�0d`a����!C��4,",�m���#jlS�S� �L�Z,\#�	���֗�|�md�t����+�w` �$�y���	����ܣ��gBa��'$6��w�J��0*T�í�x��X:�nm_�S��L,A�-X��T���gp���.��-ƿE�Sx�r�ɂ��6nz�qj��E������95s=�tH����1?u��B�!��7����4e��I\���4��x�QC��
���E.j�Mp�Ȝ XL� �x1��+���=΅��W$�����W$�rB��t}�&�_�?�<Ͻ�p�=�ۂ	����5���Z.���Jη+~A�W7�D��a�E�/�Bbv���^��-�v{R>5Υ	��y�	���`��]�����7~�H��f
�����tSګo����WW��t�A�?����nۊ.ϓcyc�e�#bQ#.�T��w�l�H�K)O��f�����~Dp������~B�ˤ:����T;;;涶6eݨ�(�(z���ۥ3%%%‘`�E�;	�j��`���:b�[DCu� nC`����4�J���(1[�V�e��a��ښ�~���D�}���Y�CXwٖt�1O�q�tF1�x�:	��T�	�����e��ŖtҎ,6��PC�3<|��1�����?��UUU��r(333KJJv�ޭco,fϞ-=~��2��߮N?�͛7�����7�HTSS�'�o�)'��ٳ�-�mݺU��\���������d%-66V`�9�r�#;�V�����&�X`0�A@:y�r����������T�7rz��1f��Q�}���������x@�n�c����J~�����)��["<���g�A@������=B`X ߀c�ъd�b.�$��f�oQY�z}���%��I��/
6��&k�a$�,���U���U�*�@�6�^���F���[舤��]A�֢��������aI9�IGHD^[{�lp`�yIM�v���.��"/���EX��:3HZ�[��>�앤X$�.��{���#������+�������k��Xpv���IZ"8s�a�R`H[�<yr̰���B�$�Q���O��4�H-�(�����˕2�g�\#~��ùs�^�Y�� 2���s4��@��@W��w$��-�GB�!��tH2��ae8��G8$��HV���Q�0"c�D|a����[�P�7D���w\�� �/����@�H��l�<DY�<s0���+Xx<���.�L��{.n�Dp���AӾ�d@*����e�#�E����U�x��S��(��|ī�>�dR�|�%�f��7��Tr�	o�B"��B���,�pu�X�ނS�[p��g�ƯΫx,��V�k�K%
�� wS$�����DJKK�N
���F��[@�v��> ^����#��-A�T@��.Փ��5���p�%3p�i,�*(Ymr�H�ApA��[�,0ـJQ�
t����C��P����$��/��67�#(��{���
b|a�%�خ,1FNN���-�����19�8�Un~~�M��6�1�|��v��qI�^_�d�`A'[�A�U"�l2�J�'��S�l��)�H��!���ϿRw_B�[��D���r�?>p��p��A�������x	I+p�Hʉ��E[j0��{�FL����Z�A-B�m^�߉P5`p����ɅtQQ�-�(������ܾ};P8{�����������Ă�f���B�؁��� ��@/H������"R�ӧO���II-����򚛛m�D���U]�̇LMǚN���;m���l�>��<�iE�V����+_2An���b5Vy	3&y�p��G�R�(�|�6?Vf�`��L�40J$�O��5$�Wkn�Ae��BۭW|�
��=x�����@���Ƥ��-�Ou�X$���h��p�X���_b(g�p655���p�Q�K6���CxH�e�nX$>~֎X%�~�@��e�aA���BAnH�y��e%�	:H9�β6��+QF�#Ð�S�(�a�
��&qɴ�Nu1a�9ĩ={�Y
�|'�AN�ȑ`�E Ƞ�v�i�6����7���n‚�~F�r�sƾ�Y,�͕�^l���n?Y!���Xe�Ν��Q,p0�V���#1���e�INN�=�8I2y�.`��p�����n�żM$�/l�t�-bv��nr��_v\�K+	,�c�4v�\�3��hbid!���Мu��P���~��D����(Ѐn,!��OMh0�����%�"�X8�������Њ�LA?�I�S=#}z~��A?G.ޘ��O�F-�`����'��9i�S�A�}uM��6J�|��/��
�ba����Zq]0N��"VJ!d7E���7G$���	����N��R�����9�pf�%O��$l��O14���?C�,X2�0d`a�����)C�l�?;��M���cIEND�B`�
�PNG


�PNG



In [31]:
#stocks_values = map(lambda s : MacroTrend.parse(s), stocks_values)
stocks_values = map(lambda s : StringIO(s), stocks_values)
stocks_values = map(lambda s : pd.read_csv(s), stocks_values)
stocks_values = map(lambda s : lastTenYears(s), stocks_values)
stocks = dict(zip(stocks_keys,stocks_values))
print stocks


---------------------------------------------------------------------------
ParserError                               Traceback (most recent call last)
<ipython-input-31-0a2d62c60471> in <module>()
      1 #stocks_values = map(lambda s : MacroTrend.parse(s), stocks_values)
      2 stocks_values = map(lambda s : StringIO(s), stocks_values)
----> 3 stocks_values = map(lambda s : pd.read_csv(s), stocks_values)
      4 stocks_values = map(lambda s : lastTenYears(s), stocks_values)
      5 stocks = dict(zip(stocks_keys,stocks_values))

<ipython-input-31-0a2d62c60471> in <lambda>(s)
      1 #stocks_values = map(lambda s : MacroTrend.parse(s), stocks_values)
      2 stocks_values = map(lambda s : StringIO(s), stocks_values)
----> 3 stocks_values = map(lambda s : pd.read_csv(s), stocks_values)
      4 stocks_values = map(lambda s : lastTenYears(s), stocks_values)
      5 stocks = dict(zip(stocks_keys,stocks_values))

/usr/local/lib/python2.7/dist-packages/pandas/io/parsers.pyc 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, doublequote, delim_whitespace, low_memory, memory_map, float_precision)
    676                     skip_blank_lines=skip_blank_lines)
    677 
--> 678         return _read(filepath_or_buffer, kwds)
    679 
    680     parser_f.__name__ = name

/usr/local/lib/python2.7/dist-packages/pandas/io/parsers.pyc in _read(filepath_or_buffer, kwds)
    444 
    445     try:
--> 446         data = parser.read(nrows)
    447     finally:
    448         parser.close()

/usr/local/lib/python2.7/dist-packages/pandas/io/parsers.pyc in read(self, nrows)
   1034                 raise ValueError('skipfooter not supported for iteration')
   1035 
-> 1036         ret = self._engine.read(nrows)
   1037 
   1038         # May alter columns / col_dict

/usr/local/lib/python2.7/dist-packages/pandas/io/parsers.pyc in read(self, nrows)
   1846     def read(self, nrows=None):
   1847         try:
-> 1848             data = self._reader.read(nrows)
   1849         except StopIteration:
   1850             if self._first_chunk:

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader.read()

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._read_low_memory()

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._read_rows()

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._tokenize_rows()

pandas/_libs/parsers.pyx in pandas._libs.parsers.raise_parser_error()

ParserError: Error tokenizing data. C error: Expected 1 fields in line 7, saw 4

In [ ]: