csvtk

csvtk copied to clipboard

As far as I know, there's no way to easily inspect the last `N` records of a `.csv` file in a way that includes the header. I assume this could...

apcamargo

Shuffle rows: csvtk shuf /or/ csvtk sort -R

3

I want to randomly re-order the rows in my CSV file. Basically unix `shuf` or `sort -R` but for xSV data. The actual use case is to shuffle the data...

tseemann

csvtk mutate2 flag to place new column at the very beginning

1

Feature request. E.g. csvtk mutate2 normal behaviour: ``` seq 1 10 | csvtk add-header -n foo | csvtk mutate2 -n bar -e '$foo + "yolo"' foo,bar 1,1yolo 2,2yolo 3,3yolo 4,4yolo...

avilella

feature request: csv2html

2

### Prerequisites - [x] make sure you're are using the latest version by `csvtk version` - [x] read the [usage](http://bioinf.shenwei.me/csvtk/usage/) ### Describe your issue * [x] describe the problem *...

tseemann

support open column range syntax for more commands

1

The `cut` command supports an open column range like `3-` for all columns beginning with the third column. It would be great if more commands like `replace` would support this...

tolot27

[Feature request] uniq and join

2

Hi Wei, Can I request two more new features? 1. for `uniq`, supporting only keep duplicated or unique key entries, more like the feature of unix `uniq` 2. for join,...

wavefancy

Horizontal file concatenation

9

Hi, is there a way to concatenate two files horizontally? Starting from ``` field1,field2 0,a 1,b 3,a ``` and ``` field3,field4 0,a 1,b 3,a ``` obtain ``` field1,field2,field3,field4 0,a,0,a 1,b,1,b...

aborruso

xlsx2csv - controlling DATE output format

6

I have used `csvtk xlsx2csv` a few times. It ususally outputs dates as `YYYY-MM-DD` but yesterday i got one in USA format `MM-DD-YY` Does XLSX store the date in a...

tseemann

support date math with mutate2

8

Currently, `mutate2` accepts date strings and can do some math with it, i.e. subtracting seconds but it does not return date-formatted strings (see https://github.com/shenwei356/csvtk/issues/159#issuecomment-906996478). Even if it can do some...

tolot27

xlsx2csv: support replacing with regular expression before conversion

1

shenwei356