Extracting data to plot time series with different colour for different days

1 次查看（过去 30 天）
Anirban Mandal
Anirban Mandal 2023-5-25
评论： Anirban Mandal 2023-6-3
I want to plot a time series plot of pressure data for different days, like the one I have attached below.
I am using the following files to read the data. In the dataset, before LTST, there is the sol no also attached, which I am not able to extract. I am not being able to extract both seperately. I was able to extract LMST and sol using extractAfter and extractBefore functions as there is a 'M' seperating them. Any suggestions on how to extract LTST and sol?
  2 个评论
Anirban Mandal
Anirban Mandal 2023-5-25
I did that already. I used readtable to extract the column and used table2array to convert it. Then I used strfind to find the space between them and seperate them. But, it was giving me error. I am attaching the code. The problem is that table2arrray is converting it to a cell array and that's why the last two lines are giving me errors.
clear
clc
x=readtable('WE__0567___________CAL_PS__________________P01.csv');
timeinfo=table2array(x(:,3));
spaceidx=strfind(timeinfo, ' ');
sol=timeinfo(1:spaceidx-1);
ltst=timeinfo(spaceidx+1:end);

请先登录，再进行评论。

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

采纳的回答

Saffan
Saffan 2023-6-2
Hi Anirban,
You can use the “split” function to extract “sol” values from LTST column using space as a delimiter.
Here is a code snippet to demonstrate that:
x = readtable('WE__0569___________CAL_PS__________________P01.csv');
timeinfo = table2array(x(:,3));
% Split timeinfo into SOL and LTST columns
splitCol = split(timeinfo, " ");
ltst = splitCol(:,2);
sol = str2double(splitCol(:,1));
Refer to this link for more information on splitting strings using delimiters:
Split strings at delimiters - MATLAB split (mathworks.com)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by