GitLocker: The Coding Marketplace

Description:

cronuseater 0.1.0a10

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?

There's just one place to get the data I want, but ... it's mess! I need to spend some time to normalize this times series.

import pandas as pd

raw_dataframe = pd.read_excel('historical_series_3Q22.xlsx', sheet_name='random_sheet')
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
NaN
$106.12
$900.00
NaN

Let's devours this times series

No need to worry. You just need to bring the raw dataframe to Cronus Eater and you are ready to start the analysis.
This way, you spend more time on what is really important for you.

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
500.23

1
4
Cash Flow
1
2Q22
302.81

2
4
Cash Flow
1
1Q22
106.12

3
4
Cash Flow
1
2022
900.00

But If I need to consume a lot of dataframes from a spreedsheet?

We got you, just use "extract_many"

raw_dataframes = pd.read_excel('historical_series_3Q22.xlsx', sheet_name=None)
times_series_df = cronus_eater.extract_many(raw_dataframes)
times_series_df.head()

Numeric Index
Label Index
Table Order
Time
Value
Sheet Name

0
4
Cash Flow
1
3Q22
500.23
random_sheet

1
4
Cash Flow
1
2Q22
302.81
random_sheet

2
7
ROE
1
1Q22
106.12
random_sheet_2

3
7
ROE
1
2022
900.00
random_sheet_2

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).
# Through pip
pip install cronus-eater

# Through poetry
poetry add cronus-eater

License
MIT
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.