CSV data manipulation: Difference between revisions
Content added Content deleted
Line 2,723: | Line 2,723: | ||
<lang Nanoquery>def sum(record) |
<lang Nanoquery>def sum(record) |
||
sum = 0 |
sum = 0 |
||
for i in range(1, len(record) - 1) |
for i in range(1, len(record) - 1) |
||
sum = sum + int(record ~ i) |
sum = sum + int(record ~ i) |
||
end for |
end for |
||
return sum |
return sum |
||
end def |
end def |
||
open "file.csv" |
open "file.csv" |
||
add "SUM" |
add "SUM" |
||
for i in range($dbsize, 1) |
for i in range($dbsize, 1) |
||
(i ~ @"SUM") = sum(#i) |
(i ~ @"SUM") = sum(#i) |
||
end for |
end for |
||
write</lang> |
write</lang> |
||