3,403 questions
3
votes
0
answers
150
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 ...
- 715
3
votes
1
answer
95
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 ...
- 33
0
votes
0
answers
56
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 ...
- 1
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
38
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
-1
votes
1
answer
168
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 ...
- 9
0
votes
2
answers
109
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 ...
-2
votes
2
answers
60
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 ...
- 2,129
0
votes
3
answers
87
views
Excel VBA to transpose a sets of rows to columns. Each set of rows may not be of the same size
I have a example table with 3 columns (Sample, Index, Value). In this example, there are 12 samples, 3 possible Index and for each of them a Value. I would like to transpose to columns the Value by ...
0
votes
1
answer
102
views
SQL: Data Transpose
I have a SQL script that outputs this:
timestamp
tagname
value
12/19/2024 15:00:57
RUNNING
0
12/19/2024 15:00:55
RUNNING
1
12/19/2024 14:53:38
RUNNING
0
12/19/2024 14:53:35
RUNNING
1
12/19/2024 14:53:...
- 89
1
vote
3
answers
124
views
SAS Proc transpose wide to long multiple variables
I had some data with a long text string that contained data with certain dates within them. I parsed out each individual text section and the corresponding date into different columns. Each ID will ...
- 101
2
votes
2
answers
202
views
How to create a SQL view to transpose data using two tables
I need to find a way to create a SQL view that allows me to transpose some data that in one table a particular column contains the column names from another table.
Table: FormControl:
FormType
...
0
votes
1
answer
99
views
Why are sequential reads faster than sequential writes?
I have a matrix transposing code like this:
for (size_t ii = 0; ii < ii_end; ii+=TILE_SIZE) {
for (size_t jj = 0; jj < jj_end; jj+=TILE_SIZE) {
for (size_t i = 0; i < TILE_SIZE; i+...
- 2,698
0
votes
1
answer
149
views
How to transpose in SAS EG when there are multiple columns of differing data types (numeric, alphanumeric, & character)?
I have a dataset that is approximately 30,000 rows & approximately 30 columns, consisting of:
1 column is a unique identifier (SSN)
6 columns are of diagnostic ICD codes
6 columns are of ...
- 3
-1
votes
1
answer
68
views
Transposing only comma separated values from an array in google sheet
I have a database with references in column V. Some cells have single value, like 0001, others have several comma separated values, like 0001, 0002, 0003. I am trying to retrieve this data to a single ...
- 13
0
votes
2
answers
72
views
transpose a table with multiple values in excel [duplicate]
I have a table that has ID and Description. One ID can have multiple rows of Description. I would like to change the format to a table where there will be 1 unique row for each ID and multiple columns ...
- 41
0
votes
2
answers
48
views
Transposing row-like data in DB table
I have a table where I store data of some parameters which are read step-wise. The number of parameters to be read can vary from use-case to use-case. The dataset of one step can be identified by its ...
- 1,193
0
votes
2
answers
74
views
Transpose a column in pandas DataFrame [duplicate]
I have a below dataframe, I'm trying to transpose the data based on the column Place. For each list of value in Place column, I need to generate a each row.
Language Capital Place
Tamil ...
- 5,251
0
votes
1
answer
60
views
How do I transpose a dataframe properly in R [duplicate]
I am struggling with what I hope is a fairly basic problem in transposing a dataframe.
My dataframe has a structure like this:
Measure = c("Heightpercentile", "Weightpercentile", &...
- 11
0
votes
1
answer
30
views
Query, unique and transpose issues on Gsheets
I have an issue I cannot figure out how to fix.
I have 2 columns, one with names and one with homework done.
Names
Homework
Person 1
Homework 1
Person 1
Homework 2
Person 1
Homework 3
Person 2
...
- 73
0
votes
2
answers
58
views
Transforming Categorical Column into Binary Columns in R Based on Multiple Conditions
I have a dataframe with two columns in R. One of the columns (column1) has three possible values (A, A and B, B).
The rows are patients.
I want to transpose column1, so I'd have binary columns (Yes, ...
- 105
0
votes
2
answers
65
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
0
answers
223
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
vote
1
answer
46
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 ...
- 41
0
votes
2
answers
108
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