Answered
Formatting .dat gps file
Unless there's an existing reader for that file format, you're going to need to read it in as text and parse it into something m...

4 years ago | 0

Answered
frequency of wind speed in a particular direction
It sounds like what you want is a 2D histogram where each bin represents the amount of time that the wind was blowing in a parti...

4 years ago | 0

Answered
time series and grouping
It's tough to give a detailed answer without seeing the structure of your data and preliminary code, but here are a few suggesti...

4 years ago | 0

Answered
String to raw data conversion problem (Timestamp Data)
Even simpler...you don't need to strip off the leading and trailing brackets. Datetime can parse formats with character literals...

4 years ago | 1

Answered
How to bin a variable and create new variables for each bin
I'd encourage you to consider whether you really need separate tables for each age bin or whether you can simply add a grouping ...

4 years ago | 0

Answered
how to create center-justified table elments
When you say you're "trying to make a table in a plot" I assume you're referring to uitable? If so, you can use uistyle to deter...

4 years ago | 0

Answered
how can i display on a table's cell different colors ?
It sounds like you're on the right track. You want to apply the addStyle to the uitable, not the uifigure: % setup fig = uifig...

4 years ago | 0

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

4 years ago | 0

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

4 years ago | 0

| accepted

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

4 years ago | 0

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

4 years ago | 0

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

4 years ago | 0

| accepted

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

4 years ago | 0

| accepted

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

4 years ago | 0

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

4 years ago | 0

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

4 years ago | 1

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

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

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

5 years ago | 0

| accepted

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

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

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

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

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

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

5 years ago | 1

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

5 years ago | 4

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

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

5 years ago | 1

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

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

5 years ago | 0

| accepted