如何将Jupter连接MySQL
STEP1 :先确认安装了pymysql包,具体安装方法请看https://blog.csdn.net/qq_37788558/article/details/80814524
STEP2:打开Jupter,导入包
import pymysql
import pandas as pd
import sqlalchemy
STEP2:建立连接,密码为自己设置的密码,db为数据库名字,其他一般为默认
conn = pymysql.connect(
host = 'localhost',
user = 'root',
password = '*****',
db = 'TSLA',
port = 3306,
charset = 'utf8'
)
sql = 'SELECT * FROM tsla_csv WHERE High<50' #SQL语句
data_tsla = pd.read_sql(sql,conn) #利用pandas读SQL
因此我们建立好了链接并导入了我们想要的表以及SQL语句