Pandas dataframe getting specific row and columns

Question

Pandas dataframe has

 FRUIT      DATE  PRICE
 Apple 11/5/2021     10
 Apple 12/5/2021     11
 Apple 13/5/2021     15
Orange 11/5/2021     20
Orange 12/5/2021     29
Orange 13/5/2021     15
Banana 11/5/2021      5
Banana 12/5/2021      7
Banana 13/5/2021      6

Data in pandas dataframe I need data of first two dates of every fruit name like

 FRUIT      DATE  PRICE
 Apple 11/5/2021     10
 Apple 12/5/2021     11
Banana 11/5/2021      5
Banana 12/5/2021      7
Orange 11/5/2021     20
Orange 12/5/2021     29

I have more than 100 fruit names

How to write condition for filtering the data?

When asking a question you should include an example of what you have tried so far, if you have not tried anything yet you might need to do some research before asking a question. — Nifim
– Nifim, Commented Aug 13, 2021 at 22:49

Corralien · Accepted Answer · 2021-08-13 18:44:06Z

1

Sort by DATE then groupby FRUIT and keep 2 first rows of each group:

>>> df.sort_values('DATE').groupby('FRUIT').head(2).sort_values('FRUIT')

    FRUIT       DATE  PRICE
0   Apple  11/5/2021     10
1   Apple  12/5/2021     11
6  Banana  11/5/2021      5
7  Banana  12/5/2021      7
3  Orange  11/5/2021     20
4  Orange  12/5/2021     29

answered Aug 13, 2021 at 18:44

Corralien

121k8 gold badges43 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

hari prasad Over a year ago

stackoverflow.com/questions/68806930/…

hari prasad Over a year ago

stackoverflow.com/questions/69304235/…

hari prasad Over a year ago

Edited my question, pls go through it

Corralien Over a year ago

@hariprasad. I updated my answer.

Collectives™ on Stack Overflow

Pandas dataframe getting specific row and columns

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related