# HG changeset patch
# User nml
# Date 1589923396 14400
# Node ID 58ed60d203367af707a58bff5e701bc1ca841169
"planemo upload for repository https://github.com/shenwei356/csvtk commit 3a97e1b79bf0c6cdd37d5c8fb497b85531a563ab"
diff -r 000000000000 -r 58ed60d20336 filter.xml
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/filter.xml Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,168 @@
+
+ rows through arithmetic expression(s)
+
+ macros.xml
+
+
+
+ filtered
+
+ ]]>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 100", we would get the following output column:
+
++---------------+------------+----------+
+| Culture Label | Cell Count | Dilution |
++===============+============+==========+
+| ECo-1 | 2523 | 1000 |
++---------------+------------+----------+
+
+----
+
+**Ex2. Filter on two columns:**
+
+Same input table
+
++---------------+------------+----------+
+| Culture Label | Cell Count | Dilution |
++===============+============+==========+
+| ECo-1 | 2523 | 1000 |
++---------------+------------+----------+
+| LPn-1 | 100 | 1000000 |
++---------------+------------+----------+
+| LPn-2 | 4 | 1000 |
++---------------+------------+----------+
+
+Now if we use the expression "2-3>50" to filter on, we would pull out:
+
++---------------+------------+----------+
+| Culture Label | Cell Count | Dilution |
++===============+============+==========+
+| ECo-1 | 2523 | 1000 |
++---------------+------------+----------+
+| LPn-1 | 100 | 1000000 |
++---------------+------------+----------+
+
+Row 3 is not returned back as its column 2 is not greater than 50.
+
+However, if **Any** is set to Yes, then Row 3 would be returned as its column 3 is greater than 50
+making it satisfy one part of the expression.
+
+
+**Note:** - Multiple columns can only be specified with a "-"
+
+----
+
+@HELP_COLUMNS@
+
+
+@HELP_END_STATEMENT@
+
+
+ ]]>
+
+
\ No newline at end of file
diff -r 000000000000 -r 58ed60d20336 macros.xml
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/macros.xml Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,337 @@
+
+ 0.20.0
+ galaxy0
+
+
+ csvtk
+
+
+
+ csvtk version
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+Column Name Input Help
+######################
+
+- Multiple names can be given if separated by a ' , '.
+
+ - ex. 'ID,Organism' would target the columns named ID and Organism for the function
+
+- Column names are case SeNsitive
+
+- Column numbers can also be given:
+
+ -ex. '1,2,3' or '1-3' for inputting columns 1-3.
+
+- You can also specify all but unwanted column(s) with a ' - '.
+
+ - ex. '-ID' would target all columns but the ID column
+
+----
+
+
+Input Data
+##########
+
+::
+
+ **Limitations of Input Data**
+
+ 1. The CSV parser requires all the lines have same number of fields/columns.
+ If your file has illegal rows, set the "Illegal Rows" parameter to "Yes" to pass your data through
+ Even lines with spaces will cause error.
+ Example bad table below.
+
+ 2. By default, csvtk thinks files have header rows. If your file does not, set global parameter
+ "Has Header Row" to "No"
+
+ 3. Column names should be unique and are case sensitive!
+
+ 4. Lines starting with "#" or "$" will be ignored, if in the header row
+
+ 5. If " exists in tab-delimited files, set Lazy quotes global parameter to "Yes"
+
+Example bad table:
+
++--------+--------+--------+--------+
+| Head 1 | Head 2 | Head 3 | Head 3 |
++========+========+========+========+
+| 1 | 2 | 3 | |
++--------+--------+--------+--------+
+| this | will | | break |
++--------+--------+--------+--------+
+
+Bad tables may work if both the "Ignore Illegal Rows" and "Ignore Empty Rows" global parameters are set to "Yes",
+But there is no guarentee of that!
+
+----
+
+
+More Information
+################
+For information from the creators of csvtk, please visit their site at: https://bioinf.shenwei.me/csvtk/
+
+Although be aware that some features may not be available and some small changes were made to work with Galaxy.
+
+**Notable changes from their documentation:**
+
+- Cannot specify multiple file header names (IE cannot use "name;username" as a valid column match)
+
+- No single quotes / apostrophes allowed in text inputs
+
+
+
+ @ARTICLE{a1,
+ title = {csvtk - CSV/TSV Toolkit},
+ author = {Wei Shen},
+ url = {https://github.com/shenwei356/csvtk}
+ }
+ }
+
+
+
\ No newline at end of file
diff -r 000000000000 -r 58ed60d20336 test-data/Animals_More.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/Animals_More.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,10 @@
+Name,Animal,Random_Number
+Spots,Dog,1
+Fred,Dog,5
+Mittens,Cat,16
+Slippers,Cat,11
+Gravy,Cat,6
+Stripes,Zebra,7
+Muffin,Cat,7
+Earl,Dog,2
+Sir-Wags-A-Lot,Dog,44
diff -r 000000000000 -r 58ed60d20336 test-data/XY_converted.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/XY_converted.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,12 @@
+X,Y
+1,2
+2,4
+4,8
+8,16
+16,32
+32,64
+64,128
+128,256
+256,512
+1024,2048
+2048,5096
diff -r 000000000000 -r 58ed60d20336 test-data/XY_converted.tsv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/XY_converted.tsv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,12 @@
+X Y
+1 2
+2 4
+4 8
+8 16
+16 32
+32 64
+64 128
+128 256
+256 512
+1024 2048
+2048 5096
diff -r 000000000000 -r 58ed60d20336 test-data/XY_with_break.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/XY_with_break.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,13 @@
+X,Y
+1,2
+2,4
+4,8
+8,16
+16,32
+32,64
+64,128
+128,256
+256,512
+,
+1024,2048
+2048,5096
diff -r 000000000000 -r 58ed60d20336 test-data/XY_with_break.tabular
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/XY_with_break.tabular Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,13 @@
+X Y
+1 2
+2 4
+4 8
+8 16
+16 32
+32 64
+64 128
+128 256
+256 512
+
+1024 2048
+2048 5096
diff -r 000000000000 -r 58ed60d20336 test-data/another.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/another.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,4 @@
+Name,Food,Age
+Joe,Beets,33
+Steven,Eggplant,36
+Jacob,Kale,59
\ No newline at end of file
diff -r 000000000000 -r 58ed60d20336 test-data/awk_mutate_input.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/awk_mutate_input.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,4 @@
+Culture Label,Cell Count,Dilution
+ECo-1,2523,1000
+LPn-1,100,1000000
+LPn-2,4,1000
diff -r 000000000000 -r 58ed60d20336 test-data/awk_mutate_output.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/awk_mutate_output.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,4 @@
+Culture Label,Cell Count,Dilution,CFU/ml
+ECo-1,2523,1000,2523000
+LPn-1,100,1000000,100000000
+LPn-2,4,1000,4000
diff -r 000000000000 -r 58ed60d20336 test-data/blood_type.tsv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/blood_type.tsv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,11 @@
+Name Blood_Type Favourite_Colour Height
+Darian AB Blue 175cm
+Fred AB- Orange 185cm
+Jacob AB Blue 160cm
+Adrian O Blue 2000cm
+Tim O- Green 20cm
+Matthew O Green 140cm
+Patrick O Green 1cm
+Chester O Blue 22cm
+Kim B Teal 11cm
+Sarah A Blue 123cm
diff -r 000000000000 -r 58ed60d20336 test-data/collapsed.tsv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/collapsed.tsv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,7 @@
+Blood_Type Name
+AB- Fred
+AB Darian; Jacob
+O- Tim
+O Adrian; Matthew; Patrick; Chester
+B Kim
+A Sarah
diff -r 000000000000 -r 58ed60d20336 test-data/concat_1.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/concat_1.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,11 @@
+Name,Colour,Food
+Eric,Blue,Apples
+Darian,Blue,Pancakes
+Daniel,Red,Apples
+Emily,Blue,Apples
+Fred,-,-
+Adrian,-,-
+Steven,-,-
+Joe,-,Beets
+Steven,-,Eggplant
+Jacob,-,Kale
diff -r 000000000000 -r 58ed60d20336 test-data/concat_2.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/concat_2.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,11 @@
+Name,Colour,Food
+Eric,Blue,Apples
+Darian,Blue,Pancakes
+Daniel,Red,Apples
+Emily,Blue,Apples
+Fred,,
+Adrian,,
+Steven,,
+Joe,,Beets
+Steven,,Eggplant
+Jacob,,Kale
diff -r 000000000000 -r 58ed60d20336 test-data/corr_1.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/corr_1.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,1 @@
+X,Y,0.9960
diff -r 000000000000 -r 58ed60d20336 test-data/corr_2.tsv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/corr_2.tsv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,1 @@
+X Y 0.9997
diff -r 000000000000 -r 58ed60d20336 test-data/csv-bob.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/csv-bob.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,2 @@
+Person,Favourite Food,Favourite Colour,Height,BloodType
+Bob,Protein,All of them,250cm,O-
diff -r 000000000000 -r 58ed60d20336 test-data/csv-darian.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/csv-darian.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,2 @@
+Person,Favourite Food,Favourite Colour,Height,BloodType
+Darian,Potatos,Blue,175cm,O
diff -r 000000000000 -r 58ed60d20336 test-data/csv-jack.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/csv-jack.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,2 @@
+Person,Favourite Food,Favourite Colour,Height,BloodType
+Jack,Pineapple,Off White,165cm,O
diff -r 000000000000 -r 58ed60d20336 test-data/csv.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/csv.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,4 @@
+Person,Favourite Food,Favourite Colour,Height,BloodType
+Jack,Pineapple,Off White,165cm,O
+Bob,Protein,All of them,250cm,O-
+Darian,Potatos,Blue,175cm,O
diff -r 000000000000 -r 58ed60d20336 test-data/cut_1.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/cut_1.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,33 @@
+Length,GC Content
+100,50.00
+100,50.05
+100,49.95
+110,50.60
+105,50.50
+101,49.05
+99,49.95
+95,50.95
+100,50.00
+100,50.00
+90,66.00
+100,66.60
+100,65.05
+101,65.95
+101,65.55
+99,66.00
+95,66.05
+100,66.55
+105,65.55
+100,65.55
+110,66.55
+110,70.00
+100,70.00
+90,45.65
+99,45.60
+99,45.50
+95,45.20
+95,45.55
+100,45.55
+100,45.20
+100,45.55
+100,45.50
diff -r 000000000000 -r 58ed60d20336 test-data/cut_2.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/cut_2.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,33 @@
+Group,GC Content
+A,50.00
+A,50.05
+A,49.95
+A,50.60
+A,50.50
+A,49.05
+A,49.95
+A,50.95
+A,50.00
+A,50.00
+B,66.00
+B,66.60
+B,65.05
+B,65.95
+B,65.55
+B,66.00
+B,66.05
+B,66.55
+B,65.55
+B,65.55
+B,66.55
+C,70.00
+C,70.00
+D,45.65
+D,45.60
+D,45.50
+D,45.20
+D,45.55
+D,45.55
+D,45.20
+D,45.55
+D,45.50
diff -r 000000000000 -r 58ed60d20336 test-data/data.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/data.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,4 @@
+Person,Height,Sport,Job
+Fred,140cm,Diving,Accountant
+Darian,175cm,Running,Student
+Jake,188cm,Shotput,Moving Heavy Objects
diff -r 000000000000 -r 58ed60d20336 test-data/filtered.tsv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/filtered.tsv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,4 @@
+Blood_Type Favourite_Colour frequency
+AB Blue 2
+O Green 2
+O Blue 2
diff -r 000000000000 -r 58ed60d20336 test-data/frequency.tsv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/frequency.tsv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,8 @@
+Blood_Type Favourite_Colour frequency
+AB- Orange 1
+AB Blue 2
+O- Green 1
+O Green 2
+O Blue 2
+B Teal 1
+A Blue 1
diff -r 000000000000 -r 58ed60d20336 test-data/gathered.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/gathered.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,4 @@
+Favourite Food,Favourite Colour,Height,BloodType,1,2
+Pineapple,Off White,165cm,O,Person,Jack
+Protein,All of them,250cm,O-,Person,Bob
+Potatos,Blue,175cm,O,Person,Darian
diff -r 000000000000 -r 58ed60d20336 test-data/illegal.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/illegal.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,6 @@
+Test,A,B,C
+D,,S,C
+F,F,F,F
+F,F,F,
+TT,TT,TT,TT
+Agh,Ol,As,TT
\ No newline at end of file
diff -r 000000000000 -r 58ed60d20336 test-data/illegal_collapse.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/illegal_collapse.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,5 @@
+C,Test
+C,D
+F,F
+,F
+TT,TT; Agh
diff -r 000000000000 -r 58ed60d20336 test-data/joined.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/joined.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,2 @@
+Person,Favourite Food,Favourite Colour,Height,BloodType,Height,Sport,Job
+Darian,Potatos,Blue,175cm,O,175cm,Running,Student
diff -r 000000000000 -r 58ed60d20336 test-data/joined_filled.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/joined_filled.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,6 @@
+Person,Favourite Food,Favourite Colour,Height,BloodType,Height,Sport,Job
+Jack,Pineapple,Off White,165cm,O,a,a,a
+Bob,Protein,All of them,250cm,O-,a,a,a
+Darian,Potatos,Blue,175cm,O,175cm,Running,Student
+Fred,a,a,a,a,140cm,Diving,Accountant
+Jake,a,a,a,a,188cm,Shotput,Moving Heavy Objects
diff -r 000000000000 -r 58ed60d20336 test-data/kv.txt
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/kv.txt Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,3 @@
+Key Value
+Dog Big
+Cat Small
\ No newline at end of file
diff -r 000000000000 -r 58ed60d20336 test-data/line_all_param.png
Binary file test-data/line_all_param.png has changed
diff -r 000000000000 -r 58ed60d20336 test-data/mutate_removed.tsv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/mutate_removed.tsv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,11 @@
+Blood_Type Favourite_Colour Height new_column
+AB Blue 175cm Darian
+AB- Orange 185cm
+AB Blue 160cm
+O Blue 2000cm
+O- Green 20cm
+O Green 140cm
+O Green 1cm
+O Blue 22cm
+B Teal 11cm
+A Blue 123cm
diff -r 000000000000 -r 58ed60d20336 test-data/mutated.tsv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/mutated.tsv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,11 @@
+Name Blood_Type Favourite_Colour Height new_column
+Darian AB Blue 175cm Darian
+Fred AB- Orange 185cm Fred
+Jacob AB Blue 160cm Jacob
+Adrian O Blue 2000cm Adrian
+Tim O- Green 20cm Tim
+Matthew O Green 140cm Matthew
+Patrick O Green 1cm Patrick
+Chester O Blue 22cm Chester
+Kim B Teal 11cm Kim
+Sarah A Blue 123cm Sarah
diff -r 000000000000 -r 58ed60d20336 test-data/other.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/other.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,4 @@
+Name,Sport,Job
+Fred,Volleyball,Molecular Biologist
+Adrian,Basketball,Computational Biologist
+Steven,Football,Microbiologist
\ No newline at end of file
diff -r 000000000000 -r 58ed60d20336 test-data/plot.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/plot.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,33 @@
+Group,Length,GC Content
+A,100,50.00
+A,100,50.05
+A,100,49.95
+A,110,50.60
+A,105,50.50
+A,101,49.05
+A,99,49.95
+A,95,50.95
+A,100,50.00
+A,100,50.00
+B,90,66.00
+B,100,66.60
+B,100,65.05
+B,101,65.95
+B,101,65.55
+B,99,66.00
+B,95,66.05
+B,100,66.55
+B,105,65.55
+B,100,65.55
+B,110,66.55
+C,110,70.00
+C,100,70.00
+D,90,45.65
+D,99,45.60
+D,99,45.50
+D,95,45.20
+D,95,45.55
+D,100,45.55
+D,100,45.20
+D,100,45.55
+D,100,45.50
\ No newline at end of file
diff -r 000000000000 -r 58ed60d20336 test-data/plot.png
Binary file test-data/plot.png has changed
diff -r 000000000000 -r 58ed60d20336 test-data/plot_box.png
Binary file test-data/plot_box.png has changed
diff -r 000000000000 -r 58ed60d20336 test-data/plot_scatter.png
Binary file test-data/plot_scatter.png has changed
diff -r 000000000000 -r 58ed60d20336 test-data/replace_1.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/replace_1.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,4 @@
+Name,Animal
+Shirley,1-Dog
+Mittens,2-Cat
+Fuzzy,3-Chinchilla
diff -r 000000000000 -r 58ed60d20336 test-data/replace_2.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/replace_2.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,4 @@
+Name,Animal
+Shirley,Big
+Mittens,Small
+Fuzzy,Chinchilla
diff -r 000000000000 -r 58ed60d20336 test-data/replace_input.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/replace_input.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,4 @@
+Name,Animal
+Shirley,Dog
+Mittens,Cat
+Fuzzy,Chinchilla
diff -r 000000000000 -r 58ed60d20336 test-data/sampled_1.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/sampled_1.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,16 @@
+Group,Length,GC Content
+A,100,50.00
+A,101,49.05
+A,100,50.00
+A,100,50.00
+B,90,66.00
+B,100,66.60
+B,101,65.55
+B,99,66.00
+B,105,65.55
+D,90,45.65
+D,99,45.60
+D,99,45.50
+D,95,45.20
+D,95,45.55
+D,100,45.20
diff -r 000000000000 -r 58ed60d20336 test-data/sampled_2.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/sampled_2.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,25 @@
+n,Group,Length,GC Content
+1,A,100,50.00
+4,A,110,50.60
+5,A,105,50.50
+6,A,101,49.05
+9,A,100,50.00
+10,A,100,50.00
+11,B,90,66.00
+12,B,100,66.60
+13,B,100,65.05
+14,B,101,65.95
+15,B,101,65.55
+16,B,99,66.00
+19,B,105,65.55
+20,B,100,65.55
+22,C,110,70.00
+24,D,90,45.65
+25,D,99,45.60
+26,D,99,45.50
+27,D,95,45.20
+28,D,95,45.55
+29,D,100,45.55
+30,D,100,45.20
+31,D,100,45.55
+32,D,100,45.50
diff -r 000000000000 -r 58ed60d20336 test-data/separated_1.tsv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/separated_1.tsv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,7 @@
+Blood_Type 1 2
+AB- Fred NA
+AB Darian Jacob
+O- Tim NA
+O Adrian Matthew
+B Kim NA
+A Sarah NA
diff -r 000000000000 -r 58ed60d20336 test-data/separated_2.tsv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/separated_2.tsv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,7 @@
+Blood_Type Name 1 2
+AB- Fred Fred N/A
+AB Darian; Jacob Darian Jacob
+O- Tim Tim N/A
+O Adrian; Matthew; Patrick; Chester Adrian Matthew; Patrick; Chester
+B Kim Kim N/A
+A Sarah Sarah N/A
diff -r 000000000000 -r 58ed60d20336 test-data/sort_order.txt
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/sort_order.txt Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,3 @@
+Zebra
+Cat
+Dog
diff -r 000000000000 -r 58ed60d20336 test-data/sorted_1.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/sorted_1.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,10 @@
+Name,Animal,Random_Number
+Stripes,Zebra,7
+Mittens,Cat,16
+Slippers,Cat,11
+Muffin,Cat,7
+Gravy,Cat,6
+Sir-Wags-A-Lot,Dog,44
+Fred,Dog,5
+Earl,Dog,2
+Spots,Dog,1
diff -r 000000000000 -r 58ed60d20336 test-data/test.csv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/test.csv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,5 @@
+Name,Colour,Food
+Eric,Blue,Apples
+Darian,Blue,Pancakes
+Daniel,Red,Apples
+Emily,Blue,Apples
\ No newline at end of file
diff -r 000000000000 -r 58ed60d20336 test-data/uniq.tsv
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/test-data/uniq.tsv Tue May 19 17:23:16 2020 -0400
@@ -0,0 +1,8 @@
+Name Blood_Type Favourite_Colour Height
+Darian AB Blue 175cm
+Fred AB- Orange 185cm
+Adrian O Blue 2000cm
+Tim O- Green 20cm
+Matthew O Green 140cm
+Kim B Teal 11cm
+Sarah A Blue 123cm