How can I import data from .csv file with numeric values and texts (with column headers) into MATLAB Workspace?
209 次查看(过去 30 天)
显示 更早的评论
I have data files (.csv of course) which contains several columns each with a column header. I want to import the data as I do in R. Using 'csvimport' I'm able to capture only the numeric values not the strings in the data. Please someone tell me the procedure of importing such data.
0 个评论
回答(6 个)
Gareth Thomas
2014-3-23
编辑:MathWorks Support Team
2018-11-7
If you right click on the .csv file you can use the “Import Tool” which will help you through the import process. you will be able to choose what data types are imported.
If you click the “Import” button, you can also see the generated code or script. You will see the code it generates.
Another way is to use: “readtable”. See the “readtable” page examples on reading *.csv files.
I hope that this helps. Gareth
0 个评论
adam honse
2018-3-9
编辑:Walter Roberson
2021-9-25
[~,~,data] = xlsread('myfile.csv')
works just fine for csvs.
0 个评论
Augustine Ekweariri
2017-3-6
You can use the csvread(csv_file.csv,row_offset,col_offset) command to read data from a csv file in this format;
a = csvread('csv_file.csv',1,0);
for more information, visit;
0 个评论
Stu Schwartz
2017-8-6
Input to csvread must be all numeric.
Mixed csv data can be input with table read and a format specification. See readtable online help and example: https://www.mathworks.com/help/matlab/import_export/import-mixed-text-and-numeric-data-from-a-text-file.html
1 个评论
Walter Roberson
2017-8-6
Historically it was true that input to csvread had to be all numeric. However, somewhere around R2015a, the range specification to csvread became able to skip over leading text rows and leading text columns (provided that the user asked to skip them); it is not able to skip over trailing text rows or trailing text columns however.
However, this ability to skip over leading rows does not help the user read the strings as they asked. It would, though, allow for the possibility of fopen() the file, fgetl() one line, fclose(), split the input line to get the column headers, then csvread() the file telling it to skip the first row.
Saeed Nematshahi
2020-12-14
use
a = csvread('csv_file.csv',1,0);
this only remove first column.
by changing 0 to 1 you can remove first column and first zero.
1 个评论
Walter Roberson
2020-12-15
Someone already recommended that three years ago; https://www.mathworks.com/matlabcentral/answers/122717-how-can-i-import-data-from-csv-file-with-numeric-values-and-texts-with-column-headers-into-matlab#answer_257459
ehsan ghane
2021-9-25
for matlab R2020b, use readmatrix fnction.
2 个评论
Walter Roberson
2021-9-25
readmatrix() is not able to read text and numeric in the same file. The user had said "Using 'csvimport' I'm able to capture only the numeric values not the strings in the data." which I think means they wanted the text as well.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!