read large csv File and export specific Values

2016 7 12
1 个回答
更新时间：2016 8 2
3 次查看（30 天）

0 个投票

Hello,
I want to read a large csv-File with mixed Datatype and then Export specific values.I uploaded the csv i need to import and i need the values: A2925-A2952, F2925-F2952, AE2925-AE2952
can anyone help? thanks a lot!

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Robert Fennis
Robert Fennis 2016-7-12
Its quite a burdon because of the sheer size of the file. Can't you simply open it in excel and use the ';' as a separator symbol? I advice to first delete all the information that you don't need to speed up the processs. You could use Notepad++ or Excel to speed up this process.
hdiba
hdiba 2016-7-12
Unfortunately I have a lot of files (over 5000) so its quite difficult to edit all the files. I already wrote a code to read the data, do u have an idea how to export the values?
clear all;
cd('C:\Users\Samsung\Desktop\diba masterarbeit\JS');
liste=dir('*.csv');
l=length(liste);
gesamtIndex=0;
data=cell(1,l);
for lauf=1:l
gesamtIndex=gesamtIndex+1;
fileID = fopen([liste(lauf).name]);
formatSpec=repmat('%s', 1, 300);
data{gesamtIndex}=textscan(fileID, formatSpec, 'Delimiter', ';');
fclose(fileID);
M=[data{gesamtIndex}{:}];
end
per isakson
per isakson 2016-7-24
编辑：per isakson 2016-7-24
The rows 2925 through 2952 constitutes the block of data under the header, which starts with the string
"Typ";"Simulationstyp";"IDRechenlauf";"ID";"Jahr";"Bezeichnung";"Nein"
There is only one header starting with that string. I think it would be more robust to use the headers than the row numbers. The same goes for the column headers. (Does AE refer to the English alphabet? )
Walter Roberson
Walter Roberson 2016-7-24
AE would be a column reference in Excel, with 2925 to 2952 being the row numbers in that column.

请先登录，再进行评论。

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

回答（1 个）

Varun Gunda
Varun Gunda 2016-8-2

0 个投票

It is my understanding that you want to read large csv-file with mixed datatype and export specific values.
You can do this by using “csvread” function in matlab. Refer the following document for more information.
http://in.mathworks.com/help/matlab/ref/csvread.html

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

提问:

hdiba
hdiba
2016-7-12

回答：

Varun Gunda
Varun Gunda
2016-8-2

Community Treasure Hunt

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

Start Hunting!

Translated by