Hello, What would be the best set of R functions to parse and transform a file?
My file looks as shown below. I would like to plot this data and I need to parse it into a single data frame that sorts of "transposes the data" with the following structure: > df <- data.frame(n=c(1,1,2,2),iter=c(1,2,1,2),step=as.factor(c('Step 1', > 'Step2', 'Step 1', 'Step 2')),value=c(10, 10, 10, 10)) > str(df) 'data.frame': 4 obs. of 4 variables: $ n : num 1 1 2 2 $ iter : num 1 2 1 2 $ step : Factor w/ 3 levels "Step 1","Step 2",..: 1 3 1 2 $ value: num 10 10 10 10 n=extracted from the file name "logdet_two_moons_n>>>>10<<<<.txt" iter=iter step=column Step1, Step2, Step3, Step4 value=value of the specific Step column And this is one possible data frame variation to be able to plot the time proportions for the different steps of my algorithm. TIA, Best regards, Giovanni Iteration Jmin Error Elapsed Corral Duality Gap Step1 Step2 Step3 Step4 2 2 0.000000e+00 1.912976e-03 1 0.000000e+00 1.779780e-03 7.214600e-05 1.243600e-05 2.246700e-05 ../test/genmoons_data/logdet_two_moons_n10.txt,2,2,1.754115e-02,0.000000e+00,9.799000e+03,0.000000e+00,5.586293e-01,0.000000e+00 Iteration Jmin Error Elapsed Corral Duality Gap Step1 Step2 Step3 Step4 4 9 0.000000e+00 1.280841e-03 2 -7.105427e-15 9.557570e-04 2.301610e-04 1.571100e-05 2.177300e-05 ../test/genmoons_data/logdet_two_moons_n20.txt,4,5,6.062756e-03,0.000000e+00,1.365970e+05,0.000000e+00,2.253051e+01,0.000000e+00 Iteration Jmin Error Elapsed Corral Duality Gap Step1 Step2 Step3 Step4 10 32 3.133476e-03 6.075853e-03 8 4.057531e-01 1.613035e-03 3.956920e-03 3.077200e-05 4.390900e-05 20 28 5.597685e-04 4.376530e-03 16 4.711146e-03 0.000000e+00 4.390998e-03 2.229600e-05 2.517100e-05 30 27 1.148159e-04 4.357923e-03 22 8.408166e-06 0.000000e+00 4.326610e-03 2.697700e-05 3.233200e-05 40 27 4.036778e-05 4.388260e-03 29 2.529294e-07 0.000000e+00 4.329726e-03 2.713000e-05 3.558400e-05 50 27 1.840383e-05 4.357373e-03 36 1.341111e-07 0.000000e+00 4.327526e-03 3.097000e-05 3.255700e-05 53 27 0.000000e+00 1.322382e-03 36 -2.842171e-14 0.000000e+00 1.327239e-03 1.420400e-05 2.043500e-05 ../test/genmoons_data/logdet_two_moons_n64.txt,53,69,3.330987e-02,0.000000e+00,2.229830e+07,0.000000e+00,6.694201e+02,0.000000e+00 Iteration Jmin Error Elapsed Corral Duality Gap Step1 Step2 Step3 Step4 10 70 7.739525e-03 2.389529e-02 8 1.494829e+00 2.975209e-03 1.873082e-02 4.713600e-05 5.837200e-05 20 74 3.379192e-03 2.084753e-02 15 3.372041e-01 0.000000e+00 2.084637e-02 4.302400e-05 3.907800e-05 30 76 1.322821e-03 2.093204e-02 21 1.018845e-01 0.000000e+00 2.083170e-02 4.704100e-05 5.707100e-05 40 78 1.176950e-03 2.095179e-02 28 2.447970e-02 0.000000e+00 2.088284e-02 4.890700e-05 4.955100e-05 50 78 2.233669e-04 2.050571e-02 35 1.573952e-02 0.000000e+00 2.045954e-02 4.046600e-05 3.899000e-05 60 78 2.167956e-04 2.095130e-02 39 8.362982e-03 0.000000e+00 2.082586e-02 6.699700e-05 8.506400e-05 70 78 2.085968e-04 2.085355e-02 46 5.135190e-03 0.000000e+00 2.083204e-02 5.432900e-05 4.078600e-05 80 78 2.570800e-04 2.044932e-02 51 5.470225e-04 0.000000e+00 2.033571e-02 5.334200e-05 5.318400e-05 81 78 0.000000e+00 2.099610e-03 51 1.421085e-14 0.000000e+00 2.100072e-03 9.147000e-06 2.324800e-05 [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.