82841_zh-CN

liliconcom

如何合并没有键列的两行

你好JMP社区，

 

所以我正在为一位朋友做一个项目，我正在为印度联赛的板球运动员分析统计数据。我在JMP中使用互联网开放选项从互联网上获取数据。我得到下表。我想知道是否有任何方式通过JMP或SAS，我可以将行与玩家的统计数据合并在其下方的行中，该行具有玩家的团队。任何帮助都会被贬低

 

谢谢

我知道了

 

Re：如何合并没有键列的两行

谢谢你的解决方案。我编辑了脚本，以便所有团队（偶数行）的行将填充矩阵A. 

dt= current data table();
// Find all of the rows that have the teams
dt << select where( Substr( :Player, 1, 1 ) == "(" );

A= dt << Get Rows Where(Substr( :Player, 1, 1 ) == "(");

// Copy the team rows to a new table
dt2 = dt << Subset(
 Selected Rows( 0 ),
 rows(A),
 Selected columns only( 0 )
);

// Delete the team rows from the starting data table
dt << delete rows;

// Join the 2 data tables
dt3 = dt << Join( With( dt2 ), By Row Number );

Re：如何合并没有键列的两行

这是一种方法。  它将数据分成两个表，然后根据行号将它们合并在一起。  我正在使用脚本执行此操作，但脚本是通过执行此操作的交互式步骤构建的，并复制JMP创建的脚本。  我正在使用缩短的数据表，因为我很懒，不喜欢打字。

Names Default To Here( 1 );
// Create a sample data table
dt = New Table( "Untitled 10",
 Add Rows( 6 ),
 New Column( "Player",
  Character,
  "Nominal",
  Set Values( {"AR Bawne", "(Delhi Daredevils)", "VR Aaron", "(Kings XI Punjab)", "AD Nath", "(Gujarat Lions)"} ),
  Set Display Width( 122 )
 ),
 New Column( "Mat",
  Character,
  "Nominal",
  Set Values( {"1", "(Delhi Daredevils)", "6", "(Kings XI Punjab)", "1", "(Gujarat Lions)"} ),
  Set Display Width( 137 )
 ),
 New Column( "Inns",
  Character,
  "Nominal",
  Set Values( {"1", "(Delhi Daredevils)", "2", "(Kings XI Punjab)", "1", "(Gujarat Lions)"} ),
  Set Display Width( 160 )
 )
);

wait(3);

// Find all of the rows that have the teams
dt << select where( Substr( :Player, 1, 1 ) == "(" );

// Copy the team rows to a new table
dt2 = dt << Subset(
 Selected Rows( 0 ),
 Rows( [2, 4, 6] ),
 Selected columns only( 0 )
);

// Delete the team rows from the starting data table
dt << delete rows;

// Change the columns to numeric in the starting data table(just because)
For( i = 2, i <= N Cols( dt ), i++,
 Column( dt, i ) << data type( numeric ) <<
 modeling type( continuous )
);

// Join the 2 data tables
dt3 = dt << Join( With( dt2 ), By Row Number );