【量化小讲堂 - Python、pandas技巧系列】计算创业板平均市盈率

mark继续学习

非常感谢

邢不行 发表于 2015-4-9 17:46
引言:

本系列帖子“量化小讲堂”，通过实际案例教初学者使用python、pandas进行金融数据处理，希望能对大 ...

学习了，谢谢老师

学习一下 谢谢分享

感谢楼主分享

支持一下楼主

学习学习

报错了。。。
"C:\Program Files\Anaconda2\python.exe" C:/Users/niko/Desktop/计算创业板平均市盈率.py
Traceback (most recent call last):
  File "C:/Users/niko/Desktop/���㴴ҵ��ƽ����ӯ��.py", line 42, in <module>
    output = all_stock.groupby('date')[['market_value', '净利润']].sum()
  File "C:\Program Files\Anaconda2\lib\site-packages\pandas\core\generic.py", line 3778, in groupby
    **kwargs)
  File "C:\Program Files\Anaconda2\lib\site-packages\pandas\core\groupby.py", line 1427, in groupby
    return klass(obj, by, **kwds)
  File "C:\Program Files\Anaconda2\lib\site-packages\pandas\core\groupby.py", line 354, in __init__
    mutated=self.mutated)
  File "C:\Program Files\Anaconda2\lib\site-packages\pandas\core\groupby.py", line 2383, in _get_grouper
    in_axis, name, gpr = True, gpr, obj[gpr]
  File "C:\Program Files\Anaconda2\lib\site-packages\pandas\core\frame.py", line 1997, in __getitem__
    return self._getitem_column(key)
  File "C:\Program Files\Anaconda2\lib\site-packages\pandas\core\frame.py", line 2004, in _getitem_column
    return self._get_item_cache(key)
  File "C:\Program Files\Anaconda2\lib\site-packages\pandas\core\generic.py", line 1350, in _get_item_cache
    values = self._data.get(item)
  File "C:\Program Files\Anaconda2\lib\site-packages\pandas\core\internals.py", line 3290, in get
    loc = self.items.get_loc(item)
  File "C:\Program Files\Anaconda2\lib\site-packages\pandas\indexes\base.py", line 1947, in get_loc
    return self._engine.get_loc(self._maybe_cast_indexer(key))
  File "pandas\index.pyx", line 137, in pandas.index.IndexEngine.get_loc (pandas\index.c:4154)
  File "pandas\index.pyx", line 159, in pandas.index.IndexEngine.get_loc (pandas\index.c:4018)
  File "pandas\hashtable.pyx", line 675, in pandas.hashtable.PyObjectHashTable.get_item (pandas\hashtable.c:12368)
  File "pandas\hashtable.pyx", line 683, in pandas.hashtable.PyObjectHashTable.get_item (pandas\hashtable.c:12322)
KeyError: 'date'

Process finished with exit code 1

多谢版主分享，学习了

感谢楼主分享