Community Profile

photo

Peter Perkins


Last seen: 2日 前

MathWorks

1,060 2011 年以降の合計貢献数

Peter Perkins's バッジ

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

詳細を表示...

貢献した分野
表示方法

回答済み
Time series data events
Ben, I'm not sure where you are starting from. I'm gonna show how to do this with timetables. Imagine you have a timetable conta...

2日 前 | 0

回答済み
get GPS time to calulate time since referencje epoch
Marta, that depends on what you mean by "GPS time". MATLAB doesn't yet have direct support for GPS time, but if all you want is...

3ヶ月 前 | 0

| 採用済み

回答済み
Find the certain amount of values between NaNs and make another variable from these values
There's no need to loop over the 750K elements. Do this on each row x of your data, i.e. loop from 1:50. Try stepping through t...

4ヶ月 前 | 0

回答済み
Finding row number of a variable existing in a table
I have no idea what you mean by "In this case the second column and third row of the table.", but this sounds like what you want...

4ヶ月 前 | 0

| 採用済み

回答済み
Correlating values from a table using a for loop
Not sure why you think a "loop is better". Try this: >> t = table([1;1;1;1;2;2;2;2;2;2],rand(10,1),rand(10,1),'VariableNames',[...

4ヶ月 前 | 0

回答済み
Comparing matrices and filling in the gaps
There are just so many things you can do with joins: >> a = table(["A";"B";"C";"D";"E";"F"]); >> b = table(["B";"D";"F"], [5;1...

4ヶ月 前 | 0

回答済み
Time weighted average after every 60mins
Or put the data in a timetable and use retime(tt,'hourly','mean'). If you need weights, you can write your own aggregation funct...

4ヶ月 前 | 0

回答済み
How can I construct a struct handle from a string?
A scalar struct with a field for each variable that you would have put in the workspace is often useful. It's like a private wor...

4ヶ月 前 | 1

| 採用済み

回答済み
Keeping columns names but replacing value for iteration
You are horzcat'ing tables, and table variable names must be unique. But your two tables both have variables named dist1, dist2,...

4ヶ月 前 | 1

| 採用済み

回答済み
Preallocation of a vector of structure
Audric, it seems like dpb understand what you are doing better than I do, but "in which each cell will be a structure of 42 fiel...

4ヶ月 前 | 0

回答済み
convert hourly data to daily sum
Turn your table into a timetable, and use retime: >> hourmelt = table2timetable(hourmelt); >> head(hourmelt) ans = 8×1 tim...

4ヶ月 前 | 0

回答済み
missing/incorrect use of math operators?
Jocelyn, modulo Geoff's concerns, I think your whole loop can be done as x = 200*3*(0:5)'; Vx = (sqrt(Vx_o) - ((k3/2).*x))^2; ...

4ヶ月 前 | 0

回答済み
Matching the size of two matrices based on values of a column
"contains time in a day in decimal form": That would be your problem. Use timetables with datetimes (or maybe durations?), and u...

4ヶ月 前 | 1

| 採用済み

回答済み
How can I fit a mesh plot axis to a vector of time values?
Does this not do what you need? >> d = datetime(2020,11,1:20); >> t = 1:15; >> mesh(d,t,x) Those dates and temps are evenly-...

4ヶ月 前 | 0

回答済み
how do you plot fft of each sensor for both test
Zeshan, you have all your data in a numeric array, t1. I strongly recommend that you convert that to a timetable. Then your plot...

4ヶ月 前 | 1

回答済み
compare datetime with different lengths
SW, if all you want is a plot, there's nothing special you need to do, just plot them. t1 = datetime(2020,11,19) + caldays(0:2:...

4ヶ月 前 | 0

回答済み
Condition for Specific Data collection
Unless you are using a fairly old version of MATLAB, I strognly recommend that you stay away from xlsread, and use readtable or ...

4ヶ月 前 | 0

回答済み
importing data and plotting
In a more recent version of MATLAB, I would suggest to not use importdata. It's old and gives you a result that is hard to work ...

4ヶ月 前 | 0

回答済み
How do I run my MATLAB program through multiple excel files in the folder?
There is. First step: use readmatrix or readtable, stay away from the much older xlsread. Ditto xlswrite. Then use something lik...

4ヶ月 前 | 0

回答済み
How to import an excel file and split a column
The short answer is no. Your timestamps are stored in the spreadsheet as floating point numbers. But why do you need to split ti...

4ヶ月 前 | 0

| 採用済み

回答済み
Consecutive count of values based on multiple conditions
Put your data in a table, and use rowfun with ID as the grouping variable. Write a function that does all the logic you need to ...

4ヶ月 前 | 1

回答済み
Arrayfun with a timetable
timetable1 is not a timetable, and probably not even legal MATLAB code. I'm going to assume you mean that you have an actual tim...

4ヶ月 前 | 0

| 採用済み

回答済み
How to use multiple arguments in matrix
Or >> t = datetime(2020,1,1,0:8759,0,0); >> scale = [repmat(.2,1,6) repmat(.5,1,8) repmat(.2,1,2) repmat(.5,1,7) .2]; >> scal...

4ヶ月 前 | 0

回答済み
Fill missing NaN by 1 in a table value
Not sure what the question is, but based on your title, "fillmissing".

4ヶ月 前 | 0

回答済み
How to read a netcdf file and convert it to time table
Hamed, it's not currently possible to create a timetable that is 3-D (lat-by-lon-by-time). One thing you can do is make a 45*875...

4ヶ月 前 | 0

回答済み
Plotting Multiple Data Streams with Timestamp
CW, if I am undersatand correctly, you are looking for the same kind of chart that stackedplot makes, for multi-rate data. The o...

4ヶ月 前 | 0

| 採用済み

回答済み
How can i plot multiple plots with respect to date in matlab for forecasting problem ?
No reason why something like this plot(datetime(2020,11,18:30),rand(3,13)) should not work.

4ヶ月 前 | 0

回答済み
if it is greater than 75 percent missing data
I think this would be much simpler if you created a timetable by combining the first 6 vars in the table. Actually, I have no id...

4ヶ月 前 | 0

| 採用済み

回答済み
Why do I get identical outputs from a randomized script?
You don't want to use seeds to get independent parallel random number streams. Switch to using one of the generators that is des...

4ヶ月 前 | 0

回答済み
Store different data types efficiently
Moritz, if "I stored these variables for all documents in a large struct array" is literally true, then that's your problem. I m...

4ヶ月 前 | 0

Load more