Databases
StackOverflow2013
Postsdbo
POR dcast error / Find irregular IDs in a dataframe
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POR dcast error / Find irregular IDs in a dataframe
    primarykey
    data
    text
    <p>My dataframe looks like this:</p> <pre><code>ID | value A | value B 1 | A1 | F 1 | A2 | N 1 | A3 | B 1 | A4 | S 2 | A1 | B 2 | A2 | G 2 | A3 | N 3 | A1 | F 3 | A2 | H 3 | A3 | J 3 | A4 | N </code></pre> <p>So I have 4 rows for one ID each. I am trying to use the dcast() function, but it only works if all IDs have the same number of rows. ID No. 2 would be an error case in this example. Is there any easy way to find all IDs that have more or less than 4 rows? Or may be is there any way to make the dcast function ignore the error cases? </p> <p>Originally I am trying to reshape the dataframe to get something like this:</p> <pre><code>ID | A1 | A2 | A3 | A4 1 | F | N | B | S 2 | B | G | N | NA 3 | F | H | J | N </code></pre> <p>Apparently the dcast() function from the reshape2 package doesn´t work with irregular IDs. It gives me the following erros message: 'Aggregation function missing: defaulting to length' But with a smaller part of my dataset - which doesn´t have those irregular iDs - it works. Any ideas? Or may be an idea how to reshape my dataframe without using dcast? Thanks!</p> <p>I am working on a mac with the following (package-) versions:</p> <pre><code>sessionInfo() R version 2.14.1 (2011-12-22) Platform: x86_64-apple-darwin9.8.0/x86_64 (64-bit) locale: [1] de_DE.UTF-8/de_DE.UTF-8/de_DE.UTF-8/C/de_DE.UTF-8/de_DE.UTF-8 attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] reshape2_1.2.1 plyr_1.7.1 loaded via a namespace (and not attached): [1] stringr_0.6 </code></pre> <p>The first column values are all integer, the others character values. </p> <pre><code>sapply(x, class) ID fach01 f01_lp "integer" "character" "character" </code></pre> <p>As for the reproducible example: I hope this helps (I used my original dataframe), however if I only use the first 500 rows of the dataframe dcast() works perfectly fine, the problem occurs when I try to use the whole dataframe of about 140000 rows. </p> <pre><code>df &lt;- structure(list(ID = c(1L, 1L, 1L, 1L, 2L, 2L, 2L, 3L, 3L, 3L, 3L, 4L, 4L, 4L, 4L, 5L, 5L, 5L, 5L, 6L, 6L, 6L, 6L, 7L, 7L, 7L, 7L, 8L, 8L, 8L, 8L, 9L, 9L, 9L, 9L), A = c("2.LF", "1.LF", "3.PF", "4.PF", "3.PF", "1.LF", "2.LF", "3.PF", "4.PF", "1.LF", "2.LF", "3.PF", "1.LF", "4.PF", "2.LF", "1.LF", "2.LF", "4.PF", "3.PF", "1.LF", "3.PF", "2.LF", "4.PF", "3.PF", "4.PF", "1.LF", "2.LF", "4.PF", "2.LF", "3.PF", "1.LF", "1.LF", "2.LF", "3.PF", "4.PF"), B = c("Mu/Ku", "Fs", "2.AF", "NW", "DE", "2.AF", "MA", "Fs", "2.AF", "NW", "NW", "Fs", "2.AF", "bel", "NW", "Fs", "bel", "bel", "NW", "DE", "2.AF", "2.AF", "MA", "Fs", "2.AF", "MA", "NW", "DE", "2.AF", "MA", "NW", "Mu/Ku", "Fs", "2.AF", "NW")), .Names = c("ID", "A", "B" ), row.names = c("3", "5", "7", "10", "26", "29", "212", "213", "32", "35", "38", "39", "43", "44", "45", "48", "53", "56", "57", "59", "61", "65", "67", "68", "72", "75", "76", "77", "81", "86", "87", "88", "92", "93", "95", "98"), class = "data.frame") </code></pre> <p>In my original dataframe the values A1 -A4 (here called 1.PF - 4.PF) are not in the right order, this is what I want dcast to do (same as above)</p> <pre><code>ID | 1.PF | 2.PF | 3.PF | 4.PF 1 | F | NW | DE | S 2 | bel | G | N | &lt;NA&gt; 3 | F | NW | bel | N </code></pre> <p>EDIT:</p> <p>I didn´t solve the dcast() problem, but I found a way to work around it: (reshape() function from the reshape package)</p> <pre><code>df &lt;- reshape(df, idvar='ID', varying = NULL, timevar = 'value A', direction='wide') </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USElisa
    1. USElisa
    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
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COUsing `dcast` I get exactly what you want -- see below (??)
      singulars
      1. POR dcast error / Find irregular IDs in a dataframe
      1. USBen Bolker
    2. COSo, then why am I not getting what I want. What else could be wrong with my dataframe?
      singulars
      1. POR dcast error / Find irregular IDs in a dataframe
      1. USElisa
    3. COTo go any further we need a *reproducible* example: my example below works for me, and I don't have anything else to work with. If my example below *doesn't* work for you then it's a difference between software versions (you haven't said what version of R/reshape2 you're using); if it does, but your original data doesn't, then it's something about your data. Take a look at http://tinyurl.com/reproducible-000 ...
      singulars
      1. POR dcast error / Find irregular IDs in a dataframe
      1. USBen Bolker
 

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