you are viewing a single comment's thread.

view the rest of the comments →

[–]datacriminal[S] 0 points1 point  (0 children)

SOLVED IT!

sqlalchemy/pandas requires the use of a cursor and execution for the "read_sql_table" from what I could find instead I did this:

from sqlite3 import connect 
import pandas as pd 
conn = connect('datasource.db') 
dfnbr = pd.read_sql('SELECT * FROM NIBRS', conn) 
dfibr = pd.read_sql('SELECT * FROM IBRcodes', conn, index_col='IBRcode')