Risposto
Filter table data into matrix
From your description, it sounds like you want data for MJJ for all years? Assuming your data is in a timetable and your dates a...

oltre 2 anni fa | 0

Risposto
Problem Importing Text File into TimeTable
Because the second variable is uses ":" as a separator, it is being treated as a duration by default. I would recommend using im...

oltre 2 anni fa | 0

| accettato

Risposto
empty space between values when making bar chat with datetime
That's a tough one. Obviously, if you were doing a standard x-y plot, you'd want the datetime axis to realistically represent ti...

oltre 2 anni fa | 0

Risposto
Preprocessing: excel table headers into categoricals
stack is the function that does the operation that converts a "wide" table with separate variables to a "tall" table with an ind...

oltre 2 anni fa | 0

Risposto
I want to import only specific Types of variables using readtable.
You can use vartype to subscript into the table and select only variables that are a certain datatype (or meta-type like 'numeri...

oltre 2 anni fa | 0

| accettato

Risposto
Select specific rows in Matlab Table.
I would suggest counting the unique times, then you can split up the table based on the counts: d = datetime(2018,1,1,[1 2 4 4 ...

oltre 2 anni fa | 0

| accettato

Risposto
Add datetime vector which contains NaT to double
The NaT isn't the problem. You cannot concatenate datetime and double in a homogenous matrix: >> x = [1 2 datetime('now')] E...

circa 3 anni fa | 0

Risposto
How to calculate average of data over a given time period?
It would be helpful to see what your data looks like (are different time components) split into different table variables?) But ...

circa 3 anni fa | 0

Risposto
Change data type of a table column into datetime?
Take a look at the convertvars function for changing the data type of a table variable. Also, is there a reason you're bring in...

circa 3 anni fa | 1

Risposto
How to change interval unit of x axis
If X is a duration array (X = minutes(0:15:262800)), you plot datetimes or durations directly, and changing the Format property ...

circa 3 anni fa | 0

Risposto
alternative visualisations of 3 vectors
You could construct datetimes from those separate vectors of year/month/day, and then plot the datetime variables. That brings y...

circa 3 anni fa | 0

Risposto
How to store Matlab datetime data type in hdf5
I don't think HDF5 has its own definition of a date/time type and you can't store MATLAB datetimes directly in HDF5. There are o...

circa 3 anni fa | 0

| accettato

Risposto
Convert categorical back to integer
Peter's answer to this similar post provides a few other suggestions to consider.

circa 3 anni fa | 0

Risposto
Overwriting a table with a different sized table
There are two ways that timetables (or table) can contain tables. In one approach, the table is the same height as the timetable...

circa 3 anni fa | 0

Risposto
table row key implementation
Hi Andrew, I assume you mean t.Properties.RowNames throughout rather than "RowKeys." Yes, that's a large difference in performa...

oltre 3 anni fa | 0

| accettato

Risposto
Plotting of yearly data.
There are a few ways to tackle this problem. Here's one approach: fi = '~/Downloads/Mod21_All_Inclusive_Data_Nov2019.txt'; opt...

oltre 3 anni fa | 0

Risposto
problem plotting excel date, cant convert to HH:MM:SS only
I'm not entirely clear about what your data looks like. Attaching a file would help. That said, I suspect readtable would do the...

oltre 3 anni fa | 0

Risposto
How can I convert datetime into double?
What do you want the doubles to represent? Datenum returns a double represents days since 0 CE. The posixtime function would...

oltre 3 anni fa | 0

Risposto
How to filter rows in a timetable based on a range between 08:00 and 16:00 for everyday and put in a new timetable
You can do this with some logical indexing on the row times. Create a timetable with a few days worth of hourly data: tt = tim...

oltre 3 anni fa | 3

Risposto
How to use timetable with hierarchical data
For synchronizing leaf-to-leaf, you probably will end up wanting to write a for-loop, looping over leaf grouping variables, sync...

oltre 3 anni fa | 0

| accettato

Risposto
There's no reason to go through cell to pass the datenums into datetime: Data = readtable(‘FileMaker.csv’); Dates = datetime...

oltre 3 anni fa | 1

Risposto
convert "number of days since" to datetime, given 365-day and 360-day calendars (not Gregorian)
Adding support for a broader range of calendars is something I've been thinking about. For a fixed-length calendar (360-day or 3...

oltre 3 anni fa | 0

| accettato

Risposto
Associate value to the correct date
Take a look at the timetable synchronize method. If you import your "1st", "2nd", "3rd" as separate timetables tt1,tt2,tt3, then...

circa 4 anni fa | 0

| accettato

Risposto
Increment dates using for loop
Are there any other calculations being done in the loop body of your actual code? If not, this can be done without looping: sam...

circa 4 anni fa | 0

| accettato

Risposto
Calculate mean of calendarDuration? (i.e. mean of age)
Hi Max, You probably want to calculate the ages of the participants as durations, and mean() is defined for duration. calendarD...

circa 4 anni fa | 0

Risposto
Reorder table variables / columns
In R2018a, check out the new <https://www.mathworks.com/help/matlab/ref/movevars.html movevars> function for rearranging variabl...

circa 5 anni fa | 7

Risposto
How to go about grouping, listing and (if user specifies) writing to a file a group of time series objects which are of different lengths (# of rows) and different time bases?
Take a look at the synchronize function for timetables. By default, synchronize(tt1,tt2) will construct a new time table with a ...

circa 5 anni fa | 1

| accettato

Risposto
Have a string with an analog time value, how to convert it to total time elapsed?
The duration datatype is the correct type to represent this data, and you can plot durations. In R2018a, there is a new capab...

circa 5 anni fa | 0