How is a Pandas crosstab different from a Pandas pivot_table?

pandas numpy scipy pivot-table crosstab
user1008537 picture user1008537 · Mar 28, 2016 · Viewed 11.4k times · Source

Both the pandas.crosstab and the Pandas pivot table seem to provide the exact same functionality. Are there any differences?

Answer

root picture root · Mar 28, 2016

The main difference between the two is the pivot_table expects your input data to already be a DataFrame; you pass a DataFrame to pivot_table and specify the index/columns/values by passing the column names as strings. With cross_tab, you don't necessarily need to have a DataFrame going in, as you just pass array-like objects for index/columns/values.

Looking at the source code for crosstab, it essentially takes the array-like objects you pass, creates a DataFrame, then calls pivot_table as appropriate.

In general, use pivot_table if you already have a DataFrame, so you don't have the additional overhead of creating the same DataFrame again. If you're starting from array-like objects and are only concerned with the pivoted data, use crosstab. In most cases, I don't think it will really make a difference which function you decide to use.

Related questions

dropping infinite values from dataframes in pandas?

what is the quickest/simplest way to drop nan and inf/-inf values from a pandas DataFrame without resetting mode.use_inf_as_null? I'd like to be able to use the subset and how arguments of dropna, except with …

Read More
What are the differences between Pandas and NumPy+SciPy in Python?

They both seem exceedingly similar and I'm curious as to which package would be more beneficial for financial data analysis.

Read More
TypeError: cannot unpack non-iterable int objec

how can I solve this error After running my code as follows . I am using the function below and implementin running window for loop on it but end up getting the error below. The for loop works and hungs at …

Read More