Databases
StackOverflow2013
Postsdbo
POmerge (opposite of split) pair of rows in r
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmerge (opposite of split) pair of rows in r
    primarykey
    data
    text
    <p>I have the column like the following. Each column has two pairs each with suffix "a" and "b" - for example col1a, col1b, colNa, colNb and so on till end of the file (> 50000).</p> <pre><code>mydataf &lt;- data.frame (Ind = 1:5, col1a = sample (c(1:3), 5, replace = T), col1b = sample (c(1:3), 5, replace = T), colNa = sample (c(1:3), 5, replace = T), colNb = sample (c(1:3),5, replace = T), K_a = sample (c("A", "B"),5, replace = T), K_b = sample (c("A", "B"),5, replace = T)) mydataf Ind col1a col1b colNa colNb K_a K_b 1 1 1 1 2 3 B A 2 2 1 3 2 2 B B 3 3 2 1 1 1 B B 4 4 3 1 1 3 A B 5 5 1 1 3 2 B A </code></pre> <p>Except First column (Ind), I want to collapse the pair of rows to make the dataframe look like the following, at the sametime the suffix "a" and "b" be removed. Also merged characters or number be ordered 1 first that 2, A first than B</p> <pre><code> Ind col1 colN K_ 1 11 23 AB 2 13 22 BB 3 12 11 BB 4 13 13 AB 5 11 23 AB </code></pre> <p>Edit: The grep function (probably) in the answer has problem if the name of columns are similar.</p> <pre><code>mydataf &lt;- data.frame (col_1_a = sample (c(1:3), 5, replace = T), col_1_b = sample (c(1:3), 5, replace = T), col_1_Na = sample (c(1:3), 5, replace = T), col_1_Nb = sample (c(1:3),5, replace = T), K_a = sample (c("A", "B"),5, replace = T), K_b = sample (c("A", "B"),5, replace = T)) n &lt;- names(mydataf) nm &lt;- c(unique(substr(n, 1, nchar(n)-1))) df &lt;- data.frame(sapply(nm, function(x){ idx &lt;- grep(x, n) cols &lt;- mydataf[idx] x &lt;- apply(cols, 1, function(z) paste(sort(z), collapse = "")) return(x) })) names(df) &lt;- nm df col_1_ col_1_N K_ 1 2233 23 BB 2 2233 22 BB 3 1123 13 AB 4 1223 12 AB 5 2333 33 AB </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USshNIL
    1. USshNIL
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POmerge (opposite of split) pair of rows in r
      1. USshNIL
      1. VTFavorite
    2. VO
      singulars
      1. POmerge (opposite of split) pair of rows in r
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POmerge (opposite of split) pair of rows in r
      1. USrdorlearn
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload