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.