Untitled Dataset of the removal of Bt by KumanoItem

Dataset for the Bt removal submitted to AFE.Description of the data and file structureThese data were collected as part of a field experiment designed to evaluate the effects of invasive bumblebee (Bombus terrestris) removal on pollination dynamics, floral visitation behavior, and agricultural productivity in squash fields. Observations and manipulations were conducted between 2022, 2024 and 2025 in Obihiro, Hokkaido, Japan.<br>Files and variables<br>File: pol1c.csv<br>Description: This data was collected to assess the invasive bumblebee on fruit production (fruit weight and the number of seeds). Observations were conducted during the flowering season in 2022 (control) and 2024 (Bt removal) in Obihiro, Hokkaido, Japan.<br>Variables<br>flowerID : Flower ID (not used in the analysis).<br>fruit_weight: Weight of fruits (g).<br>fruited: Whether the focal flower fruited or not.<br>seed: Number of seeds in the fruits.<br>Year: 2022(control) or 2024(Bt removed).<br><br><br>File: pol1v.csv<br>Description:  This data was collected to assess the flower-visit behavior of bumblebees and the pollen deposition. Observations were conducted during the flowering season in 2022 (control) and 2024 (Bt removal) in Obihiro, Hokkaido, Japan.<br>Variables<br>flower_ID: Flower ID (not used in the analysis).<br>time_of_day: Time of day when the observation was conducted.<br>pollen: Number of pollen deposited on the stigma.<br>count: Number of individuals that visited the flower during monitoring.<br>total_visitation_time: Total visitation duration.<br><br><br>File: Removal_of__Bt.csv<br>Description: This dataset documents queen removal efforts of the invasive bumblebee Bombus terrestris as part of a field experiment conducted in 2022–2025 to evaluate the ecological consequences of removing this non-native pollinator from squash agroecosystems in Hokkaido, Japan.<br>Variables<br>Year: 2022, 2024, and 2025<br>Removal of Bt queens: Whether the year corresponds to the Bt queen removal year.<br>Number of removals: Number of removal days (days on which removal was conducted).<br>Participants: Total number of participants in each year who conducted Bt queen removals (persons).<br>Number of removed Bt queens: The results of Bt queen removal in each year.<br>Number of removed Bt workers: Number of Bt workers mistakenly captured.<br>Number of monitored Bt workers: Number of observed Bt workers on the squash flowers in 2022 and 2024.<br>Number of recorded Vespula: Number of observed Vespula individuals on the squash flowers in 2024.<br>Video footage hour: Total monitored duration using video.<br>Number of observed flowers: Total number of monitored flowers in each season.<br>Number of removed Bt queens in Hokkaido: Number of removed Bt queens in Hokkaido prefecture provided by HoBiCC (Hokkaido Biodiversity Conservation Center).<br>Number of removed Bt queens in Obihiro: Number of removed Bt queens in Obihiro city provided by HoBiCC.<br><br><br>File: single.csv<br>Description: This dataset was collected to assess the single visitation of the bumblebees on the pollen transfer. Observations were conducted during the 2022 flowering season in Obihiro, Hokkaido, Japan.<br>Variables<br>ID1: Flower ID (not used in the analysis).<br>day_since_start: Day index since the start of observations (Day 1 = 21 July).<br>time_of_day: Time of day when the observation was conducted.<br>pollen: Number of pollen deposited on the stigma.<br>fruited: Whether the focal flower fruited or not.<br>head: Head width of the visited individuals.<br><br><br>File: vespula.csv<br>Description: <br>Variables<br>flower_ID: Flower ID (not used in the analysis).<br>time_of_day: Time of day when the observation was conducted.<br>pollen: Number of pollen deposited on the stigma.<br>count: Number of individuals that visited the flower during monitoring.<br>total_visitation_time: Total visitation duration.<br><br><br>File: Temperature.csv<br>Description: Data on temperature and rainfall during the experimental periods were obtained from the university’s weather station.<br>Variables<br>Year: 2022 and 2024<br>Month: From April to August<br>Day: From 1 to 30 or 31.<br>Rain: Total rainfall for the day (mm/day).<br>Temp: Mean temperature for the day (°C, daily mean).<br><br><br>Code/software<br>All analysis was conducted on R. Used code was shown in the R_code_Kumano.txt file.

提交给AFE的Bt移除数据集。数据与文件结构说明
本数据集源自一项田间试验，旨在评估入侵性熊蜂（Bombus terrestris）移除对南瓜田授粉动态、花朵访花行为以及农业生产力的影响。观测与操控实验于2022、2024至2025年间在日本北海道带广市开展。

文件与变量
文件：pol1c.csv
描述：本数据用于评估入侵性熊蜂对果实产量（果实重量与种子数量）的影响。观测于2022年（对照组）与2024年（Bt移除组）的开花季在日本北海道带广市开展。
变量
flowerID：花朵ID（分析中未使用）
fruit_weight：果实重量（单位：克）
fruited：目标花朵是否坐果
seed：果实内的种子数量
Year：2022（对照组）或2024（Bt移除组）

文件：pol1v.csv
描述：本数据用于评估熊蜂的花朵访花行为与花粉沉积情况。观测于2022年（对照组）与2024年（Bt移除组）的开花季在日本北海道带广市开展。
变量
flower_ID：花朵ID（分析中未使用）
time_of_day：观测开展的当日时段
pollen：柱头上沉积的花粉数量
count：监测期间访花的个体数量
total_visitation_time：总访花时长

文件：Removal_of__Bt.csv
描述：本数据集记录了入侵性熊蜂（Bombus terrestris）蜂王移除工作的相关信息，作为2022–2025年间田间试验的一部分，旨在评估从日本北海道南瓜农田中移除该非原生授粉蜂种后的生态效应。
变量
Year：2022、2024与2025
Removal of Bt queens：该年份是否为Bt蜂王移除年份
Number of removals：移除天数（开展移除工作的日期数）
Participants：每年开展Bt蜂王移除工作的总参与人数（单位：人）
Number of removed Bt queens：各年度Bt蜂王移除总数
Number of removed Bt workers：误捕的Bt工蜂数量
Number of monitored Bt workers：2022年与2024年在南瓜花上观测到的Bt工蜂数量
Number of recorded Vespula：2024年在南瓜花上观测到的胡蜂（Vespula）个体数量
Video footage hour：视频监测总时长
Number of observed flowers：每个观测季内的总监测花朵数
Number of removed Bt queens in Hokkaido：北海道生物多样性保护中心（HoBiCC, Hokkaido Biodiversity Conservation Center）提供的北海道地区Bt蜂王移除数量
Number of removed Bt queens in Obihiro：北海道生物多样性保护中心（HoBiCC）提供的带广市地区Bt蜂王移除数量

文件：single.csv
描述：本数据集用于评估熊蜂单次访花对花粉传递的影响。观测于2022年开花季在日本北海道带广市开展。
变量
ID1：花朵ID（分析中未使用）
day_since_start：观测开始后的天数索引（第1天为7月21日）
time_of_day：观测开展的当日时段
pollen：柱头上沉积的花粉数量
fruited：目标花朵是否坐果
head：访花个体的头部宽度

文件：vespula.csv
描述：无
变量
flower_ID：花朵ID（分析中未使用）
time_of_day：观测开展的当日时段
pollen：柱头上沉积的花粉数量
count：监测期间访花的个体数量
total_visitation_time：总访花时长

文件：Temperature.csv
描述：实验期间的气温与降雨数据源自高校气象站。
变量
Year：2022年与2024年
Month：4月至8月
Day：1日至30日或31日
Rain：当日总降雨量（单位：毫米/天）
Temp：当日平均气温（单位：摄氏度，日平均气温）

代码与软件
所有分析均在R语言环境中完成，所用代码详见R_code_Kumano.txt文件。