安装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 MySQLdb
import pandas as pd

conn = MySQLdb.connect(host='*.*.*.*',user='root',password='123456',db = '**',port=3306,charset='utf8')
cur = conn.cursor()

#cur.execute
cur.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()