精品久久一二三区,最近最新mv字幕免费观看,久久99精品久久久久久琪琪

Python3實現mysql連接和數據框的形成，具體代碼如下所示：

				?

									# -*- coding:utf-8 -*-

									# __author__ = "LQ"

									import pymysql

									import pandas as pd

									import numpy as np

									from sklearn import preprocessing

									#返回數據庫連接

									def dbcconnect():

									  conn = pymysql.connect(host='ip', port=3306, user='username', passwd='password',db='db')

									  return conn

									#接收sql返回查詢結果

									def selects(sql):

									  conn=dbcconnect()

									  cursor = conn.cursor()

									  cursor.execute(sql)

									  # 獲取剩余結果所有數據

									  results = cursor.fetchall()

									  conn.commit()

									  cursor.close()

									  return results

									#接收sql返回數據框

									def selectDf(sql):

									  conn=dbcconnect()

									  cursor = conn.cursor()

									  cursor.execute(sql)

									  # 獲取剩余結果所有數據

									  results = cursor.fetchall()

									  # 獲取列名

									  cols = [i[0] for i in cursor.description]

									  # sql內表轉換pandas的DF

									  df = pd.DataFrame(np.array(results), columns=cols).astype(float)

									  conn.commit()

									  cursor.close()

									  return df