답변 있음
Table to array error
Ivan, by calling table2array, you are asking to put different data types into a homogeneous array. That isn't gong to work. I...

8년 초과 전 | 0

답변 있음
Can anyone please help me to understand the following problem with converting a cell-array to a table?
Tobias, as puzzling as it may seem at first, cell2table is doing the right thing. t = cell2table(c) wants to take each column...

8년 초과 전 | 0

| 수락됨

답변 있음
How to convert comma separated column to table?
The main problem is your file has a partial last line. Also you'll need to skip the two header lines. In a recent version of ...

8년 초과 전 | 1

답변 있음
how the fetch the start time and end time for a particular value which i read from my file? so that i can calculate the life span of that value?,like if I given id value as 8,start &end time is 11:05:00 ,11:15:00,how to cal difference as 10 min
It's pretty hard to tell what you have and what you want. Let's assume you start out with a CSV file that looks like what you sh...

8년 초과 전 | 0

답변 있음
Merging data from different matrices with different row numbers by matching date
If you are using R2016b or later, timetable provides two really good ways to approach this. The second approach also works with ...

8년 초과 전 | 0

답변 있음
How can I convert the number 1 into a date value 20150101 (yyyyMMdd)?
There's a datetime method for that: >> A = (1:731)'; >> d = datetime(2015,1,A) d = 6×1 datetime array 01-...

8년 초과 전 | 2

답변 있음
Julian time and seconds
>> d1 = juliandate(datetime('today')) d1 = 2458017.5 >> d2 = d1 + 1234 d2 = 2...

8년 초과 전 | 1

답변 있음
Use textscan to read dates with time zone
I think you want the <https://www.mathworks.com/help/matlab/ref/datetime.html#buhzxmk-1-Format x format token> . >> datetim...

8년 초과 전 | 1

| 수락됨

답변 있음
Splitting up large arrays based on datetimes without using loops
Here's how you would do this using a table and varfun: >> t = table(datetime(2017,1,randi(365,20,1)),randn(20,1),'VariableN...

8년 초과 전 | 0

| 수락됨

답변 있음
Converting date into date and hours
Use datetimes and durations: >> t0 = datetime('today','Format','yyyy-MM-dd HH:mm:ss') t0 = datetime 2017-09-...

8년 초과 전 | 0

답변 있음
indexing to different table
It sounds like what you ultimately want is to compute statistics within groups on variables in a table. If that's correct, here'...

8년 초과 전 | 0

답변 있음
how to plot histogram from table?
This doesn't really have anything to do with tables, you just want a histogram on discrete values. Use a categorical variable...

8년 초과 전 | 0

| 수락됨

답변 있음
There is a huge table containing values from various parameters(columns) from several machines at different poit of time(rows) and continued by data from next machine at the end of each. How to segregate certain machines and form another table?
It sounds like you want a timetable (assuming you are using R2016b or later) and a categorical variable for the machine ID, and ...

8년 초과 전 | 0

답변 있음
How to add dates to a read loop
Create a datetime column vector and assign it to your table. d = datetime(2012,3,repmat(1,24,1)) % assuming you mean march 1s...

8년 초과 전 | 0

답변 있음
Entry new date when date is a different day from previous entry
You question is not described very clearly. It LOOKS like you want to split those start/end pairs into two pairs if they cross a...

8년 초과 전 | 0

답변 있음
Index out of bounds (datetime)
You have a lot of code there, and a bunch of time calculations that apparently involve excel times and posix times. Potential fo...

8년 초과 전 | 0

답변 있음
Using @range in timetable when having NaN's
Robert, it's not clear what you are looking for, or what you mean by "doesn't work". As KSSV says, range ignores NaNs, so it's n...

8년 초과 전 | 0

| 수락됨

답변 있음
How to Synchronize timetable?
Ioannis, you'll need to provide a small, clear example of what you have and what you want.

8년 초과 전 | 0

답변 있음
When I add columns to a table, it changes the assigned names to Var1, Var2 ...! How can I add columns to an existing table with the assigned names?
This Tab(:,{'B_X' 'B_Y'}) = table(B.L1(:,1),B.L1(:,2)) or this Tab(:,{'B_X' 'B_Y'}) = array2table(B.L1) or perha...

8년 초과 전 | 1

답변 있음
How can I re-code numeric variables in a table to strings?
JLC, you say "string", but it's very likely that you would be bettter off with categorical variables. Given you're original samp...

8년 초과 전 | 2

| 수락됨

답변 있음
storing tables in an array and calling them whithin a for loop
You've shown your data, but that can't possibly be output from MATLAB because 'AAPL' = is not something MATLAB would e...

8년 초과 전 | 1

| 수락됨

답변 있음
How to extract variable data from a table
Hard to tell what you are doing because you have not said what elements or clusters is. It looks like you created your own wa...

8년 초과 전 | 0

답변 있음
Index table with unrecognized row names
Row names in tables don't work like that in subscripting, but getting what you want is much easier than you think. Given this ta...

8년 초과 전 | 0

답변 있음
convert datetime format to numeric format
While you asked to be able to convert timestamps strings into (partial) date vectors, you may find that if you convert your stri...

8년 초과 전 | 1

답변 있음
How to extract time (HH:mm) from datetime from a table and plot it in interval range?
I'm not entirely clear what you are trying to do in this plot. It sounds like you want to plot things against time of day, not a...

8년 초과 전 | 1

답변 있음
Setting time ticks in plot
The numbers in your example data don't match the numbers in your explanation: >> x = [ ... 27634517312999, 1.1111809...

8년 초과 전 | 0

답변 있음
converting seconds to date in a plot
The answer depends on what version of MATLAB you are using. Using datetick with a plot of datetimes probably works prior to R201...

8년 초과 전 | 0

답변 있음
How to average time data every 1/4 of hour?
Walter is right that retime on a timetable makes this almost a one-liner. But even pre-R2016b without timetables, you don't w...

8년 초과 전 | 2

답변 있음
How do I combine two DateNumber strings without resulting in all NaN values?
You _say_ datenum, but you are using a format for _datetimes_. And in any case, datenum only accepts three fractional seconds di...

8년 초과 전 | 0

답변 있음
How can i compute the mean of specific number of table rows?
Add a grouping variable to your table and use varfun. Something like n = ceil(height(t)/10); g = repelem(1:n,10)'; t....

8년 초과 전 | 0