pandas.DataFrame.sparse.to_dense#

DataFrame.sparse.to_dense()[source]#

Convert a DataFrame with sparse values to dense.

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