1
(cl:in-package :cl-csv)
3
(defun get-data-table-from-csv (file &optional (has-column-names t) (munge-types t) sample
4
&aux (dt (make-instance 'data-table:data-table)))
5
"Gets a data-table object representing the CSV"
8
(for data = (mapcar #'data-table::trim-and-nullify row))
9
(if (and has-column-names (first-iteration-p))
10
(setf (data-table:column-names dt) data)
12
(sampling data into samples size sample)
13
(collect data into rows)))
15
(setf (data-table:rows dt)
16
(if sample samples rows))))
18
(data-table:coerce-data-table-of-strings-to-types dt)
19
(data-table::ensure-column-data-types dt))
23
(defun data-table-to-csv (dt &optional stream)
24
"Write a datatable object out to csv"
25
(write-csv (list* (data-table:column-names dt) (data-table:rows dt))
28
(defun get-data-table-from-csv-list
29
(list &optional (has-column-names t) (munge-types t) sample
30
&aux (dt (make-instance 'data-table:data-table)))
31
"Create a data-table from the parsed csv as lisp lists"
32
(flet ((map-fn (row) (mapcar #'data-table::trim-and-nullify row)))
33
(when has-column-names
34
(setf (data-table:column-names dt) (map-fn (first list))))
35
(setf (data-table:rows dt)
38
(map-fn (subseq x 0 sample))
42
(data-table:coerce-data-table-of-strings-to-types dt))