open large csv file

4 次查看（过去 30 天）
asad ali
asad ali 2019-8-29
评论： Nicolas B. 2019-8-29
i have a csv file with 93 coloums and 150000 rows
number of coloums may change to 90 in some tests and all entries are text / string
i need a single code to calculate the no of rows and couloums dynamically by reading the csv file and then get the 93/90 variable data in seprate variables
i have been using uiimport in my GUI but when i compiled the code into an application (.exe) using matlab application compiler uiimport function gives following error
"Error using uiimport>showLargeFileWindow (line 1126)
Java exception occurred:
java.lang.NullPointerException
at com.mathworks.mlwidgets.importtool.TextImportClient.showWaitProgressWindow(TextImportClient.java:253)"
Now i am using
fid=fopen('1.csv');
>> data = textscan(fid,'%s','HeaderLines',0,'Delimiter',',','CollectOutput',1);
now i am getting all the data in i single variable data Untitled.jpg
can any body help me for opening this csv file in standalone application with each variable having its values stored
First row are the variable names

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

回答（1 个）

Nicolas B.
Nicolas B. 2019-8-29
Hi Asad,
have you considered using readcell or readtable depending of what you need for data type? You can configure it to define the delimiters. For example:
T = readtable(filename, 'Delimiter',';');
Regards
  2 个评论
asad ali
asad ali 2019-8-29
i am receiving this error while using readtable
Tbl = readtable('1.csv', 'delimiter', ';', 'headerlines', 0, 'readvariablenames', true);
Error using table/readTextFile (line 237)
Cannot interpret data in the file '1.csv'. Found 92 variable names but 93 data columns. You
may need to specify a different format string, delimiter, or number of header lines.
Error in table.readFromFile (line 33)
t = table.readTextFile(filename,otherArgs);
Error in readtable (line 118)
t = table.readFromFile(filename,varargin);
Nicolas B.
Nicolas B. 2019-8-29
I would say that you have 1 header missing. Try to open your csv-file in libreoffice or excel and check whether there are headers to each column. If you cannot correct that, read the file without headers.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by