Top "Pivot-table" questions

How is a pivot table created by Laravel?

In Laravel 4, when working with many-to-many relationships as described in the 4.2 docs, how can I actually get Laravel to create …

laravel pivot-table laravel-4 eloquent

Pandas Pivot Table List of Aggfunc

Pandas Pivot Table Dictionary of Agg function I am trying to calculate 3 aggregative functions during pivoting: Count Mean StDev This …

python pandas pivot-table

How can I use VBA to add a Connection (to an External Data Source) in Excel and Save it to that Excel spreadsheet's list of Connections

I can use VBA to create a new ADODB.Connection and associated ADODB.Command and ADOBD.Parameter and then create …

excel vba pivot-table

SQL - Pivot table and group by not working

I have a table as follows: Product #users Date Count Type prodA 29 2013-02-27 113 Document prodA 31 2013-03-02 152 Extraction prodB 17 2013…

sql sql-server-2008 pivot pivot-table

Pandas 'DataFrame' object has no attribute 'unique'

I'm working in pandas doing pivot tables and when doing the groupby (to count distinct observations) aggfunc={"person":{lambda x: …

python pandas pivot-table

Pandas pivot_table, sort values by columns

I am a new user to Pandas and I love it! I am trying to create a pivot table in …

python pandas indexing pivot-table

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'column_name' in Laravel

Larael Multiple Data Insert Error SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'unit_id' at row 2 (SQL: …

php mysql laravel pivot-table laravel-5.3

Pivot data using LINQ

I have a collection of items that contain an Enum (TypeCode) and a User object, and I need to flatten …

c# linq pivot-table

Obsolete items in pivot table list

In a pivot table of mine, when I go to filter the data using the Row Label, where it shows …

excel pivot-table

pandas pivot_table column names

For a dataframe like this: d = {'id': [1,1,1,2,2], 'Month':[1,2,3,1,3],'Value':[12,23,15,45,34], 'Cost':[124,214,1234,1324,234]} df = pd.DataFrame(d) Cost Month Value id 0 124 1 12 1 1 214 2 23 1 2 1234 3 15 1 3 1324 1 45 2 4 234 3 34 2 to which …

python pandas pivot-table reshape