This is my sample CSV. It is an extract from UCI SUSY dataset, only first
few were saved using an R script.
On Wednesday, December 9, 2015 at 3:26:19 AM UTC+5:30, Andre Bieler wrote:
>
> I cannot reproduce this.
> Can you provide your data file?
>
> I attached a .cvs file and a .jl file to
> read out the data. Seems all good to me
> and the values are stored as Float64.
>
>
>
>
>
> On Tuesday, December 8, 2015 at 7:24:26 AM UTC-5, Vishnu Raj wrote:
>>
>> Hi,
>> I have a CSV file with values represented as 2.345 and 1.23e2 (say) and
>> no header
>> When I try readtable( "file", header=false ), I'm getting all the cell
>> values as "UTF8String". How can I properly read it as Float64??
>>
>> - vish
>>
>
"labels","lepton 1 pT","lepton 1 eta","lepton 1 phi","lepton 2 pT","lepton 2 eta","lepton 2 phi","missing energy magnitude","missing energy phi","MET_rel","axial MET","M_R","M_TR_2","R","MT2","S_R","M_Delta_R","dPhi_r_b","cos(theta_r1)"
0,9.728614687919616699e.01,6.538545489311218262e.01,1.176224589347839355e.00,1.157156467437744141e.00,.1.739873170852661133e.00,.8.743090629577636719e.01,5.677649974822998047e.01,.1.750000417232513428e.01,8.100607395172119141e.01,.2.525521218776702881e.01,1.921887040138244629e.00,8.896374106407165527e.01,4.107718467712402344e.01,1.145620822906494141e.00,1.932632088661193848e.00,9.944640994071960449e.01,1.367815494537353516e.00,4.071449860930442810e.02
0,1.86504542827606,-0.256076544523239,1.21556389331818,1.12735903263092,1.59875667095184,-0.421102404594421,0.59562224149704,-1.28983151912689,0.847075223922729,0.162857249379158,2.08215761184692,1.03591108322144,0.4414943754673,0.822985291481018,2.03021240234375,1.12381184101105,0.503678143024445,0.105927996337414
1,1.23669397830963,-1.0564945936203,1.06098961830139,1.69133532047272,-0.1053371950984,-0.633382022380829,0.497801452875137,0.840823829174042,0.297966241836548,0.813646852970123,1.36200261116028,0.793418228626251,0.516939520835876,0,1.36335909366608,0.181166917085648,1.53079199790955,0.0442323982715607
1,2.32381153106689,0.317979544401169,-0.716382801532745,0.560029029846191,1.72120821475983,1.28127014636993,1.27762341499329,0.85041618347168,1.13450503349304,-0.930379033088684,1.64815187454224,1.93562304973602,1.04217255115509,1.08652937412262,1.54960966110229,1.74726450443268,0.296678125858307,0.499137997627258
0,0.688603639602661,0.286295622587204,-0.415569216012955,0.906572997570038,-0.395993709564209,1.47816252708435,0.303133547306061,1.63432312011719,0.122213765978813,0.230870336294174,0.696205914020538,0.497935771942139,0.634675800800323,0,0.698711693286896,0.160106301307678,0.991877377033234,0.158656999468803
1,1.42594838142395,1.88176500797272,0.597493171691895,1.26869165897369,1.931725025177,-1.54698240756989,1.02646565437317,-0.757853448390961,1.52267813682556,-0.704253792762756,1.1417064666748,1.43718016147614,1.11705219745636,1.98129916191101,1.16214549541473,1.4821389913559,1.16295492649078,0.322542011737823
1,4.48375272750854,1.17115998268127,0.350268751382828,3.17667937278748,0.683380365371704,-1.49058628082275,2.36226868629456,-1.07206094264984,2.40570306777954,-1.85488831996918,3.44455337524414,3.6280779838562,0.934669852256775,2.14494132995605,3.44335794448853,2.06024789810181,0.786961138248444,0.357472985982895
0,1.432950258255,0.245450794696808,1.41979825496674,1.87674164772034,0.512243330478668,-0.188924312591553,0.233110710978508,-1.00570917129517,0.348837673664093,0.127952411770821,1.35067427158356,0.653409540653229,0.429291725158691,0.63501912355423,1.34790122509003,0.476063072681427,0.431901723146439,0.0716297030448914
1,0.467593640089035,-0.956501662731171,-0.328008234500885,0.675719380378723,-0.462600588798523,0.937212467193604,1.03428637981415,-0.844957292079926,1.26218342781067,-0.0472075901925564,0.473422288894653,0.807690262794495,1.51395046710968,1.13359785079956,0.54059636592865,0.89522397518158,1.26902544498444,0.372736006975174
