cronus-eater 0.1.0a3

A simple tool to get time series from spreadsheets

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	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

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.