How to get full result using DataFrame.Display method

[ratnakarsinha]

Hi,

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?

Thanks,

Ratnakar.

[shyam_9]

Hi @ratnakarsinha,

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.

[ratnakarsinha]

Hi @shyamspr, found that you can use dataframe.show instead. But there is no download option for dataframe.show method.

[ramravi]

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.