How to read a column named by some header in data file?

Question

prashant sharma 2018-11-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/428033-how-to-read-a-column-named-by-some-header-in-data-file

评论： madhan ravi 2018-11-5

data.txt

Dear All, I have 10 to 15 columns named with different headers in one data file (data.dat) (sample data file is attached below). The position of the column is not fixed and they can change after each run according to the inputs. Therefore, it is difficult to make a program with fixed column numbers. Is there any way to sort out the columns by their name and then proceed for other calculations? For example: Plot between Time and 2p2_3p1_4S___, multiplying any column by number (scalar), etc.

       Time      2p2_3p1_4S___   2p1_3p1_3D___   2p1_3d1_4F___   1s2_3p1_2P___
0000000E-07   1.387545E-011   8.116580E-008   6.224102E-006   1.804010E-006
0000000E-07   3.149958E-012   1.922005E-008   1.512518E-006   4.319076E-006
0000000E-07   2.180968E-012   1.353958E-008   1.076323E-006   6.377379E-006
0000000E-07   1.951598E-012   1.214133E-008   9.663528E-007   7.997309E-006
0000000E-07   1.805993E-012   1.124047E-008   8.948846E-007   9.263814E-006
0000000E-07   1.690790E-012   1.052642E-008   8.381780E-007   1.024948E-005
0000000E-07   1.597212E-012   9.946256E-009   7.920958E-007   1.101235E-005
0000000E-07   1.520693E-012   9.471772E-009   7.544044E-007   1.159861E-005
0000000E-07   1.457775E-012   9.081556E-009   7.234037E-007   1.204494E-005
0000000E-06   1.405719E-012   8.758646E-009   6.977473E-007   1.238051E-005
1000000E-06   1.362348E-012   8.489555E-009   6.763642E-007   1.262849E-005
2000000E-06   1.325931E-012   8.263553E-009   6.584026E-007   1.280729E-005
3000000E-06   1.295089E-012   8.072101E-009   6.431845E-007   1.293155E-005
4000000E-06   1.268726E-012   7.908405E-009   6.301705E-007   1.301287E-005
5000000E-06   1.245968E-012   7.767055E-009   6.189311E-007   1.306048E-005
6000000E-06   1.226121E-012   7.643745E-009   6.091243E-007   1.308170E-005
7000000E-06   1.208630E-012   7.535042E-009   6.004778E-007   1.308236E-005
8000000E-06   1.193055E-012   7.438214E-009   5.927743E-007   1.306706E-005
9000000E-06   1.179043E-012   7.351078E-009   5.858408E-007   1.303945E-005
0000000E-06   1.166313E-012   7.271897E-009   5.795392E-007   1.300244E-005

Your kind help will be highly appreciated. Thanks

3 个评论
显示 1更早的评论隐藏 1更早的评论

prashant sharma 2018-11-5

Hi Stephen, I am using Matlab 8.3 (R2014a). Thanks

Stephen23 2018-11-5

编辑：Stephen23 2018-11-5

Then readtable is your best option, and you can access the variables of the table using the header names.

请先登录，再进行评论。

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

Answer 1

madhan ravi 2018-11-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/428033-how-to-read-a-column-named-by-some-header-in-data-file#answer_345235

编辑：madhan ravi 2018-11-5

在 MATLAB Online 中打开

Use

T=readtable('data.txt');
T.Time %finds column header with Time 
  ^^^^|______________________________________%denotes column header
T.x2p1_3d1_4F___ = T.x2p1_3d1_4F___ * 2;