How to Split a Single-Column DataFrame into Multiple Columns with Pandas

1. Introduction

Hello, I am PiPi. Recently a member of a Python community asked a pandas data‑analysis question. The original demo data is shown below:

Problem description: A DataFrame has only one column, and every five rows should form a group. How can we split it into five columns and N rows?

2. Implementation

One approach is to convert the column to a list, slice it, and then convert the slices back to a DataFrame. The following function demonstrates this method:

def trans_lists(lists, n=5):
    lsts = [lists[i:n+i] for i in range(0, len(lists), n)]
    return lsts

The principle is to split a list into multiple nested lists, which can then be directly passed to pd.DataFrame.

Another solution uses pandas groupby and aggregation:

pd.DataFrame(df.groupby(['group'])['data'].agg(pd.Series).values.tolist())

This successfully resolves the user's issue.

3. Summary

The article presented a pandas data‑processing problem and provided two concrete solutions—list slicing and groupby aggregation—accompanied by code snippets to help readers implement the transformation.

Tip for asking questions: When posting in a group, consider sharing a small, anonymized demo dataset, include the relevant code (preferably as plain text), attach error screenshots, and if the code exceeds 50 lines, share it as a .py file.