Answered

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

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

10 months ago | 0

Answered

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

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

1 year ago | 0

Answered

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

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

1 year ago | 0

Answered

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

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

1 year ago | 0

| accepted

Answered

Convert categorical back to integer

Peter's answer to this similar post provides a few other suggestions to consider.

Convert categorical back to integer

Peter's answer to this similar post provides a few other suggestions to consider.

1 year ago | 0

Answered

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

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

1 year ago | 0

Answered

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

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

1 year ago | 0

| accepted

Answered

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

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

1 year ago | 0

Answered

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

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

1 year ago | 0

Answered

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

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

1 year ago | 0

Answered

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

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

1 year ago | 1

Answered

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

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

1 year ago | 0

| accepted

Answered

Issue with loading datetime from table

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

Issue with loading datetime from table

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

1 year ago | 0

Answered

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

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

1 year ago | 0

| accepted

Answered

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

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

2 years ago | 0

| accepted

Answered

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

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

2 years ago | 0

| accepted

Answered

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

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

2 years ago | 0

Answered

Reorder table variables / columns

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

Reorder table variables / columns

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

3 years ago | 5

Answered

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

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

3 years ago | 0

| accepted

Answered

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

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

3 years ago | 0