Pandas: Delimiter in DataFrame.from_dict()

Question

Basically, I'm using Pandas to easily write my dictionary to .csv:

import pandas as pd

df = pd.DataFrame.from_dict(dict, orient="index")
df.to_csv("test.csv")

But my .csv file looks like this:

key1: value1, value2
key2: value1
key3: value1, value2

And I want it to look like this:

key1: value1
kay1: value2
key2: value1
key3: value1
key3: value2

Is it possible to define some sort of delimiter for data in pandas? Thanks.

Possible duplicate of: http://stackoverflow.com/questions/8685809/python-writing-a-dictionary-to-a-csv-file-with-one-line-for-every-key-value — Binyamin Even, Mar 07 '17 at 09:40

score 1 · Accepted Answer · answered Mar 07 '17 at 09:45

1

Try to stack

df.stack().reset_index(1, drop=True).to_csv('test.csv')

%cat 'test.csv'

key1,value1
kay1,value2
key2,value1
key3,value1
key3,value2

answered Mar 07 '17 at 09:45

piRSquared

1 Answers1