Adding same value in the same column

Question

Hey I would like to turn python table from

To table

I know how to add normal table using dataframe

import pandas as pd

data = {'Alphabet': ['A', 'B', 'C', 'D', 'E'],
        'Number': [1, 2, 3, 4, 5]
        }

df = pd.DataFrame(data)

print (df)

But not the second table

Your question has already been answered here: https://stackoverflow.com/questions/22219004/how-to-group-dataframe-rows-into-list-in-pandas-groupby — mkrieger1, Dec 14 '21 at 08:22

score 0 · Answer 1 · answered Dec 14 '21 at 08:19

0

You can use the following approach:

df.groupby("Number")["Alphabet"].apply(lambda x:" ".join(x)).to_frame()

answered Dec 14 '21 at 08:19

nikeros

Why is `to_frame` necessary? – mkrieger1 Dec 14 '21 at 08:25
@mkrieger1 Just wanted to return a DataFrame back - `type(df.groupby("Number")["Alphabet"].apply(lambda x:" ".join(x))` is `` – nikeros Dec 14 '21 at 08:28

1 Answers1