I have a dataset df
field_pointpath assetclass_code value
C_THDxL_0154x6KSFS_A03x6KSF_11xaP_ACT 6KSFS_6KSF 50
C_THDxL_0154x6KSFS_A03x6KSF_11xaP_ACT 6KSFS_6KSF 60
C_THDxL_0154x6KSFS_A03x6KSF_11xaP_ACT 6KSFS_6KSF 65
C_THDxL_0154x6KSFS_A03x6KSF_11xaP_ACT 6KSFS_6KSF 43
C_THDxL_0154x6KSFS_A03xaP_ACT 6KSFS 70
C_THDxL_0154x6KSFS_A03xaP_ACT 6KSFS 55
C_THDxL_0154x6KSFS_A03xaP_ACT 6KSFS 43
C_THDxL_0154x6KSFS_A03xaP_ACT 6KSFS 11
C_THDxL_0154x6KSFS_B03x6KSF_11xaP_ACT 6KSFS_6KSF 67
C_THDxL_0154x6KSFS_B03x6KSF_11xaP_ACT 6KSFS_6KSF 36
C_THDxL_0154x6KSFS_B03x6KSF_11xaP_ACT 6KSFS_6KSF 39
C_THDxL_0154x6KSFS_B03x6KSF_11xaP_ACT 6KSFS_6KSF 33
C_THDxL_0154x6KSFS_B03x6KSF_11xaP_ACT 6KSFS_6KSF 20
C_THDxL_0154x6KSFS_B03xaP_ACT 6KSFS 21
C_THDxL_0154x6KSFS_B03xaP_ACT 6KSFS 22
C_THDxL_0154x6KSFS_B03xaP_ACT 6KSFS 17
C_THDxL_0154x6KSFS_B03xaP_ACT 6KSFS 30
I want to filter out values for specific field_pointpath
for example:
- C_THDxL_0154x6KSFS_A03x6KSF_11xaP_ACT
C_THDxL_0154x6KSFS_A03x6KSF_11xaP_ACT
which has a character A should not have
valuegreater than 60:
Similarly,
C_THDxL_0154x6KSFS_B03x6KSF_11xaP_ACT,
C_THDxL_0154x6KSFS_B03x6KSF_11xaP_ACT
which has a character B should not have
valuegreater than 30
Thus output should be
field_pointpath assetclass_code value
C_THDxL_0154x6KSFS_A03x6KSF_11xaP_ACT 6KSFS_6KSF 50
C_THDxL_0154x6KSFS_A03x6KSF_11xaP_ACT 6KSFS_6KSF 60
C_THDxL_0154x6KSFS_A03x6KSF_11xaP_ACT 6KSFS_6KSF 43
C_THDxL_0154x6KSFS_A03xaP_ACT 6KSFS 55
C_THDxL_0154x6KSFS_A03xaP_ACT 6KSFS 43
C_THDxL_0154x6KSFS_A03xaP_ACT 6KSFS 11
C_THDxL_0154x6KSFS_B03x6KSF_11xaP_ACT 6KSFS_6KSF 20
C_THDxL_0154x6KSFS_B03xaP_ACT 6KSFS 21
C_THDxL_0154x6KSFS_B03xaP_ACT 6KSFS 22
C_THDxL_0154x6KSFS_B03xaP_ACT 6KSFS 17
C_THDxL_0154x6KSFS_B03xaP_ACT 6KSFS 30