如何在R中创建具有我特定模式的表？

# 加载所需的包
library(dplyr)
library(tidyr)

# 创建一个数据框
data <- data.frame(
  id = 1:10,
  name = c("Alice", "Bob", "Charlie", "David", "Eve", "Frank", "Grace", "Henry", "Ivy", "Jack"),
  age = c(25, 30, 35, 40, 45, 50, 55, 60, 65, 70),
  email = c("alice@example.com", "bob@example.com", "charlie@example.com", "david@example.com", "eve@example.com", "frank@example.com", "grace@example.com", "henry@example.com", "ivy@example.com", "jack@example.com")
)

# 创建一个新的变量，基于现有变量的模式
data <- data %>%
  mutate(gender = ifelse(substr(name, nchar(name), nchar(name)) %in% c("e", "y"), "female", "male"))

# 选择要保留的变量
data <- data %>%
  select(id, name, age, gender)

# 根据特定条件筛选观测值
data <- data %>%
  filter(age > 30)

# 对观测值进行排序
data <- data %>%
  arrange(desc(age))

# 显示结果
print(data)