title: How to create two columns from a single column in a dataframe using pyspark
body: <p>I have a transform a dataframe which look like this</p>
  
  <pre><code>+---------+------+
  |  Country|Status|
  +---------+------+
  |[AW,null]|    14|
  |[UG,null]|    47|
  |[CY,null]|  1324|
  |[AO,null]|    20|
  |[US,null]|325242|
  |[KE,null]|   246|
  |[DK,true]|     1|
  |[ES,null]|  2127|
  |[IT,true]|     2|
  +----------------+
  </code></pre>
  
  <p>Now I have to transform it into a dataframe which consist of three columns and looks something like this </p>
  
  <pre><code>+---------+--------+------+
  |  Country|status  |Count |
  +---------+--------+------+
  |AW       |null    |    14|
  |UG       |null    |    47|
  |CY       |null    |  1324|
  |AO       |null    |    20|
  |US       |null    |325242|
  |KE       |null    |   246|
  |DK       |true    |     1|
  |ES       |null    |  2127|
  |IT       |true    |     2|
  +---------+-------+-------+
  </code></pre>