Databases
StackOverflow2013
Postsdbo
POR/zoo: index entries in ‘order.by’ are not unique
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POR/zoo: index entries in ‘order.by’ are not unique
    primarykey
    data
    text
    <p>I have a .csv file containing 4 columns of data against a column of dates/times at one-minute intervals. Some timestamps are missing, so I'm trying to generate the missing dates/times and assign them NA values in the Y columns. I have previously done this with other .csv files with exactly the same formatting, with no issues. The code is:</p> <pre><code># read the csv file har10 = read.csv(fpath, header=TRUE); # set date har10$HAR.TS&lt;-as.POSIXct(har10$HAR.TS,format="%y/%m/%d %H:%M") # convert to zoo df1.zoo&lt;-zoo(har10[,-1],har10[,1]) #set date to Index # merge and generate NAs df2 &lt;- merge(df1.zoo,zoo(,seq(start(df1.zoo),end(df1.zoo),by="min")), all=TRUE) # write zoo object to .csv file in Home directory write.zoo(df2, file = "har10fixed.csv", sep = ",") </code></pre> <p>My data looks like this (for an entire year, more or less) after conversion to POSIXct, which seems to go fine:</p> <pre><code> HAR.TS C1 C2 C3 C4 1 2010-01-01 00:00:00 -4390.659 5042.423 -2241.6344 -2368.762 2 2010-01-01 00:01:00 -4391.711 5042.056 -2241.1796 -2366.725 3 2010-01-01 00:02:00 -4390.354 5043.003 -2242.5493 -2368.786 4 2010-01-01 00:03:00 -4390.337 5038.570 -2242.7653 -2371.289 </code></pre> <p>When I the "convert to zoo" step I get the following error:</p> <pre><code> Warning message: In zoo(har10[, -1], har10[, 1]) : some methods for “zoo” objects do not work if the index entries in ‘order.by’ are not unique </code></pre> <p>I have checked for duplicated entries but get no results:</p> <pre><code>&gt; anyDuplicated(har10) [1] 0 </code></pre> <p>Any ideas? I have no idea why I'm getting this error on this file, but it has worked for previous ones. Thanks!</p> <hr> <p>EDIT: Reproducable form:</p> <p>EDIT 2: Have to remove the data/code, sorry!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJohn Paul
    1. USJames A
    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. POR/zoo: index entries in ‘order.by’ are not unique
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POR/zoo: index entries in ‘order.by’ are not unique
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POR/zoo: index entries in ‘order.by’ are not unique
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COI tried setting it to GMT but no dice. The data was recorded in JST (Japan Standard Time) so there is no DST. Also I have successfully run the same code on three other .csv files, with the exact same formatting, including the same date/time range in one case. That's what's throwing me - I don't know why this should be different.
      singulars
      1. POR/zoo: index entries in ‘order.by’ are not unique
      1. USJames A
    2. COI've edited my original post to include my file (Dropbox link) and full code. I'll have to remove it after solving the problem, though.
      singulars
      1. POR/zoo: index entries in ‘order.by’ are not unique
      1. USJames A
    3. COTry it with the first half of the data and the xecond half of the data separately and keep doing that until you can reproduce the problem with just a few rows of data. Then post just that.
      singulars
      1. POR/zoo: index entries in ‘order.by’ are not unique
      1. USG. Grothendieck
 

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