Database Reference
In-Depth Information
5 most frequent values:
False: 2
True: 1
4. d
<type 'unicode'>
Nulls: False
Values: 2198, "Yes!", Oh, good
5. e
<type 'datetime.datetime'>
Nulls: True
Values: 2011-11-11 11:00:00, 2014-09-15 00:00:00
6. f
<type 'datetime.date'>
Nulls: True
Values: 2012-09-08, 1970-12-06
7. g
<type 'datetime.time'>
Nulls: True
Values: 12:34:00, 12:07:00
Row count: 3
This gives a very verbose output. For a more concise output specify one of the statis‐
tics options:
--max (maximum)
--min (minimum)
--sum (sum)
--mean (mean)
--median (median)
--stdev (standard deviation)
--nulls (whether column contains nulls)
--unique (unique values)
--freq (frequent values)
--len (max value length)
For example:
$ csvstat data/datatypes.csv --null
1. a: False
2. b: True
3. c: False
4. d: False
5. e: True
6. f: True
7. g: True
Search WWH ::




Custom Search