Replicate/duplicate first value (column A) over all columns in entire row

Question

Does anyone know, how to get from this:

	A	B	C	D	E	F	G
Rate	RS	1.0	1.0	1.0	1.0	1.0	1.0

to this:

	A	B	C	D	E	F	G
Rate	RS	RS	RS	RS	RS	RS	RS

then just loop through all the columns you want to update, and assign them the first column data — Mahrkeenerh, Oct 26 '21 at 13:39

score 1 · Accepted Answer · answered Oct 26 '21 at 13:40

1

Try using slice assignment:

df[:] = df.iloc[0, 0]

Or if you want to specify the Rate index:

>>> df[:] = df.loc['Rate'].iloc[0]
>>> df
       A   B   C   D   E   F   G
Rate  RS  RS  RS  RS  RS  RS  RS
>>>

answered Oct 26 '21 at 13:40

U13-Forward

1 Answers1