A tool designed for rapid data processing and filtering, specifically tailored for handling CSV files for log analysis.
Project description
snip-snap-csv
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
$ 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.
$ 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 License.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file sscsv-0.1.1.tar.gz
.
File metadata
- Download URL: sscsv-0.1.1.tar.gz
- Upload date:
- Size: 4.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.8.3 CPython/3.11.9 Linux/6.5.0-1022-azure
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6c62ecf97f3e72a68057f0ad7988a164eaa7db0900135e38a15237aedc6090de |
|
MD5 | c35d70e86f6c6da185dfec55a6c6b4d0 |
|
BLAKE2b-256 | fb0231d69fcc14fca9db88101bfcb6d6287000d067de23ecff2de7699a7cf4bf |
File details
Details for the file sscsv-0.1.1-py3-none-any.whl
.
File metadata
- Download URL: sscsv-0.1.1-py3-none-any.whl
- Upload date:
- Size: 6.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.8.3 CPython/3.11.9 Linux/6.5.0-1022-azure
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | ebd87b5b819484d7853c286475424534d49158f77aa58403eab88de9af761064 |
|
MD5 | 87908594f9b263524f7890b248043e00 |
|
BLAKE2b-256 | c53ee0d8150c9b3f8909838f418d38c0fe0f11eb5648594065d737af6266e6e7 |