-- coding: utf-8 --

"""
Created on Thu Jan 9 11:36:00 2020

@author: QIAOQICHAO258
"""

import pandas as pd
import numpy as np
import time
from tqdm import tqdm
import codecs
import csv
import os
from math import radians, cos, sin, asin, sqrt
import math
from xgboost import XGBRegressor
from sklearn.model_selection import GridSearchCV
from sklearn.preprocessing import minmax_scale
from sklearn.metrics import mean_absolute_error

cols_dict =
{'bazhuayu_case.case_type': '案例类型',
'bazhuayu_case.case_source': '案例来源',
'bazhuayu_case.district': '区域',
'bazhuayu_case.community_sources': '案例源小区名称',
'bazhuayu_case.flr_total_ind': '总楼层',
'bazhuayu_case.checked_time': '看房次数',
'bazhuayu_case.attention_time': '关注量',
'bazhuayu_case.browse_time': '浏览次数',
'bazhuayu_case.list_time': '挂牌时间',
'bazhuayu_case.transaction_time': '成交时间',
'bazhuayu_case.list_totalprice': '挂牌总价（万元）',
'bazhuayu_case.list_unitprice': '挂牌单价（元/㎡）',
'bazhuayu_case.transaction_price': '成交总价（万元）',
'bazhuayu_case.transaction_avg_price': '成交单价（元/㎡）',
'bazhuayu_case.community_price': '案例源小区均价（元/㎡）',
'bazhuayu_case.transaction_cycle': '成交周期',
'bazhuayu_case.price_adjustment_times': '调价次数',
'bazhuayu_case.longitude': '经度',
'bazhuayu_case.latitude': '纬度'}

pi = math.pi
EARTH_REDIUS = 6378.137

经度系数 1米所对应的经度

LONGITUDE_COEF = 0.000011

纬度系数 1米所对应的度度

LATITUDE_COEF = 0.000009