Access a specific item in PySpark dataframe

Question

How can I access value at a certain index of a column in PySpark dataframe for example I want to access value at index 5 of a column named "Category". How can I do that in PySpark syntax?

Answer 1

Something like this,

value = df.where(df.index == 5).select('Category').collect()[0]['Category']
                                         #assuming 'index' is index column