Importing and Analyzing .txt files

3 次查看（过去 30 天）
Marcos Perez Rodriguez
编辑： dpb 2019-10-6
How can I import multiple files into matlab and then for example only get data from certain columns and certain parts of that column? For example I could have a .txt file with 1,000 lines and 3 columns (date, flowrate1,flowrate2). The dates range from jan-dec and I only want to import data from columns 2,3 (flowrate1,flowrate2) from the month of March?
  1 个评论
dpb
dpb 2019-10-5
编辑：dpb 2019-10-6
Just read the full file and then select the subset of data wanted...if you only import the flow data, you don't have the date data from which to select.
One good way would be to use detectimportoptions first, then use that object with readtable and it most likely will be able to automagically import the date column as datetime which is easy to use to select dates within ranges.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2019-10-5
https://www.mathworks.com/help/matlab/ref/timerange.html
You can use readtable() and convert to timetable() objects, and use timerange() indexing.
Alternately, you can use readtable(), and use month() on the date column, and compare the result to 3 in order to get a mask for which rows to use. Note that this would find all March items from separate years if there are multiple years in the file.

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