English | 中文
Rust Data Processing Toolbox, base on Tauri.
-
command
-
polars SQL for query
-
CSV to xlsx
-
Excel to CSV
-
Cat
-
Rename
| Function | Description |
|---|---|
| Sqlp | Execute Polars SQL queries against several files (Support Excel, CSV, Parquet) |
| Apply | Apply series of string, math transformations to given CSV column/s |
| Cat | Merge multiple CSV or Excel files into one CSV or xlsx file (Support Polars and CSV engine) |
| Excel to CSV | Batch convert Excel to CSV (Support converting all sheets or specifying sheets) |
| Count | Count the rows of CSV files (Instantaneous with an index) |
| CSV to xlsx | Batch convert CSV to xlsx |
| Rename | Rename the columns of a CSV |
| Select | Select, re-order columns |
| Search | Match the corresponding row in a column (equal, contains, startswith, regex) |
| Fill | Fill empty fields in selected columns of a CSV |
| Split | Split one CSV file into many CSV files (by rows or by lines, uses multithreading to go faster if an index is present when splitting by rows) |
| Skip | Skip rows form CSV |
| Enumerate | Add a new column enumerating the lines of a CSV file |
| Chinese to Pinyin | Convert Chinese to Pinyin for specific column in CSV. |
| Replace | Replace CSV data using a regex |
| Join | Joins two sets of CSV data on the specified columns |
| Sort | Sorts CSV data lexicographically |
| Slice | Slicing of CSV column (like pandas str.slice and str.split('').str[n]) |
- For more details, please refer to release
- Node.js 18+
- pnpm 9.9.0+
- 🦀Rust 1.85.0+
-
Clone this repositories
git clone https://github.com/tansen87/InsightSQL.git
-
cd to the directory of the project
cd InsightSQL -
Install dependencies
pnpm i
-
Development
pnpm tauri:dev
-
Build
pnpm tauri:build
- bilibili (The video hasn't been updated for a long time)