Questions tagged [transpose]
Transposition is an operation that applies to matrices wherein the rows and columns are swapped
transpose
3,343
questions
0
votes
2
answers
35
views
Transpose data in SQL with NULL values
I have a table with 6 columns like below
ID
VAL1
VAL2
VAL3
VAL4
VAL5
1234
AB
CD
NULL
DF
NULL
5678
HJ
NULL
UI
NULL
NULL
The expected results are like below. I want to transpose the data like below. ...
- 33
0
votes
1
answer
18
views
Transform Long Data to Table
If I have a data like this:
Column A
1
2
3
4
5
6
7
8
What formula should I use if I want it to look like this in spreadsheet?
Column A
Column B
Column C
1
2
3
4
5
6
7
8
Thank you!
I ...
- 1
-2
votes
0
answers
25
views
Why is the transpose operation commonly used to change the view of data rather than operating in memory? [closed]
Why is the transpose operation commonly used to change the view of data rather than operating in memory?
Changing the data view will obviously bring about the problem of no longer needing to copy the ...
0
votes
0
answers
17
views
How to transpose an excel file using Power Automate?
So, this is the format my file is in right now -
And this is how I want this to be -
I am using the website version and am new to Power Automate. I tried to make a flow but I don't know how to ...
- 45
-1
votes
1
answer
46
views
Python Pandas Transpose
I want to transpose the dataset below based on the Doc. # column which is a key number for each respective field name and reformat to be horizontal with respective New/Old value columns.The original ...
- 1
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 ...
- 21
0
votes
2
answers
44
views
Transpose Excel data for multi-Stacked bar chart
I am looking for a way to automatically transpose data from columns to rows based on merged cells. I have attached an example of what I imagine the result should look like.
I tried adding this data to ...
- 77
1
vote
3
answers
58
views
Equivalence between reshape, strides and transpose? (numpy)
i am sorry for the very naive question.
I have these lines of numpy code, with a transpose at the beginning, and strides and reshape are used afterward.
I wonder if by re-ordering indices in reshape ...
- 939
0
votes
0
answers
20
views
Mysql rows transposing in Node.js with mysql2 [duplicate]
I am running an SQL script in Node.js using mysql2 npm-package. This script has multiple SQL statements that have to ultimately transpose a table's rows into columns. The SQL script runs correctly ...
- 1
0
votes
0
answers
45
views
Excel VBA transpose/filter to other sheet
I'm trying to automate the sets of data. So far I have this code that filters the data to another sheet but I cannot figure out how to transpose the data vertically. I've tried adding Transpose:=True ...
- 1
1
vote
1
answer
32
views
PySpark DenseMatrix (from mllin.linalg) transpose
Hi I am trying to take a transpose of a DenseMatrix and multiply it to a RowMatrix.
I have a DenseMatrix = V and RowMatrix = U.
I have tried to implement the below function to create a transpose
def ...
- 145
-2
votes
1
answer
111
views
CUDA more load transactions than store even though both are coalesced?
I am profiling the NVIDIA's matrix transpose sample. From the looks of it and from the profiler, there are no bank conflicts. However, one thing I noticed is that global load transactions per request ...
- 27
1
vote
0
answers
34
views
CUDA matrix transpose with shared mem
I am trying to incrementally optimize matrix transpose operation on CUDA and gain some hands on experience. I have tried a few things but the timing measurements that I am getting do not make sense. ...
- 27
0
votes
1
answer
33
views
big query data transformation logic
I am trying to get a data in a specified format, currently this is in the form.
I want to write a sql query which would get me the data in this form
I tried with converting it to array and unnest ...
0
votes
1
answer
39
views
Converting / transposing a crosstab of nominal variables to a dataframe with single cases in r
I have a cross table saved in Excel with information about employees and how many times they were on a given shift.
> my_data
...1 night day
1 jeff 2 3
2 stan 3 2
3 annie 1 4
...
- 289