/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

0 vote106 views1 answer
Outlier removal
Python
10 votes113 views3 answers
Dataframein python
Python
0 vote123 views1 answer
How to use the dot lower function
Python
0 vote95 views2 answers
Python regex words with apostrophe in middle
Python
4 votes99 views2 answers
Get terminal size python
Python
12 votes106 views4 answers
How to print list without brackets python
Python
0 vote121 views1 answer
Windows 10 reset django migrations
Python
5 votes121 views1 answer
How to get all links from a website python beautifulsoup
Python
1 vote107 views1 answer
Generate openai schema
Python
2 votes115 views1 answer
Django template tag to display current year
Python