def rowToORM(row):
obj = Model()
obj.boxOffice = toFloat(row.loc['BoxOffice']) # 实时票房（万）
obj.irank = toInt(row.loc['Irank']) # 排名
obj.movieName = toStr(row.loc['MovieName']) # 影片名
obj.boxPer = toFloat(row.loc['boxPer']) # 票房占比 （ % ）
obj.movieDay = toInt(row.loc['movieDay']) # 上映天数
obj.sumBoxOffice = toFloat(row.loc['sumBoxOffice']) # 累计票房（万）
tsString = str(row.loc['time'])
obj.time = None
try:
obj.time = parse(tsString)
minute = obj.time.minute
if minute >= 30:
minute = 30
else:
minute = 0
tsString = obj.time.strftime("%Y-%m-%d %H")
tsString = "{pre}:{min:02d}:00".format(pre=tsString, min=minute)
obj.time = parse(tsString)
except:
logging.warning(
"Fail to get date from {} from {}. Using {} as Fallback".format(
__name__, tsString, obj.time))
if obj.movieName == "其它":
return None
return obj
def rowToORM(row, year, quarter):
obj = Model()
obj.code = toStr(row.loc['code']) # 股票代码
obj.name = toStr(row.loc['name']) # 股票名称
obj.year = int(year) # 分配年份
obj.quarter = int(quarter)
tsString = str(row.loc['date'])
obj.report_date = None
try:
obj.report_date = parse(tsString)
except:
logging.warning(
"Fail to get date from {} from {}. Using {} as Fallback".format(
__name__, tsString, obj.report_date))
obj.nums = toInt(row.loc['nums']) # 基金家数
obj.nlast = toInt(row.loc['nlast']) # 与上期相比（增加或减少了）
obj.count = toFloat(row.loc['count']) # 基金持股数（万股）
obj.clast = toFloat(row.loc['clast']) # 与上期相比
obj.amount = toFloat(row.loc['amount']) # 基金持股市值
obj.ratio = toFloat(row.loc['ratio']) # 占流通盘比率
return obj
def rowToORM(row, year, month):
obj = Model()
obj.year = year
obj.month = month
obj.avgPrice = toInt(row.loc['avgboxoffice']) # 平均票价
obj.avpPeoPle = toInt(row.loc['avgshowcount']) # 场均人次
obj.boxOffice = toFloat(row.loc['boxoffice']) # 单日票房（万）
obj.box_pro = toFloat(row.loc['box_pro']) # 月度占比
obj.iRank = toInt(row.loc['Irank']) # 排名
obj.movieName = toStr(row.loc['MovieName'])[0:Model.TEXT_MAX_LENGTH] # 影片名
if obj.movieName == "其他" or obj.movieName == "其它":
return None
obj.womIndex = toFloat(row.loc['WomIndex']) # 口碑指数
obj.days = toInt(row.loc['days'])
tsString = str(row.loc['releaseTime'])
obj.time = None
try:
obj.releaseTime = parse(tsString)
except:
logging.warning(
"Fail to get date from {} from {}. Using {} as Fallback".format(
__name__, tsString, obj.releaseTime))
if obj.releaseTime is None:
return None
return obj
def rowToORM(row):
obj = Model()
obj.year = int(row.loc['year'])
obj.gdp_yoy = toFloat(row.loc['gdp_yoy']) # 国内生产总值
obj.pi = toFloat(row.loc['pi']) # 第一产业献率( %)
obj.si = toFloat(row.loc['si']) # 第二产业献率( %)
obj.industry = toFloat(row.loc['industry']) # 其中工业献率( %)
obj.ti = toFloat(row.loc['ti']) # 第三产业献率( %)
return obj
def rowToORM(row):
obj = Model()
tsString = str(row.loc['date'])
obj.exe_date = None
try:
obj.exe_date = parse(tsString)
except:
logging.warning(
"Fail to get date from {} from {}. Using {} as Fallback".format(
__name__, tsString, obj.exe_date))
obj.before = toFloat(row.loc['before'])
obj.now = toFloat(row.loc['now'])
obj.changed = toFloat(row.loc['changed'])
return obj
def rowToORM(row):
obj = Model()
obj.year = int(row.loc['year'])
obj.gdp = toFloat(row.loc['gdp']) # 国内生产总值(亿元)
obj.pc_gdp = toFloat(row.loc['pc_gdp']) # 人均国内生产总值(元)
obj.gnp = toFloat(row.loc['gnp']) # 国民生产总值(亿元)
obj.pi = toFloat(row.loc['pi']) # 第一产业(亿元)
obj.si = toFloat(row.loc['si']) # 第二产业(亿元)
obj.industry = toFloat(row.loc['industry']) # 工业(亿元)
obj.cons_industry = toFloat(row.loc['cons_industry']) # 建筑业(亿元)
obj.ti = toFloat(row.loc['ti']) # 第三产业(亿元)
obj.trans_industry = toFloat(row.loc['trans_industry']) # 交通运输仓储邮电通信业(亿元)
obj.lbdy = toFloat(row.loc['lbdy']) # 批发零售贸易及餐饮业(亿元)
return obj
def rowToORM(row, date: datetime):
obj = Model()
obj.date = date
obj.timestamp = date
obj.avgPrice = toInt(row.loc['AvgPrice']) # 平均票价
obj.avpPeoPle = toInt(row.loc['AvpPeoPle']) # 场均人次
obj.boxOffice = toFloat(row.loc['BoxOffice']) # 单日票房（万）
obj.boxOffice_Up = toFloat(row.loc['BoxOffice_Up']) # 环比变化 （ % ）
obj.iRank = toInt(row.loc['IRank']) # 排名
obj.movieDay = toInt(row.loc['MovieDay']) # 上映天数
obj.movieName = str(row.loc['MovieName'])[0:Model.TEXT_MAX_LENGTH] # 影片名
obj.sumBoxOffice = toFloat(row.loc['SumBoxOffice']) # 累计票房（万）
obj.womIndex = toFloat(row.loc['WomIndex']) # 口碑指数
obj.pk = "{name}_{date}".format(name=obj.movieName,
date=dateTimeToTsStr(date))
return obj
def rowToORM(row):
obj = ClassifiedSt()
obj.code = toStr(row.loc['code'])
obj.name = toStr(row.loc['name'])
ts = datetime.datetime.fromtimestamp(row.loc['date'].value / 1000000000)
obj.date = ts.date()
obj.weight = toFloat(row.loc['weight'])
# obj.pk = "{code}_{date}".format(code=obj.code,date=dateTimeToTsStr(ts))
return obj
def rowToORM(row):
obj = Model()
obj.code = toStr(row.loc['code']) # 股票代码
obj.name = toStr(row.loc['name']) # 股票名称
obj.year = int(row.loc['year']) # 分配年份
tsString = str(row.loc['report_date'])
obj.report_date = None
try:
obj.report_date = parse(tsString)
except:
logging.warning(
"Fail to get date from {} from {}. Using {} as Fallback".format(
__name__, tsString, obj.report_date))
obj.divi = toFloat(row.loc['divi']) # 分红金额（每10股）
obj.shares = toFloat(row.loc['shares']) # 转增和送股数（每10股）
return obj
def rowToORM(row, year, month):
obj = Model()
obj.code = toStr(row.loc['code']) # 股票代码
obj.name = toStr(row.loc['name']) # 股票名称
obj.year = int(year) # 分配年份
obj.month = int(month)
tsString = toStr(row.loc['date'])
obj.report_date = None
try:
obj.report_date = parse(tsString)
except:
logging.warning(
"Fail to get date from {} from {}. Using {} as Fallback".format(
__name__, tsString, obj.report_date))
obj.count = toFloat(row.loc['count'])
obj.ratio = toFloat(row.loc['ratio'])
return obj
def rowToORM(row):
obj = Model()
tsString = str(row.loc['date'])
obj.exe_date = None
try:
obj.exe_date = parse(tsString)
except:
logging.warning("Fail to get date from {} from {}. Using {} as Fallback".
format(__name__, tsString, obj.exe_date))
obj.loan_type = row.loc['loan_type'][0:Model.TEXT_MAX_LENGTH]
obj.rate = toFloat(row.loc['rate'])
return obj
def rowToORM(row):
obj = Model()
obj.year = int(row.loc['year'])
obj.m2 = toFloat(row.loc['m2']) # 货币和准货币(亿元)
obj.m1 = toFloat(row.loc['m1']) # 货币(亿元)
obj.m0 = toFloat(row.loc['m0']) # 流通中现金(亿元)
obj.cd = toFloat(row.loc['cd']) # 活期存款(亿元)
obj.qm = toFloat(row.loc['qm']) # 准货币(亿元)
obj.ftd = toFloat(row.loc['ftd']) # 定期存款(亿元)
obj.sd = toFloat(row.loc['sd']) # 储蓄存款(亿元)
obj.rests = toFloat(row.loc['rests']) # 其他存款(亿元)
return obj
def rowToORM(row, code: str, currentStr: str):
tsStr = "{}T{}".format(currentStr, toStr(row.loc['time']))
# timestamp = datetime.fromisoformat(tsStr) # Only for py3.7+
timestamp = parser.parse(tsStr)
timestamp = timestamp - timedelta(seconds=TIME_ZONE_OFFSET_SECONDS)
typeStr = toStr(row.loc['type'])
influxPoint = {
"measurement": "share_tick",
"tags": {
"code": code
},
"time": timestamp,
"fields": {
"price": toFloat(row.loc['price']),
"change": toFloat(row.loc['change']),
"volume": toInt(row.loc['volume']),
"amount": toInt(row.loc['amount']),
"type_buy": typeStr == '买盘',
"type_sell": typeStr == '卖盘',
"type_neutral": typeStr == '中性盘'
}
}
return influxPoint
def rowToORM(row):
obj = Model()
obj.code = toStr(row.loc['code']) # 股票代码
obj.name = toStr(row.loc['name']) # 股票名称
obj.date = datetime.now()
tsString = str(row.loc['ipo_date'])
obj.ipo_date = None
try:
obj.ipo_date = parse(tsString)
except:
logging.info(
"Fail to get date from {} from {}. Using {} as Fallback".format(
__name__, tsString, obj.ipo_date))
tsString = str(row.loc['issue_date'])
obj.issue_date = None
try:
obj.issue_date = parse(tsString)
except:
logging.info(
"Fail to get date from {} from {}. Using {} as Fallback".format(
__name__, tsString, obj.issue_date))
if obj.code is None or obj.ipo_date is None:
return None
obj.amount = toInt(row.loc['amount']) # 发行数量(万股)
obj.markets = toInt(row.loc['markets']) # 上网发行数量(万股)
obj.price = toFloat(row.loc['price']) # 发行价格(元)
obj.pe = toFloat(row.loc['pe']) # 发行市盈率
obj.limit = toFloat(row.loc['limit']) # 个人申购上限(万股)
obj.funds = toFloat(row.loc['funds']) # 募集资金(亿元)
obj.ballot = toFloat(row.loc['ballot']) # 网上中签率( %)
return obj
def rowToORM(row):
obj = Model()
tsString = str(row.loc['month'])
strs = tsString.split('.')
if len(strs) < 2:
obj.year = None
obj.month = None
logging.warning("Fail to get date from deposit rate. Using None as Fallback")
else:
obj.year = int(strs[0])
obj.month = int(strs[1])
obj.ppiip = toFloat(row.loc['ppiip']) # 工业品出厂价格指数
obj.ppi = toFloat(row.loc['ppi']) # 生产资料价格指数
obj.qm = toFloat(row.loc['qm']) # 采掘工业价格指数
obj.rmi = toFloat(row.loc['rmi']) # 原材料工业价格指数
obj.pi = toFloat(row.loc['pi']) # 加工工业价格指数
obj.cg = toFloat(row.loc['cg']) # 生活资料价格指数
obj.food = toFloat(row.loc['food']) # 食品类价格指数
obj.clothing = toFloat(row.loc['clothing']) # 衣着类价格指数
obj.roeu = toFloat(row.loc['roeu']) # 一般日用品价格指数
obj.dcg = toFloat(row.loc['dcg']) # 耐用消费品价格指数
return obj
def rowToORM(row):
obj = Model()
tsString = toStr(row.loc['month'])
strs = tsString.split('.')
if len(strs) < 2:
obj.year = None
obj.month = None
logging.warning(
"Fail to get date from deposit rate. Using None as Fallback")
else:
obj.year = int(strs[0])
obj.month = int(strs[1])
obj.cpi = toFloat(row.loc['cpi']) # cpi
return obj
def rowToORM(row):
obj = Model()
obj.year = int(row.loc['year'])
obj.end_for = toFloat(row.loc['end_for']) # 最终消费支出贡献率( %)
obj.for_rate = toFloat(row.loc['for_rate']) # 最终消费支出拉动(百分点)
obj.asset_for = toFloat(row.loc['asset_for']) # 资本形成总额贡献率( %)
obj.asset_rate = toFloat(row.loc['asset_rate']) # 资本形成总额拉动(百分点)
obj.goods_for = toFloat(row.loc['goods_for']) # 货物和服务净出口贡献率( %)
obj.goods_rate = toFloat(row.loc['goods_rate']) # 货物和服务净出口拉动(百分点)
return obj
def rowToORM(row):
obj = Model()
tsString = str(row.loc['date'])
obj.date = None
try:
obj.date = parse(tsString)
except:
logging.warning(
"Fail to get date from {} from {}. Using {} as Fallback".format(
__name__, tsString, obj.exe_date))
obj.rON = toFloat(row.loc['ON']) # 隔夜拆放利率
obj.r1W = toFloat(row.loc['1W']) # 1周拆放利率
obj.r2W = toFloat(row.loc['2W']) # 2周拆放利率
obj.r1M = toFloat(row.loc['1M']) # 1个月拆放利率
obj.r3M = toFloat(row.loc['3M']) # 3个月拆放利率
obj.r6M = toFloat(row.loc['6M']) # 6个月拆放利率
obj.r9M = toFloat(row.loc['9M']) # 9个月拆放利率
obj.r1Y = toFloat(row.loc['1Y']) # 1年拆放利率
return obj
def rowToORM(row, date: datetime):
obj = Model()
obj.attendance = toFloat(row.loc['Attendance']) # 上座率
obj.avgPeople = toFloat(row.loc['AvgPeople']) # 场均人次
obj.cinemaName = toStr(
row.loc['CinemaName'])[0:Model.TEXT_MAX_LENGTH] # 影院名称
obj.iRank = toFloat(row.loc['RowNum']) # 排名
obj.todayAudienceCount = toFloat(row.loc['TodayAudienceCount']) # 当日观众人数
obj.todayBox = toFloat(row.loc['TodayBox']) # 当日票房
obj.todayShowCount = toFloat(row.loc['TodayShowCount']) # 当日场次
obj.price = toFloat(row.loc['price']) # 场均票价（元）
obj.pk = "{name}_{date}".format(name=obj.cinemaName,
date=dateTimeToTsStr(date))
obj.date = date
obj.timestamp = date
return obj
def rowToORM(row):
obj = Model()
tsString = str(row.loc['date'])
obj.date = None
try:
obj.date = parse(tsString)
except:
logging.warning(
"Fail to get date from {} from {}. Using {} as Fallback".format(
__name__, tsString, obj.exe_date))
obj.rON_5 = toFloat(row.loc['ON_5']) # 隔夜拆放利率
obj.rON_10 = toFloat(row.loc['ON_10']) # 隔夜拆放利率
obj.rON_20 = toFloat(row.loc['ON_20']) # 隔夜拆放利率
obj.r1W_5 = toFloat(row.loc['1W_5']) # 1周拆放利率
obj.r1W_10 = toFloat(row.loc['1W_10']) # 1周拆放利率
obj.r1W_20 = toFloat(row.loc['1W_20']) # 1周拆放利率
obj.r2W_5 = toFloat(row.loc['2W_5']) # 2周拆放利率
obj.r2W_10 = toFloat(row.loc['2W_10']) # 2周拆放利率
return obj
def rowToORM(row, year, quarter):
obj = Model()
obj.code = toStr(row.loc['code']) # 股票代码
obj.name = toStr(row.loc['name']) # 股票名称
obj.type = toStr(row.loc['type'])
obj.year = int(year) # 分配年份
obj.quarter = int(quarter)
tsString = str(row.loc['report_date'])
obj.report_date = None
try:
obj.report_date = parse(tsString)
except:
logging.warning(
"Fail to get date from {} from {}. Using {} as Fallback".format(
__name__, tsString, obj.report_date))
obj.pre_eps = toFloat(row.loc['pre_eps']) # 分红金额（每10股）
obj.range = toStr(row.loc['range'])[0:255] # 转增和送股数（每10股）
return obj
def rowToORM(row):
obj = Model()
tsString = str(row.loc['quarter'])
strs = tsString.split('.')
if len(strs) < 2:
obj.year = None
obj.quarter = None
logging.warning("Fail to get date from deposit rate. Using None as Fallback")
else:
obj.year = int(strs[0])
obj.quarter = int(strs[1])
obj.gdp_yoy = toFloat(row.loc['gdp_yoy']) # 国内生产总值同比增长( %)
obj.pi = toFloat(row.loc['pi']) # 第一产业增加值(亿元)
obj.pi_yoy = toFloat(row.loc['pi_yoy']) # 第一产业增加值同比增长( %)
obj.si = toFloat(row.loc['si']) # 第二产业增加值(亿元)
obj.si_yoy = toFloat(row.loc['si_yoy']) # 第二产业增加值同比增长( %)
obj.ti = toFloat(row.loc['ti']) # 第三产业增加值(亿元)
obj.ti_yoy = toFloat(row.loc['ti_yoy']) # 第三产业增加值同比增长( %)
return obj
def rowToORM(row, code):
obj = Model()
obj.code = code # VDPP,
obj.name = toStr(row.loc['name']) # observation,
obj.industry = toStr(row.loc['industry'])
obj.area = toStr(row.loc['area'])
obj.pe = toFloat(row.loc['pe'])
obj.outstanding = toFloat(row.loc['outstanding'])
obj.totals = toFloat(row.loc['totals'])
obj.totalAssets = toFloat(row.loc['totalAssets'])
obj.liquidAssets = toFloat(row.loc['liquidAssets']) # 流动资产
obj.fixedAssets = toFloat(row.loc['fixedAssets']) # 固定资产
obj.reserved = toFloat(row.loc['reserved']) # 公积金
obj.reservedPerShare = toFloat(row.loc['reservedPerShare']) # 每股公积金
obj.esp = toFloat(row.loc['esp']) # 每股收益
obj.bvps = toFloat(row.loc['bvps']) # 每股净资
obj.pb = toFloat(row.loc['pb']) # 市净率
tsString = str(row.loc['timeToMarket']) # 上市日期
if len(tsString) < 8:
obj.timeToMarket = None
else:
year, mon, day = int(tsString[:4]), int(tsString[4:6]), int(
tsString[6:])
datetime_object = datetime(year, mon, day)
obj.timeToMarket = datetime_object
obj.undp = toFloat(row.loc['undp']) # 未分利润
obj.perundp = toFloat(row.loc['perundp']) # 每股未分配
obj.rev = toFloat(row.loc['rev'])
obj.profit = toFloat(row.loc['profit'])
obj.gpr = toFloat(row.loc['gpr'])
obj.npr = toFloat(row.loc['npr'])
obj.holders = toFloat(row.loc['holders']) # 股东人数
return obj
def rowToORM(row, year, quarter):
obj = ReportMain()
obj.code = toStr(row.loc['code']) # 代码
obj.name = toStr(row.loc['name']) # 名称
obj.year = year # year
obj.quarter = quarter # quarter
tsString = "{:04d}-{:s}".format(year, row.loc['report_date'])
if quarter >= 4:
tsString = "{:04d}-{:s}".format(year + 1, row.loc['report_date'])
obj.report_date = datetime(year=year, month=quarter * 3,
day=1) + timedelta(days=32)
try:
obj.report_date = parse(tsString) # 发布日期
if obj.report_date.month // 3 + 1 < quarter:
if quarter < 4:
obj.report_date = datetime(year=obj.report_date.year + 1,
month=obj.report_date.month,
day=obj.report_date.day)
except ValueError:
obj.report_date = datetime(year=year, month=quarter * 3,
day=1) + timedelta(days=32)
logging.warning(
'Parse date {} for code {}({}) on {}Q{} failed using fallback {}.'.
format(tsString, obj.code, obj.name, year, quarter,
obj.report_date))
pass
obj.eps = toFloat(row.loc['eps']) # 每股收益
obj.eps_yoy = toFloat(row.loc['eps_yoy']) # 每股收益同比(%)
obj.bvps = toFloat(row.loc['bvps']) # 每股净资产
obj.roe = toFloat(row.loc['roe']) # 净资产收益率(%)
obj.epcf = toFloat(row.loc['epcf']) # 每股现金流量(元)
obj.net_profits = toFloat(row.loc['net_profits']) # 净利润(万元)
obj.profits_yoy = toFloat(row.loc['profits_yoy']) # 净利润同比(%)
obj.distrib = toFloat(row.loc['distrib']) # 分配方案
obj.net_profit_ratio = toFloat(row.loc['net_profit_ratio']) # 净利率(%)
obj.gross_profit_rate = toFloat(row.loc['gross_profit_rate']) # 毛利率(%)
obj.business_income = toFloat(row.loc['business_income']) # 营业收入(百万元)
obj.bips = toFloat(row.loc['bips']) # 每股主营业务收入(元)
obj.arturnover = toFloat(row.loc['arturnover']) # 应收账款周转率(次)
obj.arturndays = toFloat(row.loc['arturndays']) # 应收账款周转天数(天)
obj.inventory_turnover = toFloat(row.loc['inventory_turnover']) # 存货周转率(次)
obj.inventory_days = toFloat(row.loc['inventory_days']) # 存货周转天数(天)
obj.currentasset_turnover = toFloat(
row.loc['currentasset_turnover']) # 流动资产周转率(次)
obj.currentasset_days = toFloat(
row.loc['currentasset_days']) # 流动资产周转天数(天)
obj.mbrg = toFloat(row.loc['mbrg']) # 主营业务收入增长率(%)
obj.nprg = toFloat(row.loc['nprg']) # 净利润增长率(%)
obj.nav = toFloat(row.loc['nav']) # 净资产增长率
obj.targ = toFloat(row.loc['targ']) # 总资产增长率
obj.epsg = toFloat(row.loc['epsg']) # 每股收益增长率
obj.seg = toFloat(row.loc['seg']) # 股东权益增长率
obj.currentratio = toFloat(row.loc['currentratio']) # 流动比率
obj.quickratio = toFloat(row.loc['quickratio']) # 速动比率
obj.cashratio = toFloat(row.loc['cashratio']) # 现金比率
obj.icratio = toFloat(row.loc['icratio']) # 利息支付倍数
obj.sheqratio = toFloat(row.loc['sheqratio']) # 股东权益比率
obj.adratio = toFloat(row.loc['adratio']) # 股东权益增长率
obj.cf_sales = toFloat(row.loc['cf_sales']) # 经营现金净流量对销售收入比率
obj.rateofreturn = toFloat(row.loc['rateofreturn']) # 资产的经营现金流量回报率
obj.cf_nm = toFloat(row.loc['cf_nm']) # 经营现金净流量与净利润的比率
obj.cf_liabilities = toFloat(row.loc['cf_liabilities']) # 经营现金净流量对负债比率
obj.cashflowratio = toFloat(row.loc['cashflowratio']) # 现金流量比率
return obj
def rowToORM(row):
obj = Model()
tsString = str(row.loc['month'])
strs = tsString.split('.')
if len(strs) < 2:
obj.year = None
obj.month = None
logging.warning(
"Fail to get date from deposit rate. Using None as Fallback")
else:
obj.year = int(strs[0])
obj.month = int(strs[1])
obj.m2 = toFloat(row.loc['m2']) # 货币和准货币（广义货币M2）(亿元)
obj.m2_yoy = toFloat(row.loc['m2_yoy']) # 货币和准货币（广义货币M2）同比增长( %)
obj.m1 = toFloat(row.loc['m1']) # 货币(狭义货币M1)(亿元)
obj.m1_yoy = toFloat(row.loc['m1_yoy']) # 货币(狭义货币M1)同比增长( %)
obj.m0 = toFloat(row.loc['m0']) # 流通中现金(M0)(亿元)
obj.m0_yoy = toFloat(row.loc['m0_yoy']) # 流通中现金(M0)同比增长( %)
obj.cd = toFloat(row.loc['cd']) # 活期存款(亿元)
obj.cd_yoy = toFloat(row.loc['cd_yoy']) # 活期存款同比增长( %)
obj.qm = toFloat(row.loc['qm']) # 准货币(亿元)
obj.qm_yoy = toFloat(row.loc['qm_yoy']) # 准货币同比增长( %)
obj.ftd = toFloat(row.loc['ftd']) # 定期存款(亿元)
obj.ftd_yoy = toFloat(row.loc['ftd_yoy']) # 定期存款同比增长( %)
obj.sd = toFloat(row.loc['sd']) # 储蓄存款(亿元)
obj.sd_yoy = toFloat(row.loc['sd_yoy']) # 储蓄存款同比增长( %)
obj.rests = toFloat(row.loc['rests']) # 其他存款(亿元)
obj.rests_yoy = toFloat(row.loc['rests_yoy']) # 其他存款同比增长( %)
return obj
def rowToORM(row):
obj = Model()
tsString = str(row.loc['date'])
obj.date = None
try:
obj.date = parse(tsString)
except:
logging.warning("Fail to get date from {} from {}. Using {} as Fallback".
format(__name__, tsString, obj.exe_date))
obj.bank = str(row.loc['bank'])
obj.rON = toFloat(row.loc['ON']) # 隔夜拆放利率
obj.rON_B = toFloat(row.loc['ON_B']) # 隔夜拆放买入价
obj.rON_A = toFloat(row.loc['ON_A']) # 隔夜拆放卖出价
obj.r1W_B = toFloat(row.loc['1W_B']) # 1周买入
obj.r1W_A = toFloat(row.loc['1W_A']) # 1周卖出
obj.r2W_B = toFloat(row.loc['2W_B']) # 买入
obj.r2W_A = toFloat(row.loc['2W_A']) # 卖出
obj.r1M_B = toFloat(row.loc['1M_B']) # 买入
obj.r1M_A = toFloat(row.loc['1M_A']) # 卖出
obj.r3M_B = toFloat(row.loc['3M_B']) # 买入
obj.r3M_A = toFloat(row.loc['3M_A']) # 卖出
obj.r6M_B = toFloat(row.loc['6M_B']) # 买入
obj.r6M_A = toFloat(row.loc['6M_A']) # 卖出
obj.r9M_B = toFloat(row.loc['9M_B']) # 买入
obj.r9M_A = toFloat(row.loc['9M_A']) # 卖出
obj.r1Y_B = toFloat(row.loc['1Y_B']) # 买入
obj.r1Y_A = toFloat(row.loc['1Y_A']) # 卖出
return obj
