Day 1: Introduction?

Introduction to Hydrological Data Management, Need of course.

Day 2: Introduction to SQLite?

Why SQLite? Installation of DB Browser for SQLite, Basic Syntaxes in SQL

Day 3: Working on SQLite?

Writing queries in SQL for data slicing, dicing

Day 4: Introduction to Python?

Python in Water Resource, PyCharm as IDE, Basic Python syntaxes

Day 5: Coding in Python?

Pandas Data Frame, Working on Pandas

Day 6: Retrieving Hydrological Data available in Excel?

How to get hydrological data in Pandas Data Frame?

Day 7: USGS Data Retrieval?

USGS Stations, Retrieving data from USGS NWIS, A comparison with DHM Nepal.

Day 8: Integrating Python and SQLite?

Read and write SQLite database using Python

Day 9: Integrating Python and SQLite and conclusion?

A complete project example

Course materials link

Day 1 : Introduction to Hydro Data Modelling

Price Based Country test mode enabled for testing Nepal. You should do tests on private browsing mode. Browse in private with Firefox, Chrome and Safari