python-pandas and databases like mysql

by

As Wes says, io/sql’s read_sql will do it, once you’ve gotten a database connection using a DBI compatible library. We can look at two short examples using the MySQLdb and cx_Oracle libraries to connect to Oracle and MySQL and query their data dictionaries. Here is the example for cx_Oracle:

import pandas as pd
import cx_Oracle

ora_conn = cx_Oracle.connect('your_connection_string')
df_ora = pd.read_sql('select * from user_objects', con=ora_conn)    
print 'loaded dataframe from Oracle. # Records: ', len(df_ora)
ora_conn.close()

And here is the equivalent example for MySQLdb:

import MySQLdb
mysql_cn= MySQLdb.connect(host="myhost", 
                port=3306,user="myusername", passwd='mypassword', 
                db='information_schema')
df_mysql = pd.read_sql('select * from VIEWS;', con=mysql_cn)    
print 'loaded dataframe from MySQL. records:', len(df_mysql)
mysql_cn.close()

More Related Contents:

  1. Filter pandas DataFrame by substring criteria
  2. Adding value labels on a matplotlib bar chart
  3. Binning a column with Python Pandas
  4. Pandas column of lists, create a row for each list element
  5. Compare two DataFrames and output their differences side-by-side
  6. Selecting a row of pandas series/dataframe by integer index
  7. How to plot and annotate a grouped bar chart
  8. pandas: merge (join) two data frames on multiple columns
  9. Pandas Extract Number from String
  10. How do I find numeric columns in Pandas?
  11. How do I find the closest values in a Pandas series to an input number?
  12. How to display custom values on a bar plot
  13. How do I count the NaN values in a column in pandas DataFrame?
  14. getting the index of a row in a pandas apply function
  15. How to flatten a pandas dataframe with some columns as json?
  16. pandas groupby to nested json
  17. Pandas Merge on Name and Closest Date
  18. Pandas won’t fillna() inplace
  19. Pandas: Difference between pivot and pivot_table. Why is only pivot_table working?
  20. Running sum in pandas (without loop)
  21. Leave dates as strings using read_excel function from pandas in python
  22. How to estimate how much memory a Pandas’ DataFrame will need?
  23. FastAPI is very slow in returning a large amount of JSON data
  24. Boxplot of Multiple Columns of a Pandas Dataframe on the Same Figure (seaborn)
  25. Pandas parse non-english string dates
  26. Filtering pandas dataframe with multiple Boolean columns
  27. Parse a Pandas column to Datetime when importing table from SQL database and filtering rows by date
  28. Pandas: Incrementally count occurrences in a column
  29. reading multiple files contained in a zip file with pandas
  30. How to filter a DataFrame column of lists for those that contain a certain item

Leave a Comment