Databases
StackOverflow2013
Postsdbo
POmatlab updating time vector
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmatlab updating time vector
    primarykey
    data
    text
    <p>I have 19 cells (19x1) with temperature data for an entire year where the first 18 cells represent 20 days (each) and the last cell represents 5 days, hence (18*20)+5 = 365days. </p> <p>In each cell there should be 7200 measurements (apart from cell 19) where each measurement is taken every 4 minutes thus 360 measurements per day (360*20 = 7200).</p> <p>The time vector for the measurements is only expressed as day number i.e. 1,2,3...and so on (thus no decimal day), which is therefore displayed as 360 x 1's... and so on.</p> <p>As the sensor failed during some days, some of the cells contain less than 7200 measurements, where one in particular only contains 858 rows, which looks similar to the following example: </p> <pre><code>a=rand(858,3); a(1:281,1)=1; a(281:327,1)=2; a(327:328,1)=5; a(329:330,1)=9; a(331:498,1)=19; a(499:858,1)=20; </code></pre> <p>Where column 1 = day, column 2 and 3 are the data.</p> <p>By knowing that each day number should be repeated 360 times is there a method for including an additional amount of every value from 1:20 in order to make up the 360. For example, the first column requires 79 x 1's, 46 x 2's, 360 x 3's... and so on; where the final array should therefore have 7200 values in order from 1 to 20. </p> <p>If this is possible, in the rows where these values have been added, the second and third column should changed to nan. </p> <p>I realise that this is an unusual question, and that it is difficult to understand what is asked, but I hope I have been clear in expressing what i'm attempting to acheive. Any advice would be much appreciated. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USEmma
    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
    1. VO
      singulars
      1. POmatlab updating time vector
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POmatlab updating time vector
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POmatlab updating time vector
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI am writing from a computer with no Matlab, so I can't post any code-containing answer, but I suggest you try to create a vector of the indices you have, `[find(a(:,1)==1); find(a(:,1)==2);...;find(a(:,1)==20)]`, and a vector of indices you need, `[1*ones(360,1); 2*ones(360,1);...]`, and then interpolate using the values you have and the values you need.
      singulars
      1. POmatlab updating time vector
      1. USItamar Katz
    2. COWhat if `a(281:327,1)=1;` so the temperature repeats on two days, but less than 360, so you don't know on which day?
      singulars
      1. POmatlab updating time vector
      1. UScyborg
    3. CO@cyborg: If a(281:327,1)=1 then a(1:327,1)=1 so only an additional 33 ones would be needed.
      singulars
      1. POmatlab updating time vector
      1. USEmma
 

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