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)
- `slice`: add a `--json` flag for JSON output HOT 4
- BUG Incorrect delimiter in qsv sniff HOT 8
- qsv validate - valid pass feature request HOT 2
- What would it take to get `foreach` working on Windows? HOT 5
- `stats` & `frequency`: add a `--json` flag for JSON output
- `foreach`: add `--dry-run` option HOT 1
- qsv count HOT 1
- Locating.installing qsv HOT 2
- sql windows functions HOT 7
- add `--no-headers` support to qsv cat rowskey HOT 2
- group by HOT 1
- `frequency`: add `--other` option HOT 5
- `luau`: additional helper functions
- `search`: add preview and JSON options HOT 1
- `search` & `searchset`: when a CSV is indexed, parallelize search
- partition file into files with n rows each (except for last file) HOT 7
- `stats` command writes output file even when `--output` is not set HOT 7
- `stats`: Max precision for float types HOT 5
- sqlp selects wrong data when multiple tables have the same named column HOT 8
- Getting "usage error: " prepended to help messages for commands HOT 1
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.