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

3 views (last 30 days)
Hussein Hussein on 30 Jul 2018
Commented: Hussein Hussein on 31 Jul 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
Hussein Hussein on 31 Jul 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

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

Categories

Find more on Spreadsheets in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by