Pesticide risk during commercial apple pollination is greater for honeybees than other managed and wild bees

Data and code relating to the manuscript “Pesticide risk during commercial apple pollination is greater for honeybees than other managed and wild bees” Files are organized as follows input - contains the main data files. all_pesticide2019.csv – contains the pesticide residue data for all samples LD50.csv – contains pesticide LD50s in PPB ld50_per_bee.csv – contains pesticide LD50s in ug / honeybee nesting_type.csv – lists nesting types of the different bee samples pesticide_type.csv – lists pesticides by their type short_name.csv – lists short bee names folder “gis” hive_distance_matrix.csv – distances from each orchard to other sites sitelocation.csv – contains coordinates of sites code - contains the scripts to analyze the input files pesticide_analysis.R – is the main anaylsis for the paper unadjusted_pesticide_analysis.R – is a copy of most of the code above but without LD50 weight adjustements ld50 adjust - contains the inputs and code for the ld50 adjustments I ran ld50_adjust.R – is the code to calculate our the adjustements 2020_BeeTox_database_acute_contact_publication_final_R1.csv – is the data file taken from pamminger publication本数据集与学术论文《商业苹果授粉期间农药对蜜蜂的风险高于其他养殖蜂种与野生蜂类》相关，包含支撑该研究的数据与代码文件。文件结构如下： input 文件夹：包含核心研究数据文件 all_pesticide2019.csv：收录所有样本的农药残留数据 LD50.csv：收录以ppb（十亿分比浓度）为单位的农药半数致死剂量（LD50）数据 ld50_per_bee.csv：收录以每只蜜蜂微克数为单位的农药半数致死剂量数据 nesting_type.csv：列出不同蜂类样本的筑巢类型 pesticide_type.csv：按类别对所有农药进行分类 short_name.csv：列出蜂类的简称 gis 子文件夹： hive_distance_matrix.csv：记录每个果园与其他采样点之间的距离矩阵 sitelocation.csv：收录各采样点的坐标信息 code 文件夹：包含用于分析input文件夹内数据的脚本文件 pesticide_analysis.R：本研究的核心分析脚本 unadjusted_pesticide_analysis.R：核心分析脚本的副本，未包含半数致死剂量权重调整步骤 ld50 adjust 文件夹：包含开展半数致死剂量调整所需的输入数据与代码 ld50_adjust.R：用于计算剂量调整的代码脚本 2020_BeeTox_database_acute_contact_publication_final_R1.csv：取自Pamminger发表文献的公开数据集文件