[Python] Cookbook

• Import file in a different/common-used folder

import sys
sys.path.insert(1, '/path/to/application/app/folder')
import file

importing-files-from-different-folder

• Run system commands without using os.system()

import subprocesssubprocess.call(["ls", "-lt"])

This command calls the shell script and returns the system output and return code attribute (e.g., 0 for no error, 1 for error). This will wait for the completed process.

[QGIS] Join csv file with shape file

Use add vector layer to link csv attribute table to an existing shapefile in QGIS by keeping the number format, without recognized as string text:

https://gis.stackexchange.com/questions/29606/changing-csv-layer-attribute-value-from-text-to-number-in-qgis

https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/