The two Python/Pandas scripts below are called by the corresponding (UN Comtrade or UNIDO) front-end programs which in turn are invoked from the Data Update page. These two scripts are located in the /var/www/wordpress/jordan/prototype/scripts/ folder. They are included here to give an idea of the data structures and manipulation involved in displaying the charts. The …
Shared MySQL instance For the production Data View/Download screen, data is being fetched from a MySQL database. We are using the same MySQL instance that was installed as part of WordPress. The schema is different (jordanio). The creation and initialization of this database is a one-time process, so it is not covered here. What is …
Most charts are made using the open source Apexcharts javascript library. Some charts use the R-based ggplot libarary. A number of folders with <Wordpress root folder>/jordan/prototype/ folder (energy, indsurvey, production, sdg, trade and youth) display charts. One particular folder, <Wordpress root folder>/jordan/prototype/chart/apexcharts, has common javascript code to handle all Apexchart charts on the Observatory (Apexchart …