Reading numeric values from csv file

41 次查看（过去 30 天）
Lola
Lola 2022-6-7
评论： Lola 2022-6-11
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 个评论
显示 3更早的评论
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 个评论
显示 1更早的评论
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 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