Name | sscsv JSON |
Version |
0.1.1
JSON |
| download |
home_page | https://github.com/sumeshi/sscsv |
Summary | A tool designed for rapid data processing and filtering, specifically tailored for handling CSV files for log analysis. |
upload_time | 2024-06-28 17:40:31 |
maintainer | None |
docs_url | None |
author | sumeshi |
requires_python | <4.0,>=3.11 |
license | MIT |
keywords |
security
dfir
csv
|
VCS |
![](/static/img/github-24-000000.png) |
bugtrack_url |
|
requirements |
No requirements were recorded.
|
Travis-CI |
No Travis.
|
coveralls test coverage |
No coveralls.
|
# snip-snap-csv
[![MIT License](http://img.shields.io/badge/license-MIT-blue.svg?style=flat)](LICENSE)
A tool designed for rapid data processing and filtering, specifically tailored for handling CSV files for log analysis.
> [!NOTE]
> This project is in the early stages of development. Please be aware that frequent changes and updates are likely to occur.
## Usage
```bash
$ sscsv {{initializer}} {{Arguments}} - {{chainable}} {{Arguments}} - {{chainable}} {{Arguments}} - {{finalizer}} {{Arguments}}
```
e.g.
Below is an example of reading a CSV file, extracting rows that contain 4624 in the EventID column, and displaying the top 3 rows them sorted by the Timestamp column.
```bash
$ sscsv load Security.csv - isin 'Event ID' 4624 - sort 'Date and Time' - head 3
2024-06-26T17:29:19+0000 [DEBUG] 1 files are loaded. Security.csv
2024-06-26T17:29:19+0000 [DEBUG] filter condition: 4624 in Event ID
2024-06-26T17:29:19+0000 [DEBUG] sort by Date and Time (asc).
2024-06-26T17:29:19+0000 [DEBUG] heading 3 lines.
shape: (3, 5)
┌─────────────┬───────────────────────┬─────────────────────────────────┬──────────┬───────────────┐
│ Level ┆ Date and Time ┆ Source ┆ Event ID ┆ Task Category │
│ --- ┆ --- ┆ --- ┆ --- ┆ --- │
│ str ┆ str ┆ str ┆ i64 ┆ str │
╞═════════════╪═══════════════════════╪═════════════════════════════════╪══════════╪═══════════════╡
│ Information ┆ 10/6/2016 01:00:55 PM ┆ Microsoft-Windows-Security-Aud… ┆ 4624 ┆ Logon │
│ Information ┆ 10/6/2016 01:04:05 PM ┆ Microsoft-Windows-Security-Aud… ┆ 4624 ┆ Logon │
│ Information ┆ 10/6/2016 01:04:10 PM ┆ Microsoft-Windows-Security-Aud… ┆ 4624 ┆ Logon │
└─────────────┴───────────────────────┴─────────────────────────────────┴──────────┴───────────────┘
```
## Archtecture
```
initializer -> chainable manipulations... -> finalizer
```
### initializer
- load
### chainable manipulation
- select
- isin
- contains
- head
- tail
- sort
- changetz
### finalizer
- headers
- stat
- showquery
- show
- dump
## Planned Features:
- CSV cache (.pkl)
- Filtering based on specific conditions (OR, AND conditions)
- Grouping for operations like count
- Joining with other tables
- Config Batch
- Export Config
## License
snip-snap-csv is released under the [MIT](https://github.com/sumeshi/snip-snap-csv/blob/master/LICENSE) License.
Raw data
{
"_id": null,
"home_page": "https://github.com/sumeshi/sscsv",
"name": "sscsv",
"maintainer": null,
"docs_url": null,
"requires_python": "<4.0,>=3.11",
"maintainer_email": null,
"keywords": "Security, DFIR, CSV",
"author": "sumeshi",
"author_email": "sum3sh1@protonmail.com",
"download_url": "https://files.pythonhosted.org/packages/fb/02/31d69fcc14fca9db88101bfcb6d6287000d067de23ecff2de7699a7cf4bf/sscsv-0.1.1.tar.gz",
"platform": null,
"description": "# snip-snap-csv\n[![MIT License](http://img.shields.io/badge/license-MIT-blue.svg?style=flat)](LICENSE)\n\nA tool designed for rapid data processing and filtering, specifically tailored for handling CSV files for log analysis.\n\n> [!NOTE] \n> This project is in the early stages of development. Please be aware that frequent changes and updates are likely to occur.\n\n\n## Usage\n```bash\n$ sscsv {{initializer}} {{Arguments}} - {{chainable}} {{Arguments}} - {{chainable}} {{Arguments}} - {{finalizer}} {{Arguments}}\n```\n\ne.g.\nBelow is an example of reading a CSV file, extracting rows that contain 4624 in the EventID column, and displaying the top 3 rows them sorted by the Timestamp column.\n```bash\n$ sscsv load Security.csv - isin 'Event ID' 4624 - sort 'Date and Time' - head 3\n2024-06-26T17:29:19+0000 [DEBUG] 1 files are loaded. Security.csv\n2024-06-26T17:29:19+0000 [DEBUG] filter condition: 4624 in Event ID\n2024-06-26T17:29:19+0000 [DEBUG] sort by Date and Time (asc).\n2024-06-26T17:29:19+0000 [DEBUG] heading 3 lines.\nshape: (3, 5)\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502 Level \u2506 Date and Time \u2506 Source \u2506 Event ID \u2506 Task Category \u2502\n\u2502 --- \u2506 --- \u2506 --- \u2506 --- \u2506 --- \u2502\n\u2502 str \u2506 str \u2506 str \u2506 i64 \u2506 str \u2502\n\u255e\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u256a\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u256a\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u256a\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u256a\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2561\n\u2502 Information \u2506 10/6/2016 01:00:55 PM \u2506 Microsoft-Windows-Security-Aud\u2026 \u2506 4624 \u2506 Logon \u2502\n\u2502 Information \u2506 10/6/2016 01:04:05 PM \u2506 Microsoft-Windows-Security-Aud\u2026 \u2506 4624 \u2506 Logon \u2502\n\u2502 Information \u2506 10/6/2016 01:04:10 PM \u2506 Microsoft-Windows-Security-Aud\u2026 \u2506 4624 \u2506 Logon \u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n```\n\n\n## Archtecture\n```\ninitializer -> chainable manipulations... -> finalizer\n```\n\n### initializer\n- load\n\n### chainable manipulation\n- select\n- isin\n- contains\n- head\n- tail\n- sort\n- changetz\n\n### finalizer\n- headers\n- stat\n- showquery\n- show\n- dump\n\n## Planned Features:\n- CSV cache (.pkl)\n- Filtering based on specific conditions (OR, AND conditions)\n- Grouping for operations like count\n- Joining with other tables\n- Config Batch\n- Export Config\n\n## License\nsnip-snap-csv is released under the [MIT](https://github.com/sumeshi/snip-snap-csv/blob/master/LICENSE) License.\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "A tool designed for rapid data processing and filtering, specifically tailored for handling CSV files for log analysis.",
"version": "0.1.1",
"project_urls": {
"Homepage": "https://github.com/sumeshi/sscsv",
"Repository": "https://github.com/sumeshi/sscsv"
},
"split_keywords": [
"security",
" dfir",
" csv"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "c53ee0d8150c9b3f8909838f418d38c0fe0f11eb5648594065d737af6266e6e7",
"md5": "87908594f9b263524f7890b248043e00",
"sha256": "ebd87b5b819484d7853c286475424534d49158f77aa58403eab88de9af761064"
},
"downloads": -1,
"filename": "sscsv-0.1.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "87908594f9b263524f7890b248043e00",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<4.0,>=3.11",
"size": 6035,
"upload_time": "2024-06-28T17:40:29",
"upload_time_iso_8601": "2024-06-28T17:40:29.812063Z",
"url": "https://files.pythonhosted.org/packages/c5/3e/e0d8150c9b3f8909838f418d38c0fe0f11eb5648594065d737af6266e6e7/sscsv-0.1.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "fb0231d69fcc14fca9db88101bfcb6d6287000d067de23ecff2de7699a7cf4bf",
"md5": "c35d70e86f6c6da185dfec55a6c6b4d0",
"sha256": "6c62ecf97f3e72a68057f0ad7988a164eaa7db0900135e38a15237aedc6090de"
},
"downloads": -1,
"filename": "sscsv-0.1.1.tar.gz",
"has_sig": false,
"md5_digest": "c35d70e86f6c6da185dfec55a6c6b4d0",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "<4.0,>=3.11",
"size": 4704,
"upload_time": "2024-06-28T17:40:31",
"upload_time_iso_8601": "2024-06-28T17:40:31.254702Z",
"url": "https://files.pythonhosted.org/packages/fb/02/31d69fcc14fca9db88101bfcb6d6287000d067de23ecff2de7699a7cf4bf/sscsv-0.1.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-06-28 17:40:31",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "sumeshi",
"github_project": "sscsv",
"github_not_found": true,
"lcname": "sscsv"
}