A simple tool to get time series from spreadsheets
Project description
Cronus Eater: A simple tool to get time series from spreadsheets
Extract and normalize time series from any spreadsheet with differents patterns.
Where is the data I want?
import pandas as pd
raw_dataframe = pd.read_excel('historical_series_3Q22.xlsx')
raw_dataframe.head()
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |
---|---|---|---|---|---|---|---|---|---|---|
0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
1 | NaN | Holdings Ltd. | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
2 | NaN | NaN | NaN | NaN | 3Q22 | 2Q22 | NaN | 1Q22 | 2022 | NaN |
3 | NaN | Amounts in thousands of R$ | NaN | NaN | R$ | R$ | NaN | R$ | R$ | NaN |
4 | NaN | Cash Flow | NaN | NaN | $500.23 | $302.81 | $255.11 | $106.12 | $900.00 | NaN |
Let's devours this times series
import cronus_eater
times_series_df = cronus_eater.extract(raw_dataframe)
times_series_df.head()
Numeric Index | Label Index | Table Order | Time | Value | |
---|---|---|---|---|---|
0 | 4 | Cash Flow | 1 | 3Q22 | 302.81 |
1 | 4 | Cash Flow | 1 | 2Q22 | 255.11 |
2 | 4 | Cash Flow | 1 | 1Q22 | 106.12 |
3 | 4 | Cash Flow | 1 | 2017 | 900.00 |
Where to get it
The source code is currently hosted on GitHub at: https://github.com/breno-jesus-fernandes/cronus-eater
Binary installers for the latest released version is going to available at the Python Package Index (PyPI).
pip install cronus-eater
# or through poetry
poetry add cronus-eater
License
Contributing to Cronus Eater
All contributions, bug reports, bug fixes, documentation improvements, enhancements, and ideas are welcome. See https://github.com/breno-jesus-fernandes/cronus-eater/tree/main/docs for instructions.
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
cronus_eater-0.1.0a5.tar.gz
(8.6 kB
view hashes)
Built Distribution
Close
Hashes for cronus_eater-0.1.0a5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 04303a15360aefccbf66d24880175aaf458f54f7bf669359c2a9069e6ea19939 |
|
MD5 | 4c6ca41becd96714ae482c2a69d1df8f |
|
BLAKE2b-256 | 7a7d48b6d2fff6f3c27482218d34681b90d167bc242c6296ed897f5d43990f93 |