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