天天基金货币基金数据分析

import requests
import json
import demjson
import pandas as pd
resp = requests.get('http://fund.eastmoney.com/data/Fund_JJJZ_Data.aspx?t=7&page=1,1000000&js=reData&sort=mui,desc')
data = resp.text
data = data.replace('var reData=','')
b = demjson.decode(data)
df = pd.DataFrame(b['datas'])
df.sort_values([2],ascending=False
               ,inplace=True)
df[6] = df[6].map(lambda x:float(x.replace('亿','')) if x.replace('亿','') else 0)
df.sort_values([6],ascending=False ,inplace=True)
df[(df[9]=='开放申购')&(df[7]=='日结')&(df[10]=='0')&(df[11]=='1')&(df[6]>=100)]

# 筛选开放申购，日结，费率0，可购买，规模大于100亿的基金，最后从733只中选除了9只满足要求。持续优化，休息休息了…

df.sort_values([6],ascending=False ,inplace=True)
df[(df[9]=='开放申购')&(df[7]=='日结')&(df[10]=='0')&(df[11]=='1')&(df[6]>=100)]