import mysql.connector
import pandas as pd
# Connect to MySQL
db = mysql.connector.connect(
host="jaredcoffin.com",
user="jcffn",
password="TWER1255",
database="jmon"
)
# preparing SQL and cursor object
query = "SELECT * FROM Animalytix LIMIT 100"
cursor = db.cursor()
cursor.execute(query)
myresult = cursor.fetchall()
# disconnecting from server
db.close()
cols = [ column[0] for column in cursor.description ]
df = pd.DataFrame(myresult, columns=cols)
print(df)
A simple pull from MySQL that outputs to a Dataframe with column names from the table.
Product Manufacturer Category … Quantity City StateCode
0 Jardiance BI Vaccine … 59 Ariasland AK
1 Pradaxa BI Parasiticide … 3 West Geraldport AZ
2 Spiriva BI Parasiticide … 5 Washingtonmouth IA
3 Apoquel Zoetis Vaccine … 122 South William IN
4 Nobivac Merck Parasiticide … 202 North Anneville OH
.. … … … … … … …
95 Apoquel Zoetis Parasiticide … 76 Biancaport VT
96 Sentinel Merck Parasiticide … 28 Meganberg OK
97 Apoquel Zoetis Parasiticide … 0 Lake Jerry NE
98 Spiriva BI Vaccine … 1 Sandrastad CA
99 Spiriva BI Parasiticide … 19 Port Sharonville AL
[100 rows x 8 columns]
Process finished with exit code 0
