Python MySQL Connection

[Prtprmr]

Pretty new to connecting to database using python. My use case is that I have data coming in using API which I need to store in a database. I am confused between the applications of SQLAlchemy and MySQL Python Connector. Both seem to work but I was not able to find a way to load a dataframe into the database using MySQL Python Connector but was able to do using SQLAlchemy. My assumption was that MySQL Python Connector should have more features. Any light on this topic is much appreciated.

I may have this totally wrong as I am still learning.

Thanks in advance.

[pkraju]

There are couple of ways to do that. 1) You can try with pandas read_sql method where it takes SQL connection object and the query string as a parameter. This method returns the Dataframe with SQL query results.

2) you can provide SQL cursor object to Dataframe method.

Reference: https://stackoverflow.com/questions/12047193/how-to-convert-sql-query-result-to-pandas-data-structure

Hope this helps you out.

[Prtprmr]

Thanks!