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

Question

Hussein Hussein 2018-7-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/412678-how-can-i-evaluate-csv-file-written-in-excel-or-as-a-text

评论： Hussein Hussein 2018-7-31

*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 个评论
显示无隐藏无

Ben 2018-7-30

If you can attach the start (or all) of your CSV that would make it easier to answer.

Hussein Hussein 2018-7-31

TestFile.csv

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

请先登录，再进行评论。

请先登录，再回答此问题。