下拉刷新
Repository Details
Shared bynavbar_avatar
repo_avatar
HelloGitHub Rating
0 ratings
用 SQL 方式查询 CSV 文件的命令行工具
FreeGPL-3.0
Claim
Collect
Share
10.2k
Stars
No
Chinese
Python
Language
No
Active
25
Contributors
118
Issues
No
Organization
3.1.6
Latest
423
Forks
GPL-3.0
License
More
用 SQL 方式查询 CSV 文件的命令行工具。支持 where、group_by、join 查询和中文等多种字符编码,还可以把查询结果转存到数据库。终于不用为产品临下班,扔来的 CSV 文件而加班啦 ``` q "SELECT COUNT(*) FROM ./clicks_file.csv WHERE c3 > 32.3" ps -ef | q -H "SELECT UID,COUNT(*) cnt FROM - GROUP BY UID ORDER BY cnt DESC" ```
Included in:
Vol.67
Tags:
SQL
CLI
CSV
Python

Comments

Rating:
No comments yet