Complicated data analys

How about Python:

import pandas as pd

# Create your data
data = {
    'Hand': ['pon', 'kan', ''],
    'Value1': ['b2', 'b1', 'ö'],
    'Result': [0, 0, 0]
}
df = pd.DataFrame(data)

# Define a function for assigning numeric values
def assign_result(row):
    if row['Value1'] == 'b2':
        return 10
    elif row['Value1'] == 'b1':
        return 20
    elif row['Value1'] == 'ö':
        return 30
    else:
        return 0

# Apply the function to the DataFrame
df['Result'] = df.apply(assign_result, axis=1)

print(df)