Pandas Dataframe multiple rows with same index

Question

I have a dictionary that looks like this:

dict = {
  "A": [1,2,3],
  "B": [4]
}

when I try to create a panda Dataframe I use:

output_df = pd.DataFrame.from_dict(dict, orient='index')

Output:

-	1	2	3
A	1	2	3
B	4

What I want:

Thanks for your help! :)

Pygirl · Accepted Answer · 2021-01-19 17:38:17Z

1

try:

df.stack().swaplevel(0,1)

1  A    1.0
2  A    2.0
3  A    3.0
1  B    4.0
dtype: float64

df.stack().swaplevel(0,1).reset_index(level=[1], name='a').reset_index(drop=True)

    level_1   a
0   A         1.0
1   A         2.0
2   A         3.0
3   B         4.0

answered Jan 19, 2021 at 17:33

Pygirl

13.4k6 gold badges36 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1