if statement fails when there is no value

Question

if statement fails when there is no value

arkiboys 9,706

hello,

the if statement fails when there is no value in df_data_2
How can I correct this?

thanks

if (round(df_data_1.collect()[0][0], 3) == round(df_data_2.collect()[0][0], 3)):

Accepted answer

0 additional answers

Your answer

Answer 1

Sedat SALMAN 14,160 MVP

you can modify the following

df_data_1_1 = df_data_1.collect()
df_data_2_2 = df_data_2.collect()

if df_data_1_1 and df_data_2_2: 
    if round(df_data_1_collected[0][0], 3) == round(df_data_2_collected[0][0], 3):
        # code here 
        pass
    else:
        print("xxxxxxx")
else:
    print("empty dataframe")

arkiboys 9,706

df_data_1_1 = df_data_1.collect() 
df_data_2_2 = df_data_2.collect()

if df_data_1_1 and df_data_2_2:
    if (round(df_data_1_1.collect()[0][0], 3) == round(df_data_2_2.collect()[0][0], 3)):
        dbutils.notebook.exit("success")
    else:
        dbutils.notebook.exit("fail")

-----------------------------
error:
'list' object has no attribute 'collect'

Share via

if statement fails when there is no value

0 additional answers

Your answer