import pymysql
mydb = pymysql.connect(host="localhost",# ①
user='root',
password='********',
db="books",)
cursor = mydb.cursor()# ②
sql ="select * from mybooks"# ③
cursor.execute(sql)# ④
datas = cursor.fetchall()# ⑤for data in datas:print(data)
import pandas as pd
df = pd.read_sql_query(sql, con=mydb, index_col='id')
df
D:\CS\Apps\anaconda\anaconda3\envs\ai\lib\site-packages\pandas\io\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy
warnings.warn(
D:\CS\Apps\anaconda\anaconda3\envs\ai\lib\site-packages\pandas\io\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy
warnings.warn(
index
Hospital Name
Address
City
State
ZIP Code
County Name
Phone Number
Hospital Type
Hospital Ownership
...
Readmission national comparison footnote
Patient experience national comparison
Patient experience national comparison footnote
Effectiveness of care national comparison
Effectiveness of care national comparison footnote
Timeliness of care national comparison
Timeliness of care national comparison footnote
Efficient use of medical imaging national comparison
Efficient use of medical imaging national comparison footnote