def transform(df, steps_per_floor_, spark):
    df.createOrReplaceTempView('table1')
    df_transformed = spark.sql(("select id, concat(first_name,' ' , second_name) as name, floor* %s as steps_to_desk from table1" % steps_per_floor_))
    return df_transformed
def transform(df, steps_per_floor_, spark):
    df.createOrReplaceTempView('table1')
    df_transformed = spark.sql(("select id, concat(first_name,' ' , second_name) as name, floor* %s as steps_to_desk from table1" % steps_per_floor_))
    return df_transformed