Select rows that fulfill conditions

up vote
2
down vote

favorite

I need to write a query that will get a name of the company and shows only 2 rows and after that will check the next company and shows another 2 rows. Let's say that df looks like the one below:

x     y     y      name

1      2    3       ammazon

4     5     6       ammazon

7     8     9       ammazon

9     8     7       google

6     5     4       google

3     2     1       google

So result should be like that:

 x     y     y      name

1      2    3       ammazon

4     5     6       ammazon

9     8     7       google

6     5     4       google

I tried to use sql query but couldn't write the correct one. Could you help ? Or perhaps "for loop" would be better solution... anything

Thanks All !

asked Nov 21 at 18:53

Tmiskiewicz

305

MySQL I presume? Do you care which 2 rows? Why are there two columns with the same name?
– Caius Jard
Nov 21 at 19:21

add a comment |

up vote
2
down vote

favorite

I need to write a query that will get a name of the company and shows only 2 rows and after that will check the next company and shows another 2 rows. Let's say that df looks like the one below:

x     y     y      name

1      2    3       ammazon

4     5     6       ammazon

7     8     9       ammazon

9     8     7       google

6     5     4       google

3     2     1       google

So result should be like that:

 x     y     y      name

1      2    3       ammazon

4     5     6       ammazon

9     8     7       google

6     5     4       google

I tried to use sql query but couldn't write the correct one. Could you help ? Or perhaps "for loop" would be better solution... anything

Thanks All !

asked Nov 21 at 18:53

Tmiskiewicz

305

MySQL I presume? Do you care which 2 rows? Why are there two columns with the same name?
– Caius Jard
Nov 21 at 19:21

add a comment |

up vote
2
down vote

favorite

I need to write a query that will get a name of the company and shows only 2 rows and after that will check the next company and shows another 2 rows. Let's say that df looks like the one below:

x     y     y      name

1      2    3       ammazon

4     5     6       ammazon

7     8     9       ammazon

9     8     7       google

6     5     4       google

3     2     1       google

So result should be like that:

 x     y     y      name

1      2    3       ammazon

4     5     6       ammazon

9     8     7       google

6     5     4       google

I tried to use sql query but couldn't write the correct one. Could you help ? Or perhaps "for loop" would be better solution... anything

Thanks All !

asked Nov 21 at 18:53

Tmiskiewicz

305

I need to write a query that will get a name of the company and shows only 2 rows and after that will check the next company and shows another 2 rows. Let's say that df looks like the one below:

x     y     y      name

1      2    3       ammazon

4     5     6       ammazon

7     8     9       ammazon

9     8     7       google

6     5     4       google

3     2     1       google

So result should be like that:

 x     y     y      name

1      2    3       ammazon

4     5     6       ammazon

9     8     7       google

6     5     4       google

I tried to use sql query but couldn't write the correct one. Could you help ? Or perhaps "for loop" would be better solution... anything

Thanks All !

sql python-3.x pandas dataframe for-loop

asked Nov 21 at 18:53

Tmiskiewicz

305

asked Nov 21 at 18:53

Tmiskiewicz

305

asked Nov 21 at 18:53

Tmiskiewicz

305

asked Nov 21 at 18:53

Tmiskiewicz

305

asked Nov 21 at 18:53

Tmiskiewicz

305

MySQL I presume? Do you care which 2 rows? Why are there two columns with the same name?
– Caius Jard
Nov 21 at 19:21

add a comment |

MySQL I presume? Do you care which 2 rows? Why are there two columns with the same name?
– Caius Jard
Nov 21 at 19:21

MySQL I presume? Do you care which 2 rows? Why are there two columns with the same name?
– Caius Jard
Nov 21 at 19:21

add a comment |

1 Answer
1

active

oldest

votes

up vote
2
down vote

accepted

`groupby` with `head`

df.groupby('name').head(2)



   x  y  y     name

0  1  2  3  ammazon

1  4  5  6  ammazon

3  9  8  7   google

4  6  5  4   google

answered Nov 21 at 18:55

piRSquared

149k21135275

and that works great. Thank you !
– Tmiskiewicz
Nov 21 at 19:05

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53418810%2fselect-rows-that-fulfill-conditions%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
2
down vote

accepted

`groupby` with `head`

df.groupby('name').head(2)



   x  y  y     name

0  1  2  3  ammazon

1  4  5  6  ammazon

3  9  8  7   google

4  6  5  4   google

answered Nov 21 at 18:55

piRSquared

149k21135275

and that works great. Thank you !
– Tmiskiewicz
Nov 21 at 19:05

add a comment |

up vote
2
down vote

accepted

`groupby` with `head`

df.groupby('name').head(2)



   x  y  y     name

0  1  2  3  ammazon

1  4  5  6  ammazon

3  9  8  7   google

4  6  5  4   google

answered Nov 21 at 18:55

piRSquared

149k21135275

and that works great. Thank you !
– Tmiskiewicz
Nov 21 at 19:05

add a comment |

up vote
2
down vote

accepted

`groupby` with `head`

df.groupby('name').head(2)



   x  y  y     name

0  1  2  3  ammazon

1  4  5  6  ammazon

3  9  8  7   google

4  6  5  4   google

answered Nov 21 at 18:55

piRSquared

149k21135275

`groupby` with `head`

df.groupby('name').head(2)



   x  y  y     name

0  1  2  3  ammazon

1  4  5  6  ammazon

3  9  8  7   google

4  6  5  4   google

answered Nov 21 at 18:55

piRSquared

149k21135275

answered Nov 21 at 18:55

piRSquared

149k21135275

answered Nov 21 at 18:55

piRSquared

149k21135275

answered Nov 21 at 18:55

piRSquared

149k21135275

and that works great. Thank you !
– Tmiskiewicz
Nov 21 at 19:05

add a comment |

and that works great. Thank you !
– Tmiskiewicz
Nov 21 at 19:05

and that works great. Thank you !
– Tmiskiewicz
Nov 21 at 19:05

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Qfyilyi