Respondida
Cell Array to table
Alberto, you are mixing metaphors. You have a cell array containing values you want to put in a table, and (apparently) a table...

más de 7 años hace | 1

| aceptada

Respondida
How to delete empty cells in a cell array?
Another alternative, which may not be what you are looking for: >> c = {11 12 13; 21 [] 23; 31 [] []} c = 3×3 cell array ...

más de 7 años hace | 0

Respondida
Conversion from unix time string to uint64
I'm gonna run with Jan's guess, which, in the absence of any description, seems plausible: >> datetime(1520944184833390730/1e9,...

más de 7 años hace | 1

Respondida
How to filter dataset into specific time range and scan for missing values?
Timetables and retime were born to do this: >> X = [89 2 03 0030 1.6955 5.08; ... 89 2 03 0330 1.8172 4.39; ... ...

más de 7 años hace | 2

| aceptada

Respondida
How to convert UTC timestamp to unix time in MATLAB with the respect of leap seconds
A couple things, apologies if you already know all this: 1) POSIX time does not have leap seconds. As Jan says, unix systems va...

más de 7 años hace | 3

| aceptada

Respondida
Join two tables MATLAB
Isn't outerjoin what you are looking for? It will give you one table with rows that match, rows that are only in the left, and r...

más de 7 años hace | 0

| aceptada

Respondida
can't fill missings on table
Apparently at least one of the table variables that you are applying fillmissing to isn't numeric. You will have to figure out w...

más de 7 años hace | 0

| aceptada

Respondida
Match cell array of strings to table row names
Another possibility would be to (simple) join T1 to CA1, and then sum Weight.

más de 7 años hace | 0

Respondida
How can I group column of data with the same time stamp and get the row mean of each group?
retime on a timetable is the simplest way to compute means per time bin: >> tt = timetable(rand(10,1),'RowTimes',duration((sort...

más de 7 años hace | 0

Respondida
How to plot Date time series in MATLAB?
In something as recent as R2018b, stay away from datenum and datetick if possible. (Also, hardly ever does one need table2cell, ...

más de 7 años hace | 0

Respondida
Problem when importing a TXT file into MATLAB with "readtable". Text and numbers are between single quotes...
The real problem is that there's something funny in your file that you are not telling us about. Part of it may be using comma a...

más de 7 años hace | 0

Respondida
innerjoin two tables based on the first word in the key columns
The literal answer to your question is to create a new key variable pair from the first word of those two variables. Probably y...

más de 7 años hace | 0

Respondida
Change table variable dimension
You have created an Kx2 table, one of whose variables is KxMxNxL, the other is KxMxN. I don't know if that's what you intended, ...

más de 7 años hace | 0

Respondida
How to find out the average of data gathered from a For Loop for a specific column in a table?
The problem is that you are passing a table into mean. The table is a container, and what you need to do is to pass the variable...

más de 7 años hace | 0

| aceptada

Respondida
Categories automatically being labelled and sorted into matrix?
It's pretty hard to understand exactly what you are trying to do from the information you have provided. One problem with what y...

más de 7 años hace | 0

Respondida
Insert new rows of NaN for missing timestamps in time series.
retime "adjusts" your data to a new set of row times. In general, "adjust" means things like interpolate, or aggregate, or take ...

más de 7 años hace | 0

| aceptada

Respondida
Convert Unix Time in Date Time Format with Milliseconds
What you have is 1ns ticks since 1970. That's sort of Posix time, but at a different resolution. If that's really what you have,...

más de 7 años hace | 12

| aceptada

Respondida
Convert Julian Date to Calendar days
Michael, I can't speak for the correctness of that code, but you or that code may be confusing some things. There's the prolept...

más de 7 años hace | 3

Respondida
fints toweekly vs timetable retime
retime won't know about holidays, and 'weekly' assumes you mean the start of the week (just as 'monthly' assumes start of month)...

más de 7 años hace | 0

| aceptada

Respondida
Problem when using retime
Sofie, if I understand correctly, you want to find, within each day, the maximum temperature, and the date/time at which that ma...

más de 7 años hace | 0

Respondida
Insert new rows of NaN for missing timestamps in time series.
I recommend you use a timetable. Read your data in using readtable, then use table2timetable. The retime function makes what you...

más de 7 años hace | 1

Respondida
Import time and date text file
If that is LITERALLY what your text file looks like, then all you need to do is to give readtable an appropriate date format, so...

más de 7 años hace | 1

Respondida
transform duration into some visible in the table
You have a cell array, each cell of which contains a scalar duration. That explains the Variable Editor display you are seeing. ...

más de 7 años hace | 1

Respondida
Comparing date time vectors.
There is, it's not hard, but this seems like such a strange thing to want to do that I feel like you must mean something else. ...

más de 7 años hace | 0

| aceptada

Respondida
How do I make an array of elapsed times?
Unless you are using a pretty old version of MATLAB (< R2014b), use datetimes: >> t1 = datetime('April 18, 1995 12:00:00','Inpu...

más de 7 años hace | 0

Respondida
intersect two datetime vectors
As others have said, you don't have any matches between those two datetime vectors. The seem to be off by anything from about .5...

más de 7 años hace | 0

Respondida
Find date time value that corresponds to maximum daily value
I'm not sure retime will do all of what's asked for: it only works on one variable at a time. Getting the max tide for each day ...

más de 7 años hace | 1

Respondida
Missing 2000 years on date from csv file.
If all you have is a missing "20", the quick and dirty solution is to add calyears(2000) to each datetime in your table. But the...

más de 7 años hace | 0

Respondida
Reading the exact time and date as in excel sheet !
chamant, you will be much better off using readtable, and durations, if you have anythign like a recent version of MATLAB.

más de 7 años hace | 0

Respondida
How to find the total value by category in a table
The problem with Chris' solution is that by going through findgroups in that way, you lose all the categoricalness of your group...

más de 7 años hace | 1