How to Separate Dataframe Based on the Label value?

Question

Let say I have this dataframe.

+-----------------+-----------+
|     COMMENT     | SENTIMENT |
+-----------------+-----------+
| Good app        | Positive  |
| Bad app         | Negative  |
| Useless feature | Negative  |
| I like this app | Positive  |
+-----------------+-----------+

I want to split it based on the SENTIMENT column. Like this below.

+-----------------+-----------+
|     COMMENT     | SENTIMENT |
+-----------------+-----------+
| Good app        | Positive  |
| I like this app | Positive  |
+-----------------+-----------+


+-----------------+-----------+
|     COMMENT     | SENTIMENT |
+-----------------+-----------+
| Bad app         | Negative  |
| Useless feature | Negative  |
+-----------------+-----------+

Anyone knows the solution in Python (Jupyter) for that case? Your help will help my thesis project. Thank you :D

Does this answer your question? [How to split one csv into multiple files in python](https://stackoverflow.com/questions/60425658/how-to-split-one-csv-into-multiple-files-in-python) — deadshot, Feb 27 '20 at 06:24

score 1 · Accepted Answer · edited Feb 27 '20 at 07:06

1

Simply you can use df1 = df[df["SENTIMENT"]=="Positive"]

Then df1 will have:

df2 = df[df["SENTIMENT"]=="Negative"]

Then df2 will have:

edited Feb 27 '20 at 07:06

deadshot

8,881
4
20
39

answered Feb 27 '20 at 06:51

Aminul

1,427
2
8
16

How to Separate Dataframe Based on the Label value?

1 Answers1