str.endswith Output Query

[eddywinch82]

Hi buran,

I have solved the issues I was having :-

For filtering the Rows, by multiple matching days of the Month, from all Months :-

Instead of using this line of Code :-

(df3['DATE'].str.endswith('-6','-8'))

I now use the following :-

(df3['DATE'].str.contains('-6$|-8$'))

And for Filtering Rows, for the same Day of the Month from all Months.

I now use :-

(df3['DATE'].str.contains('-6$'))

'$' Is used to match the end of a String, you know that no doubt, I found a Stackoverflow Forum Post
that mentioned that.

And now I get the correct DataFrame Output ))

And for filtering by multiple Months I use :-

(df3['DATE'].str.contains('-6-|-8-'))

And that works too. That would show all Rows, from June and August for example.

Many thanks for your help.

Best Regards

Eddie Winch