Community Profile

photo

Peter Perkins

MathWorks

Last seen: 6日 前 2011 年からアクティブ

Statistics

All
  • 5-Star Galaxy Level 5
  • Personal Best Downloads Level 1
  • First Submission
  • 36 Month Streak
  • Guiding Light
  • Thankful Level 1
  • Revival Level 2
  • Knowledgeable Level 5
  • First Answer

バッジを表示

Content Feed

表示方法

回答済み
How to get a sum of coloumnn linked to datetime?
Create a timetable from your data, and use retime to aggregate it to monthly. It's one line of code.

約2ヶ月 前 | 1

| 採用済み

回答済み
How do I pull data between specific dates like Vlookup formula in Excel?
As Walter says, uses a timetable. >> tt = readtimetable("sampledata_uyyk.csv") [some warnings removed] >> tt = convertvars(tt...

約2ヶ月 前 | 0

回答済み
date and time string identification
"I have the following information obtained from a text-file date_hne: {'2014' '04' '01' '23' '46' '44.998300'}" I don't s...

約2ヶ月 前 | 0

回答済み
how to convert hours and minutes from decimals to datetime objects
Converting to string is totally unnecessary. Assuming the first variable in the table is already a datetime: >> t = datetime(20...

約2ヶ月 前 | 1

| 採用済み

回答済み
Effect of os clock change on timers
cr, this was a bug in earlier releases, and got fixed in R2021a.

約2ヶ月 前 | 2

| 採用済み

回答済み
Live Editor: Brace indexing changes Table to Struct
You can certainly post something like the table you have. In any case, if A is a table, then A.all is a variable in that table....

約2ヶ月 前 | 0

回答済み
How can I delete some specific rows from a matrix?
Surely you don't just have a list of dates. Presumably you have data at each date. Use a timetable to store all that. At that p...

約2ヶ月 前 | 1

回答済み
Select column in timetable based on value in table
Two steps: 1) Find the nearest sensor. This easy using interpolation: >> load("SL.mat") >> load("SensorLoc.mat") >> SensorLo...

約2ヶ月 前 | 0

| 採用済み

回答済み
Is it possible to use vertcat with dot notation?
Depending on what you are doing, you may find it convenient to turn that struct into a table (which wil automatically vertcat th...

約2ヶ月 前 | 1

回答済み
A very fast way to convert numbers into datetime ?
Syntactically, >> time = datetime("202210270954498", 'inputFormat','uuuuMMddHHmmssSSS', 'Format','yyyy-MM-dd HH:mm:ss.SSS') t...

約2ヶ月 前 | 1

回答済み
How to find specific elements in cell array not followed by another specific element?
If you have time and other data, think timetables (also Walter is right about categorical): action = categorical([1;3;2;4;1;3;2...

約2ヶ月 前 | 1

回答済み
Getting Data from Cell: Dynamic Structure needed?
Simon, what you should do depends very heavily on what you want to do with these data, i.e. what "take the value of the needed d...

約2ヶ月 前 | 1

回答済み
trying to find highest values in a time segment
It's not clear to me that Image Analyst's solution answers your question, mostly because your question is not very clear. If the...

約2ヶ月 前 | 0

回答済み
How to fix non-alignment issue when plotting multiple axes
Dinuka, if that's the plot you are looking for, I guess Voss' suggestion gets you there. But I might also add: y1=0.45 + .3*ran...

約2ヶ月 前 | 1

回答済み
Storing Variables in a loop to out put in a table
Make a timetable: i = (1:9)'; a = i-1; b = i.^2; c = i + rand(9,1); d = rand(length(i),1); e = rand(length(i),1); f = ran...

2ヶ月 前 | 0

回答済み
Issue Plotting 2 different Values
Cedric, I can't really follow your code or your explanation, but I would think you want something like this: ice = readtimetabl...

2ヶ月 前 | 0

回答済み
Coverting Timetable to Column Vector
Sam, it looks like you are ending up with a 7201x6 timetable whose variables are cell arrays, and each cell contains a 500x1 dou...

2ヶ月 前 | 1

| 採用済み

回答済み
A very fast way to sort datetime (in "ascend" mode)?
It seems like the obvious response to Any way faster than this one ? [~, idx2] = sort(datenum(a), 1, 'ascend'); is to...

3ヶ月 前 | 1

回答済み
Average of variables in timetable belonging to the same day over several years
Ziad, it seems that "dayofyear" is using "serial day number of year", and as you found, is lumping 29-Feb's with the non-leap 1-...

6ヶ月 前 | 0

| 採用済み

回答済み
Compile data from excel sheets into a dataset with multiple tags
Charlie, I'm confused. I haven't followed all of what you code does, but it seems that you are lining up tables of different he...

6ヶ月 前 | 0

回答済み
Only required the mean value out rather then every single value in a data
"7" sounds rather suspiciously like "weeks". If this were a timetable, it would be a one-liner with groupsummary. Moral: don't t...

7ヶ月 前 | 1

回答済み
Using date and time in MATLAB
I'm having trouble following exactly what needs to be done, but I imagine you want to append variables to your LoadProfile&Tarif...

8ヶ月 前 | 1

| 採用済み

回答済み
Help Merge two tables by the column variables
See join (or maybe innerjoin).

8ヶ月 前 | 1

| 採用済み

回答済み
generate an independent seed with a fixed number
Ebru, you are doing parallel simulations and presumably want to combine the results under the assumption that those results are ...

8ヶ月 前 | 3

| 採用済み

回答済み
Export rows as combined separate CSV files
There are a bunch of ways to do this. I thought I'd see how well rowfun works: > C = {rand(10,1) rand(10,1); rand(10,1) rand(10...

8ヶ月 前 | 0

回答済み
Error: Row index exceeds table dimensions.
SOLARL.Date2 = datenum(SOLARL.Date); DON'T do that. Just use datetime. You can call unique, length, and == a on datetime vector...

8ヶ月 前 | 0

回答済み
Elementwise calculations when making a new Table column
Will noone think of the joins? "I am trying to find (value1-min)/(max-min) using the appropriate max and min for the protocol ...

8ヶ月 前 | 0

回答済み
unstack table with pre and post measurements
unstack needs you to tell it three things: 1) which variables to unstack. It looks like you want SystemWeight, JumpHeight, ... ...

8ヶ月 前 | 0

回答済み
How to grab the first instance of a timestamp based on the second
It's a one-liner using a timetable and retime, with NewTimeStep 'secondly' and Method 'firstValue': >> tt = timetable(rand(10,1...

8ヶ月 前 | 0

| 採用済み

回答済み
how can I calculate movmean from 1 periode wave data?
In addition to what Mathieu suggests, there are similar things shown in these examples, especially the first one: https://www.m...

8ヶ月 前 | 0

さらに読み込む