フィルターのクリア

How to import variable names and specific data range (comma separated values) from a .txt file?

11 ビュー (過去 30 日間)
Hi guys,
I read lots of similar questions but I cannnot solve the problem. I've downloaded Earth ephemerides from NASA JPL website(attached to this question there is the .txt file) and I need to extract only variable names line (row 23) and data from row 26 up to 29.
I want to avoid Matlab tool "import data", but rather I woulde prefer to use something like ""readtable" or similar. I tried to use readtable but I've troubles.
I tried to code something like that but it seems to not take the right lines.
clc; clear all; close all
% Ephemerides
file_name = 'Earth-Moon_sys_ephem_at_ast_epochs.txt';
opts = detectImportOptions(file_name)
opts.DataLines = [26, 29];
opts.VariableNamesLine = 34;
opts.VariableNames
opts.VariableTypes = ["double", "string", "double", "double", "double", "double", "double",...
"double", "double", "double", "double","double","double","double"];
EM_sys_eph = readtable(file_name ,opts)

採用された回答

Stephen23
Stephen23 2022 年 3 月 15 日
編集済み: Stephen23 2022 年 3 月 15 日
Make sure you specify the delimiter and (start) Range for DETECTIMPORTOPTIONS:
file_name = 'Earth-Moon_sys_ephem_at_ast_epochs.txt';
opts = detectImportOptions(file_name, 'Range',26, 'Delimiter',',');
opts.DataLines = [26,29];
opts.VariableNamesLine = 23;
opts.VariableTypes = ["double", "string", repmat("double",1,12)];
opts.VariableNamingRule = 'preserve';
EM_sys_eph = readtable(file_name, opts)
EM_sys_eph = 4×14 table
JDTDB Calendar Date (TDB) EC QR IN OM W Tp N MA TA A AD PR __________ ________________________________ ________ __________ _________ ______ ______ __________ __________ ______ ______ _________ __________ __________ 2.4545e+06 "A.D. 2008-Mar-06 00:00:00.0000" 0.016737 1.4709e+08 0.0010567 173.6 289.27 2.4545e+06 1.1408e-05 61.112 62.808 1.496e+08 1.521e+08 3.1558e+07 2.4576e+06 "A.D. 2016-Jul-09 00:00:00.0000" 0.016735 1.4709e+08 0.0021419 173.05 289.83 2.4578e+06 1.1408e-05 184.25 184.11 1.496e+08 1.521e+08 3.1557e+07 2.4589e+06 "A.D. 2020-Mar-17 00:00:00.0000" 0.01675 1.4709e+08 0.002633 176.77 286.22 2.4589e+06 1.1407e-05 71.765 73.6 1.496e+08 1.521e+08 3.1558e+07 2.4596e+06 "A.D. 2022-Jan-21 00:00:00.0000" 0.01669 1.471e+08 0.0028082 174.65 288.52 2.4596e+06 1.1408e-05 16.87 17.437 1.496e+08 1.5209e+08 3.1558e+07
  8 件のコメント
Giuseppe
Giuseppe 2022 年 3 月 15 日
@Stephen sorry, I missed something on my first attempt code. On my Matlab I get the output I attached in my first edited comment.
Stephen23
Stephen23 2022 年 3 月 15 日
編集済み: Stephen23 2022 年 3 月 15 日
If it works on your version, then:
  • go for it, use it
  • keep in mind that it might not work on other versions or OSs
The function READTABLE et al are being developed continuously, and can give different outputs for different versions (as we can see on this forum). Only you can decide if that is important for your work or not.

サインインしてコメントする。

その他の回答 (1 件)

Arif Hoq
Arif Hoq 2022 年 3 月 15 日
try this:
A=readtable('Earth-Moon_sys_ephem_at_ast_epochs.txt','delimiter','tab');
B=table2cell(A(20,:));
parameter=split(B,',')';
C=table2cell(A(23:26,:));
data=split(C,',');
output=[parameter;data]

カテゴリ

Help Center および File ExchangeStartup and Shutdown についてさらに検索

製品


リリース

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by