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-jGE
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���gp���.��-ƿ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^[{�l p`�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� ���$��/��67�#(��{���
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���B AnH�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]0 N��"VJ!d7E���7G$��� ����N��R�����9�pf�%O��$l��O14���?C�,X2�0d`a�����)C�l�?;��M���c IEND�B`�
�PNG
*HDR � �� iIDATx��]PU��y��'_|��'|�ɇ�8Ӊ�����m���j�m4tJ-jGE
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���gp���.��-ƿ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^[{�l p`�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� ���$��/��67�#(��{���
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���B AnH�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]0 N��"VJ!d7E���7G$��� ����N��R�����9�pf�%O��$l��O14���?C�,X2�0d`a�����)C�l�?;��M���c IEND�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 [ ]:
Content source: Soncrates/stock-study
Similar notebooks: