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