Province_dict = {'130000': '河北省', '440000': '广东省', '610000': '陕西省',
'330000': '浙江省', '120000': '天津市', '320000': '江苏省',
'640000': '宁夏回族自治区', '500000': '重庆市', '310000': '上海市',
'150000': '内蒙古自治区', '360000': '江西省', '450000': '广西壮族自治区',
'410000': '河南省', '510000': '四川省', '650000': '新疆维吾尔自治区',
'430000': '湖南省', '420000': '湖北省', '620000': '甘肃省',
'530000': '云南省', '110000': '北京市', '350000': '福建省',
'520000': '贵州省', '140000': '山西省', '220000': '吉林省',
'460000': '海南省', '370000': '山东省', '630000': '青海省',
'210000': '辽宁省', '340000': '安徽省', '230000': '黑龙江省',
'540000': '西藏自治区'}
Province_dict_reversed = {Province_dict[key]:key for key in Province_dict}
print(Province_dict_reversed)
db = Database()
db._connect('internetDB','Hospital')
filename = 'D:/temp/hospital.xlsx'
mexcel = Excel(filename)
print(mexcel.sheetname)
for province in mexcel.sheetname:
if province in Province_dict_reversed:
province_id = Province_dict_reversed[province]
else:
print('Not Match: province')
hospital_list = mexcel.read(sheet=province)
hospital_list.pop(0)
for record in hospital_list:
def __init__(self):
# 连接AdminDatabase集合
Database.__init__(self)
self._connect('regionDB','AdminCode')
import os
from DataWarehouse.database.class_database import Database
from flask import Flask, render_template, request, redirect, url_for, jsonify
from DataWarehouse.data.class_regiondata import RegionData
import json
from bokeh.plotting import figure
from bokeh.embed import components
from werkzeug.utils import secure_filename
import flask.ext.login as flask_login
app = Flask(__name__)
app.secret_key = 'super secret string' # Change this!
# 创建初始数据
# 导入CEIC数据
db = Database()
con = db.connect('regionDB', 'CEIC')
period = range(1990,2015)
# 创建区域数据
region_list = json.load(open('e:/gitwork/application/testweb/region_ceic.txt'))
variables = con.find().distinct('variable')
rdata = RegionData()
# Our mock database.
users = {'*****@*****.**': {'pw': '123456'}}
# prepare some data
x = [1, 2, 3, 4, 5]
y = [6, 7, 2, 4, 5]
# create a new plot with a title and axis labels
p = figure(title="simple line example", x_axis_label='x', y_axis_label='y')
# add a line renderer with legend and line thickness
