Code and Datasets for Climate Action Review Analysis

This package contains the <strong>Code and Dataset for the IDAMME–GCoM climate action classification and descriptive analysis</strong>. It includes the data compiled and processed for the analysis, together with the R code used to prepare, classify, summarise, and visualise these data. All information about the code can be found in the file <strong>"_Metadata_Code_Chapter3"</strong> and all information about the data can be found in <strong>"_Metadata_Data_Chapter 3"</strong>. The data were assembled to link climate actions reported in the Global Covenant of Mayors (GCoM) database with the IDAMME classification framework, and to analyse the resulting distribution of measures, instruments, and their combinations across action types, sectors, settlement types, and implementation statuses. The file <strong>"similar_actions_gcom.csv"</strong> contains the similarity groups used to standardise GCoM action clusters, while <strong>"similar_actions_localised.csv"</strong> contains the similarity links used to connect GCoM actions to LOCALISED categories. The file <strong>"Localised_DB_Names.xlsx"</strong> provides the lookup table for IDAMME identifiers, names, and descriptions. The file <strong>"GCoM_CA.xlsx"</strong> contains the main GCoM climate action database used as the starting point for the classification process, and <strong>"df1_Signatories_5th Release.xlsx"</strong> provides the population data used to derive settlement-type categories. The preprocessing workflow, implemented in <strong>"PreProcessing.R"</strong>, assigns IDAMME categories to GCoM actions through direct matching, secondary propagation, and spread propagation, producing enriched outputs such as <strong>"GCoM_CA_with_LOC.xlsx"</strong>, <strong>"GCoM_CA_with_LOC_Final.xlsx"</strong>, and <strong>"GCoM_CA_with_LOC_Final_for_plots.xlsx"</strong>. The files <strong>"mitigation_ready_data.xlsx"</strong> and <strong>"adaptation_ready_data.xlsx"</strong> contain processed subsets prepared for downstream descriptive and graphical analyses. The file <strong>"InstrumentTypes.xlsx"</strong> supports the instrument-type regression and diagnostic analysis. The descriptive and comparative analyses are implemented in <strong>"Descriptive.R"</strong>, which generates summaries of individual IDAMME measures, instruments, and measure–instrument combinations, as well as stratified analyses by thematic category, settlement type, and implementation status. The visual outputs are produced through <strong>"Plots.R"</strong>, which creates the comparative charts, heatmaps, radar plots, and Pareto-style figures used to summarise the main findings. The files <strong>"pareto_mi_combinations_table.csv", "pareto_instruments_table.csv"</strong>, and <strong>"pareto_measures_table.csv"</strong> contain the total counts of unique measures, instruments, and combinations.

本数据包包含用于**IDAMME–GCoM气候行动分类与描述性分析的代码与数据集**。其中涵盖为开展本分析所整理与预处理的全部数据，以及用于整理、分类、汇总与可视化这些数据的R语言代码。所有代码相关信息可查阅文件**"_Metadata_Code_Chapter3"**，所有数据相关信息可在**"_Metadata_Data_Chapter 3"**中获取。

本数据集的构建目标是将全球市长盟约（Global Covenant of Mayors，GCoM）数据库中记录的气候行动与IDAMME分类框架进行关联，并分析各类举措、工具及其组合在行动类型、部门、聚居地类型与实施状态中的分布情况。

文件**"similar_actions_gcom.csv"**包含用于标准化GCoM行动集群的相似性分组，而**"similar_actions_localised.csv"**包含用于将GCoM行动与本地化分类体系相连接的相似性关联信息。

文件**"Localised_DB_Names.xlsx"**提供了IDAMME标识符、名称与描述的查询对照表。文件**"GCoM_CA.xlsx"**包含本次分类流程的核心数据源——GCoM气候行动主数据库，**"df1_Signatories_5th Release.xlsx"**则提供了用于推导聚居地类型分类的人口数据。

预处理工作流由**"PreProcessing.R"**实现，该流程通过直接匹配、二次传播与扩散传播三种方式为GCoM行动分配IDAMME分类，并生成丰富的输出文件，包括**"GCoM_CA_with_LOC.xlsx"**、**"GCoM_CA_with_LOC_Final.xlsx"**与**"GCoM_CA_with_LOC_Final_for_plots.xlsx"**。

文件**"mitigation_ready_data.xlsx"**与**"adaptation_ready_data.xlsx"**包含为后续描述性与图形分析预处理得到的细分数据集。文件**"InstrumentTypes.xlsx"**可用于支持工具类型的回归与诊断分析。

描述性与对比分析由**"Descriptive.R"**实现，该脚本可生成针对单个IDAMME举措、工具以及举措-工具组合的汇总统计，同时支持按主题类别、聚居地类型与实施状态进行分层分析。可视化成果通过**"Plots.R"**生成，该脚本可绘制对比图表、热图、雷达图与帕累托风格图形，用于总结核心研究发现。

文件**"pareto_mi_combinations_table.csv"**、**"pareto_instruments_table.csv"**与**"pareto_measures_table.csv"**包含了唯一举措、工具与组合的总计数统计信息。