Skip to content

Instantly share code, notes, and snippets.

@brianmhess
Last active March 21, 2019 14:30
Show Gist options
  • Save brianmhess/8864cf0cb0ce9ea1fd64e579e9f41100 to your computer and use it in GitHub Desktop.
Save brianmhess/8864cf0cb0ce9ea1fd64e579e9f41100 to your computer and use it in GitHub Desktop.
Data Samples
Here are some data samples for demonstrating loading.
CQL for tables:
cqlsh -e "CREATE KEYSPACE dsbulkblog WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};"
cqlsh -e "CREATE TABLE dsbulkblog.iris_with_id (id int PRIMARY KEY, petal_length double, petal_width double, sepal_length double, sepal_width double, species text)"
cqlsh -e "CREATE TABLE dsbulkblog.categories_set(category TEXT PRIMARY KEY, examples SET<TEXT>);"
cqlsh -e "CREATE TABLE dsbulkblog.categories_list(category TEXT PRIMARY KEY, examples LIST<TEXT>);"
cqlsh -e "CREATE TABLE dsbulkblog.president_birthdates(president TEXT PRIMARY KEY, birthdate_string TEXT, birthdate DATE);"
Examples:
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id
cat /tmp/dsbulkblog/iris.csv | dsbulk load -k dsbulkblog -t iris_with_id
cat /tmp/dsbulkblog/iris.csv | sed 's/Iris-//g' | dsbulk load -k dsbulkblog -t iris_with_id
dsbulk load -k dsbulkblog -t iris_with_id -url https://gist.github.com/brianmhess/8864cf0cb0ce9ea1fd64e579e9f41100/raw/522a1f564a381d7eacf6955c490bb6331d4369b2/iris.csv
dsbulk load -url /tmp/dsbulkblog/iris -k dsbulkblog -t iris_with_id
dsbulk load -url /tmp/dsbulkblog/iris -k dsbulkblog -t iris_with_id --connector.csv.fileNamePattern "**/*.csv"
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id -m "sepal_length = sepal_length, sepal_width = sepal_width, petal_length = petal_length, petal_width = petal_width, species = species, id = id"
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id -m "sepal_length,sepal_width,petal_length,petal_width,species,id"
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id -m "sepal_length,sepal_width,petal_length,petal_width,species,id" -header false -skipRecords 101
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id -maxRecords 20
dsbulk load -url /tmp/dsbulkblog/iris_no_header.csv -k dsbulkblog -t iris_with_id -header false -m "0=sepal_length, 1=sepal_width, 2=petal_length, 3=petal_width, 4=species, 5=id"
dsbulk load -url /tmp/dsbulkblog/iris.csv -query "INSERT INTO dsbulkblog.iris_with_id(id,petal_width,petal_length,sepal_width,sepal_length,species) VALUES (:id, :petal_width, :petal_length, :sepal_width, :sepal_length, :species)"
dsbulk load -url /tmp/dsbulkblog/iris_with_comment.csv -k dsbulkblog -t iris_with_id -comment "#"
dsbulk load -url /tmp/dsbulkblog/iris_with_nulls.csv -k dsbulkblog -t iris_with_id -nullStrings '[""]'
dsbulk load -url /tmp/dsbulkblog/iris_with_null_string.csv -k dsbulkblog -t iris_with_id -nullStrings "NULL"
dsbulk load -url /tmp/dsbulkblog/iris_with_null_string.csv -k dsbulkblog -t iris_with_id -nullStrings "NULL" --schema.nullToUnset false
dsbulk load -url /tmp/dsbulkblog/president_birthdates.psv -k dsbulkblog -t president_birthdates -delim "|"
dsbulk load -url /tmp/dsbulkblog/president_birthdates.psv -k dsbulkblog -t president_birthdates -delim "|" --codec.date "y.M.d"
dsbulk load -url /tmp/dsbulkblog/president_birthdates.psv -delim "|" -query "INSERT INTO dsbulkblog.president_birthdates(president,birthdate,birthdate_string) VALUES (:president, CurrentDate(), :birthdate_string)"
dsbulk load -url /tmp/dsbulkblog/sportsteams.csv -k dsbulkblog -t categories_list
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id --schema.queryTtl 3600
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id --schema.queryTimestamp "2018-01-01T12:34:56"
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id -dryRun true
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id --executor.maxPerSecond 10
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id --executor.maxInFlight 3
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id -h 127.0.0.1
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id -h 127.0.0.1 -port 9042
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id -u cassandra -p cassandra
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id -cl LOCAL_QUORUM
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id --log.maxErrors 3
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id -logDir /tmp/logs
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id -reportRate 10
dsbulk load -url /tmp/dsbulkblog/iris.csv -k dsbulkblog -t iris_with_id --monitoring.jmx false
dsbulk unload -url /tmp/unload -k dsbulkblog -t iris_with_id
dsbulk unload -url /tmp/unload -k dsbulkblog -t iris_with_id --connector.csv.fileNameFormat "iris-%0,6d.csv" --connector.csv.fileNameFormat "iris-%0,6d.csv"
dsbulk unload -k dsbulkblog -t iris_with_id
dsbulk unload -k dsbulkblog -t iris_with_id -m "id,species"
dsbulk unload -query "SELECT id, species FROM dsbulkblog.iris_with_id"
dsbulk unload -query "SELECT id, species, writetime(species) AS writetime FROM dsbulkblog.iris_with_id"
dsbulk unload -query "SELECT id, species FROM dsbulkblog.iris_with_id WHERE id IN (101,102,103,104,105)"
dsbulk unload -k dsbulkblog -t iris_with_id -delim "\t"
dsbulk unload -k dsbulkblog -t iris_with_id -nullStrings "N/A"
dsbulk unload -k dsbulkblog -t president_birthdates -delim "\t" --codec.date "EEEE MMMM d, y GGGG"
sepal_length sepal_width petal_length petal_width species id
5.1 3.5 1.4 0.2 Iris-setosa 0
4.9 3.0 1.4 0.2 Iris-setosa 1
4.7 3.2 1.3 0.2 Iris-setosa 2
4.6 3.1 1.5 0.2 Iris-setosa 3
5.0 3.6 1.4 0.2 Iris-setosa 4
5.4 3.9 1.7 0.4 Iris-setosa 5
4.6 3.4 1.4 0.3 Iris-setosa 6
5.0 3.4 1.5 0.2 Iris-setosa 7
4.4 2.9 1.4 0.2 Iris-setosa 8
4.9 3.1 1.5 0.1 Iris-setosa 9
5.4 3.7 1.5 0.2 Iris-setosa 10
4.8 3.4 1.6 0.2 Iris-setosa 11
4.8 3.0 1.4 0.1 Iris-setosa 12
4.3 3.0 1.1 0.1 Iris-setosa 13
5.8 4.0 1.2 0.2 Iris-setosa 14
5.7 4.4 1.5 0.4 Iris-setosa 15
5.4 3.9 1.3 0.4 Iris-setosa 16
5.1 3.5 1.4 0.3 Iris-setosa 17
5.7 3.8 1.7 0.3 Iris-setosa 18
5.1 3.8 1.5 0.3 Iris-setosa 19
5.4 3.4 1.7 0.2 Iris-setosa 20
5.1 3.7 1.5 0.4 Iris-setosa 21
4.6 3.6 1.0 0.2 Iris-setosa 22
5.1 3.3 1.7 0.5 Iris-setosa 23
4.8 3.4 1.9 0.2 Iris-setosa 24
5.0 3.0 1.6 0.2 Iris-setosa 25
5.0 3.4 1.6 0.4 Iris-setosa 26
5.2 3.5 1.5 0.2 Iris-setosa 27
5.2 3.4 1.4 0.2 Iris-setosa 28
4.7 3.2 1.6 0.2 Iris-setosa 29
4.8 3.1 1.6 0.2 Iris-setosa 30
5.4 3.4 1.5 0.4 Iris-setosa 31
5.2 4.1 1.5 0.1 Iris-setosa 32
5.5 4.2 1.4 0.2 Iris-setosa 33
4.9 3.1 1.5 0.2 Iris-setosa 34
5.0 3.2 1.2 0.2 Iris-setosa 35
5.5 3.5 1.3 0.2 Iris-setosa 36
4.9 3.6 1.4 0.1 Iris-setosa 37
4.4 3.0 1.3 0.2 Iris-setosa 38
5.1 3.4 1.5 0.2 Iris-setosa 39
5.0 3.5 1.3 0.3 Iris-setosa 40
4.5 2.3 1.3 0.3 Iris-setosa 41
4.4 3.2 1.3 0.2 Iris-setosa 42
5.0 3.5 1.6 0.6 Iris-setosa 43
5.1 3.8 1.9 0.4 Iris-setosa 44
4.8 3.0 1.4 0.3 Iris-setosa 45
5.1 3.8 1.6 0.2 Iris-setosa 46
4.6 3.2 1.4 0.2 Iris-setosa 47
5.3 3.7 1.5 0.2 Iris-setosa 48
5.0 3.3 1.4 0.2 Iris-setosa 49
7.0 3.2 4.7 1.4 Iris-versicolor 50
6.4 3.2 4.5 1.5 Iris-versicolor 51
6.9 3.1 4.9 1.5 Iris-versicolor 52
5.5 2.3 4.0 1.3 Iris-versicolor 53
6.5 2.8 4.6 1.5 Iris-versicolor 54
5.7 2.8 4.5 1.3 Iris-versicolor 55
6.3 3.3 4.7 1.6 Iris-versicolor 56
4.9 2.4 3.3 1.0 Iris-versicolor 57
6.6 2.9 4.6 1.3 Iris-versicolor 58
5.2 2.7 3.9 1.4 Iris-versicolor 59
5.0 2.0 3.5 1.0 Iris-versicolor 60
5.9 3.0 4.2 1.5 Iris-versicolor 61
6.0 2.2 4.0 1.0 Iris-versicolor 62
6.1 2.9 4.7 1.4 Iris-versicolor 63
5.6 2.9 3.6 1.3 Iris-versicolor 64
6.7 3.1 4.4 1.4 Iris-versicolor 65
5.6 3.0 4.5 1.5 Iris-versicolor 66
5.8 2.7 4.1 1.0 Iris-versicolor 67
6.2 2.2 4.5 1.5 Iris-versicolor 68
5.6 2.5 3.9 1.1 Iris-versicolor 69
5.9 3.2 4.8 1.8 Iris-versicolor 70
6.1 2.8 4.0 1.3 Iris-versicolor 71
6.3 2.5 4.9 1.5 Iris-versicolor 72
6.1 2.8 4.7 1.2 Iris-versicolor 73
6.4 2.9 4.3 1.3 Iris-versicolor 74
6.6 3.0 4.4 1.4 Iris-versicolor 75
6.8 2.8 4.8 1.4 Iris-versicolor 76
6.7 3.0 5.0 1.7 Iris-versicolor 77
6.0 2.9 4.5 1.5 Iris-versicolor 78
5.7 2.6 3.5 1.0 Iris-versicolor 79
5.5 2.4 3.8 1.1 Iris-versicolor 80
5.5 2.4 3.7 1.0 Iris-versicolor 81
5.8 2.7 3.9 1.2 Iris-versicolor 82
6.0 2.7 5.1 1.6 Iris-versicolor 83
5.4 3.0 4.5 1.5 Iris-versicolor 84
6.0 3.4 4.5 1.6 Iris-versicolor 85
6.7 3.1 4.7 1.5 Iris-versicolor 86
6.3 2.3 4.4 1.3 Iris-versicolor 87
5.6 3.0 4.1 1.3 Iris-versicolor 88
5.5 2.5 4.0 1.3 Iris-versicolor 89
5.5 2.6 4.4 1.2 Iris-versicolor 90
6.1 3.0 4.6 1.4 Iris-versicolor 91
5.8 2.6 4.0 1.2 Iris-versicolor 92
5.0 2.3 3.3 1.0 Iris-versicolor 93
5.6 2.7 4.2 1.3 Iris-versicolor 94
5.7 3.0 4.2 1.2 Iris-versicolor 95
5.7 2.9 4.2 1.3 Iris-versicolor 96
6.2 2.9 4.3 1.3 Iris-versicolor 97
5.1 2.5 3.0 1.1 Iris-versicolor 98
5.7 2.8 4.1 1.3 Iris-versicolor 99
6.3 3.3 6.0 2.5 Iris-virginica 100
5.8 2.7 5.1 1.9 Iris-virginica 101
7.1 3.0 5.9 2.1 Iris-virginica 102
6.3 2.9 5.6 1.8 Iris-virginica 103
6.5 3.0 5.8 2.2 Iris-virginica 104
7.6 3.0 6.6 2.1 Iris-virginica 105
4.9 2.5 4.5 1.7 Iris-virginica 106
7.3 2.9 6.3 1.8 Iris-virginica 107
6.7 2.5 5.8 1.8 Iris-virginica 108
7.2 3.6 6.1 2.5 Iris-virginica 109
6.5 3.2 5.1 2.0 Iris-virginica 110
6.4 2.7 5.3 1.9 Iris-virginica 111
6.8 3.0 5.5 2.1 Iris-virginica 112
5.7 2.5 5.0 2.0 Iris-virginica 113
5.8 2.8 5.1 2.4 Iris-virginica 114
6.4 3.2 5.3 2.3 Iris-virginica 115
6.5 3.0 5.5 1.8 Iris-virginica 116
7.7 3.8 6.7 2.2 Iris-virginica 117
7.7 2.6 6.9 2.3 Iris-virginica 118
6.0 2.2 5.0 1.5 Iris-virginica 119
6.9 3.2 5.7 2.3 Iris-virginica 120
5.6 2.8 4.9 2.0 Iris-virginica 121
7.7 2.8 6.7 2.0 Iris-virginica 122
6.3 2.7 4.9 1.8 Iris-virginica 123
6.7 3.3 5.7 2.1 Iris-virginica 124
7.2 3.2 6.0 1.8 Iris-virginica 125
6.2 2.8 4.8 1.8 Iris-virginica 126
6.1 3.0 4.9 1.8 Iris-virginica 127
6.4 2.8 5.6 2.1 Iris-virginica 128
7.2 3.0 5.8 1.6 Iris-virginica 129
7.4 2.8 6.1 1.9 Iris-virginica 130
7.9 3.8 6.4 2.0 Iris-virginica 131
6.4 2.8 5.6 2.2 Iris-virginica 132
6.3 2.8 5.1 1.5 Iris-virginica 133
6.1 2.6 5.6 1.4 Iris-virginica 134
7.7 3.0 6.1 2.3 Iris-virginica 135
6.3 3.4 5.6 2.4 Iris-virginica 136
6.4 3.1 5.5 1.8 Iris-virginica 137
6.0 3.0 4.8 1.8 Iris-virginica 138
6.9 3.1 5.4 2.1 Iris-virginica 139
6.7 3.1 5.6 2.4 Iris-virginica 140
6.9 3.1 5.1 2.3 Iris-virginica 141
5.8 2.7 5.1 1.9 Iris-virginica 142
6.8 3.2 5.9 2.3 Iris-virginica 143
6.7 3.3 5.7 2.5 Iris-virginica 144
6.7 3.0 5.2 2.3 Iris-virginica 145
6.3 2.5 5.0 1.9 Iris-virginica 146
6.5 3.0 5.2 2.0 Iris-virginica 147
6.2 3.4 5.4 2.3 Iris-virginica 148
5.9 3.0 5.1 1.8 Iris-virginica 149
5.1 3.5 1.4 0.2 Iris-setosa 0
4.9 3.0 1.4 0.2 Iris-setosa 1
4.7 3.2 1.3 0.2 Iris-setosa 2
4.6 3.1 1.5 0.2 Iris-setosa 3
5.0 3.6 1.4 0.2 Iris-setosa 4
5.4 3.9 1.7 0.4 Iris-setosa 5
4.6 3.4 1.4 0.3 Iris-setosa 6
5.0 3.4 1.5 0.2 Iris-setosa 7
4.4 2.9 1.4 0.2 Iris-setosa 8
4.9 3.1 1.5 0.1 Iris-setosa 9
5.4 3.7 1.5 0.2 Iris-setosa 10
4.8 3.4 1.6 0.2 Iris-setosa 11
4.8 3.0 1.4 0.1 Iris-setosa 12
4.3 3.0 1.1 0.1 Iris-setosa 13
5.8 4.0 1.2 0.2 Iris-setosa 14
5.7 4.4 1.5 0.4 Iris-setosa 15
5.4 3.9 1.3 0.4 Iris-setosa 16
5.1 3.5 1.4 0.3 Iris-setosa 17
5.7 3.8 1.7 0.3 Iris-setosa 18
5.1 3.8 1.5 0.3 Iris-setosa 19
5.4 3.4 1.7 0.2 Iris-setosa 20
5.1 3.7 1.5 0.4 Iris-setosa 21
4.6 3.6 1.0 0.2 Iris-setosa 22
5.1 3.3 1.7 0.5 Iris-setosa 23
4.8 3.4 1.9 0.2 Iris-setosa 24
5.0 3.0 1.6 0.2 Iris-setosa 25
5.0 3.4 1.6 0.4 Iris-setosa 26
5.2 3.5 1.5 0.2 Iris-setosa 27
5.2 3.4 1.4 0.2 Iris-setosa 28
4.7 3.2 1.6 0.2 Iris-setosa 29
4.8 3.1 1.6 0.2 Iris-setosa 30
5.4 3.4 1.5 0.4 Iris-setosa 31
5.2 4.1 1.5 0.1 Iris-setosa 32
5.5 4.2 1.4 0.2 Iris-setosa 33
4.9 3.1 1.5 0.2 Iris-setosa 34
5.0 3.2 1.2 0.2 Iris-setosa 35
5.5 3.5 1.3 0.2 Iris-setosa 36
4.9 3.6 1.4 0.1 Iris-setosa 37
4.4 3.0 1.3 0.2 Iris-setosa 38
5.1 3.4 1.5 0.2 Iris-setosa 39
5.0 3.5 1.3 0.3 Iris-setosa 40
4.5 2.3 1.3 0.3 Iris-setosa 41
4.4 3.2 1.3 0.2 Iris-setosa 42
5.0 3.5 1.6 0.6 Iris-setosa 43
5.1 3.8 1.9 0.4 Iris-setosa 44
4.8 3.0 1.4 0.3 Iris-setosa 45
5.1 3.8 1.6 0.2 Iris-setosa 46
4.6 3.2 1.4 0.2 Iris-setosa 47
5.3 3.7 1.5 0.2 Iris-setosa 48
5.0 3.3 1.4 0.2 Iris-setosa 49
7.0 3.2 4.7 1.4 Iris-versicolor 50
6.4 3.2 4.5 1.5 Iris-versicolor 51
6.9 3.1 4.9 1.5 Iris-versicolor 52
5.5 2.3 4.0 1.3 Iris-versicolor 53
6.5 2.8 4.6 1.5 Iris-versicolor 54
5.7 2.8 4.5 1.3 Iris-versicolor 55
6.3 3.3 4.7 1.6 Iris-versicolor 56
4.9 2.4 3.3 1.0 Iris-versicolor 57
6.6 2.9 4.6 1.3 Iris-versicolor 58
5.2 2.7 3.9 1.4 Iris-versicolor 59
5.0 2.0 3.5 1.0 Iris-versicolor 60
5.9 3.0 4.2 1.5 Iris-versicolor 61
6.0 2.2 4.0 1.0 Iris-versicolor 62
6.1 2.9 4.7 1.4 Iris-versicolor 63
5.6 2.9 3.6 1.3 Iris-versicolor 64
6.7 3.1 4.4 1.4 Iris-versicolor 65
5.6 3.0 4.5 1.5 Iris-versicolor 66
5.8 2.7 4.1 1.0 Iris-versicolor 67
6.2 2.2 4.5 1.5 Iris-versicolor 68
5.6 2.5 3.9 1.1 Iris-versicolor 69
5.9 3.2 4.8 1.8 Iris-versicolor 70
6.1 2.8 4.0 1.3 Iris-versicolor 71
6.3 2.5 4.9 1.5 Iris-versicolor 72
6.1 2.8 4.7 1.2 Iris-versicolor 73
6.4 2.9 4.3 1.3 Iris-versicolor 74
6.6 3.0 4.4 1.4 Iris-versicolor 75
6.8 2.8 4.8 1.4 Iris-versicolor 76
6.7 3.0 5.0 1.7 Iris-versicolor 77
6.0 2.9 4.5 1.5 Iris-versicolor 78
5.7 2.6 3.5 1.0 Iris-versicolor 79
5.5 2.4 3.8 1.1 Iris-versicolor 80
5.5 2.4 3.7 1.0 Iris-versicolor 81
5.8 2.7 3.9 1.2 Iris-versicolor 82
6.0 2.7 5.1 1.6 Iris-versicolor 83
5.4 3.0 4.5 1.5 Iris-versicolor 84
6.0 3.4 4.5 1.6 Iris-versicolor 85
6.7 3.1 4.7 1.5 Iris-versicolor 86
6.3 2.3 4.4 1.3 Iris-versicolor 87
5.6 3.0 4.1 1.3 Iris-versicolor 88
5.5 2.5 4.0 1.3 Iris-versicolor 89
5.5 2.6 4.4 1.2 Iris-versicolor 90
6.1 3.0 4.6 1.4 Iris-versicolor 91
5.8 2.6 4.0 1.2 Iris-versicolor 92
5.0 2.3 3.3 1.0 Iris-versicolor 93
5.6 2.7 4.2 1.3 Iris-versicolor 94
5.7 3.0 4.2 1.2 Iris-versicolor 95
5.7 2.9 4.2 1.3 Iris-versicolor 96
6.2 2.9 4.3 1.3 Iris-versicolor 97
5.1 2.5 3.0 1.1 Iris-versicolor 98
5.7 2.8 4.1 1.3 Iris-versicolor 99
6.3 3.3 6.0 2.5 Iris-virginica 100
5.8 2.7 5.1 1.9 Iris-virginica 101
7.1 3.0 5.9 2.1 Iris-virginica 102
6.3 2.9 5.6 1.8 Iris-virginica 103
6.5 3.0 5.8 2.2 Iris-virginica 104
7.6 3.0 6.6 2.1 Iris-virginica 105
4.9 2.5 4.5 1.7 Iris-virginica 106
7.3 2.9 6.3 1.8 Iris-virginica 107
6.7 2.5 5.8 1.8 Iris-virginica 108
7.2 3.6 6.1 2.5 Iris-virginica 109
6.5 3.2 5.1 2.0 Iris-virginica 110
6.4 2.7 5.3 1.9 Iris-virginica 111
6.8 3.0 5.5 2.1 Iris-virginica 112
5.7 2.5 5.0 2.0 Iris-virginica 113
5.8 2.8 5.1 2.4 Iris-virginica 114
6.4 3.2 5.3 2.3 Iris-virginica 115
6.5 3.0 5.5 1.8 Iris-virginica 116
7.7 3.8 6.7 2.2 Iris-virginica 117
7.7 2.6 6.9 2.3 Iris-virginica 118
6.0 2.2 5.0 1.5 Iris-virginica 119
6.9 3.2 5.7 2.3 Iris-virginica 120
5.6 2.8 4.9 2.0 Iris-virginica 121
7.7 2.8 6.7 2.0 Iris-virginica 122
6.3 2.7 4.9 1.8 Iris-virginica 123
6.7 3.3 5.7 2.1 Iris-virginica 124
7.2 3.2 6.0 1.8 Iris-virginica 125
6.2 2.8 4.8 1.8 Iris-virginica 126
6.1 3.0 4.9 1.8 Iris-virginica 127
6.4 2.8 5.6 2.1 Iris-virginica 128
7.2 3.0 5.8 1.6 Iris-virginica 129
7.4 2.8 6.1 1.9 Iris-virginica 130
7.9 3.8 6.4 2.0 Iris-virginica 131
6.4 2.8 5.6 2.2 Iris-virginica 132
6.3 2.8 5.1 1.5 Iris-virginica 133
6.1 2.6 5.6 1.4 Iris-virginica 134
7.7 3.0 6.1 2.3 Iris-virginica 135
6.3 3.4 5.6 2.4 Iris-virginica 136
6.4 3.1 5.5 1.8 Iris-virginica 137
6.0 3.0 4.8 1.8 Iris-virginica 138
6.9 3.1 5.4 2.1 Iris-virginica 139
6.7 3.1 5.6 2.4 Iris-virginica 140
6.9 3.1 5.1 2.3 Iris-virginica 141
5.8 2.7 5.1 1.9 Iris-virginica 142
6.8 3.2 5.9 2.3 Iris-virginica 143
6.7 3.3 5.7 2.5 Iris-virginica 144
6.7 3.0 5.2 2.3 Iris-virginica 145
6.3 2.5 5.0 1.9 Iris-virginica 146
6.5 3.0 5.2 2.0 Iris-virginica 147
6.2 3.4 5.4 2.3 Iris-virginica 148
5.9 3.0 5.1 1.8 Iris-virginica 149
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 6. in line 1.
# Fisher Iris Data
sepal_length,sepal_width,petal_length,petal_width,species,id
5.1,3.5,1.4,0.2,Iris-setosa,0
4.9,3.0,1.4,0.2,Iris-setosa,1
4.7,3.2,1.3,0.2,Iris-setosa,2
4.6,3.1,1.5,0.2,Iris-setosa,3
5.0,3.6,1.4,0.2,Iris-setosa,4
5.4,3.9,1.7,0.4,Iris-setosa,5
4.6,3.4,1.4,0.3,Iris-setosa,6
5.0,3.4,1.5,0.2,Iris-setosa,7
4.4,2.9,1.4,0.2,Iris-setosa,8
4.9,3.1,1.5,0.1,Iris-setosa,9
5.4,3.7,1.5,0.2,Iris-setosa,10
4.8,3.4,1.6,0.2,Iris-setosa,11
4.8,3.0,1.4,0.1,Iris-setosa,12
4.3,3.0,1.1,0.1,Iris-setosa,13
5.8,4.0,1.2,0.2,Iris-setosa,14
5.7,4.4,1.5,0.4,Iris-setosa,15
5.4,3.9,1.3,0.4,Iris-setosa,16
5.1,3.5,1.4,0.3,Iris-setosa,17
5.7,3.8,1.7,0.3,Iris-setosa,18
5.1,3.8,1.5,0.3,Iris-setosa,19
5.4,3.4,1.7,0.2,Iris-setosa,20
5.1,3.7,1.5,0.4,Iris-setosa,21
4.6,3.6,1.0,0.2,Iris-setosa,22
5.1,3.3,1.7,0.5,Iris-setosa,23
4.8,3.4,1.9,0.2,Iris-setosa,24
5.0,3.0,1.6,0.2,Iris-setosa,25
5.0,3.4,1.6,0.4,Iris-setosa,26
5.2,3.5,1.5,0.2,Iris-setosa,27
5.2,3.4,1.4,0.2,Iris-setosa,28
4.7,3.2,1.6,0.2,Iris-setosa,29
4.8,3.1,1.6,0.2,Iris-setosa,30
5.4,3.4,1.5,0.4,Iris-setosa,31
5.2,4.1,1.5,0.1,Iris-setosa,32
5.5,4.2,1.4,0.2,Iris-setosa,33
4.9,3.1,1.5,0.2,Iris-setosa,34
5.0,3.2,1.2,0.2,Iris-setosa,35
5.5,3.5,1.3,0.2,Iris-setosa,36
4.9,3.6,1.4,0.1,Iris-setosa,37
4.4,3.0,1.3,0.2,Iris-setosa,38
5.1,3.4,1.5,0.2,Iris-setosa,39
5.0,3.5,1.3,0.3,Iris-setosa,40
4.5,2.3,1.3,0.3,Iris-setosa,41
4.4,3.2,1.3,0.2,Iris-setosa,42
5.0,3.5,1.6,0.6,Iris-setosa,43
5.1,3.8,1.9,0.4,Iris-setosa,44
4.8,3.0,1.4,0.3,Iris-setosa,45
5.1,3.8,1.6,0.2,Iris-setosa,46
4.6,3.2,1.4,0.2,Iris-setosa,47
5.3,3.7,1.5,0.2,Iris-setosa,48
5.0,3.3,1.4,0.2,Iris-setosa,49
7.0,3.2,4.7,1.4,Iris-versicolor,50
6.4,3.2,4.5,1.5,Iris-versicolor,51
6.9,3.1,4.9,1.5,Iris-versicolor,52
5.5,2.3,4.0,1.3,Iris-versicolor,53
6.5,2.8,4.6,1.5,Iris-versicolor,54
5.7,2.8,4.5,1.3,Iris-versicolor,55
6.3,3.3,4.7,1.6,Iris-versicolor,56
4.9,2.4,3.3,1.0,Iris-versicolor,57
6.6,2.9,4.6,1.3,Iris-versicolor,58
5.2,2.7,3.9,1.4,Iris-versicolor,59
5.0,2.0,3.5,1.0,Iris-versicolor,60
5.9,3.0,4.2,1.5,Iris-versicolor,61
6.0,2.2,4.0,1.0,Iris-versicolor,62
6.1,2.9,4.7,1.4,Iris-versicolor,63
5.6,2.9,3.6,1.3,Iris-versicolor,64
6.7,3.1,4.4,1.4,Iris-versicolor,65
5.6,3.0,4.5,1.5,Iris-versicolor,66
5.8,2.7,4.1,1.0,Iris-versicolor,67
6.2,2.2,4.5,1.5,Iris-versicolor,68
5.6,2.5,3.9,1.1,Iris-versicolor,69
5.9,3.2,4.8,1.8,Iris-versicolor,70
6.1,2.8,4.0,1.3,Iris-versicolor,71
6.3,2.5,4.9,1.5,Iris-versicolor,72
6.1,2.8,4.7,1.2,Iris-versicolor,73
6.4,2.9,4.3,1.3,Iris-versicolor,74
6.6,3.0,4.4,1.4,Iris-versicolor,75
6.8,2.8,4.8,1.4,Iris-versicolor,76
6.7,3.0,5.0,1.7,Iris-versicolor,77
6.0,2.9,4.5,1.5,Iris-versicolor,78
5.7,2.6,3.5,1.0,Iris-versicolor,79
5.5,2.4,3.8,1.1,Iris-versicolor,80
5.5,2.4,3.7,1.0,Iris-versicolor,81
5.8,2.7,3.9,1.2,Iris-versicolor,82
6.0,2.7,5.1,1.6,Iris-versicolor,83
5.4,3.0,4.5,1.5,Iris-versicolor,84
6.0,3.4,4.5,1.6,Iris-versicolor,85
6.7,3.1,4.7,1.5,Iris-versicolor,86
6.3,2.3,4.4,1.3,Iris-versicolor,87
5.6,3.0,4.1,1.3,Iris-versicolor,88
5.5,2.5,4.0,1.3,Iris-versicolor,89
5.5,2.6,4.4,1.2,Iris-versicolor,90
6.1,3.0,4.6,1.4,Iris-versicolor,91
5.8,2.6,4.0,1.2,Iris-versicolor,92
5.0,2.3,3.3,1.0,Iris-versicolor,93
5.6,2.7,4.2,1.3,Iris-versicolor,94
5.7,3.0,4.2,1.2,Iris-versicolor,95
5.7,2.9,4.2,1.3,Iris-versicolor,96
6.2,2.9,4.3,1.3,Iris-versicolor,97
5.1,2.5,3.0,1.1,Iris-versicolor,98
5.7,2.8,4.1,1.3,Iris-versicolor,99
6.3,3.3,6.0,2.5,Iris-virginica,100
5.8,2.7,5.1,1.9,Iris-virginica,101
7.1,3.0,5.9,2.1,Iris-virginica,102
6.3,2.9,5.6,1.8,Iris-virginica,103
6.5,3.0,5.8,2.2,Iris-virginica,104
7.6,3.0,6.6,2.1,Iris-virginica,105
4.9,2.5,4.5,1.7,Iris-virginica,106
7.3,2.9,6.3,1.8,Iris-virginica,107
6.7,2.5,5.8,1.8,Iris-virginica,108
7.2,3.6,6.1,2.5,Iris-virginica,109
6.5,3.2,5.1,2.0,Iris-virginica,110
6.4,2.7,5.3,1.9,Iris-virginica,111
6.8,3.0,5.5,2.1,Iris-virginica,112
5.7,2.5,5.0,2.0,Iris-virginica,113
5.8,2.8,5.1,2.4,Iris-virginica,114
6.4,3.2,5.3,2.3,Iris-virginica,115
6.5,3.0,5.5,1.8,Iris-virginica,116
7.7,3.8,6.7,2.2,Iris-virginica,117
7.7,2.6,6.9,2.3,Iris-virginica,118
6.0,2.2,5.0,1.5,Iris-virginica,119
6.9,3.2,5.7,2.3,Iris-virginica,120
5.6,2.8,4.9,2.0,Iris-virginica,121
7.7,2.8,6.7,2.0,Iris-virginica,122
6.3,2.7,4.9,1.8,Iris-virginica,123
6.7,3.3,5.7,2.1,Iris-virginica,124
7.2,3.2,6.0,1.8,Iris-virginica,125
6.2,2.8,4.8,1.8,Iris-virginica,126
6.1,3.0,4.9,1.8,Iris-virginica,127
6.4,2.8,5.6,2.1,Iris-virginica,128
7.2,3.0,5.8,1.6,Iris-virginica,129
7.4,2.8,6.1,1.9,Iris-virginica,130
7.9,3.8,6.4,2.0,Iris-virginica,131
6.4,2.8,5.6,2.2,Iris-virginica,132
6.3,2.8,5.1,1.5,Iris-virginica,133
6.1,2.6,5.6,1.4,Iris-virginica,134
7.7,3.0,6.1,2.3,Iris-virginica,135
6.3,3.4,5.6,2.4,Iris-virginica,136
6.4,3.1,5.5,1.8,Iris-virginica,137
6.0,3.0,4.8,1.8,Iris-virginica,138
6.9,3.1,5.4,2.1,Iris-virginica,139
6.7,3.1,5.6,2.4,Iris-virginica,140
6.9,3.1,5.1,2.3,Iris-virginica,141
5.8,2.7,5.1,1.9,Iris-virginica,142
6.8,3.2,5.9,2.3,Iris-virginica,143
6.7,3.3,5.7,2.5,Iris-virginica,144
6.7,3.0,5.2,2.3,Iris-virginica,145
6.3,2.5,5.0,1.9,Iris-virginica,146
6.5,3.0,5.2,2.0,Iris-virginica,147
6.2,3.4,5.4,2.3,Iris-virginica,148
5.9,3.0,5.1,1.8,Iris-virginica,149
sepal_length sepal_width petal_length petal_width species id
5.1 3.5 1.4 0.2 NULL 0
4.9 3.0 1.4 0.2 NULL 1
4.7 3.2 1.3 0.2 NULL 2
4.6 3.1 1.5 0.2 NULL 3
5.0 3.6 1.4 0.2 NULL 4
5.4 3.9 1.7 0.4 NULL 5
4.6 3.4 1.4 0.3 NULL 6
5.0 3.4 1.5 0.2 NULL 7
4.4 2.9 1.4 0.2 NULL 8
4.9 3.1 1.5 0.1 NULL 9
5.4 3.7 1.5 0.2 NULL 10
4.8 3.4 1.6 0.2 NULL 11
4.8 3.0 1.4 0.1 NULL 12
4.3 3.0 1.1 0.1 NULL 13
5.8 4.0 1.2 0.2 NULL 14
5.7 4.4 1.5 0.4 NULL 15
5.4 3.9 1.3 0.4 NULL 16
5.1 3.5 1.4 0.3 NULL 17
5.7 3.8 1.7 0.3 NULL 18
5.1 3.8 1.5 0.3 NULL 19
5.4 3.4 1.7 0.2 NULL 20
5.1 3.7 1.5 0.4 NULL 21
4.6 3.6 1.0 0.2 NULL 22
5.1 3.3 1.7 0.5 NULL 23
4.8 3.4 1.9 0.2 NULL 24
5.0 3.0 1.6 0.2 NULL 25
5.0 3.4 1.6 0.4 NULL 26
5.2 3.5 1.5 0.2 NULL 27
5.2 3.4 1.4 0.2 NULL 28
4.7 3.2 1.6 0.2 NULL 29
4.8 3.1 1.6 0.2 NULL 30
5.4 3.4 1.5 0.4 NULL 31
5.2 4.1 1.5 0.1 NULL 32
5.5 4.2 1.4 0.2 NULL 33
4.9 3.1 1.5 0.2 NULL 34
5.0 3.2 1.2 0.2 NULL 35
5.5 3.5 1.3 0.2 NULL 36
4.9 3.6 1.4 0.1 NULL 37
4.4 3.0 1.3 0.2 NULL 38
5.1 3.4 1.5 0.2 NULL 39
5.0 3.5 1.3 0.3 NULL 40
4.5 2.3 1.3 0.3 NULL 41
4.4 3.2 1.3 0.2 NULL 42
5.0 3.5 1.6 0.6 NULL 43
5.1 3.8 1.9 0.4 NULL 44
4.8 3.0 1.4 0.3 NULL 45
5.1 3.8 1.6 0.2 NULL 46
4.6 3.2 1.4 0.2 NULL 47
5.3 3.7 1.5 0.2 NULL 48
5.0 3.3 1.4 0.2 NULL 49
7.0 3.2 4.7 1.4 NULL 50
6.4 3.2 4.5 1.5 NULL 51
6.9 3.1 4.9 1.5 NULL 52
5.5 2.3 4.0 1.3 NULL 53
6.5 2.8 4.6 1.5 NULL 54
5.7 2.8 4.5 1.3 NULL 55
6.3 3.3 4.7 1.6 NULL 56
4.9 2.4 3.3 1.0 NULL 57
6.6 2.9 4.6 1.3 NULL 58
5.2 2.7 3.9 1.4 NULL 59
5.0 2.0 3.5 1.0 NULL 60
5.9 3.0 4.2 1.5 NULL 61
6.0 2.2 4.0 1.0 NULL 62
6.1 2.9 4.7 1.4 NULL 63
5.6 2.9 3.6 1.3 NULL 64
6.7 3.1 4.4 1.4 NULL 65
5.6 3.0 4.5 1.5 NULL 66
5.8 2.7 4.1 1.0 NULL 67
6.2 2.2 4.5 1.5 NULL 68
5.6 2.5 3.9 1.1 NULL 69
5.9 3.2 4.8 1.8 NULL 70
6.1 2.8 4.0 1.3 NULL 71
6.3 2.5 4.9 1.5 NULL 72
6.1 2.8 4.7 1.2 NULL 73
6.4 2.9 4.3 1.3 NULL 74
6.6 3.0 4.4 1.4 NULL 75
6.8 2.8 4.8 1.4 NULL 76
6.7 3.0 5.0 1.7 NULL 77
6.0 2.9 4.5 1.5 NULL 78
5.7 2.6 3.5 1.0 NULL 79
5.5 2.4 3.8 1.1 NULL 80
5.5 2.4 3.7 1.0 NULL 81
5.8 2.7 3.9 1.2 NULL 82
6.0 2.7 5.1 1.6 NULL 83
5.4 3.0 4.5 1.5 NULL 84
6.0 3.4 4.5 1.6 NULL 85
6.7 3.1 4.7 1.5 NULL 86
6.3 2.3 4.4 1.3 NULL 87
5.6 3.0 4.1 1.3 NULL 88
5.5 2.5 4.0 1.3 NULL 89
5.5 2.6 4.4 1.2 NULL 90
6.1 3.0 4.6 1.4 NULL 91
5.8 2.6 4.0 1.2 NULL 92
5.0 2.3 3.3 1.0 NULL 93
5.6 2.7 4.2 1.3 NULL 94
5.7 3.0 4.2 1.2 NULL 95
5.7 2.9 4.2 1.3 NULL 96
6.2 2.9 4.3 1.3 NULL 97
5.1 2.5 3.0 1.1 NULL 98
5.7 2.8 4.1 1.3 NULL 99
6.3 3.3 6.0 2.5 NULL 100
5.8 2.7 5.1 1.9 NULL 101
7.1 3.0 5.9 2.1 NULL 102
6.3 2.9 5.6 1.8 NULL 103
6.5 3.0 5.8 2.2 NULL 104
7.6 3.0 6.6 2.1 NULL 105
4.9 2.5 4.5 1.7 NULL 106
7.3 2.9 6.3 1.8 NULL 107
6.7 2.5 5.8 1.8 NULL 108
7.2 3.6 6.1 2.5 NULL 109
6.5 3.2 5.1 2.0 NULL 110
6.4 2.7 5.3 1.9 NULL 111
6.8 3.0 5.5 2.1 NULL 112
5.7 2.5 5.0 2.0 NULL 113
5.8 2.8 5.1 2.4 NULL 114
6.4 3.2 5.3 2.3 NULL 115
6.5 3.0 5.5 1.8 NULL 116
7.7 3.8 6.7 2.2 NULL 117
7.7 2.6 6.9 2.3 NULL 118
6.0 2.2 5.0 1.5 NULL 119
6.9 3.2 5.7 2.3 NULL 120
5.6 2.8 4.9 2.0 NULL 121
7.7 2.8 6.7 2.0 NULL 122
6.3 2.7 4.9 1.8 NULL 123
6.7 3.3 5.7 2.1 NULL 124
7.2 3.2 6.0 1.8 NULL 125
6.2 2.8 4.8 1.8 NULL 126
6.1 3.0 4.9 1.8 NULL 127
6.4 2.8 5.6 2.1 NULL 128
7.2 3.0 5.8 1.6 NULL 129
7.4 2.8 6.1 1.9 NULL 130
7.9 3.8 6.4 2.0 NULL 131
6.4 2.8 5.6 2.2 NULL 132
6.3 2.8 5.1 1.5 NULL 133
6.1 2.6 5.6 1.4 NULL 134
7.7 3.0 6.1 2.3 NULL 135
6.3 3.4 5.6 2.4 NULL 136
6.4 3.1 5.5 1.8 NULL 137
6.0 3.0 4.8 1.8 NULL 138
6.9 3.1 5.4 2.1 NULL 139
6.7 3.1 5.6 2.4 NULL 140
6.9 3.1 5.1 2.3 NULL 141
5.8 2.7 5.1 1.9 NULL 142
6.8 3.2 5.9 2.3 NULL 143
6.7 3.3 5.7 2.5 NULL 144
6.7 3.0 5.2 2.3 NULL 145
6.3 2.5 5.0 1.9 NULL 146
6.5 3.0 5.2 2.0 NULL 147
6.2 3.4 5.4 2.3 NULL 148
5.9 3.0 5.1 1.8 NULL 149
sepal_length sepal_width petal_length petal_width species id
5.1 3.5 1.4 0.2 0
4.9 3.0 1.4 0.2 1
4.7 3.2 1.3 0.2 2
4.6 3.1 1.5 0.2 3
5.0 3.6 1.4 0.2 4
5.4 3.9 1.7 0.4 5
4.6 3.4 1.4 0.3 6
5.0 3.4 1.5 0.2 7
4.4 2.9 1.4 0.2 8
4.9 3.1 1.5 0.1 9
5.4 3.7 1.5 0.2 10
4.8 3.4 1.6 0.2 11
4.8 3.0 1.4 0.1 12
4.3 3.0 1.1 0.1 13
5.8 4.0 1.2 0.2 14
5.7 4.4 1.5 0.4 15
5.4 3.9 1.3 0.4 16
5.1 3.5 1.4 0.3 17
5.7 3.8 1.7 0.3 18
5.1 3.8 1.5 0.3 19
5.4 3.4 1.7 0.2 20
5.1 3.7 1.5 0.4 21
4.6 3.6 1.0 0.2 22
5.1 3.3 1.7 0.5 23
4.8 3.4 1.9 0.2 24
5.0 3.0 1.6 0.2 25
5.0 3.4 1.6 0.4 26
5.2 3.5 1.5 0.2 27
5.2 3.4 1.4 0.2 28
4.7 3.2 1.6 0.2 29
4.8 3.1 1.6 0.2 30
5.4 3.4 1.5 0.4 31
5.2 4.1 1.5 0.1 32
5.5 4.2 1.4 0.2 33
4.9 3.1 1.5 0.2 34
5.0 3.2 1.2 0.2 35
5.5 3.5 1.3 0.2 36
4.9 3.6 1.4 0.1 37
4.4 3.0 1.3 0.2 38
5.1 3.4 1.5 0.2 39
5.0 3.5 1.3 0.3 40
4.5 2.3 1.3 0.3 41
4.4 3.2 1.3 0.2 42
5.0 3.5 1.6 0.6 43
5.1 3.8 1.9 0.4 44
4.8 3.0 1.4 0.3 45
5.1 3.8 1.6 0.2 46
4.6 3.2 1.4 0.2 47
5.3 3.7 1.5 0.2 48
5.0 3.3 1.4 0.2 49
7.0 3.2 4.7 1.4 50
6.4 3.2 4.5 1.5 51
6.9 3.1 4.9 1.5 52
5.5 2.3 4.0 1.3 53
6.5 2.8 4.6 1.5 54
5.7 2.8 4.5 1.3 55
6.3 3.3 4.7 1.6 56
4.9 2.4 3.3 1.0 57
6.6 2.9 4.6 1.3 58
5.2 2.7 3.9 1.4 59
5.0 2.0 3.5 1.0 60
5.9 3.0 4.2 1.5 61
6.0 2.2 4.0 1.0 62
6.1 2.9 4.7 1.4 63
5.6 2.9 3.6 1.3 64
6.7 3.1 4.4 1.4 65
5.6 3.0 4.5 1.5 66
5.8 2.7 4.1 1.0 67
6.2 2.2 4.5 1.5 68
5.6 2.5 3.9 1.1 69
5.9 3.2 4.8 1.8 70
6.1 2.8 4.0 1.3 71
6.3 2.5 4.9 1.5 72
6.1 2.8 4.7 1.2 73
6.4 2.9 4.3 1.3 74
6.6 3.0 4.4 1.4 75
6.8 2.8 4.8 1.4 76
6.7 3.0 5.0 1.7 77
6.0 2.9 4.5 1.5 78
5.7 2.6 3.5 1.0 79
5.5 2.4 3.8 1.1 80
5.5 2.4 3.7 1.0 81
5.8 2.7 3.9 1.2 82
6.0 2.7 5.1 1.6 83
5.4 3.0 4.5 1.5 84
6.0 3.4 4.5 1.6 85
6.7 3.1 4.7 1.5 86
6.3 2.3 4.4 1.3 87
5.6 3.0 4.1 1.3 88
5.5 2.5 4.0 1.3 89
5.5 2.6 4.4 1.2 90
6.1 3.0 4.6 1.4 91
5.8 2.6 4.0 1.2 92
5.0 2.3 3.3 1.0 93
5.6 2.7 4.2 1.3 94
5.7 3.0 4.2 1.2 95
5.7 2.9 4.2 1.3 96
6.2 2.9 4.3 1.3 97
5.1 2.5 3.0 1.1 98
5.7 2.8 4.1 1.3 99
6.3 3.3 6.0 2.5 100
5.8 2.7 5.1 1.9 101
7.1 3.0 5.9 2.1 102
6.3 2.9 5.6 1.8 103
6.5 3.0 5.8 2.2 104
7.6 3.0 6.6 2.1 105
4.9 2.5 4.5 1.7 106
7.3 2.9 6.3 1.8 107
6.7 2.5 5.8 1.8 108
7.2 3.6 6.1 2.5 109
6.5 3.2 5.1 2.0 110
6.4 2.7 5.3 1.9 111
6.8 3.0 5.5 2.1 112
5.7 2.5 5.0 2.0 113
5.8 2.8 5.1 2.4 114
6.4 3.2 5.3 2.3 115
6.5 3.0 5.5 1.8 116
7.7 3.8 6.7 2.2 117
7.7 2.6 6.9 2.3 118
6.0 2.2 5.0 1.5 119
6.9 3.2 5.7 2.3 120
5.6 2.8 4.9 2.0 121
7.7 2.8 6.7 2.0 122
6.3 2.7 4.9 1.8 123
6.7 3.3 5.7 2.1 124
7.2 3.2 6.0 1.8 125
6.2 2.8 4.8 1.8 126
6.1 3.0 4.9 1.8 127
6.4 2.8 5.6 2.1 128
7.2 3.0 5.8 1.6 129
7.4 2.8 6.1 1.9 130
7.9 3.8 6.4 2.0 131
6.4 2.8 5.6 2.2 132
6.3 2.8 5.1 1.5 133
6.1 2.6 5.6 1.4 134
7.7 3.0 6.1 2.3 135
6.3 3.4 5.6 2.4 136
6.4 3.1 5.5 1.8 137
6.0 3.0 4.8 1.8 138
6.9 3.1 5.4 2.1 139
6.7 3.1 5.6 2.4 140
6.9 3.1 5.1 2.3 141
5.8 2.7 5.1 1.9 142
6.8 3.2 5.9 2.3 143
6.7 3.3 5.7 2.5 144
6.7 3.0 5.2 2.3 145
6.3 2.5 5.0 1.9 146
6.5 3.0 5.2 2.0 147
6.2 3.4 5.4 2.3 148
5.9 3.0 5.1 1.8 149
sepal_length sepal_width petal_length petal_width species
5.1 3.5 1.4 0.2 Iris-setosa
4.9 3.0 1.4 0.2 Iris-setosa
4.7 3.2 1.3 0.2 Iris-setosa
4.6 3.1 1.5 0.2 Iris-setosa
5.0 3.6 1.4 0.2 Iris-setosa
5.4 3.9 1.7 0.4 Iris-setosa
4.6 3.4 1.4 0.3 Iris-setosa
5.0 3.4 1.5 0.2 Iris-setosa
4.4 2.9 1.4 0.2 Iris-setosa
4.9 3.1 1.5 0.1 Iris-setosa
5.4 3.7 1.5 0.2 Iris-setosa
4.8 3.4 1.6 0.2 Iris-setosa
4.8 3.0 1.4 0.1 Iris-setosa
4.3 3.0 1.1 0.1 Iris-setosa
5.8 4.0 1.2 0.2 Iris-setosa
5.7 4.4 1.5 0.4 Iris-setosa
5.4 3.9 1.3 0.4 Iris-setosa
5.1 3.5 1.4 0.3 Iris-setosa
5.7 3.8 1.7 0.3 Iris-setosa
5.1 3.8 1.5 0.3 Iris-setosa
5.4 3.4 1.7 0.2 Iris-setosa
5.1 3.7 1.5 0.4 Iris-setosa
4.6 3.6 1.0 0.2 Iris-setosa
5.1 3.3 1.7 0.5 Iris-setosa
4.8 3.4 1.9 0.2 Iris-setosa
5.0 3.0 1.6 0.2 Iris-setosa
5.0 3.4 1.6 0.4 Iris-setosa
5.2 3.5 1.5 0.2 Iris-setosa
5.2 3.4 1.4 0.2 Iris-setosa
4.7 3.2 1.6 0.2 Iris-setosa
4.8 3.1 1.6 0.2 Iris-setosa
5.4 3.4 1.5 0.4 Iris-setosa
5.2 4.1 1.5 0.1 Iris-setosa
5.5 4.2 1.4 0.2 Iris-setosa
4.9 3.1 1.5 0.2 Iris-setosa
5.0 3.2 1.2 0.2 Iris-setosa
5.5 3.5 1.3 0.2 Iris-setosa
4.9 3.6 1.4 0.1 Iris-setosa
4.4 3.0 1.3 0.2 Iris-setosa
5.1 3.4 1.5 0.2 Iris-setosa
5.0 3.5 1.3 0.3 Iris-setosa
4.5 2.3 1.3 0.3 Iris-setosa
4.4 3.2 1.3 0.2 Iris-setosa
5.0 3.5 1.6 0.6 Iris-setosa
5.1 3.8 1.9 0.4 Iris-setosa
4.8 3.0 1.4 0.3 Iris-setosa
5.1 3.8 1.6 0.2 Iris-setosa
4.6 3.2 1.4 0.2 Iris-setosa
5.3 3.7 1.5 0.2 Iris-setosa
5.0 3.3 1.4 0.2 Iris-setosa
7.0 3.2 4.7 1.4 Iris-versicolor
6.4 3.2 4.5 1.5 Iris-versicolor
6.9 3.1 4.9 1.5 Iris-versicolor
5.5 2.3 4.0 1.3 Iris-versicolor
6.5 2.8 4.6 1.5 Iris-versicolor
5.7 2.8 4.5 1.3 Iris-versicolor
6.3 3.3 4.7 1.6 Iris-versicolor
4.9 2.4 3.3 1.0 Iris-versicolor
6.6 2.9 4.6 1.3 Iris-versicolor
5.2 2.7 3.9 1.4 Iris-versicolor
5.0 2.0 3.5 1.0 Iris-versicolor
5.9 3.0 4.2 1.5 Iris-versicolor
6.0 2.2 4.0 1.0 Iris-versicolor
6.1 2.9 4.7 1.4 Iris-versicolor
5.6 2.9 3.6 1.3 Iris-versicolor
6.7 3.1 4.4 1.4 Iris-versicolor
5.6 3.0 4.5 1.5 Iris-versicolor
5.8 2.7 4.1 1.0 Iris-versicolor
6.2 2.2 4.5 1.5 Iris-versicolor
5.6 2.5 3.9 1.1 Iris-versicolor
5.9 3.2 4.8 1.8 Iris-versicolor
6.1 2.8 4.0 1.3 Iris-versicolor
6.3 2.5 4.9 1.5 Iris-versicolor
6.1 2.8 4.7 1.2 Iris-versicolor
6.4 2.9 4.3 1.3 Iris-versicolor
6.6 3.0 4.4 1.4 Iris-versicolor
6.8 2.8 4.8 1.4 Iris-versicolor
6.7 3.0 5.0 1.7 Iris-versicolor
6.0 2.9 4.5 1.5 Iris-versicolor
5.7 2.6 3.5 1.0 Iris-versicolor
5.5 2.4 3.8 1.1 Iris-versicolor
5.5 2.4 3.7 1.0 Iris-versicolor
5.8 2.7 3.9 1.2 Iris-versicolor
6.0 2.7 5.1 1.6 Iris-versicolor
5.4 3.0 4.5 1.5 Iris-versicolor
6.0 3.4 4.5 1.6 Iris-versicolor
6.7 3.1 4.7 1.5 Iris-versicolor
6.3 2.3 4.4 1.3 Iris-versicolor
5.6 3.0 4.1 1.3 Iris-versicolor
5.5 2.5 4.0 1.3 Iris-versicolor
5.5 2.6 4.4 1.2 Iris-versicolor
6.1 3.0 4.6 1.4 Iris-versicolor
5.8 2.6 4.0 1.2 Iris-versicolor
5.0 2.3 3.3 1.0 Iris-versicolor
5.6 2.7 4.2 1.3 Iris-versicolor
5.7 3.0 4.2 1.2 Iris-versicolor
5.7 2.9 4.2 1.3 Iris-versicolor
6.2 2.9 4.3 1.3 Iris-versicolor
5.1 2.5 3.0 1.1 Iris-versicolor
5.7 2.8 4.1 1.3 Iris-versicolor
6.3 3.3 6.0 2.5 Iris-virginica
5.8 2.7 5.1 1.9 Iris-virginica
7.1 3.0 5.9 2.1 Iris-virginica
6.3 2.9 5.6 1.8 Iris-virginica
6.5 3.0 5.8 2.2 Iris-virginica
7.6 3.0 6.6 2.1 Iris-virginica
4.9 2.5 4.5 1.7 Iris-virginica
7.3 2.9 6.3 1.8 Iris-virginica
6.7 2.5 5.8 1.8 Iris-virginica
7.2 3.6 6.1 2.5 Iris-virginica
6.5 3.2 5.1 2.0 Iris-virginica
6.4 2.7 5.3 1.9 Iris-virginica
6.8 3.0 5.5 2.1 Iris-virginica
5.7 2.5 5.0 2.0 Iris-virginica
5.8 2.8 5.1 2.4 Iris-virginica
6.4 3.2 5.3 2.3 Iris-virginica
6.5 3.0 5.5 1.8 Iris-virginica
7.7 3.8 6.7 2.2 Iris-virginica
7.7 2.6 6.9 2.3 Iris-virginica
6.0 2.2 5.0 1.5 Iris-virginica
6.9 3.2 5.7 2.3 Iris-virginica
5.6 2.8 4.9 2.0 Iris-virginica
7.7 2.8 6.7 2.0 Iris-virginica
6.3 2.7 4.9 1.8 Iris-virginica
6.7 3.3 5.7 2.1 Iris-virginica
7.2 3.2 6.0 1.8 Iris-virginica
6.2 2.8 4.8 1.8 Iris-virginica
6.1 3.0 4.9 1.8 Iris-virginica
6.4 2.8 5.6 2.1 Iris-virginica
7.2 3.0 5.8 1.6 Iris-virginica
7.4 2.8 6.1 1.9 Iris-virginica
7.9 3.8 6.4 2.0 Iris-virginica
6.4 2.8 5.6 2.2 Iris-virginica
6.3 2.8 5.1 1.5 Iris-virginica
6.1 2.6 5.6 1.4 Iris-virginica
7.7 3.0 6.1 2.3 Iris-virginica
6.3 3.4 5.6 2.4 Iris-virginica
6.4 3.1 5.5 1.8 Iris-virginica
6.0 3.0 4.8 1.8 Iris-virginica
6.9 3.1 5.4 2.1 Iris-virginica
6.7 3.1 5.6 2.4 Iris-virginica
6.9 3.1 5.1 2.3 Iris-virginica
5.8 2.7 5.1 1.9 Iris-virginica
6.8 3.2 5.9 2.3 Iris-virginica
6.7 3.3 5.7 2.5 Iris-virginica
6.7 3.0 5.2 2.3 Iris-virginica
6.3 2.5 5.0 1.9 Iris-virginica
6.5 3.0 5.2 2.0 Iris-virginica
6.2 3.4 5.4 2.3 Iris-virginica
5.9 3.0 5.1 1.8 Iris-virginica
president|birthdate_string|birthdate
George Washington|February 22, 1732|1732-02-22
John Adams|October 30 1735|1735-10-30
Thomas Jefferson|April 13, 1743|1743-04-13
James Madison|March 16, 1751|1751-03-16
James Monroe|April 28th, 1758|1758-04-28
John Quincy Adams|July 11, 1767|1767.07.11
We can make this file beautiful and searchable if this error is corrected: Any value after quoted field isn't allowed in line 2.
category,examples
"Baseball Teams","[\"Boston Red Sox\",\"Atlanta Braves\",\"San Diego Padres\",\"Washington Senators\"]"
"Football Teams","[\"New England Patriots\",\"Seattle Seahawks\",\"Detroit Lions\",\"Chicago Bears\"]"
Soccer Teams,"[\"New England Revolution\",\"New York Red Bulls\",\"D. C. United\",\"Chicago Fire Soccer Club\"]"
Basketball Teams,"[\"Boston Celtics\",\"Los Angeles Lakers\",\"Chicago Bulls\",\"Detroit Pistons\"]"
Hockey Teams,"[\"Boston Bruins\",\"Philadelphia Flyers\",\"Washington Capitals\",\"Edmonton Oilers\"]"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment