how read .csv file.?

3 次查看（过去 30 天）
pruth
pruth 2016-2-18
编辑： per isakson 2016-2-19
hello, guys. i m using csv file of size - 450mb. i dont know how handle it. .CSV file = 'firms3070014556960011_MCD14ML.csv'
which has data when I opened it in excel I got these 13 columns.
geom lat lon bright scan track acq_date acqtime sat con version brght31 frp
0101000000105839B4C80642400E2DB29DEFA71CC0 -7.164 36.053 328.2 3.6 1.8 10/25/2012 725 Terra 81 5.1 302.4 131.6
0101000000F2D24D6210484240E7FBA9F1D28D21C0 -8.777 36.563 332.8 3.1 1.7 10/25/2012 725 Terra 74 5.1 292.4 154.1
01010000003D0AD7A3709D4240C520B072689124C0 -10.284 37.23 320.2 2.5 1.5 10/25/2012 725 Terra 61 5.1 298.3 34
01010000006F1283C0CA814840E17A14AE47E129C0 -12.94 49.014 329.3 1.7 1.3 10/25/2012 726 Terra 29 5.1 306.6 32
01010000005839B4C8769E4840A69BC420B0722BC0 -13.724 49.238 324.7 1.8 1.3 10/25/2012 726 Terra 78 5.1 304.9 36.6
0101000000713D0AD7A3A04840C1CAA145B6732BC0 -13.726 49.255 321.8 1.8 1.3 10/25/2012 726 Terra 74 5.1 303.7 27.8
010100000039B4C876BE9F4840105839B4C8762BC0 -13.732 49.248 330.2 1.8 1.3 10/25/2012 726 Terra 83 5.1 303.5 56.2
0101000000F6285C8FC2354840A8C64B3789812FC0 -15.753 48.42 322.4 1.7 1.3 10/25/2012 726 Terra 75 5.1 299.2 30.5
01010000002B8716D9CE374840C3F5285C8F822FC0 -15.755 48.436 322.4 1.7 1.3 10/25/2012 726 Terra 75 5.1 299.3 32.8
0101000000333333333313474079E9263108AC2FC0 -15.836 46.15 334.5 1.2 1.1 10/25/2012 726 Terra 86 5.1 308.9 25
01010000004C37894160154740CFF753E3A55B30C0 -16.358 46.167 324.3 1.2 1.1 10/25/2012 727 Terra 77 5.1 302.5 16.4
0101000000B4C876BE9F2A474075931804566E30C0 -16.431 46.333 332.8 1.3 1.1 10/25/2012 727 Terra 85 5.1 304.8 32.4
here I don't know how many rows are there.I just copied some to give you an idea about my data. here I want to open this file read it. and last I want only three columns from this. column 2 column 3 and column 7 i.e lat, long and acq_date. hope u understand.
remember excel could not load whole data...out of limit
  2 个评论
Ingrid
Ingrid 2016-2-18
have you looked into the capabilities of textscan?
doc textscan
pruth
pruth 2016-2-19
hello, thanks for your reply I have used this
fid= fopen('firms3070014556960011_MCD14ML.csv');
dummy = textscan(fid,'%s','delimiter','\n'); % scan the content of the file
fclose(fid)
but this showing me an "error out of memory."

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2016-2-19
fid= fopen('firms3070014556960011_MCD14ML.csv', 'rt');
dummy = textscan(fid,'%*s%f%f%*s%*s%*s%s%*s%*s%*s%*s%*s%*s', 'delimiter', ',', 'HeaderLines', 1); % scan the content of the file
fclose(fid)
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2016-2-19
450 megabytes is not big, not unless you are using a 32 bit version of MATLAB on MS Windows that has not been configured with the 3G boot switch (or which is simply configured with too little RAM.)
per isakson
per isakson 2016-2-19
编辑：per isakson 2016-2-19
I have used GSplit, a free and reliable file splitter, to split large text files. And in a second step read the file in parts.

请先登录，再进行评论。

更多回答（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