title: How to display pivoted dataframe with PySark, Pyspark?
body: <p>I cannot display/show/print a pivoted dataframe with PySpark. Although the dataframe seems to have been pivoted, when I try to use show() on it, it says <code>AttributeError: 'GroupedData' object has no attribute 'show'</code>.  </p>
  
  <p>Here's the code  </p>
  
  <pre class="lang-py prettyprint-override"><code>meterdata = sqlContext.read.format("com.databricks.spark.csv").option("delimiter", ",").option("header", "false").load("/CBIES/meters/")
  
  metercols = meterdata.groupBy("C0").pivot("C1")
  metercols.show()  
  
  
  Output:  Traceback (most recent call last): File "/tmp/zeppelin_pyspark-8003809301447367155.py", line 239, in eval(compiledCode) File " ", line 1, in AttributeError: 'GroupedData' object has no attribute 'show'
  </code></pre>