安装MySql+连接数据库+读取数据并存储成dataframe（python3.6）

环境安装

安装依赖环境

$ sudo apt-get install python-pip python-dev libmysqlclient-dev

安装MySqldb

$ pip install mysqlclient #python3.6$ pip install MySQL-python #python 2.7

连接数据库+读取数据+存储

#!/usr/bin/python# -*- coding: utf-8 -*-import MySQLdbimport pandas as pdconn = MySQLdb.connect(host='*.*.*.*',user='root',password='123456',db = '**',port=3306,charset='utf8')cur = conn.cursor()#cur.executecur.execute('select* from table_name')#sql rows = cur.fetchall()data = pd.DataFrame.from_records(list(rows))#convert tuple to list to DataFrame#data = pd.DataFrame(rows)data.to_csv('device.csv',index = False)conn.close()