Help needed for accessing factor data,

The following (admittedly inelegant) code worked for me to get the data in:

D = readLines("test.txt")
D = sapply(D,strsplit,",")
D = t(simplify2array(D))
rownames(D) <- NULL

D = as.data.frame(D)

for (i in 3:9){
??? D[,i] <- as.double(as.character(D[,i]))
}
D[,10] <- (D$V10 == "true")

Columns 1 and 2 are still factors and probably require some additional
processing.

Hope this helps,

Michael

On Fri, Sep 16, 2011 at 6:57 PM, Bharat Kherwa <bharatram.mnit at gmail.com>
wrote:

Hi Micheal

Thanks for the quick reply, but I tried your solution, and still
doesn't work ?(it gives error for the dimension).
"apply(as.character(data$V2),1,strsplit,",")
Error in apply(as.character(data$V2), 1, strsplit, ",") :
?dim(X) must have a positive length
"
I tried the above with all the data too: still got similar error.

I am attaching a file here whose data I need to access,

when we read the data using read.table('test'), it's read in as "data
frame" and using str(data) gives this :

str(data)

'data.frame': ? 23399 obs. of ?2 variables:
?$ V1: Factor w/ 1 level "spy,20110815": 1 1 1 1 1 1 1 1 1 1 ...
?$ V2: Factor w/ 23399 levels
"01:00:00,119.92,119.92,119.92,119.92,0,0,0.0 , ...

I need to access the individual elements of each row of V2.

Please let me know,
It's a great help,

Thanks a lot
Bharat

On Fri, Sep 16, 2011 at 3:42 PM, R. Michael Weylandt
<michael.weylandt at gmail.com> wrote:

I'd guess that the data frame could be easily converted to strings
without
loosing any information, so why don't you try something like

apply(as.character(V),1,strsplit,",")

and then coerce the columns to their appropriate types and recombine
them
into a big data frame?

If this doesn't work, I'd happily take a closer look at the problem, but
please use dput() so I can just copy it directly into my console and
make
sure I get just the right sort of thing.

Hope this helps,

Michael Weylandt

On Fri, Sep 16, 2011 at 6:18 PM, Bharat Kherwa
<bharatram.mnit at gmail.com>
wrote:

Hi Guys,

I have some daily tick data like this,
? ? ? ? ? ?V1
? ? ? ? ? ? ? ? ? ? V2
1 spy,20110815 09:30:00,119.18,119.19,119.18,119.19,0,0,0.0,false
2 spy,20110815 09:30:01,119.21,119.21,119.19,119.21,0,0,0.0,false
3 spy,20110815 09:30:02,119.22,119.27,119.21,119.27,0,0,0.0,false
4 spy,20110815 09:30:03,119.26,119.27,119.18,119.18,0,0,0.0,false
5 spy,20110815 ? ?09:30:04,119.2,119.2,119.18,119.2,0,0,0.0,false
6 spy,20110815 09:30:05,119.21,119.21,119.18,119.18,0,0,0.0,false

The structure of the data is as follows:

'data.frame': ? 23399 obs. of ?2 variables:
?$ V1: Factor w/ 1 level "spy,20110815": 1 1 1 1 1 1 1 1 1 1 ...
?$ V2: Factor w/ 23399 levels
"01:00:00,119.92,119.92,119.92,119.92,0,0,0.0,false",..: 10800 10801
10802 10803 10804 10805 10806 10807 10808 10809 ...

Now I want to access the individual elements of data[1,2] ?which is
09:30:00,119.18,119.19,119.18,119.19,0,0,0.0,false,
i.e. access 119.18 separately, and similarly for other entries in the
row...
How do I do that? I tried all combinations to access the individual
elements with no success,

Any help will be greatly appreciated.

Thanks a lot
Bharat