Question: I have a data frame with some text read in from a txt file the column names are `FEATURE` and `SENTENCE`. Within the `FEATURE` col there is some text that has a `+` or a `-` symbol somewhere in the txt.

How can I create a new col called `RESULTS` and:

* if `+` exists in the `FEATURE` row then the new col will have a `positive`
* and if `-` exists the new `RESULTS` will have a `negative`
but if both signs exist then the `RESULTS` will have `neutral`

I tried to use the `np.where` but failed.
My data types for the `FEATURE` is string.

Please see a sample of the data:

```
{'FEATURE': {0: '[NA] this is not a feature.',
  1: 'entertainment value[+8]',
  2: 'image quality[+6]',
  3: 'extras [-2]',
  4: 'a list cast[+2],oscar winners[+1]'},
  'SENTENCE': {0: <NA>,
  1: 'starwars trilogy',
  2: ' good for an old dvd',
  3: 'dvd no had extra features',
  4: ' good cast'}}

```

Answer: 
This is work

`SELECT series.`range` as `range`, COALESCE(dt.average, 0) as average FROM 
(
 SELECT FROM_UNIXTIME(FLOOR((UNIX_TIMESTAMP(created_at)) DIV 300)*300) AS fecha, site_id, AVG(response_time) as average
 FROM sites_health_metrics WHERE site_id = 1 
 AND created_at BETWEEN '2021-08-23 20:40:00' AND '2021-08-23 21:40:00'
 GROUP BY fecha
) dt
 RIGHT JOIN 
(
 SELECT 
 date_format(date_add('2021-08-23 20:40:00', INTERVAL @num:=@num+300 SECOND), '%Y-%m-%d %H:%i:%s') `range`
 FROM sites_health_metrics , (select @num:=-300) num LIMIT 
) series
ON series.`range` = dt.fecha
GROUP BY `range``
```
SELECT UNIX_TIMESTAMP(created_at) DIV 300 t, site_id, AVG(response_time) c
FROM sites_health_metrics a
WHERE site_id = 1 
AND created_at BETWEEN '2021-08-23 20:40:00' AND '2021-08-23 21:40:00'
GROUP BY UNIX_TIMESTAMP(created_at) DIV 300, site_id

```