Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It is not possible to use a regexp for <code>set datafile missing</code>, but you can use any program to filter you data before plotting, and replacing a regexp with one character, e.g. <code>?</code> which you set to mark a missing data point.</p> <p>Here is an example which accomplishes, what you originally requested: filtering <code>-nan</code>, <code>inf</code> etc. For testing, I used the following data file:</p> <pre><code>1 0 2 nan 3 -inf 4 2 5 -NaN 6 1 </code></pre> <p>And the plotting script may look like the following:</p> <pre><code>filter = 'sed -e "s/-\?\(nan\|inf\)/?/ig"' set datafile missing "?" set offset 0.5,0.5,0.5,0.5 plot '&lt; '.filter.' data.txt' with linespoints ps 2 notitle </code></pre> <p>This gives the following output:</p> <p><img src="https://i.stack.imgur.com/PiPpO.png" alt="enter image description here"></p> <p>So the plot command skips all missing data points. You can refine the <code>sed</code> filter to replace any non-numerical values with <code>?</code>, if this variant is not enough.</p> <p>This works fine, but allows only to select columns e.g. with <code>using 1:2</code>, but not doing computations on the columns, like e.g. <code>using ($1*0.1):2</code>. To allow this, you can filter out any row, which contains <code>nan</code>, <code>-inf</code> etc with <code>grep</code>, like its done in <a href="https://stackoverflow.com/a/7607368/2604213">gnuplot missing data with expression evaluation</a> (thanks @Thiru for the link):</p> <pre><code>filter = 'grep -vi -- "-\?\(nan\|inf\)"' set offset 0.5,0.5,0.5,0.5 plot '&lt; '.filter.' data.txt' with linespoints ps 2 notitle </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POIn gnuplot, with "set datafile missing", how to ignore both "nan" and "-nan"?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USChristoph
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIn gnuplot, with "set datafile missing", how to ignore both "nan" and "-nan"?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis is really good, thanks! Your suggested sed filter only replaces the first match by a "?". It is really fine for my purpose because gnuplot will ignore a line if there is just one "?" in it. It's a bit off-topic question now: How can the filter replace all occurrences of the relevant strings, for example with "inf -nan 2.43" the filtered one should be "? ? 2.43"
      singulars
      1. PO
      1. USuser1069609
    2. CO@user1069609 Just add a `g` behind the `i` in the sed pattern. I'll update the answer.
      singulars
      1. PO
      1. USChristoph
 

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