Splitting Dataframe into two DataFrame
<p>I have a dateframe which have unique as well as repeated records on the basis of number. Now i want to split the dataframe into two dataframe. In first dataframe i need to copy only unique rows and in second dataframe i want all repeated rows. For example</p>

<pre><code>     id   name     number
     1    Shan     101
     2    Shan     101
     3    John     102
     4    Michel   103
</code></pre>

<p>The two splitted dataframe should be like</p>

<p>Unique</p>

<pre><code>      id    name    number
      3     John    102
      4     Michel  103
</code></pre>

<p>Repeated</p>

<pre><code>      id   name     number
      1    Shan     101
      2    Shan     101
</code></pre>