Estuarine and Coastal Environment, Coastal Engineering, Coastal Management, Sustainability Science


Import module or package in Python

Suppose that a main script of (or a corresponding Jupyter Notebook) exists in the directory of myproject, and its subdirectory sub contains modules of (a function of func_a () included) and (a function of func_b() included) where imports the module mod_a and the module mod_a imports the module mod_b. First, creating an empty file in the directory sub so that sub is recognized as a package as shown below: myproject/   sub/ (func_a()) (func_b()) The sub-directory, sub, containing two modules, becomes a package when is included. Import in The following is …

Handling SQLite database using Python

Suppose that the file name of SQLite’s database is mpos_S.sqlite, its table (like a sheet of Excel) name is mpos_S, and mpos_S contains column data. If the column name of water temperature data is tp, this column tp contains water temperature data. In order to handle it from Python, you need to import sqlite3. First connect to the database and get the cursor cur. >>> import sqlite3 >>> conn = sqlite3.connect(‘mpos_S.sqlite’) >>> cur = conn.cursor() Check information of columns. >>> cur.execute("PRAGMA TABLE_INFO(mpos_S)")  ### Gets information about columns of table mpos_S >>> cols = cur.fetchall()  ### Information of a column is a tuple containing 6 elements. >>> print(cols) To get only …