Skip to content
This repository has been archived by the owner on May 15, 2024. It is now read-only.

Data Shaping to Tall and Skinny #20

Open
raeq opened this issue Aug 3, 2019 · 0 comments
Open

Data Shaping to Tall and Skinny #20

raeq opened this issue Aug 3, 2019 · 0 comments

Comments

@raeq
Copy link

raeq commented Aug 3, 2019

This project is fantastic, thank you!

I prefer to work with pandas dataframes over Excel. Cost Explorer itself - and this project - use a wide data format. I prefer to work with relational data, with ("Index", "TimePeriod","CostAmount") as the column headers, and the rows containing tuples such as [(0, "2019-01-01", 272.11022), (1, "2019-02-01", 271.292)].

Currently I have to "melt" the dataframe to transpose (unpivot) it from wide and shallow to tall and skinny.

Have you considered using a data-science friendly data shape? Would you like a PR submitted or is this on a roadmap?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant