8:GRU预测数据预处理

# 机器学习预测数据预处理

from pygeohash import encode, decode
import plotly
import numpy as np
import pandas as pd
import math
from matplotlib.path import Path
import numpy as np
import plotly.offline as of
import plotly.graph_objs as go
import chart_studio.plotly as py
import numpy as np
import pandas as pd
import folium
import webbrowser
from folium.plugins import HeatMap
import datetime
import time
import pymysql
import pymysql.cursors
import pandas as pd
import decimal
import geohash

def mysql(geo):
    print('数据库开始读取')
    conn = pymysql.connect(
        host='localhost',
        port=3306,
        user='root',
        passwd='xu19931026',
        db='hk_taxi',
        charset='utf8'
    )
    cursor = conn.cursor()  # 获取游标
    sql = "SELECT DATE_FORMAT(departure_time,'%%Y-%%m-%%d') as demand_time ,left(`geo`,7) as geo,count(0) as count FROM haikou_1 where left(`geo`,6)=%s AND DATE_FORMAT(departure_time,'%%Y-%%m-%%d') BETWEEN '201