Foundations for Analytics with Python by Clinton W. Brownley

Author:Clinton W. Brownley
Language: eng
Format: epub, pdf
Publisher: O'Reilly Media, Inc.
Published: 2016-08-10T04:00:00+00:00

python 1db_count_rows.py

On macOS:

chmod +x 1db_count_rows.py ./1db_count_rows.py

You should see the output shown in Figure 4-4 (on Windows) or Figure 4-5 (on macOS) printed to the screen.

This output shows that there are four records in the sales table. More generally, the output also shows that we created an in-memory database, created the table sales, populated the table with four records, fetched all of the rows from the table, and counted the number of rows in the output.

Now that we understand the basic operations for creating an in-memory database, creating a table, loading data into the table, and fetching data from the table, let’s broaden our capabilities by learning how to insert data into a table and update records in a table at scale with CSV input files.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.