Comments (2)
Great question! Let's clarify that:
They do achieve similar results, but there's a subtle difference in how they concatenate and treat grouping.
cat rows
assumes that all CSV files have the same structure (same columns in the same order).
While rowskey
concatenates rows based on a specified key or column. It identifies a common key column in all csv files and merges the rows that share the same key. the group option introduces a grouping column indicating the source of each row.
So, technically, you are correct: qsv cat rows
is equivalent to qsv cat rowskey --group none
.
Both concatenate rows without introducing a special grouping column...
but the --group
option in qsv cat rowskey
becomes more relevant when you want to customize the grouping behavior, for example, grouping by the full file path, filename, or other options. If --group none is used, it essentially behaves like qsv cat rows.
I hope this helps clarify the difference! also qsv also has a very user-friendly website where you could learn more and test out this command
from qsv.
Thanks @a5dur for the expansive answer! Moving this to the Discussion area's FAQ section so other folks with the same query can find it easily.
from qsv.
Related Issues (20)
- BUG `to_parquet` feature disabled. HOT 4
- regex_replace to empty string? HOT 2
- `luau`: add advanced Excel writer helper functions HOT 3
- regression of musl-static builds for sqlp HOT 4
- csv repair and troubleshooting HOT 1
- qsv exclude misses rows with empty fields HOT 3
- Extended --group for qsv cat rowskey? HOT 3
- Add dedicated sum command with the group by (-by) and window by (-over) capability HOT 1
- Add fixed width format support HOT 9
- `sign`: command to sign and verify data using FIPS 186-5 standard HOT 1
- clipboard support HOT 1
- qsvdp musl builds crash since 0.120.0 HOT 16
- BUG `to` command is not available HOT 5
- Invalid arguments or "--filename argument must contain one '{}'" on split function HOT 1
- cat rowskey: Read list of files from stdin HOT 3
- Split based on maximum file size HOT 2
- more options for apply datefmt HOT 2
- join two tables, one with header one without header HOT 3
- more options for enum HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from qsv.