xsv icon indicating copy to clipboard operation
xsv copied to clipboard

`sample` command with alternative delimiter: Could not deserialize to u64 for '<sample-size>'.

Open elena opened this issue 5 months ago • 1 comments

Trying to get a sample with pipe delimiter rather than comma.

example.psv

a|b|c|d
1|2|3|4
5|6|7|8

count as expected 👍

 $ xsv count -d"|" example.psv
2

headers as expected 👍

$ xsv headers -d"|" example.psv
1   a
2   b
3   c
4   d

sample 😭

$ xsv sample -d"|" example.psv 
Could not deserialize 'example.psv' to u64 for '<sample-size>'.

💟

elena avatar Feb 13 '24 01:02 elena

Additional:

frequency 👍

$ xsv frequency -d"|" example.psv
field,value,count
a,5,1
a,1,1
b,2,1
b,6,1
c,7,1
c,3,1
d,8,1
d,4,1

search 👍

$ xsv search -d"|" -s a '1' example.psv
a,b,c,d
1,2,3,4

select 👍

$ xsv select -d"|" a example.psv 
a
1
5

stats 👍

$ xsv stats -d"|" example.psv 
field,type,sum,min,max,min_length,max_length,mean,stddev
a,Integer,6,1,5,1,1,3,2
b,Integer,8,2,6,1,1,4,2
c,Integer,10,3,7,1,1,5,2
d,Integer,12,4,8,1,1,6,2

elena avatar Feb 13 '24 01:02 elena

@Elena , you need to specify sample size:

$ xsv sample 1 -d"|" example.psv 

jqnatividad avatar Mar 20 '24 01:03 jqnatividad