Converting 2 columns of names into 4 columns of names using Pandas

Question

I have an Excel file that consists of two columns: last_name, first_name. The list is sorted by years of experience. I would like to create an new Excel file (or text file) that prints the names two-by-two.

Last       First
Smith      Joe
Jones      Mary
Johnson    Ken 
etc

and converts it to

Smith      Joe           Jones       Mary
Johnson    Ken           etc.

effectively printing every other name on the same row as the name above.

I have reached the point where the names can be printed into a single set of columns, but I can't move every other name to adjacent columns.

Thanks

can you add the code you have so far, seems like you're almost there, just a few modifications needed. — Shawn Ramirez, May 11 '21 at 15:42
Does this answer your question? [How to pivot a dataframe?](https://stackoverflow.com/questions/47152691/how-to-pivot-a-dataframe) — ThePyGuy, May 11 '21 at 15:47

Nk03 · Answer 1 · 2021-05-11T16:24:36.133

1

TRY:

result = pd.concat([df.iloc[::2].reset_index(drop=True),
           df.iloc[1::2].reset_index(drop=True)], 1)

OUTPUT:

      Last First   Last First
0    Smith   Joe  Jones  Mary
1  Johnson   Ken    etc  None

edited May 11 '21 at 16:24

answered May 11 '21 at 16:09

Nk03

14,699
2
8
22

1

Thank you for the answer. This solved my problem completely. – James Dull May 12 '21 at 14:21

Converting 2 columns of names into 4 columns of names using Pandas

1 Answers1