Extract Data

Submit

Your name:
File:
Open code-statistics:

Language is selected by the extension of the file. See the list of supported languages to know the extension of your language.

Problem

Extract required columns below "[Data]", and delete comments

Options

exec is denied

rejudge feature is enabled

now post-mortem time, all source codes will be revealed

Sample input:_

[Header]
TITLE,xxxxxxxx.dat
BYAPP,HeatCapacity,3.8.14,1.7
INFO,2.29,MASS:Sample Mass (mg)
INFO,,MASSERR:Sample Mass Error (mg)
INFO,205.58068,MOLWGHT:Formula Weight (g/mole)
INFO,7,ATOMS:Atoms per Formula Unit
INFO, Heat Capacity Option 3.8.15 Build 20,APPNAME
DATATYPE,TIME,1
DATATYPE,COMMENT,2
STARTUPAXIS, X, 8, LINEAR, AUTO
STARTUPAXIS, Y1, 10, LINEAR, AUTO
[Data]
Time Stamp (Seconds),Comment (),Puck Temp (Kelvin),System Temp (Kelvin),Sample Temp (Kelvin),Temp Rise (Kelvin),Samp HC (J/mole-K),Samp HC Err (J/mole-K),Addenda HC (uJ/K),Addenda HC Err (uJ/K)
41022684.31,CALFILE: Puck155_1.cal - Addenda #55 measured on 4/19/2017 from 1.8938 to 302.78 K
41022684.5,,300.013,299.45,302.94831,6.228222,124.32831,0.85,8872.3999,4.515
41022942.84,,300.066,299.351,302.70334,5.6470045,123.05087,0.8188,8867.6331,4.515
41023239.73,,300.00,299.29,302.69056,5.6587493,122.93617,0.8097,8867.4288,4.515
41093600.2,CALFILE: Puck155_1.cal - Addenda #56 measured on 4/19/2017 from 1.8945 to 6.97 K
41093600.45,,6.94183,7.7466,6.9761565,0.13381095,0.037976428,0.0009166,3.4680269,0.005055
41093626.0,,6.94341,7.7485,6.9772032,0.13338808,0.037621912,0.001014,3.4693201,0.005057
41093651.75,,6.944,7.7512,6.9778851,0.13327843,0.037876781,0.0009362,3.4701983,0.005059
41094250.64,,6.69529,7.3013,6.7421403,0.1326991,0.03380048,0.0008134,3.1694344,0.004567
41094277.06,,6.68978,7.2966,6.7338561,0.12852694,0.033751509,0.0007938,3.1593382,0.004551

Sample output:

Sample Temp (Kelvin),Samp HC (J/mole-K)
302.94831,124.32831
302.70334,123.05087
302.69056,122.93617
6.9761565,0.037976428
6.9772032,0.037621912
6.9778851,0.037876781
6.7421403,0.03380048
6.7338561,0.033751509

Sample input:_

[Header]
TITLE,yyyyyyyyyyy.dat
INFO,2.58,MASS:Sample Mass (mg)
INFO,,MASSERR:Sample Mass Error (mg)
INFO,255.29068,MOLWGHT:Formula Weight (g/mole)
INFO,7,ATOMS:Atoms per Formula Unit
DATATYPE,COMMENT,2
STARTUPAXIS, X, 8, LINEAR, AUTO
STARTUPAXIS, Y1, 10, LINEAR, AUTO
[Data]
Comment (),Puck Temp (Kelvin),Pressure (Torr),Sample Temp (Kelvin),Samp HC (J/mole-K),Samp HC Err (J/mole-K),Temp Squared (K^2),Samp HC/Temp (J/mole-K/K)
CALFILE: Puck169_1.cal - Addenda #37 measured on 2/8/2017 from 1.8932 to 397.37 K
,393.622,8.2E-3,397.37221,147.20678,1.065,157904.67,0.37045062
,393.68,9.3E-5,397.00524,144.97739,1.038,157613.16,0.36517753
,393.704,7.3E-7,397.05589,144.48117,1.061,157653.38,0.36388119
,353.885,4.4E-5,356.95886,136.11093,1.142,127419.63,0.3813070
,353.711,9.3E-6,356.68257,137.4826,0.8619,127222.45,0.38544804
,353.695,5.3E-6,356.62833,137.97602,0.8182,127183.7,0.38689023
,141.476,5.4E-5,142.78077,70.334446,0.3937,20386.348,0.49260448
,141.474,7.3E-5,142.78077,71.286791,0.4152,20387.562,0.49925959
,129.053,7.4E-5,130.34843,62.203934,0.571,16990.712,0.47721277
,128.801,8.6E-5,130.00725,64.007386,0.382,16901.886,0.49233704
,128.776,2.9E-6,129.95932,65.026341,0.3636,16889.426,0.50035918
,127.877,1.4E-4,129.15246,64.822317,0.364,16680.357,0.50190542
CALFILE: Puck169_1.cal - Addenda #37 measured on 2/8/2017 from 1.8932 to 6.97 K

Sample output:

Sample Temp (Kelvin),Samp HC (J/mole-K)
397.37221,147.20678
397.00524,144.97739
397.05589,144.48117
356.95886,136.11093
356.68257,137.4826
356.62833,137.97602
142.78077,70.334446
142.78077,71.286791
130.34843,62.203934
130.00725,64.007386
129.95932,65.026341
129.15246,64.822317

Sample input:_

[Header]
TITLE,zzzzzzzzzzzz.dat
BYAPP,HeatCapacity,3.8.14,1.7
INFO,1.74,MASS:Sample Mass (mg)
INFO,254.29648,MOLWGHT:Formula Weight (g/mole)
INFO,8,ATOMS:Atoms per Formula Unit
INFO,Option 3.8.14 Build 16,APPNAME
DATATYPE,TIME,1
DATATYPE,COMMENT,2
STARTUPAXIS, X, 8, LINEAR, AUTO
STARTUPAXIS, Y1, 10, LINEAR, AUTO
[Data]
Time Stamp (Seconds),Comment (),Field (Oersted),Pressure (Torr),Sample Temp (Kelvin),Temp Rise (Kelvin),Samp HC (mJ/mole-K),Time Const tau1 (seconds),Debye Temp (Kelvin),Temp Squared (K^2),Samp HC/Temp (mJ/mole-K/K)
3612663.97,CALFILE: Puck162_1.cal - Addenda #9 measured on 1/28/2016 from 1.9154 to 399.43 K
3612664.23,,0.086,9.30E-06,398.98706,6.8782791,144617.68,35.104263,790.46281,159190.67,362.46208
3612863.86,,0.086,9.30E-06,399.0596,6.8894681,144613.32,34.908293,790.67241,159248.56,362.38526
3613062.63,,0.086,9.30E-06,399.07885,6.8728909,144585.87,34.940504,791.12507,159263.93,362.299
3613635.97,,0.086,9.30E-06,395.3714,6.6874922,138070.28,33.349255,878.74405,156318.55,349.21665
3613861.63,,0.086,9.20E-06,394.51087,6.5755213,141304.54,34.657869,830.36186,155638.83,358.17653
3614094.73,,0.086,9.40E-06,394.22554,6.7417205,142458.09,35.399882,812.94636,155413.78,361.3619
3614673.13,,0.086,9.40E-06,390.31951,6.6136179,137161.34,33.961437,880.27148,152349.32,351.40784
3614901.55,,0.086,9.30E-06,389.46633,6.5219009,140455.08,35.308285,831.88956,151684.02,360.63471
3615101.22,CALFILE: Puck162_1.cal - Addenda #9 measured on 1/28/2016 from 1.9154 to 10.243 K
3615139.44,,0.086,9.40E-06,389.18447,6.6900289,141608.76,36.067504,814.78606,151464.55,363.86026
3615718.16,,0.086,9.30E-06,385.2689,6.5564621,136214.09,34.488795,881.93604,148432.13,353.55588
3615950.17,,0.086,9.40E-06,384.38718,6.4486931,139604.61,35.898774,832.97127,147753.51,363.18747
3616191.38,,0.086,9.30E-06,384.10654,6.6224835,140829.46,36.7088,815.17103,147537.83,366.64165
3616806.94,,0.086,9.10E-06,380.03346,6.5085573,136022.73,35.326231,872.54508,144425.43,357.92305
3617045.05,,0.086,9.30E-06,379.24133,6.4121752,139010.09,36.633728,830.00947,143823.98,366.54785
3617291.31,,0.086,9.40E-06,378.99289,6.5661382,140235.23,37.42106,812.56585,143635.61,370.02075
3617912.33,,0.086,9.30E-06,374.96761,6.4477408,135108.46,35.845065,873.10852,140600.71,360.32034
3618152.11,,0.086,9.40E-06,374.17086,6.3341126,138289.19,37.207783,828.66956,140003.83,369.58835
3618400.42,,0.086,9.20E-06,373.92534,6.4905575,139483.98,38.012735,811.94111,139820.16,373.02629

Sample output:

Sample Temp (Kelvin),Samp HC (mJ/mole-K)
398.98706,144617.68
399.0596,144613.32
399.07885,144585.87
395.3714,138070.28
394.51087,141304.54
394.22554,142458.09
390.31951,137161.34
389.46633,140455.08
389.18447,141608.76
385.2689,136214.09
384.38718,139604.61
384.10654,140829.46
380.03346,136022.73
379.24133,139010.09
378.99289,140235.23
374.96761,135108.46
374.17086,138289.19
373.92534,139483.98

Ranking

Ruby _

RankUserSizeTimeDateStatistics
1mitchs460.04002017/04/24 08:26:050B / 22B / 22B
2rotary-o480.03592017/04/24 01:38:340B / 26B / 20B

Ruby2 _

RankUserSizeTimeDateStatistics
1mitchs450.23222017/04/24 08:34:190B / 22B / 21B
2rotary-o470.21792017/04/24 01:38:230B / 26B / 19B

Perl _

RankUserSizeTimeDateStatistics
1tails460.03822017/04/25 16:57:330B / 17B / 26B

Python _

RankUserSizeTimeDateStatistics
1mitchs710.09192017/04/24 00:05:060B / 38B / 26B
2rolf860.09502017/04/23 22:39:120B / 39B / 45B
3twobit740.09022017/05/09 19:43:050B / 40B / 28B

Python3 _

RankUserSizeTimeDateStatistics
1mitchs650.19612017/04/24 21:28:190B / 36B / 27B

JavaScript _

RankUserSizeTimeDateStatistics
1ETHproductions1250.05632017/04/27 01:38:300B / 66B / 57B

C _

RankUserSizeTimeDateStatistics
1tails970.03662017/04/26 18:06:160B / 44B / 53B

Haskell _

RankUserSizeTimeDateStatistics
1vlad.a1900.04132017/04/27 22:14:240B / ?B / ?B

Java _

RankUserSizeTimeDateStatistics
1rotary-o1711.05062017/04/25 22:01:460B / 107B / 58B

AWK _

RankUserSizeTimeDateStatistics
1mitchs310.03192017/04/23 14:03:090B / 13B / 18B
2llhuii310.03172017/04/23 15:56:210B / 13B / 18B
3olf760.03302017/04/23 21:13:080B / 29B / 46B

sed _

RankUserSizeTimeDateStatistics
1tails540.03862017/04/25 15:58:460B / 9B / 41B

Bash (builtins) _

RankUserSizeTimeDateStatistics
1tails500.11512017/04/25 15:46:150B / 21B / 21B
2llhuii510.09302017/04/28 00:38:540B / 23B / 23B

GolfScript _

RankUserSizeTimeDateStatistics
1mitchs330.11242017/04/24 01:27:560B / 8B / 25B
2tails330.15392017/04/25 22:02:480B / 5B / 28B
3mitchs (tails)320.14972017/04/30 02:35:500B / 8B / 24B

gs2 _

RankUserSizeTimeDateStatistics
1whio190.28242017/04/26 23:40:1910B / 5B / 4B
2mitchs190.29872017/04/28 15:45:4610B / 5B / 4B
3tails200.26432017/04/25 19:19:028B / 4B / 7B

goruby _

RankUserSizeTimeDateStatistics
1mitchs390.08882017/04/25 07:59:530B / 16B / 22B
2mitchs (rotary-o)370.09402017/04/30 02:12:240B / 16B / 20B

Scala _

RankUserSizeTimeDateStatistics
1rotary-o847.68292017/04/23 13:13:500B / 51B / 28B

Language Ranking_

RankLangUserSizeScore
1gs2whio1910000
2AWKmitchs316129
3GolfScriptmitchs (tails)325937
4gorubymitchs (rotary-o)375135
5Ruby2mitchs454222
6Rubymitchs464130
7Perltails464130
8Bash (builtins)tails503800
9sedtails543518
10Python3mitchs652923
11Pythonmitchs712676
12Scalarotary-o842261
13Ctails971958
14JavaScriptETHproductions1251520
15Javarotary-o1711111
16Haskellvlad.a1901000

return top