import tushare as ts



ts.get_stock_basics()

    self.base=ts.get_stock_basics()

  File "C:\Python27\lib\site-packages\tushare\stock\fundamental.py", line 44, in get_stock_basics

    text = urlopen(request, timeout=10).read()

  File "C:\Python27\lib\socket.py", line 351, in read

    data = self._sock.recv(rbufsize)

  File "C:\Python27\lib\httplib.py", line 567, in read

    s = self.fp.read(amt)

  File "C:\Python27\lib\socket.py", line 380, in read

    data = self._sock.recv(left)

socket.timeout: timed out

pip install tushare --upgrade

    def count_area():

        base=ts.get_stock_basics()

        count=base['area'].value_counts()

        ＃这一句的意思，就是获取所有股票的上市地区的数据，然后计算出现的次数

        print count

        print type(count)

Password:

The directory '/Users/rocky/Library/Caches/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.

The directory '/Users/rocky/Library/Caches/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.

Requirement already satisfied: matplotlib in /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python

Requirement already satisfied: numpy>=1.5 in /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python (from matplotlib)

Requirement already satisfied: python-dateutil in /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python (from matplotlib)

Collecting tornado (from matplotlib)

  Downloading tornado-4.4.3.tar.gz (463kB)

    100% |████████████████████████████████| 471kB 84kB/s 

Requirement already satisfied: pyparsing>=1.5.6 in /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python (from matplotlib)

Collecting nose (from matplotlib)

  Downloading nose-1.3.7-py2-none-any.whl (154kB)

    100% |████████████████████████████████| 163kB 75kB/s 

Collecting singledispatch (from tornado->matplotlib)

  Downloading singledispatch-3.4.0.3-py2.py3-none-any.whl

Collecting certifi (from tornado->matplotlib)

  Downloading certifi-2017.1.23-py2.py3-none-any.whl (382kB)

    100% |████████████████████████████████| 389kB 105kB/s 

Collecting backports_abc>=0.4 (from tornado->matplotlib)

  Downloading backports_abc-0.5-py2.py3-none-any.whl

Requirement already satisfied: six in /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python (from singledispatch->tornado->matplotlib)

Installing collected packages: singledispatch, certifi, backports-abc, tornado, nose

  Running setup.py install for tornado ... done

Exception:

Traceback (most recent call last):

  File "/Library/Python/2.7/site-packages/pip/basecommand.py", line 215, in main

    status = self.run(options, args)

  File "/Library/Python/2.7/site-packages/pip/commands/install.py", line 342, in run

    prefix=options.prefix_path,

  File "/Library/Python/2.7/site-packages/pip/req/req_set.py", line 784, in install

    **kwargs

  File "/Library/Python/2.7/site-packages/pip/req/req_install.py", line 851, in install

    self.move_wheel_files(self.source_dir, root=root, prefix=prefix)

  File "/Library/Python/2.7/site-packages/pip/req/req_install.py", line 1064, in move_wheel_files

    isolated=self.isolated,

  File "/Library/Python/2.7/site-packages/pip/wheel.py", line 377, in move_wheel_files

    clobber(source, dest, False, fixer=fixer, filter=filter)

  File "/Library/Python/2.7/site-packages/pip/wheel.py", line 316, in clobber

    ensure_dir(destdir)

  File "/Library/Python/2.7/site-packages/pip/utils/__init__.py", line 83, in ensure_dir

    os.makedirs(path)

  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/os.py", line 150, in makedirs

    makedirs(head, mode)

  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/os.py", line 157, in makedirs

    mkdir(name, mode)

OSError: [Errno 1] Operation not permitted: '/System/Library/Frameworks/Python.framework/Versions/2.7/man'

import tushare as ts

df=ts.get_stock_basics()

def get_stock_basics():

    """

        获取沪深上市公司基本情况

    Return

    --------

    DataFrame

               code,代码

               name,名称

               industry,细分行业

               area,地区

               pe,市盈率

               outstanding,流通股本

               totals,总股本(万)

               totalAssets,总资产(万)

               liquidAssets,流动资产

               fixedAssets,固定资产

               reserved,公积金

               reservedPerShare,每股公积金

               eps,每股收益

               bvps,每股净资

               pb,市净率

               timeToMarket,上市日期

    """

    request = Request(ct.ALL_STOCK_BASICS_FILE)

    text = urlopen(request, timeout=10).read()

    text = text.decode('GBK')

    text = text.replace('--', '')

    df = pd.read_csv(StringIO(text), dtype={'code':'object'})

    df = df.set_index('code')

    return df

P_TYPE = {'http': 'http://', 'ftp': 'ftp://'}



DOMAINS = {'sina': 'sina.com.cn', 'sinahq': 'sinajs.cn',

           'ifeng': 'ifeng.com', 'sf': 'finance.sina.com.cn',

           'vsf': 'vip.stock.finance.sina.com.cn', 

           'idx': 'www.csindex.com.cn', '163': 'money.163.com',

           'em': 'eastmoney.com', 'sseq': 'query.sse.com.cn',

           'sse': 'www.sse.com.cn', 'szse': 'www.szse.cn',

           'oss': '218.244.146.57', 'idxip':'115.29.204.48',

           'shibor': 'www.shibor.org', 'mbox':'www.cbooo.cn'}

request = Request(ct.REPORT_URL%(ct.P_TYPE['http'], ct.DOMAINS['vsf'], ct.PAGES['fd'],year, quarter, pageNo, ct.PAGE_NUM[1]))

text = urlopen(request, timeout=10).read()

        df=ts.get_report_data(2016,4)

        #第四季度就是年报

excel中后缀为csv和xls，二者区别如下：
1、xls 文件就是Microsoft excel电子表格的文件格式。
2、csv是最通用的一种文件格式，它可以非常容易地被导入各种PC表格及数据库中。 此文件，一行即为数据表的一行。生成数据表字段用半角逗号隔开。
csv是文本文件,用记事本就能打开，XLS是二进制的文件只有用EXCEL才能打
csv文件是以逗号为分隔符号，将各字段列分离出的一种ASCII文件。
csv(*.csv) 文件格式只能保存活动工作表中的单元格所显示的文本和数值。工作表中所有的数据行和字符都将保存。
数据列以逗号分隔，每一行数据都以回车符结束。如果单元格中包含逗号，则该单元格中的内容以双引号引起。

stock_info=ts.get_stock_basics()

def get_all_stock_id():

    #获取所有股票代码

    for i in stock_info.index:

        print i