清空筛选条件
清空筛选条件

variables to import in readtable for a csv file

3 次查看（过去 30 天）
Mihai Milea
Mihai Milea 2021-9-27
评论： Stephen23 2021-9-27
Hi . I have the following maybe silly question: I have a csv file where the first row are some numerical values and second row some names. I attached a test file.
I used openFileName = strcat(pricedir,'/', 'test.csv');
opts=detectImportOptions(openFileName);
opts.VariableNamingRule = "preserve";
open=readtable(openFileName,opts);
While the first row is correct the second one is all NaN
  2 个评论
Mathieu NOE
Mathieu NOE 2021-9-27
hello
readtable works for column oriented files - not like your csv file which is row oriented

请先登录，再进行评论。

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

采纳的回答

Mathieu NOE
Mathieu NOE 2021-9-27
hello
as mentionned above , readtable is not appropriate for extracting row oriented files
you can do this (based on your example) :
filename = 'test.csv';
[data_num, data_str] = myreadfunction(filename)
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
function [data_num, data_str]= myreadfunction(filename)
a = readlines(filename);
[m,~] = size(a);
data_num = str2num(char(a(1,:))); % first line
data_str = split(char(a(2,:)),','); % second line
end
  2 个评论
Stephen23
Stephen23 2021-9-27
Ran in:
Avoiding NUM2STR (which hides evil EVAL inside):
tmp = readlines('test.csv');
num = str2double(split(tmp{1},','))
num = 3×1
NaN 23 35

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by