Reading numeric values from csv file

27 次查看(过去 30 天)
Hi there. I am trying to read numeric values on matlab from a csv file that is created using PuTTY. I want to read data in realtime from row 5 going onwards and column 3 specifically. The data is being captured in realtime. I have tried a using a matlab code but I can't seem to read in the numeric values. I also want to store the values displayed into an array for later use. Please kindly assist
  5 个评论
Lola
Lola 2022-6-8
Yes I'm not sure why the cells are getting mixed up. The reason I'm using PuTTY is because for now I'm reading sensor values from I2C connections. However the aim will be to read data from the receiving end of an nRF24l01 module. So I'm not able to read from a specific pin on arduino.
Walter Roberson
Walter Roberson 2022-6-8
csvread can skip text header lines, and it can skip a fixed number of columns that can include text. But all entries after that on the line must be purely numeric. The only values that csvread would be able to handle in that file are the BPM (all of which happen to be 0 in the sample)

请先登录,再进行评论。

采纳的回答

Chaitan Divagi
Chaitan Divagi 2022-6-8
Hello Lola,
I understand that you want to read the numeric values from specific column from the csv file in realtime.
You can perform this task using MATLAB functions in the following manner:
data = readtable('<CSV-file>.csv','NumHeaderLines',5); % use readtable instead of csvread and 'NumHeaderLines', 5 skips the 5 rows from the table
col_vec = data(:, 3); % reads the 3rd colum from the table and stores in the col_vec variable
I hope that the information provided helps in resolving your query.
Thanks,
Chaitan,
  3 个评论
Walter Roberson
Walter Roberson 2022-6-10
data = readtable('<CSV-file>.csv','NumHeaderLines',5); % use readtable instead of csvread and 'NumHeaderLines', 5 skips the 5 rows from the table
col_vec = data{:, 3} ; % reads the 3rd colum from the table and stores in the col_vec variable

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Import and Export 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by