I just started with python and know almost nothing about pandas.

so now I have a directed graph which look like this:

now I need to transform it to horizontal data format like this:

I find something like Pandas Merge duplicate index into single index but it seems it cannot merge rows into different colums.

Will pandas use NAN to fill in the blanks during this process due to the need to add more columns?

CodePudding user response：

You can do something like this to transform your dataframe, pandas will automatically add NaN values for any number of columns you have with this solution.

df = df.groupby('from')['to'].apply(list)

## create the desired df from the lists
df = pd.DataFrame(df.tolist(),index=df.index).reset_index()


## Rename columns
df.columns = ["from ID"]   [f"To {i}" for i in range(1,len(df.columns))]