Checking for non-preferred file/folder path names (may take a long time depending on the number of files/folders) ...

This resource contains some files/folders that have non-preferred characters in their name. Show non-conforming files/folders.

This resource contains content types with files that need to be updated to match with metadata changes. Show content type files that need updating.

Hydroinformatics Instruction Module Example Code: Databases and SQL in Python

Authors:
Owners:		This resource does not have an owner who is an active HydroShare user. Contact CUAHSI (help@cuahsi.org) for information on this resource.
Type:	Resource
Storage:	The size of this resource is 358.6 MB
Created:	Jan 28, 2022 at 11:25 p.m.
Last updated:	Mar 21, 2022 at 8:46 p.m.
Citation:	See how to cite this resource

Sharing Status:	Public
Views:	1083
Downloads:	100
+1 Votes:	Be the first one to this.
Comments:	No comments (yet)

Abstract

This resource contains Jupyter Notebooks with examples that illustrate how to work with SQLite databases in Python including database creation and viewing and querying with SQL. The resource is part of set of materials for hydroinformatics and water data science instruction. Complete learning module materials are found in HydroLearn: Jones, A.S., Horsburgh, J.S., Bastidas Pacheco, C.J. (2022). Hydroinformatics and Water Data Science. HydroLearn. https://edx.hydrolearn.org/courses/course-v1:USU+CEE6110+2022/about..

This resources consists of 3 example notebooks and a SQLite database.

Notebooks:
1. Example 1: Querying databases using SQL in Python
2. Example 2: Python functions to query SQLite databases
3. Example 3: SQL join, aggregate, and subquery functions

Data files:
These examples use a SQLite database that uses the Observations Data Model structure and is pre-populated with Logan River temperature data.

Subject Keywords

Deleting all keywords will set the resource sharing status to private.

Content

Learn more about the BagIt download

Select a file to see file type metadata.

Readme.md

This resource is part of a HydroLearn module for Hydroinformatics and Water Data Science.

Instructions for running code in the CUAHSI JupyterHub:

Click on "Open with" at the top right
Select CUAHSI JupyterHub and agree to terms of use
Select Python as the Server Option
Once JupyterHub opens, click to open the *.ipynb file for the example of interest
Use the Jupyter tools and run code in each cell to retrieve data, generate plots, etc.
Once the CUAHSI JupyterHub is launched, additional files associated with the resources may be opened directly (File -> Open)

Related Resources

This resource belongs to the following collections:

Title	Owners	Sharing Status	My Permission
Hydroinformatics Instruction Modules Example Code	Amber Jones	Public & Shareable	Open Access

Credits

Funding Agencies

This resource was created using funding from the following sources:

Agency Name	Award Title	Award Number
National Science Foundation	Collaborative Research: Elements: Advancing Data Science and Analytics for Water (DSAW)	1931297

How to Cite

Jones, A. S., J. S. Horsburgh, C. J. Bastidas Pacheco (2022). Hydroinformatics Instruction Module Example Code: Databases and SQL in Python, HydroShare, http://www.hydroshare.org/resource/63694236207440e6a970920e818a9f66

This resource is shared under the Creative Commons Attribution CC BY.

http://creativecommons.org/licenses/by/4.0/

Comments

There are currently no comments