Add same row values to dataframe for all column with name LIKE

Question

I have a dataframe like this:

df = pd.DataFrame(columns=['aab', 'aac', 'bba'])

and I would like to add the same value to all columns which start with "aa%" something like this:

df = df.append({'aa%': 'val1', 'bba': 'val2'}, ignore_index=True)

and get this result:

+------+------+------+
| aab  | aac  | bba  |
+------+------+------+
| val1 | val1 | val2 |
+------+------+------+

Is it possible?

ipj · Accepted Answer · 2020-08-24 22:02:57Z

2

First use append to create empty row, then fill empty row with val1 where column names starts with aa. Finally fill rest of values with val2 :

df.append(pd.Series(), ignore_index=True)
df.loc[0, df.columns[df.columns.str.startswith('aa')]] = 'val1'
df.fillna('val2')

result:

    aab   aac   bba
0  val1  val1  val2

answered Aug 24, 2020 at 21:45

ipj

3,5981 gold badge17 silver badges18 bronze badges

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

1 Answer 1