Answered
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...

4 meses ago | 0

Answered
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...

4 meses ago | 0

| accepted

Answered
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).

4 meses ago | 0

Answered
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,[...

4 meses ago | 0

Answered
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...

4 meses ago | 1

Answered
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 _ _______ ...

4 meses ago | 1

Answered
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'); ...

4 meses ago | 0

Answered
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...

4 meses ago | 1

| accepted

Answered
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]) ...

4 meses ago | 1

| accepted

Answered
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 ...

4 meses ago | 0

Answered
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...

4 meses ago | 1

| accepted

Answered
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...

4 meses ago | 2

| accepted

Answered
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...

4 meses ago | 0

| accepted

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

4 meses ago | 0

| accepted

Answered
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...

4 meses ago | 1

| accepted

Answered
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 ...

4 meses ago | 0

Answered
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...

4 meses ago | 0

Answered
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...

4 meses ago | 1

| accepted

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

4 meses ago | 0

Answered
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...

4 meses ago | 0

| accepted

Answered
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...

4 meses ago | 0

| accepted

Answered
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, ...

4 meses ago | 0

| accepted

Answered
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...

4 meses ago | 0

Answered
Smartly search between tables
This would be trivial if varfun accepted more than one table input, but it doesn't do that. But you can make one table that look...

4 meses ago | 0

Answered
Calculete monthly anomalies time series temperature
You are not doing yourself any favors by using raw numeric vectors with no timestamps. This is almost trivial using datetime and...

4 meses ago | 0

Answered
repeating step signal in real time with a hold value of 5 seconds
Like this? >> interp1([1 5 6 10 11 15],[1 1 2 2 3 3],1:15,"prev") ans = 1 1 1 1 1 2 2 2 2 ...

4 meses ago | 0

Answered
how to expand the date matrix?
roudan, this question doesn't seem to make any sense. For one thing, it doesn't seem useful that you have a column whose header ...

4 meses ago | 1

Answered
Program architecture for handling large .csv files
With no code at all to go on, it's pretty hard to give specific advice. Hex issues aside, the first advice I would give would b...

4 meses ago | 1

Answered
Transforming data table from wide to long format
stack to the rescue, twice, because you are stacking two pairs of variables all into one variable: >> tw = readtable("wide_form...

4 meses ago | 1

| accepted

Answered
Trying to use retime to sum daily values, but I don't want days that only have NaN values to become 0
In the doc for retime (admittedly, not really in flashing bold letters): "All the listed methods omit NaNs, NaTs, and other miss...

4 meses ago | 0

Load more