I am trying to replace null values in my dataframe column by a prefix and ascending numbers(to make each to be unique).ie
| name | asset_number |
|---|---|
| Office Chair | null |
| Office Chair | null |
| Office Chair | null |
| Office Chair | CMP – 001 |
| Office Chair | CMP – 005 |
| Office Chair | null |
| Table | null |
| Table | CMP – 007 |
the null values should be replaced to something like PREFIX – 001,PREFIX – 002,…