filter the dataframe using a condition in pandas python

Asked Mar 10 '21 at 06:05

Active Mar 10 '21 at 06:34

Viewed 39 times

This might be a repeated question, but I couldn't get the answers of the other question.

I've a sample dataframe1

city       date        user         manager         mobile
LA      2021-03-01      XYZ          ABC            123456
LA      2021-03-02      XYZ          ABC            123456
LA      2021-03-03      XYZ          ABC            123456
FL      2021-03-01      DEF          MNO            099876
FL      2021-03-01      DEF          MNO            099867
TX      2021-03-01      KLM          PQR            9988887

How do I filter the df in order to get the data of user whose count is more than 1 in the df. As the count of XYZ and DEF exceeds 1, the rows of that users should be filtered out.

Desired result

city       date        user         manager         mobile
LA      2021-03-01      XYZ          ABC            123456
LA      2021-03-02      XYZ          ABC            123456
LA      2021-03-03      XYZ          ABC            123456
FL      2021-03-01      DEF          MNO            099876
FL      2021-03-01      DEF          MNO            099867

edited Mar 10 '21 at 06:25

asked Mar 10 '21 at 06:05

astroboy1

Need `df[df['user'].duplicated(keep=False)]` – jezrael Mar 10 '21 at 06:27
How do I use the count condition in that? what if I want records of the users whose count is more than 2 in that df. So only `XYZ` records would be filtered out. Because the count of XYZ in the column is more than 2. – astroboy1 Mar 10 '21 at 06:33
added to list of dupes. – jezrael Mar 10 '21 at 06:34
I'm sorry, I'm a newbie to pandas. Could you explain me a bit more with a solution? – astroboy1 Mar 10 '21 at 06:48
Sure, what is unclear? – jezrael Mar 10 '21 at 06:50
If you are new, maybe first check [10 minutes to pandas](https://pandas.pydata.org/docs/user_guide/10min.html) – jezrael Mar 10 '21 at 06:55
so Im tring this `xyz = pd.concat(print(g) for _, g in email_report.groupby("employee") if (g.shape[0]) > 2)`, to get the entire dataframe that satisfice my condition. But didnt work. So it as no objects to concat. – astroboy1 Mar 10 '21 at 07:04
1

Do you see second dupe? [link](https://stackoverflow.com/q/29836836/2901002) – jezrael Mar 10 '21 at 07:05
Thank you. Got my explanation and answer. – astroboy1 Mar 10 '21 at 07:13

filter the dataframe using a condition in pandas python

0 Answers0