Query split best python workflow

Query split python workflow.py

# join the items and reviews

result_df = mdsql.query( """ 
  SELECT 
    category, 
    sentiment, 
    sentiment_polarity 
  FROM gstore_apps_df INNER JOIN gstore_reviews_df 
  ON gstore_apps_df.app = gstore_reviews_df.app """, 
  gstore_apps_df = gstore_apps_df, 
  gstore_reviews_df = gstore_reviews_df )

# group by category and calculate averages

result_df = mdsql.query( """
  SELECT 
    category, 
    avg(sentiment_polarity) as avg_sentiment_polarity, 
    avg(sentiment_subjectivity) as avg_sentiment_subjectivity 
  GROUP BY category
  HAVING CAST(avg_sentiment_subjectivity as float) < 0.5
  ORDER BY avg_sentiment_polarity DESC
  LIMIT 10""", 
  from= result_df)