fork download 
  1. BEGIN {
  2.     start_time = mktime("2001 01 01 0 0 0")
  3.     end_time = mktime("2001 01 01 3 0 0")
  4.     interval = 10 * 60
  5.     FS = OFS = " "
  6. }
  7. {
  8.     current_time = $1 " " $2
  9.     current_timestamp = mktime(gensub("/", " ", "g", $1) " " gensub(":", " ", "g", $2) " 0")
  10.     while (start_time < current_timestamp) {
  11.         print strftime("%Y", start_time) "/" strftime("%m", start_time) + 0 "/" strftime("%d", start_time) + 0, strftime("%H", start_time) + 0 ":" strftime("%M", start_time), "nan"
  12.         start_time += interval
  13.     }
  14.     print $0
  15.     start_time += interval
  16. }
  17. END {
  18.     while (start_time <= end_time) {
  19.         print strftime("%Y", start_time) "/" strftime("%m", start_time) + 0 "/" strftime("%d", start_time) + 0, strftime("%H", start_time) + 0 ":" strftime("%M", start_time), "nan"
  20.         start_time += interval
  21.     }
  22. }
Success #stdin #stdout 0.01s 5300KB
comments (?)
stdin 
2001/1/1 0:00 3
2001/1/1 0:10 32
2001/1/1 0:40 17
2001/1/1 0:50 4.402
2001/1/1 1:00 3.95
2001/1/1 1:50 1.42
2001/1/1 2:00 0.34
2001/1/1 2:10 0
2001/1/1 2:20 9
2001/1/1 2:30 57
stdout 
2001/1/1 0:00 3
2001/1/1 0:10 32
2001/1/1 0:20 nan
2001/1/1 0:30 nan
2001/1/1 0:40 17
2001/1/1 0:50 4.402
2001/1/1 1:00 3.95
2001/1/1 1:10 nan
2001/1/1 1:20 nan
2001/1/1 1:30 nan
2001/1/1 1:40 nan
2001/1/1 1:50 1.42
2001/1/1 2:00 0.34
2001/1/1 2:10 0
2001/1/1 2:20 9
2001/1/1 2:30 57
2001/1/1 2:40 nan
2001/1/1 2:50 nan
2001/1/1 3:00 nan
https://ideone.com/NvZAME
language:
AWK (gawk 4.2.1)
created:
1 year ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!