Top "Pivot" questions

Sql PIVOT and string concatenation aggregate

I would like to use a pivot SQL query to construct a result table where the concatenate text as a …

sql tsql pivot reporting-services reportbuilder3.0

how to unstack (or pivot?) in pandas

I have a dataframe that looks like the following: import pandas as pd datelisttemp = pd.date_range('1/1/2014', periods=3, …

python pandas stack pivot

Opposite of melt in python pandas

I cannot figure out how to do "reverse melt" using Pandas in python. This is my starting data import pandas …

python pandas pivot reshape melt

Mysql query to dynamically convert rows to columns on the basis of two columns

I have followed a question here to use a Mysql query to dynamically convert rows to columns. This works fine, …

mysql sql pivot pivot-table

Change column name while using PIVOT SQL Server 2008

SELECT * FROM EmployeeAttributes PIVOT ( MAX(VALUE) FOR AttributeID IN ([DD14C4C2-FC9E-4A2E-9B96-C6A20A169…

sql-server-2008 pivot

PIVOT with varchar datatype

I´m trying to PIVOT some data in a table, but I cannot do it because I do not find …

sql sql-server-2008 pivot

Dynamic Pivot Columns in SQL Server

I have a table named Property with following columns in SQL Server: Id Name there are some property in this …

sql sql-server tsql pivot pivot-table

Pandas: Difference between pivot and pivot_table. Why is only pivot_table working?

I have the following dataframe. df.head(30) struct_id resNum score_type_name score_value 0 4294967297 1 omega 0.064840 1 4294967297 1 fa_dun 2.185618 2 4294967297 1 fa_dun_…

python pandas pivot

Pivot multiple columns based on one column in SQL Server

I have the following source and destination tables in SQL Server 2008R2. How can I do pivot(s) in TSQL …

sql-server tsql pivot transpose

Pivot for redshift database

I know this question has been asked before but any of the answers were not able to help me to …

sql pivot amazon-redshift