I have this table:

and the result should be

How should I solve it with python?

>Solution :

You need to split and explode, the subtlety is how to determine the splitting points?

Assuming you want to split after the digits, use the (?<=\d)(?=\D) regex (split after a digit and before a non-digit):

out = (df.assign(product=df['product'].str.split(r'(?<=\d)(?=\D)'))
         .explode('product')
      )

Output:

   product       date  value
0  Prdct_1  23.7.2022    100
0  Prdct_2  23.7.2022    100
0  Prdct_3  23.7.2022    100
0  Prdct_4  23.7.2022    100
0  Prdct_5  23.7.2022    100
0  Prdct_6  23.7.2022    100

regex demo