How do I import string and numeric data from a very large, mixed data set?

Question

Jordan Andersen 2016-11-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/311149-how-do-i-import-string-and-numeric-data-from-a-very-large-mixed-data-set

回答： KSSV 2016-11-8

Hi there,

I have data files that contains string headers in row 0, followed by numerical data in rows 1-201. This organisation is repeated for 4 trials in total (i.e. Trial 2 headers in row 202, Trial 2 data in rows 203-403, Trial 3 headers in row 404, and so on). I didn't design the data files... This is what the data look like:

Time Vertex LFinger LWrist LElbow LShoulder LHip 0 0.6389 0.1539 0.1122 0.0793 0.3415 -0.0797 0.005 0.638 0.1388 0.1001 0.0751 0.3423 -0.0808 0.01 0.6371 0.123 0.0876 0.0714 0.3433 -0.0821 ... Time Vertex LFinger LWrist LElbow LShoulder LHip 0 0.6371 0.1462 0.0967 0.0798 0.2936 -0.0987 0.0049 0.6436 0.1387 0.0913 0.0823 0.3002 -0.0928 0.0098 0.6493 0.1297 0.0849 0.0841 0.3066 -0.0879 ...

I would like to create 2D arrays in MATLAB from 20 data files that have the same organisation described above so I can compile them into 1 Excel workbook containing different sheets for each data file. I've tried several different ways and can't see to figure it out. Any help would be greatly appreciated.

Thanks, Jordan