search for: entim

Hi, Newbie alert on for loops... I have a bunch of data.frames built using rbind that have repeated values in the EnTime column. I want to read the value in the EnTime column and use it as an input to a function, but only down to the first occurrence of the string "(all)" where I want to break off and do other things. From the results I'm getting from some test code I clearly don't understand how t...

...ewhere sensible and change the first line in the code to point at it. The R code I'm having trouble with is this: Y = read.table("C:\\test.txt") names(Y)[7] = "value" Y ReShape.Y = reshape(Y, varying=list(names(Y)[7]), direction='long') ReShape.Y cast(ReShape.Y, EnTime ~ ExTime) When run the last two steps output the following: > ReShape.Y Trade PosType EnDate EnTime ExDate ExTime time value id 1 1 -1 1080103 800 1080103 1310 1 520 1 2 2 -1 1080104 755 1080104 1310 1 530 2 3 3 1 1080107 945 10...

Hi, What is cast telling me when it says the following? Aggregation requires fun.aggregate: length used as default What is 'length'? I've taken a small subset of data and wondered what EnTime vs ExTime might look like. cast is kind enough to give me a table but I don't understand the values in the table. They seem to sum up ro be the same as the total dimension of the data so I'm guessing (but cannot prove) that it's something like whether each experiment has values for bot...

...es. In most cases the data.frames look more or less like the example below - Experiment Start time down the left side, Experiment Completion time across the top and results in the cells. The following data started at 830 and is 3 minute data so the first measurement came at 833, then 836, etc. EnTime 836 842 845 848 851 854 900 903 1 833 -386 0 -772 -938 -772 0 -386 2 836 0 -386 0 0 0 -246 714 -632 3 839 0 0 0 0 -386 0 0 -772 4 842 0 0 -386 0 0 0 -682 0 5 845 0 0 0 0 0 0...

I have a data.frame that was built from a number of smaller data.frames with rbind. Each ssmaller data.frame bound together runs over the same date ranges. The format of the whole thing looks like this: Trade PosType EnDate EnTime ExDate ExTime PL_Pos 1 1 1 1040107 915 1040107 1300 164 2 2 1 1040108 909 1040108 1300 184 3 3 1 1040115 921 1040115 1300 64 4 4 1 1040120 1134 1040120 1300 124 5 5 1 1040121 923 1040121 1300...

...that? Or is some case where I need to use maybe as.numeric or something else first to ensure R sees the number the way I'm thinking about the number? Cheers, Mark > dim(X) [1] 25 425 > > ReShapeX <- melt(X, id = c("Trade", "PosType", "EnDate", "EnTime", "ExDate", "ExTime", "PL_Pos", "Costs", "Save2")) > > dim(ReShapeX) [1] 10400 11 > > MyResults <- subset(ReShapeX, value > 0) > > dim(MyResults) [1] 1105 11 > > MyResults.GroupA <- subset(MyResults, Pos...

...;2020-01-03" "2020-01-06" "2020-01-07" "2020-01-08" "2020-01-09" "2020-01-10" "2020-01-13" "2020-01-14" "2020-01-15" "2020-01-16" [12] "2020-01-17" > > > MyDate2 Trade PosType EnDate EnTime ExDate ExTime 1 1 -1 1040127 919 1040127 932 2 2 1 1040127 1155 1040127 1208 3 3 -1 1040127 1300 1040127 1313 4 4 -1 1040128 958 1040128 1313 5 5 -1 1040129 1024 1040129 1129 6 6 1 1040129 1234 1040129 1313 7 7...

...081241t734c2ca1ye595821a75b9ddc8@mail.gmail..com> Content-Type: text/plain; charset=UTF-8 Hi,    What is cast telling me when it says the following? Aggregation requires fun.aggregate: length used as default What is 'length'?    I've taken a small subset of data and wondered what EnTime vs ExTime might look like. cast is kind enough to give me a table but I don't understand the values in the table. They seem to sum up ro be the same as the total dimension of the data so I'm guessing (but cannot prove) that it's something like whether each experiment has values for bot...