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

más de 8 años hace | 0

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

más de 8 años hace | 0

| aceptada

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

más de 8 años hace | 1

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

casi 9 años hace | 0

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

casi 9 años hace | 0

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

casi 9 años hace | 2

Respondida
Julian time and seconds
>> d1 = juliandate(datetime('today')) d1 = 2458017.5 >> d2 = d1 + 1234 d2 = 2...

casi 9 años hace | 1

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

casi 9 años hace | 1

| aceptada

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

casi 9 años hace | 0

| aceptada

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

casi 9 años hace | 0

Respondida
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'...

casi 9 años hace | 0

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

casi 9 años hace | 0

| aceptada

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

casi 9 años hace | 0

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

casi 9 años hace | 0

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

casi 9 años hace | 0

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

casi 9 años hace | 0

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

casi 9 años hace | 0

| aceptada

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

casi 9 años hace | 0

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

casi 9 años hace | 1

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

casi 9 años hace | 2

| aceptada

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

casi 9 años hace | 1

| aceptada

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

casi 9 años hace | 0

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

casi 9 años hace | 0

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

casi 9 años hace | 1

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

casi 9 años hace | 1

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

casi 9 años hace | 0

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

casi 9 años hace | 0

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

casi 9 años hace | 2

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

casi 9 años hace | 0

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

casi 9 años hace | 0

Cargar más