Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Python Data Analysis, Second Edition

You're reading from   Python Data Analysis, Second Edition Data manipulation and complex data analysis with Python

Arrow left icon
Product type Paperback
Published in Mar 2017
Publisher Packt
ISBN-13 9781787127487
Length 330 pages
Edition 2nd Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Ivan Idris Ivan Idris
Author Profile Icon Ivan Idris
Ivan Idris
Arrow right icon
View More author details
Toc

Table of Contents (16) Chapters Close

Preface 1. Getting Started with Python Libraries FREE CHAPTER 2. NumPy Arrays 3. The Pandas Primer 4. Statistics and Linear Algebra 5. Retrieving, Processing, and Storing Data 6. Data Visualization 7. Signal Processing and Time Series 8. Working with Databases 9. Analyzing Textual Data and Social Media 10. Predictive Analytics and Machine Learning 11. Environments Outside the Python Ecosystem and Cloud Computing 12. Performance Tuning, Profiling, and Concurrency A. Key Concepts
B. Useful Functions C. Online Resources

Dataset - databases for lazy people


Dataset is a Python library which is basically a wrapper around SQLAlchemy. It claims to be so easy to use that even lazy people like it.

Install dataset as follows:

$ pip3 install dataset

Create a SQLite in-memory database and connect to it:

import dataset 
db = dataset.connect('sqlite:///:memory:') 

Create a table called books:

table = db["books"] 

Actually, the table in the database isn't created yet, since we haven't specified any columns. We only created a related object. The table schema is created automatically from calls to the insert() method. Give the insert() method dictionaries with book titles:

table.insert(dict(, author='Ivan Idris')) 
table.insert(dict(,  
author='Ivan Idris')) 
table.insert(dict(,  
author='Ivan Idris')) 

Print the rows from the table as follows:

for row in db['books']: 
   print(row) 

The following will be printed:

<dataset.persistence.util.ResultIter object at 0x10d4bf550>  
OrderedDict([('id', 1), ('title', "NumPy Beginner...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at R$50/month. Cancel anytime