Answered
Readtable function has some kind of limitation on the number of rows and columns?
You have not provided any sample of what's in your spreadsheet, so pretty hard to say what's wrong. Best guess is you have a lot...

8 years ago | 0

Answered
How can I take a data set with data at variable times and put it on 1 minute intervals for date and time, and generate a regression between the time stamps of my data.
You got a lot of code there, and I'm not really sure what all you are doing, especially "take into account data points that migh...

8 years ago | 0

Answered
How do I plot time-stamped data from file?
Reading the data in is relatively easy in recent MATLAB, although there's a couple of tricks. I'm using R2017b, earlier versions...

8 years ago | 0

| accepted

Answered
Plot distance with time
I'm gonna make a different guess: those numbers are seconds since midnight. So: >> t = readtable('Trial1.xls'); Warning:...

8 years ago | 0

Answered
convert seconds to time
Unless you are using an older version of MATLAB, use durations: >> seconds(28225.6) ans = duration 28225.6 s...

8 years ago | 4

Answered
Using datenum with a structure field
As Walter pointed out, there were two things going on, both having to do with the fact that s.Field for a non-scalar st...

8 years ago | 1

Answered
Reading dates/times into MATLAB and saving as a numeric vector
Unless you are using a pretty old version of MATLAB, I recommend you don't use datenum and datestr. Try datetime. For example: ...

8 years ago | 2

| accepted

Answered
Using for loop for plotting from a timetable?
I imagine that plot(TT2.Date,TT2{:,1:2}) would also work. And if there's only two variables in your timetable, that's eq...

8 years ago | 0

Answered
Pivot table with different operations for columns
Look at using a timetable, and look at using varfun with year/month as your grouping variable(s).

8 years ago | 0

| accepted

Answered
change date format in table
The warning is coming from readtable, and it's worth paying attention to what it says, and addressing the issue, because that is...

8 years ago | 0

Answered
Got error in joining two tables: Left and right key variables 'Date' and 'Date' include cells containing non-string values.
The error seems clear: you are trying to use a variable that is not supported as a key. You say that you have a datenum variable...

8 years ago | 1

Answered
How to import csv file into matlab ?
readtable, possibly using importoptions, is the thing to use in recent versions of MATLAB.

8 years ago | 1

Answered
Add missing time data
Your data run from 1-Jan-2016 to 31-Dec-2016. There are >> minutes(diff(datetime(2016,[1 12],[1 31]))) ans = 5...

8 years ago | 1

Answered
Inconsistent date formats across time functions
"This difference does make converting between string and numerical formats prone to programming errors." Robert, you may mean...

8 years ago | 0

Answered
confusing datestr and datetime month and minutes formating
The formats for datetime are not just more consistent, they are an <http://www.unicode.org/reports/tr35/tr35-dates.html#Date_Fie...

8 years ago | 0

Answered
Using Dates (if possible) as structure fields.
It's quite possible that you could use a timetable, in which each row is labelled with a datetime. Hard to say without more info...

8 years ago | 0

Answered
How to define sequence of dates between to dates on monthly time step?
Hydro, I think all you need is to add a step size of one calendar month (in your code you are stepping by one day): StartDa...

8 years ago | 2

| accepted

Answered
How do I convert table data to double to manipulate them?
The answer might be as simple as something like T.Z = T.x .* T.y. Without more information, hard to tell.

8 years ago | 0

Answered
How to get rid of unwanted comment in the data imported using 'readtable'
That's not a table, it's a cell array of ... char row vectors? Hard to know without more info. If it is, then just use strrep an...

8 years ago | 0

Answered
Find and trim text in a table
As KL's answer indicated, this isn't really a question about tables, you just need to figure out how to do it for a string colum...

8 years ago | 0

Answered
Finding unique values in a table without losing the rest of the data
It's pretty hard to tell what you mean by, "without losing the rest of the information of the table", but an alternative to Amy'...

8 years ago | 0

Answered
How can i read from CAN and save the messages in a timetable?
Jose, I think typically you would want to vertically concatenate all the timetables you get. You might either do something like ...

8 years ago | 0

| accepted

Answered
Fail to create a new variable in the Timetable
Angelina, if you are using timetables, you will likely be happier using datetimes, rather than going back and forth between thos...

8 years ago | 0

| accepted

Answered
How to convert from decimal time to hh:mm:ss
Unless you are using an older version of MATLAB, you are likely better off using readtable (instead of xlsread) and datetime (in...

8 years ago | 0

Answered
Need help with datenum function
If you have R2015b, you will likely be happioer using datetimes rather than datenums: dates = datetime(data.date(2:end),'Fo...

8 years ago | 0

Answered
How to count the duplicate id's within a group of a table?
If the table is already sorted by date and ID (use sortrows), then it's straight-forward: >> t t = 9×3 table ...

8 years ago | 0

Answered
I want to concate two tables vertically.the table has no variable name.how can I do that?
The problem here is that the requirement of two rows that are numbers and one row that is text is exactly the opposite orientati...

8 years ago | 0

Answered
Using corresponding values in a table in an equations
If your table is named "t", then t.value3 = (t.value1./100).*t.population creates a new variable in t named "value3".

8 years ago | 0

Answered
Optimise function with datetime operations
Assuming "date" is a datetime array, a couple things as a starting point: 1) The creation of the FFR and RED arrays looks lik...

8 years ago | 0

| accepted

Answered
How can I create a table to work with, from this .txt?
This is a _TAB delimited file_. In recent version of MATLAB, that is automatically detected, as is the type (datetime) of the fi...

8 years ago | 0