Using pandas to concatenate strings of multiple row by column?

Question

I want use the first 5 rows of my data frame and concentrate the string to form a new index.

Doing some research i think groupby with agg and lambda will work. What would be the best way to accomplish this? I am new to python.

For example my current data frame:

Dataframe (df):

Desired Outcome:

receipt delivery zone	fixed cost unit rate	variable cost unit rate	electric Power Another header Rate	Max Rate	Min Rate
5	2	3	3	3	3
5	2	3	3	3	3

Qdr · Accepted Answer · 2022-07-06 22:22:49Z

1

you don't need to use .groupby() or lambda. Simply use .agg(sum) on the first n-th rows to get concatenate the strings.

first step, get the slice:

slc = df.iloc[:4,:]

use .agg(sum) to aggregate the strings in one row.

new_cols = slc.agg(sum)

Simply reassign the column names

df.columns = new_cols

answered Jul 6, 2022 at 22:22

Qdr

7455 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1