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

más de 8 años hace | 0

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

más de 8 años hace | 0

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

más de 8 años hace | 0

| aceptada

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

más de 8 años hace | 0

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

más de 8 años hace | 4

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

más de 8 años hace | 1

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

más de 8 años hace | 2

| aceptada

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

más de 8 años hace | 0

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

más de 8 años hace | 0

| aceptada

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

más de 8 años hace | 0

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

más de 8 años hace | 1

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

más de 8 años hace | 1

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

más de 8 años hace | 1

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

más de 8 años hace | 0

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

más de 8 años hace | 0

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

más de 8 años hace | 0

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

más de 8 años hace | 2

| aceptada

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

más de 8 años hace | 0

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

más de 8 años hace | 0

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

más de 8 años hace | 0

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

más de 8 años hace | 0

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

más de 8 años hace | 0

| aceptada

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

más de 8 años hace | 0

| aceptada

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

más de 8 años hace | 0

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

más de 8 años hace | 0

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

más de 8 años hace | 0

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

más de 8 años hace | 0

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

más de 8 años hace | 0

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

más de 8 años hace | 0

| aceptada

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

más de 8 años hace | 0