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

2 views (last 30 days)
*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 Comments
Hussein Hussein
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

Sign in to comment.

Answers (1)

Ben
Ben on 30 Jul 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!