A comprehensive Python tool for analyzing TSOC power system operational data from Excel files
Project description
TSOC Data Analysis
Author: Sustainable Power Systems Lab (SPSL), https://sps-lab.org, contact: info@sps-lab.org
A comprehensive Python tool for analyzing TSOC power system operational data from Excel files. Provides a powerful command-line interface (CLI) and modular Python API for load analysis, generator categorization, wind power analysis, reactive power calculations, and representative operating point extraction.
📖 Full Documentation
For complete installation instructions, detailed usage examples, configuration options, and troubleshooting, visit:
https://tsoc-data-analysis.sps-lab.org/
Quick Installation
pip install git+https://github.com/SPS-L/TSOC-data-analysis.git
Quick Start
Python API
from tsoc_data_analysis import execute, extract_representative_ops
# Load and analyze data
success, df = execute(month='2024-01', data_dir='raw_data', output_dir='results')
if success:
# Extract representative points
rep_df, diagnostics = extract_representative_ops(
df, max_power=450, MAPGL=200, output_dir='results'
)
Key Features
- Month-based data filtering for efficient processing
- Load calculations (Total Load, Net Load) with statistics
- Wind power analysis with generation profiles
- Generator categorization (Voltage Control vs PQ Control)
- Reactive power analysis with comprehensive calculations
- Data validation with advanced gap filling and anomaly detection
- Representative operating points extraction using K-means clustering
- Comprehensive logging and error handling
Requirements
- Python 3.7+
- pandas>=1.3.0, numpy>=1.20.0, matplotlib>=3.3.0, seaborn>=0.11.0
- openpyxl>=3.0.0, scikit-learn>=1.0.0, scipy>=1.7.0
- psutil>=5.8.0, joblib>=1.1.0
Documentation Sections
- Installation Guide - Detailed setup instructions
- User Guide - Getting started and basic workflow
- Configuration Guide - Customizing system parameters
- Examples - Code examples and workflows
- Troubleshooting - Common issues and solutions
Support
For detailed information, examples, and troubleshooting, please visit the full documentation.
License
Licensed under the Apache License 2.0. See LICENSE for details.
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
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file tsoc_data_analysis-1.2.0.tar.gz.
File metadata
- Download URL: tsoc_data_analysis-1.2.0.tar.gz
- Upload date:
- Size: 73.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.7
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a9be66451a786605edd2b6e15e56c274efdaa80ec856abbb4483faefc544d6ad
|
|
| MD5 |
e8b4bba7ee7e021d0dd2d696a2a64abf
|
|
| BLAKE2b-256 |
c2548aa121ffec6b71dd11dc202c33603f0c2a76c130879b2223c522be205f14
|
Provenance
The following attestation bundles were made for tsoc_data_analysis-1.2.0.tar.gz:
Publisher:
publish-pypi.yml on SPS-L/TSOC-data-analysis
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
tsoc_data_analysis-1.2.0.tar.gz -
Subject digest:
a9be66451a786605edd2b6e15e56c274efdaa80ec856abbb4483faefc544d6ad - Sigstore transparency entry: 499453160
- Sigstore integration time:
-
Permalink:
SPS-L/TSOC-data-analysis@e1ba8e318f4426ea7e2a71a90dad0e1c0446cbf2 -
Branch / Tag:
refs/tags/v1.2.0 - Owner: https://github.com/SPS-L
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish-pypi.yml@e1ba8e318f4426ea7e2a71a90dad0e1c0446cbf2 -
Trigger Event:
release
-
Statement type:
File details
Details for the file tsoc_data_analysis-1.2.0-py3-none-any.whl.
File metadata
- Download URL: tsoc_data_analysis-1.2.0-py3-none-any.whl
- Upload date:
- Size: 75.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.7
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a29eb4c4c015b420ed5655f68d44047315a46b1c200343ce0b6cd7989629fae6
|
|
| MD5 |
83ce6c062a87acd6ed38c99575f90118
|
|
| BLAKE2b-256 |
d18d7f9b9d79ab8f2de1c2e3808855a55b7f849b17747c3a5db0a5099272412f
|
Provenance
The following attestation bundles were made for tsoc_data_analysis-1.2.0-py3-none-any.whl:
Publisher:
publish-pypi.yml on SPS-L/TSOC-data-analysis
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
tsoc_data_analysis-1.2.0-py3-none-any.whl -
Subject digest:
a29eb4c4c015b420ed5655f68d44047315a46b1c200343ce0b6cd7989629fae6 - Sigstore transparency entry: 499453187
- Sigstore integration time:
-
Permalink:
SPS-L/TSOC-data-analysis@e1ba8e318f4426ea7e2a71a90dad0e1c0446cbf2 -
Branch / Tag:
refs/tags/v1.2.0 - Owner: https://github.com/SPS-L
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish-pypi.yml@e1ba8e318f4426ea7e2a71a90dad0e1c0446cbf2 -
Trigger Event:
release
-
Statement type: