How to use precision only when needed with dlmwrite ?

17 次查看(过去 30 天)
I am having the problem that I want to save some data to a csv file.
The data I have in Matlab is something like this:
20190212114854371;517585652892199;20190212114852000;-2.3511062;4.999093;5.3438582;0.28869548;0.16085984;-0.57739097;52.27151;10.533472
You see, it is mixed int and float values. I want to store them exactly like this. However when I use dlmwrite without precision I end up with data like this:
2.019e+16;1.8509e+14;2.019e+16;-1.6664;6.3925;7.3933;0.0042612;0;0.0042612;52.274;10.527;0
which is not enough or it adds a lot of zeros, which slows down the writing process, if i use the needed precision:
20190211112837504.00000000;221480220621999.00000000;20190211112835000.00000000;-0.69032930;5.75713100;7.90648400;0.15009704;0.01083470;0.10411896;52.26511800;10.53640600;0.00000000
Is there a way to tell dlmwrite to onyl use precision if needed or is there another option to write csv data with precision ?
(Please do not be confused: I picked up different lines from the output.)
  2 个评论
Stephen23
Stephen23 2019-2-16
编辑:Stephen23 2019-2-17
These data look much like timestamps 20190212114854371 20190212114852000. Of course dates/times should not be combined into one decimal integer (doing so is a total misrepresentation of the bases involved with dates and times). Dates and times should be stored in a datetime variable (or even a string/char variable), which would make it clearer how to then save it properly.
Benjamin Lemmer
Benjamin Lemmer 2019-2-16
This is correct. It turned out that importing only numbers is much faster instead of the generated import routine by matlab.
Therefor and since I do not need to work with the time stamps I decided to use numbers. Is there a way to convert the datestamp after having importet it or a faster method to import the data than the generated script by matlab ?

请先登录,再进行评论。

采纳的回答

Walter Roberson
Walter Roberson 2019-2-14
No. dlmwrite only accepts one precision argument . That argument must be an integer (which is used as number of decimal places) or it must be ann fprintf format item describing aa single output value . It is valid to pass something like '%.12g' but there is no way to pass something conditional that says to use different format descriptions depending upon the value to be output (or the column number)
Furthermore inside matlab the values are not what you claim they are . There is no way to represent 0.1 exactly on floating point , only integer multiples of 2^(-N) for some integer N. Every one of the values you show with a decimal point has additional digits that you have not shown and matlab has no way of knowing whether those are wanted digits or not .
  4 个评论
Benjamin Lemmer
Benjamin Lemmer 2019-2-16
Too bad, it actually did not work. Do you have another idea how i could reach my goal ?
Stephen23
Stephen23 2019-2-17
编辑:Stephen23 2019-2-17
@Benjamin Lemmer: write your own file-writing function based on fopen, fprintf, and fclose.
If you import the timestamps as character than you avoid any loss of their data, and can easily print these to the output file directly using the %s format operator.

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Dates and Time 的更多信息

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by