Databases
StackOverflow2013
Usersdbo
USTim P
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USTim P
    primarykey
    data
    text
    plurals
    1. POColumn-wise sort or top-n of matrix
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. PORcpp: neat way to compare strings derived from an R data frame?
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODebugging (line by line) of Rcpp-generated DLL under Windows
      1. USTim P
      1. VTBountyStart
    2. VO
      singulars
      1. PORDCOMEvents package in R does not load - needed to run Excel / R communication example
      1. USTim P
      1. VTBountyStart
    1. COArtem - can I confirm ValidMerge gives you the vector you expect? It'd be helpful to see the data - could you use dput() to post up here the structure of the first 100 rows of RMDB, and the associated ValidMerge vector, or something like that? [command is `dput(RMDB[1:100,])` for first 100 rows ... obviously choose a section that has a bunch of merges!] Have a neat method in my head for quickly solving the algorithm :)
      singulars
      1. POCustom Merge Function in R
      1. USTim P
    2. COThanks Artem, let me know how that goes - happy to give a hand with the final merging stage if you need it (though I think it's pretty easy: the merged outcome obviously has the same Name and Strand value as the rows that you're merging, and it inherits Start from row startpt and End from row endpt, if that makes sense). Qn: Can I just double check that the numbers going down the Start column are strictly increasing? And the same for the End column? And there's no conceivable way that the Start/End intervals could overlap (e.g. in your example, R2 could never start at 1490 rather than 1510)?
      singulars
      1. PO
      1. USTim P
    3. CO@Martin Morgan - nice reference. Though there's a certain balance between "give a man a fish" vs "teach a man to fish" here IMHO. Someone who can pick up the skills to construct a solution from scratch will find that suddenly everything with R is easier going forward, rather than always relying on bolt-ons (which in some cases might not exist). Just my two cents.
      singulars
      1. POCustom Merge Function in R
      1. USTim P
 

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