Skip to Content
Jupyter Cookbook
book

Jupyter Cookbook

by Toomey, Nikhil Borkar, Nikhil Akki, Juan Tomás Oliva Ramos
April 2018
Beginner content levelBeginner
238 pages
7h 13m
English
Packt Publishing
Content preview from Jupyter Cookbook

How it works...

We first connect (and automatically create) an in-memory database. The new database is empty. We populate a table in the empty database, using the iris dataset. There are some clear differences in operating with a database versus an R DataFrame:

  • The iris_db display includes what the database program is running, and the column types are not as expected in R. 
  • We see that the iris_db does not reside in the R program at all—it is completely in the database. We can see that with the NA result from our nrow(iris_db) call.
  • We can run a head(iris_db) call, and it will give results. But if you look closely, there are many database settings displayed, compared to the standard R settings.
  • When we use show_query against an iris_db
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Python Cookbook, 3rd Edition

Python Cookbook, 3rd Edition

David Beazley, Brian K. Jones
Pandas 1.x Cookbook - Second Edition

Pandas 1.x Cookbook - Second Edition

Matthew Harrison, Theodore Petrou
bash Cookbook, 2nd Edition

bash Cookbook, 2nd Edition

Carl Albing, JP Vossen

Publisher Resources

ISBN: 9781788839440Supplemental Content