On Sat, 30 Jan 2016 20:50:17 -0500 Jim Callahan <jim.callahan.orlando at gmail.com> wrote:
> I am not interested in a complete ORM; what I am interested is when > the object-oriented language supports a SQL-R-like object. In R, the > object is called a data.frame and the package "Pandas" supplies a > similar data frame object to Python. > > R as I have mentioned has fantastic interfaces to SQL databases that > allow one to pass a query and have the result populate a data frame. > The data frame in R or Python can be fed to a machine learning > algorithm (scikit learn on Python) or to a plotting package such as > ggplot or bokeh. OK, good. It sounds lke what you're really interested in is the simplest function possible to move data from SQLite into Pandas. (I'll stick with Python, since I know it better than R.) But you already have pandas.read_sql_query. While that function isn't really what I'd call simple, the complexity afaict -- dates, floats, and chunks -- can be laid at Python's feet. At a minimum, you have to specify the SQL and the column names you want to use in Pandas. > SQLAlchemy package ... did not understand SQLite VIEWS and one had to > write an explicit loop to build the data frame.... You don't need to use SQLAlchemy with SQLite. And you don't need to write loops to move query results into a Pandas DataFrame. So, is the problem solved, or am I missing something? --jkl