Borrar filtros
Borrar filtros

How can I evaluate CSV File written in EXCEL or as a Text

1 visualización (últimos 30 días)
Hussein Hussein
Hussein Hussein el 30 de Jul. de 2018
Comentada: Hussein Hussein el 31 de Jul. de 2018
*CSV Example as Excel Table:*
"0 Epm_nEng SWord 0.000 300.000 6.900.000 1 Epm_nEng SWord VAR>VAL 20.000 0.000 100 Bit (aus 16-Bit) VAR==VAL n/a 0.000 1 1 0.000000 "
" 0 [rpm] 0_300 [rpm] 300_600 [rpm] 600_900 [rpm] 900_1200 [rpm] 1200_1500 [rpm] 1500_1800 [rpm] 1800_2100 [rpm] 2100_2400 [rpm] 2400_2700 [rpm] 2700_3000 [rpm] 3000_3300 [rpm] 3300_3600 [rpm] 3600_3900 [rpm] 3900_4200 [rpm] 4200_4500 [rpm] 4500_4800 [rpm] 4800_5100 [rpm] 5100_5400 [rpm] 5400_5700 [rpm] 5700_6000 [rpm] 6000_6300 [rpm] 6300_6600 [rpm] 6600_6900 [rpm] > 6900 [rpm]"
"0 54 18 17997 3715 5878 8034 11307 16213 7043 710 310 142 89 131 96 77 70 40 13 5 5 11 0 0 "
The important part of the file starts from 0[rpm] and then 0_300[rpm] which is an interval of rotation's number, after this intervals you can see a list of numbers 0 54 18 .... which are the number of detected Errors in each interval, so what i would like to do is to plot a statistic Diagramm using Matlab.
How could i get entrance to the CSV or Excel table and plot such unsorted data.
Thanks for Help huhu
  2 comentarios
Ben
Ben el 30 de Jul. de 2018
If you can attach the start (or all) of your CSV that would make it easier to answer.
Hussein Hussein
Hussein Hussein el 31 de Jul. de 2018
i would like to evaluate rows from 8 to 14! row 13 are the intervales for the Speed, row 14 are the number of calculated Speed in each interval. Both are written in the same column and what i want is to seperate them and get the interval and it's calculate Speed each in one column in order to plot them. i hope it's easy to understand Thank you

Iniciar sesión para comentar.

Respuestas (1)

Ben
Ben el 30 de Jul. de 2018
Have a look at readtable. Then plot the data loaded into the workspace.

Community Treasure Hunt

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

Start Hunting!

Translated by