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...
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
-
Updated
Mar 14, 2020 - PHP
-
Updated
Mar 14, 2020 - JavaScript
-
Updated
Feb 12, 2020 - Python
Just a minor correction. You repeat the word to in the help that is printed as an answer to xsv cat -h:
... the result is always equivalent **to to** the minimum number of rows ...
-
Updated
Feb 22, 2020
-
Updated
Jan 29, 2020 - C++
-
Updated
Mar 15, 2020 - C#
Tabula API version: 1.2.1.18052200
Filename: 3_2019년_통계부록.pdf
Internal Server Error (500)
Request Method:
POST
Request URL:
http://127.0.0.1:8080/pdf/8a6599b3be99fda826cc0448d74f0f74dfd3d78d/data
lines must be orthogonal, vertical and horizontal
Got this while extracting table
[pdf file](https://drive.google.com/fil
In #683 I started a new section of internals documentation covering the Database class: https://datasette.readthedocs.io/en/latest/internals.html#database-class
I decided not to document .execute() and .execute_against_connection_in_thread() yet because I'm not 100% happy with their API design yet.
-
Updated
Jan 7, 2020 - PHP
-
Updated
Mar 11, 2020 - PHP
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
/
Better documentation
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
MSSQL Storage
Hi there,
Very interesting tools. Thank you in advance.
I see that MSSQL is not in the roadmap.
How could it be implemented? Adding a dedicated datastore would be enough?
I could eventually help in the process
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!
I construct it using BoolVal : []bool{fasle}, with shape dim size = 1, but it has errors like behind:
The second input must be a scalar, but it has shape [1]
I don't know how to solve it.
-
Updated
Jan 14, 2020 - Java
Hi, minor issue in the "Add asynchronous line by line processing support" (link to example) documentation.
The feature detail example:.
csv()
.fromFile(csvFilePath)
.subscribe((json,lineNumber)=>{
return Promise((resolve,reject)=>{
})
},-
Updated
Mar 16, 2020 - JavaScript
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
-
Updated
Mar 4, 2020 - C#
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
There is a difference in
safegetzipfilemethod between xlsx.js & xlsx.mini.js.One is missing
replace(/^Root Entry[\/]/,"")so I get this error "Cannot find file [Content_Types].xml in zip" ev