Water Quality Monitoring Dataset (Ireland)

This study utilizes water quality data from <b>Cork Harbour, Moy Killala, and 15 other coastal locations in Ireland</b>. The Environmental Protection Agency (EPA) of Ireland manages and evaluates this dataset as part of their monitoring program. The extracted data comprises 445,125 entries from Cork Harbour, 722,532 entries from Moy Killala, and 15 other randomly selected locations, all stored in .csv format. Upon merging these disparate .csv files, the dataset expanded to 1,276,654 entries. Following a pivot operation on <b>11 parameters</b> (<b>Alkalinity-total (as CaCO3), Ammonia-Total (as N), BOD - 5 days (Total), Chloride, Conductivity @25°C, Dissolved Oxygen, ortho-phosphate (as P) - unspecified, pH, Temperature, Total Hardness (as CaCO3), True Colour</b>), the dataset was reduced to <b>29,159 rows</b>. The selection of parameters was based on their availability across the entire dataset and aimed at encompassing fundamental measurements of water quality.This repository has two csv files:Water Quality Monitoring Dataset_ Ireland.csv - with Raw Water Quality DataWQI Results on Dataset - Which has the calculated Water Quallity Indices (CCME, WAWQI, Horton, SRDD, Brown) results of water quality

本研究采用了<b>爱尔兰科克港（Cork Harbour）、莫伊基拉拉（Moy Killala）及另外15个沿海监测点位</b>的水质数据。爱尔兰环境保护署（Environmental Protection Agency, EPA）作为其监测项目的组成部分，对本数据集开展管理与评估工作。
提取得到的原始数据包含：科克港数据集445,125条记录，莫伊基拉拉数据集722,532条记录，其余15个随机选取的监测点位数据，所有数据均以.csv格式存储。将这些分散的CSV文件合并后，总数据集规模扩充至1,276,654条记录。
随后对<b>11项水质参数</b>（<b>总碱度（以CaCO₃计）、总氨氮（以N计）、5日生化需氧量（总量）、氯化物、25℃电导率、溶解氧、正磷酸盐（以P计，未指定具体形态）、pH值、水温、总硬度（以CaCO₃计）、真色度</b>）进行透视操作，最终数据集缩减至<b>29,159行</b>。参数的选取依据为其在全数据集内的可获取性，旨在覆盖水质基础监测指标。
本数据集仓库包含两份CSV文件：
1. Water Quality Monitoring Dataset_ Ireland.csv：包含原始水质监测数据；
2. WQI Results on Dataset：包含本数据集经计算得到的水质指数（CCME、WAWQI、Horton、SRDD、Brown）结果。