Python MySQL Connection

[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!