Here's a subset of my data.

```
     ID Direction
100 30761     River
101 30762    Marine
102 30763    Marine
103 30764    Marine
104 30765     River
105 30765     River
106 30766    Marine
107 30766     River
108 30767     River
109 30767     River
110 30768     River
111 30768     River
112 30769     River
113 30769     River
114 30770     River
115 30771     River
116 30772     River
117 30772     River
118 30773     River
119 30773     River
120 30774     River

```

What I'm trying to do is get a DF with the same columns except there is only one row for each ID. For example, instead of two rows of data for both ID 30767 and 30768, have one row like this:

```
30767   River
30768   River

```

However, ID 30766 has different values of direction for each row (Marine and River). For this ID, I'd like to do the same as above, but instead, create a new level for the Direction column called 'Both'

```
30766   Both

```

Desired DF looks like this:

```
ID      Direction
30761   River
30762   Marine
...     ...
30765   River
30766   Both
30767   River
...     ...
30773   River
30774   River

```