Cannot read data from a table to create a graph

2 views (last 30 days)
Hey everyone!
I have a table with data from motor sensors, but I cannot create graphs based on the data. And I don't understand what is wrong) Could someone help me?
This is the code:
Table that I use:
Error:
error.png
  4 Comments

Sign in to comment.

Accepted Answer

Guillaume
Guillaume on 21 Jul 2019
The problem is that your timestamp column is text and matlab does not know how to use text as a plot variable.
I assume that the text is supposed to be a duration, if so:
sensorData.timestamp = duration(sensorData.timestamp, 'InputFormat', 'mm:ss.S') %Don't know if it's the correct format
for i = 1:4
subplot(2,2,i)
plot(sensorData.timestamp,sensorData{:,9+i})
xlabel('Time')
end
  2 Comments
Artur Nuritdinov
Artur Nuritdinov on 21 Jul 2019
Edited: Artur Nuritdinov on 21 Jul 2019
Hm, it worked with 200 rows of data, but it doesn't work with 5000 rows of data. I tried hh:mm:ss.S and mm:ss.S. The problem is already in the first row of the table
Attached the bigger table (Motor1_1) and the smaller one (Motor11) to the message
Guillaume
Guillaume on 21 Jul 2019
The two files have completely different time format. Motor1_1.csv should be read as datetime directly by readtable in any recent version of matlab, so wouldn't need any conversion.
Motor11.csv having an unconventional time encoding needs the conversion as I've shown.

Sign in to comment.

More Answers (1)

Artur Nuritdinov
Artur Nuritdinov on 21 Jul 2019
I have found the mistake. Below is the correct code
CORRECT CODE.png
  2 Comments
Guillaume
Guillaume on 21 Jul 2019
Please don't post screenshots of the code. Paste the code as text.
It's a bit poor form to accept your own answer, particularly as you didn't identify the original problem. Reputation, which we only get when answers are accepted or voted on is the only reward we get for helping you.
Artur Nuritdinov
Artur Nuritdinov on 21 Jul 2019
Guillaume, sorry, I didn't know it. This is the first time when I ask the question and, in general, use MATLAB Answers. Thanks for your help! Will keep it in mind next time

Sign in to comment.

Categories

Find more on Data Type Identification in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!