Skip to content
#

CSV

CSV is a common data exchange format that stores tabular data in a plain text file. A CSV file stores the data in a delimited text file that uses commas to separate the values.

Here are 3,709 public repositories matching this topic...

sheetjs
DamirKh
DamirKh commented Nov 14, 2019

It would be great to have the option "skip N lines", since CSV files often contain not commented headers. Can this be implemented?
For example:

This is a data file generated by some old software.
Next line will contain a headers of parameters.
Temperature, Humidity, Voltage
22.5, 45.5, 220
23.0, 44.0, 219
...
In such case "skipLines: 2" could be added to con

trantor
trantor commented Jan 23, 2020

Hello.
I've come across what (to me) seems to be a problem with the FILENAME and FILENUM variables.

# mlr --version
Miller v5.6.2

# cat /tmp/csv1
A,B,C
_2GB,255,2
_4GB,120,4
_6GB,50,6
_10GB,10,10

# cat /tmp/csv2
FIRST,SECOND,THIRD,FOURTH
1,2,3,4
5,6,7,8
9,10,11,12
13,14,15,16

# mlr --icsv cat then put 'print FILENAME'   /tmp/csv1 /tmp/csv2
/tmp/csv1
A=_2GB,B=255,C=2
/
mbloch
mbloch commented Jan 14, 2019

Lack of documentation is a problem for most users. I have a few ideas for how to improve the documentation.

  • There should be more examples.
  • Examples should all be runnable, and sample input data should be downloadable.
  • The documentation should include articles on important topics, for example, coordinate systems, simplification methods, and how to use JavaScript expressions as arguments
metasoarous
metasoarous commented Nov 25, 2019

First off, thanks so much for tad; All in all I'm loving it as a light weight CSV viewer!

The only issue I've had so far is that someone passed me a semi-colon delimited file with some decimals, and strangely, these numbers load as ints unless I replace the semi-colons with commas. Any thoughts what might be going on here?

Thanks again!

Jemi
Jemi commented Feb 18, 2020

I'm using tsv-utils from the arch linux aur, trying to format some word frequency data from the new general services list dataset. tsv-utils makes at least two errors that I'm able to see when I'm running this commandline:

tsv-select -f 1,7 NGSL+1.01+with+SFI.tsv | tsv-pretty | less

adding -s 5 to tsv-pretty works around this problem. The tsv file was converted from the file NGSL+1.01+with

westonganger
westonganger commented Jun 29, 2018

It would be a huge improvement to the test suite if the tests validated the xml/txt contents of the spreadsheets automatically instead of requiring a manual look at the test spreadsheets.

I would love any PR's or contributions that could help improve our tests. Some test examples to get started could be found within the axlsx and [rodf](https://github.com

Wikipedia
Wikipedia

Related Topics

tsv
You can’t perform that action at this time.