Plot mixed data from .csv file

1 次查看（过去 30 天）
Michael Cody
Michael Cody 2015-8-24
评论： Michael Cody 2015-8-26
EDIT - file now attached, apologies.
Hi,
Noob question about data import from .csv file.
Got a historian database that logs values of various sensors. Can export from database to flat file.
Typical format of file: TagName,DateTime,Value. Where there are multiple tagnames in each file, values usually recorded every second. Sample file attached.
Aim is to plot sensor values on same plot and then do some frequency analysis to determine periodicity patterns.
So far I have been pre-processing by manually splitting sensor data into individual files (using Excel) then importing these files and plotting. I feel there must be more efficient method/workflow to read this mixed file. (I did see timeseries mentioned in data analysis section of documentation maybe this is way to go, but can't figure out how to create from file.)
  • Can any one suggest a suitable workflow with required commands/wizard?
Any help or info appreciated.
Thank you,
Michael
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2015-8-25
Do the "TagName" identify the different sensors? Is the data from all of the files to be combined, or is each file to be handled independently?
Michael Cody
Michael Cody 2015-8-25
Sample file now attached.
Yes TagName is ID of sensor. Mixed, current, torque, speed.
Looking for elegant way to import and then plot all or any combination on same plot. Then further analysis on selected sensors: basic stats and identifying periodicity of reading.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2015-8-25
Consider using readtable() . Then you can use http://www.mathworks.com/help/stats/grpstats.html for grouped statistics
If you have the data in Tags (cell array of strings) then you can determine the grouping information by using
[uniquesensors, ~, sensornumber] = unique(Tags);
After that, sensornumber(K) tells you which grouping is appropriate for Tags{K}, so for example:
numsensors = length(uniquesensors);
for Sn = 1 : numsensors
matches_sensor = sensornumber == Sn;
times_for_sensor = DateTime(matches_sensor);
vals_for_sensor = Value(matches_sensor);
ph(Sn) = plot(times_for_sensor, vals_for_sensor); %assuming times are datenum or datetime not strings
if Sn == 1; hold all; end
end
legend(ph, uniquesensors);
  6 个评论
显示 4更早的评论
Walter Roberson
Walter Roberson 2015-8-25
If you happen to be using R2013b or R2014a, then those support readtable() but textscan for them does not support %{}D date format; that was introduced in R2014b I think (might have been R2015a). The workaround for those is to read the field with %s and datenum() as needed. You could use
T.DateNum = datenum(T.DateTime, 'MM/dd/yyyy HH:mm:s');
Michael Cody
Michael Cody 2015-8-26
Walter, Thanks a lot again. Yes I running R2014a, so that explains it. Michael

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by