title: Getting Dataframe from existing Dataframe after some filter
body: <p>I have a Data frame something like this.</p>
  
  <pre><code>Aman Aggarwal      Amar Jannela   Vipin Kumar       Roshan Pati
  BlackBuck          DJ CHETAS      WOW Editions      MensXP
  Transport/Freight  Musician/Band  Furniture         News/Media Website
  Like               Like           Like              Like
  NaN                NaN            NaN               NaN   
  GiveMeSport        NaN            500 Startups      No Abuse KG
  News/Media Website Celina Jaitly  Internet/Software Community
  Like               Actor/Director Like              Liked
  NaN                Like           NaN               NaN
  NaN                NaN            Jitendra Kumar    Monogatari Series
  Anushka Sharma     Durjoy Datta   Actor/Director    TV Show
  Actor/Director     Author         Liked             Like
  Like               Like           NaN               NaN
  NaN                NaN            NaN               NaN
  </code></pre>
  
  <p>Obviously NaN are empty rows in original csv file. I have to extract two data frames from this.Column name as first element of every row in new datafra and page_name(BlackBuck) element of that column as further element of respective rows. Something like this.</p>
  
  <pre><code>Aman Aggarwal     BlackBuck        GiveMeSport    Anushka Sharma 
  Amar Jannela      DJ CHETAS        Celina Jaitly  Durjoy Datta 
  Vipin Kumar       WOW Editions     500 Startups   Jitendra Kumar
  Roshan Pati       MensXP           No Abuse KGP   Monogatari Series
  </code></pre>
  
  <p>2nd dataframe also similar like this </p>
  
  <pre><code>Aman Aggarwal   Transport/Freight  News/Media Website  Actor/Director
  Amar Jannela       Musician/Band      Actor/Director          Author
  Vipin Kumar           Furniture   Internet/Software  Actor/Director
  Roshan Pati  News/Media Website           Community         TV Show
  </code></pre>
  
  <p>The real issue is that there is arbitrary NaN values some where ank may be like/liked too but only thing is that name(BlackBuck) and category(Transport/Freight) are together.Since my coe cant identify which is page_name and which is category. So probably I have to remove NaN value and 'Like' and 'Liked'  separately for each column first and then aligned accordingly and transpose. How to this efficiently in python2.7.  </p>