Pandas Pivot To Sparse Code Example

Snippet 1
  from scipy.sparse import csr_matrix
from pandas.api.types import CategoricalDtype

person_c = CategoricalDtype(sorted(frame.person.unique()), ordered=True)
thing_c = CategoricalDtype(sorted(frame.thing.unique()), ordered=True)

row = frame.person.astype(person_c).cat.codes
col = frame.thing.astype(thing_c).cat.codes
sparse_matrix = csr_matrix((frame["count"], (row, col)), \
                           shape=(person_c.categories.size, thing_c.categories.size))

>>> sparse_matrix
<3x4 sparse matrix of type ''
     with 6 stored elements in Compressed Sparse Row format>

>>> sparse_matrix.todense()
matrix([[0, 1, 0, 1],
        [1, 0, 0, 1],
        [1, 0, 1, 0]], dtype=int64)


dfs = pd.SparseDataFrame(sparse_matrix, \
                         index=person_c.categories, \
                         columns=thing_c.categories, \
                         default_fill_value=0)
>>> dfs
        a   b   c   d
 him    0   1   0   1
  me    1   0   0   1
 you    1   0   1   0
 

Similar Snippets


Pandas Count Rows With Value Code Example - pandas

Add An Index Column Pandas Code Example - pandas

Pandas Ttable With Sum Totals Code Example - pandas

Remove 1st Column Pandas Code Example - pandas

Pandas Iterrows Code Example - pandas

Slicing In Pandas Code Example - pandas

Convert Pandas Data Frame To Latex File Code Example - pandas

Append New Data On Pandas Dataframe Code Example - pandas

Getting Dummies And Input Them To Pandas Dataframe Code Example - pandas

Pandas Dataframe Froms String Code Example - pandas

Combine Two Dataframe In Pandas Code Example - pandas

Str_Count On Pandas Series Code Example - pandas

Rename Row Pandas Code Example - pandas

Dictionary To A Dataframe Pandas Arrays Must All Be Same Length Code Example - pandas

How To Drop Columns In Pandas Code Example - pandas

Pandas Select All Columns Except One Code Example - pandas

How To Change Column Name In Pandas Code Example - pandas

Creating A Pandas Df Code Example - pandas

Pandas Read From Website Code Example - pandas

Pandas Show Top 10 Rows Code Example - pandas

Index Max Pandas Code Example - pandas

Pandas Cumulative Sum Column Code Example - pandas

Onehot Encode List Of Columns Pandas Code Example - pandas

How To Set Pandas Dataframe As Global Code Example - pandas

Pandas Merge Two Columns From Different Dataframes Code Example - pandas

Pandas Frame Convert String Code Example - pandas

How To Merge Two Column Pandas Code Example - pandas

Pandas Read Excel With Two Headers Code Example - pandas

Reshape Wide To Long In Pandas Code Example - pandas