sub select drop pandas code example

Example 1: pandas dataframe delete column

del df['column_name']

Example 2: Returns a new DataFrame that drops the specified column

# Returns a new DataFrame that drops the specified column

df.drop('age').collect()
# [Row(name='Alice'), Row(name='Bob')]

df.drop(df.age).collect()
# [Row(name='Alice'), Row(name='Bob')]

df.join(df2, df.name == df2.name, 'inner').drop(df.name).collect()
# [Row(age=5, height=85, name='Bob')]

df.join(df2, df.name == df2.name, 'inner').drop(df2.name).collect()
# [Row(age=5, name='Bob', height=85)]

df.join(df2, 'name', 'inner').drop('age', 'height').collect()
# [Row(name='Bob')]