csvkit

csvkit copied to clipboard

I am using `csvkit` through conda to reorder some columns in a TSV file: ``` csvcut -t -c 12,1-10 input.tsv | csvformat -T > output.tsv ``` and it all works...

fgvieira

csvsql: Add option to use ON CONFLICT DO NOTHING/UPDATE

2

I'm using csvsql to insert into to a Postregress database, and I'd like it to ignore any errors generated from unique constraints (basically skip importing the same data twice). In...

jschuur

[WIP] if csvstack files have headers, union the headers and align data

2

This PR will address #245. If the files input to csvstack have headers, then csvstack will create a header that is the union of those headers and align the data...

fgregg

I have CSV with 2 headers, like this: ``` KPI,KPI,KPI kpi1,kpi2,kpi3 1.11,2.22,3.33 ``` and I'd like to add a new column with commit hash. ``` csvstack -n COMMIT -g 12345...

vitalyk-multinarity

``` $ in2csv -p % -f ndjson test.txt > test.csv Error: need to escape, but no escapechar set ``` But I provided a escapechar! By reducing the input file I...

hmijail

Feature request to convert xlsx format with merged row cells to csv. Current behavior appears to be converting to empty except for the first cell that has the data. Unless...

christopinka

Python 3 changes, simplifications and updates for standard

marksmayo

Ingres support is available in https://github.com/wireservice/agate-sql/pull/36 Documenting here for search reasons, csvkit database support is handled in agate-sql.

clach04

csvsql: Add error/warning if no input provided

1

I not getting any feedback from these commands. How could I troubleshoot further what is really happening? Tried both 1 - PS C:\Users\goldman> csvsql -v --db postgresql://xxx:[email protected]:5432/u2020 --query "SELECT *...

goldman7911

Could a feature be added to do csvsort but ignore case (basically like a `sort -f`)?

karlbrown-va