Reading data from csv or tsv file starting from some line

14 次查看（过去 30 天）
Ahmed Anas
Ahmed Anas 2020-6-9
评论： Cris LaPierre 2020-6-11
Hi All,
I need to read data from a file openable in notepad. The file format can be csv or tsv. But the data will start from some line say 3 or 4.
Similar file has been attached. In this file the values are starting from line 5 and format is tsv. So line 5 will be read first and there will be five values which should be stored in a matrix and then line 6 values and so on.
I have tried too many ways but nothing is working.
Thanks all

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

采纳的回答

Cris LaPierre
Cris LaPierre 2020-6-9
Is the format of your data the same in all your files? If yes, then use the import tool. This will allow you to interactively configure your import. You can then generate the corresponding code (as a script or a function) that can be used to automate the import process of all files with the same formatting.
If you do want to create an importing function, this video shows you how to generate and reuse your code.
And if you have a lot of files, this video shows you how to use the import function you have created in conjunction with a datastore to import multiple files.
I'd suggest reading your data in as a table. This short video shows how to access data in a table.
  7 个评论
显示 5更早的评论
Ahmed Anas
Ahmed Anas 2020-6-11
Cris LaPierre, Thanks Bro, the last one worked perfectly..
But i have one question here, is it possible to get the number of lines where the data is not properly formatted,just as in this case its value is 4.
Cris LaPierre
Cris LaPierre 2020-6-11
I'm not aware of a simple, automatic way to do this. You can search MATLAB Answers for other posts on automatically detecting the number of headerlines, but each solution is typically tailored to the use case.
One idea that comes to mind would be to use fgetl to read the file one line at a time. Use strsplit to separate the columns of data in that line. You would then need to write some sort of logic to determine if the first value can be converted to a valid number (it will be read in as a string).

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

产品


版本

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by