How to import .csv files, keeping all the headers (which are on multiples rows) in order to extract some information from the headers?
5 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Pietro Tassan
el 24 de Feb. de 2022
Comentada: Scott MacKenzie
el 25 de Feb. de 2022
Hi!
I have a bunch of .csv files that I have to manipulate and some information that I need is stored in the headers.
Such files are organized in this way:
- from row 1 to row 21, organized in just one column, there are headers (strings) containing some information I need (regarding the experiments I have done);
- row 22 contains the proper headers in two columns;
- from row 23 to 1361 there are the values (numbers) related to the headers in row 22.
I leave here attached one of those files that I would like to analyse.
So I need to access to the values in row 7 and row 15, which are both constant for each file. For example, in the case of the file attached, the values are respectively "# CenterZ = -7923.190" and "# Power2 = 1.161346e-06". Then, I have to store from row 7 the number -7923.190 and for row 15 the number 1.161346e-06. Those values change from .csv to csv.
Do you have any idea on how I could proceed? I have checked the community posts with no success...
Hope I have been cleared in the explanation.
0 comentarios
Respuesta aceptada
Scott MacKenzie
el 24 de Feb. de 2022
Editada: Scott MacKenzie
el 24 de Feb. de 2022
Assuming your files are consistently formatted, here's one way to extract the data values in the header lines and then read the data after the header lines into a matrix:
f = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/906250/end_cavity1_v5_Z_-2.0000_2Power_0.0150_Spectrum.csv';
C = readcell(f, 'range', '1:21');
C7 = C{7};
CenterZ = str2double(C7(13:end))
C15 = C{15};
Power2 = str2double(C15(13:end))
M = readmatrix(f); % extract the data starting after the header lines
2 comentarios
Scott MacKenzie
el 25 de Feb. de 2022
@Pietro Tassan You're welcome. Glad to help.
BTW, below is another way to extract values from the header lines. This method is a bit cleaner, I think:
s = split(C(7));
CenterZ = str2double(s(4))
s = split(C(15));
Power2 = str2double(s(4))
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Type Identification en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!