You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

如何将带命名的ticker向量转换为下划线格式的字符向量?

问题描述

我有一个名为tickers的dataframe,定义如下:

tickers <- data.frame(
  country = c("Australia", "Austria", "Belgium", "Canada", "Denmark", "Finland", "France", "Germany"),
  ticker = c("SBADL Index", "SBASL Index", "SBBFL Index", "SBCDL Index", "SBDKL Index", "SBFML Index", "SBFFL Index", "SBDML Index"),
  name = NA,
  currency = NA,
  hedged = NA,
  inception = NA
)

对tickers执行如下操作后:

securities=tickers$ticker%>%setNames(tickers$country) 

得到带命名的字符向量输出:

Australia          Austria          Belgium           Canada          Denmark          Finland           France          Germany 
   "SBADL Index"    "SBASL Index"    "SBBFL Index"    "SBCDL Index"    "SBDKL Index"    "SBFML Index"    "SBFFL Index"    "SBDML Index" 
          Greece        Hong Kong          Ireland            Italy            Japan      Netherlands      New Zealand           Norway 
   "SBGRL Index" "I28692HK Index" "LETITREU Index"    "SBITL Index"    "SBJYL Index"    "SBDGL Index" "I00726NZ Index" "I00727NO Index" 
        Portugal        Singapore            Spain           Sweden      Switzerland               UK               US         Eurozone 
   "SBPEL Index"    "SBSGL Index"    "SBSPL Index"    "SBSKL Index"    "SBSZL Index"    "SBUKL Index" "LUATTRUU Index" "LEATTREU Index" 

请问如何将该输出转换为形如c("SBADL_Index", "SBASL_Index", ...)格式的无命名字符向量?


解决方案

可以通过两步操作实现需求:

  1. 提取securities的数值部分(移除命名属性)
  2. 将字符串中的空格替换为下划线

直接用一行R代码即可完成:

result <- gsub(" ", "_", unname(securities))

代码说明

  • unname(securities):移除向量的命名标签,得到仅包含原始ticker字符串的普通向量
  • gsub(" ", "_", ...):全局替换所有空格为下划线,将"SBADL Index"转换为"SBADL_Index"

执行后result即为目标格式,示例输出:

> result
 [1] "SBADL_Index"    "SBASL_Index"    "SBBFL_Index"    "SBCDL_Index"    "SBDKL_Index"    "SBFML_Index"    "SBFFL_Index"   
 [8] "SBDML_Index"    "SBGRL_Index"    "I28692HK_Index" "LETITREU_Index" "SBITL_Index"    "SBJYL_Index"    "SBDGL_Index"   
[15] "I00726NZ_Index" "I00727NO_Index" "SBPEL_Index"    "SBSGL_Index"    "SBSPL_Index"    "SBSKL_Index"    "SBSZL_Index"   
[22] "SBUKL_Index"    "LUATTRUU_Index" "LEATTREU_Index"

内容的提问来源于stack exchange,提问作者Siddharth Somani

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.07.11 03:35:14