Breaking News: Grepper is joining You.com. Read the official announcement!

working with mysql database in pandas

AICipher answered on January 27, 2021 Popularity 9/10 Helpfulness 6/10

answer working with mysql database in pandas

related mysql pandas

working with mysql database in pandas

Comment

Importing data from a MySQL database into a Pandas data frame including column names:-
import mysql.connector as sql.
import pandas as pd.
db_connection = sql.connect(host='hostname', database='db_name', user='username', password='password')
db_cursor = db_connection.cursor()
db_cursor.execute('SELECT * FROM table_name')

Popularity 9/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: database mysql pandas sql

Link to this answer
Share Copy Link

Contributed on Jan 27 2021

AICipher

0 Answers Avg Quality 2/10

Closely Related Answers

mysql pandas

Comment

# make sure to install mysql_connector library
import mysql.connector
import pandas as pd

def execute_query(sql_query, host='localhost', database='mydatabase', user='root', password='your_password'):
    # Establish a connection to the MySQL database
    conn = mysql.connector.connect(
        host=host,
        database=database,
        user=user,
        password=password
    )
    cursor = conn.cursor() # Create a cursor object to execute SQL queries
    cursor.execute(sql_query) # Execute the SQL query
    rows = cursor.fetchall() # Fetch all rows from the result set
    columns = [column[0] for column in cursor.description] # Get the column names from the cursor description
    df = pd.DataFrame(rows, columns=columns) # Create a DataFrame from the fetched rows and column names
    cursor.close() # Close the cursor 
    conn.close() # Close the database connection
    return df # Return the DataFrame


result = execute_query("SELECT * FROM table_name")
result.head()

Popularity 8/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: mysql pandas p

Link to this answer
Share Copy Link

Contributed on Feb 11 2024

Innocent Iguana

0 Answers Avg Quality 2/10

working with mysql database in pandas

Contents

More Related Answers

working with mysql database in pandas

Closely Related Answers

mysql pandas

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.