dictionary to pandas DataFrame

Question

I have this dictionary:

diccionario = {'Monetarios':['B1','B2'],
            'Monetario Dinamico':['B1','B2'],
            'Renta fija corto plazo':['B1','B2'],
            'Garantizados de RF':['B1','B2'],
            'Renta Fija Largo Plazo':['B2','B3'],
            'Garantizados de RV':['B2','B3'],
            'Mixtos Renta Fija':['B2','B3'],
            'Mixtos Renta Variable':['B3','B4'],
            'Renta Variable':['B3','B4'],
            'Alternativos':['B3','B4'],
            'Fondos Inmobiliarios en Directo':['G3','G3'],
            'IIC de Inversion Libre':['G4','G4'],
            'IIC de IIC de Inversion Libre':['G4','G4'],
            'Money Markets':['B1','B2'],
            'Money Markets Enhanced':['B1','B2'],
            'Fixed Income Short Term':['B1','B2'],
            'Capital Guaranteed Funds':['B1','B2'],
            'Fixed Income Long Term':['B2','B3'],
            'Capital Guaranteed Equity Funds':['B2','B3'],
            'Mixed Fixed Income Funds':['B2','B3'],
            'Mixed Equity Funds':['B3','B4'],
            'Equity':['B3','B4'],
            'Alternatives':['B3','B4'],
            'Real State':['G3','G4'],
            'Hedge Funds':['G4','G4'],
            'Funds of Hedge Funds':['G4','G4'],
            'HARMONIZED':'G4',
            'HIGH_YLD_EMERGING_MARKETS':'B4'
           }

And i want a data frame with the words i am using as keys as the first column and the values assigned to those keys as other columns, like this:

col 1       col 2     col 3
Monetarios    B1        B2
Monetar din.  B1        B2
Rent fija...  B1        B2

... ...

I ve just got the first colum with this: df_dict = pd.DataFrame(diccionario)

k3 = list(df_dict.columns.values)

thanks in advance

jezrael · Accepted Answer · 2016-10-18T14:38:57.753

I think you can use transpose by T with reset_index:

df = pd.DataFrame.from_dict(diccionario).T.reset_index()
df.columns = ['col1','col2','col3']
print (df)
                               col1 col2 col3
0                      Alternatives   B3   B4
1                      Alternativos   B3   B4
2   Capital Guaranteed Equity Funds   B2   B3
3          Capital Guaranteed Funds   B1   B2
4                            Equity   B3   B4
5            Fixed Income Long Term   B2   B3
6           Fixed Income Short Term   B1   B2
7   Fondos Inmobiliarios en Directo   G3   G3
8              Funds of Hedge Funds   G4   G4
9                Garantizados de RF   B1   B2
10               Garantizados de RV   B2   B3
11                       HARMONIZED   G4   G4
12        HIGH_YLD_EMERGING_MARKETS   B4   B4
13                      Hedge Funds   G4   G4
14    IIC de IIC de Inversion Libre   G4   G4
15           IIC de Inversion Libre   G4   G4
16               Mixed Equity Funds   B3   B4
17         Mixed Fixed Income Funds   B2   B3
18                Mixtos Renta Fija   B2   B3
19            Mixtos Renta Variable   B3   B4
20               Monetario Dinamico   B1   B2
21                       Monetarios   B1   B2
22                    Money Markets   B1   B2
23           Money Markets Enhanced   B1   B2
24                       Real State   G3   G4
25           Renta Fija Largo Plazo   B2   B3
26                   Renta Variable   B3   B4
27           Renta fija corto plazo   B1   B2

that is almost the answer, now i need the first column as a column, not as an index — Borja_042, Oct 18 '16 at 14:37
Lol, that is totally perfect! I did not i could traspose a DataFrame — Borja_042, Oct 18 '16 at 14:40
Just one more comment, regarding the perfection. The keys of my dictionary have been sorted alphabetically, how do I remove the alphabetical order? something like sorted= False? — Borja_042, Oct 18 '16 at 14:44
It is problem. Because `dict` are [unondered](http://stackoverflow.com/a/9001529/2901002). — jezrael, Oct 18 '16 at 14:46
I did not know I had to accept the answer as I am new to this forum. — Borja_042, Oct 19 '16 at 08:31

dictionary to pandas DataFrame

1 Answers1