This is a sciprt purely written in pyhton language. The general workflow of this script is to pull data from various sources (from SQL database, excel, csv ect), do data transformation, calculate statistic from data, generate varios kind of graph for data visualisation, the exportd the result in a single pdf report.

Several types of Python packages were used in building this script, including pandas for data transformation, geopandas for handling spatial data, matplotlib, mpltern, matplotlib, plotly, and seaborn for creating various types of graphs, numpy for statistical calculations, and fpdf for generating PDF files.

This script is suitable for automating routine reports that are repetitive and time-consuming, making the work faster and more efficient, while also reducing the risk of errors in calculations.