Reshape pandas data frame by grouping rows and casting into new columns

pandas_bin_rows.py

import pandas as pd

# an example dataframe
df = pd.DataFrame.from_dict({
        'content': ['some content', 'and text', 'more writing', 'words in a line'],
        'url': ['a-url.com', 'cool.ai', 'random.xyz', 'here.there']
    })

Nbins = 3

# use pivoting to create new rows
df['col'] = df.index.map(lambda x: x%Nbins)
df['idx'] = df.index.map(lambda x: x//Nbins)
pivoted = df.pivot(index='idx', columns='col')
pivoted.columns = ['{}_{}'.format(l[0], l[1]) for l in pivoted.columns.tolist()]

# finished
print(pivoted)