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

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