2808 explained code solutions for 75 technologies


python-pandasHow to create dataframe from Mysql table


from sqlalchemy import create_engine
engine = create_engine("mysql+pymysql://test:[email protected]/test?charset=utf8mb4")

import pandas as pd
df = pd.read_sql('SELECT * FROM phones', engine, 'index')ctrl + c
sqlalchemy

lib to work with databases

create_engine

creates database connection with specified credentials

import pandas as pd

load Pandas module

.read_sql(

creates dataframe and loads data from database

'SELECT * FROM phones'

SQL query to get the data (phones table was previously created from dataframe)

engine

database connection

'index'

name of the index column


How to create dataframe from Mysql table, python pandas

Usage example

from sqlalchemy import create_engine
engine = create_engine("mysql+pymysql://test:[email protected]/test?charset=utf8mb4")

import pandas as pd
df = pd.read_sql('SELECT * FROM phones', engine, 'index')

print(df)
output
      Phone  Price  Color
index                    
0       ip5    204    red
1       ip6    304    red
2       ip8    404   gray
3       sms    405  black
4        xi    305    red