r - Pretty printing zeros in data.frame with integers and doubles to CSV -


i have following data.frame:

q <- data.frame(a = rep(0,12), b = rep(c(0,1),6), c = 0:11, d = c(rep(0.0,10),0.003579535,0.045418328), e = c(rep(0.0,10),0.001716128,0.057440227))  > q    b  c           d           e 1  0 0  0 0.000000000 0.000000000 2  0 1  1 0.000000000 0.000000000 3  0 0  2 0.000000000 0.000000000 4  0 1  3 0.000000000 0.000000000 5  0 0  4 0.000000000 0.000000000 6  0 1  5 0.000000000 0.000000000 7  0 0  6 0.000000000 0.000000000 8  0 1  7 0.000000000 0.000000000 9  0 0  8 0.000000000 0.000000000 10 0 1  9 0.000000000 0.000000000 11 0 0 10 0.003579535 0.001716128 12 0 1 11 0.045418328 0.057440227

i save in csv following format:

"a","b","c","d","e" 0,0,0,0.000000000,0.000000000 0,1,1,0.000000000,0.000000000 0,0,2,0.000000000,0.000000000 0,1,3,0.000000000,0.000000000 0,0,4,0.000000000,0.000000000 0,1,5,0.000000000,0.000000000 0,0,6,0.000000000,0.000000000 0,1,7,0.000000000,0.000000000 0,0,8,0.000000000,0.000000000 0,1,9,0.000000000,0.000000000 0,0,10,0.003579535,0.001716128 0,1,11,0.045418328,0.057440227

how can in format? i'm not sure how use existing functionality in print,format, , formatc before calling write.csv. first 3 columns should printed integers , last 2 columns should printed doubles 9 decimal places, including zeros.

?write.csv explains how this:

in cases conversion of numeric quantities governed option "scipen" (see options), internal equivalent of digits = 15. finer control, use format make character matrix/data frame, , call write.table on that.

indeed, default arguments format sufficient needs:

write.csv(format(q),row.names=false) "a","b","c","d","e" "0","0","0","0.000000000","0.000000000" "0","1","1","0.000000000","0.000000000" "0","0","2","0.003579535","0.001716128" "0","1","3","0.045418328","0.057440227"

due various conventions want apply data, think have header , data separately:

# write header write.csv(q[0,],"mydata.csv",row.names=false) # "a","b","c","d","e"  # add data write.table(format(q,trim=true),"mydata.csv",row.names=false,col.names=false,sep=",",quote=false,append=true) # 0,0,0,0.000000000,0.000000000 # 0,1,1,0.000000000,0.000000000 # 0,0,2,0.000000000,0.000000000 # 0,1,3,0.000000000,0.000000000 # 0,0,4,0.000000000,0.000000000 # 0,1,5,0.000000000,0.000000000 # 0,0,6,0.000000000,0.000000000 # 0,1,7,0.000000000,0.000000000 # 0,0,8,0.000000000,0.000000000 # 0,1,9,0.000000000,0.000000000 # 0,0,10,0.003579535,0.001716128 # 0,1,11,0.045418328,0.057440227

Comments

Post a Comment

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

i'm looking dynamically populate select element names of items stored array. for reason it's not working , i'm not sure why. html: <div class="col-md-4 col-md-offset-4"> <select class="select1"> </select> , <select class="select2"> </select> </div> note i'm using bootstrap layout. here's jquery i'm using try , populate ".select1" jquery: select: function() { $.each(state.greens, function(index, value) { $(".select1").append("<option value =' " + index + " '>" + state.greens[index].name + "</option>"); }); } note function 'select' stored within object called 'display'. state.greens name of array i'm trying access. so @ end of html page call display.select(); call function. no error messages showing in console. also, saw question: appending
Read more

Android soft keyboard reverts to default keyboard on orientation change -

i'm building android soft keyboard , can't seem fix bug - have arabic , qwerty keyboard , when rotate device on qwerty keyboard (or arabic shift), it's if program has "restarted" , becomes arabic keyboard without shift. the onsaveinstancestate(bundle savedinstancestate) not work because application not extend activity inputmethodservice . i put following in android manifest android:configchanges="keyboard|keyboardhidden|orientation" android:windowsoftinputmode="stateunchanged|adjustresize"> i tried using @override public void onconfigurationchanged(configuration newconfig) { super.onconfigurationchanged(newconfig); log.i(mydebug, "config changed " + currentkeyboard.equals(qwerty)); } however, currentkeyboard.equals(qwerty)) results false , made sure true before orientation change. any appreciated. i think applications fault. if application restarting on orientation change
Read more

Rendering JButton to get the JCheckBox behavior in a JTable by using images does not update my table -

i rendering jbutton image on simulate jcheckbox behavior. why don't let jtable render jcheckbox? because need bigger checkboxes , there's no way can resize them (as far know). so, have own table cell renderer , editor. both renders jbutton , checkbox images on them. trying change image checked image unchecked image (or vice versa) , update cell value (boolean true or false). however, reason, getcelleditorvalue() not update table. so, release mouse, value goes original one. any appreciated! lot! public class tableexample extends jframe { jscrollpane pane; jpanel panel; jtable table; object[][] data; mytablemodel tm; renderer buttoncolumn; public tableexample(object[][] data) throws ioexception { string[] columns = {"column#1", "column#2", "column#3", "column#4", "column#5", "column#6"}; this.data = data; this.setpreferredsize(new dimension(700, 500));
Read more