cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How to get full result using DataFrame.Display method

ratnakarsinha
New Contributor II

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.

3 REPLIES 3

shyam_9
Valued Contributor

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.

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

ramravi
Contributor II

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.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group