답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

| 수락됨

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

대략 8년 전 | 0

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

대략 8년 전 | 4

답변 있음
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년 전 | 1

답변 있음
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년 전 | 2

| 수락됨

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

| 수락됨

답변 있음
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년 전 | 0

답변 있음
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년 전 | 1

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

대략 8년 전 | 1

답변 있음
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년 전 | 1

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

답변 있음
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년 전 | 2

| 수락됨

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

답변 있음
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년 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 0