Database Reference
In-Depth Information
You can select a subset of features with the
-c
option. This accepts both integers and
column names:
$
csvstat data/investments2.csv -c 2,13,19,24
2. company_name
<type 'unicode'>
Nulls: True
Unique values: 27324
5 most frequent values:
Aviir: 13
Galectin Therapeutics: 12
Rostima: 12
Facebook: 11
Lending Club: 11
Max length: 66
13. investor_country_code
<type 'unicode'>
Nulls: True
Unique values: 111
5 most frequent values:
USA:
20806
GBR:
2357
DEU:
946
CAN:
893
FRA:
737
Max length: 15
19. funding_round_code
<type 'unicode'>
Nulls: True
Unique values: 15
5 most frequent values:
a:
7529
b:
4776
c:
2452
d:
1042
e:
384
Max length: 10
24. raised_amount_usd
<type 'int'>
Nulls: True
Min: 0
Max: 3200000000
Sum: 359891203117
Mean: 10370010.1748
Median: 3250000
Standard Deviation: 38513119.1802
Unique values: 6143
5 most frequent values:
10000000:
1159
1000000:
1074
5000000:
1066
2000000:
875
