Repository Details
Shared by
HelloGitHub Rating
0 ratings
Free•GPL-3.0
Claim
Discuss
Collect
Share
10.2k
Stars
No
Chinese
Python
Language
No
Active
25
Contributors
119
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"
```
Comments
Rating:
No comments yet