When creating a nested dictionary of dataframes, how can I name a dictionary based on a list name of the dataframe?

[Aaron]

Thank you for the help!  Based on your response/recommendation, I am
thinking that my entire approach to solving my problem is very poor.  I am
trying to pull slices from a dataframe, store them in a nested dictionary,
retrieve them, perform calculations, store the results in the same nested
dictionary (hence why I need to know the actual name of each nested
dictionary), retrieve the results, then format the results.  LOL  that
looks so bad when I think about it out loud.  What I think I should be
doing is pull my first slice from a dataframe, perform my calculations,
then format those results in my desired final output; take my second,
third, fourth, etc. slices and then just repeat that same pattern instead
of what I initially thought I should do.  Is there a standard approach for
evaluating particular slices of dataframes or does it always depend on the
situation?

On Sun, Jun 7, 2020 at 4:39 AM Peter Otten <__peter__ at web.de> wrote:

> Aaron wrote:
>
> > When creating a nested dictionary of dataframes, how can I name a
> > dictionary based on a list name of the dataframe?
> >
> > Given the following:
> >
> > # START CODE
> > import pandas as pd
> >
> > cars = {'Brand': ['Honda Civic','Toyota Corolla'],
> >         'Price': [22000,25000]
> >         }
> > df_cars = pd.DataFrame(cars, columns = ['Brand','Price'])
> >
> > trucks = {'Brand': ['GMC Sierra','Ford F-150'],
> >         'Price': [50000,48000]
> >         }
> > df_trucks = pd.DataFrame(trucks, columns = ['Brand','Price'])
> >
> > list_of_dfs = [df_cars, df_trucks]
> >
> > # Not exactly sure how this code should be:
> > dict_of_dfs = {}
> > for df in list_of_dfs:
> >     dict_of_dfs[name_of_df] = {}  # Not sure here
> >     dict_of_dfs[name_of_df]['results'] = df  # Not sure here
> > # END CODE
>
> In the general case you can't find the name of a value, so you may start
> with the names and look up the dataframes in the global namespace:
>
> list_of_df_names = ["df_cars", "df_trucks"]
> dict_of_dfs = {
>    name: {"results": globals()[name]}
>    for name in list_of_df_names
> }
>
> Personally I would probably reorganize your code a bit and avoid the
> df_...
> names:
>
> import pandas as pd
>
> vehicles = dict(
>     cars={
>         'Brand': ['Honda Civic','Toyota Corolla'],
>         'Price': [22000,25000]
>     },
>     trucks={
>         'Brand': ['GMC Sierra','Ford F-150'],
>         'Price': [50000,48000]
>     }
> )
>
> dict_of_dfs = {
>     name: {"results": pd.DataFrame(val)}
>     for name, val in vehicles.items()
> }
>
>
> --
> https://mail.python.org/mailman/listinfo/python-list
>