
# 清除环境并设置工作目录
rm(list=ls())
gc()
setwd(dirname(rstudioapi::getActiveDocumentContext()$path))

# 加载必要的包
library(vegan)
library(adespatial)
library(tidyverse)
library(readxl)


#########################early
########################################################################################################################
early_occ <- read_excel("early_occ.xlsx")
# 查看数据结构
head(early_occ)
str(early_occ)

# 确保第一列是站点名称，将其设置为行名
# 假设第一列名为 "...1"（根据你的输出）
species_df <- early_occ %>% 
  rename(Site = "...1") %>% 
  column_to_rownames("Site")

# 转换为矩阵
species_matrix <- as.matrix(species_df)

# 转换为存在-缺失数据(0/1)
pa_matrix <- ifelse(species_matrix > 0, 1, 0)

# 使用Hellinger变换和beta.div
pa_hell <- decostand(pa_matrix, "hellinger")

# 计算LCBD和SCBD - 使用正确的参数
pa_beta <- beta.div(pa_hell, method = "euclidean", sqrt.D = FALSE, samp = TRUE,nperm = 999)

# 提取结果

pa_scbd_early <- data.frame(
  Species = colnames(pa_matrix),
  SCBD_pa = as.numeric(pa_beta$SCBD)
)

write.csv(pa_scbd_early,"scbd_early.csv")




#####################mid
#########################################################################################################################
rm(list=ls())
mid_occ <- read_excel("mid_occ.xlsx")
# 查看数据结构
head(mid_occ)
str(mid_occ)

# 确保第一列是站点名称，将其设置为行名
# 假设第一列名为 "...1"（根据你的输出）
species_df <- mid_occ %>% 
  rename(Site = "...1") %>% 
  column_to_rownames("Site")

# 转换为矩阵
species_matrix <- as.matrix(species_df)

# 转换为存在-缺失数据(0/1)
pa_matrix <- ifelse(species_matrix > 0, 1, 0)

# 使用Hellinger变换和beta.div
pa_hell <- decostand(pa_matrix, "hellinger")

# 计算LCBD和SCBD - 使用正确的参数
pa_beta <- beta.div(pa_hell, method = "euclidean", sqrt.D = FALSE, samp = TRUE,nperm = 999)

# 提取结果

pa_scbd_mid <- data.frame(
  Species = colnames(pa_matrix),
  SCBD_pa = as.numeric(pa_beta$SCBD)
)

write.csv(pa_scbd_mid,"scbd_mid.csv")







#####################current
########################################################################################################################
rm(list=ls())
current_occ <- read_excel("current_occ.xlsx")
# 查看数据结构
head(current_occ)
str(current_occ)

# 确保第一列是站点名称，将其设置为行名
# 假设第一列名为 "...1"（根据你的输出）
species_df <- current_occ %>% 
  rename(Site = "...1") %>% 
  column_to_rownames("Site")

# 转换为矩阵
species_matrix <- as.matrix(species_df)

# 转换为存在-缺失数据(0/1)
pa_matrix <- ifelse(species_matrix > 0, 1, 0)

# 使用Hellinger变换和beta.div
pa_hell <- decostand(pa_matrix, "hellinger")

# 计算LCBD和SCBD - 使用正确的参数
pa_beta <- beta.div(pa_hell, method = "euclidean", sqrt.D = FALSE, samp = TRUE,nperm = 999)

# 提取结果

pa_scbd_current <- data.frame(
  Species = colnames(pa_matrix),
  SCBD_pa = as.numeric(pa_beta$SCBD)
)

write.csv(pa_scbd_current,"scbd_current.csv")
