python Pandas how to set my custom index combining string and number

Question

I have an dataframe like this:

product_nmae
Productashd
productddsf
productkid

my expected dataframe will be look like this:

  product_nmae    unique_id
    Productashd    sku-1
    productddsf    sku-2
    productkid    sku-3

I tried this df['unique_id'] = df.index + 1 which giving result something like this

  product_nmae    unique_id
    Productashd       0
    productddsf       1
    productkid        3

how to get my expected result?

jezrael · Accepted Answer · 2022-08-15 10:45:10Z

4

Create default index and for possible add sku convert to strings:

df = df.reset_index(drop=True)
df['unique_id'] = 'sku-' + (df.index + 1).astype(str)

answered Aug 15, 2022 at 10:45

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Answer 1