Community Profile

# Peter Perkins

### MathWorks

Last seen: 15 dagar ago Active since 2011

All

#### Content Feed

View by

Subset timetable by specific time windows/periods
This post is more than a year old, but I'm responding in hopes that it might help anyone who looks at this. First, I don't unde...

16 dagar ago | 0

ismember: Find matching entries in table columns (and add entry from matching row)
This is a one-liner with tables: >> A = table([1;3;5]) A = 3×1 table Var1 ____ 1 3 5 >> ...

ungefär en månad ago | 0

| accepted

Using index to match rows of table
Lukas, you don't say what you actually need to do after getting those rows, but I'm going to suggest that you should be using ro...

ungefär en månad ago | 0

How to Create txt output from multiselect file by using readtable?
This code DATE = T{:,1}; TIME = T{:,2}; TIME.Format = 'hh:mm:ss'; DOH = T{:,3}; ...

ungefär en månad ago | 0

How to convert a minutes elapsed vector to time (hh:mm)?
"continous 24 hour measurement" sounds like you are dealing with time of day. If you add 600 minutes to hours(16), you will get ...

ungefär en månad ago | 0

Insert new row with values in a table before specific values
It is possible to just use tabular subscripting to insert these rows. This is kind of old school MATLAB. Don't know if it is eas...

ungefär en månad ago | 0

Plot a timetable for charging electric vehicles
Sure. It looks like you want to overlay not only all stands, but also all days on one (24 hour?) time of day axis. That makes it...

ungefär en månad ago | 0

| accepted

How to separate two graphs plotted in one figure into two separate figures?
If spikes were two separate variables in a timetable (see splitvars), this would just be stackedplot(neural).

ungefär en månad ago | 0

How do I add a label on each bar of a multiple bar chart? I want to add specific times as labels.
I bet there's a way to simplify the arguments to your bar command. What about something like bar(T_Smooth.X(1:4),T_Smooth{1:4,[...

ungefär en månad ago | 0

Operator '==' is not supported for operands of type 'table'.
There are a couple of problems. c is a table, so R = c(:,"SAPID") is also a table, with only one variable. A table is a contai...

ungefär en månad ago | 1

Dividing grouped data into equally sized subgroups
>> x = rand(16,1); >> g = repmat((1:2)',8,1); >> t = table(g,x) t = 16×2 table g x _ _______ ...

ungefär en månad ago | 1

Trying to get time between each start and stop & total time per day from a text file.
I would go with unstack: >> T1 = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/702232/FDATA.TXT'); ...

ungefär en månad ago | 0

How to vertically join differently sized tables?
One way is to "assign off the end": >> table1 = table(1,70,175,29,datetime(1992,7,1),"M",'VariableNames',{'Num','Weight','Heigh...

ungefär en månad ago | 1

| accepted

Connect correct temperature to another table based on time
Use timetables. It's a one-liner: >> A = timetable(datetime(["13-aug-2020";"14-aug-2020";"15-aug-2020"]), [13.8; 12.2; 8.5]) ...

ungefär en månad ago | 1

| accepted

bar graph with non numerical x-axis
Simon's solution is one way to do it. But using categorical just to label the bars is kind of an abuse of categorical, which is ...

ungefär en månad ago | 0

How to treat a duration array in a for loop?
Judith, I can't really follow what you are doing, but if you have timestamped data, you should be using a timetable, and then re...

ungefär 2 månader ago | 1

Reorganize table and make groups of rows to columns
You need unstack: >> Date = datetime(1963,[1;2;3;1;2;3;1;2;3],[31;28;29;31;28;29;31;28;29]); >> Permno = [10065;10065;10065;10...

ungefär 2 månader ago | 2

| accepted

Delete rows in cell aray where there is anything in one collum.
A cell array is the wrong way to store these data. You want a table, or probably a timetable. The fact that you say, "the name o...

ungefär 2 månader ago | 0

| accepted

Prevent overwriting within a for loop in 3D-motion tracking
You may just want T = table(); for ... ... T = [T; readtable (thisFile)];

ungefär 2 månader ago | 0

| accepted

How to convert the number of seconds from an epoch into UTC using the datetime function.
Matthew, this is easier than you think. In MATLAB, 'TimeZone','UTC' is sort of a ficticious timeline that pretends that leaps se...

ungefär 2 månader ago | 0

| accepted

How to plot only the matches of two different datetime?
If all you have are two datetime vectors, you can use intersect to find the common values. But I'm guessing you have other data ...

ungefär 2 månader ago | 0

How to filter the data.
Not sure how you are getting those data into MATLAB, but I suggest that you figure out why you have a cell array. You want a tab...

ungefär 2 månader ago | 0

extracting columns from multiple cell arrays consist of table data
If you've read two "similar" tables into a 2x1 cell array, best ting to do is to vertvat them outside the loop: >> C = {array2t...

ungefär 2 månader ago | 1

| accepted

split cell in 2 columns
Use cellfun, two possibilities: function [val1,val2] = myfun1(x) val1 = x(1); if isscalar(x) val2 = 0; else val2 =...

ungefär 2 månader ago | 0

How do I find the corresponding date/time value of the maximum of my data in a table?
This is a pretty common question, so I'm gonna show a bunch of stuff in hopes others can find it useful. Let's start with a sim...

ungefär 2 månader ago | 0

| accepted

how to sort a cell array inside a struct?
I think you would be better off with a table than a struct. Name_Code = table(IDs, C,'VariableNames',["Name" "Codes"]) Name_Co...

ungefär 2 månader ago | 0

| accepted

Error with splitting table into separate columns.
This is an application of unstack and then stack. The code looks a lot more complicated than it might if I hard-coded in sizes, ...

ungefär 2 månader ago | 0

| accepted

Coordinate interpolation with time
This line of code pf = polyfit(Lat(:,1) Lat(:,2)], [(Long(:,1) Long(:,2)] %Coordinates is not valid syntax for several reasons...

ungefär 2 månader ago | 0