# xsv - CLI용 CSV파일 처리도구

> Clean Markdown view of GeekNews topic #1197. Use the original source for factual precision when an external source URL is present.

## Metadata

- GeekNews HTML: [https://news.hada.io/topic?id=1197](https://news.hada.io/topic?id=1197)
- GeekNews Markdown: [https://news.hada.io/topic/1197.md](https://news.hada.io/topic/1197.md)
- Type: news
- Author: [xguru](https://news.hada.io/@xguru)
- Published: 2020-01-02T09:15:15+09:00
- Updated: 2020-01-02T09:15:15+09:00
- Original source: [github.com](https://github.com/BurntSushi/xsv)
- Points: 4
- Comments: 2

## Topic Body

CSV파일을 DB처럼 사용하게 만들어주는 CLI도구. Rust오픈소스

파일합치기,줄수세기,고정폭만들기,재포맷(딜리미터 변경등),

join(inner,outer,cross),컬럼값 파티셔닝,샘플링,역순,특정 컬럼 추출,컬럼 재정렬,

sort,분할(N개의 파일로),stats(각 컬럼별 평균,분산,중간값,범위등),테이블형태로 보기

## Comments



### Comment 830

- Author: iolothebard
- Created: 2020-01-02T11:40:03+09:00
- Points: 1

spark on local?!

### Comment 827

- Author: xguru
- Created: 2020-01-02T09:15:34+09:00
- Points: 1

데이터 분석시 CSV 데이터를 정제할때 쓰면 좋을듯

SQL 형태의 조인하기 예제 -  https://www.johndcook.com/blog/2019/12/31/sql-join-csv-files/