pyspark, reverse the order of a dataframe

pyspark, reverse the order of a dataframe.py

# revert the order of a dataframe
from pyspark.sql import SparkSession
import pyspark.sql.functions as f

# create spark session
spark = SparkSession.builder.appName('some name').getOrCreate()

# create a frame
df = spark.createDataFrame([('a',12), ('c',10), ('b',9)], ['col1', 'col2'])
df.show()

# reverse the order of the rows
inv_df = df.withColumn('index', f.monotonically_increasing_id()).orderBy(f.col('index').desc()).drop('index')