title: Using Dataframe instead of spark sql for data analysis
body: <p>Below is the sample spark sql I wrote to get the count of male and female enrolled in an agency.I used sql to generate the output,
  Is there a way to do similar thing using dataframe only  not sql.</p>
  
  <pre><code>val districtWiseGenderCountDF = hiveContext.sql("""
                                                     | SELECT District, 
                                                     |        count(CASE WHEN Gender='M' THEN 1 END) as male_count, 
                                                     |        count(CASE WHEN Gender='F' THEN 1 END) as FEMALE_count 
                                                     | FROM agency_enrollment 
                                                     | GROUP BY District
                                                     | ORDER BY male_count DESC, FEMALE_count DESC
                                                     | LIMIT 10""".stripMargin)
  </code></pre>