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.find_time_series(raw_dataframe)
times_series_df.head()
Numeric Index | Label Index | Table Order | Time | Value | |
---|---|---|---|---|---|
0 | 4 | Cash Flow | 1 | 4Q22 | 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
Documentation
You can find here
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.0a1.tar.gz
(8.3 kB
view hashes)
Built Distribution
Close
Hashes for cronus_eater-0.1.0a1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 37dd73f172ce5d6080763c5beb3720994648e175274a2465627bc1b992cc536d |
|
MD5 | bb61472bffcdc700cdb29d6318c2dc61 |
|
BLAKE2b-256 | a05acb2de7674209ff336a0e8d5a19aa24e855003b4b21f5a8efa0b755658693 |