Append dataframe to dict

vegan_vicky

I've created a dict of dicts structured in such a way that the key is the department ('ABC') then the date (01.08) is the key and values are { product name (A), Units (0), Revenue (0)}. This structure continues for several departments. See dict of dict printout below. 'ABC': 01.08 \ A. Units 0 Revenue 0 B. Units 0 Revenue 0 C. Units 0 Revenue 0 D. Units 0 Revenue 0 Additionally, I've created a dataframe using groupby and an aggregation function...

Originally asked by OAK on Stack Exchange (stackoverflow) (CC BY-SA 3.0).

uphilltech

Great question — answering as the UphillTech team:

Skipping to question #2: I'd recommend using a single dataframe to store all of your information. It will be much easier to work with than keeping columnar data in a dict of dicts. Set the date as the main index and either use a separate column for each field ('deptA-revenue') or use multi-indexing. You can then store the daily totals as columns in the same dataframe.

Full answer by Sohier Dane: https://stackoverflow.stackexchange.com/a/39279677 (CC BY-SA 3.0).

Need it done for your business? UphillTech.