If I have a dataframe and want to have the value of a cell based on a condition/filter, it seems not to be a one line instruction.
In the example below I do not know the index at the beginning so I need to filter and then ask for index and apply it.
Is there a easier way to get the value without knowing the index upfront.
Edit: Easy spoken I want to have the value of the Column "Category" of the Row where the Column "No." has the value 'P1'.
question from:https://stackoverflow.com/questions/65829774/how-to-get-the-value-of-a-cell-based-on-filtering-efficently