https://community.databricks.com/t5/data-engineering/how-to-get-full-result-using-dataframe-display-method/m-p/27232#M19112 <P>display method doesn't have the option to choose the number of rows. Use the show method. It is not neat and you can't do visualizations and downloads.</P> Thu, 22 Dec 2022 09:14:07 GMT ramravi 2022-12-22T09:14:07Z https://community.databricks.com/t5/data-engineering/how-to-get-full-result-using-dataframe-display-method/m-p/27229#M19109 <P></P> <P>Hi,</P> <P>Dataframe.Display method in Databricks notebook fetches only 1000 rows by default. Is there a way to change this default to display and download full result (more than 1000 rows) in python?</P> <P>Thanks,</P> <P>Ratnakar.</P> <P></P> Mon, 06 Apr 2020 11:36:28 GMT https://community.databricks.com/t5/data-engineering/how-to-get-full-result-using-dataframe-display-method/m-p/27229#M19109 ratnakarsinha 2020-04-06T11:36:28Z https://community.databricks.com/t5/data-engineering/how-to-get-full-result-using-dataframe-display-method/m-p/27230#M19110 <P></P><P>Hi <A href="https://forums.databricks.com/users/41031/ratnakarsinha.html" target="_blank">@ratnakarsinha</A>,</P><P>There is a limit in Databricks, not to load too much data because the computation is done on your browser and could crash Chrome / Firefox.</P> Wed, 15 Apr 2020 18:26:46 GMT https://community.databricks.com/t5/data-engineering/how-to-get-full-result-using-dataframe-display-method/m-p/27230#M19110 shyam_9 2020-04-15T18:26:46Z https://community.databricks.com/t5/data-engineering/how-to-get-full-result-using-dataframe-display-method/m-p/27231#M19111 <P></P> <P>Hi <A href="https://users/30753/shyamspr.html" target="_blank">@shyamspr</A>, found that you can use dataframe.show instead. But there is no download option for dataframe.show method.</P> <P></P> Thu, 16 Apr 2020 08:34:58 GMT https://community.databricks.com/t5/data-engineering/how-to-get-full-result-using-dataframe-display-method/m-p/27231#M19111 ratnakarsinha 2020-04-16T08:34:58Z https://community.databricks.com/t5/data-engineering/how-to-get-full-result-using-dataframe-display-method/m-p/27232#M19112 <P>display method doesn't have the option to choose the number of rows. Use the show method. It is not neat and you can't do visualizations and downloads.</P> Thu, 22 Dec 2022 09:14:07 GMT https://community.databricks.com/t5/data-engineering/how-to-get-full-result-using-dataframe-display-method/m-p/27232#M19112 ramravi 2022-12-22T09:14:07Z