Questions tagged [pivot]
The PIVOT syntax converts row data into columnar data, and vice versa for the UNPIVOT syntax. The syntax is non-standard, and not all databases support the PIVOT syntax, but the functionality can be implemented, often using decision logic (CASE expressions, etc) and aggregate functions.
pivot
11,586
questions
0
votes
0
answers
19
views
unpivot and pivot conversion from sql server to postgres
I am trying to perforrm conversion from sqlserver script to postgres
postgres not supporting format,unpivot and pivot function is there any alternate method to convert these to postgres
select [values]...
0
votes
1
answer
35
views
Filament V3 belongstomany with pivot attribute to fill
first i am usign filament form builder not panel.
my question :
please , i have manytomany relation ships in filament , and whene i save the form every things work very well the main model and these ...
0
votes
5
answers
54
views
How to transpose subset of columns into rows and group by remainder of rows? Excel? SQL?
We are in the early stages of migrating some data from a legacy system to a new system that seems to have some quirks.
Currently we have some data that is as follows
Name Date Award
Roger ...
0
votes
0
answers
35
views
Dependent Pivot Drop Downs
I am hoping someone can help. My search thus far has yielded no results, and I refuse to think this hasn't been released yet.
I have a Pivot of an extremely large set of data. In the filters is a ...
0
votes
0
answers
46
views
Row to column conversion in SQL - Dynamic rows [duplicate]
I am trying to convert the rows into column. However, the number of rows/ names are not predictable. it varies each time when I ran it based on my condition. Is there an easy way to pull that info.
...
0
votes
1
answer
16
views
Pivot multiple values to columns
This question may have been answeered, but I can't seem to find the right keywords to search.
current df:
index
time
value
type
test
0
0.00
0.112
A
test1
1
0.01
0.113
A
test1
0
0.00
0.112
A
test2
...
-1
votes
2
answers
56
views
Need help in Pivot table or Formatting the data
I have a scenario where I have the list of promotions by each job level by Month. In December, the promotion receivership % is 6.6% and in June 2.5% however when I include both I was expecting 9.1%. ...
0
votes
2
answers
59
views
How to unpivot a Pandas dataframe on two ID fields with multiple sets of columns
I have a pandas Dataframe that looks like this:
pid
fid
FirstReasonName
FirstReasonValue
SecondReasonName
SecondReasonValue
1
'x'
'a'
3
'b'
8.2
2
'y'
'c'
8
'd'
7
Now I want to unpivot it on pid ...
-1
votes
1
answer
27
views
Finding offending entries when pivot fails with a ValueError: Index contains duplicate entries, cannot reshape
I have a dataframe with 3 columns and datatypes: Datetime (Datetime dtype), Area (string), Value (float).
I want to pivot it so I get separate columns for each unique entry in Area.
df_pivot = pd....
1
vote
1
answer
36
views
Pandas multilevel Pivot/Transpose
I've looked thru countless examples, but I cannot figure out how to do the below.
Any tips would be greatly appreciated
Original df (note the multilevel)
Gender A B
sum ...
0
votes
1
answer
35
views
How to PIVOT data in snowflake by using ANY without having quotes for 'Column_Names'
How to PIVOT data in snowflake by using ANY without having quotes for 'Column_Names'.
CREATE OR REPLACE TEMPORARY TABLE quarterly_sales(
empid INT,
amount INT,
quarter TEXT)
AS SELECT * FROM ...
0
votes
2
answers
34
views
Google Sheets lambda or match() function?
I'm struggling with formula.. I want to sum in column K, when code in column H match code in column J. I thought I'd try a pivot table, but again something didn't work properly..?
Google Sheet example
...
0
votes
0
answers
16
views
pandas pivot multiple columns
I want this but got that
I want to transfer 2 columns at the same time, but they are directly flattened. How can I make multiple columns appear directly on the row?
import pandas as pd
ll = [
[&...
-1
votes
0
answers
13
views
Pivot filter : How to get the drop-down on the first element of Row in pivot table:
I received an excel file with five elements in pivot table
Geo, Country, Partner Name, Persona, and End Date
However, I am unable to apply filter on Country, Partner Name, Persona, and End Date as the ...
0
votes
0
answers
31
views
Access 2016 - Change multiple rows of PC numbers into columns against UserID [duplicate]
I am trying to sort a list of Users and the PCs they use.
Currently it is in the format:
User
PC
AA1
123
AA1
124
AA1
125
BB1
126
CC1
127
CC1
128
But I want it more like:
User
PC1
PC2
PC3
AA1
...