Append all columns of dataframe to a new dataframe

Question

I want to append all columns of a dataframe to a new dataframe with single column.

My Current Dataframe:

|**namelist1**| **namelist2** |  **namelist3** |and so on
|khalid       |  sabbir       | liton          |
|tamim        |  sakib        | tawhid         |
|taskin       |  santo        | naim           |

Expected Dataframe:

**namelistall**
khalid      
sabbir     
liton
tamim       
sakib      
tawhid
taskin      
santo      
naim

jezrael · Accepted Answer · 2023-07-13T10:36:09.880

1

Use numpy.ravel with DataFrame constructor:

df = pd.DataFrame({'namelistall': np.ravel(df.to_numpy())})
print (df)
  namelistall
0      khalid
1      sabbir
2       liton
3       tamim
4       sakib
5      tawhid
6      taskin
7       santo
8        naim

edited Jul 13 '23 at 10:36

answered Jul 13 '23 at 10:19

jezrael

822,522
95
1,334
1,252

1

Awesome! it works. – Khalid Alsaba Jul 13 '23 at 10:30

score 0 · Answer 2 · answered Jul 13 '23 at 10:34

0

It creates a new dataframe with a single column by flattening the values of the original dataframe.

new_df = pd.DataFrame({'namelistall': current_df.values.ravel()})

answered Jul 13 '23 at 10:34

Anay

741
1
5
15

score 0 · Answer 3 · answered Jul 13 '23 at 10:48

Even the stack() from pandas.DataFrame can be used.

The code to do so is as follows:

df = pd.DataFrame({'namelistall': current_df.stack().values})
print(df)

Output:

  namelistall
0      khalid
1      sabbir
2       liton
3       tamim
4       sakib
5      tawhid
6      taskin
7       santo
8        naim

Append all columns of dataframe to a new dataframe

3 Answers3