How to force field type?

[aborruso]

Hi,
I would like to filter all the records in which Population > 7

If I run qsv lua filter 'Population > 7' input.csv

I have

Lat,Lon,Population
runtime error: [string "/home/runner/.cargo/registry/src/github.com-1..."]:1: attempt to compare number with string
stack traceback:
        [C]: in metamethod 'lt'
        [string "/home/runner/.cargo/registry/src/github.com-1..."]:1: in main chun

How to force Population as floating field?

Thank you

Lat,Lon,Population
45.58152777781424,11.485138888898076,5.124174442871051
44.41486111114664,8.955138888896052,39.973810894449336
45.56347222225867,9.674861111118851,0.0
40.52763888892131,15.484027777790164,0.0
45.70597222225879,13.730138888899873,1.9245413451891165
44.382361111146615,9.068750000007254,7.407975662240021
41.01041666669947,17.137083333347043,0.12304682357805649
44.43291666670221,9.022361111118329,2.6499046002286604
44.383750000035505,9.069027777785033,7.407975662240021

[jqnatividad]

Hi @aborruso ,

You have access to all of Lua's functions with qsv.

So for your issue, you can just call tonumber() to convert Population.

$ qsv lua filter 'tonumber(Population) > 7' input.csv
[00:00:00] [========================= 100% of 9 records] (5,642/sec)
Lat,Lon,Population
44.41486111114664,8.955138888896052,39.973810894449336
44.382361111146615,9.068750000007254,7.407975662240021
44.383750000035505,9.069027777785033,7.407975662240021

There are more advanced examples of the qsv lua command here.