3,403 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
3
votes
0
answers
164
views
The cost of non contiguous reads and writes (naive matrix transpose, power-of-2 and other sizes)
I was benchmarking a naive transposition and noticed a very large performance discrepancy in performance between:
a naive operation where we read data contiguously and write with a large stride;
the ...
0
votes
1
answer
62
views
Rows disappear when transposing DT in R Shiny
I've attached a reproducible R Shiny app to show the problem I'm having. Once you click "Show tables", you can see the DT with my own data on the left and a DT with mtcars on the right as a ...
3
votes
1
answer
99
views
Changing a variable outside a function in python (transposing a matrix)
I'm trying to transpose a matrix in Python. The function should change the original variable. When I've looked up similar problems, they talk about editing the variable 'in place', but when I tried ...
-1
votes
1
answer
49
views
How to transpose character data?
I'm trying to transpose in Databricks, when used to PROC SQL in SAS.
This is the data table I am trying to transpose.
And I am wanting to get a simple transpose
I am not sure where to start... Seems ...
0
votes
0
answers
62
views
Python script to loop through column to select specific cell ranges and paste special transpose on next sheet
I am new to scripting and get the basic ideas of looping and the such. I want to loop through a column of a worksheet selection specific cell ranges and paste special transpose on the next sheet.
I ...
0
votes
0
answers
12
views
Transpose Data Based on Certain Category And Writing Over Same Data
I have the initial data and query like this:
Testing Data
With query, is it possible to make data like in the picture?
This is the data link:
https://docs.google.com/spreadsheets/d/e/2PACX-...
0
votes
1
answer
41
views
Way to transpose a Pandas DataFraa repeated blocks of 4 rows with values in the same column, with dupes [duplicate]
I am trying to transpose 2 columns into 4 rows, but it's been extremely tricky as there is duplicate lines, making pivoting difficult.
What I have is this data as df:
Device Serial Property ...
0
votes
0
answers
31
views
Transpose several columns into one and groupby several columns
I have a dataset which contains two time stamps and several data columns. My aim is to put anything in three columns: two time columns and one data column which results having several rows of ...
0
votes
0
answers
47
views
Transpose rows to columns in Crystal Reports
I'm new to crystal reports 2020 and need help with getting some data from rows into columns. The report will be exported into excel. Here is an example of the data right out of the table.
ActionID ...
1
vote
1
answer
108
views
How to efficiently multiply a vector by a transposed sparse matrix in Eigen?
I have with a sparse matrix A and a vector x in Eigen, and I need to perform the following transposed matrix ×ばつ matrix ×ばつ vector operation: ATAx. This can be decomposed into two matrix-vector ...
-1
votes
1
answer
189
views
Mainframe Sort JCL - transpose the rows to column
I have the following input:
.TY records can vary from 1 to 30 times
I tried with build & PUSH in sort but i couldn't get the expected below output
I need to get it using SORT not COBOL.
The BEGIN ...
0
votes
1
answer
65
views
Cell conditioning based on cell value on a row to cell value on column
Above is the cell values I want to apply the condition too.
A solution that works is to create a new column using the transpose function for the row in Question is to use the cell = cell.
I dont want ...
0
votes
2
answers
124
views
Excel. How to get an one row data (multiple columns) from every three rows
Please need your help.
I have an excel file with this following structure, that one row is divided into the next two rows:
initial
And need finally get this one. Every third row need to be combined ...
0
votes
4
answers
140
views
Reformat data so repeating value is column header and data is row
I have a column with values that repeat and need the unique values to be column headers. Then, I need to add the associated data as a row. I have 20k of these rows and cannot figure out how to ...
-2
votes
2
answers
62
views
Edit row and column names in a transposed data frame
I have a dataframe that I have successfully transposed using the t function present in base R. However I'd like to change the column names and row names to be part of the dataframe. I'll use the iris ...