Repository Details
Shared by
HelloGitHub Rating
0 ratings
用 SQL 方式查询 CSV 文件的命令行工具
Past 7 days Received 0 stars ✨
Use arrow keys to explore dates, Home and End for the first and last date, Escape to dismiss.| Date | Star | Daily change |
|---|---|---|
| 周二 | 10,360 | — |
| 周三 | 10,360 | 0 |
| 周四 | 10,361 | +1 |
| 周五 | 10,361 | 0 |
| 周六 | 10,361 | 0 |
| 周日 | 10,361 | 0 |
| 周一 | 10,360 | -1 |
10.4k
Stars
No
Chinese
Python
Language
No
Active
25
Contributors
132
Issues
No
Organization
None
Latest
424
Forks
GPL-3.0
License
用 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