Comments (3)
@aborruso I believe this already exists -- ?
$ cat a.csv
N,S,T,U
1,a,b,c
2,d,e,f
3,g,h,i
$ cat b.csv
N,X,Y,Z
1,l,m,n
2,o,p,q
3,r,s,t
$ mlr --csv join -j N -f a.csv b.csv
N,S,T,U,X,Y,Z
1,a,b,c,l,m,n
2,d,e,f,o,p,q
3,g,h,i,r,s,t
$ mlr --csv join -j N --lk N -f a.csv b.csv
N,X,Y,Z
1,l,m,n
2,o,p,q
3,r,s,t
$ mlr --csv join -j N --lk "" -f a.csv b.csv
N,X,Y,Z
1,l,m,n
2,o,p,q
3,r,s,t
from miller.
@aborruso I'll add a note to the online help for mlr join
from miller.
@aborruso I'll add a note to the online help for
mlr join
These last few issues of mine were all wrong, sorry.
But please add it, because I had no idea that if no field indicated, only the left ones would remain.
I had not even tested it, because I had taken the documentation literally.
Thank you very much
from miller.
Related Issues (20)
- Read performance can be improved for high-column-count data
- Investigate shutdown latency on `mlr head` HOT 2
- Cryptic fatal error message for nonexistent files since 6.9.0 HOT 2
- Investigate spurious `[]` on JSON output in some cases HOT 4
- `flatten` not working on csv input data
- Bash process substitution not working with `put -f`
- Miller's `strptime` accepts fewer format options than `strptime`
- Inconsistent result when using `$*`
- Double-width characters spoil column alignment HOT 4
- `mlr --icsv --ojson cat < mlr.bug.csv` drops some columns HOT 5
- Add description for "put" verb HOT 1
- 'mlr cut' is very slow HOT 8
- mlr --otsv does not handle broken quotes correctly compared to --ocsv HOT 6
- JSON to CSV Error HOT 8
- exit code = 1 for --csv skip-trivial-records and csv file's last record is blank
- Automated way of clearing down column data HOT 7
- JSON flag documentation question HOT 1
- Equivalent to Excel function "data load from folder" then "combine and load" multiple CSV's finally "apply transformations" HOT 7
- Find and remove "string" retaining all other row data HOT 5
- Find and replace special character & with and using ssub 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 miller.