# 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()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')