347226_zh-CN

liliconcom

使用关联数组重命名列

嗨，我正在尝试使用关联数组来重命名一堆列。 我一直以Big Class数据为例。 我会感谢一些修复脚本的帮助。

Names Default To Here( 1 );
dt = Data Table ("Big Class.jmp");
//Use and array to rename the Big Class table columns to "spanish"
newColNames = Associative Array();
newColNames["name"] = "nombre";
newColNames["age"] = "edad";
newColNames["sex"] = "sexo";
newColNames["height"] = "altura";
newColNames["weight"] = "peso";

uno = newColNames << Get Keys(); //for testing

newN = newColNames << Get Values({"name"}); //for testing

oriNames = dt << Get Column Names(); // in case there are variation on the number/name of columns

For( i=1, 1 <= N Items(oriNames), i++,
key = oriNames[i];

 Column(dt, key ) << set name (newColNames<<GET values=""></GET>

数据表脚本编写回复：使用关联数组重命名列

您非常接近：

Names Default To Here( 1 );

dt = Open("$SAMPLE_DATA/Big Class.jmp");

//Use and array to rename the Big Class table columns to "spanish"
newColNames = Associative Array();
newColNames["name"] = "nombre";
newColNames["age"] = "edad";
newColNames["sex"] = "sexo";
newColNames["height"] = "altura";
newColNames["weight"] = "peso";

oriNames = dt << Get Column Names("String");  // in case there are variation on the number/name of columns

For( i=1, i <= N Items(oriNames), i++,
 key = oriNames[i];
 Column(dt, key ) << set name ( newColNames << Get Value (key) );
); 

回复：使用关联数组重命名列

@ian_jmp花了我很长时间才看到“ 1”！

dt = Open( "$sample_data/Big Class.jmp" );
//Use and array to rename the Big Class table columns to "spanish"
newColNames = Associative Array();
newColNames["name"] = "nombre";
newColNames["age"] = "edad";
newColNames["sex"] = "sexo";
newColNames["height"] = "altura";
newColNames["weight"] = "peso";

uno = newColNames << Get Keys(); //for testing

newN = newColNames << Get Values( {"age"} ); //for testing

oriNames = dt << Get Column Names( "string" ); // in case there are variation on the number/name of columns

For( i = 1, i <= N Items( oriNames ), i++,
 key = oriNames[i];
 Column( dt, key ) << set name( newColNames[key] );
);