/Python/Connect to mysql database jupyter

Connect to mysql database jupyter

# In the python cmd, install packages:
pip3 install pymysql
pip3 install ipython-sql
pip3 install mysqlclient

# in the jupyter notebook:
import pymysql
import pandas as pd

conn=pymysql.connect(host='localhost',port=int(3306),user='root',passwd='YOUR_PASSWORD',db='YOUR_DATABASENAME')

df=pd.read_sql_query("SELECT * FROM 'YOUR_TABLENAME' ",conn)

print(df)

Source: stackoverflow.com

How to connect mysql database in jupyter notebook

# %%
%load_ext sql

# %%
%sql mysql+mysqldb://<user>:<password>@localhost/<dataBase>

# %%
%%sql

SELECT *
FROM <table>;

Source: stackoverflow.com

Similar codes

26 votes264 views6 answers
List files python
Python
0 vote180 views1 answer
Django rest framework multiple user registration
Python Django
0 vote191 views1 answer
Light fm cold start problem
Python
0 vote179 views1 answer
Value_counts to list
Python
0 vote186 views2 answers
Leer fichero de texto con columnas como diccionario python
Python
6 votes209 views5 answers
How to redirect in django
Python Django
1 vote174 views2 answers
Assigning crs using python pyproj
Python
0 vote184 views1 answer
Km/h to mph python
Python
19 votes191 views5 answers
Combine dataframes
Python
8 votes174 views2 answers
Json load from file python 3
Python