Skip to main content
`Ctrl`+`K`

# pandas.DataFrame.sparse.to_dense

DataFrame.sparse.to_dense()

  Convert a DataFrame with sparse values to dense.

  This method converts all SparseArray columns in the DataFrame to regular NumPy arrays.

  Returns:
    DataFrame

      A DataFrame with the same values stored as dense arrays.

  See also

  `DataFrame.sparse.density`

    Ratio of non-sparse points to total (dense) data points.

  Examples

      >>> df = pd.DataFrame({"A": pd.arrays.SparseArray([0, 1, 0])})
      >>> df.sparse.to_dense()
         A
      0  0
      1  1
      2  0