Hi,
Thanks :) That helped.
On Wednesday, December 9, 2015 at 6:43:30 PM UTC+5:30, Andre Bieler wrote:
>
> Hi Vish,
>
> there are two things I can spot.
>
> 1) You actually do have a header in the .csv file, so header=false is not
> a good option.
>
> 2) Something probably has gone wrong with the formatting of the second
> line in your .csv file.
> It contains stuff like: *.1.739873170852661133e.00* which cannot be
> interpreted as a number
> (note the dot in front of 1)
>
> if I remove the second line of your .csv file I can read it in with
>
> df = readtable("sample.csv")
>
> So you might check the script producing your .csv file to get a nicely
> formatted
> first line of the data.
>
> Hope this helps.
> Andre
>
>
>
>
> On Tuesday, December 8, 2015 at 11:27:34 PM UTC-5, Vishnu Raj wrote:
>>
>> 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
>>>>
>>>
